Ayush Khandelwal

Ayush khandelwal

bookmark on deepenrich
location of Ayush KhandelwalMumbai, Maharashtra, India
Followers of Ayush Khandelwal946 followers
  • Timeline

  • About me

    Assistant Manager - Supply Chain Network Analytics and Transform at General Mills

  • Education

    • Rajiv gandhi institute of petroleum technology, rae bareli

      2011 - 2015
      Bachelor of technology (b.tech.) chemical engineering

      Activities and Societies: Society of Petroleum Engineers

    • Kapil gyan peeth

      2009 - 2011
      High school science maths
  • Experience

    • Bharat petroleum corporation limited

      May 2014 - Jul 2014
      Summer trainee

      Main objectives was to study the processes in DHDS(Diesel Hydro-desulphurisation) unit and efficiency calculation of furnace.

    • Reliance industries limited

      Jun 2015 - Jun 2019

      Setting up inventory norms thus minimising working capital of business considering over 90% service level.Analysing ageing inventory (> 60 days) and its liquidation plan for potential customers using ABC analysis.Developed an excel model for monthly and weekly allocation plan using VBA macros by realigning products and smooth production planning process ensuring minimal over-production and demand drop.Highlight non moving SKUs in order to reduce inventory getting into ageing (> 30 days).Determination of buffer stock of fast moving SKUs in order to have 100% resource utilization and reduction in low quality ageing inventory.Highlight SKUs which are getting produced without any demand or with ageing and ensure no production for those.Developed Material balance reports for business and planner to get an idea of month end stocks & reports to remove FIFO violation. Show less Developed PAN India SNP Network Optimizer tool using Whatsbest/OpenSolver by maximizing overall margin considering all constraints. Tool is used for Strategical, Tactical and Operational planning:1. Operational/Tactical planning – Monthly distribution plan from plants to depots to retail outlets; output fed into primary and secondary daily scheduling model (Vessel, Rail & trucks)2. Strategical planning – Partnership for product purchases; Network planning of Depot/Retail outletUnderstood Petrol/Diesel pricing methodology for B2B & B2C customer and evaluated Bid/Agreement pricing terms for PSU Tenders and sale/purchase viability to/from other OMC vendors.Optimized vessel planning and scheduling to all ports without any dry-outs for over 10 months.Business process Transformation/ Improvement:1. Integrated SNP model with SAP APO for demand and SAP for prices, tax and distance input automation2. Got all India daily sales, inventory and monthly retro report developed in SAP BI used to schedule logistics assets and monitor plan vs actual compliance3. Identify critical dashboards for S&D and design automated dashboards in Hana/Tableau4. Process improvement of only one depot price maintenance in SAP for retail outlets: Led to logistics savings of Rs. 10+ Cr./annum5. Established a new process of depots to retail outlets route finalization using network analyst tool in ArcGIS further used for geofencing in VTS implementation enabling more visibility in last mile delivery Show less

      • Inventory Planning Manager (Polyester)

        Jan 2019 - Jun 2019
      • Supply Chain Planner (Diesel & Petrol)

        Jun 2015 - Dec 2018
    • Sp jain institute of management & research-pgpgm

      Apr 2018 - Apr 2018
      Student (supply chain analytics mdp program)

      3 days MDP Program on Supply Chain Analytics by Dr. Sesha IyerObjective: Enable participants to acquire knowledge and skill in data driven decision making for enhancing supply chain management performance in line with company's performance.Deliverables: SCM performance metircs, demand forecasting models, Inventory replenishment models, Network design and flow optimisation model, Inventory management in MRP & JIT systems with basic hands on training on Tableau.

    • Imarticus learning

      Apr 2018 - Sept 2018
      Student (data science prodegree)

      Learnt Descriptive, Presecriptive and Predictive analytical modelling techniques with hands-on training in R, Python and Tableau.Completed some Industry relevant projects and case studies during the course.

    • General mills

      Jul 2019 - now

      Working on various network optimization projects (Customer Realignment, Greenfield and Brownfield Analysis, Opening/Closing of a Warehouse, Future network optimization, etc.) and support internal stakeholders of General Mills in China, Europe and Australia regions for Dry, Ref and Frozen temp channels. Work on Llamasoft's Supply Chain Guru/Tableau/Spitfire/MS Office tool for modelling purposes.

      • Assistant Manager - Network Analytics and Transform

        Nov 2021 - now
      • Senior Analyst - Modelling (Supply Chain)

        Dec 2020 - Oct 2021
      • Analyst - Modelling (Supply Chain)

        Jul 2019 - Nov 2020
  • Licenses & Certifications

    • Supply chain analytics mdp

      Sp jain institute of management & research-pgpgm
      Apr 2018
    • Integrating tableau and r for data science

      Lynda.com
      Oct 2017
      View certificate certificate
    • Data science prodegree

      Imarticus learning
      Oct 2018