Skills, experience and talks

Skills, experience and talks

What I'm good at, and where I've applied it.

Skills

Analysis

  • R
  • SQL
  • Statistical process control
  • Data modelling

Reporting

  • Power BI
  • Excel
  • ggplot2
  • Shiny
  • Quarto / R Markdown
  • QlikView / Qlik Sense
  • SSRS

Data engineering

  • SQL Server
  • SSIS
  • Parquet
  • DuckDB
  • ETL pipelines
  • R package development
  • Git

Working with people

  • Explaining analysis to non-analysts
  • Supporting improvement work
  • Training

My time in the NHS

2021 to now

Health Intelligence Specialist

NHS, Public Health Intelligence

2019 to 2021

Business Intelligence Data Analyst

NHS, Business Intelligence

2015 to 2019

Data Manager

NHS, Quality Improvement

2014 to 2015

Data Analyst, Quality Improvement

NHS

2010 to 2013

Clinical Governance Facilitator

NHS

2008 to 2010

Project Support Officer

NHS

Talks

Occasionally I get invited to give talks or run workshops at conferences. Sometimes I feel brave enough to submit a presentation for a talk. Regardless of how it happens, it always means nerves, and telling myself afterwards I'm never doing it again. Here are all the times I did it again.

2017

Statistical process control and run charts in Qlik

Qlik Healthcare Dev Group, September Gathering

Run charts and control charts originally built in QlikView.

2018

An introduction to R

AphA Scotland, inaugural event

A demonstration of the power of R, featuring a run-through of importing, cleaning and plotting data from Excel. Delivered 4 times throughout the day, it paved the way for our workshop at the NHS-R event in Birmingham later the same year.

2018

Hands-on R workshop

NHS-R Community Conference

A day of practical R for NHS analysts: importing from Excel and SQL Server, wrangling with dplyr, charts in ggplot2 and plotly, animation with gganimate, and automated PowerPoint creation with officer. Resources were shared ahead of time so some attendees followed along on their own laptops, others simply sat back and waited for my ill-advised attempts at live coding to backfire.

2020

Rapid analysis and presentation of Quality Improvement data with R

R/Medicine

Lightning talk demonstrating runcharter and spccharter.

2020

My data.table hat trick

NHS-R Community Conference

Lightning talk on runcharter, patientcounter and spccharter, three packages that rely heavily on the wonderful data.table package.

2022

Dynamic SQL from R, into Shiny

SCODAS

Looping over a remote database using dynamic SQL from R, and visualising the query results in a Shiny dashboard.

2023

An introduction to checks and tests

KIND

A gentle introduction to thinking about checking and testing your R code, with some example use of the tiny but powerful checkmate and tinytest packages.