Work

Operations and automation specialist

Business systems, reporting and workflow automation.

I find where the work actually breaks, then build the automation and the written process so it stays fixed. Most recently I was on the operations team for Mosaic's retail field-sales program for Google's Pixel NAMER division, working with four teams across the US, Canada and Mexico. Bilingual in English and Spanish.

8
Production automations at Mosaic
250+
Hours a year returned to the team
46% → 62%
Fulfillment profitability in three months

Case studies

Problem, root cause, build, outcome

The full trace behind each number.

At Mosaic

Eight production automations

Built in Google Apps Script, Python and BigQuery. Each one writes raw data only and leaves the math in visible formulas, so a non-technical reviewer can audit any number by clicking the cell. Every one shipped with an SOP, and I trained the team on them before I left.

  1. 01

    Mexico promoter-deck pipeline

    ~90% less slide work

    About 10 Apps Script modules, built from zero in one week, that cut manual slide maintenance about 90% for the 172-store Red Zone pilot and its BigQuery-fed 5-slide executive deck.

  2. 02

    Sales and inventory automation suite

    2+ hrs a week

    Aggregation, daily channel sales and validation jobs that replaced 2+ hours of weekly manual consolidation, built so the team could own and run it.

  3. 03

    Master Sellout ingest

    Turns the weekly sell-out report into per-store line items, with merge logic that never lets an out-of-order ingest overwrite prior data.

  4. 04

    Expense reconciliation (US + Canada)

    30 min a week

    Pulls weekly carrier-card transactions, enriches each row against the field roster, and runs a row-level approval workflow. It removed about 30 minutes a week of manual work along with the whole class of reconciliation errors.

  5. 05

    Red Zone Tracker (Python)

    172 stores

    Joins the master store list, field visits, weekly sell-out and the field schedule to track 6 KPIs per retail chain across 172 stores.

  6. 06

    Field-rep lifecycle and access

    ~60% faster

    Onboarding, leave, return and offboarding for 125+ reps in three countries, cutting onboarding time about 60%, plus reconciliation of 200+ distribution lists.

  7. 07

    Weekly executive reporting

    Under 5 min

    Pulls from 6+ sources and, in under 5 minutes, generates the 11-slide leadership deck that used to take 3+ hours to build by hand.

  8. 08

    BigQuery-to-Sheets live pipeline

    Scheduled incremental refreshes, automatic retries and anomaly alerts, so field managers work from current data instead of day-old snapshots.

Earlier builds

More automation work

Independent builds

Products I built and run on my own time.

Background

Where the root-cause habit started →

A decade of bodywork and health coaching. The pain a client pointed to was often not where the problem started.