About Me

From Pharmacy Counter to Population Health Analytics

My journey started behind the counter at Tesco Pharmacy in Great Yarmouth. It was there I discovered my passion for automation when I built my first software solution—a system to automatically cross-reference prescription requests with dispensed items, saving 6 hours of staff time weekly.

That spark led me to become proficient in Python and SQL, skills that now drive significant impact. I've developed algorithms identifying £2.8M in annual savings, automated processes that reduced months of manual work to just 3 days, and built dashboards serving clinicians across the integrated care system.

Pivoting from community pharmacy to health commissioning was driven by a realisation: I don't need to be patient-facing to facilitate excellent healthcare. Now, leading data analytics for medicines optimisation, I impact outcomes at a regional level—transforming how we use data to improve prescribing quality and address health inequalities.

View my experience

Location

Norwich, Norfolk, UK

Current Role

Deputy Head of Population Health & Data Analysis

Education

MPharm (Hons), University of East Anglia

Registration

GPhC Registered Pharmacist (2211810)

"My motivation has always been to facilitate excellent healthcare. I've just found a more impactful way to channel it—through data."
Technical Expertise

Skills & Technologies

Combining healthcare domain expertise with modern data engineering and analytics capabilities

andy@nhs-analytics ~
$
$
savings_analysis.py
01import pandas as pd
02from sqlalchemy import create_engine
03
04# NHS Prescribing Data Analysis
05def calculate_savings(df):
06 """Identify cost optimisation opportunities"""
07 savings = df.groupby("practice_id").agg({
08 "cost": "sum",
09 "patients": "count"
10 })
11 return savings[savings.cost > threshold]

Programming

PythonSQLJavaScriptTypeScript

Data & Analytics

Power BIExcel (Advanced)pandasNumPyData ModelingStatistical Analysis

Healthcare Systems

NHS Data Systemsdm+dEPACTBlueteqSystmOne

Clinical Informatics

Population HealthPatient-Level DataEHR IntegrationClinical Decision SupportPrescribing Analytics

Regulatory & Governance

NICE GuidanceMHRANHS DigitalGDPRInformation Governance

Development Tools

GitVS CodeJupyterDocker
Career Journey

Professional Experience

From community pharmacy to NHS leadership—a journey of continuous growth and innovation

Lead data analytics strategy for medicines optimisation, developing bespoke datasets and analytical frameworks. Acted as Interim Head (May-Sept 2025) reporting to Associate Director of Pharmacy.

Key Achievements

  • Managed £220M prescribing budget with sophisticated forecasting models
  • Designed Python algorithm identifying £2.8M annual savings across 14,000 patients
  • Automated incentive scheme analysis: months → 3 days processing time
  • Created comprehensive opioid monitoring dashboard for clinical safety
  • Developed £14.6M QIPP efficiency savings target, achieving over-target performance

Led implementation of NICE technology appraisals and high-cost drug pathways, ensuring patient access while optimising care pathways.

Key Achievements

  • Automated Blueteq form creation: 70% reduction in forms, saving 30 hours monthly
  • Integrated Blueteq data with secondary care databases for accurate tracking
  • Developed clinical pathways for rheumatology, ophthalmology, and gastroenterology
  • Created Python-based Sankey chart analysis for patient journey visualisation

Managed all pharmacy operations with full autonomy, leading regional initiatives and contributing to national improvements.

Key Achievements

  • Designed national asthma screening solution: 30-60 mins saved daily per pharmacy
  • Created induction training eLearning modules deployed across Tesco pharmacy estate
  • Led NMS delivery initiatives achieving target performance across region
  • Served on Local Pharmaceutical Committee supporting Norfolk's community pharmacies

Progressed rapidly from newly qualified pharmacist to Acting Pharmacy Manager within two months.

Key Achievements

  • Co-led initiatives for NMS and asthma referrals across region
  • Built first automation solution for prescription request tracking

Completed professional training in challenging, service-rich environment.

Key Achievements

  • Increased NMS completion rates from <10% to 50-60% through process improvement
  • Initiated Patient Group Directions for NRT, EHC, and chlamydia services
Education & Qualifications

Academic Background

Mary Seacole Leadership Programme

NHS Leadership Academy

78%

April - October 2018

  • Formal NHS leadership qualification
  • Healthcare leadership approaches and change management
  • System-level strategic thinking

Master of Pharmacy (MPharm)

University of East Anglia

2:1 Honours

2011 - 2015

  • Independent research project on drug delivery cocrystals (75.1%)
  • OSCE clinical skills assessment (80%)
  • President of Pharmacy Society

A-Levels

Highworth Grammar School

Maths (A*), Chemistry (B), Politics (C)

2009 - 2011

Portfolio

Featured Projects

A selection of tools and solutions I've built to improve healthcare delivery

PharMetrics

Interactive platform for exploring health economics and drug development. Discover how healthcare systems evaluate drug value, research study design impact, and play Trials Tycoon strategy game.

ReactHealth EconomicsInteractive

Patient Pathway Analysis

Interactive Icicle chart displaying patient care pathways for high-cost drugs. Enables intuitive exploration of patient journeys by trust/directorate with detailed cost breakdowns. Produced with fake data for demonstration purposes.

PythonData VisualizationIcicle

Blueteq Form Generator

Automated program scraping NICE technology appraisals to generate standardised Blueteq prior approval forms. Enabled 70% reduction in forms and consistent formatting across the system.

PythonAutomationNICE

NMS Training Video

Educational video explaining the New Medication Service to train non-pharmacist staff. Produced to expand NMS provision across Tesco pharmacy stores.

Video ProductionTrainingNMS
Get in Touch

Let's Start a Conversation

Whether you're interested in collaboration, have questions about my work, or just want to connect—I'd love to hear from you.