Work experience
Senior Information Analyst
April 2008 - January 2010
-
Created Interactive Reporting Services on Acute and Community Information.
-
Created Financial Practice Based Commissioning (PBC) Reports (using SSRS) for 23 GP Practices across Blackpool.
-
Worked with the PCTs and Blackpool Victoria Hospitals Trust Finance departments in implementing HRG4, creating comparison reports to help see variations in Groupers and Tariffs.
-
Extracted SEM and Payment By Results data from Secondary Uses Service (SUS) then setup SSIS routines to load into SQL Data Warehouse.
-
Help develop the PCTs Data Warehouse automation by up SQL Server Agent Jobs, SSIS Packages, Standardised Scripts, etc.
-
Created World Class Commissioning Reports & Dashboard.
-
Arranged for Daily feeds of Blackpool Victoria's Hospitals Trust A&E, Admissions & Discharge data to be transferred to the PCT for disseminating to Blackpool GPs.
