Ministry of Petroleum & Natural Gas
Engagement Details
Primary Operations: India
Associated since: 2019
Service Type:
Development & Implementation
Service Model:
T&M
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.
Challenges:
- 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