Flávio is available for hire
Hire FlávioFlávio Fernandes
Verified Expert in Engineering
Business Intelligence Specialist and Developer
Location
Lisbon, Portugal
Toptal Member Since
April 8, 2021
Flávio是一位拥有9年以上经验的商业智能专业人士, 主要关注用户消费的数据集成和数据建模. He has worked in various industries, including telecommunications, consumer services, online gaming, and information technology. Flávio具有管理经验，并使用Microsoft商业智能堆栈设计和实现了多个数据仓库解决方案.
Portfolio
Self-employed
商业智能(BI)， c#， DAX, Microsoft Power BI, SQL Server 2019...
Nash Inc Limited
Microsoft Power BI, Excel 2013，数据可视化，Microsoft Power automation...
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...
...我使用Power BI开发的项目是一个快速和模块化的商业智能解决方案，用于支持高级管理层的决策过程.
Work Experience
Business Intelligence Consultant
2022 - 2022
Self-employed
- 成功地与涉众沟通，了解新的BI生态系统的业务需求. 我专注于了解业务，以及新的解决方案如何为公司的团队增加价值.
- 与客户协商预算和交付，以确保满足预期并按照讨论的方式实施.
- 为制造客户开发并实施端到端BI解决方案. I used SQL Server Integration Services (SSIS) as the ELT tool, SSAS (SQL Server Analysis Services)作为业务模型解决方案, and Microsoft Power BI as the reporting tool.
- 使用c#构建了一个自定义工具来管理与BI环境相关的一切, including role management and ELT execution.
Technologies: 商业智能(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
- 根据当前和未来的业务需求，指导业务用户优化现有Microsoft Power BI解决方案.
- 在Microsoft Power BI模型中开发高度复杂的度量，以确保它反映了分析的法律要求.
- 共享行业最佳案例实践，以确保解决方案的开发在未来不会受到影响.
Technologies: Microsoft Power BI, Excel 2013，数据可视化，Microsoft Power automation, Microsoft Power Apps, Microsoft Excel
Power BI Developer
2021 - 2022
AB Volvo
- 开发端到端解决方案，支持美洲客户服务的日常活动. 解决方案包括使用集成服务开发ETL流程, a Power BI data model, and reports.
- 使用c#构建了一个自定义工具来管理与报表环境相关的一切, including Power BI role management and ETL execution.
- 管理客户服务和IT团队之间的关系，确保解决方案遵循公司指导方针，并为未来的改进做好准备.
Technologies: Microsoft Power BI, Data Visualization
Business Intelligence and Analytics Team Leader
2019 - 2021
NOS Communications
- 管理一个由5名商业智能开发人员组成的团队，专注于数据集成和建模，以支持超过300份报告和40个每天更新的Power BI数据集.
- Tracked and managed the team's workflow using Jira.
- 设计并实现了一个新的数据架构，以减少洞察所需的时间, 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
- 开发并部署了一个c#应用程序来管理OLAP的部署和处理.
- Created a business intelligence solution to support management. 使用可用的API从目标流程提取数据, and reporting was done using Power BI.
- 通过在Databricks中创建进程，管理Azure中新数据架构的测试.
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
- 开发并实现了一个接近实时的解决方案来监控ETL流程, helping the team act on issues faster.
- Tracked and managed development using Jira and Git.
- 实现了一个商业智能解决方案来分析Google Analytics 360数据.
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. 其中两个项目旨在满足150多名日常用户的需求.
- 招聘并培训了三名商业智能理论和微软商业智能堆栈方面的顾问. I managed two of them on several projects.
- 为一家专门的零售商创建并实现了一个商业智能解决方案, which centralized decisions and made them faster, 直接影响到负责公司定价策略的10人团队.
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
Experience
Power BI – Modular KPI Solution
创建了一个高度可扩展和可配置的Power BI解决方案，以适应对管理业务所需的各种关键指标的分析. I handled the end-to-end solution, which included the development of ETL using PL/SQL, an analytical model, and reporting in Power BI. 我还开发了一个c#应用程序来管理指标的定义、来源和格式.
此解决方案允许用户在SSAS Tabular引擎中拥有与SSAS多维解决方案中的自定义上卷公式中相同的行为. 这个项目产生了一个模型，它可以很容易地发展以适应公司不断变化的需求.
此解决方案允许用户在SSAS Tabular引擎中拥有与SSAS多维解决方案中的自定义上卷公式中相同的行为. 这个项目产生了一个模型，它可以很容易地发展以适应公司不断变化的需求.
Power BI – Search Engine
开发Power BI自定义可视化，允许用户搜索报告, documentation, and datasets as part of their daily activities. 可视化还允许在用户浏览可用数据时收到来自商业智能团队的通知. 使用TypeScript处理数据模型和Power BI可视化的开发.
SSAS – Dynamic Role Creation
处理读取相关元数据和使用xml表达式创建角色的ETL过程. 构建此解决方案是为了动态地管理SSAS数据库中访问角色和信息的创建.
C# Custom Tool – ETL and Report Management
使用c#构建了一个工具来管理ETL和报告项目层以及与之相关的一切, including ETL processes, their respective dependencies, and user and role management. 该项目使团队能够使用单一工具来管理数据集成, monitor processes, and manage user access, among other built-in features.
Skillset
Storage
SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Microsoft SQL Server, DB, SQL Server 2014, SQL Server 2016, SQL Server Reporting Services (SSRS), Oracle SQL
Languages
T-SQL (Transact-SQL), Excel VBA, C#
Tools
Microsoft Power BI, Excel 2013, Microsoft Power Apps, Microsoft Excel
Other
SQL Server 2019, DAX, Multidimensional Expressions (MDX), Ideation, Service Development, Business Intelligence Training, Statistical Methods, XML for Analysis (XMLA), Data Visualization, Azure Data Factory
Paradigms
Business Intelligence (BI)
Platforms
Windows, Microsoft Power Automate
Education
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
Collaboration That Works
How to Work with Toptal
在数小时内，而不是数周或数月，我们的网络将为您直接匹配全球行业专家.
1
Share your needs
在与Toptal领域专家的电话中讨论您的需求并细化您的范围.
2
Choose your talent
在24小时内获得专业匹配人才的简短列表，以进行审查，面试和选择.
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