Synergy 4 Master Data Management

(1)

(2)

Synergy 4 Business

A large and growing business community, creating and maintaining a library of valuable business solutions, built

(3)

Synergy completes the picture by providing a higher level of

connectivity to organizations, bridging gaps, driving

performance efficiencies, and optimizing business processes.

• Improved Productivity

• Increased Revenue • Reduced Costs

One Organization. One Truth.

(4)

Executive

Financial

Employees

Operational

Base strategy on solid, reliable business information Provide trustworthy compliance reporting

Increase productivity throughout the business Reduce bad decision-making

Improve forecasting accuracy Streamline business cycles

Improve revenue completeness Avoid costly mistakes

Reduce analytic churn

(5)

(6)

Synergy Evolution

: Well MDM

Well Audit > UWI Matrix

data profiling, matching, alignment, grouping

WellSync > Well Asset Management

uwi & list validation, entitlements analysis

Corporate Well Repository

(7)

Some form of MDM is a required foundation for enterprise BPM and BI initiatives

(8)

A consolidated view of company data assets, and

a consistent method of aggregating and distributing a “source of truth”

ensure that data is managed, cleansed, stored and delivered according to company policies, guidelines, and governance specifications

What is

Master Data Management

The technology, tools, and processes required to:

Create and maintain consistent and accurate master data across business domains

Maintain a current, centralized repository of validated asset and attribute information

Publish current and accurate data to all company departments, processes, and data sources

Reduce the workload by eliminating inconsistencies and errors in the master data

Design and implement a consistent unified view of assets and related activities

(9)

source

data not cleaned or managed properly

integration

data sources not integrated properly

user

users introduce errors

analytics

reporting and analytics applications

security

access to information not controlled properly

source : Aberdeen Group, September 2009

(10)

By the end of 2012, 50% of Master Data Management implementations will be regarded as failures*

Cost of Bad

Master Data Management

*source : Accenture, June 2009

lack of business-oriented approach

high start-up costs of MDM software and services process becoming politicized

increasing budgetary concerns many vendors systems immature organizations reinventing the wheel

(11)

Automation. Automation. Automation. Benefit from work of industry peers

Avoid cost by using a proven foundation

Opportunity

Reduce labor intensity. Leverage existing low-cost alternatives. Adopt proven practices.

(12)

Automation

Actions

Sequences

Workflow

Get Sort Filter Join Transform Send Notify UWI Matrix Hierarchy Matrix WI Matrix Well Audit

Corp Well Admin

Lifecycle Process - RTD Change Management Process

(13)

(14)

FINANCE ^ ^ ^ > > > < < < v v v DRILL FIELD PA AFE LAND RESERVES PPDM ^ ^ ^ > > > < < < v v v

(15)

Synergy accesses multiple industry data sources “out of the box”

Databases & spreadsheets of assets & attributes Enterprise ERP, CRM systems, LDAP directories Finance, Operations, and other business systems Industry data pools and 3rd party systems

Public Petroleum Data Model

(16)

Data Services

Divestco Data G1 PPDM

GeoLogic Data Hub Geoscout Data

IHS Data Hub IPL Data Hub QCData Hub Enterprise Services Active Directory AutoCAD LDAP MicroStation Onbase

Connected

Data Sources

Field Data FieldView PVR Finance Axapta Envision JV Nexus Powervision PWSQL QByte FM Land CS Explorer GeoNexus LandMan LandRite Operations AFE Navigator Budget EDI FITS Jiffy JOSA JOMA Mosaic OpenWells Peep Portfolio Value Navigator WellTracker WellTrax WellView WellPoint Prod Accounting Avocet Pace Petronet Prism QByte PA Triangle XI Resource Planning JD Edwards Oracle SAP Various Excel Ultimus

(17)

Industry

Master Data

MASTER DATA

FA PA

FIELD

DRILLING _RESERVES LAND

AFE

PPDM

Data describing business entities that span systems Key data-point relationships between systems

(18)

MDM

Registry

(19)

MDM

Repository

(20)

Approach

Analyze: contents and dispositions of target systems

Optimize: fill gaps, rebuild relationships, and manage exceptions Control: process to maintain consistency and accuracy

(21)

Major Phases

Standardize the approach and improve the output Support different MDM approaches

(22)

Data Source

Profiling

Profile Assess Source Enrich Monitor

Connect databases, spreadsheets, lists, text files

Identify key elements & relationships

Generate key matrices & audit reports

(23)

(24)

Seeding

UWI Records

All UWI’s Land UWI Matrix Reserves Production Field Finance PPDM UWI 100102808808W500 System CS Explorer File Status Active Well Status Producing

Corporate Well Repository

SAMPLE INPUT DATA SOURCE INPUT DATA

(25)

(26)

(27)

Data Quality

Assessment

Utilize generated key lists to query attributes

Identify naming and formatting issues

Identify wrongly coded and categorized data Find missing values, errors, & exceptions

(28)

Data Quality

Assessment

Battery Code Commingled Confidential Status Cost Centre Event Status Facility Operator Field Code Ground elevation Hierarchy KB Elevation Lahee Class

Last Production Date License Date License Number Licensee On Production Date Pool Code Producing Zone Rig Release Date Spud Date

Total Depth

True Vertical Depth Well Fluid

(29)

(30)

Data

Sourcing

Mine connected systems to identify fix candidates

Cross reference groupings/categorizations/hierarchies Apply conditional logic to address inconsistencies

(31)

(32)

Cross Reference

Formations

Land SLAVE PT. Land Formations Land System MDM Repository PPDM

Public SLAVE POINT FM Public Formations

SLAVE POINT SLAVE POINT FM Matched Formations

Unmatched Formations

(33)

Data

Enrichment

Persist validated candidates

Format & structure entries > fill gaps

Provide reconciliation reports & tools > audit Transform unstructured > structured

(34)

(35)

Unstructured >

Structured

File M-00283

Sub C

Fluid PNG From Bound Top

From Form Surface To Bound Base

To Form Slave Point FM Unstructured Mineral Rights

Land System

MDM Repository Structured Mineral Rights

(36)

(37)

Data Source

Monitoring

Scheduled checks for data consistency & quality

Monitor system relationships and interdependencies

Notify systems and stakeholders of alarm conditions Trigger monitor reports from update processes

(38)

(39)

Responding

to Business Challenges

Challenge Response

lack of business-oriented approach self-funding - business value first, last,

always

high start-up costs of software and services

lowest total cost of ownership in industry - bar none

process becoming politicized users interact with products, not

concepts or definitions

increasing budgetary scrutiny scope. commit. deliver.

many vendors systems immature proven in large group of industry peers

organizations reinventing the wheel leverage existing connections,