Sumit Agarwal Email & Phone Number

India

Gurugram, Haryana, India

New Delhi, Delhi, India

• Developed/ maintained/ tracked primary sales/ secondary sales dashboard to capture granular sales trends, KPIs including GOLY/GOLM, forecast billing monthly/quarterly/yearly closing and maintain historic data trends.
• Developed a category and SKU-level demand plan accuracy dashboard to analyse reasons for low accuracy from both demand and supply-side. RSP accuracy showed a gradual improvement of ~20% over the months.
• Created a category and SKU-level fulfilment dashboard to identify gaps between POs and billing to bring transparency which reduced operational gaps and enhanced volume fulfilment rates by ~10%.
• Created, maintained, and updated PSI sheet monthly to forecast closing inventory at platforms to strategize stock planning. Over 3 months, OOS reduced by ~7%.
• Created CXO-level decks to highlight trends, gaps, and achievements in sales/ inventory planning/NPD progress among other KPIs.
• Developed BU-wise trackers with category teams to analyze overall market size, competition profile, OEL market share, OEL product rankings, R&R etc. to benchmark OEL portfolio against competitors.

Pune, Maharashtra, India

• Conducting market research, feasibility studies, pilot studies and preparing excel data models for a "global navigation giant" for its product evaluation studies
• Identifying KRAs, capturing/monitoring/performing Root Cause Analysis (RCA) on KPIs through exploratory data analysis to generate data-driven business insights for product enhancement after requirement gathering and.
• Automating the reports with relevant KPI numbers/charts for easy handling of large sampled datasets
• Preparing executive client decks with recommendations and deep-dive business analysis to identify trends/patterns/gaps in data to improve product performance with respect to the competitor profile
• Communicating with stakeholders in a cross-functional setup to decide workflow/attributes for data collection and drive regular metric review calls till study completion
• Tracking project milestone progress/timelines and executing end to end delivery of project study reportsAchievements/ Learning:Worked as a senior analyst on 4 "navigation product" evaluation and enhancement studies end.

Bangalore

• Suggested a go-to-market strategy for a healthcare solution after an extensive secondary research of the market being targeted by Optum
• Proposed a business platform model with a cost-benefit analysis after analyzing opportunities and challenges of the proposed solutions

Pune, Maharashtra

• Communicated with client and other stakeholders to understand objective and goal of AT&T’s telecom business application modules live environment changes in code and prepare activity plans for execution
• Ensured cross-functional collaboration by identifying resources to execute planned changes in app
• Handled escalations and ensured timely resolution as single Point Of Contact during deployment runs
• Created end to end reports for stakeholders detailing incidents/activities/escalation resolutions during deployments to gather insights for process efficiency and optimization

Pgdm, Marketing And Finance

Bachelor’S Degree, Information Technology

Xii, 93.4 %

High School, 95.20 %