Ministry of Petroleum & Natural Gas

Engagement Details

Primary Operations: India

Associated since: 2019

Service Type:
Development & Implementation

Service Model: 

Status: On-Going

Methodology: Waterfall

Scope/Challenges/Key objectives

Business Case:

In a quest for a robust data management system, the client initiated the process for advanced data analytics. The client expects a platform to be built to gather, filter, and present the data in a common format to ease the analysis process in order to develop and deploy advanced analytical dashboards.


  • Unorganized data from multiple sources
  • Needed critical attention on legacy as well as the newer pile of information.
  • Data security concerns
  • Data islands
  • Data duplication and other quality issues
Solution, Technical Environment, Benefits

Solution / Project Engagement:

  • Deployment of solution which allows the data upload of various formats by the stakeholders as per the access privileges
  • Executed ETL Activities for existing data sources from uploaded data for various division i.e., Demand, Supply, Marketing, Gas, Finance, PMUY,PMGKY etc.
  • Processing of data and performed various business rules to create reports
  • Create and build BI Reports
  • Automated Claim Report
  • Sanity Check While Data Upload
  • 20+ Analytical Dashboards

Technical Environment:

  • Apache Hadoop, SAS, Excel

20+ Analytical Dashboards

Automated Claim Report

Sanity Check while Data Upload

Reduced Time to process claims