About the Client:

Global Energy and Trading Company Under Top Fortune 20 company

Problem Statement:

Create centralized DW for management reporting for Traders, Credit Risk and Market Risk Analysts

Solution Provided:

• Integrated 20 different source system using ETL to make a centralized Data Warehouse
• Caters 4 different geographies from trading and risk management perspective
• Used SSIS/ Datastage as ETL tools and SQL Server as data warehouse
• 1 GB data growth every day
• Real time data integration with SAP

Highlights:

• Integrated 20 source systems
• SSIS/Datastage as ETL tool
• 1GB Data per day inflow in DW
• Real Time Integration with BizTalk

Benefits Delivered:

• A Consolidated summary of credit and market risk data for analysts.
• 40 different excels replaced from the system.
• Real time integration with SAP to get the payment information.
• Real time updates for traders regarding counterparty exposures.
• Traders across 4 geographies see the common credit and market risk.