Ketan Gaikwad

• End-to-End Shipment Tracking: Used WMS to track all shipments from warehouse to final delivery. Identified bottlenecks and reduced delays by 33%. • ETL Data Processes: Built SQL-based ETL pipelines to integrate logistics and sales data from various sources. Prepared data for demand planning models. • Demand Planning: Collaborated with the demand planning team to analyze sales forecasts and current inventory. Reduced overstock through improved planning.

• Out-of-Stock Reduction: Analyzed sales data and reorder cycles to identify root causes. Improved order logic and reduced out-of-stock situations by 14%. • Dashboard Development: Built Power BI dashboards for the company to monitor daily inventory levels, delivery times, and supplier performance. • Safety Stock Optimization: Calculated safety stock levels based on demand and lead times to reduce overstock and delivery issues.

• SAP ERP: Supported the entire procurement process in SAP MM from purchase order to goods receipt. Ensured a stable material flow. • Logistics & Transport: Coordinated transports. Planned deliveries based on warehouse data and reduced transport costs through negotiations with freight forwarders. • Inventory Control: Conducted stock counts and inventory checks in SAP. Achieved inventory accuracy of over 98% and reduced slow-moving items.