João Antonio Vieira Bandeira

T

Team Lead | Data & Analytics

The Estée Lauder Companies Inc.

Apr 2022 - Jan 2023 (10 months)

Key Responsibilities: - Lead a new data analytics team, coaching them on the development of innovative ways to solve complex analytical problems. - Lead developments on the Azure platform using tools like Databricks, Data Factory and SQL Server. - Lead the development of ETL and machine learning solutions in Python. - Support the BI & Analytics team on the creation of data architecture and sustainable data pipelines for projects. - Develop solutions in Power BI service. - Be a technical lead on subjects like coding (Python, SQL and DAX) and on topics like Machine Learning, ETL, databases and automation.

T

Team Lead | Business Process Automation

The Estée Lauder Companies Inc.

Feb 2021 - Apr 2022 (1 year 3 months)

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 cr

Senior Analyst | NA Sales FP&A

Dell Technologies

Oct 2019 - Jan 2021 (1 year 4 months)

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

AIESEC Trainee | NA Sales FP&A

Dell Technologies

Jan 2019 - Sep 2019 (9 months)

AIESEC Global Talent Exchange Program participant. Key Responsibilities: - Support Opex planning and analysis of a US commercial sales segment with about 340 employees and $60M annual budget. - Develop and enhance reports and tools for the team Main Achievements: - T&E report automation and enhancement resulting in a higher T&E visibility among sales leadership and a more efficient T&E spend control. - Creation of a Headcount tracking automated tool in order to support controllers to have a better visibility over weekly HC changes. - Supported the creation of a template to standardize and improve accuracy of commissions Accrual calculation.

T

Production Planner | Production Planning & Control

Thyssenkrupp Elevadores S.A

Jan 2018 - Dec 2018 (1 year)

Key Responsibilities: - Develop improvements in the production scheduling system; - Create and improve planning and control tools; - Work closely with IT team to develop new features on the company's ERP system; - Develop data analysis focused on identifying production planning improvements and cost reduction opportunities; - Provide general support in Excel and SQL related questions; Main Achievements: - Led the implementation of a new lead time based production scheduling system that was able to reduce work in progress in the plant in about 30% and was presented as a best practice for other plants of the group; - Developed an operations research logic, using Excel Solver, that was able to optimize the machines' workload balancing.

T

Intern | Project Management (PMO)

Thyssenkrupp Elevadores S.A

Jul 2017 - Dec 2017 (6 months)

Key Responsibilities: - Control the Sustain Engineering projects status, including project budget, risks, deliveries and resources and report them to the Engineering director; - Lead the daily scrum meetings with the Product Engineering teams; - Make constant follow-ups with all teams involved in the projects; - Update the projects schedules in MS Project Server; - Support the PMO team with the creation of new KPIs and Excel control tools. Main Achievements: - Developed dashboards with a series of KPIs used to monitor the projects standard deliveries status; - Created automated Excel tools to improve the control over project budget, resource usage and FTE; - Developed a presentation template used to globally report the projects stat

M

Volunteer Intern | Consulting Projects

Móveis Mamp

Sep 2016 - Dec 2016 (4 months)

Have a practical experience by supporting the growth of a local family furniture business through the implementation of some industrial engineering concepts. - Implementation of basic quality management tools; - Process mapping and standardization; - Standardization of roles and responsibilities; - Creation of a website in WordPress and a Facebook business profile;

Project Assistant | Extension Program

Universidade Federal de Pelotas

Aug 2013 - Jul 2014 (1 year)

- Support a project aimed to develop local viticulture on small producers. - Reach out to local authorities to present the project.

U

Research Assistant | Polymers Lab

UCS - University of Caxias do Sul

Dec 2010 - Dec 2012 (2 years 1 month)

- Support a research project aimed to develop a new biodegradable polymer composite. - Run laboratory analysis. - Write and publish scientific articles.

João Antonio Vieira Bandeira

About

Detail

Timeline

Résumé