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 Audit • Checking Conformity • Continuous Auditing • KPIs : Versioning and Durations • Assessment of complexity in real life • Outliers analysis • Awareness of risks and control gaps • Continuous Monitoring via Dashboard • Inefficiencies • Major credibility with the audited • Learning and on-boarding Process business Mining for daily routine workflow • 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 of ‘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 BEGIN EXEC END EXEC SYS NAME TYPE NAME TIME TIME (T) (S) PKG ID BEGIN EXEC DATE END EXEC DATE SYS 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 BEGIN EXEC END EXEC SYS NAME TYPE NAME TIME TIME (T) (S) PKG ID BEGIN EXEC DATE END EXEC DATE SYS 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 BEGIN EXEC END EXEC SYS NAME TYPE NAME TIME TIME (T) (S) PKG ID BEGIN EXEC DATE END EXEC DATE SYS 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

Ma Main Process cornerstones of the process we have in mind • Component is moving through 6 main blocks plus 2 related to pre-production environment N H O D I B Pre-Prod R 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)