← Home

Selected work

Everything I’ve shipped.

Case studies and live demos, all built solo. Filter by focus. Each card opens the full story or the working build.

Also built

Scanned forms into a 33-column spreadsheet at $0.002 per page

A dental clinic’s intake forms arrived as scanned PDFs, hand-keyed into spreadsheets one field at a time. I built a vision-AI pipeline instead: a strict 33-column schema first, then extraction against it, deduped by file hash and page number so re-runs are always safe. Zero manual re-keying, at roughly $0.002 per page in AI cost, about $2 per thousand pages. The schema is swappable, so the same pipeline retargets to any form type without a rebuild.

Role: scoping + schema design + build · Stack: Python, GPT-4o-mini vision, Google Drive + Sheets · Type: data pipeline

raph@raphaelmercado.devlinkedin.com/in/raphmercadogithub.com/raphaelmercado-coder