Fernando R.
Power BI Engineer
Fernando is a Power BI Engineer with eight years of experience, including three years internationally in Portugal and Spain. He specializes in data visualization, automation, and business intelligence solutions across sales, finance, and distribution sectors.
As a Data Consultant at Amaris Consulting, Fernando leads end-to-end BI projects, leveraging Databricks, SQL, and Power BI to develop insightful dashboards and automation solutions that enhance decision-making.
Proficient in MSSQL, T-SQL, Azure Data Factory, and Python, he excels in data modeling and process optimization, driving efficiency and business growth through data-driven strategies.
Main expertise
- SQL 4 years
- Jira 5 years
- Microsoft power automate 5 years
Other skills
- Python 2 years
- Azure Data Factory 2 years
- Microsoft Fabric 1 years
Selected experience
Employment
Data Consultant
Amaris Consulting - 3 years
-
Working with a focus on data visualization with the Data Management team at the Transformation Center for Companies.
-
Responsible for surveying and estimating projects, monitoring and conducting the Business Intelligence project development pipeline.
-
Working on the construction of end-to-end projects with the Digital Business team for Portugal and Spain.
-
Responsible for all stages of project development, including structuring and building tables and processes in Databricks, developing data visualization and automated sharing methods.
Technologies:
- Technologies:
SQL
Microsoft power automate
Python
Microsoft Power BI
MSSQL
-
Team Member - Squad Agile BI
Philip Morris International - 8 months
-
Develop of dashboards focused on organizational efficiencies
-
Predict Analytics Projects
-
Reports automation
Technologies:
- Technologies:
SQL
Microsoft power automate
Microsoft Power BI
MSSQL
-
Consignment Analyst Pl - BI
Philip Morris International - 1 year 4 months
-
Disseminated a culture of data within the sector and implemented controls that support data-based decision making. Acted with a focus on specific projects that allow the area greater control of the information generated.
-
Data analysis through Power BI; Constructed panels for visualization of KPI's;
-
Constructed and maintained dashboards for finance projects; Implemented automatic data update Gateway online;
-
Created of online flows for sending e-mails;
Data processing through Power Query; -
Created DAX and Power Query M programming;
Connected to internal and external data sources: SQL, SalesForce, SharePoint and API's.
Technologies:
- Technologies:
SQL
Microsoft power automate
Microsoft Power BI
MSSQL
-
Business Intelligence
Philip Morris International - 1 year 1 month
-
Worked with the project implementation team and E-Commerce Sales Strategy Management for all PMB customers in Brazil;
-
Assisted in the construction of planning and management of commercial actions;
-
Developed actions to achieve the goals and growth of market share for 7 regional sales;
-
Directed and contacted regularly the sales team, identifying needs and solutions;
-
Developed Power BI dashboards for the entire sales team (managers and salespeople);
-
Developed projects using agile methods (Scrum with Kanban);
-
Masterfile maintenance, through customer management and routing (18K of POS);
-
Opened and phased targets for telesales operations serving 7 regionals with 38 sales zones;
-
Built daily KPIs to monitor volume and product distribution;
-
Built monthly KSI’s to monitor performance;
-
Responsible for sales forecast and assistance in strategic planning;
-
Controlled information generated by the Customer Care team.
Technologies:
- Technologies:
SQL
Microsoft power automate
Microsoft Power BI
MSSQL
-
Checker
Philip Morris International - 11 months
-
Stored items in an organized and orderly manner, keeping FEFO (First-Expire, First-Out);
-
Defined appropriate methods of storage and identification of materials;
-
Responsible for inventory control, eliminating possible processes that generate losses;
-
Received the products, ensuring the accuracy and efficiency of the receipt;
-
Reversed logistics processes;
-
Controlled goods entry and exit transactions through the SAP system.
Technologies:
- Technologies:
Microsoft power automate
Microsoft Power BI
-
Apprentice
Philip Morris International - 5 months
- Learned the organizational processes, structure and organizational culture of the company.
Technologies:
- Technologies:
Microsoft Power BI
Administrative Assistant
Flamarsul Distribuidora LTDA - 6 months
-
Assisted in the construction of daily KPIs to monitor volume and product distribution;
-
Assisted in the construction of monthly KSI’s for performance monitoring;
-
Maintained Masterfile, through customer management and routing;
-
Assisted in sales forecasting and strategic planning;
-
Assisted in the construction of planning and management of commercial actions to achieve the goals;
-
Directed and contacted regularly the sales team, identifying needs and solutions; Developed sales dashboard.
Technologies:
- Technologies:
SQL
Microsoft Power BI
MSSQL
-
Education
Standalone courseProject Management
LaSalle University · 2020 - 2022
BSc.Management Processes
LaSalle University · 2016 - 2019
Find your next developer within days, not months
In a short 25-minute call, we would like to:
- Understand your development needs
- Explain our process to match you with qualified, vetted developers from our network
- You are presented the right candidates 2 days in average after we talk