Summary
Overview
Work History
Education
Skills
technologies
Projects
training
Timeline
Generic

Prabhav Pandey

Middleton,USA

Summary

Results-oriented professional with 7 years of diverse experience in operations and data analytics. Led several projects and implemented technical solutions at clients across USA, Europe and India.

Overview

11
11
years of professional experience

Work History

Supply Chain Analyst

Imbed Biosciences Inc
02.2023 - Current
  • Designed production plan for products
  • Designed order management and purchasing KPI's with interactive dashboards and sharing them with the board members.
  • Calculated min, max and safety stock levels of the inventory which helps purchasing team to determine when to place the order
  • Forecasting of products for 2024 season by analyzing the levels, trend and seasonality
  • Developed the Work in progress, finished goods and raw material monthly reports, helping the finance team to calculate accurate COGS value.
  • Optimized supply chain processes by implementing data-driven analysis and forecasting methods.
  • Reduced inventory holding costs through effective demand planning and supplier management strategies.
  • Streamlined procurement processes, enhancing supplier relationships and reducing lead times for critical materials.
  • Implemented advanced analytics tools, improving demand forecasting accuracy and supporting more informed decision-making processes.
  • Ensured timely delivery of products to customers by closely monitoring order fulfillment processes and addressing any issues promptly.
  • Worked closely with sales teams to understand customer needs, ensuring appropriate inventory levels were maintained to meet demand fluctuations effectively.

Supply Chain Analyst

Navitus Health Solutions
05.2022 - 12.2022
  • Used Data analysis to discover the trends over various categories and sub-categories of drug classes and did forecasting of multiple drugs using baseline models such Linear time series models and non-linear models with an average accuracy of 85-90% across different drug classes.
  • Collaborated with cross-functional teams to develop and execute end-to-end supply chain strategies that supported business objectives.
  • Reported on supply chain KPIs to verify compliance with established standards.

Entrepreneur

Grouprop
09.2017 - 08.2020
  • Conducted target market research to scope out industry competition and mapped product roadmap to revenue streams
  • Managed sales, operations, logistics and was responsible for customer interaction and relationship.
  • Self-motivated, with a strong sense of personal responsibility.

Senior Software Analyst

Accenture Services Private Limited
08.2012 - 08.2016
  • Worked closely with software development and testing team members to design robust SAP solutions
  • Led SAP CRM application design and development across 10-member development team.
  • Delivered high-quality documentation for both technical and non-technical audiences, facilitating better understanding of application functionalities across teams.
  • Managed multiple concurrent projects from initial conception through successful delivery, consistently meeting deadlines while maintaining a high standard of work quality.

Education

Bachelor of Technology in Electronics and Communication -

SRM University

M.S. in Industrial And Systems Engineering -

University of Wisconsin
Madison, WI
12.2022

Skills

  • Purchasing Processes
  • Stakeholder Relationships
  • Data Analysis
  • Supply Chain Planning
  • Production planning
  • Demand forecasting
  • Report Preparation
  • Order processing

technologies

Python, R, My SQL, SQLite, Oracle DB, MS-Excel, MS-Word, Power Point, Power BI

Projects

Developed an inventory management tool that categorized inventories in terms of ABC analysis. This tool also helped group the suppliers as best to worst in terms of their respective lead times which helped to set the right MOQ and safety stock levels for the inventory.

Developed different forecasting models to forecast demand for multiple SKUs over a period of 1-month, 3-months, and 5-months and achieved an accuracy of around 90%, 85% and 82% for the three cases.

Designed different supply chain metrics and developed a KPI dashboard that displayed daily, weekly, and monthly trends of revenue, profit margins, COGS, top performing products etc.

Developed Tableau visualization for food supply chain data set, performed data wrangling, descriptive data analysis and Tableau dashboard development. 




training

  • Supply Chain Analytics
  • Network Optimization
  • Inventory Optimization
  • Linear Programming
  • Forecasting
  • Visualization using Power BI
  • Visualization using Tableau
  • Basic Statistics
  • Inferential Statistics
  • Machine Learning with Python
  • Python Data Structures

Timeline

Supply Chain Analyst

Imbed Biosciences Inc
02.2023 - Current

Supply Chain Analyst

Navitus Health Solutions
05.2022 - 12.2022

Entrepreneur

Grouprop
09.2017 - 08.2020

Senior Software Analyst

Accenture Services Private Limited
08.2012 - 08.2016

Bachelor of Technology in Electronics and Communication -

SRM University

M.S. in Industrial And Systems Engineering -

University of Wisconsin
Prabhav Pandey