Flávio Fernandes

Created a Power BI solution that is highly scalable and configurable to accommodate the analysis of a wide range of key indicators needed to manage the business. I handled the end-to-end solution, which included the development of ETL using PL/SQL, an analytical model, and reporting in Power BI. I also worked on a C# application to manage the indicators' definition, source, and format.

This solution allowed users to have the same behavior in an SSAS Tabular engine as in the custom roll-up formula in SSAS multidimensional solutions. The project resulted in a model that can easily grow to accommodate the company's constantly evolving needs.

Developed a Power BI custom visualization that allowed users to search for reports, documentation, and datasets as part of their daily activities. The visualization also allowed notifications from the business intelligence team while users browsed available data. I handled the development of the data model and the Power BI visualization using TypeScript.

Handled the ETL process that read relevant metadata and created roles using XMLA expressions. This solution was built to dynamically manage the creation of access roles and information present in the SSAS database.

Built a tool using C# to manage the ETL and reporting project layer and everything related to it, including ETL processes, their respective dependencies, and user and role management. The project enabled the team to have a single tool to manage the data integration, monitor processes, and manage user access, among other built-in features.