Report for September 2017

Report Date
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.

Project Status
RAG Status
Time
AMBER
Cost
AMBER
Scope
GREEN
Overall
AMBER
RAG Commentary
ISSUE: Project requires re-plan now that technical architecture has been defined.
Change Status
Activity
Approved budget
230.0 days
Activity this month
41.4 days
Activity this year
70.1 days
Activity to date
118.2 days
Estimate to complete current year
126.3 days
Estimate to complete future years
0.0 days

Project Info

Project
EDW Implementation
Code
DTI006
Programme
Digital Transformation - Enterprise Data Warehouse
Management Office
ISG PMO
Project Manager
Lee-Ann Simpson
Project Sponsor
Dave Berry
Current Stage
Close
Status
Closed
Start Date
01-May-2017
Planning Date
n/a
Delivery Date
n/a
Close Date
03-Aug-2018
Overall Priority
Highest
Category
Discretionary