Report for February 2019

Project Manager's Commentary  

DTI005 - ETL Tool Implementation 

Discretionary

Milestones

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

08-Mar-2019      Project Delivery

22-Mar-2019      Project Closure

RAG

AMBER 

Report by Andy Stewart  for Feb 2019 

Achievements in Last Period

• Live environment built
• Org Hierarchary successfully migrated to the enterprise cloud infrastructure on Dev and scheduled to run on a daily basis
• User training continues with 
  • on-going ODT training being completed
  • facilitated training for Data Integration Advanced
  • facilitated training for Cloud Administration 
• Ongoing investigations with build issues to resolve namely;
  • database authentication 
  • debugging 

Top Issues

• Potential for resource contention on key Dev Tech resource: situation to be monitored
• Loss of BI reports from Test environment has delayed the migration of Org Hierarchy into Test for user testing 
• Project budget is currently projecting a 20% overspend to complete remaining activities 
• Acceptance Sign-Off delayed due to build issues Org Hierarchy related issues 

Key Next Steps

• Resolve remaining build issues associated with 
  • database authentication 
  • debugging
• Determine process for single version of code to enable deployments to Dev, Test and Live environments 
• Continue with ODT training.
• Migration of Org/Hierarchy to enterprise cloud infrastructure on both Test and Live environments 
• Determine handover and post project support requirements 
• Complete Acceptance Sign-Off

Overall, the project is reporting AMBER due to budget concerns.

DTI021 - EDW Embed & Optimise 

Discretionary

Milestones:

RAG: AMBER 

Report by Anne Mathison for February 2019

Achievements

• 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

Issues 

• 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