Klaus Köhne-volland - Azure Cloud Solution Architect focusing on data lakehouse, data analytics, machine learning, and GenAI

Petersberg, Germany

Experience

Apr 2022 - Present

3 years 4 months

Azure Cloud Solution Architect focusing on data lakehouse, data analytics, machine learning, and GenAI

IT-Consulting

Project for a client in the Drive and Control industry.
Analytics study on cloud vs. on-premise strategy, data modeling, modern data warehousing, and data mesh
End-to-end PoC Azure Synapse Analytics to Power BI Premium based on a purchasing use case
Created a data modeling decision matrix for modern data warehousing
Developed solution and integration architecture for network connectivity from on-premise to Azure Synapse Analytics using ExpressRoute
Azure onboarding, Synapse Analytics workspace deployment, concept for Azure RBAC, custom RBAC roles, Synapse RBAC
Set up Azure access for Synapse Analytics on Azure Gen2 storage account container with SAP data from another Azure subscription
Designed Synapse Analytics serverless external tables and view generation on Parquet and Delta tables in Azure Gen2
Modeled Power BI datasets for Power BI Premium workspace
Planned Synapse multi-team development
Validated Synapse Spark pool partitioned Delta table with derived columns as partition keys
Designed self-service data access for different business units on Synapse Serverless SQL Pool including row-level and column-level security
Created solution and integration architecture for Azure Machine Learning, Azure Cosmos DB, AI Services
Built solution and integration architecture for Azure AI Services Document Intelligence, OpenAI, Cognitive Search, Translator Language and connectivity via REST API to external cloud
Designed historization and delta load for dimension and fact data in Synapse using data flows
Created and coordinated solution and integration architecture for an additional Azure subscription with Azure Data Factory to connect external cloud providers
Integrated MS Self-Hosted Integration Runtime for on-premise data integration of Oracle, MySQL, SQL Server
Implemented Azure DevOps CI/CD for Synapse artifacts, ARM templates, and Terraform for IaC
Implemented Azure MLOps, AI Services, container instances, Kubernetes cluster, Azure Functions
Presented MS Purview
Evaluated and went live with MS Fabric, OneLake, Data Mesh features, security layers, shortcuts, governance and compliance, Synapse/Fabric feature mapping, semantic links, data gateway, migration to Fabric
Technologies/Standards used: Azure Synapse Analytics, Azure ML, MS Fabric, Azure DevOps, ADF, Power BI Premium, SSMS, Python, Synapse Studio, ML Studio, VS Code, PowerShell, GIT, Scrum

Apr 2021 - Apr 2022

1 year 1 month

Architect and new development of an analytics platform in the Azure Cloud

IT-Consulting

Project for a client in the insurance industry.
Analyzed and documented technical data flows and business requirements
Presented best practices
Advised on implementing new BI solutions
Created and aligned the Azure solution and integration architecture for Synapse Analytics extension
Azure RBAC, custom RBAC roles, Synapse RBAC
Defined data models and management processes
Modeled in Power BI Desktop
Calculated KPIs using Power BI DAX measures
Built dashboard for sales controlling, 360-degree sales, and product management
Provided detailed KPI views via drill-through and bookmarks
Implemented cross-report drill-throughs
Created a Power BI authorization concept
Designed and implemented dynamic Power BI row-level security
Technologies/Standards used: Azure Synapse Analytics, Azure DevOps, Data Factory, Azure Data Lake Gen2, Synapse Studio, SSMS, Visual Studio, Power BI Desktop, Report Builder, Power BI Premium, M Query, PowerShell, Python, Git

Feb 2021 - Oct 2021

9 months

Architect and new development of Power BI reporting on-premise with DWH connection

IT-Consulting

Project for a client in the finance industry.
Analyzed existing reporting based on SSRS and IBM Cognos BI
Modeled and designed SSRS inventory reporting with Power BI Desktop RS and Report Builder
Designed and integrated SSAS Tabular server mode
Installed, set up, and connected Visual Studio with SSAS project extension
Modeled and built SSAS Tabular models
Integrated Power BI DAX measures for income, portfolio, and interest rate management ratios into a monthly monitoring system
Designed and integrated dynamic row-level security based on table-based sales structure data across multiple hierarchical levels
Implemented SSRS Power BI reports with live connection to Analysis Services tabular models
Technologies/Standards used: MS SQL Server 2016, SSRS, SSMS, Visual Studio 2019, Power BI Desktop RS, Report Builder, SQL, T-SQL, DAX, M Query, Git

Oct 2018 - Mar 2021

2 years 6 months

Architect and new development of a DWH and BI platform in the Azure Cloud

IT-Consulting

Project for a client in the finance industry.
Analyzed existing reporting of the standard environment agree21/IDA
PoC Microsoft Power BI focusing on architecture, security, features and services vs. Cognos BI, analyst evaluations, cost calculation, decision matrix
Layer architecture: Data Vault, data mart star schemas, Power BI modeling of data marts, financial controlling
Created requirements and authorization concept for Power BI Premium
Designed historization with SCD Type 2 plus temporal in the data mart layer
Data modeling of star schemas for costs, commission, plan data, security, and time dimension including multiple hierarchies
Designed and implemented dynamic row-level security based on the DWH data model integrated into Power BI RLS
Designed a deployment concept for Power BI based on Azure DevOps
Implemented ETL job pipelines in Azure Data Factory
Modeled in-memory aggregation tables in Power BI Desktop
Modeled SSIS DWH inbound interfaces from staging, persistent staging, Data Vault raw/core/business to data mart layer
Modeled Power BI Desktop data marts for costs, commissions, net interest income, relative date attributes for period comparisons, switchable measures, DAX expressions for comparative and planned values, and selective output at different hierarchy levels
Designed and implemented various Power BI reports and dashboards with slicers, hierarchy slicers, search fields, and drill-through to detailed data
Connected a Power BI on-premises gateway to an Azure SQL Database
Created paginated reports with Power BI Report Builder using shared datasets in the Power BI Service
Modeled and developed an outbound interface for futures transactions to VR-Control
Designed and implemented a release process for reporting posting periods in Power BI
Technologies/Standards used: Azure SQL Database, Azure DevOps, Data Factory, SSIS-IR, Azure Data Lake Gen2, SSMS, Visual Studio, Power BI Desktop, Report Builder, Power BI Premium, Data Vault 2.0, SQL, T-SQL, PL/SQL, DAX, M Query, Git, Scrum

Jul 2014 - Sep 2018

4 years 3 months

Group Reporting DWH and BI

IT-Consulting

Project for a client in the finance industry.
Designed and implemented ETL processes for SolvV, equity, Finrep, MREL, and data quality measurement system
Data modeling and dimension management with SCD Type 2 and 6, monthly, daily, sub-daily, audit-proof correction loading
Designed and implemented rejection interfaces
Created a dynamic mapping system
Developed technical architecture diagrams
Reviewed and coordinated technical concepts and effort estimates
Managed change, rollout, and patch management
DBA tasks: sizing, management, monitoring, tuning, advanced security
Designed an upload interface
Platform migrations from SPARC to x86
Connected a DB2 gateway
Designed and implemented dynamic cubes for equity, Finrep, and MREL
Performed data mining
Implemented Oracle Transparent Data Encryption
Technologies/Standards used: SAP IQ 15 and 16, SQL Server 2012 and 2016, Oracle 11 and 12c, DB2 10 and 11, Hadoop, Solaris 10, Red Hat Linux 7, Docker, IBM Cognos BI 10 and 11, Apparo Fastedit 2 and 3, SQL, T-SQL, PL/SQL, Unix shells, Perl, IBM ClearCase, UC4 Automic 10, Informatica 9 and 10, ER/Studio, PowerDesigner, Abacus Davinci, HP Service Manager, HP Quality Center, C:D, iFG, Kanban, Scrum