Company Brief
This large IT company - With a 25-year track record and an operating footprint across North America, Europe and Asia-Pacific, is a global consultancy providing clients with value-based solutions across: Consulting, Application Outsourcing, Product Development Services , Business Process Outsourcing

Challenge

The Company has proposed a 3-Phase solution approach for the Business Intelligence Project solution for their management reports across the globe in the phase 1 and Project data datamart & integration of ETL with oracle apps application in the phase 2 & 3.

CP Solution

Performed the system requirement for the enterprise solution.
Created meeting summaries for all initial discussions with management teams
Created High Level Documents & Road Map for the complete solution
Developed POC (Proof of Concept) reports and Cubes to demonstrate the solution and the success process
Designed and Developed star schema based Data Mart
Designed & developed ETL mappings and data business rules validations
Designed and Developed Meta Data Model (using Cognos Framework model)
Designed & Developed Reports using Cognos Report Studio
Designed & Developed Cubes for Analysis using Cognos Powerplay
Did the integration of ETL with oracle apps application in the phase 2 & 3.
Environment: Windows XP / 2000, Cognos 8 BI – Report Studio & Analysis Studio, Powerplay, Modeling (Framework Manager), SQL Server 2005 Database / SSIS 2005 ETL Tool