Stuart Lomas Email & Phone Number

Manchester, England, United Kingdom

Warrington, England, United Kingdom

• Lead developer for multiple patient administration system change and merge projects for IAPT services using agile methodology, influencing system design and developing full ETL process using Powershell and SSIS and.
• Lead developer for Mental Health Services Dataset, a 62 table relational secondary uses database, reporting from multiple data sources, SQL servers and databases in SSMS plus SSIS export to MS Access submission database.
• Development of robust SQL reporting tables from multiple data sources plus performance optimisation in data transformation in SSIS and SSMS. Data splitting for different Trusts following reorganisation and contractual.
• Migration of all ETL from SSIS 2008 to SSIS 2016, SSMS 2012 to SQL 2019 and reports from SSRS 2008 to SSRS 2019.
• Development of over 50 SSRS performance reports dashboard reports at Trust and service level in SSRS 2016 enabling time saving and improved awareness through automation and roll out of self-service reporting.

Warrington, England, United Kingdom

• Developing and improving reporting processes for Mental Health project reports and statutory returns using Microsoft SQL Server Management Studio and Report Writer 2, MS Access and Excel.
• Supporting roll out of PARIS community health database across wider range of services, ensuring reporting, process and service requirements are met to support move towards electronic health records. Testing new.
• Developing a suite of reports from PARIS patient administration system using Oracle PL-SQL and EIS for monthly performance and other adhoc reports. Automation of reporting via MS Excel into various performance and.
• Working closely and autonomously with operational teams to gathering service, commissioner and reporting requirements to develop standalone data systems for services to enable the accurate and automated collection of.
• Line management

Huyton, England, United Kingdom

• Supporting roll out of PARIS community health patient administration system across wider range of services, ensuring reporting, process and service requirements are met to support move towards electronic health.
• Developing a suite of reports from PARIS using Oracle PL-SQL and Business Objects/EIS for monthly performance and other adhoc reports. Automation of reporting via MS Excel into various performance and management.
• Working closely with provider teams to develop standalone data systems for services to enable the accurate and automated collection of data for performance reporting, other internal reports and to improve the.
• Statutory national return submission, validation and analysis.

Huyton, England, United Kingdom

• Analysing NHS provider data and returns using MS Excel and Access and reporting primary care statutory returns to Department of Health via Unify2 and other media.
• Developing reports for community health services such as Musculoskeletal Therapy Services using ODBC links from Hearts PAS system to MS Access and reporting via MS Excel.
• Developing reports using Business Objects and EIS.
• Working with provider teams to develop robust standalone databases using MS Access and adapting these to meet services' requirements.
• Combining data from several acute, community health and social care sources to support Triple Aim project.

Huyton, England, United Kingdom

• Database system management and data cleansing of SWIFT Social Care system.
• Accurate system input and analysis of data using Business Objects and MS Excel.
• Process planning for intermediate care statistics; workshop facilitation; improvement in social care team data processes; document development.
• Managing KPIs using Covalent management tool.