Learn Data Skills
João Antonio Bandeira

João Antonio Bandeira

Data Analytics Lead

Estée Lauder


My Portfolio Highlights

My New Course

Introduction to Python

Data enthusiast, embracing the beauty of numbers and algorithms.

My Work

Take a look at my latest work.


Understanding Data Engineering


Introduction to SQL


Introduction to Python

My Certifications

These are the industry credentials that I’ve earned.

Other Certificates

Dell Technologies Data Science Associate

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

The Estée Lauder Companies Inc. | Apr 2022 - Present

Team Lead | Data Analytics

Key Responsibilities: - Manage a new team of data analytics experts, coaching them on the development of innovative ways to solve complex analytical problems. - Lead the adoption of new analytical tools like Alteryx and Databricks. - Lead the development of advanced analytics and data science projects. - Be a trusted advisor inside the OneSource Analytics team on the use of programming languages like Python, SQL and DAX and on subjects like Machine Learning, ETL and process automation.
Show More

The Estée Lauder Companies Inc. | Jan 2021 - Apr 2022

Team Lead | Business Process Automation

Key Responsibilities: - Manage a small team of automation experts, coaching them to reach their full potential and help them to provide a positive impact to the business; - Develop innovative solutions able to create efficiency and improve accuracy of processes and reports across finance and supply chain through the use of analytical tools like Power Query, Power Pivot, Power BI, Python, MDX/SQL, VBA, Knime, UiPath etc. - Be a trusted advisor on the data analytics and automation areas, leading and supporting the implementation of new financial tools, best practices, process improvements and capacity creation initiatives; Main Achievements; - Responsible for leading initiatives that resulted in more than 6,000 annual hours of capacity created (~3 FTEs) and for mentoring many other automation projects, helping the team to overachieve capacity creation targets in FY21 and FY22. - Developed an automated employee cost planning tool used by the FP&A Global Brands team that created 2,300 annual hours of capacity and increased forecast accuracy. - Key player on the transition of financial reports from Oracle Hyperion to OneStream system, being responsible for the migration of some of the most complex reports under the FP&A scope. - Received at least 4 recognitions from the leadership team and internal customers.

Dell Technologies | Jan 2019 - Jan 2021

Senior Analyst | NA Sales FP&A

Key Responsibilities: - Support Opex planning, analysis and budget control of US and Canada Commercial sales divisions with over a thousand employees and over $250M of annual budget. - Provide accurate and responsive support to the business partners, including FP&A managers, sales executives and finance controllers. - Find innovative solutions to enhance and automate the team's financial reports and tools using Power Query, Power Pivot, Power BI, DAX, MDX/SQL and R. - Share best practices on the use of Excel and company's financial systems. Main Achievements: - Created an automated Opex report that was used by the team as the main tool to build their monthly close reports and analysis. - Led the implementation of new and standardized Opex planning tools for Forecasts and Outlook that resulted in 500h/year of capacity created for the team and improved planning accuracy. - Received about 12 awards through the Dell Inspire program as recognitions for the positive impact generated by the tools and innovations that were implemented.

thyssenkrupp Elevadores | Jan 2018 - Dec 2018

Production Planner | Production Planning & Control


thyssenkrupp Elevadores | Jul 2017 - Dec 2017

Intern | Project Management (PMO)


My Education

Take a look at my formal education

Master's degree, Big Data & Business IntelligenceENEB - Escuela de Negocios Europea de Barcelona | 2021
Bachelor's degree, Industrial EngineeringUniversidade Federal de Pelotas | 2017
Exchange Program, EngineeringKettering University | 2015

About Me

João Antonio Bandeira

I'm always seeking to explore and develop my logical thinking skills and I love to spend hours studying and sharing knowledge about new programming languages, analytical tools and techniques that can be used to create innovative solutions.

Powered by

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