Supply Chain & Inventory Manager - SAP, Python

Sri Lakshmi sowjanya Bommisetty

Texas, USA +1-913-***-**** **********.************@*****.***

SUMMARY

Supply chain professional with 6+ years of experience spanning manufacturing, FMCG, pharmaceuticals, and beverages. Combine hands-on SAP inventory and production processes with Python, SQL, Power BI, and advanced Excel to turn operational data into practical planning decisions. Experience includes demand forecasting, inventory optimization, BOM consumption analysis, replenishment planning, and order-to-cash operations. Take ownership of inventory reconciliation, investigate the causes behind material variances, and work with production, purchasing, and warehouse teams to strengthen stock accuracy and material availability.

PROFESSIONAL EXPERIENCE

Supply Chain & Inventory Manager Texas Internal Pipe Coating, Texas, USA Feb 2026 - Present

• Own inventory control and material planning for manufacturing operations, aligning available stock, incoming supply, and replenishment priorities with production requirements.

• Support SAP implementation and adoption by aligning physical inventory practices, receiving records, and production consumption with system transactions.

• Manage SAP MM goods receipts, goods issues, and inventory postings, maintaining traceability between material movements and supporting documentation.

• Reconcile material issues against production orders through SAP MM and PP processes, investigating differences between posted quantities and reported consumption.

• Analyze actual consumption against bill of materials (BOM) requirements and production output; work with production teams to validate quantities and improve BOM accuracy.

• Evaluate demand trends and material requirements using SAP IBP and APO data to support supply planning, replenishment decisions, and production readiness.

• Use Python and SQL to analyze inventory and consumption data, identify exceptions, and assess stock coverage, safety stock, and reorder requirements.

• Develop Power BI and advanced Excel reports from SAP, WMS, and TMS data to track inventory balances, material availability, and supply chain performance.

• Lead daily inventory reviews, cycle counts, and month-end physical counts, reconciling warehouse quantities with SAP balances and documenting outstanding differences.

• Perform root-cause analysis of inventory discrepancies by tracing opening balances, receipts, production issues, and adjustments across reporting periods.

• Develop work-order-level consumption analyses and unit-usage comparisons to distinguish changes in production volume from changes in material efficiency.

• Assess inventory against upcoming production orders and expected consumption; flag shortages and communicate purchasing requirements before materials constrain production.

• Review weekly and monthly inventory trends with management, explaining consumption variances, stock risks, and the assumptions behind material forecasts.

• Establish material-requisition and usage-recording procedures, including documentation for partial and previously used materials, to strengthen transaction accuracy.

• Coordinate corrective actions with production, procurement, and warehouse teams, connecting discrepancies identified in reports with changes to day-to-day inventory practices.

1

PROFESSIONAL EXPERIENCE - CONTINUED

Supply Chain Planner / Analyst PepsiCo, Texas, USA Jan 2024 - Feb 2026

• Developed SKU-level demand forecasting models in Python using historical sales data from SAP IBP and POS systems, applying ARIMA and regression techniques to improve forecast accuracy by 18% and guide production planning across North America.

• Optimized safety stock levels and reorder points using Python libraries (SciPy, PuLP) on SAP APO inventory data, reducing excess inventory by 12% across 15 distribution centers while maintaining a 95% service level.

• Built automated Python ETL pipelines to extract, clean, and consolidate data from SAP IBP, SAP APO, WMS, TMS, and Excel, cutting manual reporting effort by 35% and ensuring reliable data for decision-making.

• Integrated SAP APO data with Power BI dashboards to monitor production schedules, inventory levels, and distribution metrics in real-time, enabling proactive adjustments to supply and demand.

• Designed transportation optimization models using Python linear programming, improving route planning and load efficiency, which reduced freight costs by 10% while meeting delivery commitments.

• Partnered with procurement and production teams to perform “what-if” scenario simulations in SAP APO and Python, modeling supply disruptions, demand spikes, and lead time variability to improve contingency planning.

• Created interactive Power BI dashboards to track inventory turnover, lead times, fill rates, and on-time delivery KPIs, automating data extraction and visualization to provide weekly executive-ready insights.

• Conducted detailed root cause analysis of shipment delays using SAP order and delivery tables (VBAP, VBRK, LIKP) and Python, implementing process improvements that increased on-time delivery by 15%.

• Led a cross-functional S&OP analytics initiative, combining SAP APO, WMS, and production data to inform seasonal demand planning, SKU prioritization, and production alignment decisions.

• Streamlined reporting and analytics workflows by integrating SAP data extraction, Python scripts, and Power BI visualizations, reducing manual reconciliation time by 40% and enabling near real-time operational monitoring. Supply Chain Analyst - Logistics & Distribution Hindustan Unilever Limited (HUL), India Aug 2020 - Apr 2022

• Planned and coordinated end-to-end logistics for FMCG products using SAP MM, SD, and WM modules, improving shipment scheduling and reducing lead times across five regional distribution centers by 12%.

• Developed SQL queries on SAP HANA to monitor inventory levels, batch movements, and stock reconciliation, identifying slow-moving SKUs and achieving a 14% reduction in operational carrying costs.

• Created dynamic Excel dashboards with PivotTables, advanced formulas, and VBA macros to track fleet utilization, delivery schedules, and warehouse throughput, reducing manual tracking effort by 20+ hours per week.

• Optimized delivery routes for 150+ trucks using SAP TM and Excel Solver, lowering fuel consumption by 8% and improving on-time delivery metrics.

• Conducted ABC/XYZ analysis of over 2,500 SKUs in SAP to prioritize replenishment of high-value items, reducing stockouts by 10% and improving working capital efficiency.

• Automated shipment tracking reports by integrating SAP SD tables (VBAK, VBAP) with Power Query, enabling faster, error-free reporting and enhancing weekly operational reviews.

• Led warehouse slotting and space utilization projects in SAP WM, reorganizing high-movement SKUs to streamline picking and packing, resulting in a 10% increase in order fulfillment efficiency.

• Worked closely with 3PL partners to monitor vendor compliance, track delivery accuracy, and analyze performance using SAP analytics, achieving 95% on-time delivery.

• Performed root cause analysis of recurring shipment delays using SAP LIKP and LIPS tables, implementing process changes that reduced delivery delays by 15%.

• Supported S&OP and regional distribution planning by preparing actionable insights from SAP reports, SQL-based inventory trends, and scenario modeling in Excel, enabling more informed supply chain decisions. 2

PROFESSIONAL EXPERIENCE - CONTINUED

Supply Chain & Order Management Analyst Accenture, India Jan 2019 - Jul 2020

• Oversaw order-to-cash operations for Pfizer’s vaccines and therapeutic drug portfolio using SAP SD, processing over 10,000 monthly orders across multiple distribution centers, which improved order accuracy by 20% and reduced cycle times by 15%.

• Developed and maintained SQL scripts to extract and consolidate data from SAP tables, providing actionable insights into inventory levels, backorders, and shipment trends across 5 DCs.

• Created automated Excel dashboards with PivotTables, Power Query, and VBA macros to monitor inventory and stock movements, enabling supply planners to identify potential shortages early and reduce stockouts by 12%.

• Conducted demand analysis using historical SAP MM and SD sales data, aligning production schedules with actual market demand, resulting in a 12% improvement in fill rates and a reduction of slow-moving stock by 8%.

• Performed ABC/XYZ classification of over 500 SKUs to prioritize high-value products, optimize warehouse allocation, and minimize expiry-related losses by 10%.

• Built Excel-based performance dashboards tracking lead times, backorders, and order fulfillment metrics, enabling supply chain managers to monitor trends and reduce delayed shipments by 15%.

• Monitored vendor compliance by analyzing SAP purchase order and delivery data, identifying underperforming vendors, and contributing to a 7% increase in on-time deliveries over six months.

• Supported S&OP and production planning meetings by preparing standardized reports in SAP SD and Excel, delivering clear insights on inventory, orders, and forecast alignment, which improved reporting efficiency by 25%. CORE SKILLS

Supply Chain & Operations: Demand Planning, Supply Planning, Inventory Optimization, Procurement Analytics, Order Management, Forecast Accuracy, Capacity Planning, Budgeting and Scheduling, Sales & Operation Planning (S & OP), Replenishment Planning

Inventory & Production Control: BOM Analysis and Validation, Inventory Reconciliation, Cycle Counting, Physical Inventory, Production-Consumption Analysis, Goods Receipts and Goods Issues, Material Requirements Planning (MRP), Material Traceability

Data Analysis & BI: Data Cleaning & Transformation, Trend Analysis, Root Cause Analysis, KPI Dashboards, Variance Analysis, Cost-Benefit Analysis, Scenario Modeling, ABC/XYZ analysis ERP & SCM Systems: SAP MM, PP, SD, WM, APO, SAP IBP, WMS/TMS, Oracle NetSuite, JD Edwards, Microsoft Dynamics 365, Infor SCM, Blue Yonder (JDA), Kinaxis RapidResponse Programming Languages: Python (pandas, NumPy, matplotlib), SQL (T-SQL, PL/SQL) Forecasting & Modeling: Time Series Forecasting, Regression Analysis, Monte Carlo Simulation, Optimization Models, Inventory Forecasting, Linear Programming

Business & Financial Analysis: Cost Analysis, Budget Forecasting, Working Capital Optimization, Spend Analysis, Supplier Negotiation Metrics, Profitability & Margin Analysis Reporting & Documentation: Power BI Dashboards, Tableau Storytelling, Excel Reports (Advanced Formulas, Pivot Tables, VBA Macros), Business Requirement Documents (BRDs), Standard Operating Procedures (SOPs), Data-Driven Presentations Methodologies: Agile (Scrum), Waterfall, Lean Six Sigma (Green Belt), DMAIC, Kaizen, Value Stream Mapping Business Analysis: Jira, Confluence, MS Project, SharePoint, Cross-functional Team Collaboration, Vendor Coordination, Stakeholder Reporting

EDUCATION

Master of Science in Computer Science

Campbellsville University, Louisville, KY, USA

Bachelor of Technology in Civil Engineering

Jawaharlal Nehru Technological University, Kakinada, Andhra Pradesh, India 3

Contact this candidate