Technical

Systems, pipelines, and analytical tooling.

Alongside housing research, I build the technical layer behind the work: ingestion pipelines, monitoring dashboards, geospatial workflows, automation, and data products designed to make analysis operational.

Research Infrastructure

Current Systems Work

Centralised compliance monitoring dashboard visual

Current Systems Work

Centralised Compliance Monitoring Dashboard

A portfolio-wide monitoring layer that consolidated fragmented compliance signals into a single operational system.

Shows production-style dashboard design, scheduled data checks, and analytical systems built for live operations.

SQLBigQueryHexGoogle Sheets Sync
Open Case
License plate recognition dashboard visual

Current Systems Work

License Plate Recognition Verification Dashboard

An anomaly-detection workflow for estate vehicle access records, including OCR-aware matching and repeat-visitor analysis.

Shows applied analytics, fuzzy matching, operational investigation design, and interface thinking under noisy data conditions.

SQLPythonHexOCR Matching
Open Case
Operational checklist extension visual

Current Systems Work

Operational Checklist Chrome Extension

A lightweight browser extension that made field data capture faster while staying compatible with existing reporting workflows.

Shows pragmatic systems design: improve throughput and reliability without forcing teams to adopt a totally new stack.

JavaScriptGoogle SheetsAutomation
Open Case
Automated HDB trends reporting dashboard

Current Systems Work

Automated HDB Trends Reporting

A monthly reporting pipeline combining HDB transaction data, town-level geography, and language generation to reduce reporting overhead.

Shows how I approach automation as analytical infrastructure rather than just scripting for convenience.

PythonSQLHexOpenAI
Open Case

Legacy Systems and Pipelines

Technical Case Studies

Automated client reporting workflow and recurring market report output

Technical Case Study

Automated Client Reporting System

A data pipeline designed to generate recurring market and operational reports using automated workflows.

Reduced manual reporting work while improving consistency and timeliness of client insights.

PythonSQLDashboard Systems
Open Case
Executive dashboard suite for market and performance monitoring

Technical Case Study

Executive Market Intelligence Dashboards

A suite of real-time dashboards designed for leadership to monitor housing market conditions and internal performance signals.

Enabled leadership teams to track market conditions and internal performance through continuously updated analytical dashboards.

SQLBI ToolsAutomation
Open Case
Screenshot of a Raspberry Pi-based home SQL server setup

Technical Case Study

Home SQL Server for Sensor Inputs

A Raspberry Pi-based MariaDB setup used to receive sensor data and support end-to-end experimental data collection without relying on hosted infrastructure.

Created a small self-hosted database environment that could accept live sensor inputs and support downstream analysis projects.

MariaDBRaspberry PiApachePHPphpMyAdmin
Open Case
Screenshot of a daily stock data ingestion and enrichment workflow

Technical Case Study

Daily Stock Data Ingestion Pipeline

A scripted workflow that scraped daily market data, joined supporting financial datasets, computed valuation-oriented features, and wrote the results back to SQL for dashboard use.

Built a repeatable daily ingestion workflow that turned scraped market data into structured SQL tables for downstream analysis and dashboards.

RSQLWeb ScrapingYahoo FinancePower BI
Open Case
Photo of environmental sensor hardware used for an ML experiment

Technical Case Study

Environmental Sensor and ML Experiment

An end-to-end experiment that collected temperature and humidity data from sensors, stored it in SQL, and tested whether machine learning could reduce air-conditioning usage.

Built a full workflow from sensor hardware to analysis, showing how environmental data could support more efficient air-conditioning decisions.

RSQLPower BIArduinoStatistical Testing
Open Case
Screenshot of a live feedback pipeline ingesting Google Form data into SQL

Technical Case Study

Live Feedback Pipeline From Google Forms to SQL

An ingestion workflow that moved Google Form responses into SQL on a schedule so Power BI dashboards could refresh close to real time without paid middleware.

Created a practical low-cost pipeline that kept customer-feedback dashboards updated within minutes of submission.

RGoogle SheetsGoogle FormsSQL ServerPower BI
Open Case
Screenshot of a sensor uptime monitoring dashboard

Technical Case Study

Sensor Uptime Monitoring Dashboard

A monitoring dashboard built to detect sensor dropouts, latency issues, and abnormal posting intervals across multiple devices sending data into SQL.

Made it easier to identify failing or lagging sensors quickly instead of discovering data problems only after downstream analysis broke.

Power BISQLArduinoDirectQuery
Open Case