Report for September 2017

DTI005 ETL Tool Implementation  

 Planned to start Jan-18

Project Manager's Commentary  

DTI004 - ETL Tool Procurement 

Discretionary

Milestones

11-Aug-2017  ITT Issued

08-Nov-2017 Project Delivery

23-Nov-2017 Project Close    

RAG

AMBER

Report by Nick Graham for September 2017

Achievements in Last Period

• Procurement strategy of '1 year plus review' engagement agreed and approved by programme board.  
• ITT drafting and review in progress.    
• Business case drafted and in review. 
• Completion of project re-planned, agreed by stakeholders and programme board, awaiting authorisation by WIS.  

Issues

• Market engagement, procurement strategy & ITT production have over-run, leading to overspend.  Re-costed and re-scheduled plan for completion approved by stakeholders was submitted to WIS for authorisation 29th Sept and then overwritten.  Re-submitted to WIS for 6th Oct.  Approval will return project to GREEN.   
• Business Case supporting ITT has not yet been approved.

Next Steps

• Confirm ITT and issue. 
• Receive responses. 
• Begin evaluation.

The project is reporting AMBER.

Issues - Market engagement, procurement strategy & ITT production have over-run, leading to overspend. Re-costed and re-scheduled plan for completion approved by stakeholders was submitted to WIS for authorisation 29th Sept and then overwritten.  Re-submitted to WIS for 6th Oct.  Approval will return project to GREEN.    No further SMT action required.  

DTI006 - EDW Implementation 

Discretionary

Milestones

21-JUL-17            Planning Complete

29-SEP-17            Design Phase Complete

24-NOV-17          Org Hierarchy ASOR

06-DEC-17           Infrastructure Build Complete

08-DEC-17           Deployment

12-JAN-18           Project Close

RAG

AMBER

Report by Chris Lawford for September 2017

Achievements in Last Period

• Security Policy broadly agreed. The remaining open issue is the need for encryption-at-rest for confidential data (see below).
• Technical architecture design complete, and in final stages of approval. We will use Oracle as the DB platform. We will create a bespoke, separate VMware Oracle based platform. We do not require any additional Oracle license options for the initial build.
• Org / Hierarchy application design complete. We will build Org /hierarchy using Talend Open source ETL.
• SSIS Dev build complete. This is our back-up ETL tooling option.

Issues

• The decision on the need for encryption-at-rest has been deferred current security policy; we will not have confidential data in the initial build. This issue is enterprise wide, and will be taken forward outwith the programme (Dave Berry).
• The project was planned with an assumption EDW would be built using a standard Oracle platform. This is not the case, and additional time and effort will be required. The project will be re-planned to accommodate.

Next Steps

• Commence DEV build
• Start Org/ Hierarchy development.
• Start Development Organisation discussions.

The project is currently reporting AMBER, until such time as the project has been re-planned and approved.

DTI019 - BI/MI Analysis Toolkit 

Discretionary

Milestones

RAG

GREEN

Report by Sue Woodger for September 2017

Achievements in Last Period

• Consultant provided a walkthrough of ideas for the toolkit. He will provide access to his initial slides for Project Services input and will update the toolkit based on programme manager and project manager input. A second draft of the toolkit is expected by 6 October.

Issues

• Have to keep reminding consultant to send highlight reports

Next Steps

• BI/MI Analyst to provide second draft of toolkit by 6 October

RAG Commentary: n/a  

DTI022 - EDW Business Engagement  

Discretionary

Milestones

15-SEP-17              Planning Complete 22-DEC-17             Project Delivery 14-JAN-17             Project Close

RAG

AMBER

Report by Geoff  Cropley for September 2017

September 2017

Achievements in Last Period

Initial kick-off session held confirming approach objectives and deliverables.  Further refinement of activities is continuing will be agreed at the next workshop to be held on 3rd October.

Project planning  is expected to complete with Asta and project brief  submitted by 13th October 2017.

Issues

• It has taken longer than expected to reach end of planning. The plan will have to be reviewed and adjusted to account for the delay.

Next Steps

• Continue planning and estimating
• Agree Project Brief, risks issues and dependencies

The project is reporting AMBER, until planning is complete.