Report for June 2018

Report Date
June 2018

DRAFT

 

Report compiled by  Morna Findlay (IS Apps Programme Manager)

for Jim McGeorge (USG), Niall Bradley (CAM),  Steven Ross (CAM) , Ailsa Vamplew (CAM) , Sheila Williams (SDS), Jane Johnston (SRA),  Damon Querry (RIS), Sara Cranston (Records Management), Rena Gertz (GaSP), Isabell Majewsky Anderson (Edinburgh Global) and other interested business area owners.

 

 

Section One: Programme Commentary, RAG and Resources Update

Commentary

Overall the STU Programme is RED   because it is now confirmed that  several projects will  not complete  within 17/18 and several projects are RED or AMBER at this time.

STU252 - RED - to be suspended

STU260 - AMBER - milestones likely to change during planning process

STU262- RED - Additional budget approved, delivery milestone delayed as testing not yet completed and support arrangements not yet finalised.

STU261 ( Not started) RED - no solution identified

 

RED and AMBER Programme Risks

 

   

 Risk Status   Owner 
Availability of sharepoint resource RED Alex Carter
Additional compliance work may affect scheduling and budgets of other projects during 2017-18 and 2018-19    AMBER   Jim McGeorge
mobility online may not be decomissioned by Study Away AMBER Jim McGeorge
End of Life of Yii framework may require rewrite of multiple applications AMBER Stefan Kaempf

 

RAG & Forward Look June 2018

   

     

 

Resources to end of June  2018

          

 

 

 

Section Two: Projects Not Started

 

Project Info Programme Manager's Commentary

SRA - Free WiFi at University Open Days

Discretionary

Planning: TBC

Delivery:TBC

RAG Status

RED

Plan

 This project is to undertake the work noted in this proposal. The proposal estimated 10d of work, but it is now clear that this budget is insufficient  enough to deliver a standalone solution for open wifi during open days,

 ITI planned to deliver open wifi using the JISC pilot service but this has not been achieved. Alternative solutions have been estimated to be of significant cost and there is no identified source of funding to deliver these, hence the  project's status as RED.  The issue has been escalated to senior management.

Dependencies

Solution not identified. Funding not identified. Status of  and cost of JISC-solution unclear.

 

Section Three: Projects in Progress

 

Project Info

Project Managers Commentary

STU252 - Worktribe BI Suite Universe - Research Management BI MI Enhancements

Category: Discretionary

Milestones

Provisional  milestones updated on Projects website, will need updated and approved after re-plan, once scope change approved

 Date

Title

27-July 2018 Agree to suspend project until new scope and new budget  is agreed  Governance decision on proposed scope change - accept can't deliver Org unit permissions for IGMM and Roslin within current budget
TBC Acceptance Sign-off
TBC Deploy to LIVE - STAR Schema and BI Suite Universe - and switch on daily refresh package in LIVE
 TBC Deployment sign off Review
TBC Close

 

      

RAG Status

RED

Report by Jamie Thin for June 2018

Achievements in Last Period

  • Project on hold awaiting decision from Business lead re. proposed scope change
  • Business lead has agreed Project should be formally suspended while the RIS team evaluate the use of Power BI against the raw BI Data extract as alternative to the STU252 Star schema and BI Suite Universe
  • Alternative technical solutions to apply org unit permissions reviewed - none are operationally attractive
  • Other project tasks on hold , pending outcome of discussion on scope

Issues

  • Open - No agreement on Scope change re. Org unit permissions
    • Initial proposal of providing no org unit data restrictions have been rejected by Business lead
    • Workaround explored with IS Service Management of applying row level permissions, but doesn't look like it would work for  IGMM and Roslin, and complex data structures with collaborative projects with multiple budgets for each Org unit
  • Open : Resource conflict in IS Project services - PM has limited time to push scope change to conclusion while focusing on higher priority Service Excellence Exam Timetabling project

Next Steps 

  • Propose the project is suspended until either scope change is agreed by the business lead , or project sponsor provides more funding to do some R&D and see if it is possible to complete project closer to original scope , or risk project being closed without delivering a working BI Suite universe.
  • Re-plan with revised scope 
  • R&D to investigate other possible solutions for providing  IGMM and Roslin with their own data in an easy format to report against
  • Deliver remaining JIRAS incl STU252-52 (0.5d effort) 
  • UAT acceptance sign-off
  • Handover to BAU  - Confirm policy decision with IS Service Management re. IS L&UC RIS team access to Universe Designer 
    • propose limited access to Universe Designer for RIS team - so RIS can locally make some simple changes  eg.  rename data items and add 'tool-tip' descriptions of each object 
  • Deploy BI Suite Universe to LIVE, switch on daily package to refresh STAR schema in LIVE
  • Deployment review
  • Project Closure

Milestones

Provisional  milestones updated on Projects website, will need updated after re-plan, once scope change approved

STU253 - PGR Opportunity Finder

Category: Discretionary

Milestones

DateFor security reasons, images aren't duplicated during cloning. Please re-add or replace the image as required. Previous Date Title Stage Complete
25-May-2018 No date available System Design - Research PURE API Design Yes
19-Jun-2018 No date available Build Complete Build No
03-Jul-2018 No date available Integration Complete Integrate No
18-Jul-2018 No date available Acceptance Complete Accept No
26-Jul-2018 No date available Deployment Deliver No
14-Aug-2018 No date available Project Closure Close No
21-Dec-2018 21-Dec-2017 External Milestone: Guidance policy for use of "Willingness to take Ph.D. students" and "Ph.D. research projects available" Deliver No
21-Dec-2018 11-May-2017 External Milestone: Guidance policy for use and tagging of keywords to support PGR search Deliver No

RAG Status

GREEN

Report by Geoff Cropley for June 2018

Achievements this period

  • API use confirmation received
  • Dev & tes Environments built
  • Search results design built
  • Search widget built
  • Funnelback Data collection built

Issues

  • None

Next steps

  • Extract Pure data and integrate to search results pages
  • Targetting completion of Build, Integration, Acceptance and Deployment milestones

STU257 Privacy Impact Assessment Tool

Category: Compliance

Milestones

Target DateFor security reasons, images aren't duplicated during cloning. Please re-add or replace the image as required. Title
20-Jul-2018 Tender Response
21-Sep-2018 Contract Award
02-Nov-2018 Complete Application Familiarisation and Setup
16-Nov-2018 Complete User Guides
23-Nov-2018 User Acceptance
26-Nov-2018 Deployment to Live
14-Dec-2018 Deployment Sign-Off
14-Dec-2018 Closure

RAG Status

GREEN

  Report by Andy Stewart for June 2018

  Achievements in Last Period 

  • Procurement Activity
    • Procurement strategy approved and ITT published on 6th June and will be open until 20th June
    • 19 expressions of interest have been registered
    • The Bidders conference has been scheduled for Wednesday 11th July with input scheduled from the DPO and Accessibility Officer
  • Revised project plan agreed to accommodate OJEU procurement process and the resultant impact
  • Procurement evaluators briefing session arranged with Procurement for 2nd July

  Issues

  • No issues

Next Steps

  • EQIA - to be completed
  • Bidders conference
  • Commence review of ITT responses

 

STU258 - Careers - Student Alumni Community Networking Platform

Category - Discretionary

Milestones

11-Jun-2018 Push to Live [Vendor]
18-Jun-2018 Launch of website
29-Jun-2018 Delivery sign-off
27-Jul-2018 Project closure

RAG Status

Green

Report by Chris Orrell for June 2018

Achievements

  • Project team believed sufficient issues were addressed by the vendor that this service went live week commencing 25th June to various alumni cohorts including 2018 graduates 28th June.
  • A process flow illustrating the support available to end users from IS Helpline, Aluminati (the vendor) and Development and Alumni Services (DAS) was prepared and agreed. This allowed Project Services to engage with the IS Helpline and confirm their role and ability in supporting this service - note the IS Helpline are only expected to support with EASE login issues.  

Issues

  • A review of the platform by the IS Helpline highlighted a number of usability issues and a number of these are being addressed.
  • Delivery sign-off is yet to be planned, which is simply a case of arranging a meeting. Project closure for 27th July is not considered at risk.

Next steps

  • Define benefit realisation support that the Alumni team would like for this project.
  • Plan delivery sign-off.

 STU259 FREEDOM OF INFORMATION  GDPR UPDATES

 Category:  COMPLIANCE

 Rag Status 

BLUE (Closed)

  Report by Morna Findlay for June 2018

Achievements This Period

  • Closure report approved

  • project closed

STU260 CAM  Degree Finders - Options Appraisal - PhP End of Life migration path - proof of concept

End of planning to be proposed to 29th June.

RAG Status: Amber

Report by Chris Orrell for June 2018

Achievements this period

  • New infrastructure had been created by INF127, the UG & PG degree finders copied over, tested and go-live is anticipated on this new infrastructure July. This means that given the new infrastructure now has Centos 7 that PHP v5.4 will be on extended support until 2024 and Yii v1 until December 2019.

    • This means STU260 does not have to complete a pilot assessment which was originally anticipated (and budgeted for) and so this project (subject to agreement) becomes a much smaller options appraisal task.
  • An initial meeting was held with CAM to consider high level options for how the University may ensure support for the degree finder process beyond December 2019.

Issues

  • Production Management have confirmed that a change freeze would be applied to UG & PG Degree finders post December 2019 until this functionality is replaced by Service Excellence Programme (SEP). The earliest indicated delivery for this new functionality is October 2020 but this is not a committed date. The business have advised that a design freeze during this period would not be acceptable.
  • The business have also advised that there are 20+ support calls / requested changes and that it is expected that over the next couple of months or so SEP will generate new requirements for the degree finders.
  • To upgrade Yii v1 to Yii v2 would require a rewrite of both degree finder applications. UG & PG degree finders are significantly different and rewriting them would be two large projects. The business have advised that due to the number of required changes, including durable medium below, a like for like rewrite would be of no benefit. Additionally any re-write would be in a Python and not PHP with a Django framework and not Yii.
  • A robust long term solution to the Consumer Protection Law durable medium requirement is a high priority.

Next Steps

  • Complete Brief that will propose that STU260 is to produce an options appraisal.

RAG Commentary

It should be noted that although this project is rated amber (see comment below) the work has highlighted a significant risk that UG & PG degree finders will be out of support Dec 2019 and replacing this functionality will be a large piece of work either as a project or part of SEP. Time is rated amber and therefore so is the project as end of planning is delayed.

STU262 Electronic Sharing of Responses for GDPR

Category:  COMPLIANCE 

MILESTONES

21-May-2018            Acceptance Milestone Completion
22-Jun-2018 Delivery of Documentation Deliverables
25-Jun-2018 Delivery sign-off milestone
06-Jul-2018 Deployment Sign-off - stage complete
13-Jul-2018 Closure complete

Rag Status:

 RED

 

Report for June by Morna Findlay

Achievements This Period

  • new project budget and milestones approved

  • conflict for sharepoint development resource resolved

  • partial delivery achieved - business able to send electronic responses

  • support model drafted for discussion

Issues

Next Steps

  • Complete UAT testing (deletions), or approve scope change   and handover of this deliverable to support
  • Complete deployment sign-off milestone and hand over to support
  • Close

 

 

STU263 - REPLACE INFORMATION REQUEST PLANNING MONITOR TOOL - PROCUREMENT

Category:  COMPLIANCE 

Milestones

24-Aug-2018 Analysis Complete
21-Sep-2018 Options Appraisal Reviewed
28-Sep-2018 Options Appraisal Signed Off
05-Oct-2018 Options Appraisal Delivered
22-Oct-2018 Project Closed

Rag Status:

 Green

Report for June 2018 by Alison Kellas

Achievements

  • All analysis workshops have been completed
  • As-is process maps drafted and out for review and sign off

Issues

  • PM contract ends on 13th July and a replacement PM is to be identified

Next Steps

  • Sign-off of as-is process maps
  • Conduct gap analysis and gap analysis workshop
  • Conduct data mapping exercise

 

 

Section Four: Closed or Withdrawn Projects

Project Info Project Managers Commentary

STU256

CAM Degree Finders - Compliance with Legislation & Guidance

Closed 01/06/2018

Closure Report

Closure Milestone

STU259

FREEDOM OF INFORMATION GDPR UPDATES

 

 

Closed 12/6/18

Closure report

Closure milestone

 

AttachmentSize
Image icon stu-flook-june18.png54.39 KB
Image icon stu-res-june18.png33.06 KB