
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
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
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
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
- 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.
Senior Data Engineer
- 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.
Freelance Data Engineering Consultant
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.
Data Coordinator and Data Specialist
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.
Data Engineer
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.
Software Integration Engineer
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.
IT Project Manager
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.
Area Manager
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.
Engineering and Utilities Intern
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.
Quality Control and Audit Intern
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.
Research and Development Intern
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.
Experience
C6 Bank | Data Team Coordination and Data Lake Integration
• 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
• 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• 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
Master's Degree in Artificial Intelligence
Pontifical Catholic University of Rio Grande do Sul - Porto Alegre, Brazil
Specialization in Project Management
Ohio University - Athens, Ohio, USA
Master's Degree in Business Administration
FGV - Rio de Janeiro, Brazil
Bachelor's Degree in Systems Engineering
Pontifical Catholic University of Rio Grande do Sul - Porto Alegre, Brazil
Associate's Degree in Systems Engineering
Mechatronics Technology Center - Caxias do Sul, Brazil
Certifications
Intel IoT Edge AI
OpenVINO | via Udacity
English for Business
Ohio University
Machine Learning on Google Cloud
Coursera
Self-driving Cars Engineering | Nanodegree Program
Udacity
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)
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring