Priyanka Tiwari
Supply Chain Analyst
Maryland, US.About
Results-driven Supply Chain Planning and Analytics professional with 5+ years of expertise in optimizing complex supply chains across pharmaceutical, FMCG, and large-scale retail sectors. Leverages data-driven insights and advanced analytics tools to translate business requirements into scalable solutions, consistently improving planning accuracy, operational visibility, and cost efficiency. Proven ability to drive significant improvements in forecast accuracy, inventory optimization, and logistics performance through strategic S&OP support and cross-functional collaboration.
Work
Kroger
|Supply Chain Planning Analyst
Maryland, Maryland, US
→
Summary
Orchestrated end-to-end supply planning for 12,000+ SKUs across 40+ distribution centers, integrating diverse demand channels to improve on-shelf availability and operational efficiency.
Highlights
Managed end-to-end supply planning for 12,000+ SKUs across 40+ distribution centers, improving on-shelf availability by approximately 7% within network capacity limits using SAP IBP.
Achieved a 14% improvement in weekly forecast accuracy by building and maintaining SKU-level demand forecasts using Python and SQL, incorporating seasonality and promotion adjustments.
Reduced annual excess inventory by nearly $4M by establishing inventory segmentation and safety stock parameters aligned to service-level targets for ambient, refrigerated, and frozen categories.
Mitigated stockout risk by 18% during peak periods through conducting scenario analysis on transportation delays, labor constraints, and demand spikes to enable proactive mitigation actions.
Automated SQL-based data validation and refresh processes in a cloud data environment, cutting manual effort by 35% and improving planning reliability.
Hindustan Unilever Limited (HUL)
|Logistics Transformation & Strategy Analyst
India, India
→
Summary
Contributed to a pan-India logistics transformation program spanning 30+ warehouses and 1,000+ distributors, focusing on optimizing cost efficiency and service levels.
Highlights
Identified 8-10% margin leakage across modern and general trade channels by developing SKU- and channel-level cost-to-serve models using SQL and Excel (Power Query, Pivot Tables).
Reduced average delivery lead times by ~12% without increasing logistics spend through network scenario analysis using Python and Excel, evaluating warehouse consolidation and hub-and-spoke structures.
Reduced line-haul transportation costs by ~7% by building transportation analysis models in SQL and Excel VBA to assess lane utilization, shipment frequency, and mode mix, enabling freight consolidation.
Achieved ~5% cost savings while improving On-Time, In-Full (OTIF) performance by collaborating with procurement and 3PL vendors to renegotiate rate cards and optimize contract SLAs.
Automated weekly logistics performance reporting using Power BI and SQL Server, reducing manual reporting effort by ~40% and improving visibility for regional and national supply chain leadership.
Accenture (Client: Pfizer)
|Supply Chain Planner
India, India
→
Summary
Supported a global supply planning engagement for Pfizer's essential medicines portfolio, ensuring supply continuity for 120+ finished goods SKUs across North America and EMEA markets.
Highlights
Improved forecast accuracy by ~18% for chronic and stable product lines by preparing demand forecasts in SAP APO (DP) using historical sales data, seasonality patterns, and commercial inputs.
Reduced excess and slow-moving inventory by ~14% while maintaining service levels above 98% by managing inventory planning activities for 3 manufacturing plants and 6 regional distribution centers.
Translated demand plans into feasible supply plans using SAP APO (SNP), incorporating production capacity, lead times, and safety stock parameters across multiple manufacturing sites.
Reduced manual reporting effort by ~30% through developing Excel-based planning and exception reports (Pivot Tables, Power Query) to track capacity utilization, supply gaps, and expedite requirements.
Ensured master data accuracy and stability of planning outputs post-implementation by assisting with planning system data migration and validation during SAP enhancements.
Education
University of North America
Master of Science
Computer Science
Maharaja Ranjit Singh College
Bachelor of Commerce
Computer Application
Skills
Supply Chain Planning & Operations
Demand Forecasting, Supply Planning, Inventory Optimization, Replenishment Planning, Production Planning, Order Fulfillment, Logistics & Distribution, Supplier Collaboration, Sales & Operations Planning (S&OP), Integrated Business Planning (IBP), Service Level Management.
ERP & Planning Platforms
SAP IBP, SAP APO (DP, SNP), SAP S/4HANA (MM, SD, PP), SAP ECC, Oracle SCM Cloud, Blue Yonder (JDA), Kinaxis RapidResponse.
Data Analytics & Reporting
SQL (MySQL, PostgreSQL), Advanced Excel (Pivot Tables, Power Query, VBA), Python (pandas, NumPy), Power BI, Tableau, SAP Analytics Cloud.
Forecasting & Inventory Models
Time Series Forecasting, Demand Sensing, Safety Stock Planning, Inventory Segmentation (ABC/XYZ), Reorder Point Planning, Lead Time Analysis, Scenario & What-If Analysis.
Logistics & Network Analytics
Transportation Analytics, Distribution Network Analysis, Route & Lane Optimization, Freight Consolidation, Cost-to-Serve Analysis, Warehouse Performance Metrics.
Performance Metrics & KPIs
Forecast Accuracy, Forecast Bias, OTIF, Fill Rate, Inventory Turns, Weeks of Supply, Capacity Utilization, Cost per Case, Service Level Tracking.
Process Improvement & Methods
Lean Six Sigma, Continuous Improvement, Value Stream Mapping, Process Standardization, Root Cause Analysis, Exception Management.
Data & Systems Governance
Master Data Management, Data Validation, Planning Parameter Setup, System Testing, Data Migration Support.
Collaboration & Delivery
Cross-Functional Stakeholder Management, Business Requirements Gathering, Project Coordination, Agile & Scrum Environment.