
Felipe Jacheto
Verified Expert in Engineering
Data Engineer and Infrastructure Developer
São Paulo - State of São Paulo, Brazil
Toptal member since March 30, 2022
Felipe is a skilled Data Engineer with years of experience as a Data Engineer Consultant and Freelancer. Starting as a junior developer, he quickly advanced to one of the leaders in a 20-member team, helping to scale data-related projects in multiple clients. Felipe's strongest skills include implementing and operating Azure Data Stack, Power BI development and Power BI organizational management, Data Pipeline development, and Process Automation.
Portfolio
Experience
- Python - 5 years
- SQL - 3 years
- Microsoft Power BI - 3 years
- ETL - 3 years
- Data Governance - 2 years
- Information Visualization - 2 years
- Azure Data Factory (ADF) - 2 years
- Data Architecture - 2 years
Availability
Preferred Environment
Azure, Windows, Python, Office 365, Microsoft Power BI
The most amazing...
...project I've developed was a robot orchestration infrastructure in six months.
Work Experience
Senior Data Engineer
Pemex - Main
- Developed or contributed to initiatives to organize Power BI in the organization, such as a centralized app, standard documentation, standard templates and good practices which spread across all developers, and automatic PBI refresh monitoring.
- Developed several Power BI for the finance department, including Spending which provides a one-stop-shop and 100% automated tool that consolidates all expenses of the organization.
- Contributed to essential Data Engineering efforts to organize the company's data into a single Data Warehouse, creating multiple data pipelines and tuning SQL Server performance.
- Developed multiple Power BI for the Supply Chain department, such as Material Status Report which consolidates all expected deliveries in a single place, and Parked/Blocked which creates a unified panel for all POs that needs attention.
Data Governance Learning Organization Leader
Visagio
- Created reference materials for data governance across all companies, containing good practices across people, processes and technology pillars.
- Published an internal article called "What it REALLY means to be Data-driven?".
- Created documentation for a framework to evaluate the data management maturity of clients. With that, it is possible to measure how well a company is doing in each pillar and propose improvements to specific categories.
- Helped to sell more than five data-related projects to different clients in several industries by building proposal materials and presenting them in meetings.
Data Engineer
Visagio
- Developed over 50 data pipelines in Azure Data Factory and Databricks (using PySpark and Pandas), with dozens of system integrations and hundreds of tables created in the data warehouse.
- Resolved more than 400 support tickets in 2020 while overseeing technical support.
- Created an Azure infrastructure from scratch for a 5,000+ employee company in the mining sector. Began with no infrastructure, and now there are more than 300 official tables and robust data governance with high-data quality.
- Led infrastructure improvement efforts such as creating CI/CD mechanisms, implementing quality checklists for developers, creating a data quality dashboard, a data catalog, a pipeline monitoring dashboard, a unified RPA, and data infrastructure.
- Implemented solutions for people management, such as a central backlog for registering and following all initiatives, prioritization score calculation, and a welcome kit to automate onboarding.
- Coordinated the data DG pillar of the data learning organization. Activities included: studying data governance and getting certifications, creating knowledge materials, selling new data projects, and presenting classes about DG.
- Developed several high-quality Power BI dashboards for multiple departments, including Finance, HR, Operations, Supply Chain, and IT.
- Helped to organize Power BI server, enabling it to handle multiple developers from several departments, by defining best practices, creating standard documentation, training, and coaching other developers.
- Developed and maintained multiple robots in UiPath to automate processes across multiple departments.
- Created quality standards and common templates to be used by other developers in UiPath, to reduce complexity, standardize documentation and enable all robots to be monitored in a single tool in Power BI.
RPA Developer
Visagio
- Automated several processes in the supply chain department of a bank. This involves mapping processes, designing the automation roadmap and changes required, and developing software robots (RPA) to automate repetitive tasks and implementing those.
- Accomplished saving over four FTEs with software robots.
- Developed several dashboards in Power BI to report a retail company's centralized services department performance.
Full-stack Developer
Visagio
- Assisted in developing a workflow management software based on C# for creating, following, and monitoring common tasks between business teams.
- Designed and developed a system in C# to orchestrate software robots in several computers. The components were a controller (the "brain" of the system), a database, an executor (to trigger the bots), robots, and a user interface.
- Developed over ten different software robots using C# and VBA.
Experience
Power BI Monitor Dashboard
https://www.jacheto.com/?project=Power+BI+Monitor+DashboardThe dashboard has several key components, including Last refreshes, which shows the last N refreshes of every published Power BI, making it extremely useful for spotting errors. Data Sources, which shows all data sources automatically from API. Excel Documentation, which is a single documentation Excel that every developer needs to fill when publishing new reports. This simplifies life because people usually do not take time for documentation, so reducing that to a 3-minute process increases overall adoption. Additionally, Usage Metrics are included, which function similarly to Power BI's default usage metrics, showing how many views and viewers each page from each report had over the last weeks.
Spending Power BI
https://www.jacheto.com/?project=Finance+Spending+Power+BIAzure Data Infrastructure Implementation
In 2019, I acted as a data engineer, creating data pipelines for the financial department. In 2020 I became the technical support of the team. I made sure everything in production worked without errors and generated value that satisfied clients. At the time, the project had two pillars: Data and RPA infrastructure. In 2021, I switched to the front line, working as a data engineer (creating data pipelines and integrations with the company's systems), and a DevOps engineer (constantly evolving the architecture with improvements in the infrastructure and governance).
Data Governance Coordinator
I participate in the Data and BI LO, leveraging data governance (and all other data management siloes). I spend a good portion of time studying data governance, reading books and online articles, and creating knowledge materials (PowerPoint presentations describing what it is and its importance, then entering into the details of each silo). I secured the DAMA certification as a data management certified professional. I created materials to spread the knowledge of data governance across the company, presented classes and meetups about the topic, and delivered a presentation outlining proposals on selling new projects with data governance-related capabilities
Supply Chain RPA Automation
Autonomous Service Robot
Software Robot Orchestration System
The system was developed in C# to orchestrate software bots on several computers. It consisted of a controller, a database, an executor, software robots, and a UI.
Python Platform Game with Custom Physics Engine
2 DOF Platform
Education
Bachelor's Degree in Control and Automation Engineering
Instituto Mauá de Tecnologia - São Caetano do Sul, São Paulo, Brazil
Exchange Program in Electrical Engineering
Waterford Institute of Technology - Waterford, Ireland
Certifications
IELTS
IELTS
UiPath Advanced Training
UiPath
Skills
Libraries/APIs
PySpark, Pandas, REST APIs, Pygame
Tools
Microsoft Power BI, Excel 2013, Microsoft PowerPoint, Microsoft Excel, Git, Microsoft Flow, MATLAB, Tableau
Languages
Python, SQL, Excel VBA, SQL DML, T-SQL (Transact-SQL), C, JavaScript, C#
Paradigms
ETL, Business Intelligence (BI), Azure DevOps, DevOps
Platforms
Windows, Azure, Databricks, Linux, Ubuntu, SharePoint
Storage
Data Pipelines, Data Lakes, Microsoft SQL Server, SQL Server Analysis Services (SSAS)
Frameworks
Spark
Other
Office 365, Robotic Process Automation (RPA), Data Visualization, Data Governance, Azure Data Factory (ADF), Excel 365, Presentations, Data Engineering, DAX, Dashboards, SAP, Control Theory, Classical Control Theory, Robot Operating System (ROS), Data Architecture, UiPath, Data Warehousing, Data Warehouse Design, Data Management, Azure Data Lake, APIs, Data Analysis, Data Analytics, Communication, Azure Databricks, Information Visualization, Artificial Intelligence (AI), Robotics, Process Mapping, IT Project Management, Leadership, People Management, Catalog Data Entry Services, Semiconductors, Renewable Energy, English, Azure Analysis Services
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