Sep 2023 – Dec 2024 · 1 yr 3 mos · Mumbai, Maharashtra, India · On-site

Apr 2023 – Sep 2023 · 5 mos · Mumbai, Maharashtra, India

• ● Led and managed a team of 11 in benchmarking and competitive pricing, achieving over 75% market coverage.
• ● Core member for analysing the purchasing behavior patterns of customers using Python, leveraging support, confidence, and lift metrics to create a successful Buy X Get Y campaign, resulting in an 8% increase in net margin per order.
• ● Created SQL and Mixpanel dashboards, automated mailer for real-time monitoring of Discount, Margin, and Promos at Category and SKU levels.
• ● Collaborated with the Product Team, authored Business Requirement Document (BRD), conducted A/B testing for core user flows.
• ● Evaluated pricing initiatives using financial metrics (profit margins, pricing elasticity, sensitivity) and provided data-driven recommendations for optimization.

Apr 2022 – Apr 2023 · 1 yr · Mumbai, Maharashtra, India

• ● Optimized 8+ Excel/G-Sheet reports and metrics using SQL and Mixpanel, reducing processing time by 80% (from 4 hours to 45 minutes).
• ● Analyzed daily data and created automated dashboards and emails PAN India using SQL & Appscript, resulting in a significant increase in Expiry Removal % in Delivery Hubs from 77.30% (Oct 22) to 99.57% (Jan 23).
• ● Built and drove Store Productivity Metric and Dashboard, leading to increased store productivity from 74% (May 22) to 98% (Jan 23) PAN India.
• ● Analyzed order packing time data and employed data-driven decision-making to decrease estimated packing time from 1.8 min to 1.5 min.
• ● Collaborated with Zepto Cafe and Product team, analyzing cafe order data and developing logic for estimated packing time. Authored Business Requirements Document (BRD) and Product Requirements Document (PRD).
• ● Worked closely with the Product team for new product rollouts, prioritization, deprioritization, and logic changes (ETA, Packing, Zepto Cafe, last mile delivery, etc.).
• ● Conducted ad hoc data analysis and visualization using Excel and SQL, including buffer optimization, order delivery & last mile breach reduction, order assignment analysis, and packer productivity analysis

Oct 2021 – Apr 2022 · 6 mos

• ● Streamlined Operations for -100 providers, which led to an improvement of NPS from -10% to 72% over 3 months at a Rapid Pace for Personal Chefs Category.
• ● Analyzed trend and Improved provider traveling time of providers via Route optimization from an average of 25 mins to the current 10 mins.
• ● Created the provider-customer Matchmaking system to improve customer experience by analysing order pattern and heatmap of the city, leading to an increase in average Ratings from 4.2 to 4.8 out of 5.0.
• ● Handled 50 customers in Key Account Manager(KAM) Model, which lead to a reduction in FBCE (Fulfillment Bad Customer experience) % from more than 10% in Dec'21 to less than 2%.
• ● Coordinated with the Product team to improve the app workflow of providers.
• ● Used SQL and Google Sheets to analyze data of 5 months for planning growth & customer retention, report optimization and SQL dashboard building for the category.
• ● Managed the Customer Escalation resolution system to bring down the escalation % from more than 20% on Dec 21 to less than 2%.

Aug 2021 – Oct 2021 · 2 mos

• ● Inventory Management of cosmetics and beauty products in the city for providers.
• ● Streamlined Operations for the city which led to an NPS increase from 30% to 65% in 2 months.
• ● Handholding of providers to follow Quality SOPs and Workflow SOPs
• ● Increased the average Service Delivered(SD) % from 60% to 86% in 2 months.