Understanding Complex Development Processes
0 likes10 views
The fifth talk at Process Mining Camp was given by Olga Gazina and Daniel Cathala from Euroclear. As a data analyst at the internal audit department Olga helped Daniel, IT Manager, to make his life at the end of the year a bit easier by using process mining to identify key risks. She applied process mining to the process from development to release at the Component and Data Management IT division. It looks like a simple process at first, but Daniel explains that it becomes increasingly complex when considering that multiple configurations and versions are developed, tested and released. It becomes even more complex as the projects affecting these releases are running in parallel. And on top of that, each project often impacts multiple versions and releases. After Olga obtained the data for this process, she quickly realized that she had many candidates for the caseID, timestamp and activity. She had to find a perspective of the process that was on the right level, so that it could be recognized by the process owners. In her talk she takes us through her journey step by step and shows the challenges she encountered in each iteration. In the end, she was able to find the visualization that was hidden in the minds of the business experts.
More Related Content
More from Process mining Evangelist (20)
Recently uploaded (20)
Understanding Complex Development Processes
- 1. Process Mining for Component Management in EUROCLEAR 2017-2018 ACTIVITIES
- 3. Process Mining Exercise TO GO- NOT TO GO ? OBJECTIVES MEANS TO REACH OBJECTIVES COST-BENEFIT EVALUATION
- 4. Benefits of Process Mining exercise for Stakeholders 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
- 5. Business Background: Component & Data 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.
- 6. What kind of process we have? Software Configuration Management Lifecycle Map T T T T T T T T T
- 7. What kind of data we have? • Sample data snap
- 8. What kind of data we have?_candidates for case ID • Sample data snap PKGID BEGINEXECDATE BEGINEXEC TIME ENDEXECDATE ENDEXEC TIME SYSNAME(S) SYSNAME (T) TYPENAME (S) STGID(S) STGID(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
- 9. What kind of data we have? _candidates for time stamp • Sample data snap PKGID BEGINEXECDATE BEGINEXEC TIME ENDEXECDATE ENDEXEC TIME SYSNAME(S) SYSNAME (T) TYPENAME (S) STGID(S) STGID(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
- 10. What kind of data we have?_candidates for activity • Sample data snap PKGID BEGINEXECDATE BEGINEXEC TIME ENDEXECDATE ENDEXEC TIME SYSNAME(S) SYSNAME (T) TYPENAME (S) STGID(S) STGID(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
- 11. Choosing Case ID _First Prototype CASE_key _SCEN 0 CASE_key _SCEN1 CASE_key _SCEN2 Action_Scenario 0 Action_Scenario1 Action_Scenario2 BO2G170321001 BVL0020_COB_G BVL0020_COB B promotedtoB promotedfromOtoB BO2G170321001 BVL013_COB_G BVL013_COB B promotedtoB promotedfromOtoB BO2G170321002 DWB858_COB_G DWB858_COB B promotedtoB promotedfromOtoB BO2G170321002 ETL0020_COB_G ETL0020_COB B promotedtoB promotedfromOtoB BO5G170320001 ETL0020_COB_G ETL0020_COB B promotedtoB promotedfromOtoB BO5G170320002 DWB858_COB_G DWB858_COB B promotedtoB promotedfromOtoB BO6G170320001 DWB858_COB_G DWB858_COB B promotedtoB promotedfromOtoB BO6G170320002 DWB858_COB_G DWB858_COB B promotedtoB promotedfromOtoB BO6G170321001 ETL0020_COB_G ETL0020_COB B promotedtoB promotedfromOtoB DB2G170321001 BVL0020_COB_G BVL0020_COB D promotedtoD promotedfromBtoD DB2G170321001 BVL013_COB_G BVL013_COB D promotedtoD promotedfromBtoD DB2G170321002 DWB858_COB_G DWB858_COB D promotedtoD promotedfromBtoD DB2G170321002 ETL0020_COB_G ETL0020_COB D promotedtoD promotedfromBtoD DB5G170320001 ETL0020_COB_G ETL0020_COB D promotedtoD promotedfromBtoD DB5G170320002 DWB858_COB_G DWB858_COB D promotedtoD promotedfromBtoD DB6G170320001 DWB858_COB_G DWB858_COB D promotedtoD promotedfromBtoD DB6G170320002 DWB858_COB_G DWB858_COB D promotedtoD promotedfromBtoD
- 12. • Component is moving through 6 main blocks plus 2 related to pre-production environment Main Process cornerstones of the process we have in mind O B D I N Pre-Prod R H Pre-Prod P
- 13. Case ID Initial Scenario: PKG moving through TARGET stages
- 14. Defining Scope : how package moves (short life cycle)
- 15. Defining Scope : how component moves (long life cycle)
- 16. What kind of data we have? PKGID BEGINEXECDATE BEGINEXEC TIME ENDEXECDATE ENDEXEC TIME SYSNAME(S) SYSNAME (T) TYPENAME (S) STGID(S) STGID(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
- 17. What kind of data we have? PKGID BEGINEXECDATE BEGINEXEC TIME ENDEXECDATE ENDEXEC TIME SYSNAME(S) SYSNAME (T) TYPENAME (S) STGID(S) STGID(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
- 18. Choosing 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 promotedtoB promotedfromOtoB BO2G170321001 BVL013_COB_G BVL013_COB B promotedtoB promotedfromOtoB BO2G170321002 DWB858_COB_G DWB858_COB B promotedtoB promotedfromOtoB BO2G170321002 ETL0020_COB_G ETL0020_COB B promotedtoB promotedfromOtoB BO5G170320001 ETL0020_COB_G ETL0020_COB B promotedtoB promotedfromOtoB BO5G170320002 DWB858_COB_G DWB858_COB B promotedtoB promotedfromOtoB BO6G170320001 DWB858_COB_G DWB858_COB B promotedtoB promotedfromOtoB BO6G170320002 DWB858_COB_G DWB858_COB B promotedtoB promotedfromOtoB BO6G170321001 ETL0020_COB_G ETL0020_COB B promotedtoB promotedfromOtoB DB2G170321001 BVL0020_COB_G BVL0020_COB D promotedtoD promotedfromBtoD DB2G170321001 BVL013_COB_G BVL013_COB D promotedtoD promotedfromBtoD DB2G170321002 DWB858_COB_G DWB858_COB D promotedtoD promotedfromBtoD DB2G170321002 ETL0020_COB_G ETL0020_COB D promotedtoD promotedfromBtoD DB5G170320001 ETL0020_COB_G ETL0020_COB D promotedtoD promotedfromBtoD DB5G170320002 DWB858_COB_G DWB858_COB D promotedtoD promotedfromBtoD DB6G170320001 DWB858_COB_G DWB858_COB D promotedtoD promotedfromBtoD DB6G170320002 DWB858_COB_G DWB858_COB D promotedtoD promotedfromBtoD
- 19. Choosing 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 promotedtoB promotedfromOtoB BO2G170321001 BVL013_COB_G BVL013_COB B promotedtoB promotedfromOtoB BO2G170321002 DWB858_COB_G DWB858_COB B promotedtoB promotedfromOtoB BO2G170321002 ETL0020_COB_G ETL0020_COB B promotedtoB promotedfromOtoB BO5G170320001 ETL0020_COB_G ETL0020_COB B promotedtoB promotedfromOtoB BO5G170320002 DWB858_COB_G DWB858_COB B promotedtoB promotedfromOtoB BO6G170320001 DWB858_COB_G DWB858_COB B promotedtoB promotedfromOtoB BO6G170320002 DWB858_COB_G DWB858_COB B promotedtoB promotedfromOtoB BO6G170321001 ETL0020_COB_G ETL0020_COB B promotedtoB promotedfromOtoB DB2G170321001 BVL0020_COB_G BVL0020_COB D promotedtoD promotedfromBtoD DB2G170321001 BVL013_COB_G BVL013_COB D promotedtoD promotedfromBtoD DB2G170321002 DWB858_COB_G DWB858_COB D promotedtoD promotedfromBtoD DB2G170321002 ETL0020_COB_G ETL0020_COB D promotedtoD promotedfromBtoD DB5G170320001 ETL0020_COB_G ETL0020_COB D promotedtoD promotedfromBtoD DB5G170320002 DWB858_COB_G DWB858_COB D promotedtoD promotedfromBtoD DB6G170320001 DWB858_COB_G DWB858_COB D promotedtoD promotedfromBtoD DB6G170320002 DWB858_COB_G DWB858_COB D promotedtoD promotedfromBtoD OR
- 20. Choosing Activity : Source Stage view - not recognized
- 21. Choosing Activity : Target Stage view - not recognized
- 22. Choosing 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 promotedtoB promotedfromOtoB BO2G170321001 BVL013_COB_G BVL013_COB B promotedtoB promotedfromOtoB BO2G170321002 DWB858_COB_G DWB858_COB B promotedtoB promotedfromOtoB BO2G170321002 ETL0020_COB_G ETL0020_COB B promotedtoB promotedfromOtoB BO5G170320001 ETL0020_COB_G ETL0020_COB B promotedtoB promotedfromOtoB BO5G170320002 DWB858_COB_G DWB858_COB B promotedtoB promotedfromOtoB BO6G170320001 DWB858_COB_G DWB858_COB B promotedtoB promotedfromOtoB BO6G170320002 DWB858_COB_G DWB858_COB B promotedtoB promotedfromOtoB BO6G170321001 ETL0020_COB_G ETL0020_COB B promotedtoB promotedfromOtoB DB2G170321001 BVL0020_COB_G BVL0020_COB D promotedtoD promotedfromBtoD DB2G170321001 BVL013_COB_G BVL013_COB D promotedtoD promotedfromBtoD DB2G170321002 DWB858_COB_G DWB858_COB D promotedtoD promotedfromBtoD DB2G170321002 ETL0020_COB_G ETL0020_COB D promotedtoD promotedfromBtoD DB5G170320001 ETL0020_COB_G ETL0020_COB D promotedtoD promotedfromBtoD DB5G170320002 DWB858_COB_G DWB858_COB D promotedtoD promotedfromBtoD DB6G170320001 DWB858_COB_G DWB858_COB D promotedtoD promotedfromBtoD DB6G170320002 DWB858_COB_G DWB858_COB D promotedtoD promotedfromBtoD
- 23. Choosing Action Source to Target Stage view in ONE STREAM: starts looking familiar • 6 months of data, all streams data but filtered on one only target stream ? ? ?
- 24. Choosing Action Scenario Source to Target Stage view in ALL STREAMS: discovery begins 10 months of data. Detailed View of testing Activities in All Corridors
- 25. Defining scope: ALL STREAMS ACTIVITIES
- 26. Choosing 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 promotedtoB promotedfromOtoB promotedfromO(Stream2) toB(Stream2) BO2G170321001 BVL013_COB_G BVL013_COB B promotedtoB promotedfromOtoB promotedfromO(Stream2) toB(Stream2) BO2G170321002 DWB858_COB_G DWB858_COB B promotedtoB promotedfromOtoB promotedfromO(Stream2) toB(Stream2) BO2G170321002 ETL0020_COB_G ETL0020_COB B promotedtoB promotedfromOtoB promotedfromO(Stream2) toB(Stream2) BO5G170320001 ETL0020_COB_G ETL0020_COB B promotedtoB promotedfromOtoB promotedfromO(Stream5) toB(Stream5) BO5G170320002 DWB858_COB_G DWB858_COB B promotedtoB promotedfromOtoB promotedfromO(Stream5) toB(Stream5) BO6G170320001 DWB858_COB_G DWB858_COB B promotedtoB promotedfromOtoB promotedfromO(Stream6) toB(Stream6) BO6G170320002 DWB858_COB_G DWB858_COB B promotedtoB promotedfromOtoB promotedfromO(Stream6) toB(Stream6) BO6G170321001 ETL0020_COB_G ETL0020_COB B promotedtoB promotedfromOtoB promotedfromO(Stream6) toB(Stream6) DB2G170321001 BVL0020_COB_G BVL0020_COB D promotedtoD promotedfromBtoD promotedfromB(Stream2) toD(Stream2) DB2G170321001 BVL013_COB_G BVL013_COB D promotedtoD promotedfromBtoD promotedfromB(Stream2) toD(Stream2) DB2G170321002 DWB858_COB_G DWB858_COB D promotedtoD promotedfromBtoD promotedfromB(Stream2) toD(Stream2) DB2G170321002 ETL0020_COB_G ETL0020_COB D promotedtoD promotedfromBtoD promotedfromB(Stream2) toD(Stream2) DB5G170320001 ETL0020_COB_G ETL0020_COB D promotedtoD promotedfromBtoD promotedfromB(Stream5) toD(Stream5) DB5G170320002 DWB858_COB_G DWB858_COB D promotedtoD promotedfromBtoD promotedfromB(Stream5) toD(Stream5) DB6G170320001 DWB858_COB_G DWB858_COB D promotedtoD promotedfromBtoD promotedfromB(Stream6) toD(Stream6) DB6G170320002 DWB858_COB_G DWB858_COB D promotedtoD promotedfromBtoD promotedfromB(Stream6) toD(Stream6)
- 28. Choosing 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
- 30. ? ?
- 32. Choosing 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
- 34. Choosing Action_FINAL COMBINED WITH CASE_key _SCEN 0 CASE_key _SCEN1 CASE_key _SCEN11 Action_Scenari o 0 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
- 36. Picture of Stream1 – Back to the initial scope and mission of Process Mining Exercise ? ?
- 37. Final Thoughts • 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 or 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