Milan Shaji

I wanted to use data to improve services where I live, so I asked where the Gold Coast should start investigating road safety. I built a reproducible study of 8,142 casualty crashes from 2020–2024: Python and SQL, a 500 m spatial grid, a BigQuery spatial check, a Power BI report on a star schema with DAX measures, and a public map dashboard.

The top 20 squares cover 0.35% of the city but held 55 of the 695 serious crashes in held-out 2024, about 23 times their share by area. DBSCAN clustering caught 54, so the simpler count method stays. Fourteen of those 20 squares are mostly on state-controlled roads, mainly the Pacific Motorway, which TMR manages rather than the City. Ranking council roads separately gives the City its own list: it caught 40 of 384 serious crashes on council roads in 2024, against 24 for the combined list. Without traffic volumes, the counts can't measure risk per trip. The dashboard links to the methods, source code and reproducible data release.

python · sql · geopandas · dbscan · duckdb · bigquery · power bi · dax · leaflet · mcp

A self-hosted market terminal that screens roughly 1,550 US stocks and the top 50 crypto every 60 seconds, aggregating six free no-key data sources into a transparent 1–5 rating and concrete entry-timing engine. Every score decomposes into the trend, momentum, quality, valuation and risk inputs that produced it. Node.js and vanilla JavaScript, one runtime dependency, no build step, installable to a phone home screen.

What matters is whether the score survives contact with reality. Backtesting and forward paper-trading engines (60 automated tests, test-driven, with look-ahead-bias guards) replay the signals against ten years of history and a live S&P 500 benchmark. Building that harness surfaced three separate bugs that had inflated returns by thirty-plus points: survivorship bias, a hindsight-selected universe, and stale entry pricing. The corrected result is reported in the app itself, on screen rather than buried: the signal set underperformed simply buying and holding the index.

node.js · vanilla js · express · finnhub · fred · tradingview · github

An AI market analyst for Australia's electricity grid. Spot prices idle for days, then blow past $300/MWh with little warning. Dispatch ingests over a million rows of 5-minute AEMO price and demand data into a DuckDB pipeline gated by 44 automated tests, refreshed daily.

A gradient-boosted early-warning model flags likely spike days, benchmarked with rolling-origin backtests. An LLM analyst writes the daily briefing: 21–25 cited figures, each re-verified against source data before the brief may publish. Runs unattended every morning on GitHub Actions behind a public Streamlit dashboard.

python · duckdb · gradient boosting · claude api · github actions · streamlit

Hand-tracked generative visuals in TouchDesigner, directed in plain English. MediaPipe webcam tracking drives visuals composited over the live camera feed: a shape rides the thumb–index pinch point, scales with hand aperture, and hides the moment tracking drops. The node network is generated from reproducible Python rather than wired by hand.

A language layer directs the scene, but nothing a model says touches the render unchecked: every Claude response passes a strict JSON parameter contract, schema-validated field by field and rejected on any violation. That's Dispatch's verification discipline, applied to a system with no database to check against.

python · touchdesigner · mediapipe · claude api · pytest

A real-time hand-tracked video effect, built after a filter trend went around social media. Three corner-pinned quads (one per finger-pair across both hands) mask a live-filtered copy of the camera feed, so moving your hands reshapes where each effect appears.

Two failure modes drove the build. Effects that displace pixels can leak outside their intended shape, so each copy is filtered before masking rather than after. And losing tracking mid-effect can corrupt the whole render, so every region is gated to disappear cleanly when a hand leaves the frame.

touchdesigner · mediapipe · real-time compositing