Feb 2024 – Jul 2025 · 1 yr 5 mos · Bengaluru, Karnataka, India

• I have worked with Last Mile and Category team. Below are some of the analyses & projects I have worked on -
• 1) Delivery Time Optimization - Identified inefficiencies across all stages of the delivery process and optimized key metrics such as Handshake (HS) time, Direct Handover (DH), and Last to Last Mile (LLM) time, resulting in a 17% reduction in overall delivery time through detailed analysis.
• 2) Order Loss Reduction - Assessed the impact of high estimated delivery times (ETAs) and store unserviceability on order loss, developed actionable insights through dashboards on Mixpanel and Google sheets, that enabled the team to optimize resource planning and reduce order loss by 1%.
• 3) Shift to Slot Transition - Enabled the team to monitor key success metrics with the help of Python and SQL in Superset, ensuring a seamless transition from the Shift model to the Slot model and ensuring alignment with operational goals.
• 4) RTO Orders Reduction- Reduced RTO (Return to Origin) orders from 2% to 1% by analyzing
• rider and customer behavior patterns and implementing system constraints to address identified issues.
• 5) Stakeholder Collaboration - Worked closely with business, product, engineering, and senior leadership teams to define and implement business targets for optimizing last mile strategies.
• 6) Led Last Mile Analytics - Managed end-to-end analytics for Zepto’s Last Mile operations, leading a team of two analysts.
• 7) Improved Assortment and Pricing - Assisted in building better assortment and strategic pricing for the beverages category consisting of 1000+ SKUs by tracking sell-side KPIs.

Feb 2022 – Feb 2024 · 2 yrs · Pune, Maharashtra, India · Hybrid

• I have worked with a leading U.S. pharmaceutical company, ranked among the top 10 by revenue, on below analyses and projects-
• 1) Strategic Recommendations - Proposed business recommendations and insights for US-based clients, impacting a ~$2 billion product portfolio in 2022.
• 2) Market Assessments - Strategized on product competitor threat assessment and market opportunity assessments to help stakeholders make better investment decisions, resulting in a ~15% portfolio performance increase.
• 3) Sales Force Effectiveness and Sizing - Assessed the effectiveness of the sales force through its promotional tactics and determined the optimal Sales force size required for efficient drug promotion.
• 4) Key Analysis - Performed analyses such as market share analysis, segmentation, targeted account performance, and switch analysis, identifying improvement areas and driving a ~10% sales increase.
• 5) KPI Dashboards Development - Built multiple dashboards to track key performance indicators (KPIs) for Lytics and CF product portfolio using Tableau, Python, and Google Sheets.
• 6) Report Automation - Automated monthly reports using PySpark, SQL, and Excel, reducing turnaround time by approximately 40%.

Oct 2020 – Feb 2022 · 1 yr 4 mos

• I have worked with supply chain team to track below KPI metrics -
• KPIs Tracking & Insights - Tracked sales and manufacturing metrics, year-over-year pricing changes, and the gap between annual targets and actual performance.

Jun 2019 – Jul 2019 · 1 mo