Selected work

Case studies

Seven systems, written up honestly. Each one ends with what I’d do differently, because a portfolio that only contains wins isn’t telling you anything you can use.

Healthcare · 2025–2026

An offline automation ecosystem for a US diagnostics provider

12+ interconnected workflows covering patient intake, clinical report processing, billing reconciliation and delivery — built as a personal initiative with no mandate and no budget, adopted as company standard.

60–75% processing time reduction

Healthcare · 2026

Operational visibility for a three-week rolling cadence

A tracking system for an operation where three patient cohorts are always in flight at once, built to survive the messiness of real archive data rather than assume it away.

Zero patient rows stored

ERP · Manufacturing

Recovering three months of unrecoverable ERP data

A ransomware attack wiped a quarter of a client's inventory and billing records. I recovered them from an untouched BI server with MAQL, SQL, and ADVPL.

100% of records recovered

ERP · Quality assurance

Building an ISO-certified quality process into an ERP

A client's lab was certified under ISO and ICONTEC. The ERP's quality module couldn't reproduce its tests, so I mapped the real process and built the gap in ADVPL.

Certified process, not an approximation

ERP · Food manufacturing

Finding the bad number in a meat processor’s production costs

Production costs drifted away from what the plant floor knew to be true, with no report to say why. I traced the calculation across 9+ stock tables and 3 modules and rebuilt it from the database up.

Cost-data integrity restored

ERP · Food manufacturing

Fitting a bakery shop floor into a standard ERP, stage by stage

Six production zones needed what an MES gives, inside a standard ERP scope. I mapped them into four TOTVS Protheus modules, from discovery to integrated testing.

An MES-shaped need, met without an MES

ERP · Plastics manufacturing

Diagnosing a failed ERP–MES integration from a vague error

A dozen-plus work orders stopped integrating between ERP and MES, and the log said only “field mismatch.” I compared the rejected records against the ones that went through.

Root cause found, fixed the same day