Report for November 2017

DTI005 ETL Tool Implementation  

 Planned to start Apr-18

Project Manager's Commentary  

DTI004 - ETL Tool Procurement

Discretionary

Milestones

11-Aug-2017  ITT Issued

18-Dec-2017 Project Delivery

08-Jan-2018 Project Close    

RAG

RED

Report by Nick Graham for November 2017 

Achievements in Last Period

• Business case agreed by stakeholders and approved by project sponsor.
• Expenditure request re-submitted to CIO - approval awaited.    
• Procurement resource confirmed and committed to project.
• ITT specification, minimum requirements and award criteria re-drafted and in review.
• Procurement strategy re-drafted and in review.      

Issues

• Budget for software procurement not approved.  To be escalated.

Next Steps

• Complete, approve and issue ITT. 
• Re-plan project completion on basis of confirmed timescales of the above.

The project is reporting RED.

DTI006 - EDW Implementation 

Discretionary

Milestones

15-FEB-18    Org Hierarchy ASOR 09-MAR-18   Infrastructure Build Complete 16-MAR-18   Deployment 02-APR-18    Project Close

RAG

GREEN

Report by Chris Lawford for November 2017

Achievements in Last Period

• DEV build in progress. Progress is being made, but slower than planned. This is due to the complexities of the bespoke DEV build. It should be noted that the EDW build is at the technical leading edge, and a lot of the experience gained will prove useful for other non-DTI work.  
• Meeting held with IS Apps Management to review the approach to the analysis and design of an adapted BI/MI service organization. The proposed process was approved.
• Org / Hierarchy build staging to foundation complete; foundation to access in progress.
• Project re-planned around delays to DEV build (see above).  

Issues

• Slow progress on DEV infrastructure build (see above).
• BA requested for BI/MI service organisation work; yet to be assigned.   

Next Steps

• Complete DEV build.
• Complete Org / Hierarchy development.
• Commence BI/MI service organisation analysis.

The project is currently reporting GREEN.

DTI019 - BI/MI Analysis Toolkit 

Discretionary

Milestones

RAG

AMBER

Report by Sue Woodger for November 2017

Achievements

• Expecting BI/MI Analysis Toolkit v2.0 10 November 17 - eventually submitted on 22 November 17

Issues

• Expected toolkit on 10^th November. Project manager informed consultant that although she was on leave on the Monday 13 to Wednesday 15 she would review the toolkit on the Friday night (10^th) before going on holiday and would circulate to reviewers. Toolkit did not arrive on the 10^th or the 13^th. PM asked Estates BA to chase up in her absence. Consultant informed that the toolkit would be with us by cop 15 November.
• 15 November consultant informed that due to the feedback on the Estates document meant that Toolkit would not be coming on the 15^th and he would pick that back up on the 16^th November. PM asked for a revised date for the toolkit but the consultant asked when we were going to reschedule it! PM explained that she needed consultant to provide a date as she was not re-arranging reviewers until we had confidence in a date.
• Finally received the toolkit on 22 November although we had to email for updated links as the links the consultant sent were to the old version. We were expecting that this draft of this work to be as close to the final version as possible.  Reviewers were in agreement that the document was a huge disappointment. Link to Feedback document
• Programme manager fed back the comments to the consultant and his manager adding that we were disappointed with the overall contents and quality of the toolkit and that a considerable amount of rectification will be required their part before UoE were prepared to sign it off.
• Following a call with Consultancy the Managing Director acknowledged to programme manager that their company had dropped the ball on this one and would provide a plan of action to remedy.   
• They have agreed to re-issue a draft of the BI/MI Analysis Toolkit on the afternoon of Friday 8 December (after 3pm) with a view to reviewing this with programme manager first then sponsor and project manager on 11 December. A review by skype is arranged for Tuesday 12 December at 9am. 

Next Steps

• A review by skype is arranged for the new version of the toolkit on Tuesday 12 December at 9am.
• Revise closure date

RAG Commentary: Project is Amber as remedial work to be done by consultants (as the overall contents and quality of the deliverable was substandard and disappointing). This will impact the delivery and closure dates and revised dates will be submitted when we see the quality of the revised deliverable on 11 December.

DTI022 - EDW Business Engagement  

Discretionary

Milestones

15-SEP-17              Planning Complete

22-DEC-17             Project Delivery

14-JAN-17             Project Close

RAG

GREEN

Report by Geoff  Cropley for November 2017

Achievements in Last Period

Project deliverables are progressing and are on track for delivery.

EDW Wiki has been established and draft communications and governance, strategy and plans have been produced and formal acceptance is planned during December 2017. 

Draft Business Engagement process have been produced and will be submitted for approval during December.

Data Migration Strategy Options paper to be produced by end of December 2017.

Issues

None to report

Next Steps

Sign off deliverables for Communications, Governance and Business Engagement.

Prepare Migration Strategy Options paper and Requirements Gathering Process and present.