Pranav Shelke

Experience

• 

  TATA Power

  Jun 2019 - Jun 2019

  Internship Trainee
• 

  Tata Projects

  Dec 2019 - Feb 2020

  Project Intern
• 

  LazyDoor

  Dec 2021 - Feb 2022

  Operation and Supply Chain Intern

  • Clustering, Routing of orders, & Tracking operation statistics also maintaining and creating daily reports• Handled the end-to-end operations of last mile delivery and coordinated among team to address issue• Optimized last mile delivery of products to ensure savings in logistics and transport for cost reduction

• 

  Emami Agrotech Limited

  Apr 2022 - Jun 2022

  Supply Chain Management Intern

  • Analysed the system generated statistical forecast and the correlation with actual sales using MS Excel• Complied promotions on sales, Uplift gained and cleansing of sales history for optimal statistical forecast• Integrated ABC-XYZ inventory grid analysis with existing supply chain and operations processes in Excel• Pre-processed SKUs past consumption data by outlier adjustment techniques to eliminate future errors• Performed forecasting at volume, value level for brand, and 150+ SKU for validation of STAT forecasts • Developed VBA tool in Excel to compare the accuracies of different standard models with MAPE, RMSE• Implemented 10 forecasting models via Microsoft Excel & SPSS to evaluate model error & accuracy • Documented Winter-holts & Regression matrix model for SKU and proposed same to obtain accuracy• Achieved accuracy within range of 89.5-98.5% annually at brand value fits and forecasts with final models• Attained MAPE in the range of 0 and 10% for more than 85% of fits and forecast at SKU volume level • Successfully increased forecasting accuracy by 5%, for A class SKUs, driven by proposed FC models Show less

• 

  Carlsberg Group

  Jul 2023 - now

  Stint 3: Supply and Demand Planning Stint 2: Indirect Procurement Stint 1 : Brewery Operations & Carlsberg Excellence

  • Management Trainee - ISC

    Mar 2024 - now

  • Management Trainee - ISC

    Oct 2023 - Mar 2024

  • Management Trainee- ISC

    Jul 2023 - Oct 2023