António Rocha
BI Analyst at SDG Group Portugal- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
Português Native or bilingual proficiency
-
Inglês Full professional proficiency
Topline Score
Bio
Alexandra Costa
It was a pleasure working with Antonio! He is very organized, always showing eager to learn new things and a true teamplayer. He is always willing to help his team achieving better results through the analysis of data. António will be a great asset to any company.
Alexandra Costa
It was a pleasure working with Antonio! He is very organized, always showing eager to learn new things and a true teamplayer. He is always willing to help his team achieving better results through the analysis of data. António will be a great asset to any company.
Alexandra Costa
It was a pleasure working with Antonio! He is very organized, always showing eager to learn new things and a true teamplayer. He is always willing to help his team achieving better results through the analysis of data. António will be a great asset to any company.
Alexandra Costa
It was a pleasure working with Antonio! He is very organized, always showing eager to learn new things and a true teamplayer. He is always willing to help his team achieving better results through the analysis of data. António will be a great asset to any company.
Credentials
-
Microsoft Certified: Azure AI Fundamentals
MicrosoftJul, 2021- Oct, 2024 -
Microsoft Certified: Power Platform Fundamentals
MicrosoftJul, 2021- Oct, 2024 -
Introduction to Windows PowerShell 5.1
UdemyApr, 2021- Oct, 2024 -
Learn Windows & Linux Command Line
UdemyApr, 2021- Oct, 2024 -
PowerShell - essential course with labs
UdemyMar, 2021- Oct, 2024 -
AZ-900: Microsoft Azure Fundamentals
UdemyNov, 2020- Oct, 2024 -
DP-900: Azure Data Fundamentals
UdemyNov, 2020- Oct, 2024 -
Microsoft Certified: Azure Data Fundamentals
MicrosoftNov, 2020- Oct, 2024 -
Microsoft Certified: Azure Fundamentals
MicrosoftNov, 2020- Oct, 2024 -
Azure Database Administrator (DP-300)
RumosSep, 2020- Oct, 2024 -
Learning SQL Programming
LinkedInSep, 2020- Oct, 2024 -
SQL Tips, Tricks, & Techniques
LinkedInSep, 2020- Oct, 2024 -
Developing SQL Databases (20762)
RumosJul, 2020- Oct, 2024 -
Administering a SQL Database Infrastructure (20764)
RumosMay, 2020- Oct, 2024 -
Querying Data with Transact-SQL (20761)
RumosApr, 2020- Oct, 2024 -
Relational Database, Analysis and SQL Language
RumosMar, 2020- Oct, 2024 -
Microsoft Certified: Azure Database Administrator Associate
MicrosoftFeb, 2021- Oct, 2024
Experience
-
SDG Group Portugal
-
Portugal
-
Business Consulting and Services
-
1 - 100 Employee
-
BI Analyst
-
May 2023 - Present
Business Intelligence Consultant: - Ceate, Improve and maintain several Reports and Dashboards (Power BI), from two different clients (Food and Beverages Industry and Surgical prostheses industry) - Transversal project competency: Architecture, Design, Story Board, ETL, Developement, DAX, Reporting, Testing - Food and Beverages: Created 10 reports to track the Modern Distribution area: Orders, Sellout, SellIn, Activities, Ruptures, etc - Surgical prostheses industry: Created 3 Reports - Profit and Loss for Financial department (Segmented with row Level Security for the other department managers), Orders Dashboard and Pending Orders Dashboard Tools: Power BI, Power Query, DAX, ETL, Dataflows, Data Factory, RLS, Azure, Jira, Sprints Show less
-
-
-
Manutan Portugal
-
Portugal
-
Retail Office Equipment
-
1 - 100 Employee
-
Business Analyst
-
Sep 2021 - Apr 2023
Database Administration and Management for Portugal and Spain (Data upload, data correction, GDPR requests), Project Manager for the continuous improvement of the Databases (Sprints) - Create, improve and maintain several Dashboards for the different departments (Business, Sales, Quotations, After-Sales, Comercial team, Finance, Marketing) (Power BI, MicroStrategy and Excel) - Management of Data tasks related to Marketing Actions (Customer segmentation, customer potential, customer analysis, product analysis, product segmentation) Example Dashboards: - Resillience Plan Dashboard - Analysis of the impact of the war on our Customers, analysis of Industry and Customer Size, Segmentantion on Customer potential by clusters ranging from Impacted to Very High potential. - Customer LifeTime Value Dashboard - Analysis of the CLTV by Industry and Customer Size Show less
-
-
-
Rumos
-
Portugal
-
IT Services and IT Consulting
-
100 - 200 Employee
-
Data analytics & AI - Database Administrator
-
Nov 2020 - Aug 2021
- Microsoft SQL Server Health, Performance & Security Assessments (Retail and Investment Banking Industry) - Creation of detailed Health & Performance reports that provided Microsoft SQL Server and databases overall Health and key actions to improve performance - Creation of detailed Security reports that provided key actions to improve Security of Microsoft SQL Server and databases - Script execution for the improvement of Health, Performance and Security on SQL Servers and Databases Tools: Microsoft SQL Server Management Studio, Hyper-V, VMware, Microsoft Excel, Windows PowerShell Show less
-
-
-
Finsolutia
-
Spain
-
Financial Services
-
200 - 300 Employee
-
Origination Administrator Associate
-
Nov 2018 - Aug 2020
- Technical framework for mortgage loan proposals (proposal analysis, issue of Complementary Document for deed and FINE Approval); - Mortgage loan proposals formalization (Complementary Document and insurances rectifications); - Mortgage loan proposals creation and archive - Department's Procedures Manual creation Tools: Microsoft Excel, 4Sight Servicing Platform, Power BI (as user) - Technical framework for mortgage loan proposals (proposal analysis, issue of Complementary Document for deed and FINE Approval); - Mortgage loan proposals formalization (Complementary Document and insurances rectifications); - Mortgage loan proposals creation and archive - Department's Procedures Manual creation Tools: Microsoft Excel, 4Sight Servicing Platform, Power BI (as user)
-
-
-
Banco Invest S.A.
-
Portugal
-
Banking
-
100 - 200 Employee
-
Accounting and Control Technician
-
Apr 2018 - Nov 2018
- Suppliers contracts control - Billing control and accounting - Suppliers payments - Archive managment Tools: AS/400, Microsoft Excel and VBA - Suppliers contracts control - Billing control and accounting - Suppliers payments - Archive managment Tools: AS/400, Microsoft Excel and VBA
-
-
-
-
Administrative Assistant
-
Mar 2017 - Mar 2018
- Executive action processing - Citations and Notifications developing - Archive managment Tools: Microsoft Excel, iBase and GPESE - Executive action processing - Citations and Notifications developing - Archive managment Tools: Microsoft Excel, iBase and GPESE
-
-
Education
-
Rumos
Academia Database & Data Intelligence -
Instituto Superior Técnico
Master of Engineering (MEng), Mechanical Engineering