Luis Otavio’s Curriculum

Academic education

University Federal of Minas Gerais, Master’s degree in Demography, Mar/2025 – Dec/2026

University Federal of Minas Gerais, Bachelor’s degree in Statistics, Mar/2020 – Aug/2024

Work Experience

Banco Mercantil / Data Analyst - Credit Products JANUARY 2025 - now

Blip / Data Analyst JULY 2024 - JANUARY 2025

Some developed activities:

  • Monitoring and Improvement of Business Indicators;

  • Conducting A/B Testing;

  • Dashboard Creation and Enhancement;

  • Customized Notebooks for Different Data Analyses;

  • Discussion on Data Storage.

Pottencial Seguradora / Actuarial and Reinsurance Intern DECEMBER 2022 - JULY 2024

Some developed activities:

  • Automation of Risk Accumulation reports using Power BI.

  • Allocation and control of Risks according to Reinsurers’ cessions.

  • Audit and Validation of Reinsurance Premiums and Claims.

  • Transformation, loading, and validation of data in databases to enhance the reliability of information in report delivery;

Creation of dashboards using Power BI to simplify processes and reduce the time required, turning hours into minutes;

  • Maintenance of automated Python scripts for data transfer to SQL, aiming to improve process efficiency and reliability;

  • Creation of R scripts to generate automatic reports periodically, with just one click;

  • Creation of SQL scripts for data manipulation, query optimization, and data utilization.

Brazilian public policy observatory with the homeless population/ Extension Student SINCE APRIL 2023, REMOTE

Some developed activities:

  • Contribution to the development and promotion of laws regarding the homeless population.

  • Production of Technical Reports presenting profile data of the homeless population across all Brazilian states, including all cities and the Federal District.

  • Automated data extraction using web scraping from Cad Único: automation of data collection, saving time and enabling access to a wide range of data sources.

  • Loading and manipulation of databases: data preparation and organization for analysis.

  • Analysis of processed data, generating insights: creation of tables, charts, and comparisons, as well as identification of key summary measures.

  • Study published on G1 presenting a historical series and encouraging discussion on the topic: https://g1.globo.com/sp/sao-paulo/noticia/2023/04/05/cidade-de-sp-contabiliza-mais-de-52-mil-moradores-de-rua-alta-de-82percent-em-2023-afirma-pesquisa.ghtml

Statistics Department of the Pro-Rectorate of Undergraduate Studies at UFMG/ Intern MAY 2021 - DECEMBER 2022, BELO HORIZONTE

Focus on the development of reports for dissemination and assistance in decision making from the results.

Some projects:

  • Automation and optimization of periodic reports (Rmarkdown) in an agile and efficient manner;

  • Loading, transformation/manipulation of data;

  • Application of statistical techniques in analysis, such as the Kohonen neural network, for example;

  • Studies related to the impacts of changes that have occurred over time at the university;

  • Automatic creation of reports using RMarkdown for various UFMG courses, aiming to save time;

Some results:

Skills

Key Competencies

  • Experience with different types of data;

  • Experience in cleaning, transforming and loading data;

  • Problem-solving skills;

  • Ease of adapting to new environments;

  • Ability to learn new skills quickly;

  • Ability to communicate results in a cohesive and clear way, effective communication;

Data Extraction, Analysis and Presentation

  • SQL;
  • Excel/Sheets;
  • Python;
  • R;
  • Power BI;
  • Word/Docs;
  • Power Point/Presentation;

Technical Abilities

  • Probability;
  • Statistical tests of significance;
  • Sampling;
  • Inference;
  • Multivariate Statistics;
  • Time Series - Forecast;
  • Machine Learning;
  • Data Description and Presentation;
  • Discrete Data Modeling;
  • Generalized Linear Models;
  • Bayesian Inference;
  • Regression Models;

Languages

English B2 and Native in Portuguese.

Hobby

Gym, running, games and series.