Author Image

Hi, I am Diogo.

Diogo Dantas



Professional with experience in analyzing and interpreting data for strategic business decisions.
Focused on transforming data into valuable insights through quantitative analysis and accurate reporting.
Skills in SQL, Python and BI tools.
Degree in Systems Analysis and Development, studying 6th semester mathematics with a strong analytical background and a commitment to data accuracy and meeting deadlines.




Team Work
Logical Reasoning
Analytical Thinking
Adaptability
Troubleshooting
Time Management

Skills

Professional background

1
Gi Group

Jul 2013 - Aug 2024

São Bernardo do Campo - SP

Resident service provider at Volkswagen.

Controller

Jul 2013 - Aug 2024

Responsibilities:
  • I structured unstructured databases for financial analysis, with SQL queries (for data cleaning and cross-checking) and extractions via SAP HANA IDE, ensuring accuracy and strategic insights.
  • Performed exploratory analysis using Pandas, Matplotlib and Seaborn in a Jupyter environment, validating operational data integrity (employee data, meals) with a focus on consistency, detection of outliers and hidden patterns, generating interactive visualizations and interpretable reports to identify cost/operational optimization opportunities.
  • I critically analyzed vehicle occupancy data, linking route, shift and cost information to suggest optimizations in line with operations. I used table queries to propose reallocating employees between shifts, resulting in 30% fewer trips/day.
  • Documented and presented savings proposals through reports, Business Cases in Excel and PowerPoint presentations, ensuring buy-in from the operational team.
  • Extracted restaurant access and meal volume data via SQL (Graphical User Interface), creating scripts to consolidate occupancy and cost KPIs, which enabled the reduction of 2 restaurants.
  • I developed dashboards in Excel and Power Bi to monitor fixed/variable food and transportation costs, with alerts for deviations, generating precision in planning and annual budget savings.
  • I critically analyzed employee flow data x menu information, identifying volumes and presenting data to the Purchasing sector to renegotiate incidences and save on contracts.
  • Collaborated with cross-functional teams to meet administrative and operational demands.
  • Use of advanced tools in the Office package, Power BI (DAX, Power Query), SAP, Senior and K-SRM (general ABAP purchasing system).

São Bernardo do Campo - SP

Personalised support for clients such as Cimpor, JSL Logística and Intercement.

Administrative assistant

Jun 2011 - Jun 2013

Responsibilities:
  • Assisted in gathering information from users for the development of telecom systems.
  • Assisted in the implementation and maintenance of systems, as a focal point for clients. Preparing tests, analyzing technical problems and proposing solutions.
  • I input costs and managed telecom assets, ensuring the optimization of resources and efficient control of investments.
  • I prepared detailed management reports and dashboards to provide actionable insights to leadership and support strategic decision-making.
2

3
Banco do Brasil

Feb 2010 - Dec 2010

São Paulo - SP

Internship in the Banco do Brasil building (Historic Centre of SP).

Accounting intern

Feb 2010 - Dec 2010

Responsibilities:
  • Preparation of statistical calculations, invoicing, identification of document batches, customer support, telephone support for agencies and preparation of control tables.
  • Logistics for ATM service and maintenance.

Education

2022-2026
Degree in Mathematics
Taken Courses:
  • Statistics, Analytical Geometry and Linear Algebra, Logic and Discrete Mathematics, Calculus, Physics and General subjects, among others.
2017-2019
Systems Analysis and Development
Taken Courses:
  • Algorithms and Data Structure, Cloud Computing and Devops, Mobile Development, Applied Agile Software Engineering, Object-Oriented Systems Analysis, Database Programming, Mathematics and Statistics, NOSQL Database Modeling, among others.
2020-2021
Data Science - Lato Sensu Specialisation
Taken Courses:
  • Big Data Architecture, Data Collection and Storage, Big Data Processing, Statistical Analysis, Data Visualization, Data Mining and Analysis.
2012-2015
Bachelor of Accounting Sciences
Taken Courses:
  • Cost Analysis, Financial Mathematics, Financial Planning and Budgeting, Cost and Industrial Accounting, Tax Accounting and Tax Planning, Working Capital and Financial Analysis, among others. Enrolment locked in 3rd year.

Recent Projects

Accomplishments

Extract, Transform and Load Data in Power BI
Microsoft Feb 2025

Python Project for Data Engineering
IBM Sep 2024

Databases and SQL for Data Science with Python
IBM Oct 2024

Relational Database Administration (DBA)
IBM Nov 2024

Associate Data Engineer in SQL
Datacamp Jun 2024

Java com Orientação a Objetos
Alura Feb 2022

Python com Orientação a Objetos
Alura Jul 2022

Design Patterns em Java I e II
Alura Mar 2022