Experience

Essex Partnership University NHS Foundation Trust

• United Kingdom
• Hospitals and Health Care
• 700 & Above Employee

• Information Analyst

  • Mar 2020 - Present

  (Mental health) Regular and ad hoc querying and reporting from Oracle and SQL Server databases using Excel. (Mental health) Regular and ad hoc querying and reporting from Oracle and SQL Server databases using Excel.



Chelsea and Westminster Hospital NHS Foundation Trust

• United Kingdom
• Hospitals and Health Care
• 700 & Above Employee

• Lead Information Analyst

  • Feb 2019 - Mar 2020

  All regular reporting. QlikView, Oracle, Sql Server, Excel and some Business Objects. Conversion of Business Objects queries to Oracle PL/SQL views. All regular reporting. QlikView, Oracle, Sql Server, Excel and some Business Objects. Conversion of Business Objects queries to Oracle PL/SQL views.



Norfolk and Suffolk NHS Foundation Trust

• Hospitals and Health Care
• 700 & Above Employee

• SQL Server Developer

  • Sep 2017 - Feb 2019

  John was invited to return to the (mental health) trust to cover ad-hoc reporting and small projects including a care quality dashboard which depended largely on Datix incident data. See also earlier entry below. John was invited to return to the (mental health) trust to cover ad-hoc reporting and small projects including a care quality dashboard which depended largely on Datix incident data. See also earlier entry below.



King's College Hospital NHS Foundation Trust

• United Kingdom
• Hospitals and Health Care
• 700 & Above Employee

• BI Analyst

  • Jun 2017 - Sep 2017

  Ad hoc and regular reporting from an Oracle database. Ad hoc and regular reporting from an Oracle database.



Royal Free London NHS Foundation Trust

• Hospitals and Health Care
• 700 & Above Employee

• SQL Server / VBA Developer

  • Aug 2016 - Dec 2016

  Responsible for maintenance and development of data entry and reporting systems covering RTT validation, diagnostic validation, outsourcing, pending discharge and patient safety. MS Access front ends (both bound form and “scatter and gather”), SQL Server with Excel reporting (self-service and scheduled automated outputs). Responsible for maintenance and development of data entry and reporting systems covering RTT validation, diagnostic validation, outsourcing, pending discharge and patient safety. MS Access front ends (both bound form and “scatter and gather”), SQL Server with Excel reporting (self-service and scheduled automated outputs).



Norfolk and Suffolk NHS Foundation Trust

• Hospitals and Health Care
• 700 & Above Employee

• SQL Server Developer

  • Jul 2014 - Jun 2016

  (Mental health) All reporting requirements and data warehouse extension using SQL Server. Ad hoc SQL scripting. Excel vba development. Some SSRS using Visual Studio 2005. For 2 consecutive financial years developed contractual reporting process for waiting times covering multiple standards for referral to treatment [RTT], referral to assessment [RTA] and assessment to treatment [ATT] by service line.The 2 processes used 2 different techniques to extract and present the data. (Mental health) All reporting requirements and data warehouse extension using SQL Server. Ad hoc SQL scripting. Excel vba development. Some SSRS using Visual Studio 2005. For 2 consecutive financial years developed contractual reporting process for waiting times covering multiple standards for referral to treatment [RTT], referral to assessment [RTA] and assessment to treatment [ATT] by service line.The 2 processes used 2 different techniques to extract and present the data.



Basildon & Thurrock University Hospitals NHS Foundation Trust

• United Kingdom
• Hospitals and Health Care
• 700 & Above Employee

• Information Analyst

  • Jan 2014 - Jul 2014

  Creating SQL Server databases for KPI and RTT dashboards.Ad hoc SQL scripting. Excel vba development. Creating SQL Server databases for KPI and RTT dashboards.Ad hoc SQL scripting. Excel vba development.



Barts Health NHS Trust

• United Kingdom
• Hospitals and Health Care
• 700 & Above Employee

• Information Analyst

  • Oct 2013 - Jan 2014

  RTT reconciliation using SQL across the 3 legacy trusts following the merger in April 2013.Development of an RTT dashboard. RTT reconciliation using SQL across the 3 legacy trusts following the merger in April 2013.Development of an RTT dashboard.



Clinicenta

• SQL Developer

  • Oct 2011 - Jan 2014

  Started one month after go live in a busy team.Helping to meet all internal and external information requirements including Unify2 (particularly RTT), HRG grouping, CPTS (billing) and CDS.Reconciliation of outputs and redevelopment of data warehouse components.Development of standard operating procedures and implementation of the PCT to CCG transition. Started one month after go live in a busy team.Helping to meet all internal and external information requirements including Unify2 (particularly RTT), HRG grouping, CPTS (billing) and CDS.Reconciliation of outputs and redevelopment of data warehouse components.Development of standard operating procedures and implementation of the PCT to CCG transition.



Barts Health NHS Trust

• United Kingdom
• Hospitals and Health Care
• 700 & Above Employee

• Business Analyst

  • Aug 2011 - Oct 2011

  John was invited to return to Newham to improve the quality and quantity of information being provided to the Women, Children and Sexual Health directorate. The directorate was expanding to meet demand whilst maintaining its lead in quality of care. John was invited to return to Newham to improve the quality and quantity of information being provided to the Women, Children and Sexual Health directorate. The directorate was expanding to meet demand whilst maintaining its lead in quality of care.



NHS Suffolk and North East Essex Integrated Care Board

• Hospitals and Health Care
• 1 - 100 Employee

• Data Analyst

  • Mar 2011 - Aug 2011

  (In the PCT before it became the CCG.) Working in the Urgent Care Commissioning team, John was the sole analyst gathering and reporting complex performance data from various providers (A&E, hospitals, GPs, etc.).This information informed decisions regarding the creation new schemes and the negotiation of appropriate contracts. (In the PCT before it became the CCG.) Working in the Urgent Care Commissioning team, John was the sole analyst gathering and reporting complex performance data from various providers (A&E, hospitals, GPs, etc.).This information informed decisions regarding the creation new schemes and the negotiation of appropriate contracts.



Colchester Hospital University NHS Foundation Trust

• United Kingdom
• Hospitals and Health Care
• 300 - 400 Employee

• Business Analyst

  • Oct 2010 - Mar 2011

  Assisting development of a business intelligence replacement for over 200 existing internal, external and ad-hoc reports. Using Insource Data-Academy and Analyzer with SQL Server. Assisting development of a business intelligence replacement for over 200 existing internal, external and ad-hoc reports. Using Insource Data-Academy and Analyzer with SQL Server.



London Borough of Tower Hamlets

• United Kingdom
• Government Administration
• 700 & Above Employee

• Data Analyst

  • Mar 2010 - Jun 2010

  Prepared the Ethnic Minority Achievement Grant and the Profile of School Information for the borough’s 96 schools. He also assisted with the DCSF School Workforce return.John has used DCSF School Census, EYFSP and key stage data from NEXUS, KEYPAS, eRoom and EPAS. Prepared the Ethnic Minority Achievement Grant and the Profile of School Information for the borough’s 96 schools. He also assisted with the DCSF School Workforce return.John has used DCSF School Census, EYFSP and key stage data from NEXUS, KEYPAS, eRoom and EPAS.



Barts Health NHS Trust

• United Kingdom
• Hospitals and Health Care
• 700 & Above Employee

• Business Analyst

  • Nov 2008 - Jan 2010

  Newham Hospital. In a growing team of 8, producing statutory and board-level reports. Also involved in the creation of ad-hoc reports for both internal and external consumption.Produced reports and presentations to the board regarding equality and diversity within the workforce, the patients and the community. Also responsible for gathering human resource data from ESR and financial data from the financial management team to produce board-level scorecards.John developed a good working knowledge of the operational directorates, especially the monitoring of key performance indicators including benchmarking (mainly using Dr Foster).He has detailed knowledge of EPR and CDS and peripheral knowledge of 18 week reporting.



London Borough of Hackney

• United Kingdom
• Government Administration
• 700 & Above Employee

• Data Analyst Environment and Pollution

  • Jul 2008 - Nov 2008

  Producing performance reports from M3 and a bespoke database. Producing performance reports from M3 and a bespoke database.



London Borough of Sutton

• United Kingdom
• Government Administration
• 700 & Above Employee

• Information Officer

  • Mar 2008 - Jul 2008

  Children's Services and EducationExtracting data from Paris and taking feeds from schools and other teams in the borough, cross-checking it to confirm its validity, requesting any corrections and reporting to management and central government. John assisted with the submission of various returns including PAF, SSDA903 and Key Stages 1 to 4. He worked on performance monitoring of Children's Centres using Capita's eStart. During his time at Sutton the borough was preparing for the JAR, developing ContactPoint and implementing Tribal.



London Borough of Lambeth

• United Kingdom
• Government Administration
• 700 & Above Employee

• Information Officer

  • Jan 2008 - Mar 2008

  Data matching and cleansing using Framework-I, Sx3, Academy, Multiview, Anite, and Onyx CRM. Data matching and cleansing using Framework-I, Sx3, Academy, Multiview, Anite, and Onyx CRM.



London Borough of Hammersmith and Fulham

• Information Officer

  • Nov 2007 - Jan 2008

  Children's Services and EducationRegular and ad-hoc reporting from Framework-I using Business Objects and Oracle SQL (via Oracle Tools). Extensive re-manipulation using MS Access and Excel including VBA. Children's Services and EducationRegular and ad-hoc reporting from Framework-I using Business Objects and Oracle SQL (via Oracle Tools). Extensive re-manipulation using MS Access and Excel including VBA.



London Borough of Greenwich

• Government Administration
• 100 - 200 Employee

• Trainer

  • Mar 2007 - Jul 2007

  Floorwalker (including assessment of training needs and one-to-one training)Working with social workers and occupational therapists using Framework-I in Older People's Services, Mental Health, Rapid Response, Queen Elizabeth Hospital, Occupational Therapy, Physical Disability and Sensory Impairment. Floorwalker (including assessment of training needs and one-to-one training)Working with social workers and occupational therapists using Framework-I in Older People's Services, Mental Health, Rapid Response, Queen Elizabeth Hospital, Occupational Therapy, Physical Disability and Sensory Impairment.



London Borough of Camden

• United Kingdom
• Government Administration
• 700 & Above Employee

• Trainer

  • Aug 2006 - Mar 2007

  Helping establish better working practices within Framework-I (one year after go live). On-site support for over 100 workers. Data quality initiatives including JAR preparation. Providing assistance with department restructuring and rollout of version 2.8.1.0. Helping establish better working practices within Framework-I (one year after go live). On-site support for over 100 workers. Data quality initiatives including JAR preparation. Providing assistance with department restructuring and rollout of version 2.8.1.0.



London Borough of Harrow

• Trainer

  • Oct 2005 - Jun 2006

  FloorwalkerSupported a team of about 30 social workers and 15 managers and administrators in Older People's Services during Harrow's first Framework-I go-live. Then Children's Services at Northwick Park Hospital and the Children with Disabilities Team. FloorwalkerSupported a team of about 30 social workers and 15 managers and administrators in Older People's Services during Harrow's first Framework-I go-live. Then Children's Services at Northwick Park Hospital and the Children with Disabilities Team.