Prefeitura de Presidente Epitácio
Software Engineering & Health Data Systems
Oct 2023 — Present
- Built Python/FastAPI validation services and maintained Java/Spring/PostgreSQL systems, modeling longitudinal patient identity across historical names, missing or changed CPF identifiers, and CNS changes for 21,000+ monthly records.
- Diagnosed Java/Spring performance degradation caused by an unset optional identifier that prolonged object lifetime and increased garbage-collection pressure; fixed identifier assignment and cleanup behavior to restore stable execution.
- Built performance instrumentation to detect N+1 patterns, repeated execution paths, and latency regressions, validating changes through baseline/diff comparisons, shadow runs, and night/chaos tests.
- Debugged an edge agent across installation, discovery, and execution using isolated VMs, MITM traffic inspection, and runtime diagnostics; traced repeat-install failures to stale Windows Registry and machine state, then updated uninstall cleanup and forced discovery during installation.
- Reduced healthcare claim rejection rates from 12%+ to below 1% across 8 consecutive billing cycles by engineering 11 auditable Python/SQL validation and reconciliation rules across legacy and government systems.
- Cut municipality-wide workforce reconciliation from 240+ person-hours to about 4 per cycle by building Python extraction, Parquet processing, provenance controls, and centralized APIs.
- Built an S3/Parquet analytical path cataloged by AWS Glue and queried through Athena, and worked on SQS, Lambda, and SES workflows for cross-application audit events and transactional email.
- Authored installation, operations, troubleshooting, and handoff guides, and trained 5 staff members plus 3+ physicians and nurses on production workflows, auditing, and issue resolution.
IT Infrastructure & Systems Support · Internship
Nov 2021 — Oct 2023
- Designed and shipped a domain-specific plugin that reduced a mandatory dengue-reporting workflow from 7 manual steps to one checkbox.
- Operated health-check-driven failover for Nginx and application replicas across distributed municipal nodes, shifting traffic from unhealthy nodes within approximately 1–3 minutes with no reported user-visible outages.
- Improved release and recovery reliability with Ansible/Jenkins automation, health checks, backup checkpoints, certificate and credential rotation, and rollback procedures; restored a 9 GB PostgreSQL-backed application within 1 hour after a failed update.