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.
open to work · Fort Worth, Texas
AndrewRocha
Marketing Operations & AI Automation Specialist
Meta Ads Lead-Generation System: 856 leads at $4.22 each
- Meta Ads Manager
- Campaign structure and retargeting
- Pixel setup and attribution
- Lead and conversion tracking
- Campaign data QA
- Performance reporting
- Content and asset organization
scroll, it gets louder
01 — the short version
I build the systems behind lead generation, then automate the repetitive half.
Meta Ads, attribution, landing pages and client websites, with the data underneath reconciled against its source. I design the system and hold the judgment; the machine does the volume.
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 documented best practices in an SOP written before the process is handed off.
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.
02 — what I actually use
The sticker wall
Tools I reach for weekly, not a list of things I once opened.
Reporting and marketing ops
- Meta Ads Manager
- Campaign structure and retargeting
- Pixel setup and attribution
- Lead and conversion tracking
- Campaign data QA
- Performance reporting
- Content and asset organization
Web and AI builds
- Landing pages and brand sites
- Cloudflare Pages and Workers
- JavaScript and TypeScript
- Claude Code and custom AI skills
- Multi-model AI review
- SEO and structured data
- Accessibility (WCAG) and browser QA
Data operations
- Data entry
- Data cleaning
- Data validation
- Quality assurance and QA review
- Records management
- Data consolidation
- Spreadsheet hygiene
- Source-of-truth reconciliation
Automation and systems
- Python workflows
- CLI automation and scripting
- AI-assisted workflow automation
- Prompt engineering workflows
- Form-fill automation
- AI output validation
- ETL and data ingestion pipelines
- Process documentation
- SQL — Supabase and PostgreSQL
Platforms
- Microsoft Excel
- Microsoft Office
- Word
- Outlook
- Google Sheets
- Google Workspace
- SaaS dashboards
- Project management tools
- Web/CMS platforms
Work style
- Independent remote work
- Async communication
- Attention to detail
- Confidentiality
- Accuracy under repetition
- English/Spanish translation (professional working proficiency)
03 — the road so far
Work journey
Every stop was accuracy work before it was systems work. That order is the point.
5 stops, oldest first, one page each
-
Mar 2025 – Present
Founder / Marketing Operations & AI Automation
YAHWAYLOVE LLC · Fort Worth, TX / Remote
- Run traffic and attribution for an AI SaaS client with no access to its analytics: tagged outbound links, a weekly sweep, QA and metrics loop, and an approval gate that reads every post back before anything is scheduled
- Build client websites, landing pages and operator hubs, held to automated accessibility, layout and content checks before they ship
- Build AI-assisted automation for complex client projects with Python, CLI tooling and Claude Code, and audit client data: a field-completeness audit of 2,029 CRM contacts, with customer records taken out of version control
-
Apr 2025 – Present
Data & Campaign Operations Support
414 Creative · Remote
- Monitor, clean, and organize Meta Ads performance data across multiple client accounts
- Two-campaign Meta Ads system for a college client, from an account with no pixel: 856 leads at $4.22 each and 127 applications at $28.43 each over 90 days
- Analyze campaign metrics, targeting signals, lead data, and reporting exports to identify inconsistencies and trends before they reach a decision
-
Aug 2024 – Feb 2025
Independent Contractor
Miracle Method / Tub Done Refinishing · Orange, TX & Boca Raton, FL
- Managed contract work independently from intake through completion, including scheduling, materials, job detail, timelines, and quality checks
- Maintained accurate project notes and customer records while working with limited supervision
- Demonstrated reliability, self-direction, and consistency in detail-heavy service work
-
Sep 2023 – Mar 2024
Documentation & Records Specialist
Lake Arenal Real Estate · Nuevo Arenal, Costa Rica
- 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 by translating between English and Spanish for clients and internal teams
-
May 2018 – Apr 2021
Operations / Valet
Corinthian · Marina Del Rey, CA
- Provided high-trust customer service for residents while maintaining 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
where I worked clients served: Northern California · Fort Worth, TX · Orange, TX · Indianapolis, IN · Stuart, FL
Point at or tap a pin to see the stop.
Based in Fort Worth, Texas. Remote only, not relocating. 1 of 5 roles never sat anywhere on a map at all.
04 — things that run
Built, shipped, still running
Each one exists because a manual process was costing real hours.
Traffic & Attribution System
The tracking rig is the invoice
External traffic partner for an AI SaaS product with no access to the client's analytics, ad accounts or billing, so attribution was built in-house: tagged outbound links, a weekly sweep, QA and metrics loop that ranks what worked, and an approval gate that creates every post as a draft and reads it back from the server before anything is scheduled. 285 commits.
- Python
- PowerShell
- Attribution
- Approval gate
Meta Ads Lead-Generation System
856 leads at $4.22 from an account with no pixel
A two-campaign Meta Ads system for a college client: Campaign 1 buys cold attention cheaply with video-first creative, Campaign 2 converts only the people Campaign 1 already warmed up. Over 90 days: 487,000 impressions at $0.47 CPC, 856 leads at $4.22 each, and 127 applications at $28.43 each.
- Meta Ads Manager
- Pixel & retargeting
- Campaign reporting
Client Ministry-Tech Partnership
Their files stay in sync without anyone remembering to sync them
Ongoing client work for a ministry: an AI proxy holding every API key server-side, a Dropbox-to-library autosync watcher on a scheduled task, research and hub packs, and a site remodel. A CRM data-quality audit across 2,029 contacts took customer records out of version control and added a check so they cannot return. 625 commits.
- Node
- Vercel
- Scheduled tasks
- Dropbox API
- Verification gate
Offline-First Pregnancy Journal App
Private by design: no login, data stays on the device
A faith-based pregnancy journal and family keepsake app I own and ship: offline-first, no login, every entry stored on the device in IndexedDB, live on Cloudflare Pages. Includes an OWASP ASVS 5 security review with a tracked remediation plan. 460 commits.
- Hono
- JavaScript
- IndexedDB
- Cloudflare Pages
Document Generation Pipeline
Structured inputs in, a finished 16-page document out
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 an illustrated 16-page PDF. 290 commits and 949 passing tests, because a generator that silently drops an input is worse than no generator.
- Node
- TypeScript
- React
- 949 tests
Automated Job-Search Data Pipeline
A bad run refuses to publish itself
A daily job pipeline: 16 source families scanned into SQLite, run through a hard requirements gate, scored, and rendered into a self-contained dashboard. 315 commits behind three gates — a 451-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
School-Data Vault Platform
A year of records that outlives the system holding them
A complete private archive of a year of coursework: 30 courses and 268 lesson pages, with grades, files, video transcripts and email pulled out of a hosted LMS, normalised, and stored somewhere retrievable. A watcher checks 13 source documents every 30 minutes and flags any change for review instead of applying it. 407 commits, 759 tracked files.
- Python
- TypeScript
- Structured extraction
- Archival integrity
Operations Status Board
A report with no state of its own cannot drift
A status board covering 56 projects and the client engagements at once, rebuilt from source every morning by a scheduled task, so the board cannot disagree with the work. 62 commits, 125 tests.
- Node
- Scheduled tasks
- 125 tests
05 — questions people actually ask
Straight answers
What roles is Andrew Rocha looking for?
Marketing operations and AI automation work — Meta Ads and campaign reporting, attribution, landing pages and client websites, and the automation behind them — plus data operations, records and QA roles where accuracy is the whole job. Contract through YAHWAYLOVE LLC or remote W-2; async and low-meeting.
What marketing results can he show?
A two-campaign Meta Ads system for a college client produced 856 leads at $4.22 each and 127 applications at $28.43 each over 90 days, from an account with no prior advertising and no pixel. He also runs traffic and attribution for an AI SaaS product and builds client websites and landing pages through YAHWAYLOVE LLC.
Is Andrew available for remote work?
Yes — remote is the arrangement, not a preference. He is based in Fort Worth, TX (US Central) and is not relocating, so he works fully remote in an async, low-meeting style, comfortable with distributed teams and written-first communication.
What tools does he use for data work?
Excel and Google Sheets for records and reporting, Python for cleaning, deduplication and validation, and AI-assisted workflows with human QA kept intact. He also builds small automation pipelines and documents the SOP so they run without him.
How does he keep automated work trustworthy?
Every value carries its provenance, anything that writes stays human-in-the-loop, and cleaned data ships with a validation report showing exactly what changed and why. When numbers disagree, the inconsistency is run down to root cause. A result nobody verified is not treated as a result.
Does he work in Spanish?
Yes — English and Spanish (professional working proficiency), including bilingual documentation and translating between clients and internal teams.
06 — say hello
Let's talk
Fort Worth, Texas · remote · async and written-first.
rocha@yahwaylove.com