Systems I traced, repaired, or built — with the evidence left in.
A three-tier ETL that folds four operational systems into one Control Plan report.
| Source | System | Role |
|---|---|---|
| SmartPath | REST API | events |
| Maximo | ERP | assets |
| IPACT | Billing | usage |
| LDAP | Directory | identity |
150,000+ records in ~23 min across DEV / QA / PROD.
A studio of PDF, text, and publishing utilities behind one shared catalog.
| App | Role | Deploy |
|---|---|---|
| studio | hub / catalog | public |
| proofmark-pdf | PDF suite | private |
| text-cleaner | text sanitizer | private |
Pulls nonprofit tech roles across Canada and the US into one filterable place.
| Org | Method | Status |
|---|---|---|
| Wikimedia | Greenhouse | live |
| Khan Academy | Greenhouse | live |
| CodePath | Greenhouse | live |
| Code for America | manual | queued |
| Mozilla | manual | queued |
| CanadaHelps | manual | queued |
| Open North | manual | queued |
| GiveDirectly | manual | queued |
Hourly refresh via a protected ingestion endpoint.
A single reporting cube in MicroStrategy that pulls 78 attributes out of four separate systems and feeds two dashboards — a team timesheet view and a director-facing view — from one shared source.
A Python routine that measures how long each stage of an agent work cycle takes, across events that do not always arrive in order.
The investigation and repair work that found why historical data was missing and wrong, then recovered it — 130,000+ records — and stopped it from happening again.
A rework of how a production reporting job reads a 23-million-row device inventory table on Teradata. The old query recomputed a giant join on every run; the new one computes it once, stores the result, and reads that instead.
A transformation step that reconciles the same fact — a customer name, a product, a ticket number — when four systems each spell it differently, and picks the single best value.
The pipelines and cloud setup that copy a 500-million-row MongoDB collection into BigQuery and prove, row by row, that the copy is correct. Built as code — schemas, extraction jobs, and infrastructure all deploy through CI/CD with no clicking around a cloud console.
A web platform researchers use to explore, simulate, and analyze biological data without writing their own tooling from scratch. React and D3 on the front, R Shiny and Python services behind it, all containerized.
A pipeline that pulls together 750+ TB of cancer data from several public sources, cleans and quality-checks it, and runs machine-learning models to surface candidate biomarkers.
A site that tells you what today is anywhere in the world — the silly days, the real public holidays, and what happened on this date in history. 250 countries, 500+ pages, refreshed on a schedule.
A tool that turns a Markdown résumé into clean, recruiter-software-friendly DOCX and PDF, and can also grade an existing résumé for how well the automated screeners will actually read it.
A system that audits all my repositories once a week — reading commit history and repo state — and writes a dated report, then keeps my tools and config in sync across my Windows and Mac machines automatically.
A pipeline that loads a year of NYC taxi-trip data, then transforms it in clean layers (raw → cleaned → analytics) with dbt, orchestrated by Airflow and packaged in Docker.
A web app for sketching and planning SAS data-integration flows: import an existing flow, lay out the business rules, and plan the scheduling, all visually.
An R package that lets researchers explore microbiome data interactively — profile which organisms are present and compare communities side by side — instead of writing plotting code by hand.
A pipeline that watches data for things that look wrong — using clustering (K-Means, DBSCAN) plus plain rules — and flags them automatically as part of the build.
A free learning platform for cell and molecular biology: interactive tutorials, quizzes, and real pathway simulations you can tweak and watch update live. A free alternative to Cell Collective.
The commercial twin of Signal for Good: the same job-board engine, but its source adapters cover ten different corporate hiring systems, and repeat postings collapse into one.
This website. A field-manual-styled portfolio that ties the story, the proof, and a gated deeper archive together instead of scattering them across disconnected pages.
Smaller builds, experiments, and works in progress.