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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.