Ananya Deshmukh — Data Analyst
Pune, Maharashtra
Data analyst two years into retail e-commerce, working in SQL, Python and Power BI. Traced a 9% fall in repeat orders to a broken coupon rule and restored about ₹1.4 crore of annual revenue, and rebuilt the weekly category report the merchandising team now plans against.
Experience
Data Analyst, Gulmohar Commerce · July 2024 – present
Category analytics for a marketplace of 2.3 million customers across 11 categories.
- Rebuilt the weekly category report in Power BI, replacing 90 minutes of manual spreadsheet assembly with a four-minute refresh that 40 category managers now read.
- Traced a 9% fall in repeat orders to a coupon rule that silently excluded first-time buyers; the fix restored about ₹1.4 crore of annual repeat revenue.
- Built the cohort retention model the merchandising team plans promotions against, covering 2.3 million customers and three years of order history.
- Cut query cost on the three heaviest dashboards by 62% by partitioning the orders table on order date and dropping four unused joins.
Data Analyst Intern, Lumenfield Analytics · January 2024 – June 2024
- Automated the daily stock-out check in Python, replacing a 45-minute manual routine and surfacing 210 stock-outs in the first month.
- Standardised five years of supplier records ahead of a warehouse migration, removing 18,000 duplicate rows and 340 mismatched tax codes.
Projects
- Mandi Watch — A public dashboard tracking daily wholesale prices for 14 crops across 60 Maharashtra markets.
Education
- B.Sc. Statistics · Fergusson College, Savitribai Phule Pune University · June 2021 – May 2024
Skills
- Analysis: SQL, Python, pandas, Cohort analysis, A/B testing
- Reporting: Power BI, DAX, Excel, Looker Studio
- Data: PostgreSQL, BigQuery, dbt, Data modelling, Data cleaning
Certifications
- Microsoft Certified: Power BI Data Analyst Associate (PL-300) — Microsoft
- Databricks Certified Data Analyst Associate — Databricks