João Pedro profile photo

João Pedro Lopes Gonçalves

Python · SQL · ETL · AWS Cloud

Data & Automation Engineer

Gallery photo 1
Gallery photo 3
Gallery photo 5

About

Computer Engineering student at Instituto Federal Fluminense, currently working with data, automation, and enterprise workflow optimization in a corporate engineering environment. My experience is focused on building practical solutions that reduce manual work, improve data reliability, and support better operational decisions across technical and project-driven teams.

Main Skills & Tools

Data Engineering & AutomationPython, SQL, ETL Pipelines, Data Validation, Workflow Automation, Process Optimization
AI & Intelligent AutomationLLM-based Automation, AI Agents, Prompt Engineering, AI-assisted Data Analysis, Document Review Automation
Database ManagementOracle DB, Relational Data Modeling, Advanced SQL Querying, Corporate Data Structuring
Programming & ScriptingJavaScript, Java, VBA
Analytics & Business IntelligencePower BI, Advanced DAX, Power Query M, Advanced Excel
Development & Enterprise ToolsGit, VS Code, Power Apps, Power Platform, Microsoft 365
Professional StrengthsComplex Problem Solving, Process Automation, Data-Driven Decision Making, Cross-Functional Communication, Fast Learning, C1 English

Experience

TechnipFMC logo

TechnipFMC · Internship

Project Engineer

Sep 2024 - Jul 2026 · 1 yr 11 mos·São João da Barra, Rio de Janeiro, Brasil · Hybrid
  • Developed and implemented automation solutions for engineering and project management workflows using Python, VBA, SQL, Oracle Database, and Microsoft 365 tools;
  • Supported large-scale data management processes, including extraction, validation, transformation, and structuring of corporate data from Oracle databases;
  • Designed and explored AI-powered automation solutions, including LLM integrations and AI agents, to support data analysis, documentation review, workflow execution, and operational decision-making;
  • Contributed to continuous improvement initiatives by applying Lean principles and Kaizen methodologies to optimize workflows, improve operational efficiency, and earned TechnipFMC’s Best Kaizen of the Quarter recognition;
  • Built and maintained advanced Power BI dashboards using complex DAX, Power Query M, relational data modeling, table joins, and data transformation logic;
  • Collaborated with engineering, project management, and cross-functional global teams to identify process bottlenecks and implement scalable solutions;
  • Used English daily to analyze technical documentation, communicate with global stakeholders, and support alignment across international project teams.

Certifications

Excel from Basic to Advanced, Macro, VBA + Power BI

Udemy · Jan 2025

JavaScript in 7 Days + Real Projects

Udemy · Aug 2024

Python 3 from Basic to Advanced

Udemy · Feb 2024

Git Complete: From Basic to Advanced

Udemy · Nov 2023

Power BI Complete - From Basic to Advanced

Udemy · Sep 2023

IFF logo

Instituto Federal Fluminense

2022 - Early 2027

B.S. in Computer Engineering

Campus Campos Centro

The Instituto Federal Fluminense holds the maximum grade awarded by Brazil's Ministry of Education (MEC), placing it among the country's top-ranked federal institutions. The Computer Engineering program covers embedded systems, digital circuits, operating systems, algorithms, and software engineering.

Embedded SystemsAlgorithmsOSDigital CircuitsSoftware Engineering