Open to opportunities

ygor guerra

@ygorguerra

Message

Data analyst with expertise in Power BI and SQL.

Brazil

Message

What I'm looking for

I seek a dynamic role that fosters growth and values data-driven decision-making.

With an Executive MBA in Management focused on Finance from FGV, I have over five years of experience in data analysis and visualization. My journey has been marked by a commitment to transforming complex data into actionable insights, particularly through my work with Power BI and SQL. I have successfully optimized data extraction processes, leading to significant operational savings and enhanced decision-making for companies like Cartão Elo.

Throughout my career, I have developed a strong proficiency in integrating data from various sources, including Google Analytics and databases, to create comprehensive dashboards that drive strategic initiatives. My analytical skills, combined with a dedication to storytelling through data, have enabled me to present findings in a way that resonates with stakeholders, ensuring that data-driven decisions are made effectively.

Experience

Work history, roles, and key accomplishments

Sr. Data Analyst

Cartão Elo

Jun 2021 - Feb 2024 (2 years 8 months)

As a Sr. Data Analyst, I optimized SQL data extraction processes, developed Power BI dashboards for income visibility, and automated financial calculations, resulting in significant operational savings and improved decision-making.

Power BI SQL Data Visualization Data Extraction Automation Financial Analysis Dashboard Development Data Modeling

Administrative Analyst

Recursus Engenharia

Dec 2020 - Apr 2021 (4 months)

Responsible for creating Power BI dashboards to assess project viability and monitor engineering project performance, leading to enhanced transparency and productivity.

Power BI Data Analysis Monitoring Automation VBA Dashboard Development Financial Analysis Excel Macros Team Collaboration

Jr. Finance Analyst

Akta Motors

Nov 2019 - Mar 2020 (4 months)

Managed treasury operations using Power BI tools to optimize bank reconciliations, ensuring timely financial reporting in a fast-paced environment.

Power BI Treasury Management Bank Reconciliation Financial Reporting Data Optimization SQL Excel Time Management Financial Analysis

Finance Assistant

Viva Rock Suítes

Dec 2018 - Nov 2019 (11 months)

Handled remote financial management for a hotel client, reporting financial results through Power BI dashboards to the hotel owner.

Financial Management Power BI Data Reporting Client Communication Excel Financial Analysis Dashboard Development Time Management

Education

Degrees, certifications, and relevant coursework

University of Michigan

Specialization, Computer Science

2023 - 2024

Grade: With Honors

Completed a specialization in Python for Everybody, enhancing programming skills and understanding of data handling and analysis.

Faculdade Getúlio Vargas

Executive MBA, Management

2020 - 2022

Completed an Executive MBA in Management with a focus on Financial Management, gaining advanced knowledge in management principles and financial strategies.