Process Mining for Component Management in EUROCLEAR 2017-2018 - - PowerPoint PPT Presentation

Process Mining for Component Management in EUROCLEAR

2017-2018 ACTIVITIES

Pr Process Mining Exercise

TO GO- NOT TO GO ?

OBJECTIVES MEANS TO REACH OBJECTIVES COST-BENEFIT EVALUATION

Be Bene nefits of Process Min inin ing exercis ise for Stakehold lders Business

• Checking Conformity
• KPIs : Versioning and Durations
• Outliers analysis
• Continuous Monitoring via Dashboard
• Learning and on-boarding Process

Mining for daily routine workflow Audit

• Continuous Auditing
• Assessment of complexity in real life
• Awareness of risks and control gaps
• Inefficiencies
• Major credibility with the audited

business

• High impact visualisation of findings

Bus Busine ness Ba Background: und: Co Compo pone nent & Data Ma Management

• Component and Data Management: part of ADM

Division (Delivery Excellence Department)

• Endevor: also known as CA Software Change

Manager is a set of tools used to automate, control, and monitor the mainframe software development life cycle

• Software Configuration Management aims at

pushing components of the software from one environment to another when a required level of maturity of the code is reached. We are speaking

• f ‘promotion’ of the component step by step

toward production stage.

Wh What kind of process we have? So Software Configuration Management Lifecycle Map

T T T T T T T T T

Wh What kind of data we have?

• Sample data snap

Wh What kind of data we ha have?_candi ndida dates fo for case ID

• Sample data snap

PKG ID BEGIN EXEC DATE BEGIN EXEC TIME END EXEC DATE END EXEC TIME SYS NAME (S) SYS NAME (T) TYPE NAME (S) STG ID (S) STG ID (T) ELM (S) ELM (T) BO2G170321001 21/03/2017 10:13 21/03/2017 10:13Stream2 Stream2 COB O B BVL0020 BVL0020 BO2G170321001 21/03/2017 10:13 21/03/2017 10:13Stream2 Stream2 COB O B BVL013 BVL013 BO2G170321002 21/03/2017 10:18 21/03/2017 10:18Stream2 Stream2 COB O B DWB858 DWB858 BO2G170321002 21/03/2017 10:18 21/03/2017 10:18Stream2 Stream2 COB O B ETL0020 ETL0020 BO5G170320001 20/03/2017 10:01 20/03/2017 10:02Stream5 Stream5 COB O B ETL0020 ETL0020 BO5G170320002 20/03/2017 16:35 20/03/2017 16:35Stream5 Stream5 COB O B DWB858 DWB858 BO6G170320001 20/03/2017 13:14 20/03/2017 13:14Stream6 Stream6 COB O B DWB858 DWB858 BO6G170320002 20/03/2017 15:00 20/03/2017 15:00Stream6 Stream6 COB O B DWB858 DWB858 BO6G170321001 21/03/2017 12:00 21/03/2017 12:00Stream6 Stream6 COB O B ETL0020 ETL0020 DB2G170321001 21/03/2017 10:15 21/03/2017 10:15Stream2 Stream2 COB B D BVL0020 BVL0020 DB2G170321001 21/03/2017 10:15 21/03/2017 10:15Stream2 Stream2 COB B D BVL013 BVL013 DB2G170321002 21/03/2017 10:19 21/03/2017 10:19Stream2 Stream2 COB B D DWB858 DWB858 DB2G170321002 21/03/2017 10:19 21/03/2017 10:19Stream2 Stream2 COB B D ETL0020 ETL0020 DB5G170320001 20/03/2017 10:02 20/03/2017 10:03Stream5 Stream5 COB B D ETL0020 ETL0020 DB5G170320002 20/03/2017 16:36 20/03/2017 16:36Stream5 Stream5 COB B D DWB858 DWB858 DB6G170320001 20/03/2017 13:15 20/03/2017 13:15Stream6 Stream6 COB B D DWB858 DWB858 DB6G170320002 20/03/2017 15:00 20/03/2017 15:01Stream6 Stream6 COB B D DWB858 DWB858

Wh What kind of data we have? _candidates for time stamp

• Sample data snap

PKG ID BEGIN EXEC DATE BEGIN EXEC TIME END EXEC DATE END EXEC TIME SYS NAME (S) SYS NAME (T) TYPE NAME (S) STG ID (S) STG ID (T) ELM (S) ELM (T) BO2G170321001 21/03/2017 10:13 21/03/2017 10:13Stream2 Stream2 COB O B BVL0020 BVL0020 BO2G170321001 21/03/2017 10:13 21/03/2017 10:13Stream2 Stream2 COB O B BVL013 BVL013 BO2G170321002 21/03/2017 10:18 21/03/2017 10:18Stream2 Stream2 COB O B DWB858 DWB858 BO2G170321002 21/03/2017 10:18 21/03/2017 10:18Stream2 Stream2 COB O B ETL0020 ETL0020 BO5G170320001 20/03/2017 10:01 20/03/2017 10:02Stream5 Stream5 COB O B ETL0020 ETL0020 BO5G170320002 20/03/2017 16:35 20/03/2017 16:35Stream5 Stream5 COB O B DWB858 DWB858 BO6G170320001 20/03/2017 13:14 20/03/2017 13:14Stream6 Stream6 COB O B DWB858 DWB858 BO6G170320002 20/03/2017 15:00 20/03/2017 15:00Stream6 Stream6 COB O B DWB858 DWB858 BO6G170321001 21/03/2017 12:00 21/03/2017 12:00Stream6 Stream6 COB O B ETL0020 ETL0020 DB2G170321001 21/03/2017 10:15 21/03/2017 10:15Stream2 Stream2 COB B D BVL0020 BVL0020 DB2G170321001 21/03/2017 10:15 21/03/2017 10:15Stream2 Stream2 COB B D BVL013 BVL013 DB2G170321002 21/03/2017 10:19 21/03/2017 10:19Stream2 Stream2 COB B D DWB858 DWB858 DB2G170321002 21/03/2017 10:19 21/03/2017 10:19Stream2 Stream2 COB B D ETL0020 ETL0020 DB5G170320001 20/03/2017 10:02 20/03/2017 10:03Stream5 Stream5 COB B D ETL0020 ETL0020 DB5G170320002 20/03/2017 16:36 20/03/2017 16:36Stream5 Stream5 COB B D DWB858 DWB858 DB6G170320001 20/03/2017 13:15 20/03/2017 13:15Stream6 Stream6 COB B D DWB858 DWB858 DB6G170320002 20/03/2017 15:00 20/03/2017 15:01Stream6 Stream6 COB B D DWB858 DWB858

Wh What kind of data we ha have?_candi ndida dates fo for activity

• Sample data snap

PKG ID BEGIN EXEC DATE BEGIN EXEC TIME END EXEC DATE END EXEC TIME SYS NAME (S) SYS NAME (T) TYPE NAME (S) STG ID (S) STG ID (T) ELM (S) ELM (T) BO2G170321001 21/03/2017 10:13 21/03/2017 10:13Stream2 Stream2 COB O B BVL0020 BVL0020 BO2G170321001 21/03/2017 10:13 21/03/2017 10:13Stream2 Stream2 COB O B BVL013 BVL013 BO2G170321002 21/03/2017 10:18 21/03/2017 10:18Stream2 Stream2 COB O B DWB858 DWB858 BO2G170321002 21/03/2017 10:18 21/03/2017 10:18Stream2 Stream2 COB O B ETL0020 ETL0020 BO5G170320001 20/03/2017 10:01 20/03/2017 10:02Stream5 Stream5 COB O B ETL0020 ETL0020 BO5G170320002 20/03/2017 16:35 20/03/2017 16:35Stream5 Stream5 COB O B DWB858 DWB858 BO6G170320001 20/03/2017 13:14 20/03/2017 13:14Stream6 Stream6 COB O B DWB858 DWB858 BO6G170320002 20/03/2017 15:00 20/03/2017 15:00Stream6 Stream6 COB O B DWB858 DWB858 BO6G170321001 21/03/2017 12:00 21/03/2017 12:00Stream6 Stream6 COB O B ETL0020 ETL0020 DB2G170321001 21/03/2017 10:15 21/03/2017 10:15Stream2 Stream2 COB B D BVL0020 BVL0020 DB2G170321001 21/03/2017 10:15 21/03/2017 10:15Stream2 Stream2 COB B D BVL013 BVL013 DB2G170321002 21/03/2017 10:19 21/03/2017 10:19Stream2 Stream2 COB B D DWB858 DWB858 DB2G170321002 21/03/2017 10:19 21/03/2017 10:19Stream2 Stream2 COB B D ETL0020 ETL0020 DB5G170320001 20/03/2017 10:02 20/03/2017 10:03Stream5 Stream5 COB B D ETL0020 ETL0020 DB5G170320002 20/03/2017 16:36 20/03/2017 16:36Stream5 Stream5 COB B D DWB858 DWB858 DB6G170320001 20/03/2017 13:15 20/03/2017 13:15Stream6 Stream6 COB B D DWB858 DWB858 DB6G170320002 20/03/2017 15:00 20/03/2017 15:01Stream6 Stream6 COB B D DWB858 DWB858

Choosing Case ID _Firs rst Pro rototype

CASE_key _SCEN 0 CASE_key _SCEN1 CASE_key _SCEN2 Action_Scenario 0 Action_Scenario1 Action_Scenario2

BO2G170321001 BVL0020_COB_G BVL0020_COB B promoted to B promoted from O to B BO2G170321001 BVL013_COB_G BVL013_COB B promoted to B promoted from O to B BO2G170321002 DWB858_COB_G DWB858_COB B promoted to B promoted from O to B BO2G170321002 ETL0020_COB_G ETL0020_COB B promoted to B promoted from O to B BO5G170320001 ETL0020_COB_G ETL0020_COB B promoted to B promoted from O to B BO5G170320002 DWB858_COB_G DWB858_COB B promoted to B promoted from O to B BO6G170320001 DWB858_COB_G DWB858_COB B promoted to B promoted from O to B BO6G170320002 DWB858_COB_G DWB858_COB B promoted to B promoted from O to B BO6G170321001 ETL0020_COB_G ETL0020_COB B promoted to B promoted from O to B DB2G170321001 BVL0020_COB_G BVL0020_COB D promoted to D promoted from B to D DB2G170321001 BVL013_COB_G BVL013_COB D promoted to D promoted from B to D DB2G170321002 DWB858_COB_G DWB858_COB D promoted to D promoted from B to D DB2G170321002 ETL0020_COB_G ETL0020_COB D promoted to D promoted from B to D DB5G170320001 ETL0020_COB_G ETL0020_COB D promoted to D promoted from B to D DB5G170320002 DWB858_COB_G DWB858_COB D promoted to D promoted from B to D DB6G170320001 DWB858_COB_G DWB858_COB D promoted to D promoted from B to D DB6G170320002 DWB858_COB_G DWB858_COB D promoted to D promoted from B to D

• Component is moving through 6 main blocks plus 2 related to pre-production environment

Ma Main Process cornerstones of the process we have in mind

O B D I N Pre-Prod R H Pre-Prod P

Ca Case ID Ini nitial Scena nario: PK PKG moving through TARGET T stages

De Defining Sco cope : how package move ves (short life cycle)

De Defining Scope : how component mo moves (long life cycle)

Wh What kind of data we have?

PKG ID BEGIN EXEC DATE BEGIN EXEC TIME END EXEC DATE END EXEC TIME SYS NAME (S) SYS NAME (T) TYPE NAME (S) STG ID (S) STG ID (T) ELM (S) ELM (T) BO2G170321001 21/03/2017 10:13 21/03/2017 10:13 Stream2 Stream2 COB O B BVL0020 BVL0020 BO2G170321001 21/03/2017 10:13 21/03/2017 10:13 Stream2 Stream2 COB O B BVL013 BVL013 BO2G170321002 21/03/2017 10:18 21/03/2017 10:18 Stream2 Stream2 COB O B DWB858 DWB858 BO2G170321002 21/03/2017 10:18 21/03/2017 10:18 Stream2 Stream2 COB O B ETL0020 ETL0020 BO5G170320001 20/03/2017 10:01 20/03/2017 10:02 Stream5 Stream5 COB O B ETL0020 ETL0020 BO5G170320002 20/03/2017 16:35 20/03/2017 16:35 Stream5 Stream5 COB O B DWB858 DWB858 BO6G170320001 20/03/2017 13:14 20/03/2017 13:14 Stream6 Stream6 COB O B DWB858 DWB858 BO6G170320002 20/03/2017 15:00 20/03/2017 15:00 Stream6 Stream6 COB O B DWB858 DWB858 BO6G170321001 21/03/2017 12:00 21/03/2017 12:00 Stream6 Stream6 COB O B ETL0020 ETL0020 DB2G170321001 21/03/2017 10:15 21/03/2017 10:15 Stream2 Stream2 COB B D BVL0020 BVL0020 DB2G170321001 21/03/2017 10:15 21/03/2017 10:15 Stream2 Stream2 COB B D BVL013 BVL013 DB2G170321002 21/03/2017 10:19 21/03/2017 10:19 Stream2 Stream2 COB B D DWB858 DWB858 DB2G170321002 21/03/2017 10:19 21/03/2017 10:19 Stream2 Stream2 COB B D ETL0020 ETL0020 DB5G170320001 20/03/2017 10:02 20/03/2017 10:03 Stream5 Stream5 COB B D ETL0020 ETL0020 DB5G170320002 20/03/2017 16:36 20/03/2017 16:36 Stream5 Stream5 COB B D DWB858 DWB858 DB6G170320001 20/03/2017 13:15 20/03/2017 13:15 Stream6 Stream6 COB B D DWB858 DWB858 DB6G170320002 20/03/2017 15:00 20/03/2017 15:01 Stream6 Stream6 COB B D DWB858 DWB858

Wh What kind of data we have?

PKG ID BEGIN EXEC DATE BEGIN EXEC TIME END EXEC DATE END EXEC TIME SYS NAME (S) SYS NAME (T) TYPE NAME (S) STG ID (S) STG ID (T) ELM (S) ELM (T) BO2G170321001 21/03/2017 10:13 21/03/2017 10:13 Stream2 Stream2 COB O B BVL0020 BVL0020 BO2G170321001 21/03/2017 10:13 21/03/2017 10:13 Stream2 Stream2 COB O B BVL013 BVL013 BO2G170321002 21/03/2017 10:18 21/03/2017 10:18 Stream2 Stream2 COB O B DWB858 DWB858 BO2G170321002 21/03/2017 10:18 21/03/2017 10:18 Stream2 Stream2 COB O B ETL0020 ETL0020 BO5G170320001 20/03/2017 10:01 20/03/2017 10:02 Stream5 Stream5 COB O B ETL0020 ETL0020 BO5G170320002 20/03/2017 16:35 20/03/2017 16:35 Stream5 Stream5 COB O B DWB858 DWB858 BO6G170320001 20/03/2017 13:14 20/03/2017 13:14 Stream6 Stream6 COB O B DWB858 DWB858 BO6G170320002 20/03/2017 15:00 20/03/2017 15:00 Stream6 Stream6 COB O B DWB858 DWB858 BO6G170321001 21/03/2017 12:00 21/03/2017 12:00 Stream6 Stream6 COB O B ETL0020 ETL0020 DB2G170321001 21/03/2017 10:15 21/03/2017 10:15 Stream2 Stream2 COB B D BVL0020 BVL0020 DB2G170321001 21/03/2017 10:15 21/03/2017 10:15 Stream2 Stream2 COB B D BVL013 BVL013 DB2G170321002 21/03/2017 10:19 21/03/2017 10:19 Stream2 Stream2 COB B D DWB858 DWB858 DB2G170321002 21/03/2017 10:19 21/03/2017 10:19 Stream2 Stream2 COB B D ETL0020 ETL0020 DB5G170320001 20/03/2017 10:02 20/03/2017 10:03 Stream5 Stream5 COB B D ETL0020 ETL0020 DB5G170320002 20/03/2017 16:36 20/03/2017 16:36 Stream5 Stream5 COB B D DWB858 DWB858 DB6G170320001 20/03/2017 13:15 20/03/2017 13:15 Stream6 Stream6 COB B D DWB858 DWB858 DB6G170320002 20/03/2017 15:00 20/03/2017 15:01 Stream6 Stream6 COB B D DWB858 DWB858

Cho Choosing ng Ca Case ID

CASE_key _SCEN 0 CASE_key _SCEN1 CASE_key _SCEN2 Action_Scenario 0 Action_Scenario1 Action_Scenario2

BO2G170321001 BVL0020_COB_G BVL0020_COB B promoted to B promoted from O to B BO2G170321001 BVL013_COB_G BVL013_COB B promoted to B promoted from O to B BO2G170321002 DWB858_COB_G DWB858_COB B promoted to B promoted from O to B BO2G170321002 ETL0020_COB_G ETL0020_COB B promoted to B promoted from O to B BO5G170320001 ETL0020_COB_G ETL0020_COB B promoted to B promoted from O to B BO5G170320002 DWB858_COB_G DWB858_COB B promoted to B promoted from O to B BO6G170320001 DWB858_COB_G DWB858_COB B promoted to B promoted from O to B BO6G170320002 DWB858_COB_G DWB858_COB B promoted to B promoted from O to B BO6G170321001 ETL0020_COB_G ETL0020_COB B promoted to B promoted from O to B DB2G170321001 BVL0020_COB_G BVL0020_COB D promoted to D promoted from B to D DB2G170321001 BVL013_COB_G BVL013_COB D promoted to D promoted from B to D DB2G170321002 DWB858_COB_G DWB858_COB D promoted to D promoted from B to D DB2G170321002 ETL0020_COB_G ETL0020_COB D promoted to D promoted from B to D DB5G170320001 ETL0020_COB_G ETL0020_COB D promoted to D promoted from B to D DB5G170320002 DWB858_COB_G DWB858_COB D promoted to D promoted from B to D DB6G170320001 DWB858_COB_G DWB858_COB D promoted to D promoted from B to D DB6G170320002 DWB858_COB_G DWB858_COB D promoted to D promoted from B to D

Cho Choosing ng Activity

CASE_key _SCEN 0 CASE_key _SCEN1 CASE_key _SCEN2 Action_Scenario 0 Action_Scenario1 Action_Scenario2

BO2G170321001 BVL0020_COB_G BVL0020_COB B promoted to B promoted from O to B BO2G170321001 BVL013_COB_G BVL013_COB B promoted to B promoted from O to B BO2G170321002 DWB858_COB_G DWB858_COB B promoted to B promoted from O to B BO2G170321002 ETL0020_COB_G ETL0020_COB B promoted to B promoted from O to B BO5G170320001 ETL0020_COB_G ETL0020_COB B promoted to B promoted from O to B BO5G170320002 DWB858_COB_G DWB858_COB B promoted to B promoted from O to B BO6G170320001 DWB858_COB_G DWB858_COB B promoted to B promoted from O to B BO6G170320002 DWB858_COB_G DWB858_COB B promoted to B promoted from O to B BO6G170321001 ETL0020_COB_G ETL0020_COB B promoted to B promoted from O to B DB2G170321001 BVL0020_COB_G BVL0020_COB D promoted to D promoted from B to D DB2G170321001 BVL013_COB_G BVL013_COB D promoted to D promoted from B to D DB2G170321002 DWB858_COB_G DWB858_COB D promoted to D promoted from B to D DB2G170321002 ETL0020_COB_G ETL0020_COB D promoted to D promoted from B to D DB5G170320001 ETL0020_COB_G ETL0020_COB D promoted to D promoted from B to D DB5G170320002 DWB858_COB_G DWB858_COB D promoted to D promoted from B to D DB6G170320001 DWB858_COB_G DWB858_COB D promoted to D promoted from B to D DB6G170320002 DWB858_COB_G DWB858_COB D promoted to D promoted from B to D

OR

Cho Choosing ng Activity : Sour urce Stage view - no not recogni nized

Cho Choosing ng Activity : Target Stage view - no not recogni nized

Cho Choosing ng Activity

CASE_key _SCEN 0 CASE_key _SCEN1 CASE_key _SCEN2 Action_Scenario 0 Action_Scenario1 Action_Scenario2

BO2G170321001 BVL0020_COB_G BVL0020_COB B promoted to B promoted from O to B BO2G170321001 BVL013_COB_G BVL013_COB B promoted to B promoted from O to B BO2G170321002 DWB858_COB_G DWB858_COB B promoted to B promoted from O to B BO2G170321002 ETL0020_COB_G ETL0020_COB B promoted to B promoted from O to B BO5G170320001 ETL0020_COB_G ETL0020_COB B promoted to B promoted from O to B BO5G170320002 DWB858_COB_G DWB858_COB B promoted to B promoted from O to B BO6G170320001 DWB858_COB_G DWB858_COB B promoted to B promoted from O to B BO6G170320002 DWB858_COB_G DWB858_COB B promoted to B promoted from O to B BO6G170321001 ETL0020_COB_G ETL0020_COB B promoted to B promoted from O to B DB2G170321001 BVL0020_COB_G BVL0020_COB D promoted to D promoted from B to D DB2G170321001 BVL013_COB_G BVL013_COB D promoted to D promoted from B to D DB2G170321002 DWB858_COB_G DWB858_COB D promoted to D promoted from B to D DB2G170321002 ETL0020_COB_G ETL0020_COB D promoted to D promoted from B to D DB5G170320001 ETL0020_COB_G ETL0020_COB D promoted to D promoted from B to D DB5G170320002 DWB858_COB_G DWB858_COB D promoted to D promoted from B to D DB6G170320001 DWB858_COB_G DWB858_COB D promoted to D promoted from B to D DB6G170320002 DWB858_COB_G DWB858_COB D promoted to D promoted from B to D

Cho Choosing ng Act ction Sour urce ce to Target Stage vi view in n ONE STREAM: M: start rts looking ng fa familiar

• 6 months of data, all streams data but filtered on one only target stream

? ? ?

Cho Choosing ng Action n Scena nario So Source to Target St Stage vi view in ALL STREAMS: discovery begins

10 months of data. Detailed View of testing Activities in All Corridors

De Defining scope: ALL STRE REAMS ACTIVITIES

Cho Choosing ng Action

CASE_key _SCEN 0 CASE_key _SCEN1 CASE_key _SCEN11 Action_Scenario 0 Action_Scenario1 Action_Scenario11 Action_Scenario11_2 BO2G170321001 BVL0020_COB_G BVL0020_COB B promoted to B promoted from O to B promoted from O (Stream2) to B (Stream2) BO2G170321001 BVL013_COB_G BVL013_COB B promoted to B promoted from O to B promoted from O (Stream2) to B (Stream2) BO2G170321002 DWB858_COB_G DWB858_COB B promoted to B promoted from O to B promoted from O (Stream2) to B (Stream2) BO2G170321002 ETL0020_COB_G ETL0020_COB B promoted to B promoted from O to B promoted from O (Stream2) to B (Stream2) BO5G170320001 ETL0020_COB_G ETL0020_COB B promoted to B promoted from O to B promoted from O (Stream5) to B (Stream5) BO5G170320002 DWB858_COB_G DWB858_COB B promoted to B promoted from O to B promoted from O (Stream5) to B (Stream5) BO6G170320001 DWB858_COB_G DWB858_COB B promoted to B promoted from O to B promoted from O (Stream6) to B (Stream6) BO6G170320002 DWB858_COB_G DWB858_COB B promoted to B promoted from O to B promoted from O (Stream6) to B (Stream6) BO6G170321001 ETL0020_COB_G ETL0020_COB B promoted to B promoted from O to B promoted from O (Stream6) to B (Stream6) DB2G170321001 BVL0020_COB_G BVL0020_COB D promoted to D promoted from B to D promoted from B (Stream2) to D (Stream2) DB2G170321001 BVL013_COB_G BVL013_COB D promoted to D promoted from B to D promoted from B (Stream2) to D (Stream2) DB2G170321002 DWB858_COB_G DWB858_COB D promoted to D promoted from B to D promoted from B (Stream2) to D (Stream2) DB2G170321002 ETL0020_COB_G ETL0020_COB D promoted to D promoted from B to D promoted from B (Stream2) to D (Stream2) DB5G170320001 ETL0020_COB_G ETL0020_COB D promoted to D promoted from B to D promoted from B (Stream5) to D (Stream5) DB5G170320002 DWB858_COB_G DWB858_COB D promoted to D promoted from B to D promoted from B (Stream5) to D (Stream5) DB6G170320001 DWB858_COB_G DWB858_COB D promoted to D promoted from B to D promoted from B (Stream6) to D (Stream6) DB6G170320002 DWB858_COB_G DWB858_COB D promoted to D promoted from B to D promoted from B (Stream6) to D (Stream6)

Cho Choosing ng Action

CASE_key _SCEN 0 CASE_key _SCEN1 CASE_key _SCEN11 Action_Scenario 0 Action_Scenario1 Action_Scenario11 Action_Scenario11_2 SYS_NAME (s)_YEAR key SYS_NAME(T )_YEAR key

BO2G170321001 BVL0020_COB_G BVL0020_COB B prom oted to B prom oted from O to B prom oted from O (Stream 2) to B (Stream 2) July'17 RLS July'17 RLS BO2G170321001 BVL013_COB_G BVL013_COB B prom oted to B prom oted from O to B prom oted from O (Stream 2) to B (Stream 2) July'17 RLS July'17 RLS BO2G170321002 DW B858_COB_G DW B858_COB B prom oted to B prom oted from O to B prom oted from O (Stream 2) to B (Stream 2) July'17 RLS July'17 RLS BO2G170321002 ETL0020_COB_G ETL0020_COB B prom oted to B prom oted from O to B prom oted from O (Stream 2) to B (Stream 2) July'17 RLS July'17 RLS BO5G170320001 ETL0020_COB_G ETL0020_COB B prom oted to B prom oted from O to B prom oted from O (Stream 5) to B (Stream 5) M ay'17 RLS M ay'17 RLS BO5G170320002 DW B858_COB_G DW B858_COB B prom oted to B prom oted from O to B prom oted from O (Stream 5) to B (Stream 5) M ay'17 RLS M ay'17 RLS BO6G170320001 DW B858_COB_G DW B858_COB B prom oted to B prom oted from O to B prom oted from O (Stream 6) to B (Stream 6) no release no release BO6G170320002 DW B858_COB_G DW B858_COB B prom oted to B prom oted from O to B prom oted from O (Stream 6) to B (Stream 6) no release no release BO6G170321001 ETL0020_COB_G ETL0020_COB B prom oted to B prom oted from O to B prom oted from O (Stream 6) to B (Stream 6) no release no release DB2G170321001 BVL0020_COB_G BVL0020_COB D prom oted to D prom oted from B to D prom oted from B (Stream 2) to D (Stream 2) July'17 RLS July'17 RLS DB2G170321001 BVL013_COB_G BVL013_COB D prom oted to D prom oted from B to D prom oted from B (Stream 2) to D (Stream 2) July'17 RLS July'17 RLS DB2G170321002 DW B858_COB_G DW B858_COB D prom oted to D prom oted from B to D prom oted from B (Stream 2) to D (Stream 2) July'17 RLS July'17 RLS DB2G170321002 ETL0020_COB_G ETL0020_COB D prom oted to D prom oted from B to D prom oted from B (Stream 2) to D (Stream 2) July'17 RLS July'17 RLS DB5G170320001 ETL0020_COB_G ETL0020_COB D prom oted to D prom oted from B to D prom oted from B (Stream 5) to D (Stream 5) M ay'17 RLS M ay'17 RLS DB5G170320002 DW B858_COB_G DW B858_COB D prom oted to D prom oted from B to D prom oted from B (Stream 5) to D (Stream 5) M ay'17 RLS M ay'17 RLS DB6G170320001 DW B858_COB_G DW B858_COB D prom oted to D prom oted from B to D prom oted from B (Stream 6) to D (Stream 6) no release no release DB6G170320002 DW B858_COB_G DW B858_COB D prom oted to D prom oted from B to D prom oted from B (Stream 6) to D (Stream 6) no release no release

? ?

Cho Choosing ng Action

CASE_key _SCEN 0 CASE_key _SCEN1 CASE_key _SCEN11 Action_Scenario 0 Action_Scenario1 Action_Scenario11 Action_Scenario11_2 SYS_NAME (s)_YEAR key SYS_NAME(T )_YEAR key

BO2G170321001 BVL0020_COB_G BVL0020_COB B prom oted to B prom oted from O to B prom oted from O (Stream 2) to B (Stream 2) July'17 RLS July'17 RLS BO2G170321001 BVL013_COB_G BVL013_COB B prom oted to B prom oted from O to B prom oted from O (Stream 2) to B (Stream 2) July'17 RLS July'17 RLS BO2G170321002 DW B858_COB_G DW B858_COB B prom oted to B prom oted from O to B prom oted from O (Stream 2) to B (Stream 2) July'17 RLS July'17 RLS BO2G170321002 ETL0020_COB_G ETL0020_COB B prom oted to B prom oted from O to B prom oted from O (Stream 2) to B (Stream 2) July'17 RLS July'17 RLS BO5G170320001 ETL0020_COB_G ETL0020_COB B prom oted to B prom oted from O to B prom oted from O (Stream 5) to B (Stream 5) M ay'17 RLS M ay'17 RLS BO5G170320002 DW B858_COB_G DW B858_COB B prom oted to B prom oted from O to B prom oted from O (Stream 5) to B (Stream 5) M ay'17 RLS M ay'17 RLS BO6G170320001 DW B858_COB_G DW B858_COB B prom oted to B prom oted from O to B prom oted from O (Stream 6) to B (Stream 6) no release no release BO6G170320002 DW B858_COB_G DW B858_COB B prom oted to B prom oted from O to B prom oted from O (Stream 6) to B (Stream 6) no release no release BO6G170321001 ETL0020_COB_G ETL0020_COB B prom oted to B prom oted from O to B prom oted from O (Stream 6) to B (Stream 6) no release no release DB2G170321001 BVL0020_COB_G BVL0020_COB D prom oted to D prom oted from B to D prom oted from B (Stream 2) to D (Stream 2) July'17 RLS July'17 RLS DB2G170321001 BVL013_COB_G BVL013_COB D prom oted to D prom oted from B to D prom oted from B (Stream 2) to D (Stream 2) July'17 RLS July'17 RLS DB2G170321002 DW B858_COB_G DW B858_COB D prom oted to D prom oted from B to D prom oted from B (Stream 2) to D (Stream 2) July'17 RLS July'17 RLS DB2G170321002 ETL0020_COB_G ETL0020_COB D prom oted to D prom oted from B to D prom oted from B (Stream 2) to D (Stream 2) July'17 RLS July'17 RLS DB5G170320001 ETL0020_COB_G ETL0020_COB D prom oted to D prom oted from B to D prom oted from B (Stream 5) to D (Stream 5) M ay'17 RLS M ay'17 RLS DB5G170320002 DW B858_COB_G DW B858_COB D prom oted to D prom oted from B to D prom oted from B (Stream 5) to D (Stream 5) M ay'17 RLS M ay'17 RLS DB6G170320001 DW B858_COB_G DW B858_COB D prom oted to D prom oted from B to D prom oted from B (Stream 6) to D (Stream 6) no release no release DB6G170320002 DW B858_COB_G DW B858_COB D prom oted to D prom oted from B to D prom oted from B (Stream 6) to D (Stream 6) no release no release

COMBINED WITH

Cho Choosing ng Ac Action_FINAL NAL

COMBINED WITH CASE_key _SCEN 0 CASE_key _SCEN1 CASE_key _SCEN11 Action_Scenari

Action_Scenar io1 Action_Scenario1 1 Action_Scenario11_2 SYS_NAME (s)_YEAR key SYS_NAME (T)_YEAR key X- Corrido r Flag PKG profile

BO2G170321001 BVL0020_COB_G BVL0020_COB B promoted to B promoted from O to B promoted from O (Stream2) to B (Stream2) July'17 RLS July'17 RLS NO BO2 BO2G170321001 BVL013_COB_G BVL013_COB B promoted to B promoted from O to B promoted from O (Stream2) to B (Stream2) July'17 RLS July'17 RLS NO BO2 BO2G170321002 DWB858_COB_G DWB858_COB B promoted to B promoted from O to B promoted from O (Stream2) to B (Stream2) July'17 RLS July'17 RLS NO BO2 BO2G170321002 ETL0020_COB_G ETL0020_COB B promoted to B promoted from O to B promoted from O (Stream2) to B (Stream2) July'17 RLS July'17 RLS NO BO2 BO5G170320001 ETL0020_COB_G ETL0020_COB B promoted to B promoted from O to B promoted from O (Stream5) to B (Stream5) May'17 RLS May'17 RLS NO BO5 BO5G170320002 DWB858_COB_G DWB858_COB B promoted to B promoted from O to B promoted from O (Stream5) to B (Stream5) May'17 RLS May'17 RLS NO BO5 BO6G170320001 DWB858_COB_G DWB858_COB B promoted to B promoted from O to B promoted from O (Stream6) to B (Stream6) no release no release NO BO6 BO6G170320002 DWB858_COB_G DWB858_COB B promoted to B promoted from O to B promoted from O (Stream6) to B (Stream6) no release no release NO BO6 BO6G170321001 ETL0020_COB_G ETL0020_COB B promoted to B promoted from O to B promoted from O (Stream6) to B (Stream6) no release no release NO BO6 DB2G170321001 BVL0020_COB_G BVL0020_COB D promoted to D promoted from B to D promoted from B (Stream2) to D (Stream2) July'17 RLS July'17 RLS NO DB2 DB2G170321001 BVL013_COB_G BVL013_COB D promoted to D promoted from B to D promoted from B (Stream2) to D (Stream2) July'17 RLS July'17 RLS NO DB2 DB2G170321002 DWB858_COB_G DWB858_COB D promoted to D promoted from B to D promoted from B (Stream2) to D (Stream2) July'17 RLS July'17 RLS NO DB2 DB2G170321002 ETL0020_COB_G ETL0020_COB D promoted to D promoted from B to D promoted from B (Stream2) to D (Stream2) July'17 RLS July'17 RLS NO DB2 DB5G170320001 ETL0020_COB_G ETL0020_COB D promoted to D promoted from B to D promoted from B (Stream5) to D (Stream5) May'17 RLS May'17 RLS NO DB5 DB5G170320002 DWB858_COB_G DWB858_COB D promoted to D promoted from B to D promoted from B (Stream5) to D (Stream5) May'17 RLS May'17 RLS NO DB5 DB6G170320001 DWB858_COB_G DWB858_COB D promoted to D promoted from B to D promoted from B (Stream6) to D (Stream6) no release no release NO DB6 DB6G170320002 DWB858_COB_G DWB858_COB D promoted to D promoted from B to D promoted from B (Stream6) to D (Stream6) no release no release NO DB6

Pi Picture of St Stream1 – Ba Back to the he ini nitial scope pe and nd mission n of Process Mini ning ng Exercise

? ?

Fi Fina nal Tho houg ughts

• Lessons learnt
• Talk to many experts - biased view

exist!

• Taking completely new look on the

process, include habitual reference points of the business owners.

• Helicopter view is what gives truly big

picture and big trends

• Regularly talk to Senior Management

to maintain link to main goals

• Data analyst wearing two hats needs

to give an extra thought about how to maximize collaboration with business process owners and get their full buy- in.

• Lessons… still to be learnt (future

research agenda)

• Are KPI based on the data from one

process give full picture on the risks

• r should we blend the data from

several processes connected to our main process? (e.g defects management, incidents management, sprints?)

• Improvements: quick wins and longer

term plans

• Audit Assessment of Risks and

Controls