Summary
Overview
Work History
Education
Skills
Websites
Other Experiences
Timeline
Generic

Guilherme Tosi

Software Engineer
São Carlos

Summary

Data Engineer and Information Systems student at USP São Carlos, specializing in scalable data pipelines, ERP integrations, and automation solutions. Delivered 75% process time reduction, 100% issue resolution on key dashboards, and improved data reliability across real estate B2B systems. Skilled in Python, Apache NiFi, DBT, Snowflake, and AWS. Strong expertise in Python, Apache NiFi, DBT, Snowflake, AWS, Low-code development (e.g., Retool), and Metabase, along with advanced experience in SQL, low-code development, data engineering, and process automation. My deliverables focus on efficiency gains, democratization of internal processes, and optimization of data monitoring.

Knowledgeable Software Engineer with robust background in data architecture and pipeline development. Proven ability to streamline data processes and enhance data integrity through innovative solutions. Demonstrates advanced proficiency in SQL and Python, leveraging these skills to support cross-functional teams and drive data-driven decision-making.

Results-driven data engineering professional with solid foundation in designing and maintaining scalable data systems. Expertise in developing efficient ETL processes and ensuring data accuracy, contributing to impactful business insights. Known for strong collaborative skills and ability to adapt to dynamic project requirements, delivering reliable and timely solutions.

Overview

3
3
years of professional experience
4052
4052
years of post-secondary education
2
2
Languages

Work History

Data Engineer

CUB
São Carlos, SP
01.2025 - Current
  • Optimized ETL data pipelines using Apache NiFi and Snowflake, improving reliability and reducing specific integration failures by 100%.
  • Designed Metabase dashboards and automated quality checks, eliminating 100% of dashboard-related complaints and improving CSAT scores.
  • Refactored critical system tables with DBT and advanced SQL (CTEs, subqueries), increasing financial analysis accuracy for clients, improving data in 3 large dashboards.
  • Constructed low-code internal automation tools in Retool, reducing manual processes by 75% and minimizing operational errors.
  • Main Projects:
  • Evolution of Installment and Contract Tables
  • Situation: Inconsistencies and limitations in 3 client dashboards.
  • Task: Refactor and enhance critical system tables using DBT for higher data reliability in those 3 dashboards.
  • Action: Applied advanced SQL with CTEs, subqueries, derived columns, and adopted present value logic.
  • Result: Boosted dashboard reliability and consistency on Metabase, improving clients’ financial analysis. 100% of complaints ceased and CSAT satisfaction score augmented.
  • Data Integration with Apache NiFi
  • Situation: Incomplete integration and unstructured data from partner ERPs (SIENGE, MEGA, UAU), affecting 100% of all tables that use this data.
  • Task: Create 1 table with new fields and expand data integration flows for contractual data.
  • Action: Enhanced NiFi workflows with new processors., 1 table in Snowflake, and adjusted conditional routing.
  • Result: Expanded data integration coverage by 70%, increased reliability, and reduced integration failures.
  • Process Automation with Retool
  • Situation: Manual internal operations prone to errors and delay, about 2 hours per day is used to it.
  • Task: Construct 5 low-code interfaces for internal process automation, making API Rest calls to AWS (Dynamo, S3, SQS), Kobana, and Snowflake.
  • Action: Developed Retool interfaces for:
  • Reintegrating failed contracts
  • Registering and managing client credentials
  • Onboarding developments and uploading media to S3
  • Configuring webhooks for Kobana
  • Opt-in and Opt-out of contracts in a democratic and auditable manner
  • Result: 75% reduction in time spent on these tasks, error minimization, and OKR target achievement.
  • Internal Integration Dashboards
  • Situation: Lack of efficient visibility on daily integration status, initially monitored via Grafana.
  • Task: Formulate internal dashboards using Metabase, retrieving data from Snowflake tables.
  • Action: Wrote queries in Metabase to monitor contract integration by ERP, client, and date.
  • Result: Enhanced control and proactivity in detecting and solving integration issues, providing full visibility on the company’s contract statuses.

N1 Support Analyst

CeMEAI / USP
São Carlos, SP
03.2023 - 01.2025
  • Resolved 300+ technical support requests annually with a 90% first-contact resolution rate, reducing system downtime significantly.
  • Reduced infrastructure failures by 75% through monitoring and maintenance of Linux/Windows systems.
  • Produced and compiled custom OS images for academic labs, cutting configuration errors to 0% and reducing setup time by 30%.
  • Managed an inventory of 100+ lab devices, ensuring operational efficiency and compliance with IT standards.
  • Projects:
  • Customized Operating System Image Development
  • Situation: In the academic environment, students require many different software, demanding a tailored OS image.
  • Task: Develop a custom Ubuntu image based on Gentoo.
  • Action: Authored a detailed guideline to ensure correct formatting during OS image creation.
  • Result: 100% reduction in human errors and 30% reduction in formatting time.

Full Stack Developer

Cafézinho
São Carlos, SP
10.2022 - 01.2023
  • Built and optimized features for a dating app with 1,000+ downloads, using PHP, JavaScript, and CSS for responsive UI design.
  • Integrated Google Pay, enabling secure transactions for 33% of users.
  • Applied Scrum methodology, improving team productivity by 20% through continuous delivery and iterative development.
  • Reduced versioning conflicts by 50% via structured Git workflows.
  • Main Projects:
  • Integration with Google Pay
  • Situation: Need to provide diverse and secure payment options for 100% of users.
  • Task: Integrate Google's solution into the company's system.
  • Action: Analyzed documentation and integrated the solution, also adjusting the site’s style.
  • Result: The app gained a new payment option, used by 33% of users.

Education

Bachelor of Science - Computer Sciences

University of São Paulo
São Carlos, São Paulo
12.2026

Technical - Real State

Instituto MONITOR
Rio Claro, SP
11.2024

Skills

Site Reliability Engineering (SRE)

Software Engineering (SWE)

Data Engineering

Big Data

Artificial Intelligence

Cloud computing

Low Code Development

Business Intelligence

Agile Methodologies

undefined

Other Experiences

  • Scientific Initiation, Palacký University Olomouc - Remote
  • Student Representative, Bachelor in Information Systems, ICMC

Timeline

Data Engineer

CUB
01.2025 - Current

N1 Support Analyst

CeMEAI / USP
03.2023 - 01.2025

Full Stack Developer

Cafézinho
10.2022 - 01.2023

Bachelor of Science - Computer Sciences

University of São Paulo

Technical - Real State

Instituto MONITOR
Guilherme TosiSoftware Engineer