robson poffo

Work

Projects

A selection of recent work — products, side projects, and experiments.

Data Platform8

Low-latency insights architecture — Arrow/DuckDB in-memory layer serving Looker Studio in front of BigQuery

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.

DuckDBBigQueryLooker StudioQuery Optimization
Data & AI Platform — sources flow into a central platform and out to analytics, insights, and smart apps

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.

BigQueryDataflowCloud RunData Platform

TOTVS Clock In

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.

Facial RecognitionMachine LearningOffline-firstiOS
Data Connect — JDBC and MongoDB databases synced into the data platform via CDC

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.

SQLDatabasesNoSQLCDC
Batch ingestion — files from a GCS folder loaded via a single SQL read into BigQuery

Batch Ingestion by 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.

BigQueryGoogle Cloud StoragePythonSQL
Billing — cloud provider costs aggregated and split across tenants

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.

BillingMulti-tenantCloud CostsCost Optimization
Data Sync — reverse ETL from the analytical store back to transactional databases

Data Sync (Reverse ETL)

Reverse ETL that lets SQL pipelines sync data into transactional databases — for applications that need a transactional store for scalability, performance, or transactions.

Reverse ETLSQLData SynchronizationTransactional Databases
Cost reduction — descending cost bars with a downward savings trend

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.

Cost OptimizationCloud CostsStorageData Processing

Personal Initiatives12

mySaldoa Home — net worth, safe to spend, the next 30 days of bills, bills from email and an account summary in several currencies

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.

Personal FinanceMulti-currencyAIAnthropic Claude
Sheet Music Studio score view — a piano transcription with difficulty levels, transpose, confidence insights (key, tempo, meter), a playing keyboard and the player

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.

AIMachine LearningAudioMusic Transcription
Upwise — an autonomy ladder from Guided to Mastered, then off the list

Upwise (Family Growth)

A family app that turns everyday responsibilities into measurable independence — chores, allowance, habits and reflection, with an AI coach for parents and kids.

NestJSPostgreSQLNext.jsReact Native
HomeSturdy — every home task, one calm plan

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.

React NativeExpoTypeScriptNode.js
Smart Keyboard — an iOS keyboard with writing-style shortcuts

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.

Google Cloud RunPythoniOSApple
Portfolio System — a browser window of poffo.me with a CMS editing spark

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.

Next.jsReactTypeScriptFirebase
Parse SQL — SQL parsed into an abstract syntax tree across 12 dialects

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.

SQLPythonFastAPIsqlglot
Warranty & Receipt Tracker — every warranty at a glance

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.

Google Cloud StorageiOSAppleCloud Run
AI Agile Assistant — daily progress board with AI insights, risks, and suggested actions

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.

AIJiraAtlassianScrum
An Alexa-style smart speaker with a glowing light ring and a bat-signal above it

Alexa Batman

An Amazon Alexa skill that answers any question using generative AI, with kid-safe guardrails on every response.

AlexaVoice AssistantGenerative AILLM

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.

Speech to TextPythonGoogle Cloud FunctionsGoogle Cloud Storage
TrelloDash — Trello boards turned into analytics metrics

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.

Node.jsMongoDBTrello APIAlexa