About the Client:
Global Energy and Trading Company Under Top Fortune 20 company
Create centralized DW for management reporting for Traders, Credit Risk and Market Risk Analysts
- 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
- Integrated 20 source systems
- SSIS/Datastage as ETL tool
- 1GB Data per day inflow in DW
- Real Time Integration with BizTalk
- 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.
Global Energy and Trading Company
February 28, 2019