Migrated a dated data warehouse structure and reporting system into an advanced, integrated, single-source transportation reporting system with advanced analytics for a global food manufacturing company.
About the Client:
Our client is a leading global food and beverage manufacturing company.
The objective was to migrate the transportation reporting system from a dated legacy data warehouse to the latest SAP Business Warehouse (BW), build an integrated data warehouse solution for ad-hoc analysis, create pre-defined reports, add advanced analytics and accommodate changes planned for OLTP systems
Designed and built the latest data warehouse with SAP BW, used SAP Business Explorer for reporting and published the reports in SAP Enterprise Portal
Designed and developed master data and hierarchy data extracts from Master Data Management
Designed and developed interfaces to send the consolidated data to downstream systems
Designed over 40 DataStage jobs to extract data from transportation systems into shipment planning, orders, tenders, executions, invoicing, accruals and payments business processes
Efficiently handled the large volume of data for highly analytical reports
Outcome and Benefits:
Created a single reporting system for all the transportation reporting
Identified inefficient routes and optimized the routing guide
Identified the cost by transportation linehaul, fuel & accessorial cost by SKU, and included the ability to roll up to k level and business unit using the Finance Product Structure
Improved the tender acceptance rate by carriers
Improved the unload and upload times for shipment orders
Optimized the cost per case/pallet/caw/gross/net lb. for transportation
Narrowed the gap between planned vs actual shipment costs
To find out more about how we can be your trusted analytics and planning partner, contact us today.
Please fill out the form to download the PDF. All fields with an * are required.