Business Problem: The existing Datawarehouse and the BI platform was not scaling to the ever increasing data volumes and required to optimized or migrated to a newer platform
Our Solution: The work involved understanding the current data integration framework developed using custom PL-SQL scripts and effectively migrate (re-write as parallel jobs in DataStage). The existing Datawarehouse in Oracle was also migrated to Netezza. The reporting infrastructure on Business Objects was reviewed and prototypes were developed in Cognos to demonstrate how to improve the effectiveness of the reports and better leverage the new warehouse.
Technology: Oracle 10g, Netezza, DataStage 8.5, Business Objects, Cognos 10.1.2