Case studies

Home Case Studies Major Drug Company in Livonia, MI

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.