My first work at Capgemini has involved resourcing and providing information for the data migration workstream of a major bid process, discovery for a project with DEFRA and a role with HMRC looking at mappings within their Customs and Borders software.Subsequently I have worked at Defra to analyse coding and migrate 9 legacy databases to Azure Cloud.

I am working in a part-time remote role to create and maintain a Data-set extraction process for the Mental Health Services Data-set (MHSDS) for Oldercare, focusing on Carenotes and Ulysses data held regarding St Magnus Hospital, St Marthas Hospital and Rosemary Park Nursing Home.I have also worked with the organisation to redesign Carenotes to better support collection of data and process improvement, implemented functionality such as Assist and Email engine to assist clinicians and… Show more I am working in a part-time remote role to create and maintain a Data-set extraction process for the Mental Health Services Data-set (MHSDS) for Oldercare, focusing on Carenotes and Ulysses data held regarding St Magnus Hospital, St Marthas Hospital and Rosemary Park Nursing Home.I have also worked with the organisation to redesign Carenotes to better support collection of data and process improvement, implemented functionality such as Assist and Email engine to assist clinicians and also to advised on the expansion to cover Rosemary Park Care Home.Work has included bespoke forms development using XML, DSDL (Carenotes SQL based scripting language) and Javascript and bespoke summary development using XSL Javascript and XSL. I have also performed Carenotes system upgrades for the company, and facilitated implementation of the e-mail reminder service. Show less

I was contracted to design and deliver Data Migration from OpenInsight Revelation (CrossCare) to Servelec RiO. This required the purchase and tailoring of a data extraction tool and developing complex scripts to remap data as OpenInsight is a PICK style multivalue database and the CrossCare product itself was not compatible with OpenInsight's own extraction tools.Data was then mapped, transformed and extracted using variable driven SSIS packages to provide input data for Servelec's data… Show more I was contracted to design and deliver Data Migration from OpenInsight Revelation (CrossCare) to Servelec RiO. This required the purchase and tailoring of a data extraction tool and developing complex scripts to remap data as OpenInsight is a PICK style multivalue database and the CrossCare product itself was not compatible with OpenInsight's own extraction tools.Data was then mapped, transformed and extracted using variable driven SSIS packages to provide input data for Servelec's data migration tool. I also used SSIS to re-organise the CrossCare Document Repository and prepare extracts for upload to RiO I joined the project with only 6 months until target go-live and have helped the CIC design and plan their configuration as well as developing conversion scripts and working with services to re-plot multilevel data into a format that wass clinically acceptable within the considerable constraints of the RiO migration tool.An additional data migration was required to repackage source data into a framework for a bespoke archive viewer tool.I also supported the advanced technical design and configuration of RiO and designed service flows through the system. I used system components to create solutions to replace functionality that Medway required but the product did not have (for example a message book system involving assessment forms, User Portal and aspects of workflow).FInally I offered advice and technical configuration (including script development) for a standalone Subject Access Request Module, designed to extract all data on a specified patient, Show less

Following the completion of the Carenotes Recovery Programme, I was asked to lead a project to move the Community Data Warehouse from a supplier network (NELCSU) to GSTT's own internal network, as well as to address outstanding pieces of work for the Informatics Team and to provide information as needed to the EHR project.I was also asked to work on integrations and data validation from the Child Health Hub and to create an engine to extract the Community Services Dataset from Carenotes… Show more Following the completion of the Carenotes Recovery Programme, I was asked to lead a project to move the Community Data Warehouse from a supplier network (NELCSU) to GSTT's own internal network, as well as to address outstanding pieces of work for the Informatics Team and to provide information as needed to the EHR project.I was also asked to work on integrations and data validation from the Child Health Hub and to create an engine to extract the Community Services Dataset from Carenotes / Reporting databases due to deficiencies in the Carenotes product.I worked on initial validation, batch tracing and patient reconciliation between the main acute EPR solutions in play as preparation for their move to Epic. Show less

As Technical Workstream Lead and Design Authority for the Carenotes Recovery Programme, my role was to validate all technical queries for the Carenotes product as well as to review and create Functional Requirement Specifications for delivery of functionality not provided by the supplier. I also reviewed proposals from the Vendor to ensure that changes to the product were compliant with Trust requirements and NHS Standards.I reviewed existing functionality to assess readiness for… Show more As Technical Workstream Lead and Design Authority for the Carenotes Recovery Programme, my role was to validate all technical queries for the Carenotes product as well as to review and create Functional Requirement Specifications for delivery of functionality not provided by the supplier. I also reviewed proposals from the Vendor to ensure that changes to the product were compliant with Trust requirements and NHS Standards.I reviewed existing functionality to assess readiness for Department of Health Information Standards extracts such as the Children's and Young Persons Health Services Data Set and its successor the Community Services Data Set.In addition, I have oversaw and worked with the team of programmers responsible for creating content (Reports, Searches and Forms using JS and XML/XSL) as well as working with the Clinical Analysts to determine the optimum configuration for the Carenotes product.I was also responsible for working with the Vendor on technical integrations including an HL7 messaging service for Newborn Bloodspots, and the upload of patient immunisations.I was responsible for data preparation and validation of the 2nd part of the Child Health Data Migration into Carenotes which could not be delivered by the Vendor for the primary delivery of Carenotes. This included transformation of JSON stored data into structured data, and analysis and extraction of clinical coding which the product uses as a primary reporting method.Finally, I was the technical reviewer for the due diligence process carried out as part of an options paper for the Project Board. This involved meeting multiple Trusts as well as the Civica (PARIS) in order to ascertain their products suitability and maturity as a Child Health solution, as well as carrying out a review of OpenRiO and EMIS. Show less

My role included managing and developing the Data Warehouse integration engine which merged key datafeeds from Carenotes, legacy datafeeds from Servelec RiO and other external data feeds such as EMIS, as well as developing OLAP resources for use by the Community Performance Team, Transformation and System Administration Teams. I also monitored the daily ETL and oversaw receipt and transmission of data between in house systems and external stakeholders such as E-Noting and KHP… Show more My role included managing and developing the Data Warehouse integration engine which merged key datafeeds from Carenotes, legacy datafeeds from Servelec RiO and other external data feeds such as EMIS, as well as developing OLAP resources for use by the Community Performance Team, Transformation and System Administration Teams. I also monitored the daily ETL and oversaw receipt and transmission of data between in house systems and external stakeholders such as E-Noting and KHP Online.With the creation of the London Child Health Hubs, I was responsible for reviewing the technical specification of the messaging output and ensuring that data received had been validated, as well as devising data integration of feeds into the reporting database.I also developed Sharepoint to provide central management of Development, Performance and Configuration requests. I developed configuration reporting for both the System Administration and Transformation teams.I also worked closely with the Informatics team to review compliance against NHS Information Standards Notices such as CIDS, CYPHS and CSDS. Show less

My role was to provide technical overview of the Carenotes product with respect to transforming and preparing data from Servelec Rio for migration to Carenotes. I was also responsible for ensuring that data migration strategy and configuration remained in line with Trust processes and supported Trust reporting. This included working with the Clinical Analysts to determine baseline business processes and configuration from the perspective of reporting requirements.I developed… Show more My role was to provide technical overview of the Carenotes product with respect to transforming and preparing data from Servelec Rio for migration to Carenotes. I was also responsible for ensuring that data migration strategy and configuration remained in line with Trust processes and supported Trust reporting. This included working with the Clinical Analysts to determine baseline business processes and configuration from the perspective of reporting requirements.I developed validation for Carenotes Child Health for both non-structured JSON data and vertically stored clinical coding data and worked with the Data Migration Lead to complete validation on critically tight timescales due to lack of vendor dillience. I also advised on table structures and data extraction / mapping from RiO to Carenotes.I was also technical lead for Carenotes configuring the inital dashboards, front end reports, searches and forms (UDFs) , and training other team members to create basic forms. This involved XML, DSDL (custom Carenotes scripting language based on SQL), javascript and XSL. Show less

The work involved re-drafting and cleaning up MHSDS extraction scripts in order to improve DQMI compliance and to reduce the error rate (the scripts were not cascading) as well as to implement new data extractions around Interventions and Coded Assessments.Additionally I created reporting around the DQMI and Interventions CQUINs and other relevant reporting such as EIP and CYP access, DTOC validation in preparation for moving from BSP submission to providing data via MHSDS.I was… Show more The work involved re-drafting and cleaning up MHSDS extraction scripts in order to improve DQMI compliance and to reduce the error rate (the scripts were not cascading) as well as to implement new data extractions around Interventions and Coded Assessments.Additionally I created reporting around the DQMI and Interventions CQUINs and other relevant reporting such as EIP and CYP access, DTOC validation in preparation for moving from BSP submission to providing data via MHSDS.I was also asked to update CSDS extraction scripts so that extraction could be done by CCG. Show less

Provided Testing and Support for RiO Release 1 First of Type with Southwark, and Fast Follower for Lambeth , focusing on transforming Childrens Services, testing and performance. As well as developing Communications and resources for end users.I also oversaw the testing, development and roll out of waiting lists and developed presentations focused on enhancing Management knowledge and understanding of the RiO Appointment Management System and its supporting features.In addition… Show more Provided Testing and Support for RiO Release 1 First of Type with Southwark, and Fast Follower for Lambeth , focusing on transforming Childrens Services, testing and performance. As well as developing Communications and resources for end users.I also oversaw the testing, development and roll out of waiting lists and developed presentations focused on enhancing Management knowledge and understanding of the RiO Appointment Management System and its supporting features.In addition I provided RiO application expertise, supported the Change Programme and provided both testing and analysis of Maintenance and Configuration Releases.I ran the pilot for Choose and Book Integration from the RiO perspective, working with the Acute Choose and Book Lead on initial roll out and testing for Community in RiO Release 1 and took an active part in testing and development for Choose and Book integration with Release 2. Show less

RiO Release 1 Transformation, Benefits and Communications Leads. RiO V5 Change and Training LeadMy role Includes RiO Performance Analysis and Monitoring, Infrastructure Review, Mobile Working Deployment, Training and System Administration responsibilities.

Various roles including PA to the Business Intelligence Manager (Performance data analysis and collection), Medical Secretarial Cover, Child Development Team coordinator for the Community Paediatrics Service, PA cover for Information Governance.I also developed a full Paediatric Client Management system using MS Access integrated via VBA with MS Word.