Joao Vitor Brandao

Maintains and evolves 10+ production automation systems, integrating Python, REST APIs, databases, SharePoint, and Microsoft services into critical academic and administrative processes. Investigates production issues through structured logs and database records, performs root cause analysis, and implements fixes, validations, exception handling, telemetry, and structural refactoring. Reduced recurring production failures by approximately 30%, maintaining data integrity in pipelines with 40k+ records per cycle. Improved exception handling and telemetry, reducing production operational errors by approximately 28%. Designed and maintained 8+ production automations in Python/Robot Framework, with MongoDB integrations and validation layers for 25k+ records per semester. Migrated and refactored Python/Robot Framework workloads from Jenkins to the BotCity ecosystem, aligning dependencies, logging, scheduling, and execution requirements.

Developed Python backend routines and refactored legacy scripts, reducing execution time by approximately 20% and production anomalies by approximately 25%.

Automated tasks with Power Automate/Pipefy and built 12+ dashboards in Power BI, validating datasets with more than 100k rows.

Developed web features with Ruby on Rails, SQL/PostgreSQL, Linux, and Git, with an emphasis on data integration and backend reliability.