Summary
Overview
Work History
Education
Skills
Activities
Projects
References
Certification
Timeline
Generic

Shruti Upadhyay

Austin,TX

Summary

Results-driven procurement professional with expertise in identifying cost-savings opportunities, managing vendors and negotiating contracts. Proven track record of successful cost optimization and supplier performance management. Good knowledge of Inventory Management, Assortment Planning, Data Analysis. Apt at data modelling and data visualization with data tools like Power BI, SQL, Access, Tableau.

Overview

10
10
years of professional experience
1
1
Certification

Work History

Procurement Manager

Reliance Retail
04.2018 - 10.2023
  • Developed Sales & Buy Plan in order to meet Business targets
  • Managed a team of procurement professionals, fostering collaboration and teamwork to achieve organizational goals.
  • Developed strong relationships with key suppliers, resulting delivery schedules.
  • Managed end to end business volume of 15BINR
  • Improved bottom line by 0.5% by optimizing margin eroders
  • Streamlined customer buyback process resulting in annual saving of 20MINR
  • Reduced procurement costs by implementing strategic sourcing initiatives and negotiating favorable contracts with suppliers.


Inventory Planner

Reliance Digital Retail Ltd
04.2016 - 04.2018
  • Played an instrumental role in developing power BI dashboards on sales(LFL), OTB, Ageing and phased out SKU
  • Assessed risk inventory & deploy mitigation plan
  • Streamlined inventory management process by implementing efficient tracking and forecasting systems.
  • Reduced surplus stock levels through accurate demand analysis and proactive purchasing adjustments.
  • Delivered positive LFL despite negative trend in industry through promotional activities
  • Established relationships with vendors and suppliers to streamline procurement operations.
  • Improved supply chain visibility, proactively communicating with suppliers to address potential delays or shortages.
  • Realized In-stock of 96.48% during peak season against the target of 95%
  • Achieved 2% ageing inventory greater than 2 quarter as against target of 3%.
  • Boosted accuracy in forecasting demand by 6% through comprehensive analysis of historical data and market trends

Demand Planner

Volvo Eicher Commercial Vehicles
06.2013 - 04.2016
  • Generated SKU level statistical forecast for 22000 spare parts
  • Analyzed historical data to identify patterns, trends, and seasonality for use in demand forecasts.
  • Developed reports like Order fulfillment report, Ageing report, closed out SKU report and Open order report
  • Prepared network analysis of spare part dealer and distributer and suggest the optimum warehouse location for Storage
  • Developed programs with IT department to automate various daily reports & new developments
  • Achievements: Designed & Implemented Distributors mapping with Distribution Centre via Network analysis
  • Reduced inventory costs by optimizing safety stock levels and effectively managing obsolete items.
  • Enhanced customer satisfaction with timely product availability through accurate demand forecasting.
  • Developed collaborative relationships with cross-functional teams to ensure alignment in demand planning processes.
  • FY15 Forecast Accuracy of 92%, method used is time series forecasting
  • Realized ON-Time-In-Full of 96% against target of 95%
  • Reduced transportation cost by 15%, amounting to 258 MINR against discovery of 273 MINR.



Education

B.E. - Industrial Production -

SGSITS-Indore
01.2013

Higher Secondary -

Padma School Gwl
01.2008

High School -

TC Jain School Ambah
01.2006

Skills

  • Demand Forecasting
  • Inventory Management
  • Data Analysis
  • Supply Chain Optimization
  • Collaboration and Communication
  • ERP Systems (SAP)
  • Excel, Access, Power BI, Tableau, SQL
  • Problem-solving and Decision-making

Activities

  • Excellence in Mathematics award for securing full on marks in 10th Board
  • Preparing for APICS CPIM Certification
  • Received 5 "Tatkal" rewards in VECV for various out of the way contribution
  • Member- core committee in college cultural event & BAHA team
  • Cadet of NCC for 2 years

Projects

Steel Authority Of India(SAIL), Delhi, To optimize logistics cost of coal from sources to plant, Developed Excel solver based sourcing model which generated surplus revenue of 3.5%

References

References would be furnished if require

Certification

  • Certified SAP S/4 HANA Sourcing & Procurement- 1709


Timeline

Procurement Manager

Reliance Retail
04.2018 - 10.2023

Inventory Planner

Reliance Digital Retail Ltd
04.2016 - 04.2018

Demand Planner

Volvo Eicher Commercial Vehicles
06.2013 - 04.2016

B.E. - Industrial Production -

SGSITS-Indore

Higher Secondary -

Padma School Gwl

High School -

TC Jain School Ambah

Similar Profiles

CREATE PROFILE
Shruti Upadhyay