Skip to content

Projects

Projects & Case Studies

Production systems solving concrete business problems.

Flagship case

AppTech — Plataforma de Gestão

A satellite platform unifying sales, receivables, tax, legal and HR for a construction company.

processes in the historical pipeline
~2,7M
permission-controlled modules
13
incremental ETL pipelines
20+
Full-StackData ScienceAutomation
Read the full case
Fig. 01 — Data flow 12 nodes · 11 edges
UAU (SQL Server) TOTVS RM over VPN Spreadsheets Court databases public + one paid Incremental ETL watermark + natural-key UPSERT Enrichment rate limit + cost ceiling PostgreSQL Flask API 13 modules React SPA WhatsApp PDF / XML ERP filings queue with heartbeat
Source External Process Store Application Output

More than twenty incremental pipelines consolidate the source systems into Postgres; on top of it, thirteen modules and the outputs operations actually use — including legal filings back into the ERP. Payroll comes in over a VPN, opened only during extraction. Drawing a single Postgres is a simplification: it stands for AppTech’s own database plus the legal database it reads and enriches.

# System Metric
02 Pandora — Agente de Operações do ERP An agent orchestrator that operates the ERP — and, where money is involved, asks before it signs. Applied AIAutomationData ScienceFull-Stack 8 min 2026 03 Monitor Judicial — Plataforma Multi-cliente Reads the official gazettes of 91 courts every night and delivers to each client only what is theirs — as a PDF, shielded against false positives. AutomationData ScienceFull-Stack 1,1 mi+ 2026 04 ai-memory — Segundo Cérebro (RAG) A persistent-memory MCP server with semantic search over APIs, code, emails and schemas. Applied AIData Science 58k+ 2025 05 Frota de Robôs — Operação Autônoma do ERP 15 robots in production that operate the ERP on their own — tax, receivables, legal and infrastructure. AutomationData Science 15 2024–2026 06 Robô de Recebimentos An autonomous agent that reconciles payments against open instalments and settles them in the ERP on its own. AutomationData Science 6 2025 07 AutoMgsWeb — Automação WhatsApp WhatsApp messaging automation platform integrated with the ERP. AutomationFull-Stack 3 2024