Key facts
| Organisation | East London Health and Care Partnership (NHS and local government partnership) |
|---|---|
| Role | Data and Analytics Consultant |
| Dates | June 2020 to September 2020 (4 months) |
| Type | Contract |
| Status | To confirm — old CV names it East of London Health Partnership. |
| Knowledge base | Personal\CV\kb\employment\2020-06-elhcp.yaml |
Summary
A four month engagement at the height of Covid. Built the data and analytics solution that used primary care observation data to identify patients vulnerable to Covid-19 across east London.
Achievements
- Developed an SSIS ETL process extracting 2 billion primary care observations and applying the Quality and Outcomes Framework ruleset to build a Kimball data warehouse of patient outcome registers.
- Designed and built a data and analytics solution using patient observation data to build Power BI reports identifying patients vulnerable to Covid-19.
- Developed a SQL Server Analysis Services Tabular model.
- Developed DAX measures implementing the business rules of the Quality and Outcomes Framework ruleset.
- Developed Power BI reports using live connection to SQL Server Analysis Services.
Technologies
SSIS, SQL Server, SSAS Tabular, DAX, Power BI.
Open questions
Organisation name differs between sources (old CV says East of London Health Partnership; LinkedIn says East London Health and Care Partnership). LinkedIn used.
Sources
The old CV (CV-MD-02.docx) and the LinkedIn experience capture of 5 October 2026. Relevance ratings agreed with Matthew, 8 October 2026.