DW/BI-&-Enterprise-Integration


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.
Client Name
Global Energy and Trading Company
Category
Portfolio
Date
February 28, 2019