RemanejaSUS & Nova PPI Capixaba
Architecting real-time allocation of public healthcare resources for millions of citizens.
The Context
The State Health Department of Espírito Santo (SESA) manages a complex network of public healthcare services. To ensure equitable access, physical service quotas (consultations, surgeries) and financial resources must be continuously planned and reallocated among 78 municipalities—a process known as the Programação Pactuada e Integrada (PPI).
The Operational Bottleneck
Historically, this reallocation process was highly fragmented. It relied on a labyrinth of spreadsheets, manual data entry, and slow administrative workflows. When regional demands shifted, adjusting the financial ceilings and service flows took too long. The data was isolated, making it difficult for regional governance bodies to make fast, evidence-based decisions.
The Systems Engineering Approach
To eliminate this friction, we designed a unified operational architecture that transitioned the state to a "Living PPI" (PPI Viva) model.
- Data Architecture & ETL: Developed robust ETL (Extract, Transform, Load) pipelines using R to process, clean, and standardize complex public health datasets from multiple legacy sources.
- Workflow Application: Engineered the "Nova PPI Capixaba" application. This tool digitizes the workflow, allowing municipal and state managers to securely propose, negotiate, and register quota reallocations in a centralized environment.
- Decision Support Systems: Built real-time analytical dashboards directly connected to the data pipelines. These dashboards provide immediate visibility into financial ceilings ("Teto Financeiro"), patient flows, and regional service gaps ("vazios assistenciais").
The Outcome
The system completely eliminated the need for manual data reconciliation. By providing a single source of truth updated in real-time, it empowered regional governance bodies (COSEMS, CIR, CIB) to allocate resources with unprecedented transparency and speed. The result is significantly greater allocative efficiency of public funds and, most importantly, improved responsiveness in healthcare delivery for the state's citizens.