Peter K.

Tech Stack: Microsoft Fabric, OneLake, Lakehouse, Delta Lake, Power BI, Data Factory (Fabric), Microsoft Purview, Dataverse. Enterprise Cloud Modernization: Spearheaded the architectural design and execution of a large-scale data platform modernization project for a major insurance provider, successfully migrating a legacy Oracle-based data warehouse to a unified Microsoft Fabric Lakehouse architecture using OneLake, structured around a Bronze/Silver/Gold medallion framework for progressive data refinement and governed consumption. Strategic Roadmapping: Conducted comprehensive corporate Microsoft Fabric readiness assessments, providing C-suite leadership with clear, actionable cloud adoption roadmaps and infrastructure cost-optimization blueprints. Scalable Data Foundations: Engineered high-performance, scalable data architectures utilizing Azure Cloud and Azure Synapse Analytics integrations to systematically dismantle legacy infrastructure bottlenecks.

Tech Stack: Microsoft Fabric, OneLake, Lakehouse, Delta Lake, Data Factory (Fabric), Microsoft Purview, Azure Data Lake, Power BI Direct Lake. Enterprise Fabric Architecture: Architected and governed enterprise-scale data architecture utilizing Microsoft Fabric, successfully aligning multi-domain cloud data strategies with overarching business objectives. OneLake & Direct Lake Optimization: Defined and deployed unified Lakehouse and Warehouse frameworks within OneLake, establishing robust semantic layers and driving governed, self-service BI via high-performance Power BI Direct Lake models. Orchestrated Data Engineering: Spearheaded the architectural integration of Fabric Data Factory pipelines within a  Bronze/Silver/Gold medallion architecture, automating end-to-end data ingestion, standardization, and progressive refinement across Lakehouse zones. Data Governance & Compliance: Partnered with security teams to embed automated data governance, strict compliance, and data lineage tracking into the Fabric ecosystem via deep integration with Microsoft Purview. Transition Roadmapping: Authored comprehensive architectural blueprints, reference implementations, and strategic roadmaps to guide the organization through phased Fabric adoption and legacy system migrations.

Tech Stack: Azure Cloud, Azure Databricks, Delta Lake, Azure Synapse Analytics, Azure Data Lake Storage (ADLS), Unity Catalog, Azure Purview, Power BI. Enterprise Data Fabric Architecture: Designed and deployed a scalable, enterprise-wide data fabric architecture across hybrid cloud and on-premises environments, leveraging ADLS, Synapse Analytics, and Azure Databricks to unify disparate data sources. Delta Lake & Lakehouse Engineering: Engineered robust Delta Lake-based architectures to seamlessly handle both real-time and batch data processing pipelines, dramatically increasing data reliability, consistency, and ETL throughput. Unified Data Governance & MDM: Spearheaded modern data governance initiatives by setting up, configuring, and deploying Unity Catalog and Azure Purview data scanners, establishing automated policy migrations, and leading Master Data Management (MDM) profiling and data cleansing frameworks. Scalable Analytics Architecture: Architected and optimized an enterprise-level Power BI infrastructure—integrating complex data sources, dataflows, and semantic datasets—while tuning query performance to ensure peak backend scalability and reporting efficiency.

Tech Stack: Azure Cloud, Azure Data Factory (ADF), Azure Synapse Analytics, Azure Databricks, Azure Data Lake, Azure Purview, Power BI, Unity Catalog. Enterprise Data Fabric Architecture: Designed and deployed a scalable, enterprise-wide data fabric architecture across hybrid cloud and on-premises environments, leveraging ADLS, Synapse Analytics, and Azure Databricks to unify disparate data sources. Delta Lake & Medallion Architecture: Engineered a Bronze/Silver/Gold medallion architecture on Delta Lake to progressively refine raw ingestion into governed, business-ready Gold tables, seamlessly handling both real-time and batch data processing pipelines, dramatically increasing data reliability, consistency, and ETL throughput. Unified Data Governance & MDM: Spearheaded modern data governance initiatives by setting up, configuring, and deploying Unity Catalog and Azure Purview data scanners, establishing automated policy migrations, and leading Master Data Management (MDM) profiling and data cleansing frameworks. Scalable Analytics Architecture: Architected and optimized an enterprise-level Power BI infrastructure—integrating complex data sources, dataflows, and semantic datasets—while tuning query performance to ensure peak backend scalability and reporting efficiency.

Tech Stack: Azure Cloud, Azure Data Factory, Data Lake, Synapse, Azure Databricks Responsibilities and Accomplishments: ● Teaming with Systems Engineering and Management to deliver innovative data analytics solutions ● Producing and sharing architecture/design patterns for data analytics ● Architecting Azure Synapse Analytics using star schemas and implementing table distribution ● Migrating on-prem databases to Azure and setting replication between on-prem and cloud database ● Setting up multiple data lakes including data governance, work zones, metadata, and security ● Setting up Data Governance using Azure Purview ● Architecting and optimizing data ingestion and data processing using Azure Data Factory, SQL DB, Azure Synapse Analytics and designing logical data warehouse for optimal Power BI consumption ● ETL design and hands on using Data Factory ● Architecting and deploying Azure Data Lake storage

Tech Stack: Azure Cloud, Azure Synapse Analytics, Azure Databricks, Azure Data Factory (ADF), Cosmos DB, Snowflake, Azure Data Lake, Power BI. Cloud Migration & DWH Architecture: Architected and executed the end-to-end cloud migration of legacy on-premises analytics solutions to a modern Azure Cloud Data Warehouse pattern utilizing Azure Synapse Analytics, Data Factory, Databricks, and Cosmos DB. Multi-Source Ingestion & Snowflake Migration: Designed scalable ingestion pipelines from multiple disparate sources into a secure Azure Data Lake and Synapse DWH, while managing a strategic database migration to Snowflake. Engineering Leadership: Managed and mentored a cross-functional team of BI developers, establishing robust design patterns and data governance standards across the analytics delivery lifecycle. Power BI Optimization & Scalability: Spearheaded advanced performance optimization, automated data modeling, and query tuning for enterprise Power BI ecosystems (reports, dashboards, dataflows), while introducing user training programs to enable governed self-service.

Tech Stack: Azure Cloud, SQL Server, Targit software Strategic Requirement Gathering: Spearheaded the discovery of strategic and tactical business requirements, ensuring that data initiatives directly supported and accelerated organizational objectives. Stakeholder Advisory: Delivered expert analytical insights to senior leadership, defining precise technical specifications for complex ad-hoc reporting solutions and enterprise-wide data quality initiatives. Architectural Roadmap: Translated high-level business priorities into robust data architecture requirements, developing and socializing a comprehensive long-term roadmap to guide organizational data transformation. DataOps & Process Optimization: Modernized and automated data ingestion and analytics workflows (DataOps) within the Azure/SQL Server environment, significantly reducing technical debt and streamlining access for diverse stakeholder roles.

Tech Stack: Azure Cloud, Azure Data Factory (ADF), Azure Data Lake, SQL DWH, Power BI, Enterprise Architecture (PaaS/IaaS/SaaS). Azure Cloud Architecture: Led the end-to-end design, deployment, and lifecycle administration of the enterprise Azure data platform, delivering scalable PaaS, SaaS, and IaaS solutions utilizing Azure Data Factory and Data Lake architectures. BI Strategy & Power BI Governance: Formulated the corporate business intelligence strategy and pioneered enterprise-wide Power BI governance frameworks, successfully defining and enforcing rigorous data security policies and row-level access controls. Data Integration & Engineering Leadership: Managed cross-functional ETL development teams to deliver targeted data marts, designing a unified service bus architecture to consolidate disparate sources into a clean, single version of truth. Enterprise Roadmapping: Partnered directly with corporate stakeholders to translate high-level business priorities into traceable functional specifications, Master Data Management (MDM) frameworks, and long-term data architecture roadmaps.

Tech Stack: SQL Server, SSIS, SSRS, T-SQL, ODS, Dimensional Modeling Data Warehouse Architecture: Architected, designed, and deployed enterprise-scale data warehouses and Operational Data Store (ODS) frameworks to unify disparate data sources and optimize corporate BI reporting. Pipeline Optimization: Engineered and streamlined end-to-end data ingestion and ETL workflows, significantly accelerating data sourcing, enrichment, and loading times across multi-dimensional hypercubes and data marts. Requirements Modeling: Partnered with cross-functional subject matter experts (SMEs) to analyze business priorities and translate them into robust technical specifications and scalable logical/physical data models.

Senior Data Architect/BI Consultant