Flávio Fernandes, Developer in Lisbon, Portugal
Flávio is available for hire
Hire Flávio

Flávio Fernandes

Verified Expert  in Engineering

Business Intelligence Specialist and Developer

Location
Lisbon, Portugal
Toptal Member Since
April 8, 2021

Flávio is a business intelligence professional with over nine years of experience, primarily focusing on data integration and data modeling for user consumption. He has worked in various industries, including telecommunications, consumer services, online gaming, and information technology. Flávio has management experience and has designed and implemented multiple data warehouse solutions using the Microsoft business intelligence stack.

Portfolio

Self-employed
Business Intelligence (BI), C#, DAX, Microsoft Power BI, SQL Server 2019...
Nash Inc Limited
Microsoft Power BI, Excel 2013, Data Visualization, Microsoft Power Automate...
AB Volvo
Microsoft Power BI, Data Visualization

Experience

Availability

Part-time

Preferred Environment

Windows, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Microsoft Power BI, SQL Server 2019

The most amazing...

...project I've developed using Power BI is a fast and modular business intelligence solution to support the C-suite's decision-making process.

Work Experience

Business Intelligence Consultant

2022 - 2022
Self-employed
  • Successfully engaged with stakeholders to understand the business requirements for the new BI ecosystem. I focused on understanding the business and how the new solution could add value to the company's group.
  • Negotiated budget and delivery with the client to ensure expectations were met and the implementation occurred as discussed.
  • Developed and implemented an E2E BI solution for a manufacturing client. I used SQL Server Integration Services (SSIS) as the ELT tool, SQL Server Analysis Services (SSAS) as the business model solution, and Microsoft Power BI as the reporting tool.
  • Built a custom tool using C# to manage everything related to the BI environment, including role management and ELT execution.
Technologies: Business Intelligence (BI), C#, DAX, Microsoft Power BI, SQL Server 2019, Azure Data Factory, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS)

Power BI Consultant

2022 - 2022
Nash Inc Limited
  • Guided the business user through optimizing the existing Microsoft Power BI solution according to the current and future business needs.
  • Developed highly complex measures in the Microsoft Power BI model to ensure that it reflected the legal requirements of analysis.
  • Shared industry best-case practices to ensure that the development of the solution wouldn't be compromised in the future.
Technologies: Microsoft Power BI, Excel 2013, Data Visualization, Microsoft Power Automate, Microsoft Power Apps, Microsoft Excel

Power BI Developer

2021 - 2022
AB Volvo
  • Developed an end-to-end solution to support the daily activities of customer services in the Americas. The solution included developing the ETL process using integration services, a Power BI data model, and reports.
  • Built a custom tool using C# to manage everything related to the reporting environment, including Power BI role management and ETL execution.
  • Managed the relationship between customer care and the IT team to ensure that the solution followed the company guidelines and was ready for future improvements.
Technologies: Microsoft Power BI, Data Visualization

Business Intelligence and Analytics Team Leader

2019 - 2021
NOS Communications
  • Managed a team of five business intelligence developers focused on data integration and modeling to support over 300 reports and 40 Power BI datasets which were updated daily.
  • Tracked and managed the team's workflow using Jira.
  • Designed and implemented a new data architecture to reduce the time to insight, promote self-service business intelligence, and improve the development lifecycle.
Technologies: SQL Server 2019, Oracle SQL, Microsoft Power BI, SQL Server Analysis Services (SSAS), T-SQL (Transact-SQL), C#, Multidimensional Expressions (MDX), DAX, Business Intelligence (BI), Microsoft SQL Server, DB

Business Intelligence Specialist

2018 - 2019
Deco Proteste
  • Developed and deployed a C# application to manage OLAP deployment and processing.
  • Created a business intelligence solution to support management. The data was extracted from the target process using the available API, and reporting was done using Power BI.
  • Managed the testing of the new data architecture in Azure by creating processes in Databricks.
Technologies: SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server 2016, T-SQL (Transact-SQL), SQL Server Reporting Services (SSRS), C#, Multidimensional Expressions (MDX), DAX, Microsoft Power BI, Business Intelligence (BI), Microsoft SQL Server, DB, Excel VBA

Data Warehouse Developer

2016 - 2018
Betsson Group
  • Developed and implemented a near real-time solution to monitor ETL processes, helping the team act on issues faster.
  • Tracked and managed development using Jira and Git.
  • Implemented a business intelligence solution to analyze Google Analytics 360 data.
Technologies: SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server 2016, T-SQL (Transact-SQL), Multidimensional Expressions (MDX), Business Intelligence (BI), Microsoft SQL Server, DB

Business Intelligence Consultant

2013 - 2016
B2F - Business To Future
  • Developed five end-to-end business intelligence solutions, which covered source analysis, ETL, online analytical processing, and reporting development. Two of the projects aimed to support the needs of over 150 daily users.
  • Recruited and trained three consultants in business intelligence theory and the Microsoft business intelligence stack. I managed two of them on several projects.
  • Created and implemented a business intelligence solution for a specialized retailer, which centralized decisions and made them faster, directly affecting a 10-person team handling the company's pricing strategy.
Technologies: SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server 2014, T-SQL (Transact-SQL), SQL Server Reporting Services (SSRS), Multidimensional Expressions (MDX), Oracle SQL, DAX, Microsoft Power BI, Business Intelligence (BI), Microsoft SQL Server, DB, Excel VBA

Power BI – Modular KPI Solution

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.

Power BI – Search Engine

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.

SSAS – Dynamic Role Creation

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.

C# Custom Tool – ETL and Report Management

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.
2013 - 2017

Master's Degree in Services Engineering

Universidade do Porto - Porto, Portugal

2016 - 2016

Course in Data Analysis and Data Mining

Universidade do Porto - Porto, Portugal

2014 - 2015

Short Master's Course in Business Intelligence

Universidade Portucalense - Porto, Portugal

Tools

Microsoft Power BI, Excel 2013, Microsoft Power Apps, Microsoft Excel

Languages

T-SQL (Transact-SQL), Excel VBA, C#

Storage

SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Microsoft SQL Server, DB, SQL Server 2019, SQL Server 2014, SQL Server 2016, SQL Server Reporting Services (SSRS), Oracle SQL

Paradigms

Business Intelligence (BI)

Platforms

Windows, Microsoft Power Automate

Other

DAX, Multidimensional Expressions (MDX), Ideation, Service Development, Business Intelligence Training, Statistical Methods, XML for Analysis (XMLA), Data Visualization, Azure Data Factory

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring