Ravi John, MANAGER - DEMAND PLANNING

Ravi John

MANAGER - DEMAND PLANNING

3M India Limited

Location
India - Bengaluru
Education
Master's degree, Operations Management
Experience
14 years, 1 Months

Share My Profile

Block User


Work Experience

Total years of experience :14 years, 1 Months

MANAGER - DEMAND PLANNING at 3M India Limited
  • India - Bengaluru
  • My current job since December 2016

• Demand Planning Lead for the Safety & Industrial Business Group comprising of 5 divisions.
• Took up additional responsibility of Healthcare Business Group comprising of 4 divisions for 8 months.
• Managed a portfolio of 1000+ Make to Stock SKU's & annual sales turnover of Rs. 960 Cr ($147 m).
• Spearhead multiple monthly S&OP meetings for the said divisions.
• Developed 'Product Expiry Dashboard' - a tool that attempts to statistically identify root causes.
• Developed 'Order Flow Vs Product Availability' dashboard.
• Developed an Offline Forecasting Tool based on 3 models to vet/challenge system statistical forecasts.
• Highest ever forecast accuracy - ASD (72%), PSD (75%), IATD (75%) & C3SD (80%) between 2017-19.
• Developed 'SKU Cockpit' - an SKU performance analysis tool with inbuilt forecast models.
• Recipient of 3M Param Individual Award for Supply Chain Excellence in 2018.
• Attained a performance rating of 5/5 for 2018 and was elevated to "High-Potential" cadre in 2019.

MANAGER – SUPPLY CHAIN, INDIA & INTERNATIONAL RETAIL BUSINESSES at EUREKA FORBES, LTD
  • India - Mumbai
  • September 2015 to December 2016

• Worked as a Supply & Demand Planner for the retail arm of Eureka Forbes.
• Handled planning for all product categories - Water Purifiers, Vacuum Cleaners & Air Purifiers.
• Managed a portfolio of 100+ finished goods SKUs and sales turnover of Rs 500 Cr ($75m).
• Set up the S&OP Process at Eureka Forbes & established the monthly rhythm.
• Entrusted with additional planning responsibilities for FMCD, Rural & International Businesses.
• Developed the SCM Dashboard - a companywide supply chain performance analytics MIS.
• Initiated migration to Order Fill Rates as a metric for measuring Modern Trade supply fulfilment.
• Developed a Defective Rectification Tool which helped accelerate refurbishment of defective products.
• Realized bottom line savings of Rs 87 Lakhs (US$ 120k) within a 5-month period (FY’16) through liquidation of non-moving stocks.
• Planned and oversaw the successful launch of the Air Purifiers category during the Smog epidemic in 2016.

MANAGER – PRODUCT SUPPLY & INVENTORY, INNOVATION at GODREJ & BOYCE MFG. CO. LTD
  • India - Mumbai
  • June 2013 to August 2015

• Worked as a Supply & Demand Planner for Air-conditioners & Microwave Ovens categories.
• Managed a portfolio of 60+ SKU's with an annual sales turnover of Rs. 450 Cr (US$ 70m).
• Appointed by the CEO as the Project Management Office lead to work on critical 'cash-release' projects.
• Realized finance-vetted savings of over Rs. 170 Cr (US$ 26m) through PMO projects between 2013-2015.
• Was among top 3 nominated by the CEO to be part of the accelerated leadership program titled 'Horizon'.
• Founding member of the 'Innovation Cell' at Godrej Appliances.
• Consistently ensured over 90% product availability between 2013-15.
• Reduced YoY ageing inventory by 19% for AC's & 52% for MWO's in 2014-15.
• Attained ‘Surpassed Expectations’ rating for FY 2014-15 (awarded only to the top 1 percentile).

SUMMER INTERN – SUPPLY CHAIN at NESTLE INDIA, LTD
  • India - Delhi
  • March 2012 to May 2012

• Undertook a Six Sigma project to identify the root cause of high variability rates in yoghurt filling at all six 'Nestle A+' yogurt production lines. Bagged a Pre-Placement Offer (PPO) as Plant Demand Planner for Nestle A+ Yoghurt & Infant Nutrition Products.

SPECIFICATION CONSULTANT– TECHNICAL PRODUCTS at HILTI INDIA PVT., LTD
  • India - Mumbai
  • April 2010 to May 2011

• Worked as a technical solutions consultant to key specifiers - Architects, Structural Design Consultants, Contractors, Project Management Companies.
• Specified technical products like Chemical Anchors, Fasteners, Rebar Grouting in structural plans/drawings and passed on the leads to sales.
• Bagged major 'column jacketing' project for India-Bulls towers & Pan India 'rock-anchoring' projects for Ultratech Cements through cost efficient and practical designs

SALES ENGINEER at DAIKIN AIR-CONDITIONING INDIA PVT., LTD
  • India - Mumbai
  • July 2008 to March 2010

• Worked as a techno-commercial sales engineer having the following responsibilities - design, bidding, negotiations, supply, installation & testing.
• Developed an automated tool that optimizes VRV system module selection based on power consumption.

Education

Master's degree, Operations Management
  • at Symbiosis Institute of Operations Management (SIOM)Symbiosis International University
  • January 2013

MBA in Operations Management

Bachelor's degree, Mechanical Engineering
  • at University of Mumbai
  • May 2008

Bachelor of Engineering Degree in Mechanical Engineering.

Specialties & Skills

Supply Chain Management
Demand Forecasting
Inventory Management
Demand Planning
COMMUNICATION SKILLS
FORECASTING
Demand Planning
Pre-Sales
Statistical Forecast Modelling
Sales & Operations Planning (S&OP)
Inventory Management
OTIF & Fill Rate Management
Expiry & Obsolescence Management
SOPs, SLAs & Process Framing
Supply Planning
Production Planning

Social Profiles

Personal Website
Personal Website

URL removed due to policy violation. Please contact support for further information.

Languages

English
Expert
German
Expert
Hindi
Expert
Malayalam
Intermediate
Arabic
Beginner

Memberships

APICS
  • Certified Supply Chain Professional (CSCP)
  • June 2012

Training and Certifications

Microsoft Excel - Expert (Level 3) (Training)
Training Institute:
Godrej & Boyce
Date Attended:
December 2013
Duration:
24 hours
Microsoft Excel - Beginner & Intermediate (Level 1 & 2) (Training)
Training Institute:
Godrej & Boyce
Date Attended:
February 2014
Duration:
24 hours
Horizon Program - Enterprise Planning, Strategic leadership & Disruptive Innovation (Training)
Training Institute:
Illinois Institute of Technology – Chicago
Date Attended:
November 2014
Duration:
1200 hours
TOC Fundamentals Training (Training)
Training Institute:
Goldratt India
Date Attended:
April 2016
Duration:
10 hours
Infor Demand Planner (Training)
Training Institute:
Infor
Date Attended:
August 2013
Duration:
50 hours
SAP – PP/MM Modules (Training)
Training Institute:
SIOM
Date Attended:
June 2012
Duration:
104 hours
Six Sigma Green Belt Certification (Certificate)
Date Attended:
March 2013
Certified Supply Chain Professional (CSCP) (Certificate)
Date Attended:
June 2012

Hobbies

  • Squash
    I play squash at an amateur level
  • Cricket
    Represented my engineering college at Mumbai University level tournaments (seasoned ball cricket) as a middle order batsman and part time legspinner
  • Creative writing
    I used to write articles, short stories and poems which have been published in the internal magazines at college and work. My work can also be found at www.rrealm.blogspot.com.