Report for March 2018

DTI005 ETL Tool Implementation  

 Planned to start Apr-18

Project Manager's Commentary  

DTI004 - ETL Tool Procurement

Discretionary

Milestones

15-Dec-2017  ITT Issued

28-Mar-2018 Project Delivery

13-Apr-2018 Project Close    

RAG

RED

Report by Nick Graham for March 2018 

Achievements in Last Period

• Clarifications to outstanding questions received.
• Award letters issued to bidders. 
• Commercial payments basis agreed internally - repeated annual subscription payment. 
• Commercial negotiations begun.

Issues

• Issue - Project forecasting overspend of 38 days against agreed budget.  This includes 6.8 days to be cross-charged to DTI005 for the start of that project.  The remaining overspend is due to greater than planned effort in assessing suppliers' bids and will be resolved at Portfolio Level.  For information only:  no SMT action required.         

Next Steps

• Completion of commercial negotiations.
• Project delivery.
• Project closure.

The project is reporting RED.

DTI006 - EDW Implementation 

Discretionary

Milestones

19-APR-18           Org Hierarchy ASOR

11-MAY-18           Infrastructure Build Complete

18-MAY-18           Deployment

04-JUN-18          Project Close

RAG

AMBER

Report by Chris Lawford for March 2018

Achievements in Last Period

• TEST build started. Good progress made.
• Org/hierarchy application deployed to DEV.  
• BI/MI Organisation RACIs “Run the Service” & “Change the service” drafts complete.   
• Governance submitted and approved to modify milestones and increase budget. 

Issues

• Maintaining progress on infrastructure build through to project completion.      

Next Steps

• Complete TEST build.
• Commence LIVE build.
• Complete deployment of Org/Hierarchy to TEST.
• Execute Org/Hierarchy UAT; achieve ASOR. 
• Run “Small Changes” workshop, complete BI/MI service RACI draft.

The project continues to report AMBER given the history of uncertainty around infrastructure build. Successful completion of the TEST infrastructure build will give sufficient confidence to return to GREEN.

DTI019 - BI/MI Analysis Toolkit 

Discretionary

Milestones

RAG

AMBER

Report by Sue Woodger for March 2018

Achievements

• 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

Issues

• 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  

Discretionary

Milestones

15-SEP-17              Planning Complete

24-JAN-18             Project Delivery

31-JAN-18             Project Close

RAG

GREEN

Report by Geoff  Cropley for March 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 April.

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

Issues

None to report.

Next Steps

Continue deliverables sign-off, handover and close project.