In this Role I was responsible for Designing Backend Database for CQUIN Project for the CHD Network and worked on redesigning the Trust Old Data warehouse.Description of successes and responsibilities: Development For both Projects done on SQL SERVER 2017. Worked on SliverLink and CRIS PAS Systems and Have Very Good Knowledge on Both PAS Systems. Used Azure Devops for Weekly Sprints. Involved in database design, Tables, Views, and Functions and Developing Stored… Show more In this Role I was responsible for Designing Backend Database for CQUIN Project for the CHD Network and worked on redesigning the Trust Old Data warehouse.Description of successes and responsibilities: Development For both Projects done on SQL SERVER 2017. Worked on SliverLink and CRIS PAS Systems and Have Very Good Knowledge on Both PAS Systems. Used Azure Devops for Weekly Sprints. Involved in database design, Tables, Views, and Functions and Developing Stored procedures for CHD Project. Was responsible for loading the data from FTP server into Data warehouse using SSIS. Redesigned data warehouse in order to ensure productivity, efficiency and maintainability a series of standards needs to be used. Optimised T-SQL queries adding Necessary Indexes to it. Show less

The Methods Insight Analytics team has grown out of the East Midlands Quality Observatory, an NHS team that, from 2009-2013, worked as part of NHS East Midlands and latterly NHS Midlands and East SHA to use data sourced locally and nationally to inform front line clinicians and the public about variation in the quality and outcomes of care so improvements can be made.The team comprises of a highly qualified and experienced group of information and healthcare specialists focused in the… Show more The Methods Insight Analytics team has grown out of the East Midlands Quality Observatory, an NHS team that, from 2009-2013, worked as part of NHS East Midlands and latterly NHS Midlands and East SHA to use data sourced locally and nationally to inform front line clinicians and the public about variation in the quality and outcomes of care so improvements can be made.The team comprises of a highly qualified and experienced group of information and healthcare specialists focused in the provision of strategic intelligence around quality and safety of care for the UK healthcare market. We work with a wide range of clients in the NHS and academia.Our vision is to deliver actionable knowledge on population provision and healthcare provider clinical performance, to enable the public, commissioners, providers and policy makers to have comparable, transparent intelligence to make decisions on, analyse the quality of healthcare services, make comparisons, and assess change.Our plan is to provide a range of standard analysis free to everyone. We also provide specifically commissioned bespoke analysis and services as well as specialised information products that will be available on a subscription basis. Our consulting service integrates with the wider Methods healthcare consulting team to offer insight driven projects. Show less

NHS East midlands will provide insight into the quality of services across the East Midlands for the public and the local NHS, supporting organisations in delivering high quality services. The roles undertaken and functions delivered by NHS East midlands need to enable users across the region to maximise benefits and use us to deliver the vision, supporting healthcare organisations to make evidence-based, robust decisions. My responsibility is to load the HES (Hospital Episode statistics)… Show more NHS East midlands will provide insight into the quality of services across the East Midlands for the public and the local NHS, supporting organisations in delivering high quality services. The roles undertaken and functions delivered by NHS East midlands need to enable users across the region to maximise benefits and use us to deliver the vision, supporting healthcare organisations to make evidence-based, robust decisions. My responsibility is to load the HES (Hospital Episode statistics) national NHS data in to our data warehouse using SSIS, generating reports using SSRS,Qlikview and maintain their data warehouse. Show less

Daniel Contractors is sub-contractor for United Utilities; The Company’s core activities broadly cover utility works, civil engineering, cross-country pipelines, facilities management and plant hire. I had given a responsibility of loading the data of united utilities using SSIS into SQL server and to generate reports Using SSRS.

I had been given responsibility of Scoping, analysis first and then performed the role of BI consultant. The health smart project involved developing database programs like procedures and functions to generate medical reports. The reports are the health care reports run on a monthly/quarterly/half-yearly & yearly periods.I was ETL & reporting developer responsibility includes requirements analysis, data model preparation (dimensional model) for the data warehouse, ETL Design, Scheduling of… Show more I had been given responsibility of Scoping, analysis first and then performed the role of BI consultant. The health smart project involved developing database programs like procedures and functions to generate medical reports. The reports are the health care reports run on a monthly/quarterly/half-yearly & yearly periods.I was ETL & reporting developer responsibility includes requirements analysis, data model preparation (dimensional model) for the data warehouse, ETL Design, Scheduling of jobs, reporting. ETL tool used was SSIS and reporting used was SSRS. Show less