Avani Mahawar

Data professional with 6+ years of experience in workflow automation, data modelling and pricing analytics. Experienced in building machine and deep learning models using Python and statistical trends with tools like Airflow and MySQL Workbench.

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.

MSc in Data Science and Artificial Intelligence – University of Liverpool (2025-01 – 2026-01)

Bachelor of Technology (B.Tech) in Industrial and Production Engineering – Indian Institute of Technology (IIT) Delhi (2014-01 – 2018-01)