Common use of Statement of Requirement Clause in Contracts

Statement of Requirement. list all of the Authority’s Requirements, specifications or agreed features of the Future Service to be performed. This is a Time and Materials FSC for two Individual Assignments. FSC2064 is building a new dev/test/live SQL environment for YPLA. This FSC is primarily to ensure IM Services has DBA support in place before, during and after its deployment in January 2012 and also to support other Data Service environments e.g. Data Warehouse and Data & MI stacks and existing sandbox servers. The requirement is for SQL Server expertise to assist with the management and consultancy of the YPLA and other SQL databases and other SQL related services, such as SSIS, SSRS and SSAS. The expertise needs to help us ensure the database servers are highly available, fault tolerant and of optimal configuration. It is expected that this will be delivered by two people working normal office hours (Monday to Friday 9 – 5.30pm) excluding English Bank Holidays. If one person is off, expectation is the other would cover so this would exclude them both taking holiday at the same time. The role(s) will be directed by Removed as reserved information Activities included are: Consultancy and advice Advising on deployments Advising on Data management Advising on configuration of SQL servers or databases Advising on performance tuning approach and methodology Advising on Database design and development Advising on Architecture and system design Advising on new software solutions Advising on Security implementations Advising on Disaster recovery strategy and planning Analysis and investigations not relating to incidents Design – where analysis is complete Design of basic schemas less than 5 tables (physical) Design of basic SSIS packages without complex transformations Design of basic reports Development – where design is complete Development of basic schemas less than 5 tables (physical) Development of basic procedures (C.R.U.D) Development of basic SSIS packages (without complex transformations) Development of basic SSRS reports Development of basic SSAS cubes Documentation – where configuration is known Documentation of databases Documentation of packages Documentation of servers House keeping Deletion of development or test databases Taking of an ad-hoc database backup Shrinking of development and test database files outside the standard maintenance plans Creation of indexes Management Ensure Sale service is delivered as defined by INF-HOS09 Section 2.3 Proactive ownership of SQL Server outages or issues eg. liaising with other Cap Gemini teams, such as the server or SAN management team Monitoring and formal ownership of Cap Gemini technical change requests that affect the environments in scope Items out of scope are those that would normally be undertaken by the operational DBA team and already included in the Capgemini contract. The above activity list will be undertaken in accordance with the appropriate IM Services governance processes. A list of deliverables and success criteria for this role are as follows: Ref 001 - Document detailing roles and responsibilities of the Cap DBAs and MI Staff Ref 002 - Provision of service as defined in Sect 1.1 above until 31 March 2012 Ref 003 - Option to continue service for 2012/13 financial year Success Criteria: YPLA (Removed as reserved information) approval for the document detailing their operational DBA role Feedback mechanism to determine whether delivery of the service described in Sect 1.1 is delivered or not

Statement of Requirement. list all of the Authority’s Requirements, specifications or agreed features of the Future Service to be performed. 1.1.1 The National Apprenticeship Service (NAS) are seeking to make the following changes to their Apprenticeship vacancies system to align with restructuring and policy changes being introduced. The critical success factor for this project is the delivery to the expectations of the business before the end of January 2012. This FSC will cover the Elaboration phase of the project. A key factor is the completion of the Deliverables identified in Section 1.2 – sign-off of these is the mechanism by which Stage 2: System change depends. 1.1.2 Changes to the system required for January are described below. Geography changes There have been changes to the geography structure which affect the ability to access, allocate and record data in the system as it stands today due to the introduction of divisions and the change to regions and area’s The Apprenticeship vacancies system is moving to be a centrally co-ordinated function, but with geographically based management. This will require the system to show Divisional and area geography for NAS users. Due to the physical geographical location of NAS Apprenticeship vacancies teams, there will be a need for teams, wherever they are based to be able to also view and manage the Apprenticeship vacancies system not only for their Division and Area, but to also support and undertake work within the system for other Divisions and Areas. Impact of Minimum Contract Value (MCL) To understand and accurately reflect the changes to how Providers will be contracted with and manage vacancies as a result of the introduction of Minimum Contract Value. This is where Providers will only hold contracts to deliver provision if they have a Time contract value over a certain amount. The system will need to show both the vacancies managed by the main contractor, but also the relationship hierarchy with vacancies managed by a sub-contractor. There will be instances where for some provision, a Provider is a main contractor but for other provision they need to be linked to another provider as they are a sub-contractor or part of a consortium arrangement. In addition Apprenticeship vacancies takes a feed of Provider information from PIMS and Materials FSC will therefore also need to align with the changes to PIMS following MCL changes Hierarchy Roles in LASS Create new SFA hierarchy roles in LASS for two Individual AssignmentsAv to use. FSC2064 is building a new dev/test/live SQL environment for YPLAe. g. Av:SFA Regional:User Approver, Av:SFA Division:User Approver, etc. This FSC is primarily to ensure IM Services has DBA support in place before, during and after its deployment in January 2012 and also to support other Data Service environments e.g. Data Warehouse and Data & MI stacks and existing sandbox serverswould match the agency’s current organisation hierarchy. The requirement is for SQL Server expertise agency would need to assist with the management detail whether it would be a straight mapping from lsc region to sfa region and/or division and consultancy whether sfa divisional users would require extra functionality within AVMS and therefore require additional changes to Av Replacement of the YPLA and other SQL databases and other SQL related services, such as SSIS, SSRS and SSAS. The expertise needs to help us ensure the database servers are highly available, fault tolerant and of optimal configuration. It is expected that this will current interim solution which should be delivered regressed once an agreed long term solution has been deployed See CCR11897 (investigation undertaken by two people working normal office hours (Monday to Friday 9 – 5.30pm) excluding English Bank Holidays. If one person is off, expectation is the other would cover so this would exclude them both taking holiday at the same time. The role(s) will be directed by *Removed as reserved information Activities included Reserved Information) 1.1.3 Core competencies of the supplier engaged to fulfil this role are: Consultancy Extensive experience of similar sized application upgrades Extensive Knowledge of Apprenticeship vacancies and advice Advising on deployments Advising on Data management Advising on configuration LASS Knowledge of SQL servers or databases Advising on performance tuning approach PIMS Ability to apply and methodology Advising on Database design share best practice Ability to suggest, explain and development Advising on Architecture demonstrate value added by changes in processes and system design Advising on new software solutions Advising on Security implementations Advising on Disaster recovery strategy and planning Analysis and investigations not relating Ability to incidents Design – where analysis is complete Design of basic schemas less than 5 tables (physical) Design of basic SSIS packages without complex transformations Design of basic reports Development – where design is complete Development of basic schemas less than 5 tables (physical) Development of basic procedures (C.R.U.D) Development of basic SSIS packages (without complex transformations) Development of basic SSRS reports Development of basic SSAS cubes Documentation – where configuration is known Documentation of databases Documentation of packages Documentation of servers House keeping Deletion of development produce documentation easily shared or test databases Taking of an ad-hoc database backup Shrinking of development and test database files outside the standard maintenance plans Creation of indexes Management Ensure Sale service is delivered as defined deployed with/by INF-HOS09 Section 2.3 Proactive ownership of SQL Server outages or issues eg. liaising with other Cap Gemini teams, such as the server or SAN management team Monitoring and formal ownership of Cap Gemini technical change requests that affect the environments in scope Items out of scope are those that would normally be undertaken by the operational DBA team and already included in the Capgemini contract. The above activity list will be undertaken in accordance with the appropriate IM Services governance processes. A list of deliverables and success criteria for this role are as follows: Ref 001 - Document detailing roles and responsibilities of the Cap DBAs and MI Staff Ref 002 - Provision of service as defined in Sect 1.1 above until 31 March 2012 Ref 003 - Option to continue service for 2012/13 financial year Success Criteria: YPLA (Removed as reserved information) approval for the document detailing their operational DBA role Feedback mechanism to determine whether delivery of the service described in Sect 1.1 is delivered or notSuppliers/parties 1.

Statement of Requirement. list all of the Authority’s Requirements, specifications or agreed features of the Future Service to be performed. This To initiate the Centralised Contract Management (CCM) 2013/14 Release project. The Authority and the Education Funding Agency have a number of requirements for the provision of contracts for the academic year 2013/14. The key requirements identified in the supporting business case are: reflect policy changes made by BIS and the Skills Funding Agency including the following; reflect requirements to introduce provision for 24+ loans. 24+ Advanced Learning Loans (ALL) is a Time driven out of the government papers: “Skills for Sustainable Growth” and Materials FSC “Investing in Skills for two Individual AssignmentsSustainable Growth” (November 2010). FSC2064 support delivery of funding simplification for the Skills Funding Agency. Simplification is building a new dev/test/live SQL environment for YPLAcritical to enabling an autonomous and responsive system and it recognises that colleges and training organisations are in the best place to identify, interpret and then respond to learners’ needs within their available resources. This FSC is primarily reflect policy changes made by DfE and the Education Funding Agency including but not limited to ensure IM Services has DBA support in place before, during and after its deployment in January 2012 and also the changes required to support other Data Service environments e.g. Data Warehouse academies and Data & MI stacks direct school grants. For the Authority the project will consider the following: Funding Stream Configuration - 2013/14 rollover (includes funding simplification) 24+ loans (incl. Loans Bursary) CCM Contract Process Improvement Support of NFF Programmes/Deliverable selection/catalogue Changes indentified for future releases in 13/14 that may require consideration/set-up in Release 1. ( For example, Funding Claims, performance management, ILR changes, ESF ) For the Education Funding Agency the project will consider the following: 2013/14 Roll Forward Process streamlining / automation General During the initiation we will assess the anticipated current and future contract volumes for both agencies and provide a recommendations paper for consideration, outlining the findings. Consider the options for upgrades to the core projects to deliver general improvements to the project retain the product within the existing sandbox serverssupport agreement an upgrade plan for achieving this avoiding disruption to dates along the critical business cycle. The requirement is for SQL Server expertise to assist with Access the management and consultancy ‘quick-wins’ that can be delivered as part of the YPLA and other SQL databases and other SQL related services, such as SSIS, SSRS and SSAS. The expertise needs to help us ensure the database servers are highly available, fault tolerant and of optimal configuration. service enablement work It is expected that this as an output of the initiation and elaboration phase a document will be delivered by two people working normal office hours produced detailing a proposal for delivery. Only 1 (Monday to Friday 9 – 5.30pmdraft) excluding English Bank Holidays. If one person is off, expectation is the other would cover so this would exclude them both taking holiday at the same time. The role(s) will be directed by Removed as reserved information Activities included are: Consultancy and advice Advising on deployments Advising on Data management Advising on configuration of SQL servers or databases Advising on performance tuning approach and methodology Advising on Database design and development Advising on Architecture and system design Advising on new software solutions Advising on Security implementations Advising on Disaster recovery strategy and planning Analysis and investigations not relating to incidents Design – where analysis is complete Design of basic schemas less than 5 tables (physical) Design of basic SSIS packages without complex transformations Design of basic reports Development – where design is complete Development of basic schemas less than 5 tables (physical) Development of basic procedures (C.R.U.D) Development of basic SSIS packages (without complex transformations) Development of basic SSRS reports Development of basic SSAS cubes Documentation – where configuration is known Documentation of databases Documentation of packages Documentation of servers House keeping Deletion of development or test databases Taking of an ad-hoc database backup Shrinking of development and test database files outside the standard maintenance plans Creation of indexes Management Ensure Sale service is delivered as defined by INF-HOS09 Section 2.3 Proactive ownership of SQL Server outages or issues eg. liaising with other Cap Gemini teams, such as the server or SAN management team Monitoring and formal ownership of Cap Gemini technical change requests that affect the environments in scope Items out of scope are those that would normally be undertaken by the operational DBA team and already included in the Capgemini contract. The above activity list will be undertaken in accordance with the appropriate IM Services governance processes. A list of deliverables and success criteria for this role are as follows: Ref 001 - Document detailing roles and responsibilities version of the Cap DBAs and MI Staff Ref 002 - Provision of service as defined in Sect 1.1 above until 31 March 2012 Ref 003 - Option to continue service for 2012/13 financial year Success Criteria: YPLA (Removed as reserved information) approval for the document detailing their operational DBA role Feedback mechanism to determine whether delivery of the service described in Sect 1.1 proposal is delivered or notrequired from this Initiation phase.

Statement of Requirement. list all of the Authority’s Requirements, specifications or agreed features of the Future Service to be performed. This is a Time and Materials FSC for two one Individual Assignments. FSC2064 is building a new dev/test/live SQL environment for YPLAAssignment. This FSC is primarily Individual assignment will be a DBAD3 SQL Database Administrator to ensure IM Services has DBA support in place before, during and after its deployment in January 2012 and also to support other Data Service environments e.g. Data Warehouse and Data & MI stacks and existing sandbox servers. work under the instruction of the Authority The requirement is for an established SQL Server expertise expert to assist with the management and consultancy of the YPLA and other Data Service SQL databases and other SQL related services, such as SSIS, SSRS and SSAS. The expertise needs to help us ensure the database servers are highly available, fault tolerant and of optimal configuration. It is expected that this will be delivered by two people working normal office hours (Monday to Friday 9 – 5.30pm) excluding English Bank Holidays. If one person is off, expectation is the other would cover so this would exclude them both taking holiday at the same time. The role(s) role will be directed by Removed as reserved information in the Data Service. It is envisioned that this, and an associated IA, will be replaced by a managed service provided by Cap Gemini. A Contract Change Request has been raised with Cap Gemini, discussed in the March Change Request Board meeting. Discussions are currently underway between the Data Service and Cap Gemini to agree the structure, nature and pricing of such a service. It is expected that this IA will be moved to a service within the next one to two months. Given the essential nature this role currently occupies, a temporary arrange for IA funding is required to ensure continuity of service. Activities included are: Consultancy and advice Advising on deployments Advising on Data management Advising on configuration of SQL servers or databases Advising on performance tuning approach and methodology Advising on Database design and development Advising on Architecture and system design Advising on new software solutions Advising on Security implementations Advising on Disaster recovery strategy and planning Analysis and investigations not relating to incidents Design – where analysis is complete Design of basic schemas less than 5 tables (physical) Design of basic SSIS packages without complex transformations Design of basic reports Development – where design is complete Development of basic schemas less than 5 tables (physical) Development of basic procedures (C.R.U.D) Development of basic SSIS packages (without complex transformations) Development of basic SSRS reports Development of basic SSAS cubes Documentation – where configuration is known Documentation of databases Documentation of packages Documentation of servers House keeping Deletion of development or test databases Taking of an ad-hoc database backup Shrinking of development and test database files outside the standard maintenance plans Creation of indexes Management Ensure Sale service is delivered as defined by INF-HOS09 Section 2.3 Proactive ownership of SQL Server outages or issues eg. e.g. liaising with other Cap Gemini teams, such as the server or SAN management team Monitoring and formal ownership of Cap Gemini technical change requests that affect the environments in scope Items out of scope are those that would normally be undertaken by the operational DBA team and already included in the Capgemini contract. The above activity list will be undertaken in accordance with the appropriate IM Services governance processes. A list of deliverables and success criteria for this role are as follows: Ref 001 - Document detailing roles and responsibilities of the Cap DBAs DBA and MI Staff Ref 002 - Provision of service as defined in Sect 1.1 above until 31 March May 2012 Ref 003 - Option to continue service for 2012/13 financial year Success Criteria: YPLA (Removed as reserved information) approval Ongoing DBA support for the document detailing their operational DBA role Feedback mechanism to determine whether delivery of the service described in Sect 1.1 is delivered or notData Service.