Report for August 2013 _ DRAFT

Report Date
August 2013

Report compiled by Rhian Davies (IS Apps Programme Manager) for Liz Welch  (Programme Owner)

Section One: Programme Commentary, and Resources Update

Section Two: Projects Not Started

Section Three: Projects In Progress

Section Four: Closed or Withdrawn Projects 

Section Five: New Approved Projects from 13/14 Annual Plan

 

 

Section One: Programme Commentary, and Resources Update  

 

 

 

 

Section Two: Projects Not Started

 

 

Project InfoProgramme Managers Commentary

 AP34

Student Fees - Interest Charging on Invoices

Compliance

Planning - January 2014

Delivery - tbc

 RAG Status - GREEN

 Plan

 

Dependencies

 Need to get decision from Fee Strategy Group which meets quarterly - FIS following up on status.

No change to timeline from previous report.

AP34

Student Fees - SAAS and SLC Fees Reconciliation

Compliance

Planning - October 2013

Delivery - May 2014

 RAG Status - GREEN

Plan

 

Dependencies

There will be input required from Registry, however this is not required at the beginning of the project.

AP34

Migration of BOXI reports

Compliance

Planning - October 2013

Delivery - March 2014

 RAG Status - GREEN

Plan

 

Dependencies

The purpose of this project is to address any issues following the BOXI Upgrade.

AP34

Essential Enhancements for Finance Applications

Compliance

Planning - September 2013

Delivery - July 2014

 RAG Status - GREEN

Plan

Intially planning required to determine scope for this project - it will include the work required for International Bank Account Validation.

 

Dependencies

AP34

eExpenses Replacement

Compliance

Planning - tbc

Delivery - tbc

 RAG Status

Plan

 This is the procurement and implementation of a new eExpenses Solution

Dependencies

The direction of this project depends on the outcome of the proof of concept project.

AP89-008

FPM for eInvoicing

 

Discretionary

Planning - January 2014

Delivery - July 2014

RAG Status - GREEN

 

Plan

The project is due to start in January 2014.

 

Dependencies

 

Section Three: Projects in Progress

 

 

Project InfoProject Managers Commentary

FIN056 (AP Number)

eProcurement Scotland - eInvoicing

 

Category: Funded

Milestones

---

---

--- 

RAG Status

SUSPENDED

 

Report by Rhian Davies for June 2013.

Project suspended until 13/14 - resources not available within FIS until the early Autumn.

 

 

FIN076  (AP12-029)

Student Finance Channel - Further Developments for Staff and Students

 

Category: Discretionary

Milestones

  *To be replanned once callback issue estimated*

12-Aug-2013Deployment review
23-Aug-2013Closure

RAG Status

RED

Report by Susan McKeown for August 2013

 

Achievements in Last Period
  • The vast majority of payments have gone through the new channel successfully
Issues
  • Progressing the issues with the callback post go live has been slow. To enable testing, the project required WPM to activate the financechanneltest pathway (they do not provide test pathways until pathways have gone LIVE). WPM have confirmed that it should now be available for use. The PM is keeping the project RED until it's proven the test pathway can be successfully used.
Next Steps
  • Using the TEST system, diagnose the callback failure issue and agree whether this is small enough to be resolved as a support issue
  • Reschedule milestones and re-estimate project effort
  • Sign-off the Deployment
  • Close the project

 

 

 

 

 

 

FIN078 (AP Number)

eFin Journal Auto-Upload

 

Category: Discretionary

Milestones

 

Target dateTitle
06-Sep-2013Go-live
13-Sep-2013Deployment sign-off
27-Sep-2013Closure
 

RAG Status

GREEN

Report by Dawn Nicholls for August 2013

 Achievements this period

  • System enhancements completed to convert bad files to csv format and to email to the owner for manual posting
  • System overview/training given to FIS team members

Issues

  • Delayed go-live resulting from late changes which then caused issues with securing additional development resource.
  • Invalid files still being received from WPM, both on this project and the ERA replacement project. This will not prevent the new system from going live but will prevent FIS from activating some of the pathways until the errors are resolved with WPM.

Next steps

  • installation of new software onto Live w/c 2nd Sept
  • go-live for delegate registration files w/c 9th Sept
  • subsequent activation of other pathways (e.g. OLLIE, print credit etc)
  • project closure

  

Full details can be seen in the Project Journal

FIN079 (AP Number)

LEAN- Review of Financial Systems

 

Category: Discretionary

Milestones

 

Revised DateTitle
06-Sep-2013Delivery - workpackage 2 (eIT enhancements)
06-Sep-2013Delivery - workpackage 14 (eIT transfer queue)
20-Sep-2013Closure
 

RAG Status

GREEN

Report by Dawn Nicholls for August 2013

Achievements this period

  • eIT enhancements (work packages 2 and 14) are now complete and have been tested by FIS ready for go-live 

Issues

  •  Minor delay to eIT enhancements go-live due to issues securing resource and FIS availability to undertake UAT

Next steps

  • Go-live of eIT enhancements 6th Sept
  • Project closure

 

Full details can be seen in the Project Journal

FIN080 (AP Number)

Customer Interface Improvements

 

Category: Discretionary

Milestones

 

Target dateTitle
30-Aug-2013Phase 2 - Acceptance
13-Sep-2013Phase 2 - Go-live
20-Sep-2013Phase 2 - Deployment
27-Sep-2013Closure
  

RAG Status

AMBER

Report by Dawn Nicholls for August 2013

Achievements this period

  • a number of the issues raised by SACS during their acceptance test have been resolved and passed back for testing
  • the BOXI universe has been passed to FIS for testing

Issues

  • delayed acceptance sign-off from SACS which in turn is delaying the sign-off from FIS
  • further issues are regularly being identified by SACS team which then require further development and technical resource to correct
  • the project has now reached its approved budget limit so the project has been placed on Amber status as it is highly likely that it will exceed both its time and cost parameters

Next steps

  • acceptance sign-off 
  

Full details on project activities can be seen in the Project Journal

FIN081 (AP Number)

Document Management for Finance Applications

 

Category: Discretionary

Milestones

---

---

--- 

RAG Status

SUSPENDED

Report by Rhian Davies for June 2013

Project suspended until 13/14.

FIN083  (AP23-003)

eFinancials Upgrade

 

Category: Compliance

Milestones

 

 

  
17-Jul-13Closure

 

RAG Status

BLUE

 

Achievements in this period

 

  1. DEV database migration largely completed

  2. Project closed

  3. Outstanding deliverables transferred to new project code (FIN091)

 

The project RAG status has been set to BLUE as  the project was closed on 2/8/13

 

FIN085  (AP01-008)

eTime Phase 3

 

Category:  Compliance

 

Milestones

 

22-Nov-2013UAT (for final release) signed off
11-Dec-2013Deployment signed off
18-Dec-2013Closure

 

 

RAG Status:  RED

Report by Jill Nicoll for August 2013

 
Achievements in last period:

Release 3 signed off in UAT and deployed to Live.

Release 4 (HSS) signed off in Peer testing, deployed to Test, signed off in UAT and deployed to Live.

Actual cost for this HSS funded work is 12 days of ISA effort.

First 3 of 4 Release 5 requirements built. 

Issues:

The Batch Processing requirements remain unconfirmed.  No progress has been made on this over the past two months. 

The Development Team has indicated that there is a strong likelihood that the Designer & Lead Developer will be reassigned away from the project.  This has been raised as Project Risk 5, and has resulted in the project's RAG status being changed to RED.

Next Steps:

Stakeholders:

UAT test and sign off Release 5

Automatic transfer to Payroll (Release 6) : confirm business requirements 

Batch Processing functionality (Release 7) : confirm business requirements OR sign off on the Designer's proposed solution

ISA:

Design Release 5's requirement 4

Build Release 5's requirement 4

Peer test Release 5

Deploy Release 5 to Test and release for UAT testing 

FIN086 (AP23-004)

ePay Reconciliation

 

Category:  Compliance

 

Milestones

26-Apr-13  Planning

 

 

 

RAG Status:  GREEN

 

Report by Rhian Davies for June 2013

Project suspended until 13/14 to enable eAuthorisations to start in 12/13.

 

FIN087

Credit Note/Sales Invoice Interface Changes

Category:  Funded

 

Milestones

 

Target dateTitle
20-Aug-2013PPDR - Design Review
04-Oct-2013PPBR - Build Review
31-Oct-2013PPIR - Integration Review
07-Nov-2013ASOR: Acceptance Review
11-Nov-2013Deploy to Live
20-Nov-2013DSOR - Deployment Review
28-Nov-2013Project Closure
 

  

RAG Status:  AMBER

Report by Dawn Nicholls for August 2013

 

Achievements this period

  • Design work has started 

Issues

  • Design work is not as far along as planned due the developer being required to assist with issues on other finance projects (e.g. FIN078 and FIN088)
  • Delays to the Design stage mean that the development resource will not be available for the Build stage as they are booked for another finance project. This has been escalated to team leaders and the project placed on Amber status.

Next steps

  • Complete Design stage
  • Secure development resource for Build stage and replan project

 

FIN088 (AP12-017)

ERA Decommissioning

 

Category:  Compliance

 

 

Milestones

 

06-Sep-2013Integrate Finance Channel Complete
13-Sep-2013Acceptance Finance Channel Complete
23-Sep-2013Deliver PCounter
04-Nov-2013Deliver Finance Channel
14-Nov-2013DOS Review
28-Nov-2013Project Closed
 

 RAG Status:  AMBER

Report Date: August 2013
Louise Heathcote
 

 

Achievements in this Reporting Period

  • Print Credit Build Complete and Acceptance sign off due 05/09/13
  • Finance Channel being Build Peer Reveiwed and ready for Integration Testing next week, deployment date now due 4th November due to heavy usage at the start of term

Issues

  • Print Credit missed the deployment date due to an issue with the account set up at Worldpay, deployment now scheduled for 23rd September
  • JAMs process not live manually posted OLL files for August

Next Steps

  • Deploy Print Credit
  • Roll out JAMs process to business units once it has gone live

 

FIN089

eAuthorisations Migration

 

Category:  Compliance

 

Milestones

 

11-Sep-2013Phase 1 UAT sign-off
19-Sep-2013Phase 1 Delivery
02-Oct-2013Phase 1 Deployment approved
18-Oct-2013Phase 2 Build approved
18-Oct-2013Phase 3 Business Analysis approved
25-Nov-2013Phase 2 Integration approved
10-Jan-2014Phase 2 UAT approved
17-Jan-2014Phase 4 Analysis signed off
20-Jan-2014Phase 2 Delivery
03-Feb-2014Phase 2 Deployment approved
07-Feb-2014Closure

 

RAG Status:  Green

Report by Jill Nicoll for August 2013
 

Achievements in last period:

Phase 1:

Some items of Phase 1 UAT testing signed off.

Phase 1 UAT and Deployment stages re-planned, per advice from Business Area Manager.

Request raised to, and approved by, the Change Advisory Board (CAB) for Phase 1 Live deployment on 19th September (during start-of-term Change Freeze).

Live environment set up.

BOXI:

BOXI universe built and signed off in Peer Testing

Phase 2:

Phase 2 Business Analysis signed off.

Phase 2 System Design signed off.

Issues:

The BOXI universe was developed in BOXI R2, because the BOXI R4 environment was not yet stable in the Dev environment.  Attempts to migrate to Dev R4 have revealed some known issues with R4's support of SQL Server universes.  These will be further investigated, and a way forward agreed, in the next period.  In the meantime, the universe will be pulished to Test R2, to allow UAT testing to progress.  When the issues have been resolved, this project will migrate the eAuthorisations universe to R4 in the Dev and Test environments.

The Project Sponsor's request to re-plan Phase 2 to deliver in batches could not be fully met, due to Dev Tech resource constraints during September and early October.  As a result, the plan has been adjusted to deliver in two batches only at this time.  Further batch break-down will be provided, if this becomes possible.  A list of requirements has been sent to the Project Sponsor for prioritisation, to support the batch planning. 

The re-estimation at the close of the Phase 2 Design stage confirmed a revised project estimate of 259 days, an increase of 12 days over the approved 247 days.  The Project Sponsor and Programme Manager have confirmed that this increase will be supplied from elsewhere in the FInance Programme budget (details to be confirmed).

Next Steps:

Phase 1:

Phase 1 UAT testing to be completed and signed off by FIS testing team.

Phase 1 Live deployment (contingent upon timely UAT completion and sign-off).

BOXI:

BOXI Universe to be deployed to Test and released for UAT testing.

BOXI Universe to be UAT tested by FIS team.

BOXI Universe Live deployment (contingent upon UAT completion and sign-off).

Phase 2:

Project Sponsor to provide prioritised list of requirements, to support batch planning. 

Phase 2 batch 1 Build will continue throughout the next period.

FIN091

Edinancials Upgrade Phase 2

Category: Compliance

 

 

30-Aug-2013Sign off eFIN DEV database migrationBuild
09-Sep-2013Design ReviewDesign
12-Sep-2013Project Brief ApprovedPlan
09-Oct-2013Sign off EFIN TEST database migrationAccept
09-Oct-2013Sign off DR testing and SSSAccept
21-Oct-2013Prototype SSO/Launchpad deliveredBuild
25-Oct-2013Migrate EFIN LIVE databaseDeliver
30-Oct-2013Sign off Launchpad prototypeAccept
04-Nov-2013DB migration DSORDeliver
11-Nov-2013Close

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

RAG STATUS: AMBER

 

Report by Morna Findlay for August 2013

Achievements this period

Initial kick-off project meeting held

Project team established

Initial draft  project brief, estimate and plan published

Approval for IS applications to continue work on database migration befor brief approved agreed by WIS.

Supplier Self-Service application signed off on DEV by Finance

Database migrated to test.

Testing of database DEV migration continues.

DR/resilience recommendations provided to Finance

 

Outstanding Issues

Estimate, Brief and plan not approved.

Trigger/dataguard resolution not yet approved by ABS

FIS test plan not received.

Unclear how Supplier Self Service can be tested in TEST by a supplier.

 

Next Steps

Approve  project brief, estimate and plan 

DR/resilience requirements to be finalised by Business.

 

The project is AMBERas the  brief has not yet been approved,

 

 

FIN092

Corporate Planner

 

Category:  Compliance

 

Milestones 

 

6-Sep-2013

Build Sign off Review

 

 

RAG Status:  GREEN

Report for August 2013 by Anne Mathison

  Achievements this period

  • Project set up
  • Inital project meeting to gather requirements
  • Planned, estimated, resourced and scheduled Project
  • Requested new VM Server

 

Outstanding Issues
  • None

 

Next steps
  • Brief to be approved at WIS
  • Liase with Account Ability
  • Confirm and agree technical requirements
  • Set up environment in Live in preperation for Consultant on 23rd September
  • Support Live until Return submitted

 

Section Four: Closed or Withdrawn Projects

 

Project InfoProject Managers Commentary

FIN082

HMRC Real Time Information

Compliance 

Report by Jill Nicol

This project was closed on 10-Aug-2010

Please see the Completion Report for further information.  

AP23-055

Rolling out Finance BOXI Reports

 

Funded 

Report by Rhian Davies

This project was withdrawn from the 12/13 programme.

FIN072 (AP01-008)

eTime

 

Category: Compliance

Report by Jill Nicol

This project was closed on 30-Nov-12.

Please see the Completion Report for further information.

FIN077

Control Account Balancing

 

Category: /Compliance

Report by Sue Woodger 

This project was closed 1 February 2013

Please see the Completion Report

FIN084

eStores Rollout

Category : Discretionary

 

Report by Dawn Nicholls

This project was closed on 20th December 2012

Please see the Completion Report for further information

 

FIN083

Efinancials upgrade

Vategory:Compliance

Report by Rhian Davies

This project was closed on 17/7/13

Please see the completion report for further details.

 

Section Five: New Approved Projects from 13/14 Annual Plan

Any projects that were approved in previous annual planning rounds and have been postponed to start in 13/14 will be listed under section 2: Projects Not Started. Projects started in 12/13 but which will carry over to 13/14 are listed under section 3: In Progress.

 

 

 

 

 

Project InfoProject Managers Commentary

 AP34

Student Fees - Interest Charging on Invoices

Compliance

Planning -

Delivery -

 RAG Status

 Plan

 

Dependencies

 

AP34

Student Fees - SAAS and SLC Fees Reconciliation

Compliance

Planning -

Delivery -

 RAG Status

Plan

 

Dependencies

AP34

Migration of BOXI reports

Compliance

Planning -

Delivery -

 RAG Status

Plan

 

Dependencies

AP34

Essential Enhancements for Finance Applications

Compliance

Planning -

Delivery -

 RAG Status

Plan

 

Dependencies

AP34

eExpenses replacement

Compliance

Planning -

Delivery -

 RAG Status

Plan

 

Dependencies