António Rocha

BI Analyst at SDG Group Portugal
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Oeiras, Lisbon, Portugal, PT
Languages
  • Português Native or bilingual proficiency
  • Inglês Full professional proficiency

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

5.0

/5.0
/ Based on 1 ratings
  • (1)
  • (0)
  • (0)
  • (0)
  • (0)

Filter reviews by:

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.

You need to have a working account to view this content.
You need to have a working account to view this content.

Credentials

  • Microsoft Certified: Azure AI Fundamentals
    Microsoft
    Jul, 2021
    - Oct, 2024
  • Microsoft Certified: Power Platform Fundamentals
    Microsoft
    Jul, 2021
    - Oct, 2024
  • Introduction to Windows PowerShell 5.1
    Udemy
    Apr, 2021
    - Oct, 2024
  • Learn Windows & Linux Command Line
    Udemy
    Apr, 2021
    - Oct, 2024
  • PowerShell - essential course with labs
    Udemy
    Mar, 2021
    - Oct, 2024
  • AZ-900: Microsoft Azure Fundamentals
    Udemy
    Nov, 2020
    - Oct, 2024
  • DP-900: Azure Data Fundamentals
    Udemy
    Nov, 2020
    - Oct, 2024
  • Microsoft Certified: Azure Data Fundamentals
    Microsoft
    Nov, 2020
    - Oct, 2024
  • Microsoft Certified: Azure Fundamentals
    Microsoft
    Nov, 2020
    - Oct, 2024
  • Azure Database Administrator (DP-300)
    Rumos
    Sep, 2020
    - Oct, 2024
  • Learning SQL Programming
    LinkedIn
    Sep, 2020
    - Oct, 2024
  • SQL Tips, Tricks, & Techniques
    LinkedIn
    Sep, 2020
    - Oct, 2024
  • Developing SQL Databases (20762)
    Rumos
    Jul, 2020
    - Oct, 2024
  • Administering a SQL Database Infrastructure (20764)
    Rumos
    May, 2020
    - Oct, 2024
  • Querying Data with Transact-SQL (20761)
    Rumos
    Apr, 2020
    - Oct, 2024
  • Relational Database, Analysis and SQL Language
    Rumos
    Mar, 2020
    - Oct, 2024
  • Microsoft Certified: Azure Database Administrator Associate
    Microsoft
    Feb, 2021
    - Oct, 2024

Experience

    • 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

    • 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

    • 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

    • 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)

    • 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
    2020 - 2020
  • Instituto Superior Técnico
    Master of Engineering (MEng), Mechanical Engineering
    2010 -

Community

You need to have a working account to view this content. Click here to join now