Company Brief
This company is a Telecom Organization. This group, has a diverse business portfolio and has created global brands in the telecommunication sector.

Challenge

The Business Intelligence solution meant for catering to the information needs of Management team. The BI solution aims to provide single information view across the organization to present consistent information to all in organization i.e. “one version of truth”. The application aims to provide secured access to the data pertaining to Key Performance Indicators (KPIs) of the business, that are sourced (from multiple sources, which are both internal and external to the organization), massaged (applying the relevant business rules), stored, and reported in an user friendly manner to the management executives.
The Business Intelligence system would, besides catering to the above mentioned will provide adhoc report, dashboard, balance score card etc. linked to vision of the organization and system would provide functionalities like DSS (Decision Support System), advance analytics, workflow etc that can help the users to take timely decisions. BI solution shall also provide the client with planning, forecasting and budgeting tool, which will maximize productivity and performance at all levels of management

CP Solution

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 and Developed Meta Data Model (using Cognos Framework model)
Designed & Developed Reports using Cognos Report Studio
Designed & Developed Cubes for Analysis using Cognos Powerplay

Environment: UNIX / AIX, Cognos 8 IBM Edition for AIX, IBM DB2, Ascential Datastage