Willian Ranzani

Senior BI & Data Analytics Engineer with 7 years delivering intelligence solutions across Azure and Microsoft Fabric environments. Expert in Power BI development (Reports, Dashboards, DAX, Power Query) backed by strong SQL skills for data modeling and optimization. Experienced in Tabular Cube management via SSAS, SSMS, Tabular Editor, and DAX Studio.

Experienced with low-code automation through Power Apps and Power Automate. Delivers CI/CD pipelines and Agile workflows using Git and Azure DevOps, holding Microsoft certifications DP-600, DP-700, and PL-300. Also active as a Power BI instructor.

BI Developer at CertaPro (2024-06 – Present)

• Designed and delivered Power BI reports and dashboards for a global team, using Tabular Editor, DAX Studio, and SSAS Tabular Cubes for advanced data modeling and performance tuning.
• Tableau migration of Dashboards to Power BI, converting Calculations, LODs, Preps, Charts and KPIs.
• Managed data workflows using, SSMS, and Azure DevOps with Git-based CI/CD pipelines.
• Operated in a cross-functional Agile/Scrum environment with sprint planning and daily standups across international stakeholders.

Senior BI Analyst at SEB Group (2022-07 – 2024-06)

• Delivered Power BI reports and dashboards at enterprise scale, including Power BI Reporting Services, Tabular Editor, DAX Studio.
• Built CI/CD pipelines using Azure DevOps and Git, automating deployment and versioning.
• Administered the Microsoft Fabric platform, managing Power BI capacities P1, RLS, Datamarts.
• Used Azure cloud services and Databricks (Lakehouse architecture) for data engineering.
• Led pilot projects in predictive modeling and time series analysis using Python (scikit-learn, TensorFlow, pandas, matplotlib).
• Operated within Agile frameworks (Scrum and Kanban) across cross-functional teams.

Mid-Senior BI Analyst at Perplan Real State (2020-09 – 2022-07)

• Creation of reports and dashboards in Excel and Power BI for internal control and presentations to the shareholders' committee.
• Database structuring, integration, data processing, and development of professional layouts in Power BI.
• Monitoring of expenses, budget control, and expense allocation.
• Experience in Excel, Power BI (ETL, Modeling, Power Automate, Power Apps)

Junior Data Controller Analyst at Pinion (2019-09 – 2020-09)

• Enhanced data-driven strategic decision-making using KPIs and visualization tools like Looker Studio and Power BI

MBA in Data Science and Analytics – USP (2022 – 2024)

Training Program in Data Scientist – Data Science Academy (2022 – 2024)

Bachelor's in Accounting – Universidade Paulista (2017 – 2020)