Supply Chain Analytics & Demand Planning Analyst

Supply Chain Analytics Demand Planning S&OP MRP Logistics Procurement SAP SQL Power BI Vendor Management Harsha Vardhan Battina

Supply Chain Analyst

St.Louis, MO +1-215-***-**** ************************@*****.*** SUMMARY

Supply Chain Analyst with 4+ years of experience in demand planning, inventory optimization, procurement analytics, logistics coordination, and forecasting across retail and healthcare sectors. Skilled in SQL, Power BI, SAP MM/SD, Excel, and KPI reporting to improve forecast accuracy, reduce operational costs, and optimize end-to-end supply chain performance. TECHNICAL SKILLS

Core Supply Chain: Inventory Management, Order Processing, Procurement Support, Vendor Coordination, Logistics Tracking, Distribution Planning, Data Analysis, Process Automation, Stakeholder Collaboration, Supply Planning Data & Analytics: Advanced Excel, SQL (Advanced), Power BI, Tableau, Python, Data Visualization, Data Cleaning & Reporting ERP & Tools: SAP MM, SAP SD, Oracle SCM, NetSuite, MS Access, WMS Process Improvement: Root Cause Analysis, KPI Tracking, Workflow Documentation, Cost Control Support Operations Support: Demand Planning & Forecasting, Statistical Forecasting, Forecast Accuracy Improvement, Purchase Order Management, Freight Tracking, Returns & Reverse Logistics Soft Skills: Analytical Thinking, Problem-Solving, Communication, Team Collaboration, Time Management, Attention to Detail PROFESSIONAL EXPERIENCE

PepsiCo, MO, USA Dec 2024 – Present

Supply Chain Analyst

• Reduced supply chain costs 12% using SQL, Power BI, and supply chain analytics for demand planning and inventory optimization.

• Managed reporting and analysis for procurement, inventory, and logistics operations across multi-site supply chain activities.

• Led process automation of procurement and forecasting reports using SQL and Excel, reducing manual effort by 30%.

• Improved inventory accuracy by 15% through SAP MM/SD replenishment planning and WMS optimization, reducing stockouts and improving service levels.

• Shortened vendor onboarding time 25% by streamlining purchase order approvals, enhancing procurement analytics and vendor performance analysis, improving sourcing efficiency.

• Improved freight tracking accuracy and reduced shipment delays 18% by leading root cause analysis and implementing solutions for logistics optimization and supply chain visibility.

• Drove stakeholder collaboration across procurement, logistics, and operations teams to improve end-to-end supply chain performance.

CitiusTech, India Aug 2021 – July 2023

Supply Chain Analyst

• Lowered excess inventory 10% by designing Tableau dashboards to track demand-supply variance, improving inventory optimization and forecast accuracy.

• Conducted demand forecasting using Excel and Python, supporting demand planning and S&OP processes, leading to a 15% reduction in excess inventory and 25% improvement in turnover.

• Coordinated order processing and vendor schedules, achieving 96% on-time delivery through improved logistics optimization and supply chain visibility.

• Conducted supplier performance analysis using Excel and MS Access, strengthening vendor performance analysis and procurement analytics, improving cost control.

• Reduced order processing delays 15% by implementing structured reporting and KPI tracking, enhancing KPI dashboards and data-driven decision making.

• Improved outbound shipment accuracy 11% using WMS-based planning, supporting inventory optimization and logistics optimization.

• Delivered procurement spend and logistics KPI reports via Excel dashboards, enabling data-driven decision making and supply chain visibility.

• Enhanced fulfillment reliability by aligning procurement, logistics, and finance workflows, improving S&OP coordination and end-to-end supply chain visibility.

EDUCATION

Master Saint Louis University, MO, USA

Bachelor Velagapudi Ramakrishna Siddhartha Engineering College, India

Contact this candidate