Case Study
Solution For Data Warehouse Management System
CALL US 24/7/365 972-831-7400 www.pmam.com CASE STUDY SOLUTION FOR DATA WAREHOUSE MANAGEMENT SYSTEM Case Study SOLUTION FOR DATA WAREHOUSE MANAGEMENT SYSTEM PMAM Corporation 2 Client – NasdaqGS: AGII listed Insurance Group with offerings in Specialty Insurance. Problem Statement Our client grew inorganically and acquired several businesses and as result inherited multiple applications and databases that were required to be maintained by their IT department. They required a solution to: a. Create a single database to which data from all business units get fed. b. Design a solution to eliminate dependency on multiple databases and have a single DWH for further processing. c. To get rid of several data file format li