Highlights:Built a dashboard to track the evolution of Publicis Groupe's media investment in Brazil and the group's revenue generation. The scale of this project was around half a billion dollars of gross investment.

Skills:Python, SQL, Data Analysis, Business Intelligence

Goal:Work as a data analyst, transforming data from various sources into business insights.

Senior Data Analyst 08/2024 - current
Media Hero, São Paulo, São Paulo Brazil
Industry: Marketing
Responsible for understanding the challenges and requirements of the marketing and advertising industry to optimize clients' budget allocation.
— Regularly interacts with clients to understand their business strategies, marketing investments, and targets. — Analyses client data to ensure it is sufficient to ensure the quality of Machine Learning models. — Regularly interacts with data scientists, engineers, and developers to propose improvements in data extraction, transformation, loading, storage, and visualization. — Responsible for automating ETL, dashboard design, and data analysis to generate insights. — Plans and executes improvements, enhancing the use of artificial intelligence in the product to increase the efficiency of recommendations. — Develops new features in the product based on customer requests to improve marketing investment allocation recommendations. — Ensures that processes align with data privacy and protection standards.--
Squad Leader 05/2024 - current
Bichinhos da TI, São Paulo, São Paulo Brazil
Industry: Education
Volunteer work that helps professionals from different backgrounds to transition their careers into data science.
— Lead a squad of 8-12 volunteer data professionals, including analysts, engineers, and scientists. — Oversee multiple data projects from conception to completion. — Engage with stakeholders to gather requirements about data products. — Mentor team members, fostering their learning, development, and professional growth. — Measure the impact of data projects on organizational goals.--
Senior Data Analyst 10/2022 - 08/2024
Publicis Groupe Brasil, São Paulo, São Paulo Brazil
Industry: Marketing
Built a dashboard to track the evolution of Publicis Groupe's media investment in Brazil and the group's revenue generation. The scale of this project was around half a billion dollars.
— Developed a solution to monitor the media investment (over R$1B) managed by Publicis Groupe and forecast the revenue generation via incentive plans (over R$100M). — Participated in the development of Deepo: Publicis Groupe Brazil's media data management tool. — Responsible for implementing Deepo on more than 15 clients: modeled, configured, and automated data extraction according to each client's needs. — Streamlined the Deepo implementation process for clients, reducing implementation time from 3 months to less than 2 weeks. — Responsible for the integrity of data extracted from media platforms through SQL queries to the database. — Promoted a new business front by providing tagging consultancy services using Google Tag Manager for 3 new clients, demonstrating autonomy and proactivity. — Presented SQL as a new tool to analyze consumption patterns at CDP Treasure Data, later migrating these analyses to Google BigQuery. Reduced the time needed to carry out exploratory analyses by 50%. — Developed more than 30 dashboards using Looker, Metabase, and PowerBI.--
Business Intelligence Analyst 06/2021 - 09/2022
Oslo Performance Criativa, Rio de Janeiro, Rio de Janeiro Brazil
Industry: Marketing
Held responsibility for the agency's ETL and BI process, serving around 15 clients.
— Fine-tuned data extractions in Supermetrics, reducing the incidence of extraction errors by more than 50%. — Streamlined transformations in Power Query, reducing dashboard update times by around 30%. — Developed more than 20 dashboards in PowerBI, customizing data visualization to each client's needs. — Developed measures in DAX to analyze the evolution of the main performance indicators, emphasizing measures for comparing KPIs weekly, month by month, and year by year. — Developed the measurement paradigm on the websites of more than 10 clients and implemented data collection using Google Tag Manager, with emphasis on the initial configuration of Google Analytics 4. — Performed customer segmentation (RFM and Cohort) using Google Analytics data. — Demonstrated his crisis management skills when dealing with unforeseen delivery problems for two clients. — Applied agile methods to gather requirements, obtain feedback, and organize deliveries for each client.--
Graduate Research Student 03/2018 - 08/2020
Universidade Federal Fluminense, Volta Redonda, Rio de Janeiro Brazil
Industry: Engineering
Developed a numerical model in Fortran to simulate the effect of clusters on phase transformation kinetics.
— Carried out extensive data analysis based on the numerical model results. — Presented papers at 5 scientific conferences and published an article on phase transformation phenomena in a journal. — Completed an internship in Programming and Numerical Methods classes, with more than 50 students. — Demonstrated his oratory, communication, and didactic skills while delivering classes. — Wrote a dissertation on the subject based on the results found.--

Universidade Federal Fluminense 08/2013 - 12/2017
Volta Redonda, Rio de Janeiro, Brazil
Degree: Bachelor's Degree
Major:Mechanical Engineering
Relevant coursework: — Classical and Quantum Mechanics. — Prototype Development. — Mechanical Design.

data analyst Data Analyst, Business Intelligence, Python, SQL