Fábio is available for hire
Hire FábioFábio Vasques
Verified Expert in Engineering
Data Engineer and Developer
Location
Brasília - Federal District, Brazil
Toptal Member Since
December 30, 2021
Fábio is a passionate professional working in the IT field for over 20 years. He has extensive knowledge in SQL, procedural languages for several RDBMS, data modeling, and data pipelines using a high diversity of technologies. He is also keen on agile practices, iterative and incremental methodologies, and formal methods for highly complex systems development. Fábio has a proven track record of successfully managing teams in projects and strategic areas involving technology.
Portfolio
Healthtek Solutions, LLC
Data Engineering, ETL, ETL Tools, Data Visualization, Tableau, Data Analytics...
GoSchoolBox (Toptal Client)
NoSQL, Relational Databases, Mentorship, MongoDB, JSON, Data Visualization, ETL...
Toptal Client - Zips Car Wash
SQL, Data Modeling, T-SQL (Transact-SQL), Data Pipelines, Microsoft SQL Server...
Experience
Availability
Part-time
Preferred Environment
pgAdmin, Oracle SQL Developer, Apache Airflow, ER/Builder, erwin Data Modeler, Jupyter Notebook, SQL, Data Modeling, Relational Database Design, Database Architecture, Database Schema Design, Reporting, Data Loading, Star Schema, PL/SQL, Oracle PL/SQL, Oracle SQL, Database Administration (DBA), Oracle DBA, Database Structure, Database Transactions, Transactions
The most amazing...
...database I've built can receive millions of SQL instructions in a concise amount of time, and it's part of a Brazilian government system.
Work Experience
Data Engineer
2023 - PRESENT
Healthtek Solutions, LLC
- Built a solution encompassing data extraction to report presentations using Tableau.
- Designed the data model for the solution, focusing on a structure optimized for complex queries with excellent performance.
- Set up the data architecture using Azure, prioritizing the lowest possible cost for the client without compromising integrity and performance. I configured Azure SQL, Blob Storage, and Azure Data Factory for this solution.
- Created data pipelines using Azure Data Factory and was responsible for loading CSV files from the Blob Storage server, processing the loaded data, and distributing it into the respective tables in Azure SQL.
- Created and configured Tableau Cloud, in addition to making data sources and dashboards for use by the entire team.
Technologies: Data Engineering, ETL, ETL Tools, Data Visualization, Tableau, Data Analytics, SQL, Data Modeling, Databases, Database Design, Database Structure, Database Transactions, Azure, Azure Data Factory, Query Optimization, English
Database Consultant
2022 - PRESENT
GoSchoolBox (Toptal Client)
- Monitored how to build a data visualization tool within their web solution to create dashboards and reports on the fly.
- Presented two ways to store the data for the report builder solution; the first used their Mongo database, and the second used a relational database. In both, I presented examples of data operations for clarity.
- Designed examples of JSON files and showed them the ETL process that would be necessary for creating those files.
- Presented many graphs and what kind of information, dimensional or factual data, would be necessary to produce each.
Technologies: NoSQL, Relational Databases, Mentorship, MongoDB, JSON, Data Visualization, ETL, Relational Database Design, Database Architecture, Database Schema Design, Data Loading, Business Logic, Star Schema, Architecture, Database Structure, Transactions, Data Modeling, Databases, Database Design, Requirements Analysis, English
Data Engineer and Data Analyst
2022 - PRESENT
Toptal Client - Zips Car Wash
- Created a data pipeline to gather information from multiple relational databases using T-SQL, SQL, task scheduling, and background jobs from SQL Server.
- Constructed a database using concepts such as the starflake model and data vault, guaranteeing that the solution has historical data to be consumed within a data visualization tool and has integrity across multiple fact tables.
- Produced routines capable of processing almost 1 billion records in a short time, using only T-SQL and SQL.
- Prepared many database views for Domo (a data visualization tool). I studied Domo to create the best approach for a cost-effective solution, joining performance on consuming data with the lower cost of using Domo for my client.
- Created a routine using GIS (Geographical Information Systems) operations, which compares the weather on a 7-day basis to compare with the users' visits to my client's stores.
Technologies: SQL, Data Modeling, T-SQL (Transact-SQL), Data Pipelines, Microsoft SQL Server, User Requirements, Data Visualization, Task Scheduling, Background Jobs, Dashboards, Reports, GIS, Azure, Azure Cosmos DB, Database Design, SQL Server DBA, Domo, Relational Database Design, Database Architecture, Database Schema Design, Reporting, Integration, Data Loading, Business Logic, Star Schema, Database Administration (DBA), Architecture, Data Management, Database Structure, Database Transactions, Transactions, Databases, ETL, Requirements Analysis, Query Optimization, English
MariaDB and Tableau Expert
2022 - 2022
Magnolia Jewelers Inc.
- Remodeled the client's inconsistent database so as to avoid inconsistencies, created indexes to allow faster processing of reports, and designed the database to scale. The client was a jewelry company.
- Created a procedure that checks the employees' inserts in the database to point to possible places where a correction is necessary. Before that, they used to spend much time cross-checking the shipments received from China.
- Fixed—in four hours—a coding error that had been occurring for over half a year, and they could not find what was wrong. I found out that the problem was an implementation of a MySQL function that, in a specific scenario, was miscalculating dates.
Technologies: MariaDB, Python, Tableau, MySQL, Business Logic, ETL, Database Design, SQL, Database Administration (DBA), Architecture, Data Management, Database Structure, Database Transactions, Transactions, Data Modeling, Databases, Query Optimization, English
Data Engineer
2022 - 2022
Toptal Client - Overhead Intelligence
- Created a data structure concept to store the LiDAR files in two different ways using Azure Blob Storage. The first approach was in charge of keeping the raw LiDAR data, and the second for the processed data.
- Created a conceptual data model to store the transactional data, linking the Azure SQL database to the Azure Blob Storage.
- Presented a GIS function example coded within Azure SQL that would be accountable for gathering all the LiDAR files in a map area drawn by the user.
Technologies: LiDAR, Azure, Azure SQL, Azure Blob Storage API, Data Engineering, GIS, Data Modeling, Relational Database Design, Database Architecture, Database Schema Design, Integration, Amazon S3 (AWS S3), Business Logic, Database Administration (DBA), Architecture, Data Management, Azure Synapse, Database Structure, Database Transactions, Transactions, SQL, Databases, Database Design, English
IT Manager
2018 - 2022
ASI Company
- Performed substantial changes on functionalities with low-performance problems, bringing them stability and high performance.
- Designed data models for legacy solutions and implemented new systems.
- Led the team in creating the new software architecture for the organization's solutions for the web and mobile environments.
- Reduced the cost with software maintenance, reorganizing the maintenance team keeping only senior developers with expertise in the legacy solution.
- Created a team for refactoring and modernizing solutions with the developers moved from the maintenance team. This action resulted in new contracts and a narrow scope of solutions.
- Implemented a solution using a business process management tool to monitor demands from clients and internal needs. This action resulted in a better SLA agreement between the company and the clients, increasing clients satisfaction.
Technologies: Management, Leadership, IT Governance, SQL, Node.js, Oracle, PostgreSQL, Vue, Flutter, T-SQL (Transact-SQL), PL/pgSQL, Oracle PL/SQL, Software Requirements Specifications (SRS), Negotiation, Planning, Agile Practices, ETL, PL/SQL Tuning, IT Strategy, SQL Server 2012, Innovation, Camunda BPM, Team Leadership, SQL Stored Procedures, Relational Databases, Database Modeling, Data Architecture, Microsoft SQL Server, Data Reporting, Business Intelligence (BI), Databases, Dimensional Modeling, Data Engineering, User Requirements, Data Pipelines, Data Governance, Data Cleaning, Spreadsheets, Data Analysis, Complex Data Analysis, Data Quality Analysis, JavaScript, MySQL, Database Performance, Dashboards, Reports, GIS, Database Design, Reverse Engineering, SQL Server DBA, Relational Database Design, Database Architecture, Database Schema Design, Reporting, Integration, Customer Relationship Management (CRM), Data Loading, Business Logic, MariaDB, PL/SQL, Oracle SQL, Database Administration (DBA), Oracle DBA, Microsoft Excel, Architecture, Oracle Database, Data Management, Database Structure, Database Transactions, Transactions, Requirements Analysis, Query Optimization
Business Process Specialist
2014 - 2018
Ministério da Educação - Brazilian Ministry of Education
- Created a 2000 lines PL/pgSQL code in 15 days to integrate three ministries that validate non-profitable institutions to tax exemption.
- Built a dimensional data model, DDL, and ETL SQL instructions to load data into the dimensional database.
- Designed dashboards to track processes performance using Microsoft Power BI and Qlik Sense.
- Mapped the business processes for two central secretariats within the Ministry of Education and proposed evolution, lowering costs and improving business performance.
- Owned two projects in the Ministry. The first aimed to regulate all higher education institutions in Brazil; the second included non-profitable education institutions nationwide.
Technologies: BPMN, BPM, SQL, PostgreSQL, PL/pgSQL, Software Requirements Specifications (SRS), Agile Practices, Qlik Sense, Microsoft Power BI, Bizagi Modeler, Team Leadership, Relational Databases, Data Analytics, ETL Development, Database Modeling, Data Architecture, Data Vaults, Data Reporting, Business Intelligence (BI), Databases, Dimensional Modeling, Data Engineering, User Requirements, Data Pipelines, Data Cleaning, Spreadsheets, Web Scraping, Data Analysis, Complex Data Analysis, Data Quality Analysis, PostGIS, JavaScript, MySQL, Database Performance, Dashboards, Reports, Database Design, Reverse Engineering, Google Analytics, Relational Database Design, Database Architecture, Database Schema Design, Reporting, Integration, Customer Relationship Management (CRM), Data Loading, Business Logic, PL/SQL, Oracle SQL, Microsoft Excel, Oracle Database, Database Structure, Database Transactions, Transactions, ETL, Requirements Analysis, Query Optimization
Senior Data Analyst | Senior System Analyst
2013 - 2014
ASI Company
- Defined the requirements and data models for an ERP solution in CRM, inventory, and warehouse management.
- Proposed new forms of managing and versioning the source code, requirements, and business documents.
- Implemented a requirement management framework based on my knowledge in CCMI certification.
Technologies: erwin Data Modeler, Software Requirements Specifications (SRS), Rational Unified Process (RUP), SQL Stored Procedures, Relational Databases, ETL Development, Database Modeling, Data Architecture, Microsoft SQL Server, Data Reporting, Business Intelligence (BI), Databases, Dimensional Modeling, Data Engineering, User Requirements, Data Pipelines, Data Cleaning, Spreadsheets, Data Analysis, Complex Data Analysis, Data Quality Analysis, UML 2, Object-oriented Design (OOD), Database Performance, Reports, Database Design, SQL Server DBA, Relational Database Design, Database Architecture, Database Schema Design, Reporting, Integration, Customer Relationship Management (CRM), Data Loading, Business Logic, PL/SQL, Oracle SQL, Database Administration (DBA), Oracle DBA, Microsoft Excel, Architecture, Oracle Database, Data Management, Database Structure, Database Transactions, Transactions, SQL, Requirements Analysis, Query Optimization
IT Consultant
2009 - 2013
Organization of Ibero-American States (OEI) for Education, Science and Culture
- Worked actively in the three most significant programs implemented by the Brazilian Ministry of Education, defining requirements, data structure, business rules, and technologies.
- Created a complex script to rank students applying for public universities using Oracle PL/SQL.
- Determined public policies for low-income students, indigenous people, and racial diversity by observing multiple data sources and defined the first decision-making logic within the Brazilian Ministry of Education.
- Led the IT team involved in the Ministry of Education programs during its execution, which occurred twice a year for each program.
Technologies: PostgreSQL, Oracle, PL/pgSQL, Oracle PL/SQL, Data Modeling, ETL, ETL Tools, Oracle GoldenGate, Software Requirements Specifications (SRS), Agile Practices, Scrum, SQL, Tableau, Leadership, Team Leadership, SQL Stored Procedures, Relational Databases, Data Analytics, Database Modeling, Data Architecture, Data Vaults, Data Warehousing, Data Reporting, Business Intelligence (BI), Databases, Dimensional Modeling, Data Engineering, User Requirements, Data Pipelines, Data Governance, Data Cleaning, Spreadsheets, Data Analysis, Complex Data Analysis, Data Quality Analysis, PostGIS, UML 2, Database Performance, Dashboards, Reports, Relational Database Design, Database Architecture, Database Schema Design, Reporting, Integration, Data Loading, Business Logic, PL/SQL, Oracle SQL, Oracle DBA, Microsoft Excel, Architecture, Oracle Database, Data Management, Database Structure, Database Transactions, Transactions, Requirements Analysis, Query Optimization
Tech Lead | Senior System Analyst
2007 - 2009
B2Br
- Provided consultancy services to a partner company on methodologies for developing, documenting, and validating software on-demand with governmental contracts.
- Created routines using a shell script to validate the amount charged from mobile calls within a Telecon client.
- Collaborated on the company CMMI certification, being responsible for requirement management.
Technologies: Oracle, ETL, Management, Consulting, Software Requirements Specifications (SRS), Data Modeling, Functional Point Analysis, Metrics, Team Leadership, SQL Stored Procedures, Relational Databases, Data Analytics, ETL Development, Database Modeling, Data Warehousing, Data Reporting, Databases, Data Engineering, User Requirements, Spreadsheets, Data Quality Analysis, UML 2, Object-oriented Design (OOD), Reports, Relational Database Design, Database Architecture, Database Schema Design, Reporting, Integration, Business Logic, Oracle SQL, Oracle DBA, Microsoft Excel, Oracle Database, Database Structure, Database Transactions, Transactions, SQL, Requirements Analysis, Query Optimization
Tech Lead | Senior System Analyst
2005 - 2007
CTIS
- Designed the data model and SRS (Software Requirement Specifications) for an ARV (antiretroviral) distribution logistics system for AIDS treatment nationally.
- Defined internal activities related to software requirement management to certify the company on CMMI level 2.
- Outlined how components should communicate within the architecture as the tech lead.
- Provided internal consultancy for other teams on software requirement management, data modeling, and SQL performance tuning.
- Measured several software sizes using function point analysis.
Technologies: Oracle, Oracle PL/SQL, Software Requirements Specifications (SRS), Requirement Traceability Matrices, Capability Maturity Model Integration (CMMI), Java 6, Metrics, Functional Point Analysis, Team Leadership, SQL Stored Procedures, Relational Databases, Database Modeling, Data Architecture, Data Reporting, Databases, User Requirements, Spreadsheets, UML 2, Object-oriented Design (OOD), Reports, Relational Database Design, Database Schema Design, Reporting, Integration, Business Logic, Oracle SQL, Oracle DBA, Microsoft Excel, Oracle Database, Database Structure, Database Transactions, Transactions, SQL, Requirements Analysis, Query Optimization
Junior System Analyst | System Analyst
2000 - 2005
Indra - Politec
- Designed data flow diagrams and integrated them with data models across the entire company during my first professional year working in IT.
- Used UML to document the software developed within the company.
- Measured several systems using function point analysis.
- Created data models and wrote SQL queries for many systems.
- Used Natural, Cobol, and IBM DB2 as programming languages.
Technologies: NATURAL, IBM Db2, Software Requirements Specifications (SRS), Data Modeling, SQL, Data Flow Diagram (DFD), erwin Data Modeler, UML, COBOL, Relational Databases, Database Modeling, Data Architecture, Data Reporting, Databases, User Requirements, Spreadsheets, UML 2, Object-oriented Design (OOD), Relational Database Design, Database Schema Design, Reporting, Business Logic, Microsoft Excel, Database Structure, Database Transactions, Requirements Analysis, Query Optimization
Experience
SiSU - Sistema de Seleção Unificada (Unified Selection System)
https://sisu.mec.gov.br/SiSU is a Brazilian public program that standardizes student entry in Brazilian public universities all over the country with just one test.
I was in charge of defining software requirements, business requirements, data modeling, SQL procedures, and tunning SQL instructions in this project. I also built the database to receive more than 15 million insert operations and 100 million reading operations in a five-day window.
In addition, I designed the ranking logic and procedure to correctly order all the students within each course available on the platform.
I was in charge of defining software requirements, business requirements, data modeling, SQL procedures, and tunning SQL instructions in this project. I also built the database to receive more than 15 million insert operations and 100 million reading operations in a five-day window.
In addition, I designed the ranking logic and procedure to correctly order all the students within each course available on the platform.
FIES - Higher Education Student Financing Fund
https://sisfiesportal.mec.gov.br/FIES is a Brazilian governmental program that aims to provide funding for students willing to take higher education degrees. I worked on integrations between the Brazilian Ministry of Education and the banks financing students. My main activities were designing data models, creating PL/pgSQL scripts to process information gathered from multiple banks, and developing analytical reports for decision-making.
SICON (Conditionality System for Bolsa Família)
"Bolsa Família" was a social assistance program that helped millions of Brazilians living with a family income lower than the minimum wage. To apply for the support, the families should follow some rules regarding children's health care and education. This system monitored those families by consolidating and processing all the information gathered by all the Brazilian city halls.
My role in this project was to design de database structure, create the PL/SQL scripts to process that information, and enable finding families that were not complying with the program's rules and finding frauds within the program.
My role in this project was to design de database structure, create the PL/SQL scripts to process that information, and enable finding families that were not complying with the program's rules and finding frauds within the program.
DST-AIDS (Drug Logistics Control)
DST-AIDS was a Brazilian system to manage the distribution of antiretroviral (ARV) drugs for AIDS treatment nationwide. It was developed in 2007 and was my first project as a tech lead.
I led the tech team, managed software requirements, designed the data model, created the most complex SQL instructions used by the software, and wrote PL/SQL code.
I led the tech team, managed software requirements, designed the data model, created the most complex SQL instructions used by the software, and wrote PL/SQL code.
Skills
Languages
SQL, PL/pgSQL, T-SQL (Transact-SQL), UML 2, UML, Python, JavaScript, Java 6, NATURAL, COBOL, Snowflake, Cypher
Tools
pgAdmin, GIS, Bizagi Modeler, Camunda BPM, Tableau, Apache Airflow, Qlik Sense, Microsoft Power BI, Oracle GoldenGate, Sybase PowerDesigner, IBM Cognos, Spreadsheets, Google Analytics, Domo, Microsoft Excel, IBM Data Studio
Paradigms
Management, ETL, BPMN, Scrum, Object-oriented Design (OOD), Dimensional Modeling, Business Intelligence (BI), Database Design, Requirements Analysis, Object-oriented Programming (OOP), Data Science
Platforms
Oracle, Jupyter Notebook, Oracle Database, Azure, Apache Kafka, Azure Synapse
Storage
Oracle PL/SQL, PostgreSQL, IBM Db2, Oracle SQL Developer, SQL Stored Procedures, MySQL, Data Pipelines, Databases, Microsoft SQL Server, Relational Databases, Database Modeling, Azure SQL, Database Architecture, PL/SQL, Oracle SQL, Database Administration (DBA), Oracle DBA, Database Structure, Database Transactions, MongoDB, NoSQL, Database Performance, Azure Cosmos DB, SQL Server DBA, MariaDB, PostGIS, SQL Server 2012, Neo4j, JSON, Amazon S3 (AWS S3)
Other
Leadership, Strategy, Data Visualization, Data Modeling, Agile Practices, Data Engineering, Business Requirements, User Requirements, Software Requirements Specifications (SRS), Data Analysis, ER/Builder, erwin Data Modeler, Software Development, Capability Maturity Model Integration (CMMI), IT Governance, Negotiation, Planning, PL/SQL Tuning, IT Strategy, Innovation, BPM, ETL Tools, Requirement Traceability Matrices, Metrics, Functional Point Analysis, Team Leadership, Analytics, Data Architecture, Data Governance, Data Reporting, Data Analytics, Data Warehousing, ETL Development, Data Vaults, Data Cleaning, Complex Data Analysis, Data Quality Analysis, Dashboards, Reports, Reverse Engineering, Relational Database Design, Database Schema Design, Reporting, Integration, Data Loading, Business Logic, Star Schema, Architecture, Data Management, Transactions, Query Optimization, Web Scraping, User Experience (UX), User Interface (UI), Customer Relationship Management (CRM), Azure Data Factory, English, Machine Learning, IBM Cloud, Artificial Intelligence (AI), Bokeh, Apache Cassandra, Consulting, Data Flow Diagram (DFD), Technical Leadership, Task Scheduling, Background Jobs, LiDAR, Mentorship, PolyBase
Frameworks
Rational Unified Process (RUP), Apache Spark, Flutter, Spark
Libraries/APIs
Pandas, NumPy, Matplotlib, Beautiful Soup, Node.js, Vue, Azure Blob Storage API
Education
2002 - 2005
Bachelor's Degree in Information Systems
Centro Universitário Euroamericano (UNIEURO) - Brasília, Brazil
Certifications
SEPTEMBER 2021 - PRESENT
SQL (Intermediate) Certificate
HackerRank
SEPTEMBER 2021 - PRESENT
Strategic Leadership and Management
Coursera
FEBRUARY 2020 - PRESENT
IBM Data Science Professional Certificate
Coursera
DECEMBER 2019 - PRESENT
Introduction to Data Science
Coursera
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