نيك Vollans

Worked as a Senior Data Architect on a project to replatform an existing NHS Application.

Short term contract to overhaul the production process for key digital products. Creating a plan to ensure smoother more automated production in the future, allowing the analysts to concentrate on adding new items to the products.

Short contract, writing 2 mandatory health reports from data stored on an incomplete Data Warehouse, incrementally maturing the DW as I proressed.

Short term contract.
Create a process to verify a list of healthcare providers who were not currently submitting MHSDS data by contacting these organisations and help them through the process of submitting their datasets. Hiring any additional staff needed for this project.
Created the processes needed to verify providers, hired and trained 2 admin assistants to do the verification work. Shaped the Data Quality Team for MHSDS at NHS Digital in Leeds. Managed a small team responsible for contacting key personnel at healthcare providers. Created a contact database. Used advanced SQL skills to improve the quality of existing data submissions. Created and updated a local SNOMED database so that the team could perform analysis on the SNOMED data that was being flowed.

Contracting for Bradford District Care Trust
Objectives: Overhaul an MS Access database application to produce MHSDS dataset report.
Activity: Reprogrammed the existing application successfully within 2 weeks. Reduced processing time by% in the next 2 weeks. Created a new version of the software for the yearly updated report in time for the April deadline. Took over as DBA for the organisation. Developed an automated reporting solution for the CDS report. Using advanced SQL I recreated the MHSDS reporting tool in SQL server which made DQ its focus as well as speeding up production. Lead a team of 6 developers and analysts to retire old patient databases.