Diego | Data Analyst | Statistics | Data-Driven | Analytical thinking | Business Intelligence | Excel - SQL - Power BI - Tableau - Python

Diego

About

Data Analyst with a focus on generating insights, analytical thinking, and problem-solving. I worked as a Data Analyst in the fleet logistics sector for three years at a toll company. My primary responsibilities included data extraction from the database using SQL queries, data cleaning and organization in Excel, analysis and insights generation, and the creation of dashboards in Power BI, followed by presentations to the board. As a Data Analyst, I had the opportunity to achieve significant results for the company, such as reducing vehicle fuel consumption by up to 9%, lowering vehicle maintenance costs by up to 3%, and optimizing incident response time by up to -6 minutes, all based on critical data analysis.

Skills

Projects

Covid Numbers in 2021

This project consists of an analysis on the numbers of Covid in the world. I used Microsoft Excel to partially clean the data downloaded from the Database and later imported it on MySQL. On MySQL I extracted and cleaned the data to be used. Later I used Tableau for Data Visualization.

Data Cleansing - SQL (Nashville housing)

Data Cleansing using SQL queries. Data source: Nashville housing.

People Analytics: redução de Turnover

Uma empresa de wholesale identificou um aumento significativo em sua taxa de turnover no ano de 2023. Essa análise foi realizada com intuito de responder a seguinte questão: Quais políticas/fatores da empresa deveriam mudar de forma a minimizar o turnover? Link no medium.

Fintech: controle da inadimplência em operações de crédito.

A YourCredit Bank (nome fictício) é uma fintech de Crédito que apresentou altos índices de inadimplência. Esse estudo busca responder à questão: Quais fatores de risco estão mais associados a inadimplência? Com isso, o que a fintech deveria mudar de forma a minimizar a inadimplência?

Agro Analytics: precificação de garantias de crédito por safras de Café

O AgroCoop Bank (nome fictício), especializado no setor agropecuário, busca otimizar seus processos de precificação das garantias oferecidas pelos clientes ao solicitar crédito. No entanto, o AgroCoop Bank enfrenta desafios na avaliação precisa das sacas de café oferecidas como garantia.

Health Analytics: Otimização de Custos de Plano de Saúde

A H.Y Health Insurance (nome fictício) é uma operadora de planos de saúde corporativos. Objetivos: 1) Identificar quais fatores estão mais relacionados com o Custo do Plano de Saúde da empresa. 2) Apontar quais tipos de ações preventivas a empresa pode tomar para reduzir esse custo.

Experience

2016-2019

Data Analyst

Caminhos do Parana S/A This is a highway toll collection company with a large fleet of operational vehicles. All vehicle incidents are recorded on tablets and sent to the database. As a Data Analyst in the Fleet Department, my responsibilities included: - Extracting data from the database using SQL. - Cleaning and organizing data in Microsoft Excel. - Creating dashboards in Power BI and preparing reports and presentations for the executive team. - Providing data-driven insights to enhance field operation efficiency. Some achievements I accomplished as a Data Analyst, based on data analysis, were: - Achieved a 9% reduction in fuel consumption across the entire fleet (utilizing fuel consumption and mileage metrics). - Reduced vehicle maintenance costs by 3%.

Education

Ponta Grossa State University

Geographical Engineering

2023-2024 Datascy

Master Certificate of Data Science & Analytics

Workload: 120 hours.