Report for February 2018

Report Date
February 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 DEV environment build complete, TEST commenced. 
  • ETL Procurement:  Evaluation phase complete, announcement on outcome imminent.
  • BIMI Service RACI – first draft available, consensus meetings in progress.

Top 3 issues

  • Delays in EDW build process; assessment of knock-on effects.
  • Turning ETL outcome into a contract award as quickly as possible.
  • Funding approval for Oracle Advanced Security, in order to conform with EDW security policy.       

Key Next Steps

  • Closely monitor TEST build progress.
  • Award of ETL contract, planning for implementation project.
  • Approval of 18/19 Budget.   

The programme continues to report AMBER until impact of EDW build delay is assessed. 

Status and Forward Look


Resource Summary

Section Two: Projects Not Started

Project Info Project Manager's Commentary

DTI005 ETL Tool Implementation  

 Planned to start Apr-18  
DTI021 EDW Embed & Optimise    

 Planned to start Apr-18


Section Three: Projects in Progress

Project Info

Project Manager's Commentary  

DTI004 - ETL Tool Procurement






15-Dec-2017  ITT Issued

28-Mar-2018 Project Delivery

13-Apr-2018 Project Close    



Report by Nick Graham for February 2018 

Achievements in Last Period

  • Responses evaluated against award criteria and accessibility requirements.
  • Bidders' product demonstrations completed.
  • Bidders' evaluation product instances accessed. 
  • Scoring completed - minor clarifications awaited from bidders prior to confirmation of decision.  


  • Project forecasting overspend of 30 days against agreed budget.         

Next Steps

  • Confirmation of selection decision.
  • Commercial negotiation.
  • Project delivery.


The project is reporting AMBER.



DTI006 - EDW Implementation 





22-MAR-18           Org Hierarchy ASOR

13-APR-18             Infrastructure Build Complete

20-APR-18             Deployment

07-MAY-18            Project Close



Report by Chris Lawford for February 2018

Achievements in Last Period

  • DEV build completed 27/02. Some snagging items still in progress, but will not hold us up.   A significant number of items have been deferred - to be included as potential scope items for “Embed & Optimise” follow-on project.
  • Org/hierarchy application deployment to DEV in progress.
  • BI/MI service organisation RACI reviews in progress.     
  • TEST build in progress.


  • Slow progress on DEV infrastructure build, knock-on effect for TEST/LIVE build.

Next Steps

  • Complete TEST build.
  • Commence LIVE build.
  • Complete deployment of Org/Hierarchy to DEV/TEST.
  • Complete Org/Hierarchy UAT. 
  • Continue BI/MI service organisation analysis.

The project is currently reporting AMBER, due to the late delivery of Dev infrastructure and knock-on effects. To be reviewed and milestones/costs adjusted as required.



DTI019 - BI/MI Analysis Toolkit 




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



Report by Sue Woodger for February 2018


  • Revised milestones approved by WIS 26 January 18
  • PM drew up a revised toolkit document but on consultation with other analysts working on BI there needs to be changes


  • PM had to take on 2 new projects and had deadlines for the project briefs which meant the toolkit update was delayed
  • Snowstorm and closure of university delayed the review of the revised toolkit

Next Steps

  • Update of revised toolkit
  • PM to reconsider milestones as redrafting delayed


Project is amber as milestones are to be reviewed

DTI022 - EDW Business Engagement  





15-SEP-17              Planning Complete

24-JAN-18             Project Delivery

31-JAN-18             Project Close



Report by Geoff  Cropley for January 2018

Achievements in Last Period

All project deliverables have been completed and handover to the business owner is underway.   Project closure is expected to complete later in March.

Personnel changes have extended the closure date and meetings have been arranged to confirm deliverables complete.


None to report.

Next Steps

Continue deliverables sign-off, handover and close project.

Handover outcomes to business owner.


Section Four: Closed or Withdrawn Projects

DTI003 Withdrawn

COM029 Proof of concept project has now been closed.