Pedro Ribeiro

Working as Data Governance Architect in the Data Governance team, implementing the Data Market Place via Microsoft Purview data governance and data security functionalities, defining MDM Strategy and data models, Governance Domains, glossary terms, data quality roles and respective dependencies with DORA (Digital Operational Resilience Act) initiative. Training Different Data Stewards and Data Owners on the Microsoft Purview Adoption Work cross-functionally with Legal, Compliance, Risk, InfoSec, and Technology to align governance activity Used Trainable AI Classifiers to Identify confidential documentation across various major compliance policies, including GDPR, HIPAA, ISO, PCI, SOC, and SSAE 18 compliance. Main Activities: • Data Classification (Creating new data classification types and using built-in ones), • New Sources Registration and Scanning under Data Map • Data Lineage discovery and Automation • Data Catalog creation & population – Unified Catalog • Data Governance Domains creation • Implementing Sensitive labeling & associated Reporting under information protection • Creating & enforcing Sensitivity Policies (for e-mails, databases, office documents) • Working on DLP – Data Prevention Loss policies • Meta Data Management • Data Quality enforcement • Architecture Designs (High and Low Level Architecture designs of Data Mesh Platform for Data Analytics and Master Data Management) using Azure Data Factory, Azure Logic Apps, Azure Functions, Azure Data Lake, Azure Synapse

Lead Architect of the Enterprise Master Data Platform which integrates with Data & Analytics, Data Reconciliations Enterprise solution, Artificial intelligence platforms and transactional platforms Main Activities: Logical Data modeling, High level and Low level Architecture Designs, Code Reviews, Data Migrations, Relational and Dimensional Modeling, Domains Modeling, Data Integrations. Utilizing Purview, PowerBI, Data Factory, Talend, DataBricks, DevOps, SQL Server, Python, GCP and Azure Cloud, Synapse and BigQuery, Data Lakes, Theobald, Aecorsoft. Design & Migration of Master Data Domains from SAP MDG, ECC and BW to Azure and GCP Clouds. Discovery of non-functional requirements and identifying potential gaps. Building roadmaps for systems in scope. Project Scope: Large Enterprise Data Platform, with 32 people working simultaneously on it, across the Globe. Accountable in terms of Design Authority, Compliance and Risk Management with budget responsibilities

Lead Architect of Modern Data Platform (MDP) focused on Relational and Dimensional Data Modeling, Data Integrations, Data Migration & Data Governance of the objects in scope MDP platform serving BI & Analytics Data Consumers Utilizing Purview, PowerBI, Data Factory, DataBricks, DevOps, SQL Server, Python, Azure Cloud, Data Warehouses Synapse, Data Lakes Roadmap definition and maintenance Project Scope: Large Enterprise Modern Data Platform, with 41 people working simultaneously on it, across the Globe. Accountable in terms of Design Authority, Compliance and Risk Management with budget responsibilities

Lead of the Financial Reporting and Analytical front office solutions department, with focus on, Data security and Governance, Software Architecture, DevOps, .NET, Data Warehouses, Analytics, Business Intelligence and Reporting Project 1: Built from scratch an Enterprise Data Warehouse to ingest and consolidate information from the global relational insurance systems, respective subledger and ERP applications. Project 2: Creation of the Reporting and .NET Analytical front office platform composed by tailored Data Marts, .NET, Excel and SSRS reports, serving Actuaries, Underwriters, FP&A and several power users. Program Scope: Large scale Financial Transformation Program, with 200+ people working across the Globe Teams Management: 10 teams (82 Engineers) mostly, nearshore and offshore located, using Scrum and SAFe methodologies. Full responsibility over recruitment and teams performance management. Accountable in terms of Design Authority Technologies Used: Databricks, Azure data Lake, SSAS,SSIS,SSRS, .NET, SQL Server, PowerBI, Excel, High Available Infrastructures (Clusters, SANs, VMWare), Confluence, JIRA, SharePoint, ServiceNow, Bamboo, SVN, Slack, UC4 / Automic, Orchestration Key Achievements: Added significant value to the company’s performance through a technology and innovation robust roadmap, re-negotiated the Suppliers contracts (3M spared), the initial commitment was delivered on-time in a compliant way

I was the ultimate responsible for all the Architecture Deliverables, SLAs, SLOs and KPI definitions My daily responsibilities consisted in Conceptual, Logical and Physical architecture designs / reviews, C Level stakeholders engagement, architecture teams leading (31 FTEs), Data Governance reviews, Data Encryption technologies (data at rest, data in transit) and environments alignment Due to my expertise in Change Management, part of my time was spent creating standards and guidelines to enforce compliance, architecture, and manage / mitigate risks. Technology Used: SSIS,SSRS, SQL Server, SSAS Multidimensional, Visio, .NET (VB and C#) , High Available Infrastructures (Servers, Clusters, SANs, VMWare, Networks) Designed layers - Presentation Layers, Business Services Layers, Data Services Layers Key Achievements: Solutions performance improvements, definition of the Disaster Recovery Plan, uniformization of the IT Landscape, risks mitigation, definition of the horizontal / vertical scaling for application resilience / performance.

Working as Lead Architect for the Marketing and Sales Stream. Focused on the integration part of the projects. Project 1: Designed the Database and ingestion flows of BMB (Branded Machine Business) which receives information from OLTP systems (SAP, WebApps ) spread across the globe, ingests this information and transform it, in a Data Warehouse and Cubes solution, to provide analytical report capabilities about Sales of beverages (coffee, Juice) Project 2: Designed the Database and respective integration with existing webservices for project named Masters, which consist, on an Azure based application, that receives information directly from the beverages machines positioned across the globe in the clients. Goal is to understand if coffee powder is missing or any spear part is missing/broken to ensure fast reply by alerting the technicians on the fields in real time.