Organisation

Work/Task Breakdown

Project Planning

Task Who Priority When 
O1. Formulate Project Team       
D1.1 Confirm members of the project Team Project Sponsor / Head of Production / Kx Director Must  
D1.2 Confirm roles and responsibilities  Project Sponsor / Head of Production / Kx Director Must  
O2. Performance Acceptance and  Monitoring       
D2.1 Document the key business functionality / reports and associated acceptance times that will form the criteria for assessing the system performance  Project Team  Must  
D2.2 Create test scripts relating to key business functionality / reports Project Team  Must  
D2.3 Define tool sets to monitor infrastructure performance  Project Team  Must  
D2.4 Define tool sets to deliver application utilisation monitoring  Project Team  Must  
D2.5 Define schedule of tests to be undertaken  Project Team  Must  
D2.6 Define method of running performance tests  Project Team  Must  
D2.7 Define responsibility for managing / running / recording performance tests  Project Team   Must  
O3. Application Performance Review       
D3.1 Prepare holding environment  Development Technology  Must  
D3.2 Create and restore copy of live database to holding environment  Development Technology  Must  
D3.3 Create script to anonymise the database  Kx Technical Lead  Must  
D3.4 Anonymise the database Development Technology  Must  
D3.5 Provide copy of database to Kx Development Technology  Must  
D3.6 Prepare report of system performance analysis Kx Technical Lead Must  
O4. Build new Kx database Test environment (incorporating)      
D4.1  Prepare updated Technical documentation to reflect the new test environment Technical Lead Must  
D4.2 A new test test database environment that mirrors the current live production environment and delivers an acceptable performance that is consistent across both data centres
  • Across both data centres
  • Infrastructure with regards servers, processors and memory 
  • Operating system - Windows Server 2008 R2 Enterprise SP1
  • SQL Server 2014 SP2-GDR Enterprise Edition
  • Application databases 
  • Always on Availability groups (AOAG) for system resilience
  • System interfaces
  • Scheduled system housekeeping activity such as backups, re-indexing etc.
Infrastructure Lead / Technical Lead  Must  
D4.3 Configure database and connections  Kx Technical Lead  Must  
D4.4 Complete initial performance schedule and tests  Project Team  Must  
D4.5 Document current scheduled activities with regards schedule, start time, duration, known issues, known impact  Applications Management Must  
D4.6  Log of performance tests Project Team  Must  
O5. Refresh Kx Application Test environment       
D5.1 Build a new test Web server to replicate the live environment  Development Technology  Should  
D5.2 Configure new test Web server to replicate the live environment  Kx Technical Lead  Shoukd  
O6. Database Infrastructure Performance Review      
D6.1 Complete performance monitoring at primary site, using defined performance and monitoring tools  Project Team  Must   
D6.2 Complete performance monitoring at secondary site, using defined performance and monitoring tools Project Team   Must   
D6.3   Define impact on system performance  using defined performance and monitoring tools  Project Team  Must   
D6.3 Implement any required tuning to stabilise performance at both sites  Technical Lead / Kx Technical Lead  Must   
D6.4 Produce technical recommendation associated with system performance testing  Project Team   Must   
D6.5 Produce implementation plan for system performance monitoring on live production environment  Project Team   Must   
D6.6 Review system maintenance activities  and the impact on performance / reliability  Support Lead / ACE Technical Lead Must  
D6.7  Produce technical recommendation associated with system maintenance activities  Support Lead / ACE Technical Lead Must  
D6.8  Produce implementation for system maintenance activities on live production environment  Support Lead / ACE Technical Lead Must  
O7. Produce Operations Level Agreement       
D7.1 Prepare an agreed Operations Level Agreement between IS Applications and Accommodation Catering and Events Project Team  Should  

 

Resources, Skills and Costs

This project will require a variety of resources with the initial estimated activity as follows

Business Area Department  Role Estimated Effort (in days)
Accommodation Catering and Events Technical Team ACE - Technical Lead  and support  
Accommodation Catering and Events Business user(s) Business Lead   
Kx Technical Team  Kx Technical Lead   
IS Applications  Project Services  Project Manager   
IS Applications  Development Technology Technical Lead   
IS Applications Applications Management  Applications Management Lead   
IS Applications Technology Management Technology Management Lead   
ITI IT Technology IT Technology Lead   

In addition, there may the requirement to engage a third party consultant to develop the required client server performance test scripts  

Project Governance

The project will be overseen as follows;

  • The project team as detailed within the project stakeholders 
  • The project board as detailed within the project stakeholders 

Any points of conflict with the project team will be escalated to the project board by the project manager 

 

Project Stakeholders

Details relating to the stakeholders roles and responsibilities can be viewed within the Stakeholder List 

Name Business area Role
Alister Webb IS Applications Development Technology Technical Lead (Project Team)
Andrew Glass Accommodation Catering and Events ACE Technical Lead (Project Team)
Andy Stewart IS Applications Project Services Project Manager (Project Team / Project Management Team)
Chris Barnes Accommodation Catering and Events Project Sponsor (Project Management Team)
Claire Barnish Accommodation Catering and Events Project Sponsor (Project Management Team)
James Love Kinetics Systems Kx Project Manager  (Project Team / Project Management Team)
David Morse IT Infrastructure Windows Server Infrastructure Lead (Project Team)
Iain Fiddes IS Applications Development Head of Development Services (Project Management Team)
John Chan IS Applications Applications Management Applications Management Lead (Project Team)
Mark McGowan IS Applications Technical Management Technical Management Lead (Project Team)
Scott Moncrieff Accommodation Catering and Events Business Area Leads Coordinator  (Project Team)
Stefan Kaempf IS Applications Production Management Head of Production Management (Project Management Team)
Warren Colclough Kinetics Solutions Kx Technical Lead (Project Team)

 

Project Estimations

The project has been estimated at 60 days.  Project estimate 

 

Project Info

Project
Kx Infrastructure Consolidation
Code
ACS039
Programme
Accommodation Catering and Events (ACE)
Management Office
ISG PMO
Project Manager
Andrew Stewart
Project Sponsor
Claire Barnish
Current Stage
Close
Status
Closed
Start Date
22-Aug-2017
Planning Date
n/a
Delivery Date
n/a
Close Date
06-Jul-2018
Overall Priority
Normal