Report for April 2018

Report Date
April 2018

Report compiled by Chris Lawford (Programme Manager) for Alex carter (Programme Owner)

Section One: Programme Commentary, RAG and Resources Update

Programme Commentary

Key Achievements in Last Period

  • EDW TEST build complete, LIVE in progress. Good progress continues to be made.
  • Org/Hierarchy solution in UAT.
  • Business Engagement project completed.
  • EDW-adapted BI/MI Service Organisation 1st draft completed and under review.

Top Three issues

  • Resolving Project Mgmt resourcing issues
  • Maintaining progress on EDW infrastructure build.
  • Finalisation of ETL Procurement Contract award.
  • Achieving project closure on DTI019: BI/MI Analysis Tool-kit.

Key Next Steps

  • Complete LIVE infrastructure build.
  • Award of ETL contract, planning & kick-off of the implementation project.
  • Achieving project closure for BI/MI Analysis Tool-kit.
  • Approval of 18/19 Budget.

Overall the programme remains at AMBER, with an expectation that it will return to GREEN once the project management resourcing issues have been resolved, the ETL contract is awarded and 18/19 budget has been approved at the DTI governance level.

Status and Forward Look

 

Resource Summary

 

Section Two: Projects Not Started

Project Info Project Manager's Commentary
DTI021 EDW Embed & Optimise    

 Planned to start May-18

 
   

Section Three: Projects in Progress

Project Info

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 1st 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 

16-Feb-2018 Redrafting of toolkit as UoE toolkit (new)
09-Mar-2018 Approval by Operational Guidance Committee
13-Mar-2018 Delivery of BI/MI Analysis Toolkit into overarching BI/MI Projects toolkit
20-Mar-2018 Delivery Review
23-Mar-2018 Close

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.

 

Section Four: Closed or Withdrawn Projects

DTI003 Withdrawn

COM029 Proof of concept project has now been closed. 

 

 

Documentation

Not available.