Mohit Gupta Email & Phone Number

• Analyzed consumer buying trends in Mexico and Brazil for PepsiCo, identifying pivotal product attributes influencing buying decisions and trade-offs within the product leading to an additional $10M in revenue & 0.5% in.
• Designed the suggested order portfolio recommender for Kellogg’s across various geographies at the store level for sales teams to provide right quantity and products resulting in higher compliance & revenue growth of.
• Handling daily communication with client stakeholders and defining work priorities for timely delivery of the project.
• Directed and nurtured a team of 6-8 analysts hailing from diverse disciplines across various departments, demonstrating adept leadership and fostering professional growth within the organization

Gurugram, Haryana, India

• Engineered sales-centric strategies, leveraging K-means clustering to optimize product portfolios across 1,000+ modern trade stores in the LATAM region. Resulted in ~5% YoY revenue growth and a $20M profit increment.
• Optimized procurement process for Kellogg’s, crafting strategic vendor scorecards for streamlined negotiation and pricing strategies, resulting in a 2-3% reduction in raw material unit costs through effective vendor.
• Collaborated with executive and C-suite leadership to spearhead several digital transformation projects, utilizing prioritization, optimization, and rectification frameworks to track business and inform strategic.
• Worked on client problem understanding, proposal making, defining the project scope, timeline, business analytics, and communicating key insights to senior internal and client stakeholders to shape strategy-based agile.
• Directed and nurtured a team of 4 analysts hailing from diverse disciplines across various departments

Gurugram, Haryana, India

• Awarded as “Best Solution Provider” from a team of 70+ members for Alternate Flight Recommendation Plan
• Alternate Flight recommendation: Enhanced the re-accommodation process for passengers with cancelled flights by minimizing revenue leakage and saving the company ~INR 50Lakhs monthly
• Connecting network & Pricing: Optimized the inventory of connecting flights & the connecting time at airports to maximize the connection opportunities in network contributing to ~2% increment in connecting traffic
• Mentored and led a team of 2 and coordinated with various departments for rolling out decisions on real time basis

Gurgaon, India

• Forecast & inventory optimization: Optimized and enhanced functionality of flight inventory forecasting code resulting in 40% reduction in run time and better inventory management contributing to ~2% increment in.
• Ancillary Pricing: Analyzed the impact of DGCA policies and guidelines on cancellation & change fees charged by airlines and restructured the same to minimize the revenue loss and save ~10 Cr yearly

Delhi

• Mid mile route optimization: Restructured the HUB to DC route mapping using simulated annealing algorithm in R and improved vehicle capacity utilization, resulting in daily saving of ~ 500Kms distance
• DC expansion: Established 850+ delivery centers across India based on analysis of location demographics and achieved full coverage in 8 states resulting in 15% volume growth in tier 3 & 4 cities
• Misroute correction: Designed address intelligence mechanism by analyzing past consignee’s address for extracting the locality and used the same to map new addresses for solving misdirection of shipment

1. Improved product marketability and profitability by researching, identifying, and capitalizing on market opportunities2. Developed various marketing techniques to increase the customer acquisition rate

Ahmedabad Area, India

1. Analyzed the root cause of Sanitaryware defects and implemented the plan for improving global yield of product 2. Analyzed the previous product designs and improved the designs for water saving

1. Manufacturing of different variety of tiles and ceramic ware2. Determination of composition of raw material for batch formation

B.Tech, Ceramic Engineering

CGPA: 8.49 (Department Rank - 6)

All India Senior School Certificate Examination

Marks: 89%

All India Secondary School Examination

CGPA: 10.0

Bachelor Of Technology - Btech