patrick pessoa

• Designed and maintained scalable data extraction and processing platforms using Python, FastAPI, and Kubernetes.
• Built distributed data pipelines processing tens of millions of records weekly, storing structured datasets in PostgreSQL.
• Implemented Apache Airflow orchestration managing 80+ automated workflows for extraction, transformation, and storage.
• Automated manual data collection pipe

• Contributed to the Automatic Train Supervision (ATS) system regulating São Paulo’s subway network, supporting infrastructure used by ~3M daily passengers.
• Developed C++ and C# modules implementing train routing and traffic regulation logic based on real-time signaling and scheduling constraints.
• Built and stabilized control room monitoring interfaces used for real-time supervision of subway

• Integrated Elasticsearch and Neo4j for advanced search and graph-based relationship analysis across company datasets.
• Designed and maintained scalable data extraction and processing platforms using Python, FastAPI.
• Built distributed data pipelines processing tens of millions of records weekly, storing structured datasets in PostgreSQL.
• Automated manual data collection pipelines, reducing

• Designed and implemented VBA-based automation tools to support engineering budgeting workflows.
• Automated the collection of materials pricing from official government sources across multiple states, replacing manual research processes.
• Built structured pricing databases using Microsoft Access, improving traceability and consistency of cost estimates.
• Reduced manual data gathering effort by

• Developed VBA automation modules to streamline internal data processing and reporting workflows.
• Supported engineering teams in projects related to electricity generation, transmission, and distribution infrastructure.
• Assisted in preparing technical specifications and engineering documentation for project execution.

• Designed and implemented Power BI dashboards to track the progress of government-incentivized projects across multiple business areas.
• Replaced fragmented Excel tracking with a centralized data visualization platform accessible across departments.
• Enabled teams to monitor documentation progress, project status, and compliance requirements in real time.
• Improved transparency and decision-ma

Master's project focused on developing prediction systems for energy consumption and demand. Developed under a 100% exemption grant granted by the institution, for the best student in the Electrical Engineering - Computers class.

Issued Jul 2019

Issued Jan 2016

Issued Dec 2016