John Middlewick Email & Phone Number

Hybrid Home/Leeds/London

Development of health-related analytical measures and indicators designed to help improve health outcomes within the NHS. Utilising SQL and Python coding within a Databricks environment to deliver outputs that can be used to develop online publications which can be accessed by clinicians and the wider public incorporating headline measures, narrative, CSV, excel files and interactive Power BI Dashboards. Creation and maintenance of Power BI dashboards including development of National… Show more Development of health-related analytical measures and indicators designed to help improve health outcomes within the NHS. Utilising SQL and Python coding within a Databricks environment to deliver outputs that can be used to develop online publications which can be accessed by clinicians and the wider public incorporating headline measures, narrative, CSV, excel files and interactive Power BI Dashboards. Creation and maintenance of Power BI dashboards including development of National Obesity Audit dashboard and Annual Maternity Dashboard and ongoing updates to existing dashboards. Utilising functionality such as slicers, layer selection, bookmarks, table relationships, customised buttons, customised tooltip pages, dynamic titles to ensure an interactive visual experience. Facilitation of visualisations of source data through merges, conditional and custom columns, table relationships, error handling, DAX and M. Using online applications such as Mapshaper and Geojson to download and manipulate NHS organisational boundary data from the ONS website to utilise in interactive map visuals.Taking a User Centred Design approach working with clinical and managerial stake holders to capture initial requirements and involvement of ongoing development through sharing of outputs data quality issues, managing of expectations and demonstration of visualisations.Working in an Agile working environment utilising Jira, management of tickets and involvement in Agile rituals Show less

Remote - Cherry Hill Nj

Customer service performance analysis reporting functions migration

Development and management of Utilisation Reporting Database in MS Access, identifying required datasets in various formats and locations and incorporating into Utilisation Reporting Database using SQL queries and transformations, automated uploading of CSV files and Excel files and OBDC links to other SQL databases.Development and running of daily, weekly and monthly reports relating to network capacity and utilisation by accessing data from Utilisation Reporting Database and… Show more Development and management of Utilisation Reporting Database in MS Access, identifying required datasets in various formats and locations and incorporating into Utilisation Reporting Database using SQL queries and transformations, automated uploading of CSV files and Excel files and OBDC links to other SQL databases.Development and running of daily, weekly and monthly reports relating to network capacity and utilisation by accessing data from Utilisation Reporting Database and manipulating in Excel using pivot tables, VBA, advanced functions, charts utilising dynamic named ranges delivered as interactive spreadsheets, Powerpoint slides including embedded Excel Charts and used to deliver KPI’s, forecast, scorecards, drill down to identify over utilised cells, reasons and possible fixes and dates to facilitate proactive congestion management.Migration of data feeds after changes to data sources. Changes to the source data involved migrating from CSV outputs to a SQL server database and further migrating the ETL process from the CSV scenario to the SQL source. Achieved by creating new feeds via ODBC links mapping and validating the new data sources to the existing tables in MS Access database. Running the existing and revised processes in parallel to test the effectiveness off the migration.Modelling of network planning scenarios regarding product launches, equipment rollouts anticipated growth utilising using utilisation data and presenting in slide packs and interactive spreadsheets.Automation and streamlining of various internal reporting processes within implementation team using Excel, Access and VBAManagement of decommissioned of legacy equipment.Implementation of remedy ticket tracking and reporting process by development of MS Access database and deployment of database. Show less