Learn Data Skills
Rodrigo Modesto

Rodrigo Modesto

Data Analyst

Planning | Goiรขnia

Technologies

Transforming complex data into actionable insights that drive strategic decisions and business results for managers and stakeholders.

DataCamp Course Completion

Take a look at all the courses Iโ€™ve completed on DataCamp.

Courses

Introduction to Python
Introduction to Power BI
Intermediate Python
Intermediate SQL

My Work Experience

Where I've interned and worked during my career.

Grupo Planning | Jan 2024 - Feb 2025

Senior Data Analyst

๐Ÿ”‘ ๐—ž๐—ฒ๐˜† ๐—ฅ๐—ฒ๐˜€๐—ฝ๐—ผ๐—ป๐˜€๐—ฎ๐—ฏ๐—ถ๐—น๐—ถ๐˜๐—ถ๐—ฒ๐˜€ โ€ข Data Management: collecting and integrating data from diverse sources; cleaning and preparing data using SQL, BigQuery, Python, and Alteryx. โ€ข Advanced Data Views: creating complex views in BigQuery and SQL Server, based on tax reports, for use in Power BI. โ€ข Dashboard Development: designing interactive and intuitive dashboards/reports for internal (consulting team) and external clients using Power BI and Figma. โ€ข UX/UI Application: employing UX/UI principles for report backgrounds, ensuring they meet client-specific utility, usability, and desirability through Figma. โ€ข Exploratory Analysis: conducting data analysis in Power BI to uncover trends and patterns. โ€ข Stakeholder Engagement: interpreting results and presenting insights to key stakeholders. โ€ข Performance Monitoring: tracking KPI's and performance metrics in Power BI to support data-driven decisions. โ€ข Business Optimization: using Python to optimize business processes. โ€ข Team Collaboration: working with multidisciplinary teams, including IT, consulting, marketing, and HR. โ€ข Documentation: developing technical and process documentation, particularly in Figma. โ€ข Workspace Management: overseeing workspaces and permissions for Power BI's semantic model. ๐Ÿฅ‡ ๐—”๐—ฐ๐—ฐ๐—ผ๐—บ๐—ฝ๐—น๐—ถ๐˜€๐—ต๐—บ๐—ฒ๐—ป๐˜๐˜€ ๐—ฎ๐—ป๐—ฑ ๐—”๐—ฐ๐—ต๐—ถ๐—ฒ๐˜ƒ๐—ฒ๐—บ๐—ฒ๐—ป๐˜๐˜€ โ€ข BI System Development: created a comprehensive BI system mapping the analyst journey in fiscal analyses, enhancing productivity by 70%. Integrated extensive company data to provide detailed financial views and insights into key products, suppliers, and transactions. โ€ข BI Management Report: developed a management BI report based on Microsoft Planner activities, effectively quantifying task stages and progress. This initiative reduced process stage times by 30%. โ€ข Custom BI Report: designed a detailed BI report for a major agriculture group, covering financial assessments such as gross revenue and net profits for farms focused on cattle and soybean.
Show More

Omnisaude | Sep 2023 - Feb 2024

Data Analyst

๐Ÿ”‘ ๐—ž๐—ฒ๐˜† ๐—ฅ๐—ฒ๐˜€๐—ฝ๐—ผ๐—ป๐˜€๐—ฎ๐—ฏ๐—ถ๐—น๐—ถ๐˜๐—ถ๐—ฒ๐˜€ โ€ข Data Management: collecting and integrating data from diverse sources; cleaning and preparing data using PostgreSQL, OrangeSQL, Python, and Alteryx. โ€ข Advanced Data Views: creating complex views in PostgreSQL, OrangeSQL, based on billing and receipts, regulation processes, supply management, the development of medical accounts, accounts payable, and accounts receivable, for use in Power BI. โ€ข Dashboard Development: designing interactive and intuitive dashboards/reports for stakeholders and other employers using Power BI and Figma. โ€ข UX/UI Application: employing UX/UI principles for report backgrounds, ensuring utility, usability, and desirability through Figma. โ€ข Exploratory Analysis: conducting data analysis in Power BI to uncover trends and patterns. โ€ข Stakeholder Engagement: interpreting results and presenting insights to key stakeholders. โ€ข Performance Monitoring: tracking KPI's and performance metrics in Power BI to support data-driven decisions. โ€ข Business Optimization: using Python to optimize business processes. โ€ข Documentation: developing technical and process documentation in Figma about Philips Tasy. โ€ข SQL Queries: validation of the KPI values, measures, and visuals used in Power BI. ๐Ÿฅ‡ ๐—”๐—ฐ๐—ฐ๐—ผ๐—บ๐—ฝ๐—น๐—ถ๐˜€๐—ต๐—บ๐—ฒ๐—ป๐˜๐˜€ ๐—ฎ๐—ป๐—ฑ ๐—”๐—ฐ๐—ต๐—ถ๐—ฒ๐˜ƒ๐—ฒ๐—บ๐—ฒ๐—ป๐˜๐˜€ โ€ข BI System Development: I developed dashboards and reports covering various areas of the company, including contract management, business and financial indicators, monitoring of billing and receipts, regulation processes, supply management, the evolution of medical accounts, accounts payable, and accounts receivable. Additionally, I conducted billing analyses, prepared financial management reports, and constructed the Income Statement. These reports helped create an action plan that reduced the company's claim frequency by 20% over a period of 3 months.

Agora - Fรกbrica de Resultados | Jan 2022 - Sep 2023

Data Analyst

๐Ÿ”‘ ๐—ž๐—ฒ๐˜† ๐—ฅ๐—ฒ๐˜€๐—ฝ๐—ผ๐—ป๐˜€๐—ฎ๐—ฏ๐—ถ๐—น๐—ถ๐˜๐—ถ๐—ฒ๐˜€ โ€ข Data Management: collecting and integrating; cleaning and preparing data using Power Query. โ€ข Dashboard Development: designing interactive and intuitive dashboards/reports for stakeholders and other employers using Power BI and Figma. โ€ข UX/UI Application: employing UX/UI principles for report backgrounds, ensuring utility, usability, and desirability through Figma. โ€ข Exploratory Analysis: conducting data analysis in Power BI to uncover trends and patterns. โ€ข Stakeholder Engagement: interpreting results and presenting insights to key stakeholders. โ€ข Performance Monitoring: tracking KPI's and performance metrics in Power BI to support data-driven decisions. โ€ข Team Collaboration: working with multidisciplinary teams, including sales, consulting, and marketing. โ€ข Mystery Shopper Surveys: formulation and management of surveys, using Google Forms as a tool to generate critical customer service quality indicators. โ€ข SQL Queries: validation of the KPI values, measures, and visuals used in Power BI. ๐Ÿฅ‡ ๐—”๐—ฐ๐—ฐ๐—ผ๐—บ๐—ฝ๐—น๐—ถ๐˜€๐—ต๐—บ๐—ฒ๐—ป๐˜๐˜€ ๐—ฎ๐—ป๐—ฑ ๐—”๐—ฐ๐—ต๐—ถ๐—ฒ๐˜ƒ๐—ฒ๐—บ๐—ฒ๐—ป๐˜๐˜€ โ€ข BI System Development: I developed interactive dashboards and financial reports that simplify the visualization and interpretation of complex data, empowering clients to make well-informed strategic decisions by transforming raw data into actionable insights. Beyond data analysis, I have played a crucial role in designing intuitive data visualizations using Figma, greatly enhancing the communication of key insights to stakeholders. These visual tools had been instrumental in bridging the gap between complex analytics and clear, actionable strategies. By seamlessly integrating these capabilities, I have consistently contributed to the creation of data-driven strategies that have led to substantial improvements in customer service standards and produced tangible financial gains. In several instances, my initiatives have resulted in boosting client sales by up to 80%.

My Education

Take a look at my formal education

Associate's degree in Data AnalyticsXperiun | 2024
Associate's degree in Data ScienceEscola DNC | 2023
Master of Business Administration (MBA) in Project ManagementIPOG - Instituto de Pรณs-Graduaรงรฃo e Graduaรงรฃo | 2018
Bachelor's degree in Civil EngineeringPontifรญcia Universidade Catรณlica de Goiรกs | 2017
Postgraduate's degree in Occupational Safety EngineeringFaculdade de Estudos Administrativos de Minas Gerais | 2016
Bachelor's degree in Food EngineeringUniversidade Federal de Goiรกs | 2010

About Me

Rodrigo Modesto

As a skilled Data Analyst with more than 3 years of experience, I specialize in developing interactive dashboards and conducting in-depth analyses using tools and languages like Power BI, SQL, Python, Alteryx, Figma, GCP (BigQuery), Git, R, Excel.

Powered by

  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free