Akshay Garg

• Worked on inventory optimization for HVAC components using demand planning techniques, collaborating with Supply Planning, Procurement, and IT. Facilitated requirement workshops, mapped current processes, and documented planning logic and SOPs in Confluence for standardization. • Performed ABC/XYZ segmentation on SKUs using SAP S/4HANA and SQL. Collaborated with Master Data and Inventory Control teams. Ensured data quality, validated logic, and documented methodology in SharePoint for cross-team transparency. • Improved forecast accuracy by 22% for moving averages and trend decomposition. Integrated inputs from Sales, Marketing, and Finance. Maintained forecasting models, assumptions, and process flows in Confluence and Jupyter. • Calculated safety stock and reorder points using demand variability, service level targets, and supplier lead times. Built Excel models using Power Query, VBA, and solver. Partnered with Operations and Procurement. Documented assumptions and workflows. • Developed Power BI dashboards to monitor stock aging, inventory turns, and forecast KPIs. Partnered with BI and Finance teams for metric alignment. Automated reporting processes and maintained dashboard update SOPs in OneDrive and Confluence. • Enabled 18% excess inventory reduction while maintaining 95% service levels. Conducted root cause analysis, facilitated crossfunctional reviews, and implemented corrective actions. Used Lean principles, visual boards, and continuous improvement logs to track and document changes.

• Directed weekly production schedules by aligning demand, capacity, and material availability, boosting throughput 12%. Facilitated Tier 4 cross-functional planning meetings to resolve conflicts, resulting in an 18% increase in on-time delivery performance. • Analyzed forecast data to optimize wafer fab capacity, improving yield efficiency by 9%. Managed finished goods inventory, cutting excess stock by 15%, which lowered annual holding costs significantly. • Coordinated shipment plans to meet manufacturing and customer need, achieving 98% on-time fulfillment. Led ERP forecasting improvements, reducing forecast errors by 22% through data-driven process enhancements and collaboration across teams.

• Operated on Demand Forecasting and Inventory Optimization for EV partsincluding battery packs BLDC motors controllers and chassis frames to improve planning accuracy across plants through cross-functional collaboration and data gathered from ERP and CRM. • Analyzed months of demand data using Python and SQL to identify consumption trends of EV parts with SAP IBP and S/4HANA integration supporting real-time planning decisions across procurement warehousing and production departments. • Used supply chain methods like moving average forecasting EOQ safety stock and seasonal demand profiling within Excel and SAP MM to optimize inventory levels and align replenishment strategies with real-world delivery and maintenance cycles. • Created a live Tableau and SAP Fiori dashboard to monitor inventory turnover service levels lead times and stock aging with data sourced from SAP BW and structured for weekly updates using Excel and SQL outputs. • Performed ABC and XYZ inventory segmentation in Excel and SAP BusinessObjects to classify components by usage variability and cost prioritizing planning efforts and reducing stock imbalances for high-value and high-rotation parts. • Achieved 30% stockout reduction 22% forecast improvement and 15% working capital savings with documentation maintained in Confluence reporting done in Excel and collaborative process tracking using Jira and SharePoint systems.

Relevant Coursework: Business Analytics, Lean Six Sigma, Project Management, Engineering Economics, Statistics for engineers, Entrepreneurship