We have worked with a wide range of clients, both within the NHS and private sector. Some of our previous projects have included:
- work within an NHS commissioning organisation to audit their information department, workflows and systems, and the development and implementation of simplified and automated alternatives to some of the existing manual analytical processes. To meet some of the main training needs identified through this audit a course in advanced Microsoft Access reporting and SQL programming (for both Microsoft Access and Microsoft SQL Server) was developed and facilitated for the Information team.
- the development of a database for use within an NHS commissioning organisation's information department to record, monitor and manage their adhoc and regular information request workload.
- the development of a system for use within an NHS commissioning organisation to centralise and automate the production of National Tariff flex/freeze data and attribution challenges
- data migration project management, solution development and technical support - including to and from NHS Connecting For Health (CfH) / National Programme for IT (NPfIT) acute and community information systems, including data quality and cleansing processes (de-duplication, merging etc)
- the development of models to enable the analysis of the inpatient, outpatient and diagnostic capacity of an NHS provider to support the delivery of the 18-week referral-to-treatment (RTT) target, including the provision of training of staff in the concepts of supply and demand, clearance times etc and in the use of the models themselves
- work with an NHS provider to integrate non-PAS data into their commissioning management system to enable reporting, analysis and the development of enhanced CDS messages
- the analysis of A&E activity data for an NHS commissioning organisation to identify any trends and issues with potential impact on the delivery of the emergency care services within the health community and the achievement of the 4 Hour A&E target.
- the provision of bespoke specialist training in a non-web-based variant of Javascript
- the provision of bespoke training for NHS commissioning support staff in SQL Server Reporting Services (SSRS)
- the provision of a data warehouse / reporting layer and web-based reporting solution to a number of NHS community and mental health provider organisations and social enterprises
- the development of bespoke data capture systems - both standalone and integrated/interfaced with existing systems
- support for National Tariff / Payment By Results reporting processes in a number of NHS acute providers