I am from Florianópolis, a beautiful city located in the south of Brazil. I hold a degree in Computer Science from the University of Southern Santa Catarina (UNISUL) and have been a technology professional for over 20 years. Throughout my career, I have worked on diverse projects in various business areas, assuming roles such as developer, analyst, and project manager. As an entrepreneur, I founded my own company and developed a platform for the corporate communication market. Currently, I also work on international data engineering projects.
My job consists of structuring and analyzing data, being responsible for processes such as Data Architecture, ETL, Pipelines, up to the final analysis and construction of dashboards for supporting Business Decisions.
ETL process aimed at integrating data related to Google Ads (AdWords) campaigns into a Data Warehouse.
Stack : Azure Blob Storage, Azure Data Factory, SQL Server
The sync process leverages SQL Server Change Tracking to capture modified data, temporarily store it, and apply it to the target environment using ADF pipelines. Inserts, updates, and deletes are executed in the correct order to ensure referential integrity.
Stack : Azure Data Factory and SQL Server
NovaDrive is a data engineering project for an automotive company, focused on building scalable pipelines and infrastructure to manage and analyze high-quality vehicle data.
Stack : AWS, Airflow, Snowflake, DBT
SigeCom is a platform designed for communication and public relations companies. This is a BI project designed to provide metrics for performance analysis of communication agencies.
Stack : SQL Server, Pentaho, Power BI, ERwin
XKLog is a trusted transportation company that offers streamlined logistics solutions.
Stack : Azure, My SQL, Power BI
Here we have a case study using the fictional Northwind Traders database, where a data analysis was conducted to generate insights and recommendations in 5 different areas : Sales, Products, Customers, Employees and Logistics
Stack : Azure, SQL Server, Power BI
Knowledge and experience in designing and developing interactive dashboards and reports using Power BI, which can extract and analyze data from various sources such as Excel spreadsheets, SQL databases, and cloud-based services. I am experienced in using Power Query to clean and transform data, DAX language to create custom calculations and measures, and Power BI visualizations to create insightful and visually appealing reports.
My expertise includes writing complex SQL queries to extract, transform, and analyze data from various databases, including PostgreSQL, MySQL, and SQL Server. I am experienced in designing and implementing database structures, creating database objects such as tables, views, and stored procedures, and optimizing database performance using indexing and other techniques.
Web application development, both front-end and back-end, designing and developing ASP.NET web applications using various technologies such as HTML, CSS, JavaScript, and C#. I am experienced in working with ASP.NET MVC (Model-View-Controller) and ASP.NET Web API to create scalable and maintainable web applications.
I specialize in designing and implementing data solutions on Azure, with a strong focus on leveraging key Azure data services including Azure Data Factory, Azure Synapse Analytics, and Azure Databricks. My experience encompasses extracting, transforming, and loading (ETL) data to support scalable and efficient data workflows.I have also participated in projects using AWS data services
My expertise includes designing ETL/ELT processes, developing scripts, and optimizing performance using tools such as Azure Data Factory, Airflow, Pentaho and SSIS.I am experienced in working with various types of data sources, including structured, semi-structured, and unstructured data.
I possess strong knowledge and experience in data modeling and data warehousing, including designing and developing conceptual, logical, and physical relacional and dimensional data models, using tools such as ERwin, PowerDesigner, and ER/Studio.
Knowledge and experience in Python data analytics, including data cleaning, data wrangling, and data visualization. using libraries such as Pandas, NumPy, Matplotlib, and Seaborn to analyze and visualize data.
I am experienced in identifying patterns, trends, and insights in data, and presenting them in a clear and concise manner. Additionally, my excellent communication skills enable me to effectively collaborate with the stakeholders to ensure the data analysis aligns with business requirements.