弗拉维奥费尔南德斯，葡萄牙里斯本的开发者
弗拉维奥 is 可用 租用
Hire 弗拉维奥

弗拉维奥费尔南德斯

验证专家  in 工程

商业智能专家和开发人员

位置
葡萄牙里斯本
至今成员总数
2021年4月8日

弗拉维奥 is a business intelligence professional with over nine years of experience, primarily focusing on data integration and data modeling for user consumption. 他在不同的行业工作过, 包括电信, 消费服务, 网络游戏, 信息技术. 弗拉维奥 has management experience and has designed and implemented multiple data warehouse solutions using the Microsoft business intelligence stack.

SQL Server集成服务(SSIS)SQL Server分析服务(SSAS)Microsoft SQL ServerDAXt - sql (transact - sql)Microsoft Power BISQL Server 2014SQL Server 2016SQL Server报表服务(SSRS)Oracle SQLC#商业智能培训数据可视化窗户商业智能(BI)

Portfolio

自由职业者
商业智能(BI), C#, DAX, Microsoft Power BI, SQL Server 2019...
纳什有限公司
Microsoft Power BI, Excel 2013, 数据可视化, Microsoft Power automation...
AB沃尔沃
Microsoft Power BI，数据可视化

Experience

SQL Server分析服务(SSAS) - 7年t - sql (transact - sql) - 7年SQL Server集成服务(SSIS) - 7年DAX指数- 6年Microsoft Power BI - 6年SQL Server报表服务(SSRS) - 3年Excel VBA - 3年Oracle SQL - 2年

Availability

兼职

首选的环境

窗户, SQL Server集成服务(SSIS), SQL Server分析服务(SSAS), Microsoft Power BI, SQL Server 2019

最神奇的...

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

工作Experience

商业智能顾问

2022 - 2022
自由职业者
  • 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. 我使用SQL Server集成服务(SSIS)作为ELT工具, SQL Server分析服务(SSAS) as the business model solution, 以及Microsoft Power BI作为报告工具.
  • Built a custom tool using C# to manage everything related to the BI environment, 包括角色管理和ELT执行.
技术:商业智能(BI), C#, DAX, Microsoft Power BI, SQL Server 2019, Azure数据工厂, SQL Server集成服务(SSIS), SQL Server分析服务(SSAS)

Power BI顾问

2022 - 2022
纳什有限公司
  • 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.
技术:Microsoft Power BI, Excel 2013, 数据可视化, Microsoft Power automation, Microsoft Power Apps, Microsoft Excel

Power BI开发人员

2021 - 2022
AB沃尔沃
  • 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, Power BI数据模型, 和报告.
  • Built a custom tool using C# to manage everything related to the reporting environment, 包括Power BI角色管理和ETL执行.
  • 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.
技术:Microsoft Power BI，数据可视化

商业智能和分析团队负责人

2019 - 2021
号通讯
  • 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.
  • 使用Jira跟踪和管理团队的工作流程.
  • Designed and implemented a new data architecture to reduce the time to insight, 推广自助式商业智能, 并改善开发生命周期.
技术:SQL Server 2019, Oracle SQL, Microsoft Power BI, SQL Server分析服务(SSAS), t - sql (transact - sql), C#, 多维表达式(MDX), DAX, 商业智能(BI), Microsoft SQL Server, DB

商业智能专员

2018 - 2019
德科Proteste
  • Developed and deployed a C# application to manage OLAP deployment and processing.
  • 创建了一个商业智能解决方案来支持管理. The data was extracted from the target process using the 可用 API, 报告使用Power BI完成.
  • Managed the testing of the new data architecture in Azure by creating processes in Databricks.
技术:SQL Server集成服务(SSIS), SQL Server分析服务(SSAS), SQL Server 2016, t - sql (transact - sql), SQL Server报表服务(SSRS), C#, 多维表达式(MDX), DAX, Microsoft Power BI, 商业智能(BI), Microsoft SQL Server, DB, Excel VBA

数据仓库开发人员

2016 - 2018
Betsson集团
  • Developed and implemented a near real-time solution to monitor ETL processes, 帮助团队更快地处理问题.
  • 跟踪和管理使用Jira和Git的开发.
  • Implemented a business intelligence solution to analyze Google Analytics 360 data.
技术:SQL Server集成服务(SSIS), SQL Server分析服务(SSAS), SQL Server 2016, t - sql (transact - sql), 多维表达式(MDX), 商业智能(BI), Microsoft SQL Server, DB

商业智能顾问

2013 - 2016
B2F -面向未来的业务
  • 开发了5个端到端商业智能解决方案, 涵盖了源分析, ETL, 在线分析处理, 报告发展. 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. 我在几个项目中管理他们中的两个.
  • Created and implemented a business intelligence solution for a specialized retailer, 哪些集中决策并使决策更快, directly affecting a 10-person team handling the company's pricing strategy.
技术:SQL Server集成服务(SSIS), SQL Server分析服务(SSAS), SQL Server 2014, t - sql (transact - sql), SQL Server报表服务(SSRS), 多维表达式(MDX), Oracle SQL, DAX, Microsoft Power BI, 商业智能(BI), Microsoft SQL Server, DB, Excel VBA

Power BI -模块化KPI解决方案

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. 我负责端到端解决方案, 其中包括使用PL/SQL开发ETL, 解析模型, 并在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.

动力BI -搜索引擎

Developed a Power BI custom visualization that allowed users to search for reports, 文档, 和数据集作为他们日常活动的一部分. The visualization also allowed notifications from the business intelligence team while users browsed 可用 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.

c#自定义工具- ETL和报表管理

Built a tool using C# to manage the ETL and reporting project layer and everything related to it, 包括ETL流程, 它们各自的依赖关系, 以及用户和角色管理. The project enabled the team to have a single tool to manage the data integration, 监控流程, 管理用户访问, 其他内置功能.
2013 - 2017

服务工程硕士学位

波尔图大学-波尔图，葡萄牙

2016 - 2016

数据分析和数据挖掘课程

波尔图大学-波尔图，葡萄牙

2014 - 2015

短期商业智能硕士课程

葡萄牙大学-葡萄牙波尔图

工具

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

语言

t - sql (transact - sql)， Excel VBA, c#

存储

SQL Server集成服务(SSIS), SQL Server分析服务(SSAS), Microsoft SQL Server, DB, SQL Server 2014, SQL Server 2016, SQL Server报表服务(SSRS), Oracle SQL

范例

商业智能(BI)

平台

窗户，微软Power automation

其他

SQL Server 2019, DAX, 多维表达式(MDX), 意念, 服务开发, 商业智能培训, 统计方法, 用于分析的XML (XML), 数据可视化, Azure数据工厂

有效的合作

如何使用Toptal

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

1

分享你的需求

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

选择你的才能

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

开始你的无风险人才试验

与你选择的人才一起工作，试用最多两周. 只有当你决定雇佣他们时才付钱.

对顶尖人才的需求很大.

开始招聘