Report for June 2018

Report Date
June 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 LIVE build complete. “EDW Production Ready” milestone reached.   
  • Org/Hierarchy solution ready for deployment.
  • ETL Implementation project in progress.
  • EDW Embed & Optimise project initiated.

Top Issues

  • Approval for proposed 18/19 budget.
  • Achieving project closure on DTI019: BI/MI Analysis Tool-kit.

Key Next Steps

  • Close EDW implementation project.
  • Close ETL procurement project.  
  • Close BI/MI Analysis Tool-kit project.

Overall the programme is reporting GREEN.

 

Status and Forward Look

Resource Summary

Section Two: Projects Not Started

Project Info Project Manager's Commentary
       
   

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 June 2018 

Achievements in Last Period

  • PO Issued.
  • We have agreed to purchase call-off consultancy as detailed in contract.

Issues

  • PM has not had time to progress project closure.

Next Steps

  • Purchase call-off consultancy
  • 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 Craig Moore for June 2018 

Achievements

  • Engagement with suppliers has begun

Issues

  • The current deadline for activities to be completed by the end of the financial year may not be met due to delays in the associated procurement project
  • A PICCL is being raised to move the planning milestone. The rest of the milestones shall be re-baselined to reflect this. 

Next Steps

  • Plan workshop
  • Plan architectural options paper for project board sign-off

 

 

 

DTI006 - EDW Implementation 

 

 

Discretionary

Milestones

26-JUN-18           Infrastructure Build Complete

16-JUL-18           Deployment

03-AUG-18          Project Close and DSOR

RAG

GREEN

Report by Lee-ann Simpson for June  2018

Achievements

 

  • Infrastructure Build Complete Milestone achieved – We now have a ‘Production Ready’ Enterprise Data Warehouse;
  • Deployment Checklist completed;
  • Go CAB approved deployment to LIVE environment for Production;
  • Parameritisation completed and pushed out to environments

Issues 

  • Security Patch applied to DEV which locked the container to all users.  DEV had to be rolled back which caused a delay to EST109 development.  Security patch has been applied to TEST and LIVE and will be applied to DEV once EST109 demonstrations have been completed;
  • Some items within DTI006 have been descoped and will be carried across to DTI021 (EDW Embed and Optimise) for completion

Next Steps 

  • EDW Implementation to completed before EDW is deployed on the 16th July;
  • TAD to be signed off by CISO;
  • DSOR to be completed;
  • Parameritisation documentation to be completed.

The project showing as GREEN with focus continued on deployment and close of the project.

 

DTI019 - BI/MI Analysis Toolkit 

 

Discretionary

Milestones

18-Jul-2018

Redrafting of toolkit as UoE toolkit (new)

20-Jul-2018

Delivery of BI/MI Analysis Toolkit into overarching BI/MI Projects toolkit

25-Jul-2018

Delivery Review

30-Jul-2018

Close

 

RAG

GREEN

Report by Sue Woodger for June 2018

Achievements

  • Reviewed toolkit v1.2 with programme manager and project sponsor and sponsor is now helping with language in the toolkit to make it BI/MI centric.

Issues

  • Project sponsor on leave so unable to complete in timescales – revised timescales now available and approved by WIS
  • WIS approved revised milestones on 25 June but asked for Iain Fiddes and Mark Ritchie to review and approve the milestones

Next Steps

  • Finalise toolkit to version 2 and sign off
  • Agree how to deliver into overarching BI/MI projects toolkit
  • Close project

 

RAG Commentary: Project is GREEN as revised milestones approved

DTI021 - EDW Embed & Optimise 

 

Discretionary

Milestones

RAG: Green

Report by Lee-Ann Simpson for June 2018

Achievements in Last Period

  • Project initiated via WIS on 22nd June with an anticipated planning date of 13th July.

Issues

  • Delay in project start date,  due to delays in completion of predecessor project DTI006 EDW Implementation. Kick-off efforts commenced in the second half of June.

Next Steps

  • Complete Planning phase of the project

The project is reporting GREEN,as the project has now been initiated and is in the planning phase.

 

Section Four: Closed or Withdrawn Projects

DTI003 Withdrawn

COM029 Proof of concept project has now been closed. 

DTI022 Business Engagement has now been closed.