Purchase and Supply Chain Engineer, Mitsubishi Electric, Bangalore, India
Nov, 2019 β Apr, 2022
Overview and KPIs achieved:
β’ Sole member responsible for entire factory import operations
β’ Handled 18 overseas suppliers and 4 domestic suppliers, encompassing above 2000 unique electrical and mechanical parts from 9 countries
β’ On-time Delivery Ratio - Increased from 86% to 99.7%
β’ Airfreight Cost - Reduced by 40%
β’ Cost Reduction - 6200 INR/elevator unit
β’ Used Excel, SQL, and Python to automate multiple processes and improve database management
Material Requirement Planning and Inventory Control:
β’ Created Standard Operating Procedures for handling imports with special emphasis on handling inventory for Phase-in / Phase-out parts
β’ Created order planning sheets and standardized monthly ordering process
β’ Contingency planning for post-pandemic strain on supply chain and inventory re-optimization considering the global semiconductor shortage and logistical disruptions
Supply Chain improvement and Costing:
β’ Improved frequency and accuracy of order forecasting
β’ Optimized ordering strategy and incoterms based on Lead-time changes
β’ Identified and targeted high cost-impact items for potential cost-reduction activities through ABC, Spend, and Pareto analysis
β’ Achieved Cost Reduction through Optimized Multi-sourcing, Value Engineering, and Competitive Pricing Negotiation
β’ Supported in localization activities, especially fasteners, terminals, wires, PCBs, cast iron parts
β’ Utilization of Dead Stock through Design changes
β’ Worked on packing improvements and supported logistics
Internal Operations improvement and Automation:
β’ Used SAP and Mitsubishi's ERP to handle bulk data and create automated custom databases using SQL and Python
β’ Automatized material requirement planning based on detailed study on Bill of Material and market projection
β’ Implemented poka-yoke to reduce man-hour wastage and develop standardized Lean operations.
β’ Root cause analysis and strategizing countermeasures to eliminate bottlenecks in the supply chain