Report for April 2018

 Planned to start May-18

Project Manager's Commentary  

DTI004 - ETL Tool Procurement

Discretionary

Milestones

28-Mar-2018 Project Delivery

13-Apr-2018 Project Close    

RAG

AMBER

Report by Chris Lawford for April 2018 

Achievements in Last Period

• Commercial negotiations in progress.

Issues

• We need to reach contract award asap, in order to start the ETL Implementation project. Sticking point is the payment schedule – an updated proposal has been submitted to the vendor; we trust agreement is imminent.

Next Steps

• Contract Award
• Project closure

The project is reporting AMBER, in acknowledgement of the late project delivery milestone.

DTI005 - ETL Tool Implementation 

Discretionary

Milestones

02-APR-18           Project Start

20-APR-18           End of Planning

31-AUG-18          Project Delivery 14-SEP-18            Project Closure   

RAG

AMBER

Report by Chris Lawford for April 2018 

Achievements in Last Period

• Project planning phase initiated.

Issues

• Project manager has left UofE. On boarding a replacement.

Next Steps

• TBA

The project is reporting AMBER, due to lack of a project manager.

DTI006 - EDW Implementation 

Discretionary

Milestones

19-APR-18           Org Hierarchy ASOR

11-MAY-18           Infrastructure Build Complete

18-MAY-18           Deployment

04-JUN-18          Project Close

RAG

AMBER

Report by Chris Lawford for April 2018

Achievements in Last Period

• TEST build complete, LIVE build in progress.
• Org/hierarchy application deployed to TEST and in UAT.
• EDW Adapted BI/MI Service Organisation Document 1^st draft complete and under review.

Issues

• Maintaining progress on infrastructure build through to project completion.
• Replacement PM required to complete project, as the existing PM has been assigned additional work in the BI tools programme.

Next Steps

• Engage & Transfer project to new PM.
• Commence LIVE build, achieve “Infrastructure Build Complete” milestone.
• Complete Org/Hierarchy UAT; achieve ASOR.
• Achieve Deployment.
• Complete sign-off of adapted BI/MI Service Document.
• Commence Project close activities.

The project continues to report AMBER. Return to GREEN dependent upon appointment of a replacement PM to maintain focus through to project close.

DTI019 - BI/MI Analysis Toolkit 

Discretionary

Milestones

These are in the middle of being revised 

RAG

AMBER

Report by Sue Woodger for April 2018

Achievements

• No achievements this month – see issues

Issues

• PM had to take on 2 new projects and had deadlines for the project briefs which meant the toolkit update was delayed
• Due to PM family leave, sick leave and other higher priority projects taking precedence the PM has been unable to give her attention to this project. Timescales have had to be revised

Next Steps

• Update of revised toolkit
• Revise milestones

RAG Commentary: Project is AMBER  as milestones have to be revised. PM has been on family leave and sick leave and other projects have taken priority

DTI022 - EDW Business Engagement  

Discretionary

Milestones

31-JAN-18             Project Close

RAG

BLUE

Report by Geoff  Cropley for April 2018

Achievements in Last Period

All project deliverables have been completed  and handed over to the business.

The project is now closed.

Outcome

Explanation for variance

The original estimate of 100 days to complete the tasks had been high as It was difficult to predict the level of effort and the number of resources required whilst assessing the current warehouse environment.   Additionally, less work was required to establish the stakeholder community and to produce the communications strategy and plan.  Time recording for a number of people did not materialise on Asta and this lead to actual effort recorded being less than the estimate. 72 days were recorded to complete the deliverables.

Outstanding Issues

The use of the outputs from the deliverables must now be driven forward including; 

• Governance structure and operating model implementation
• EDW follow-on project team to support business unit acquisition to be formalised to resource and maintain data acquisitions 
• Funding arrangement to support data acquisition to be confirmed

Additionally, there has to be ongoing and regular communications with customers to manage the pipeline of demand and maintain the business value in using the EDW.

These outstanding points are currently being driven forward by Service Management and the Programme Owner.

Issues

None to report.