# Robson Poffo

> Senior Product Manager · AI & Data Platforms on Google Cloud (BigQuery, Dataflow) · Agentic AI · Platform Strategy & Cloud Economics

Personal portfolio of Robson Poffo. For structured, up-to-date data, connect to the MCP server (Streamable HTTP, no auth; read-only apart from a send_message tool for contacting Robson Poffo): https://mcp.poffo.me/public/robsonpoffo

## Agents

- [MCP server](https://mcp.poffo.me/public/robsonpoffo): profile, projects, experience, education, skills, search
- [Connect your agent](https://poffo.me/agents): setup for Claude and other MCP clients

## Pages

- [About](https://poffo.me/about): background, skills, work and education timeline
- [Projects](https://poffo.me/projects): case studies
- [Contact](https://poffo.me/contact)

## Projects

- [mySaldoa](https://poffo.me/projects/mysaldoa): My take on Microsoft Money, rebuilt for today: personal finance with honest multi-currency net worth from exchange rates synced daily, a modern interface, and AI that sets up accounts from plain words and reads bills from email.
- [Sheet Music Studio](https://poffo.me/projects/sheet-music-studio): Built to help my 12-year-old find sheet music he couldn't get anywhere: upload a recording, pick one of 22 instruments, and an AI pipeline writes the score at three difficulty levels — with synced playback and PDF / MusicXML / MIDI export.
- [Upwise (Family Growth)](https://poffo.me/projects/upwise): A family app that turns everyday responsibilities into measurable independence — chores, allowance, habits and reflection, with an AI coach for parents and kids.
- [HomeSturdy](https://poffo.me/projects/homesturdy): A home-maintenance app that turns everything a house needs into an auto-generated, remind-me-only-when-due plan — live on iOS and web, backed by an Express/Postgres API on Cloud Run.
- [Smart Keyboard](https://poffo.me/projects/smart-keyboard): A text optimizer that helps you catch spelling errors and redundancies before sending important messages — not a keyboard replacement, but a focused tool for clearer communication.
- [Memory-Optimized Query Engine](https://poffo.me/projects/memory-optimized-query-engine): An in-memory serving layer in front of BigQuery that gives dashboards sub-second latency while sharply cutting BigQuery slot cost — Looker Studio reads from it instead of hitting BigQuery directly.
- [Data & AI Platform](https://poffo.me/projects/data-ai-platform): A multi-tenant Big Data & AI platform (serving thousands of companies) that ingests, transforms, and serves data through analytics, Insights, and Smart Apps. I led its SQL-first engine migration — ~70% lower platform cost, 16× faster.
- [Portfolio System](https://poffo.me/projects/portfolio-system): This site — a Next.js app on Firebase with a CMS-style admin, image uploads, and a Claude-powered writing assistant. A living portfolio I fully own and edit in place.
- [TOTVS Clock In](https://poffo.me/projects/facial-recognition-app): A 0→1, offline-first face-recognition time clock I took from concept to production in under four months — now serving hundreds of thousands of workers daily, protected by a granted U.S. patent.
- [Data Connect (JDBC)](https://poffo.me/projects/data-connect-jdbc): A Change Data Capture (CDC) tool that ingests data from virtually any source — JDBC databases, MongoDB, and files — into the Data & AI Platform, online or in batch.
- [Parse SQL](https://poffo.me/projects/parse-sql): A paste-and-go web app: drop in SQL and instantly get a pretty-printed version, an interactive AST view, and a checklist of query-optimization warnings across a dozen dialects.
- [Batch Ingestion by SQL](https://poffo.me/projects/batch-ingestion-sql): A batch pipeline that loads ERP data from a Google Cloud Storage folder into the Carol data platform — auto-discovering what to load and generating the BigQuery SQL from a single tenant id.
- [Warranty Tracker (mobile)](https://poffo.me/projects/warranty-tracker-mobile): Built an app that organizes receipts and warranties in one place, using AI to make it easy to track what you own and when coverage expires.
- [AI Agile Assistant for Jira](https://poffo.me/projects/ai-agile-assistant-for-jira): A Jira Cloud app that makes daily standups faster and sharper — an AI assistant that times the meeting, surfaces what changed since yesterday, and flags risks and blockers, reporting up to a 40% cut in daily meeting time.
- [Billing](https://poffo.me/projects/billing): A scalable billing system that computes cost across cloud providers and splits it among tenants via custom rules — plus automated actions that actively reduce cloud spend.
- [Data Sync (Reverse ETL)](https://poffo.me/projects/data-sync): Reverse ETL that lets SQL pipelines sync data into transactional databases — for applications that need a transactional store for scalability, performance, or transactions.
- [Cost Reduction](https://poffo.me/projects/cost-reduction): A cross-cutting program to cut data-platform cost across storage, ingestion, and processing — driven by architecture reviews and impact-vs-effort prioritization, reducing spend by millions without compromising performance.
- [Alexa Batman](https://poffo.me/projects/alexa-batman): An Amazon Alexa skill that answers any question using generative AI, with kid-safe guardrails on every response.
- [Voice to Text for WhatsApp](https://poffo.me/projects/voice-to-text-for-whatsapp): A WhatsApp bot that transcribes voice messages on demand — forward an audio to a specific number, get back a readable transcript instantly. Built solo, in my own time, with multi-language support so it works across different audiences.
- [TrelloDash](https://poffo.me/projects/trellodash): A Trello analytics tool that turns boards into actionable metrics — idea to MVP in five months, grown to 500+ users, with a companion Alexa skill.
