GIDEON GIFTSON RAJ

Data Analytics:-

• Design and develop automated reporting system for analysis and audit purpose.
• Gathers and interprets relevant data (cost, quality, demand patterns, etc.) and provides analytical support.
• Develops and communicates periodic trend and performance reports on daily, weekly, monthly basis.
• Used advanced tools like Alteryx, Qlikview, Tableau, Access, Microsoft Forms and create automated report which provide insights for important decision making by top management.
• Created Macros to automate complicated analysis and to measure accuracy of performance.
• Automated repetitive operations using Robotic Process Automation (RPA).
• Worked in ODBC sources like Teradata, Oracle and SAP BI.
• Create dashboards for performance monitoring, and action decisions.
• Develop analysis frameworks to measure and evaluate Business impact.
  

Global Procurement:-

• Maintaining inventory at all 21 depots in North America.
• Release weekly, monthly and interim orders according to scheduled forecast.
• Procure parts from China, Brazil, England, South Africa, India, Thailand, Taiwan and deliver to North America.
• Work with freight forwarder and get shipment sailed and air lifted as per schedule.
• Track all in-transit shipments and monitor timely receiving.
• Work with packagers to get all parts booked and repacked according to packaging standards.
• Monitor distribution to all depots at North America and correct maldistributions in network.

Prototype Procurement \ BOM Maintenance:-

• BOM validation- Work with Product development engineers to identify list of parts required for prototype build.
• Identify suppliers for all requested parts and placing order in GPIRS.
• Tracking design changes and requirement timely and correcting BOM and orders.
• Liaise with logistics service provider and supplier to get parts on-time before MRD.
• Organizing Parts tracking meeting with Engineers and build team to address supplier concerns, part changes and Build plan changes.
• Maintaining system versus physical stock accuracy for effective production and planning.
• Communicating packaging standards and requirements to supplier for any unique parts.
• Analyze and release critical parts list according to plan change and highlighting it to top management.
• Handled B515(Ecosport) program for Cologne,Germany and successfully brought 87% of parts before MRD.
• Transition of overseas procurement jobs from US to India and provide fill rate from 67 % to 96% in 3 months.
• Transition of most complicated automation project and deliver better performance.

• Initiating purchase requisition and liaise with source for on time delivery and supplier rating.
• Coordinating with accounting department to solve payment issues (blocked invoices) with suppliers to avoid delivery on hold issues.
• Analyze and release critical parts list according to plan change.
• Managing supply chain operations of all Engines, Transmissions & Trim and chassis parts to meet production targets.
• Make reconciliation between system and physical stock in plant and perform root cause analysis in case of discrepancies.
• Established FIFO Control, Improved traceability of parts, Equipment planning & arrangement.
• Optimized layout and process planning of material flow in engine shop for reducing operation cost.
• Monitoring slow moving and obsolete parts and planning for alternate usage saving 45 MINR.
• Increased stock accuracy to 99.4%.(1500 MINR)