Skip to content

Selected projects · 2021—Present

Four projects. One focus on usable data.

Selected projects across business intelligence, data integration and analytical modelling in commercial and public-sector environments.

01

Data engineering, architecture and historical modelling

Public Health Register Data Platform

Designed scalable dimensional models for case history, clinical requests, operational activities and correspondence on a national public-health register.

Snowflake · dbt · SQL · Power BI · GitLab

Open case study

02

Data architecture, entity design and public-health analytics

Disease Surveillance Data Modelling

Classified questionnaire fields across five disease groups and designed shared facts, dimensions and bridge tables for consistent surveillance reporting.

Salesforce · SQL · Snowflake · ERD design · Dimensional modelling

Open case study

03

Enterprise integration, reconciliation and optimisation

Enterprise Supplier Data Reconciliation

Built reusable integration and reconciliation models across supplier, contract, claims and payment data, while optimising a 240-million-record pipeline.

Snowflake · dbt · SQL · Python · Apache Airflow · GitLab

Open case study

04

Business intelligence and inventory

Supply Chain Visibility and Inventory

Integrated Microsoft Dynamics and international warehouse data into a Power BI reporting suite for stock visibility, inventory planning and stockout forecasting.

Power BI · DAX · Power Query · Microsoft Dynamics

Open case study