Staffordshire, England, United Kingdom
I am a Data Migration and Business Intelligence Consultant with over three decades of experience delivering complex data solutions across the NHS and private sectors. My work is driven by a passion for transforming complex data challenges into streamlined, high-performing systems. I specialise in SQL Server development, ETL (SSIS), data warehousing, and data migration strategy, with a strong focus on data integrity, quality, and performance optimisation. After earning my HND in Maths, Statistics, and Computing from the Polytechnic of North London, I began my career in software development and systems engineering, working with technologies such as VB, Delphi, and Oracle SQL, before advancing to the full Microsoft SQL Server stack (SSMS, SSIS, SSRS, SSAS). Over time, my focus evolved toward delivering robust, scalable data platforms for healthcare, where accuracy, security, and reliability are essential. I have supported over twenty NHS organisations, leading large-scale data migrations between systems such as RiO, EMIS, and CareNotes, and developing data warehouses and BI frameworks that underpin national reporting, patient tracking, and clinical analytics. Recent highlights include: LSCFT NHS Trust – migration from RiO to EMIS, ensuring accurate patient cohort identification. Royal Free London – merging national reporting datasets across trusts into a unified structure. Apira – designing data migration strategies with clear scope, rollback planning, and business continuity. Sheffield Health and Social Care – leading migration development, automation, and data quality improvement. Birmingham Women’s and Children’s NHS – managing the CareNotes to RiO migration, optimising ETL routines and documentation. Throughout my career, I’ve focused on combining technical precision with strategic insight—developing automated validation pipelines, optimising databases through indexing, applying GDPR-compliant data governance, and implementing Power BI and DevOps frameworks to enhance reporting and transparency. I take pride in delivering migrations that are efficient, accurate, and disruption-free, while mentoring teams and advising stakeholders to align technical solutions with business goals. My approach is grounded in curiosity, precision, and a continual drive to make data systems more reliable, efficient, and insightful for the organisations that depend on them.
Statutory submission integration for Royal Free Hospital and North Middlesex University Hospital. Investigate the processes at each trust and develope a unified datamarts to report from a single data source.,
In my role as a Data Migration Strategy Consultant, I significantly impacted project outcomes through: Establishing Clear Project Scope. Set realistic goals and timelines that minimised scope creep and aligned with organisational expectations. Detailed Data Assessment and Profiling. Proactively identified potential risks, enabling effective mitigation strategies that preserved data integrity and reduced project delays. Precise Mapping and Transformation. Ensured compatibility and consistency in data, maintaining high data quality crucial for operational efficiency post-migration. Strategic Migration Approaches. Selected migration approaches based on detailed analysis, minimising downtime and maintaining business continuity. Comprehensive Rollback Plan. Prepared for unforeseen failures to safeguard operational stability, ensuring a safety net that allowed quick recovery and minimal impact. Thorough Documentation and Proactive Communication. Enhanced collaboration and kept all stakeholders well-informed, contributing significantly to the project's success and operational stability. These efforts underscore my expertise in managing critical technical initiatives and demonstrate my leadership in ensuring smooth and efficient project execution.
I significantly enhanced the Data Migration project by leading strategic oversight, managing technical innovations, and ensuring effective communication and collaboration across teams. Led and supervised the Data Migration project, ensuring smooth execution and strategic oversight. Managed a team of developers, coordinating efforts to meet project goals. Enhanced migration strategies and documentation, contributing to improved processes and effectiveness. Engineered advanced ETL processes and constructed data pipelines using CI/CD methodologies for better data integration. Enhanced and optimised View, Stored Procedures and Functions by adding Clustered and Non-Clustered indexes Ensured alignment across various project streams, fostering effective communication and collaboration. Identified and addressed deficiencies in data mapping and configuration, enhancing the overall quality and reliability of the migration. Contributed to the project’s documentation and reporting, crafting informative presentations and deploying success criteria Dashboards. Overall, my leadership and technical expertise drove the success of the Data Migration project, ensuring strategic alignment, operational efficiency, and the achievement of all project objectives.
I effectively led the CareNotes to Rio Data Migration project, demonstrating comprehensive leadership, strategic planning, and technical expertise to ensure successful project execution and alignment with key objectives. Led the CareNotes to Rio Data Migration project, showcasing leadership and strategic planning. Authored essential strategy documentation to guide the migration process. Engineered ETL routines for optimal data extraction from CareNote and parametrised stored procedures. Developed optimised Views, Stored Procedures and Functions through the use of Clustered and Non-Clustered Indexes across all objects Provided technical guidance to the project board, influencing key decisions. Participated in resource planning and candidate interviews to build a competent team. Advised on the creation and management of project documentation. Facilitated effective communication and collaboration with key project leads. Ensured data integrity and proper alignment of data flows in collaboration with the Data Warehouse and Configuration Leads. Managed comprehensive resource allocation across all project facets to ensure successful project execution. Contributed to aligning all project activities with overarching project objectives. Overall, my leadership and technical skills drove the success of the CareNotes to Rio Data Migration project, ensuring thorough planning, optimal resource allocation, and seamless execution across all project facets.