Experience:
• Interned in the Demand Side Platform team, providing functionalities for advertisers to create, edit, and update ad campaigns in bulk.
• Addressed a critical issue where the Microsoft Excel workbook template used for storing ad campaigns exceeded the cell limit of 32k characters, causing the process to crash.
• Developed a dynamic workbook generation solution by diving deep into the codebase and identifying the areas for modification.
• Replaced the static workbook generation code with a dynamic approach that validated columns, their contents, and calculated the required number of columns based on each customer's request.
• Resulted in customizable workbooks for each customer, enabling them to include only the fields they desired.
• Successfully delivered all project milestones and met the assigned deliverables.
Skills Demonstrated:
• Problem-solving: Addressed the cell limit overflow issue by developing a dynamic workbook generation solution, ensuring smooth operation and enhanced usability.
• Technical proficiency: Leveraged Microsoft Excel, Java, and codebase exploration to identify and modify the necessary sections for workbook generation.
• Adaptability: Successfully worked with a large-scale codebase, navigating through unfamiliar territory to implement necessary changes.
• Customer focus: Developed an understanding of customer requirements and the impact of software solutions on their experience, highlighting the importance of meeting their needs.
Quantifiable Impact:
• Eliminated the need for manual intervention and static template modifications when encountering cell limit overflows in the Excel workbook.
• Increased customer satisfaction by allowing them to customize their workbooks and include only the desired fields.
• Improved efficiency by automating workbook generation, saving time and effort for both the team and customers.