Data Warehousing & Business Intelligence solution for a global Energy companies merger.

A merger between global energy leaders each having disparate data sources including ERP and legacy systems.

Challenge

As a result of energy company merger, the requirement arised to integrate disparate data sources between both companies and provide seamless Reporting and Decision Support System (DSS).

Solution

• iGlades analysis indicated that data need to be extracted from the following operational data sources:
  • Mainframe
  • SAP R/3
  • Flat files
  • Oracle
  • XML
• iGlades designed a cloud-based Data Warehouse solution to deliver unprecedented analytical power to clients and merchants.
• iGlades succeeded in providing following capabilities to client:
  • Adhoc Reporting by business users
  • Standard reporting and distribution on flexible schedules
  • Analytics on Production, Revenue & Accounting (PRA), Supply Intelligence, Enterprise Intelligence and Check Write analytics.

Benefits

• Seamless Adhoc/Standard reporting - Business users gained capability to generate & distribute reports in near-real time.
• PRA Analysis - Business users gained insight into integrated Production, Revenue and Accounting (PRA) data.
• Customer Profitability - Data warehouse has facilitated to better analyze the merger's PRA activities and Supply Intelligence and Enterprise Intelligence.
• Decisions support systems - By leveraging this DSS system, client can review data and analyze production & Revenue in several Delivery Networks in near-real time.
• Business Drivers - Analyzing the data revealed the actual drivers behind Production, Delivery Networks and Revenues and helped the client gain a better understanding of the PRA helping the company make timely business decisions that have resulted in significant financial impact.

Technologies used:

• Data Warehouse - Amazon Redshift
• Data Integration (ETL): Talend 3.x
• Business Intelligence - Apache Spark 3.x, Hadoop 3.x