Client and private-product names remain closed. The system, operating constraint,
technology, and relevant public evidence remain visible.
Systematic investing
Multi-agent research system for systematic investing
A coordinator drives tiers of local and cloud models to propose and stress-test
trading strategies; a fixed statistical evaluation battery — permutation testing,
deflated Sharpe, regime stratification, bootstrap drawdown tails — decides what
survives. Every candidate runs in an isolated worktree, so hundreds of experiments
can run without contaminating each other.
PythonSQLitellama.cpp + LiteLLMgit-worktree isolation
White paper →
Legacy migration
Fitness-studio management platform → PWA
A low-code-generated application carrying years of accumulated business rules,
rebuilt as a progressive web app on .NET while its SQL Server 2019 back end stays
live. Schema changes go through reviewed migrations, not through a designer.
Blazor WebAssembly.NET 10MS SQL Server 2019PWA
Related case →
Legacy migration
Project-billing and underbilling dashboard → PWA
A second rescue off a different low-code generator, this one under a hard
constraint: the database schema could not be touched at all. The new front end had
to fit the existing model exactly rather than negotiate with it.
Blazor WebAssembly.NET 10MS SQL Serverread-only schema
Related case →
API integration
Fleet document & form-submission pipeline
Pulling documents and form submissions out of a third-party fleet-operations API
into an operational database, with the ingestion diagnostics to explain why any given
record did not arrive. Credentials are read at runtime from a controlled table —
never compiled into source, never committed.
REST API ingestionT-SQLSQL Serveringestion diagnostics
Related case →
Replacement build
Timesheet & invoicing platform
A twenty-year-old Access application replaced by a web app that reads the same
live SQL Server database the old one still uses — so both run against the same data
during the transition and the business never stops billing. Cutover by choice, not
by big-bang.
NodeTypeScriptFastifyshared MS SQL Server
Related case →
Compliance systems
Employee training & competency tracking
Required classes per job role, actual training records, competency matrices and
audit reports. The interesting part is the source control: every form, report, query
and module is exported to text, so a thirty-year-old desktop database gets real
diffs and real code review.
MS AccessVBAtext-export source of truth
Developer tooling
Version-control gateway for Access applications
The generalisation of that idea: tooling that takes an Access application apart
into reviewable text, drives it through git, and puts it back together — so a whole
category of business-critical software that has never been under version control
finally can be.
Access object modelgitCLI + UI
Consumer platform
Cross-platform fandom & community platform
A safety-first social product built as a monorepo across web and every Apple and
Android surface that matters — phone, tablet, watch, TV, and headset — off one shared
schema and one shared package layer.
Next.jsPrismaSupabaseiOS / Android / visionOS / tvOS / watchOS
Legacy migration
Equipment sales & configuration tool
A PHP and JavaScript MVVM application recovered off a live server with no clean
source history — competing directory copies, stale backups, and a hundred-line diff
between two versions both claiming to be current. Establishing what the real source
was came before any modernisation could start.
PHPJavaScript MVVMsource archaeology
Related case →
AI infrastructure
AI platform — gateway, inference, fleet
One conduit every model request in the ecosystem flows through. A control plane
that decides which model answers under what budget, a data plane that executes the
tokens, and a resource plane that schedules the GPUs underneath. Consumers ask for a
capability; they never name a machine or a provider — so local and commercial tiers
are a routing decision, not an architecture. Underneath it, cross-project
vector-backed retrieval: context digested once into a typed, queryable store rather
than re-read from raw text every session.
LiteLLM gatewayllama.cppGPU lease schedulervector retrieval
The hardware →
AI infrastructure
Local-first coding harness
An interactive coding environment pointed at self-hosted models instead of a
vendor endpoint, with review gates, completeness guards and write guards wired into
the loop — the harness that decides whether a model's claim of "done" is true.
WSLSSH tunnellingmodel routingguard extensions
Engineering method →
Web
Two production sites on Cloudflare
This site and the firm's. Static-generated, edge-hosted, with a retrieval
assistant grounded on my own published writing and a contact path that runs through
my own Worker — bot protection and delivery included, and not one byte routed through
a marketing stack.
AstroCloudflare PagesWorkersRAG over a private corpus
Ask Andy →