MDM PROJECT BEST PRACTICE INFORMATICA DAY 4 TH JUNE Presented by Arhis and EDF

(1)

| 1

Presented by Arhis and EDF

MDM PROJECT BEST PRACTICE

(2)

| 2 ©www.arhis.com 2014

AGENDA

1. Presenting Arhis

1. Arhis presentation and value proposition 2. Arhis MDM projects approach.

3. Arhis MDM Factory

4. Energy domain MDM implementation

2. Presenting EDF Business case

1. Presenting EDF

2. EDF Hydro Generation 3. PRERHY Project

4. Project scope and achievements

(3)

ARHIS VALUE PROPOSITION

A SWISS LEADER IN THE MDM FIELD !

Our focus is Master Data Management

 Arhis is a clear leader in the MDM implementation space since its creation with more than 30 success stories

Capitalizing on Best Vendors solutions

 A unique expertise on key vendors solutions (Informatica)

 A value-added offering with a team of highly qualified MDM Hub engineers

 Implementation best practices combined with a proven MDM project methodology.

Our value proposition : Customer Satisfaction at a reasonable Total Cost of Ownership

 Speed of execution

 Reliability in quality and delivery

 Strong commitment

(4)

ARHIS : A STRONG MDM EXPERTISE

(5)

ARHIS : MDM PROJECT APPROACH

PHASED, ITERATIVE APPROACH USING INFORMATICA AND ARHIS TOOLS

“Agile” Iterations

ARHIS Factory

(6)

ARHIS MDM FACTORY

BEST PRACTICES AND ACCELERATOR TOOLS

Methodology and Skills :

Factory Concepts have proven to work in large projects

Arhis has delivered MDM Vanilla in less than 2 months

100 screens , 80 base objects

Tools :

Schemagen concepts adopted by EDF and large customers as

Arhis methodology

Datagen intensivelly used for data generation (Tests)

SiFTester WebService Framework deployment accelerator

Reusable Components shapes :

(7)

MDM IMPLEMENTATIONS OPTIONS

(8)

ARHIS : MDM IN THE ENERGY SECTOR

VERY CENTRALISED HYBRID STYLE MDM IMPLEMENTATIONS

System live (Q2 2014)

Live by Q4 2014

Zurich Informatica day 2013

“GRT Gaz owns and operates

the

largest

High

Pressure

Natural

Gaz

network

in

Europe”

This year we present :

“A world leader in electricity”



Hybrid



Very Centralized

(9)

EDF PRERHY

Informatica Day

(10)

| 10

EDF: A GLOBAL LEADER

IN ELECTRICITY

 We are a world leader in electricity

Covering all activities: generation (from nuclear to renewables), networks, sales and trading

 We are an international group

With roots in Europe and long-term partnerships and cooperation agreements in high-growth countries

 Key Figures :



€72.7 billion

in sales



39.3 million

customers



159,740 employees

worldwide



84.7% of generation does not emit

CO₂

(11)

| 11

EDF: AN INTERNATIONAL GROUP

(12)

| 12

EDF: ELECTRICITY GENERATION IN FRANCE

EDF PRERHY - Informatica Day - june 2014

 Generation :

 Nuclear: safety reinforced, Flamanville EPR to generate its first TWh in 2016  Hydropower: SuperHydro renovation program 73% (2012 results) completed and

RenouvEau project being deployed

(13)

| 13

EDF: HYDRO GENERATION IN FRANCE

2 700 MW 7 600 MW 2 500 MW 2 600 MW 4 600 MW

 DPIH (Direction of HydroPower Engineering & Generation) :  4 800 employees

 5 Generation Units (Est, Alpes, …)  2 Engineering Units (CIH, DTG)

 447 power plants , 1 200 generators

 From 100 kW to 1 800 MW • 10% > 100 MW (50% of total) • 50% < 12 MW (10% of total)  640 dams , 3 500 valves  1 500 km galleries  270 km penstocks

 Among them 100 are operated remotely

(14)

| 14

PRERHY PROJECT : CONTEXT & STAKES

 PRERHY : « Projet de REnovation du Référentiel des moyens de production de

L'HYdraulique »

 Renovation of the Hydropower Generation Assets Frame of Reference

 CONTEXT : Several changes have significant impacts on DPIH organization :

 Deployment of the RenouvEau renovation program : • Strong evolution of hydropower generation business processes

• Supported by a big effort to modernize the information system

 Increase of regulatory constraints (safety)

 A lot of hydro concessions to be renewed during the next years

 STAKES : Governance of Master Data identified as a key success factor

 To keep a strong knowledge of the generation portfolio

 To validate and share master reference data among all stakeholders, from engineering

to generation teams

(15)

| 15

PRERHY: OBJECTIVES & MDM PROJECT

 OBJECTIVES :

 Overhaul of the repository of hydropower generation assets description • Extension of the depth of assets description

• Evolution to become master of data on its scope of data

 Initialize master data values with a quality level sufficient to be recognized as the truth

 Set up the master data governance organization at the DPIH level  MDM Project :

 New « DoReMHy v3 » application will be based on a MDM solution :

• In March 2013 , EDF has selected Informatica MDM Hub with BPM ActiveVOS option

• Use of ETL PowerCenter and Informatica Data Quality

 Project plan has an iterative roadmap to implement business objects, services and

interfaces

 On going : 1st iteration, (version) to be deployed in production end of 2014  3 iterations scheduled until end of 2015

(16)

| 16

PRERHY: ESTIMATE OF KEY FIGURES

 31 Business Objects , classified into 19 « Categories »

 290 Attributes , up to 45 attributes per Business Object

 21 DataBases as source or / and target

 <= 100 000 records with an estimate of 10% renewal per year

 Potential Declared Users at the end of the project :

 10 Administrators (business)  50 Data Stewards

 1 000 Users with ability to create, modify, validate master data  Up to 4 500 Users in consultation

(17)

| 17

PRERHY : ITERATIVE MDM IMPLEMENTATION

(18)

| 18 EDF PRERHY - Informatica Day - june 2014

(19)

| 19

ACHIEVEMENTS : P1 DELIVERED IN DUE TIME !

ITERATION 1 = P1 + P2

Bugs Fixing P1 Documenta tion delivery Ta k e O v e r Business Rules Match and Merge Rules

Tests Prep HUB Model Technical Acceptance Périmètre 1 IDD _Model Tests Prep Input / Output Flows Tests Prep MDM HUB UI FLOWS

Nov 1 Nov 2 2013Dec 1 Dec 2 Jan 1 Jan 2Année 2014Fev 1 Fev 2 Mars1

Project Management

Architecture and technical coordination

START End 2 End End 2 End End 2 End IDD Configuration Customization Presentation of « Vanilla» IT acceptance tests

EDF Package Installation

Installation Packages Mars2 2014 End of March

P2 Start

P1

(20)

| 20

ACHIEVEMENTS ITERATION 1 – PART 1

DV3

P1

Around sixty base objects tables

More than sixty rules to implement between the ETL (Powercenter) and MDM HUB

Complexity of datastewardship controls, cardinalities, cleansing,

A rich User Interface

(21)

| 21

NEXT STEPS

1. FINISH P2 - ITERATION 1 CONSTRUCTION

2. GET IT ACCEPTANCE FOR P2 (END OF Q2)

3. GET USER ACCEPTANCE (Q3)

4. GO LIVE (Q4 2014)

5. ITERATION 2, 3 , … (2014, 2015…)

(22)

| 22

Q&A

THANKS FOR YOUR

ATTENTION !

[email protected] [email protected]