Overview -

An enterprise-wide data warehouse was developed by Nagarro to help a Swedish telecom major to convert its heterogeneous corporate data from legacy systems into an integrated, easy to use information system, to be used for strategic decision making.

Problem Description

Nagarro’s client needed a centralized data storage system for storing transactional data coming from multiple operational systems within the organization and some external source systems. It was also required to consolidate disparate data marts, and develop a centralized data warehouse for a common view of information for enterprise wide analysis and reporting. The client wanted that the enterprise data warehouse would supply the business with one single version of high quality information about the business. This would then be used for business intelligence, analytics and reporting to support the business requirements within all defined areas.

Solution

Nagarro followed a global delivery model to ensure timely and cost-effective development of the data warehousing solution. The team developed subject oriented data marts and loaded the client’s data into the centralized data warehouse after performing a comprehensive set of processing steps on the source data to cleanse, combine, structure and aggregate the data. Migration of all historical data was accomplished, which enabled the customer to decommission old legacy systems. Some specific features of the solution include:

• Extraction, transformation and loading (ETL) of data from multiple heterogeneous source systems was done using Informatica 8.6™.
• Common layers were designed to control the format (header/trailer), check quality, handle security and define contracts and service agreements on usage of data.
• Specially designed reports were generated using Business Objects XI™ which used the dimensional model to provide analytic view of the data.
• A set of metadata tables within the ORACLE™ environment were implemented which are used to keep track of all ETL processes to provide traceability from each data warehouse row back to the originating source.
• A number of Informatica performance tuning measures were implemented.

Benefits

• Provided a single platform for cleansing, collating and storing the data from diverse sources.
• Allowed for the conversion of raw data into strategic information – to allow decision support.
• Achieved significant cost saving and reduced risks using a global delivery model.
• Improved the performance and reliability of ETL processes to ensure data availability.
• Replaced legacy systems that were inefficient and costly to maintain.