Report for January 2018

Report Date
January 2019

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 Embed & Optimise project in progress. Handed over to replacement project manager.
  • Talend Implementation project in progress. Handed over to replacement project manager.  
  • EDW programme mgmt secured through to expected end of programme.  
  • Talend Dev and Test environment build completed.
  • Talend Training started.  

Top Issues

  • Potential for resource contention on key Dev Tech resource: situation being monitored.
  • Establishment of an interim support model across core EDW and the early adopter solutions.    

Key Next Steps

  • Monitor progress on inflight projects, assist and support newly appointed project managers.
  • Prepare for programme closure.

Overall the programme is reporting GREEN.

Status and Forward Look

(see programme financials)

Resource Summary


Section Two: Projects Not Started

Project Info Project Manager's Commentary

Section Three: Projects in Progress

Project Info

Project Manager's Commentary  

DTI005 - ETL Tool Implementation 



11-Jan-2019        Design Sign-off 

08-Feb-2019       Infrastructure Build Complete

01-Mar-2019      Acceptance Sign-off (ASOR)

08-Mar-2019      Project Delivery

22-Mar-2019      Project Closure



Report by Chris Lawford for Jan 2019 (on behalf of Andy Stewart)  

Achievements in Last Period

  • Technical architecture design complete.
  • Training planning, procurement, scheduling completed. Training commenced.    
  • Dev, Test environments built and smoke testing complete.
  • Project handed over to replacement PM.

Top Issues

  • Potential for resource contention on key Dev Tech resource: situation to be monitored.

Key Next Steps

  • Perform Live environment build, achieve “infrastructure build complete” milestone.
  • Continue with training.
  • Migration of Org/Hierarchy to enterprise infrastructure.

Overall, the project is reporting GREEN.


DTI021 - EDW Embed & Optimise 




Stage Milestone Due Date Previous Date Complete  
Plan Planning (Major) 17-Aug-2018 No date available Yes


Execute Tech Guidelines for Data Acquisition Projects 31-Aug-2018 No date available Yes


Execute Privacy Impact Assessment (PIA) 18-Jan-2019 07-Sep-2018 No


Execute Operational Handover 01-Feb-2019 28-Sep-2018 No


Execute Security - TDE 22-Feb-2019 05-Oct-2018 No


Execute Complete Technical Set-Up 01-Mar-2019 02-Nov-2018 No


Execute Org hierarchy active/inactive logic 01-Mar-2019 16-Oct-2018 No


Execute Archiving Strategy 08-Mar-2019 28-Sep-2018 No


Execute Access Layer Design 15-Mar-2019 31-Aug-2018 No


Deliver Delivery Review (Major) 22-Mar-2019 09-Nov-2018 No


Close Project Closure (Major) 29-Mar-2019 16-Nov-2018 No



Report by Richard Bailey for Jan 2019


  • Project handover to be completed to new PM - Richard Bailey, who has 0.5 day a week availability going forward.
  • PIA completed and shared with the Universities DPA Champion for review prior to sign off, meeting booked for 06-Feb-2019.
  • Agreement with CISO to progress with EDW TDE Implementation obtained via the Development Team.
  • Wiki DEV environment recreated to remove the EDW TDE.



  • Project Manager moved to another area of the University which meant a handover had to be completed in order for the new Project Manager to be able to pick up and progress the project, Project Manager allocation / availability, though handed over is not as high as it was previously (dropped to .5 day a week).
  • Programme Manager now works 2 days per week (offsite) which may impact upon the DTI021 project.


Next Steps

  • Progression of the EDW TDE within the EDW DEV environment.
  • Operational Handover to be completed with the Production (Apps Man) team.


The project is reporting AMBER.  Project is on budget / time frame for now; however, due to the lack of contingency - it will remain at amber


Section Four: Closed or Withdrawn Projects

DTI003 Withdrawn

DTI004 ETL Procurement has now been closed. 

DTI006 EDW Implementation has now been closed. 

DTI019 BI/MI Analysis toolkit has now been closed. 

COM029 Proof of concept project has now been closed. 

DTI022 Business Engagement has now been closed. 



Image icon capture-resource-summary.png16.85 KB