Hi, I’m Tom Jemmett

I’m a Senior Healthcare Analyst working in the NHS for The Strategy Unit.

About

profile.jpg

I have over 10 years experience as an analyst working within the NHS, working in a number of provider trusts and within the Midlands and Lancashire Commissioning Support Unit.

I have a background in Computer Science and Pure Mathematics, graduating from The Open University with first class honours.

I’m currently a member of the BCS, an associate member of the IMA, and a member of AphA.

I’m an active member of the NHS-R Community and a Senior Fellow in the NHS-R Academy.

  • R
  • Python
  • Haskell
  • C/C++
  • bash/zsh
  • SQL (T-SQL, pg/pl SQL)

Projects


Latest Post

2021-11-30

Why we should use UUIDs for all primary keys

Recently I’ve been working with HES data on a project, and the current structure of tables we have is for each of the different datasets (Inpatients, Outpatients, Emeregency Care, etc.) we have a separate table for each financial year. Within these there will be a column like EPIKEY or ATTENDKEY which is the primary key in that table. This key is stored as a BIGINT. This key restarts counting each year… well, sort of. Read more
All Posts

Contact

My current local time is .

tom@tjmt.uk