Sara Lee

Metaphor Technologies is retained for the Analytics project at Sara Lee Corporation in Chicago, IL to build a Data Mart. The purpose is to import facts exported from SAP and Manugistics to veryfy compliance of their Inventory and Planning with previously set goals.

The project is critical to control distressed inventory which will ultimately result in costly distress sales, donations, and tanking of goods. Metaphor Technologies designs the data mart, ETL via SSIS packages, and extensive report generation through SSRS.

The project is particularly interesting from a Business Intelligence perspective with comparing data for various financial periods along a 5-4-4 fiscal year calendar.