Case Study 1 : Hi Tech Manufacturing Unit

Backlog Automation

Solution Summary:

  • Automate the Process of deriving Expected date of Delivery of a Customer Shipment
  • Based on Shipment data and Planner Files

Process Overview:

  • Integrate with Shipment Tracking Tool - dbSchenker
  • Worked with a Different Sources of Data Files - Approx 10 Different Changing Sources of Data including Planner, Order, Shipment, Onhold Orders, Credit Holds, Online Shipment Trackers etc
  • Derive Various TAT’s

Technology Used:

  • Net, MS Access, VBA, SQL Server

Impact

  • Significant Automation of Process - GREEN Belt Program, Savings of 500K US$, 30 Hours to 30 Mins
  • Dashboards to Executive Management team using Power View, Advanced Excel