Skip to content

Data Science · Applied AI · Automation

Turning legacy systems into business decisions

I'm Marcelo Santos. I build data systems, automation and artificial intelligence for real-world operations.

From ERP integrations to autonomous agents, semantic search and large-scale monitoring, I design every solution to fit each company's business rules.

Not prototypes. Production systems — running processes, connecting information and turning data into action.

Real system, fictitious data. A 30-minute trial, with the link sent by email. The link arrives by email; best opened on a computer.

Sheet 01 — Ecosystem in production click a system
Read as
ERP UAU The heart of the companySQL Server + API Platform AppTech All management in one placeFlask · React · ~20 ETLs try it IA · RAG ai-memory The memory AI looks upHybrid search · MCP 15 agents Robot Fleet Routines that run themselvesScheduled jobs · daemons Orchestrator Pandora Asks before it signsAuditable agents · LLM Messaging AutoMgsWeb The ERP notifies who needs itIdempotent queue · 3 DBs Agent Collections Robot Reconciles and settles alone6-stage pipeline Platform Court Monitor Only what is each client’s1.1M publications/day TOTVS RM Spreadsheets Emails · 58k AI assistants Gazettes · 91 courts Tax XMLs Court databases Managers · WhatsApp WhatsApp Clients · email ERP UAU core Platform AppTech try it IA · RAG ai-memory 15 agents Robot Fleet Orchestrator Pandora Messaging AutoMgsWeb Agent Collections Platform Court Monitor TOTVS RM Spreadsheets Emails AI assistants Gazettes (91) Tax XMLs Managers WhatsApp Clients
Systems7 on this sheet
Coreconstruction ERP
Scalenot to scale · schematic
Rev.2026-10

00Who answers

Pandora runs the operation

She is the MJS agent: she reads the ERP, acts through the API and, when money is involved, asks before signing. The systems in this portfolio are what she operates.

See the Pandora case →
Illustrated character — the face is not a real person.

01 Areas of expertise

Areas of expertise

Every skill points to the production systems that prove it.

01

Data Science & ETL

Resilient pipelines that extract, transform and unify data from legacy ERPs, SQL Server databases, TOTVS RM and spreadsheets — with incremental loads, watermarks and replica resilience.

Python · PostgreSQL · SQL Server · ETL incremental · pandas · Airflow-style jobs

Proven in

~2,7M processes in the historical pipeline — AppTech

02

Applied AI & RAG

Semantic search and RAG systems in production: embeddings, full-text, rank fusion and an MCP server acting as a "second brain" over 58,000 emails and thousands of documents.

RAG · Embeddings · Busca híbrida · MCP · LLMs · Bancos vetoriais

Proven in

58k+ emails indexed — ai-memory

03

Automation & Autonomous Agents

Robots that run the ERP on their own: they approve payment processes, import invoices, monitor publications from 91 courts, reconcile payments and settle instalments — and notify on WhatsApp whoever needs to know.

Agentes autônomos · WhatsApp API · Integração de APIs · Jobs agendados

Proven in

15 autonomous robots in production — Robot Fleet

04

Full-Stack & DevOps

Complete web apps in Flask + React, packaged in Docker and served in production with Docker Swarm, Traefik, Nginx and rolling deploys with healthchecks.

Flask · React · Docker Swarm · Traefik · Nginx · REST APIs

Proven in

13 permission-controlled modules — AppTech

02 Projects & Case Studies

Projects & Case Studies

Production systems solving concrete business problems.

All projects

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.