andrew rocha

Fort Worth, Texas · USA · Central Time · open to work

Andrew
Rocha.

Data Operations & Workflow Automation

I make messy data trustworthy and repetitive work disappear. Get my résumé in your terminal, or ask your agent to fetch it.

01 Work history

Records first. Automation second.

Every job below was accuracy work before it was systems work — that order is the whole point.

$ git log --graph --career

  • (HEAD -> main) Founder · Data Operations & Automation Lead · YAHWAYLOVE LLC a41c9e2Mar 2025 – Present
    • Build repeatable data workflows for client projects, campaign exports, research output and internal records across multiple platforms.
    • Use Python, CLI tooling and AI-assisted workflows to ingest, organize, deduplicate and validate data from exports, dashboards, forms and research sources.
    • Run verification-heavy review workflows with source-aware quality checks, so every record traces back to something that can be re-checked.
    • Design human-in-the-loop review for repetitive form-fill and data-entry work — faster throughput without giving up accuracy or accountability.
    • Build reporting across campaign and platform exports with clean inputs, traceable metrics and source-of-truth validation.
    • Document workflows and SOPs so recurring data tasks run consistently with minimal supervision.
  • Data & Campaign Operations Support · 414 Creative 7b3d180Apr 2025 – Present
    • Monitor, clean and organize Meta Ads performance data across multiple client accounts.
    • Review campaign metrics, targeting signals, lead data and reporting exports to find inconsistencies before they reach a decision.
    • Supported improvements in targeting precision and cost-per-lead within 2–3 months through organized campaign data review and operational support.
    • Reconcile reported metrics against platform data and keep clean records for client-facing updates.
  • Independent Contractor · Miracle Method / Tub Done Refinishing c92f4a7Aug 2024 – Feb 2025
    • Ran contractor work end to end — intake, scheduling, materials, job detail, timelines and quality checks.
    • Kept accurate project notes and customer records while working with limited supervision.
    • Detail-heavy service work where consistency and self-direction were the job.
  • Documentation & Records Specialist · Lake Arenal Real Estate 5e08b63Sep 2023 – Mar 2024
    • Captured, organized and maintained property records, client detail, listing information, media files and supporting documentation.
    • Standardized property data and listing assets so records were easier to retrieve, compare and update.
    • Supported accurate bilingual documentation, translating between English and Spanish for clients and internal teams.
  • Operations · Valet · Corinthian, Marina Del Rey d17a0f5May 2018 – Apr 2021
    • High-trust service for residents with accuracy, organization and accountability in daily vehicle operations.
    • Implemented process improvements that increased parking capacity by 20%.
    • Recognized as Employee of the Month for reliability and consistent service quality.

(init) first commit · learning by shipping 373d1b6

02 Pillars

Three pillars. Every system sits in one.

The same three ideas underneath every workflow below — which is why they survive being handed to someone else.

01

Clean Inputs

Nothing downstream is trusted more than the record it came from. Ingestion, deduplication, validation and reconciliation against a source of truth — with every value traceable back to something that can be re-checked.

  • Define the target
  • Account intelligence crawl
  • Source-of-truth reconciliation
02

Repeatable Systems

Work that runs the same way twice without supervision. Bounded scheduled loops, hard requirement gates, human-in-the-loop review on anything that writes, and an SOP written before the process is handed off.

  • Daily scheduled scan
  • Drafting with a grounding pass
  • Human-in-the-loop form fill
  • SOP documentation
03

Proof It Works

A result nobody verified is not a result. Test suites, offline smoke runs, freshness gates, real-browser verification, and a validation report shipped beside the data as the evidence.

  • Validation reporting
  • Verification harness

03 Workflows

The whole pipeline, stage by stage.

Each one runs today. Expand any of them for what it does and why it is built that way.

$ ls ~/workflows

  • Define the target Clean Inputs grade once, read many

    Grade a vertical once against weighted criteria, cut it into bands, and store the grade as a lookup so later stages read it instead of re-deciding it. Every score cell carries its provenance — measured, derived, recalled or assumed — and an unverified cell is not allowed to disqualify a segment or win the budget.

  • Account intelligence crawl Clean Inputs cheap first, escalate on evidence

    Cheap HTTP for everything, headless browser only where the cheap pass demonstrably failed — and the decision is made on the response body, never the status code. Pages come from the site's own sitemap rather than a blind crawl, and any fact that will be quoted back to a person is verified against the page or visibly quarantined.

  • Source-of-truth reconciliation Clean Inputs catch it before the decision

    Reported figures checked back against platform data, inconsistencies surfaced before they reach a decision, and records left clean enough to hand to a client without a caveat.

  • Daily scheduled scan Repeatable Systems bounded, gated, kill-switched

    16 source families scanned on a bounded daily loop with a kill switch, run through a hard requirements gate before anything is scored. The loop refuses to publish a scan that came back empty, is over six hours stale, or lost more than half its sources — a silent bad run is worse than no run.

  • Drafting with a grounding pass Repeatable Systems corrected, never regenerated

    Drafts are generated, then fact-checked against the underlying record by a second pass that returns literal find-and-replace edits. The document gets corrected rather than rewritten, so it never quietly drifts away from the source it was built from.

  • Human-in-the-loop form fill Repeatable Systems nothing writes unattended

    Repetitive data entry accelerated without surrendering accountability: the system proposes, a person approves, and nothing writes unattended. Speed is bought from the review loop, not from the accuracy.

  • SOP documentation Repeatable Systems written while it is fresh

    The process written down while it is still fresh, so the next run needs no supervision and the knowledge does not live in one head. This is the step that turns a task someone did into a task anyone can run.

  • Validation reporting Proof It Works the report is the deliverable

    Cleaned data ships with a report showing exactly what changed and why. The report is the deliverable — the guarantee is proof rather than a promise, and it is what makes the work checkable by someone who was not there.

  • Verification harness Proof It Works green suites are not enough

    A real browser driven across three viewports, failing the build on accessibility violations, console errors, layout overflow, undersized targets, or a page that rendered nothing. Built because a green test suite had already let real defects through — including a page that scored perfectly while displaying nothing at all.

04 Operating layer

The system that runs the systems.

The through-line under all of it: I design the system and hold the judgment, and the machine does the volume. That is why the same person can run data operations and a video pipeline — in both, the intensive work is automated and my job is the structure, the standards and the gate.

Claude Code + custom skills
My working environment. I author my own skills and workflows there and harden each one against a failing test before it ships, so a process I run once becomes a process anything can run.
Multi-model review
Claude, Codex, Gemini and Grok wired to cross-check each other's work, because one model agreeing with itself is not verification.
Generative media
Higgsfield and Midjourney for AI video and image production, and text-to-speech where narration is needed — volume without a shoot.
Clip pipeline
GPU Whisper transcription and captioning through a tuned OpenShorts build, scheduled out via Postiz, with a person approving every post.
Automation plumbing
Python and CLI glue, MCP servers, and a Cloudflare Worker fronting a model API so the AI half runs as infrastructure rather than as a browser tab.
Verification
Playwright and axe gates, offline smoke runs and pytest suites. AI writing more of the work is only safe if the checking got stronger at the same time.

05 Projects

Built to run daily, not to demo.

Working systems I own end to end — each one exists because a manual process was costing me hours.

$ ls -la ~/projects

  • School-Data Vault Platform /R · Data Operations drwxr-xr-xPython

    A complete private archive of a year of coursework, built so the data survives losing access to the system it came from: every course, lesson, grade, file, video transcript and email pulled out of a hosted LMS, normalised, and stored somewhere retrievable. 127 commits, 648 tracked files. This is records management as a migration problem — get it all, keep it faithful to the source, and make it findable afterwards.

    • Python
    • TypeScript
    • Structured extraction
    • Archival integrity
  • Client Ministry-Tech Partnership /S · Data Operations & Automation drwxr-xr-xNode

    Ongoing client work across five deliverables: an AI proxy holding every API key server-side, a Dropbox-to-library autosync watcher running on a scheduled task, research and hub packs, and a site remodel. Ships behind a definition-of-done gate that has to pass before anything is called finished. 141 commits, 439 tracked files.

    • Node
    • Vercel
    • Scheduled tasks
    • Dropbox API
    • Verification gate
  • Document Generation Pipeline /D · Pipeline / Document Generation drwxr-xr-xNode

    A document pipeline that takes structured inputs — a person's details, written testimony, source references and authorised context from an existing database and document corpus — and assembles a 14-page output from them. 87 commits and 56 test files, because a generator that silently drops an input is worse than no generator.

    • Node
    • TypeScript
    • React
    • 56 test files
  • Automated Job-Search Data Pipeline /F · Data Operations drwxr-xr-xPython

    A daily job pipeline: 16 source families scanned into SQLite, run through a hard requirements gate, scored, and rendered into a self-contained dashboard. 250 commits behind three gates — a 410-test pytest suite, an offline pipeline smoke run, and a real-browser harness across three viewports that exits non-zero on accessibility violations, console errors, layout overflow, or a dead interaction.

    • Python
    • SQLite
    • pytest
    • Cloudflare Workers
    • Playwright
  • Widget & Embed Platform /D · Platform / Front-end drwxr-xr-xNode

    A private, single-user widget platform: a password-gated builder plus a public embed runtime, so a marketing site can add a form, gallery or counter without an Elfsight subscription or a third-party CDN in the finished product. 35 commits and 45 test files; the embed ships as self-contained output because an embed that phones home is a dependency nobody audited.

    • Node
    • TypeScript
    • Embed runtime
    • 45 test files
  • Spreadsheet Cleanup & Validation Service /C · Data Operations drwxr-xr-xPython

    A productized spreadsheet-rescue service: messy client data in, cleaned and deduplicated data out, plus a validation report showing exactly what changed and why. The report is the deliverable - the guarantee is proof, not a promise.

    • Python
    • Excel
    • Google Sheets
    • validation reporting
  • Automated Browser QA Gate /V · Verification drwxr-xr-xNode

    A verification gate that made a green test suite mean something. Drives a real browser at three viewports and fails the build on accessibility violations, console errors, sideways scroll, undersized tap targets, or a page that rendered nothing - the last one because an empty page used to score perfectly.

    • Node
    • Playwright
    • axe-core

06 Skills

The stack I run, and what I do all day.

data operations
Data entry · data cleaning · validation · QA review · records management · data consolidation · spreadsheet hygiene · source-of-truth reconciliation
automation
Python workflows · CLI automation · AI-assisted workflow automation · form-fill automation · AI output validation · process documentation · Supabase
reporting
Meta Ads Manager · campaign data QA · performance reporting · lead and conversion tracking · asset organization
platforms
Microsoft Excel · Google Sheets · Google Workspace · SaaS dashboards · project management tools · web/CMS platforms
work style
Independent remote work · async communication · confidentiality · accuracy under repetition · English/Spanish translation (fluent)

07 Education

Credentials.

  • Associate of Applied Biblical Studies — Year 1 completed Lifestyle Christianity University · 2025–2026
  • High School Diploma Flagler High School · Pompano Beach, FL
  • Leadership Certificate Gratitude Training · West Palm Beach, FL