Guilherme Bortolaso, Developer in Santa Cruz do Sul - State of Rio Grande do Sul, Brazil
Guilherme is available for hire
Hire Guilherme

Guilherme Bortolaso

Verified Expert  in Engineering

Data Engineer and Developer

Santa Cruz do Sul - State of Rio Grande do Sul, Brazil

Toptal member since January 25, 2024

Bio

Guilherme is a qualified professional with extensive experience in data engineering. His career is marked by significant contributions to large-scale projects involving the implementation of big data solutions, machine learning, and back-end development. Adept in team leadership and strategic consulting, Guilherme is prepared to tackle complex challenges and deliver high-impact solutions.

Portfolio

Reddit
Python 3, AWS IoT, Scala, Docker, Kubernetes, Google Cloud Platform (GCP)...
Pinterest
Python API, Python 3, GraphQL, Flask, Data Engineering, Databases, APIs, Python
V4
AWS IoT, Google Cloud Platform (GCP), Microsoft SQL Server, Amazon Aurora...

Experience

  • Python 3 - 8 years
  • AWS IoT - 7 years
  • SQL - 6 years
  • NoSQL - 4 years
  • Google Cloud Platform (GCP) - 4 years
  • Apache Airflow - 2 years
  • PySpark - 2 years
  • Databricks - 1 year

Availability

Part-time

Preferred Environment

Python 3, Google Cloud Platform (GCP), SQL, NoSQL, Apache Airflow, PySpark, Amazon, Databricks, AWS Glue, Azure

The most amazing...

...project I've developed is an advanced simulation system for autonomous vehicles at Skoods, integrating Unreal Engine, Python, TensorFlow, and AirSim.

Work Experience

Senior Data Engineer

2023 - PRESENT
Reddit
  • Developed machine learning (ML) algorithms at Reddit to fortify fraud prevention measures, enhancing transaction security and reducing credit card fraud.
  • Oversaw the back-end development of Reddit's financial transactions, improving the efficiency and reliability of ad sales and billing systems.
  • Modernized Reddit's tech stack by implementing Kafka, Flask, and Kubernetes, boosting system scalability and improving efficiency in handling increased traffic demands.
Technologies: Python 3, AWS IoT, Scala, Docker, Kubernetes, Google Cloud Platform (GCP), PostgreSQL, Apache Airflow, Data Engineering, Databases, ETL, Python

Senior Data Engineer

2022 - 2023
Pinterest
  • Migrated Pinterest's API from REST to GraphQL, enhancing system performance and data efficiency.
  • Implemented unit and integration tests for new GraphQL infrastructure, ensuring robust and error-free deployment.
  • Assisted GraphQL adopters by designing and implementing features that enhanced user experience and improved the back-end systems' functionality.
Technologies: Python API, Python 3, GraphQL, Flask, Data Engineering, Databases, APIs, Python

Freelance Data Engineering Consultant

2021 - 2023
V4
  • Established the company's 1st cloud environment, integrating diverse databases like PostgreSQL Aurora and MongoDB.
  • Developed ETL/ELT data pipeline patterns in Python, optimizing data processing capabilities and providing robust support for business analytics.
  • Directed recruitment and training initiatives for junior engineers and data scientists, cultivating a highly skilled team to meet the demands of a rapidly expanding digital marketing startup.
Technologies: AWS IoT, Google Cloud Platform (GCP), Microsoft SQL Server, Amazon Aurora, Python 3, MongoDB, Amazon Elastic Container Service (ECS), PostgreSQL, Data Engineering, Databases, ETL, Python

Data Coordinator and Data Specialist

2020 - 2021
C6 Bank
  • Managed the company's data team, enhancing data security and fraud prevention in payment transactions.
  • Oversaw regulatory compliance for anti-money laundering and counter-terrorism, maintaining high audit standards.
  • Developed and maintained data pipelines, contributing to efficient database administration and advanced report provisioning.
Technologies: Python 3, AWS IoT, Google Cloud Platform (GCP), SQL Server 2016, Terraform, MongoDB, Apache NiFi, StreamSets, Data Engineering, Databases, ETL, Python

Data Engineer

2019 - 2020
Hewlett Packard Enterprise
  • Developed AWS data pipelines, optimizing Amazon Redshift and Aurora databases for enhanced data handling.
  • Contributed to ETL and API development, integrating Java, Python, and various tools for agile data processing.
  • Played a key role in creating a telemetry data platform, using Databricks for processing large data volumes efficiently.
Technologies: Java, Python 3, AWS IoT, Jenkins, PostgreSQL, MySQL, Play SDK, Kubernetes Operations (kOps), Data Engineering, Databases, ETL, Python

Software Integration Engineer

2018 - 2020
Skoods Self-racing Car Team
  • Developed high-definition (HD) mapping and simulation systems for autonomous vehicles using Unreal Engine 4, C++, and Python.
  • Implemented advanced ML techniques with TensorFlow and Keras for realistic vehicle navigation simulations.
  • Pioneered a digital twin for logistics operations, leveraging AWS and the Google Cloud Platform (GCP) for high-capacity neural network training.
Technologies: C++, Python 3, Unreal Engine 4, Point Clouds, 3D, Simulators, Simulink, MATLAB

IT Project Manager

2015 - 2017
Um Ti
  • Spearheaded the development of software projects, focusing on innovative solutions in cybersecurity and big data.
  • Developed Political Campaign Analysis Platform (PoAS), a platform for political campaign analysis. Used public web and social media data for reputation analysis with data mining and natural language processing (NLP).
  • Employed ML in Python and PySpark for PoAS, generating insights on campaign strategies, reputational aspects, and critical topics.
  • Headed cybersecurity projects, including web radio server management, information security issue resolution, and Linux infrastructure design for network privacy.
Technologies: Python 3, Hadoop, XenServer, Apache Cassandra, PySpark, Natural Language Toolkit (NLTK), SHOUTcast

Area Manager

2007 - 2014
Schnell Group
  • Provided comprehensive technical support for Graphico software across Latin America, including on-premises infrastructure setup and training for staff and clients in major construction projects like dams and nuclear plants.
  • Contributed to extensive infrastructure projects in ports, airports, dams, wind farms, and rolling mills. Orchestrated effective coordination between commercial and technical aspects to guarantee the seamless execution of projects.
  • Directed strategic reporting to headquarters, providing essential data, key performance indicators (KPIs), and insights into the Brazilian market. This information proved instrumental in formulating and executing technology-commercial strategies.
Technologies: Windows Server, Delphi, MySQL, IP Networks, Graphico

Engineering and Utilities Intern

2004 - 2005
AB InBev
  • Developed a Visual Basic (VB) routine for data acquisition, capturing key production metrics like energy and fuel usage.
  • Focused on tracking drying ramps and cooling of raw materials, along with process variables and automation system logs.
  • Integrated acquired data into a MySQL database. Created dashboards for real-time monitoring of Navegantes I and II Malt Houses' performance.
  • Developed software for PID control of a high-pressure boiler's malt drying and temperature control, saving 144 kg of fuel per hour.
Technologies: Visual Basic, MySQL, Windows Server, Excel VBA

Quality Control and Audit Intern

2001 - 2002
General Motors
  • Conducted audits of systematists and future suppliers for General Motors in Gravatai. The audit focused on verifying the products and processes of these suppliers before the unit became operational.
  • Created reports on non-conformities identified during the audits. These reports were crucial in ensuring supplier standards met the company's stringent quality requirements.
  • Presented audit results in English, highlighting areas of improvement and compliance. This role required strong analytical and communication skills in an international business context.
Technologies: Windows, Excel VBA

Research and Development Intern

1998 - 1998
Kopp
  • Developed software for radars, electronic panels, and legislative voting systems. Worked on data storage and transmission systems for Detran and voting systems.
  • Played a significant role in developing the voting system for the Senate and Chamber of Deputies. Researched new products like infrared flashes and wireless data streaming using FM carriers.
  • Presented company products and services to clients and public agencies. Utilized technologies like Assembler, C, C++, analog and digital electronics, and PIC series microcontrollers.
Technologies: Assembly, C++, Digital Electronics, Analog-to-digital Converters (ADC)

Experience

C6 Bank | Data Team Coordination and Data Lake Integration

Headed vital projects focusing on data team management, security, and fraud prevention at C6 Bank that was later merged with JP Morgan. These projects included:

• Overseeing the integration of disparate data lakes post-merger, combining large datasets into a unified system and ensuring seamless data flow.
• Aligning data practices with strict regulatory standards, particularly in anti-money laundering and counter-terrorism financing, a challenge intensified by the merger's scale.
• Managing the cultural merger of C6 Bank and JP Morgan teams, fostering collaboration and aligning work cultures to maintain morale and productivity.
• Creating and maintaining scalable data pipelines, adapting to increased demands and guiding the team in new technologies and processes.

My tenure here was marked by overcoming challenges in data integration, regulatory compliance, cultural unification, and pipeline development during a crucial merger period.

V4 Company | Big Data Project

Served as a big data project consultant and played a key role in pioneering V4 Company's data initiatives in a rapidly evolving digital marketing landscape. Some of my key challenges and accomplishments include:

• Establishing V4's 1st cloud environment, integrating diverse databases such as PostgreSQL Aurora, SQL Server, and MongoDB. This initiative laid the foundation for robust data handling and analytics capabilities.
• Developing ETL/ELT data pipeline patterns in Python, streamlining data processing, and supporting advanced business analytics. This involved technical expertise and a strategic approach to data management.
• Participating in recruiting and training a new team, focusing on junior engineers and data scientists. My role was instrumental in building a skilled team to drive the company's data-centric vision.

During my tenure at V4 Company, I focused on establishing a robust foundational data infrastructure, crafting efficient data pipelines, and leading a nascent team. These efforts played a pivotal role in significantly contributing to the company's growth within the digital marketing industry.

Skoods Self-racing Car Team

https://github.com/skoods-org
Spearheaded innovative projects in autonomous vehicle simulation while serving as a software engineer at Skoods Self-racing Cars team. Some of the key challenges and accomplishments include:

• Developing high-resolution mapping and sophisticated simulation systems using Unreal Engine 4, C++, and Python. This work was pivotal in enhancing the realism and accuracy of autonomous vehicle simulations.
• Implementing cutting-edge machine learning techniques with tools like TensorFlow and Keras. These efforts were crucial in advancing the simulation platform's capabilities for realistic vehicle navigation.
• Conceptualizing and developing a digital twin for logistics operations, utilizing AWS and GCP for intensive neural network training. This project demonstrated the potential of virtual simulations in optimizing real-world logistics and transportation.

During my time at Skoods, I spearheaded significant technological breakthroughs in autonomous vehicle simulation, implemented machine learning solutions, and played a key role in creating a sophisticated digital twin. These contributions positioned the company at the forefront of innovation within the automotive industry.

Education

2023 - 2024

Master's Degree in Artificial Intelligence

Pontifical Catholic University of Rio Grande do Sul - Porto Alegre, Brazil

2019 - 2019

Specialization in Project Management

Ohio University - Athens, Ohio, USA

2005 - 2007

Master's Degree in Business Administration

FGV - Rio de Janeiro, Brazil

1998 - 2005

Bachelor's Degree in Systems Engineering

Pontifical Catholic University of Rio Grande do Sul - Porto Alegre, Brazil

1996 - 1998

Associate's Degree in Systems Engineering

Mechatronics Technology Center - Caxias do Sul, Brazil

Certifications

MARCH 2020 - PRESENT

Intel IoT Edge AI

OpenVINO | via Udacity

AUGUST 2019 - PRESENT

English for Business

Ohio University

NOVEMBER 2018 - PRESENT

Machine Learning on Google Cloud

Coursera

APRIL 2018 - PRESENT

Self-driving Cars Engineering | Nanodegree Program

Udacity

DECEMBER 2016 - PRESENT

Financial Engineering and Risk Management Part I

Columbia University in the City of New York | via Coursera

Skills

Libraries/APIs

PySpark, Python API, Natural Language Toolkit (NLTK)

Tools

Git, Apache Airflow, Amazon Elastic Container Service (ECS), Terraform, Apache NiFi, Jenkins, MATLAB, SHOUTcast, AWS Glue

Languages

Python 3, Python, SQL, Scala, GraphQL, Java, C++, Simulink, Delphi, Visual Basic, Excel VBA, Assembly

Paradigms

ETL, Agile

Storage

Databases, NoSQL, PostgreSQL, Microsoft SQL Server, Amazon Aurora, MongoDB, SQL Server 2016, MySQL

Platforms

Google Cloud Platform (GCP), AWS IoT, Docker, Kubernetes, Amazon Web Services (AWS), XenServer, Windows Server, Windows, Amazon, Databricks, Azure

Frameworks

Flask, Play SDK, Unreal Engine 4, Spark, Hadoop

Other

Data Engineering, APIs, Software, Economics, Business, IT Project Management, Machine Learning, Data Science, Artificial Intelligence (AI), StreamSets, Kubernetes Operations (kOps), Point Clouds, 3D, Simulators, Computer Vision, English, Financing, ECS, Streaming, Apache Cassandra, IP Networks, Graphico, Digital Electronics, Analog-to-digital Converters (ADC)

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring