Lab Book · Build Notes

Build Notes

Selected systems that show how I build when the work has to ship.

Enterprise Systems
01Live

Enterprise Analytics Platform

Bell Canada

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.

Went wrong: Schema-first, or rename forever

MicroStrategySQLData Modeling
02Live

Duration Calculation Engine

Bell Canada

A Python routine that measures how long each stage of an agent work cycle takes, across events that do not always arrive in order.

Went wrong: Events out of order

PythonPandasAlgorithm Design
03Live

Data Quality Recovery System

Bell Canada

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.

Went wrong: The 30-day blind spot

SQLData QualityRoot Cause Analysis
04Live

Query Optimization Framework

Bell Canada

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.

Went wrong: The whale join

SQLPerformance TuningData Modeling
05Live

Data Consolidation Layer

Bell Canada

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.

SQLData IntegrationETL
06Private

MongoDB → BigQuery Migration

Bell Canada

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.

Went wrong: The silent NULLs

GCPBigQueryMongoDB
Research Platforms
01Private

Bioinformatics Platform

Johns Hopkins University

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.

Went wrong: Slow enough to abandon

ReactD3.jsR Shiny
02Private

Multi-Omics Data Pipeline

Johns Hopkins University

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.

PythonRSpark
Independent Builds
01Live

Resume Foundry

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.

Went wrong: Light text on a light page

PythonFastAPIDocument Generation
Live app
02Live

dev-meta

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.

Went wrong: A hook vanished mid-run

AutomationGitClaude Code
03Live

NYC Taxi ELT

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.

dbtAirflowDocker
Repository
04Live

Sasafrass

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.

ReactTypeScriptSAS DI
RepositoryLive app
05Live

Microbiome Explorer

An R package that lets researchers explore microbiome data interactively (profile which organisms are present, compare communities side by side) instead of writing plotting code by hand.

RShinyBioinformatics
Repository
06Live

Anomaly Detection System

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.

PythonScikit-learnTensorFlow
Repository
07Private

OSSC · Cell Biology Simulation Platform

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.

RShinyPython
Docs
08Live

Signal for Good

A job board that gathers technology roles at nonprofits into one searchable place, pulling live listings automatically and being honest about which sources are still manual.

Went wrong: Honest about the gaps

Next.jsTypeScriptPostgres
Live app
09Live

Signal for Profit

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.

Next.jsTypeScriptPostgres
Live app
10Live

Portfolio Website

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.

Next.jsReactCSS
Live app
On the bench

Smaller builds, experiments, and works in progress.

Sabbir Hossain · Build NotesPage 03