GAURAV SHARMA
Delhi NCR
Summary
Detail-oriented professional with nearly ten years of experience in FMCG and Print industries. Expertise in data gathering, mining, visualization, and analysis, complemented by strong MIS capabilities. Proven ability to manage multiple projects in entrepreneurial environments, leveraging both qualitative and quantitative skills. Seeking opportunities to apply existing skills while embracing new challenges and collaborative learning.
Overview
17
17
years of professional experience
Work History
Manager - Pricing & Scheduling Team
HT MEDIA LTD.
Delhi NCR
07.2024 - Current
- Perform detailed analysis of Revenue, Volume, Market Share, and Yield at daily, monthly, quarterly, and yearly levels.
- Track and evaluate yield drop reasons, including missed/absent clients, low-yield accounts, and inventory mix changes.
- Handle pricing and rate queries by reviewing historical rates and finalizing new client rates based on IOR framework.
- Support management decision-making by providing data-driven insights on pricing, scheduling, and inventory utilization.
Deputy Manager - Circulation
HT MEDIA LTD.
Delhi NCR
10.2011 - 06.2024
- Prepare Sales MIS, performance scorecards, and variation/implementation gap reports. • Reconcile bookings, track submissions (renewals & fresh), and monitor sales targets (annual/quarterly/monthly).
- Conduct competitor ad analysis, market share updates, and circulation presentations for leadership.
- Maintain NPS/PO/Unsold reports and track reader expiries vs renewals. • Allocate AOP numbers and KRAs, assess manpower vs booking targets, and ensure system updates.
- Provide sales status reports, motivate teams with ranking systems, and support performance improvement.
MIS Executive
HINDUSTAN UNILEVER LTD.
Gurgaon
04.2009 - 09.2011
- Developed and maintained GTM metrics (Urban & Rural) and transition loss reports for Pan India.
- Prepared sales MIS, dashboards, and growth reports (monthly, quarterly, yearly) including basepack, channel trends, and contribution analysis.
- Managed sales data masters for capturing primary/secondary sales and monitored sales trends with ECO & coverage efficiency.
- Published and tracked new sales targets (area-wise, RS-wise, category-wise) and ensured order vs allocation alignment.
- Analyzed channel performance, family grocer growth, and contribution reports across different levels.
- Maintained field capability scores and supported leadership with ad-hoc reporting & actionable insights.
Education
B.COM -
Delhi University
01.2009
Skills
- Data analysis and reporting
- Data visualization
- Management information systems
- Sales planning and strategy
- Project management
- Power BI expertise
- SQL proficiency
- Advanced Excel skills
Timeline
Manager - Pricing & Scheduling Team
HT MEDIA LTD.
07.2024 - Current
Deputy Manager - Circulation
HT MEDIA LTD.
10.2011 - 06.2024
MIS Executive
HINDUSTAN UNILEVER LTD.
04.2009 - 09.2011
B.COM -
Delhi University