Provision of a Future Management Information System

Tender description

The CPS is seeking to develop a CPS Future Management Information (FMI) System as a scalable, enterprise platform that will provide CPS business directorates (including HR, Finance and Casework) with the tools and support to collect useful and trustworthy data to be analysed with high-functioning data analytics capability. The solution (together with ongoing maintenance, support and upgrades) will be delivered by the service provider, we expect to future-proof the solution through additional enhancements over the duration of the contract, the interpretation and application of the database will be performed by internal CPS analysts Lot 1: The CPS is seeking to develop a CPS Future Management Information (FMI) System as a scalable, enterprise platform that will provide CPS business directorates (including HR, Finance and Casework) with the tools and support to collect useful and trustworthy data to be analysed with high-functioning data analytics capability. The solution (together with ongoing maintenance, support and upgrades) will be delivered by the service provider, we expect to future-proof the solution through additional enhancements over the duration of the contract, the interpretation and application of the database will be performed by internal CPS analysts The current Casework Management Information System (MIS) has been in place for almost 20 years. As of 08/06/22, the number of cases on the system was 14,832,370. A significant number of the fields in the database are automatically calculated within the data warehouse. We would anticipate that any new solution would be capable of replicating this database with the associated calculations (transition) within the new platform. In addition to the casework data, there are many other key data sources including finance, HR, complaints, proceeds of crime and victims right of review (VRR). This not a complete list but these (and additional databases) will be required to be incorporated into the data factory and many with will have similar calculations or transitions to MIS. Further work is required to create single data standards and align the various data sources across the organisation. This includes HR, finance as well as casework data. The system will need, as a minimum, to provide for near-live reporting with data sets updated at the end of each day. The system will need to be scalable so that when new datasets (from same or different areas within the business) become available, they can be incorporated seamlessly into the system (reasonably quickly and inexpensively) The system will automate how our people produce management information so they can spend less time on what figures are and add more value through interpretation and application. The current CPS tactical solution is underpinned based on Microsoft technologies (Azure Data Factory and Power BI), however the Organisation will consider alternative options for a proven solution that will deliver the required business outcomes. Suppliers are asked to provide information on how they would approach the challenge outlined above. The transfer of the data will need to take place automatically with the minimum of staff involvement. Accuracy is of the upmost importance and all new reporting that would be provided through the data factory will need to accurately correlate against all reporting outputs that are provided within the current legacy systems. It is fundamental important to note that we are not starting this work from scratch. A discovery phase has been completed together with high and low level design and a proof of concept stage. The CPS is considering the workstreams as follows: 1. FMI platform – design, implementation, build and support; 2. Data Analysis – defining and improving data quality and standards for the FMI system; 3. Centre of Excellence (CoE) - supporting the rollout to the CPS Business Teams via the support and guidance of a FMI CoE 4. Legacy systems – establishing a roadmap and transition for CPS Management Reporting in order to decommission the legacy MIS system whilst safeguarding the MIS data.