Data Analyst – Strategy & Finance at Zomato (2018-06 – 2022-08)
India's largest Food Delivery, Dining and Restaurant Discovery Service
- Developed a locality-level supply-demand tracker (200+ users) using K-means clustering for a newly launched product feature.
- Saved (100+ hours) of co-ordination time between sales and marketing analytics team using data optimized at geographical grids.
- Directly led technical internal audits for customer refund and discount policies in collaboration with PWC to ensure compliance.
- Reconciled merchant payouts to identify discrepancies and proactively coordinated with the billing team for timely resolution.
- Reduced fraud by 12% by working on various user and merchant segments along with creating risk scores for fraud detection.
- Shipped Tableau and Redash real time dashboards to monitor billing KPIs across India and UAE for the finance and billing team.
- Automated trackers by saving 10 hrs/week by integrating slack snapshots with tableau for daily reporting and data visibility.
Data Analyst – Pricing Team at BlinkIt (2022-09 – 2023-02)
Indian quick commerce (8 mins delivery)
- Successfully built a dynamic Pricing Simulator to project product margins using sales prediction data with 83% accuracy.
- Facilitated collaboration within 20+ stakeholders from sales & warehouse using PRDs to optimize targets & restocking.
- Identified Price Elasticity for festive assortment through dynamic pricing experiments to drive 5% margins & -30 % wastage.
- Enabled pricing strategy to increase revenue by 21% using historical sales, current inventory and competitor benchmarks.
Product Analyst at Aryng (2023-05 – 2024-01)
Client: Life360, Family location safety app
- Conducted Campaign Analytics to evaluate feature usage after a free trial; increased user adoption rate for subscriptions by 5%.
- Formulated the business problem statement and the A/B tests; validated their statistical significance in the hypothesis testing.
- Built probabilistic models to predict subscription level Churn, Retention & customer LTV values using Binomial framework.
Data Analyst at Veera (2024-02 – 2024-07)
Chromium open-source browser
- Collaborated with stakeholders and derived company's logical data model by validating relations and normalizing data to 3NF.
- Designed and refined EER diagrams, defining primary and foreign keys to enforce data integrity and reduce update anomalies.
- Developed automated ETLs with cron jobs using python libraries with Airflow to push data to Redash for SQL-based querying.
