Ayush Uttam

MBA (Operations & Marketing) candidate with hands-on exposure to FMCG sales analytics at Dabur India and 4 end-to-end Power BI dashboards built on 285K+ records across e-commerce, quick-commerce, mobility, and consumer-electronics datasets. Skilled in requirement gathering, KPI design, process mapping, and self-serve reporting using Advanced Excel, SQL, Power BI, and Power Query.

Business Analyst Intern at Dabur India Pvt. Ltd. (2025-08 – Present)

• Analysed primary and secondary sales data across 15+ SKUs and 30+ retail outlets to identify demand and shelf-movement trends, supporting territory-level sales planning.
• Prepared 4 weekly campaign performance reports consolidating sales, distribution, and visibility data, replacing 3 separate trackers with a single review format for the sales team.
• Documented end-to-end marketing execution workflows through discussions with 5 stakeholders across sales, trade marketing, and distribution, producing process maps that surfaced 2 recurring handoff delays in campaign rollout.
• Benchmarked 3 competitor brands across 4 product categories on pricing, pack size, and shelf visibility, translating findings into positioning recommendations shared with the marketing team.

MBA in Operations & Marketing – Allenhouse Institute of Management, Kanpur (2024 – 2026)

Bachelor of Arts – Chhatrapati Shahu Ji Maharaj University, Kanpur (2020 – 2023)