Designed and implemented procurement planning workflows integrating SAP MM with supplier performance dashboards in Power BI, improving OTIF and reducing stockouts by double digits.
Naveen Konada
I help manufacturing and distribution teams cut stockouts, improve OTIF, and optimize inventory using SAP, SQL, Python, and Power BI.
4+ years • SAP S/4HANA, IBP, MM, Ariba • SQL, Python, Power BI • experience across India & USA
alt="Naveen Konada portrait"
/>
I've led projects that improved OTIF by 9–11%, reduced stockouts by 10%+, increased inventory turns from around 4.8 to 7.1, cut freight cost per unit, and eliminated excess and obsolete inventory—partnering closely with planning, procurement, finance, and operations teams.
Data-Driven Decisions
Using SQL, Python, and BI tools to translate noisy operational data into clear, actionable insights for planners and leaders.
Cost & Inventory Optimization
Balancing service levels, working capital, and logistics cost through smarter MRP tuning, safety stock, and supplier strategies.
Global & Cross-Functional
Experience across India and the U.S., collaborating with procurement, planning, logistics, and finance teams to ship real solutions, not just dashboards.
Supply Chain Planning & Optimization
- SAP S/4HANA & SAP MM (materials & purchasing)
- SAP IBP (demand & supply planning)
- Inventory optimization, MRP, safety stock & ROP
- Procurement, supplier management, PPV analysis
- Production & material planning across plants/DCs
Data Analysis & Visualization
- SQL (joins, CTEs, window functions)
- Python (Pandas, NumPy, time-series forecasting)
- Power BI & Tableau (data modeling, DAX, dashboards)
- Advanced Excel (Solver, pivots, VLOOKUP/XLOOKUP)
- Data storytelling & KPI design for stakeholders
Process Improvement & Project Management
- Lean Six Sigma (Green Belt), DMAIC, Kaizen, RCA
- Value Stream Mapping & process redesign
- FMEA, OTIF tracking, continuous improvement
- Cross-functional workshops & stakeholder alignment
- Documentation, SOPs, and training materials
Optimized MRP parameters including safety stock, MOQ, and reorder points across multiple materials, improving forecast accuracy and increasing inventory turns while maintaining service levels.
Developed a supplier allocation model to optimize cost, MOQ, and lead time, demonstrating a significant improvement in procurement profitability and cycle time.
Modeled multi-period production, inventory, and facility location decisions to maximize profit under capacity and demand constraints, supporting long-term network design choices.
Built a supplier performance and freight analytics scorecard in Power BI using OTIF, lead time, defect rate, and cost metrics to identify under-performing vendors, improve delivery reliability, and support negotiations.
- Designed procurement planning workflows integrating SAP MM with supplier performance dashboards in Power BI, improving OTIF by 9% and reducing stockouts by 11%.
- Conducted PPV analysis and negotiated supplier contracts, reducing procurement spend by $450K annually through data-driven supplier selection.
- Optimized MRP parameters, improving forecast accuracy by 8% and increasing inventory turns from 5.2 to 7.1 cycles per year.
- Applied Lean and RCA to remove supply bottlenecks, reducing lead time by 5.6 days per shipment.
- Automated 3-way match using SQL-based reporting, cutting reconciliation time from 6 days to 2 days.
- Improved forecast accuracy by building Python time-series models, reducing MAPE from 22% to 8% across five business units.
- Managed raw material procurement using SAP APO, reducing working capital by 12% while improving material availability by 16%.
- Implemented vendor scorecards & freight dashboards, improving OTIF from 84% to 93% and reducing freight cost per unit by 7%.
- Eliminated ₹6.3 crore of idle stock via SQL-based E&O inventory audits, increasing turns from 4.8 to 6.4.
- Automated invoice & PO reconciliation via SQL scripts, cutting 3-way match time by 35 hours monthly.
- Supported daily procurement via SAP MM, including vendor onboarding, PO creation, and logistics tracking, improving vendor compliance to 97%.
- Automated Excel-based approval workflows, reducing invoice processing time from 10 days to 4 days.
- Partnered with logistics & finance to optimize freight routing, reducing per-unit transport cost by 6%.
- Built Power BI dashboards to monitor lead times, supplier performance, and procurement KPIs for 250+ POs.
Certifications: Six Sigma Green Belt (IISE) · Supply Chain Foundations: The Essentials (CSCMP).
I'm actively open to full-time Supply Chain & Analytics roles – including Supply Chain Analyst, Procurement / Inventory Analyst, Material Planner, and Operations / Supply Chain Analytics roles.
I enjoy working on problems around MRP tuning, inventory optimization, supplier performance, and logistics cost reduction—anywhere data and process improvement can move the KPIs that matter.