Report for March 2019

Report Date
March 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
  • Talend environments built.
  • Talend Training started.  

Top Issues

  • Some delays in Embed & Optimise project, re-planning exercise in progress.
  • Additional budget required to complete Talend Implementation.

Key Next Steps

  • Monitor progress on inflight projects, prepare for project closures and support project managers.
  • Prepare for programme closure.
  • Secure budget needed to complete the programme (this has now been done, hence the green RAG status).

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 



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

05-Apr-2019      Project Delivery

12-Apr-2019      Project Closure



Report by Andy Stewart  for March 2019 

Achievements in Last Period

  • Technical Architect Document updated and circulated to the project team to review 
  • Development 
    • Talend / GIT credential encryption - solution identified and implemented 
    • Ability to ustilise same code across all environments implemented
  • Accessibility review meeting scheduled for 4th April 

Top Issues

  • Revised project plan and estimate was not approved at WIS due to

  • Additional tasks associated with 

    • preparing an updated Development Standards guide 
    • on-going Talend support requirements 

Key Next Steps

  • Technical Architect Document review meeting scheduled for 4th April 
  • User On Demand Training to be completed 
  • Deployment of Org Hierarchy to Test and Live to be scheduled after testing completed via DTI021


Overall, the project timeline will require to be extended to deliver a Development Standards guide and confirm Talend support arrangements going forward. This has still to be re-planned and estimated


DTI021 - EDW Embed & Optimise 




Stage Milestone
Archiving Strategy 15-Mar-2019
Complete Technical Set-Up 15-Mar-2019
Access Layer Design 15-Mar-2019
Org hierarchy active/inactive logic 15-Mar-2019
Operational Handover 19-Mar-2019
Delivery Review (Major) 25-Mar-2019
Security - TDE 25-Mar-2019
Privacy Impact Assessment (PIA) 26-Mar-2019
Project Closure (Major) 29-Mar-2019


Report by Anne Mathison for February 2019


  • Project handover completed to new PM - Anne Mathison, who has 1.0 days a week until end of March

    • Replanned 1.25 days a week in March.
  • Although PIA completed and shared with the Universities DPA Champion for review it has not been signed off and there is zero budget left for this.
    • Service management have agreed to write up the situation
  • Operational Handover is underway
  • Security patching in Live was completed to bring it in line with the current patching in Dev and Test
  • Revised Archiving Strategy been updated
  • Some technical documentation has been updated


  • Programme Manager now works 2 days per week (offsite) which may impact upon the DTI021 project.

Next Steps

  • Milestones and budget revised
  • Progression of the EDW TDE within the EDW DEV environment.
  • Operational Handover to be completed with the Production (Apps Man) team.
  • Security patches to be completed in Dev, Test and Live
  • Complete Technical set up
  • Privacy Impact Assessment written up
  • Org Hierarchy active/inactive logic complete
  • Archiving strategy complete
  • Access Layer Design complete
  • Technical documentation complete


The project is reporting AMBER.  Revised Budget and milestones have been revised; 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.95 KB