Andy Charlwood

about-me-image

As Deputy Head of Population Health & Data Analysis within the Medicines Optimisation team at the NHS Norfolk and Waveney ICB, I focus on leveraging data analytics to optimise medicines usage, enhance prescribing quality, and address health inequalities. I develop analysis via Python, SQL, and Power BI to inform and guide the strategic plan of the medicine optimisation team.

An innovative, data-driven medicine optimisation Pharmacist with a passion for utilising technology to drive efficiencies through automation. In my free time, I'm a father, an avid video/photographer and a tech enthusiast.

  • Location:Norwich, Norfolk
  • Age:31
  • Registration number:2211810
  • Interests:Technology, Photography, Rugby
  • Education:Master of Pharmacy, University of East Anglia
  • Employment:NHS Norfolk & Waveney Integrated Care Board

Summary

My career as a registered pharmacist started in Tesco pharmacy, Great Yarmouth. It was here where I first became curious to the idea of automating workflows through coding, specifically, I created and implemented a system that could automatically check if prescription requests to local GPs could be automatically checked against dispensed items to identify unfilled requests. This saved ~6 hours of staff time checking repeat requests by staff each week.

That was the first time I built my own software solution to a problem I was facing. It led me down a path where I not only see the value in learning these skills but have a passion for it. This hobby led me to becoming proficient in python & SQL, and enables me to provide significant value in my current role as Deputy Head of Population Health & Data Analysis within the Medicines Optimisation team.

I've initiated and completed projects which have improved efficiencies for my colleagues and clinicians in the wider integrated care system. To see some of these examples, please see the projects part of this page.

My motivation has always been to facilitate excellent healthcare. How I channel that motivation has changed massively since 2016. I realise I don't need to be patient facing to achieve that goal. Pivoting from community pharmacy to local health commissioning was driven by a desire to positively impact patient outcomes at a regional level.


Work Experience

Deputy Head of Population Health & Data Analysis, Medicines Optimisation

NHS Norfolk and Waveney Integrated Care Board
June 2024 -

I drive the strategic delivery of population health initiatives from the perspective of medicines optimisation. My role involves spearheading data-driven approaches to improve prescribing quality, address health inequalities, and enhance system efficiency. I provide clinical expertise and oversee complex projects, ensuring alignment with national policies and local healthcare needs.

In this role, I have successfully implemented solutions using Python, SQL, and Power BI to deliver actionable insights, develop interactive dashboards, and streamline decision-making processes for medicines optimisation and population health management.


Responsibilities & key achievements

  • Collaborating with the ICB data team to access, and create insights with patient-level data. Previously the Medicine Optimisation team has been limited to practice-level.
  • Creating an Opioid dashboard to convert all opiates to oral morphine equivalent, to identify and prioritise reviews of patients being over prescribed opiates
  • Leveraging AI to audit repeat prescription adherence at a system-wide level.

Medicines Optimisation - High cost drugs & care homes

NHS Norfolk and Waveney Integrated Care Board
May 2022 - June 2024

Collaborated with specialists to ensure patient access to medicines mandated by new NICE technology appraisals (TAs) while optimizing care pathways to align with national and local guidance and minimize waste.


Responsibilities & achievements

  • Integrated Blueteq platform data with secondary care activity data, resolving data-matching limitations.
  • Redesigned Blueteq forms based on NICE TAs, reducing forms by 70% and saving ~30 hours of admin and pharmacist time monthly.
  • Developed primary care guidance with NSFT during the ADHD medicine shortage
  • Created an oxygen data dashboard to identify primary care patients needing review.
  • Completed high-cost drug pathways for rheumatology, ophthalmology, and gastroenterology.

Pharmacy Manager

Tesco Pharmacy
Nov 2017 - May 2022

Oversaw day-to-day pharmacy operations with autonomy to deliver high-quality, safety-focused services.


Responsibilities & key achievements

  • Led regional projects, including achieving KPIs like the New Medication Service (NMS) and implementing national operational changes.
  • Contributed to national initiatives, such as developing induction training plans for new starters.
  • Served on the Local Pharmaceutical Committee (LPC), supporting Norfolk's community pharmacies.
  • Created and executed plans to meet annual KPI targets, including customer feedback and health service provision.
  • Managed locum pharmacist bookings and ensured an up-to-date business continuity plan.
  • Handled HR responsibilities, including staff rotas, training, recruitment, performance management, and grievances.
  • Collaborated with store and regional pharmacy managers via Microsoft Teams, WhatsApp, and conference calls.

Duty Pharmacy Manager

Tesco Pharmacy
August 2016 - Nov 2017

Joined as a newly qualified pharmacist in August 2016 and, after two months, stepped up as Acting Pharmacy Manager.


Responsibilities & key achievements

  • Co-led initiatives for NMS and asthma referrals, developing resources to support service provision.
  • Designed a quality payments solution for asthma patient screening, implemented nationally, saving pharmacists 30–60 minutes daily and generating potential revenue of ~£1 million.

Pre-Registration Pharmacist

Paydens Pharmacy
July 2015 - July 2016

Chose to train at a busy, understaffed pharmacy offering a wide range of services, providing a strong foundation for my professional career.


Responsibilities & key achievements

  • Took on advanced responsibilities, including patient consultations, resolving prescription interventions, and supporting pharmacy staff.
  • Undertook audits, including one which resulted in an increase in completed NMS, from less than 10% of target to reaching 50-60% target
  • Instigated multiple PGDs, including NRT, EHC & Chlamydia screening/treatment

Education

Master of Pharmacy (MPharm)

University of East Anglia
September 2011 - June 2015
2.1

Developed strong academic and practical skills through research and extracurricular activities.

  • Conducted an independent research project on drug delivery, exploring complex ideas in cocrystals, achieving a distinction- level grade of 75.1%.
  • Demonstrated excellent consultation skills, reflected in a 4th-year OSCE result of 80%
  • Honed time management, creativity, and problem-solving skills while balancing academic and extracurricular commitments.

Non-academic activities

    During my time at UEA I supported several clubs/societies as a committee member:
  • President - Pharmacy society
  • Secretary/Vice-president - Ultimate frisbee
  • Publicity officer - Alzheimer's society

A-Levels: Maths, Chemistry, Politics

Highworth Grammar School
September 2009 - June 2011
Maths (A*), Chemistry (B), Politics (C)

Check out some of my work

PharMetrics

PharMetrics

PharMetrics is an interactive platform for exploring key aspects of health economics and drug development. Discover how healthcare systems evaluate whether new drugs offer value for money. See how research study design can influence outcomes, and step into the role of big pharma navigating the complex testing and approval process in the Trials Tycoon strategy game.

See more
Patient pathway analysis

Patient pathway analysis

An interactive chart displaying patient care pathways for high-cost drugs (example provided has randomised cost/patient numbers). This graph enables an intuitive way to explore patient journeys by trust/directorate, and provides a detailed breakdown of figures such as total patients, cost, frequency of dosing, average cost per patient. Data can be filtered by date/directorate to identify trends of medicine used easily.

See more
Blueteq generator

Blueteq generator

As part of my project to automate work flow relating to Blueteq forms, I created a program which automatically scrapes information from NICE technology appraisals, and generates forms for clinical review before going live. This enables minimal admin work to generate the forms in the future, but more importantly enabled us to standardise and recreate all current live forms with minimal effort.

See more
NMS video

NMS video

Whilst working at Tesco as a community pharmacist, I felt there was an opportunity to expand on NMS provision across stores. I took the initiative in writing, and producing this video explaining NMS. The intention of the video was to train non-pharmacist staff members on how they can support with the NMS service.

See more