Public Sector / SocialPERIOD: 2024 – 2025Comarca de União da Vitória, Brazil
Sistema ELLAS
Research & Development Platform for Secure Public Sector Data Sharing
Built from scratch in direct partnership with the Regional Commission for Tackling Violence and over 12 public agencies, including Public Prosecution (Ministério Público), Civil Police, Judiciary Court, Bar Association (OAB), and Health Secretariat.
Partner Institutions12+
FIciências Selection2024 & 2025
Adoption StatusState Pilot
THE PROBLEM & CONTEXT
Public protection agencies operated in data silos, impeding timely inter-agency intervention, secure case record sharing, and protective order tracking for victims of violence.
THE ARCHITECTURAL SOLUTION
Designed and implemented a secure digital platform with structured access control, strict data governance, and relational schemas validated directly against real judicial case records provided by the Public Prosecutor's Office.
SYSTEM ARCHITECTURE & DESIGN HIGHLIGHTS
01Relational database modeling optimized for sensitive legal & health records
02Strict role-based & multi-agency data isolation rules
03Encrypted transmission pipelines for multi-departmental auditability
04Real-world judicial case record validation framework
ENGINEERING CHALLENGES
- •Designing strict access control boundaries for heterogeneous public entities with distinct legal mandates.
- •Validating complex relational schemas against unstandardized judicial records provided by law enforcement and courts.
LESSONS & KEY TAKEAWAYS
- •Rigorous domain modeling combined with early stakeholder validation prevents costly schema refactors when handling compliance-heavy data.
- •Direct collaboration with field operators (prosecutors, police officers) yields far more usable software than isolated spec building.
TECHNOLOGY STACK USED
TypeScriptNestJSPostgreSQLPrisma ORMNext.jsReactTailwind CSSDocker