Bruno O.

Data Analyst

BI Analyst
5/1/2021 - Present

Constructed and maintained data pipelines for creating Data Marts, encompassing data consumption in the Raw layer, ETL processes, star schema construction in intermediate layers, and delivering refined data in the Data Warehouse using Databricks in PySpark and BigQuery in SQL. Created monitoring systems for table loads utilized in primary reports for the BI team, leveraging Databricks in PySpark and BigQuery in SQL. Conducted surveys of rules and requirements to serve internal customers effectively. Developed and optimized reports in Power BI, applying dimensional modeling with a star schema and restructuring reports to include measures created in DAX and incremental loads. Administered Power BI Service environments, handled code versioning using GitHub, and documented dashboards via Confluence.

Governance and Internal Controls Analyst
12/1/2017 - 5/1/2021

Conducted comprehensive surveys to identify and document rules and requirements for serving internal customers. Mapped and processed diverse data sources to ensure accurate and reliable information flow. Developed advanced dashboards and Key Performance Indicators (KPIs) for performance control using Power BI and Excel, enhancing data visualization and decision-making capabilities.

Web Programming Intern
9/1/2017 - 12/1/2017

Developed functionalities for the company's ERP web system using .NET. Created and optimized database queries using SQL.

Analysis and Development of Systems at Thermomechanical Technology College
2015 - 2017

Data Engineering at XP Education
2022 - 2022

Google Data Studio - From Basic to Advanced at Udemy Brasil
10/1/2021

Curso Completo - Power Bi Experience at Power Bi Experience - Leonardo Karpinski
8/1/2021

Microsoft Excel - Advanced at Fundação Bradesco
9/1/2019

Power BI Complete - from Basic to Advanced at Udemy Brasil
7/1/2019