KPMG fields a multifaceted team to crystallize Encino Energy’s data and analytics solutions

The oil and gas industry faces especially complex data and analytics challenges marked by the sheer volume and varieties of data; integration from disparate systems, locations, and stakeholders; and the demands around real-time monitoring. On top of those complexities, Encino Energy had to build a new data and analytics capability in response to explosive growth.

To meet our client’s needs, KPMG assembled a team of specialists with deep knowledge and experience in areas including the oil and gas industry; leading business practices; Microsoft Azure; data integration; master data management; data governance; and Informatica, data engineers, data modelers, and Snowflake. We knew it would take all these capabilities combined with advanced technologies to unearth insights, use them to inform the design and creation of a new architecture, and plan and execute a master data management program tailored to Encino Energy.

Assess: Starting with a thorough assessment and building early stakeholder engagement

In order to align to our client’s business, data, and technology needs, we committed to a rapid, robust assessment. We worked closely with key stakeholders to understand their business and reporting needs and to engage them in the process from the start. Examining data sources, processes, and tools helped create a clear picture of the current state and informed the future vision.

Master MDM: Developing a master data management program

Encino Energy recognized that providing valuable, trustworthy data to downstream consumers would require an effective master data management program up front. 

KPMG helped to design, implement, and operationalize an MDM program that brings large volumes of data from multiple, disparate legacy sources into an Encino data hub powered by Informatica, Snowflake, and Microsoft Azure. This modernized platform allows Encino to institutionalize and efficiently apply data management and data governance standards, tools, and processes. The platform leverages automation to improve efficiency, increase accuracy, and ultimately build trust. 

KPMG worked alongside Encino Energy stakeholders to complete key activities, including the following:

• Defined business requirements for master data and prioritized implementation order
• Defined master entities by applications, primary and secondary SORs, precedence conditions, key master data elements, and business rules
• Helped achieve consensus on critical governing definitions, including well header attributes, levels in well hierarchy, Encino well lifecycle, unique well identifiers, and trusted sources for well data
• Created processes for defining quality, developing rules, managing scorecards, and cleansing data
• Defined data mastering rules across the well and land domains in terms of standardization, normalization, cleansing, and enrichment logic 
• Defined data mapping, including SOR table/data element to master data element maps; rules for matching merging, linking, deduplication, and transformation; and scoring logic 
• Established a data governance vision and mobilized a governance working group
• Developed a target operating model to formalize roles and responsibilities as well as define processes for managing and measuring data mastering, including at well header, well bore, and well completion levels
• Established a central repository, leveraging Snowflake, and implemented Informatica Enterprise Data Catalog to manage the business data glossary, facilitate business object searches, and capture meta data
• Provided end-user socialization, training, and feedback mechanisms.