DW/BI-&-Enterprise-Integration

shape
shape
shape
shape
shape
shape
shape
shape

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