Rohit Lalwani

About Rohit Lalwani

Data-Driven Logistician | Project Execution Champion | Advanced Analytics Expert I…

Experience

1. Operations Analyst

   Aditi Consulting

   May 2024 — Present · Phoenix, AZ, US

   Contributed to the launch of Siemens’ $150M electrical manufacturing facility supporting U.S. data center infrastructure by optimizing supply chain operations, inventory planning, and vendor integration.• Onboarded 30+ domestic suppliers through SAP Ariba, automating approval workflows and ensuring compliance with procurement standards; reduced average supplier activation time by 22%, accelerating early-stage procurement.• Aligned supplier lead times and plant capacity with production forecasts using MS Project, enabling proactive resource scheduling and maintaining 95% adherence to planned production timelines.• Developed real-time freight tracking dashboards in Power BI to monitor delivery timelines, carrier performance, and cycle times across multiple 3PL providers, resulting in a 98% on-time delivery rate for critical equipment.• Analyzed freight data from SAP ERP (MM Module) and visualized trends in Tableau to identify high-cost lanes and improve routing decisions, achieving an 18% decrease in inbound logistics expenses resulted in savings of $0.5M.• Created a centralized inventory control model using Excel (Power Query, PivotTables, VBA) to track stock levels against construction schedules, improving inventory accuracy by 30% and reducing excess material.• Built a demand monitoring tool in Excel VBA to improve material flow and stock availability by 28%.• Applied Lean Six Sigma principles to redesign warehouse layoutinnt barcode-based inventory tracking, leading to a 35% reduction in overstock and a 40% improvement in receiving efficiency.• Consolidated KPIs from procurement, logistics, and production teams into weekly reports using Excel macros and SAP exports; these insights supported decision-making and helped reduce scheduling deviations by 30%.

Education

• A. P. Shah Institute of Technology, Thane

  Civil Engineering, design, drawing, estimation & costing

  2017 — 2021

• W. P. Carey School of Business – Arizona State University

  Master of Science - MS, Logistics, Materials, and Supply Chain Management