Ujjwal Gupta

Company Overview: Pyxis by Bain & Company helps B2C companies understand their business by using a combination of alternative data and Bain's proprietary insights. They leverage a wide array of alternative data sources to provide actionable insights on market share, customer loyalty, and other key metrics.

• Ensured data quality across 10 billion SKUs and 10 datasets by implementing automated rule sets and refining manual tagging workflows.
• Developed one-click Python automation scripts for monthly data refreshes, detecting YoY and MoM growth discrepancies, to minimize human error, and ensure zero-defect data delivery.
• Designed and implemented data-driven estimation and extrapolation methodologies to deliver precise, actionable market insights. Custom analytics for Bain's front-end consulting, leveraging big-data analytics using Snowflake. Generated reports and obtained data to develop analytics on key performance and operational metrics.
• Saved 40 hours per week for the team by introducing an end-to-end automated QA process for the front end.
• Leading a team of four analysts to execute all Business-As-Usual (BAU) client delivery processes, ETL, and QA.
• Involved in JIRA-based project management and resource planning across projects for a team of four analysts.
• Developed and maintained 30 reports on the Tableau server, with more than a billion records.
• Worked with the product team to improve the performance and quality of reports delivered to over four clients by promoting the development of 50 Alteryx workflows.
• Fast-track promotion to Associate in April 2024, with a top rating and an upward career trajectory consistently for two fiscal years.
• Trained and onboarded four new members in the team, despite being relatively new, showcasing people skills.
• Represented the Data Ops team in client communication strategies, delivering data-driven insights to case work teams.
• Evaluated post-COVID effects on share of wallet for accessing online mode user journey.
• Chosen as the youngest member of the team to handle the offshore client CEOs' office because of end-to-end knowledge.

• Company Overview: Internship focused on data-driven decision making
• Developed two new lead generation plans in the North India segment
• Successfully implemented the plans in the Delhi area
• Internship focused on data-driven decision making