Jo O'Neil Email & Phone Number

Population Health Management.Proactive Case Management,Anticipatory Care,Risk Stratification.ACG / Sollis Clarity.Oracle / Cerner HealtheIntent,Ssentif.Fingertips.Integrated systems service redesign.Patient pathway analysis.Benchmarking.Invoice validation.Data quality and validation.Process mapping.Privacy impact assessments.DPIA,SUS / SLAM.111 RAIDR dashboard.ECDS.Risk Stratification tools - End user support, training, documentation, query writing, user acceptance testing, regression testing, issue investigation , analysis, reports.Global Burden of Disease,Ardens Manager

Partner in The Data Office which my husband and I launched following our move to the Isle of Wight in 2007. Experience in data migration, cleansing, process mapping, metric reporting, testing, SQL query writing and OLAP cubes. Recently gained Prince2 Practitioner qualification. Industry experience includes: - Private medical insurance, call centre, SLA monitoring, NHS - workforce and PCT, national government programme, pharmaceutical, asset management, healthcare commissioning (private sector company working with NHS), pension and HR systems.

Security ClearedData migration / cleansing project.SQL test scripts / process mapping.White box testing.BAU support.

In my role I was part of the team that assessed, implemented and supported clients. This particularly involved the understanding of the HealthNumerics-RISC Risk Stratifcation and Population Health Management application and how the functionality of this application could provide benefits to the PCT by highlighting trends, issues and to support enhanced patient care. Main duties included:· Mapping processes for issue reporting and resolution, data protection and system access.· Maintaining and controlling the issue and enhancements logs.· Mapping the flow of information through the application from upload, validation, querying and front end reporting.· Training end users and administrators in the functionality and benefits of the application.· Investigating issues and supporting the testing and implementation of patches.· Leading weekly conference calls with the IT Support team (Toronto) and the operations team to discuss, prioiritse and plan issues and patch releases.

The role was part of a project team responsible for the procurement, configuration and roll out of a third party asset management solution. The project utilised PRINCE2 methodology and strict Q&C processes:· Creating a data dictionary detailing the structure and table relationships.· Creating SQL queries to update and extract information.· Amending lookup tables in the software and changing configurations to enable additional data to be captured.· Creating Design Specification to detail the functionality of the product.· Mapping the data flows of asset information through the various information systems and sources.· Analysing the source Human Resources information and mapping the required fields to the third party supplied application.· Investigating issues with the system and liaising with the third party suppliers to resolve problems.· Creating test scripts and performing testing on the tool and processes..Black box testing.

Providing user training to groups or an individual basis on a bespoke web based data entry application.Conducting full audit visits at NHS and Private hospitals, writing up an audit report and performing a follow up review to identify progress on agreed actions and resolve any further issues.Creating a consistent and structured visit proforma. This enabled a full analysis of the hospitals situation to be assessed. Potential barriers to compliance were identified and discussed. Examples of Best Practice were compiled and used to assist hospitals with specific issues.Creating and distributing an automated report for all regional coordinators based on an OLAP cube.Representing the NJR at national and regional events such as the British Orthopaedic Association annual meeting, British Hip Society annual meeting.Regularly meeting and discussing data report with senior orthopaedic surgeons to discuss the hospitals in the areas that they represent.

· Processing Commissioning Data Set data from hospital trusts and importing into an SQL Server 2000 database.· Analysing PCT and other data providers’ data capture systems and performing data quality checks.· Co-ordinating receiving, validating and aggregation of data to fulfil statutory returns. Communicating with all data providers (e.g. Trusts, Local Government, Specialist Trusts, Primary care) to ensure Local Delivery Plans were completed.· Analysing commissioning data to support performance management, KPI’s and SLA’s

· Co-ordinating the receiving, validation and aggregation of workforce data to support national programmes.· Communicating with various stakeholders regarding the purpose of data requests and the valid format for data.· Investigating and developing the structure of the Workforce Monitoring Database to enable efficient data transfer and to be able to provide meaningful and useful information concerning the local workforce.

Within a rapidly developing and changing department, which provided facilitation services for both private medical insurance members and external customers. I provided critical support through the production and analysis of information, this required the continual improvement and development of this information to assess and evaluate development opportunities within the healthcare market.I developed Access databases and robust data validation mechanisms to support the Capital Hip Care Centre and the Trilucent Care Centre to enable accurate and timely information to be presented to the Department of Health.I created and performed regular data quality checks to ensure the data was consistent and accurate.The key accountabilities of the were; -·Reporting ·Analysis ·Data Integrity ·System Support & Problem Solving ·Data Collection Solutions

2.I, Mathematics, Statistics And Operational Research

2 A Grades And 1 B Grade, 4 A Levels - Statistics A, Biology A, Pure Maths B, General Studies C

8 A Grades & Distinction In Mathematics Extension, 8 Gcse A Grades - Maths, Eng Lit, Eng Lang, Science (2), Bus Studies, Hsty, Frch