Case Study 1

Home / Case Study 1

Major Drug Company in Livonia, MI

Project Name: Freight Order Consolidation

Problem Statement/Purpose: Project aims to report orders which are shipped multiple times a day to the same location, this would help to consolidate all the orders and then ship through a single shipment resulting in a huge freight cost cutting

Approach:

  • Identifying all the freight source systems and building a data mart to pull the required data items.
  • Writing a SQL script to tune the data in accordance to the report requirement (Dashboard and Detail page)
  • Project involves complex calculations and security which are handled in framework model.
  • Shipping orders need to be reported based on the Eastern Time Cutoff (5:00 PM,6:00 PM) which would help warehouse manager to hold shipments at a cut-off time which provides maximum cost cutting

Business Value:  This project saved our client an approximately of $240,000/Year on freight charges.