Klaus Köhne-volland
Azure Cloud Solution Architect
Erfahrungen
Apr. 2022 - Bis heute
2 Jahren 11 MonatenAzure Cloud Solution Architect
IT Consulting
- Analytics Study on Cloud vs. On-Premise Strategy, Data Modeling, Modern Data Warehousing and Data Mesh
- End-to-End PoC Azure Synapse Analytics bis Power BI Premium based on a purchasing use case
- Creation of a Data Modeling Decision Matrix for Modern Data Warehousing
- Creation of Solution and Integration Architecture for Network Connectivity On-Premise to Azure Synapse Analytics based on ExpressRoute
- Azure On-Boarding, Synapse Analytics Workspace Deployment, Concept for Azure RBAC, RBAC Custom Roles, Synapse RBAC
- Setup Azure Access Synapse Analytics on Azure Gen2 Storage Account Container with SAP data from another Azure subscription
- Conception of Synapse Analytics Serverless External Table and View Generation on Parquet and Delta Tables in Azure Gen2
- Modeling Power BI Datasets for Power BI Premium Workspace
- Conception Synapse Multi-Team Development
- Validation Synapse Spark Pool Partitioned Delta Table with derived columns as partition key
- Conception of self-service data access for different business units on Synapse Serverless SQL Pool incl. Row Level and Column Level Security
- Creation of Solution and Integration Architecture for Azure Machine Learning, Azure Cosmos DB, AI Services
- Build Solution und Integration Architecture for Azure AI Services Document Intelligence, OpenAI, Cognitive Search, Translator Language and Connectivity via REST API to external Cloud
- Concept, historization and delta load DIM and FACT data in Synapse by Data Flows
- Creation and coordination of the solution and integration architecture of an additional Azure subscription with Azure Data Factory to connect external cloud providers
- Integration MS Self Hosted Integration Runtime for On-Premise Data Integration of Oracle, MySQL, SQL Server
- Implementation of Azure DevOps CI/CD for Synapse artifacts, ARM Templates, and Terraforms for IaC
- Implementation of Azure MLOps, AI Services, Container Instances, Kubernetes Cluster, Azure Functions
- Presentation MS Purview
- Evaluation and go live of MS Fabric, OneLake, Data Mesh Features, Security Layers, Shortcuts, Governance und Compliance, Synapse/Fabric Feature Mapping, Semantic Links, Data Gateway, Migration to Fabric
Technologies/Standards: 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 Jahr 1 MonateAnalytics Platform Architect
IT Consulting
- Analysis and recording of technical data flows as well as business requirements
- Presentation of best practices
- Advice on the implementation of new BI solutions
- Creation and alignment of the Azure Solution and Integration Architecture for Synapse Analytics
- Azure RBAC, RBAC Custom Roles, Synapse RBAC
- Structural definition of the data models and management processes
- Modeling in Power BI Desktop
- Calculation of KPIs via Power BI DAX Measures
- Dashboard for sales controlling, 360-degree sales and product management
- Detailed views of KPIs via drill-through and bookmarks
- Realisierung Cross-Report Drill-Throughs
- Creation of a Power BI authorization concept
- Design and implementation of a dynamic Power BI RLS
Technologies/Standards: 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 - Okt. 2021
9 MonatenPower BI Developer
IT Consulting
- Analysis of actual reporting based on SSRS and IBM Cognos BI
- Modeling and design of SSRS inventory reporting with Power BI Desktop RS and Report Builder
- Design and integration of SSAS Tabular server mode
- Installation, Setup and Initial Connection Visual Studio with SSAS Project Extension
- Modeling and Build SSAS Tabular Models
- Integration of Power BI DAX measures for income, portfolio and interest rate ratios into a monthly monitoring system
- Design and integration of dynamic row level security based on table-based sales structure data across multiple hierarchical levels
- Implementation of SSRS Power BI Reports with connection to hard tab models Analysis Service Connect live
Technologies/Standards: MS SQL Server2016, MS SSRS, MS SSMS, MS Visual Studio 2019, Power BI Desktop RS, Report Builder, SQL, TSQL, DAX, M Query, Git
Okt. 2018 - März 2021
2 Jahren 6 MonatenDWH and BI Architect
IT Consulting
- Analysis of the actual reporting of the standard environment agree21/IDA
- PoC Microsoft Power BI in the focus areas of architecture, security, features and services Power BI vs. Cognos BI, analyst evaluations of the BI market, cost calculation, decision matrix
- Layer Architecture: Data Vault to Data Mart Star Schemes, Power BI Modeling of Data Marts, Financial Controlling
- Creation of Requirements and Authorization Concept for Power BI Premium
- Conception of the historization SCD Type 2 plus Temporal in the data mart layer
- Data modelling of the star schemes costs, commission, plan data, security and the dimension time including multi-hierarchies
- Concept and implementation of a dynamic row level security based on the DWH data model with integration into the Power BI RLS
- Design of a deployment concept for Power BI based on Azure DevOps
- Implementing ETL Job Pipelines in the Azure Data Factory
- Modeling In-Memory Aggregation Tables in Power BI Desktop
- Modeling SSIS DWH Inbound Interfaces from Staging, Persistent Staging, Data Vault Raw/Core/Business to Data Mart Layer
- Power BI Desktop Modeling of data marts costs, commissions, net interest income, relative date attributes for period comparisons, switchable measures, DAX expressions for calculating comparative and planned values as well as selective output at different hierarchical levels
- Layout design and implementation of various Power BI reports and dashboards with slicers, hierarchy slicers and search fields, drill-through reporting in detailed data
- Connection of a Power BI On-Premises Gateway for a dedicated connection to an Azure SQL Database
- Realization of paginated reports with Power BI Report Builder with connectivity on shared datasets in the Power BI Service
- Modelling and development of an outbound interface for futures transactions to VR-Control
- Design and implementation of a release process for reporting posting periods in Power BI
Technologies/Standards: Azure SQL Database 12, Azure DevOps, Data Factory, SSIS-IR, Azure Data Lake Gen2, MS SSMS, MS Visual Studio, Power BI Desktop, Report Builder, Power BI Premium, Data Vault 2.0, SQL, TSQL, PL/SQL, DAX, M Query, Git, Scrum
Juli 2014 - Sept. 2018
4 Jahren 3 MonatenDWH and BI Developer
IT Consulting
- Conception and implementation of ETL processes in the areas of SolvV, equity, Finrep, MREL, data quality measurement point system
- Data modelling and dimension management according to SCD type 2 and 6, monthly, daily, underground, audit-proof correction loading
- Design and implementation of rejection interfaces
- Conception of a dynamic mapping system
- Creation of technical architecture diagrams
- Review and coordination of technical concepts, effort estimates
- Change-, Rollout-, Patch-Management
- DBA, Sizing, Management, Monitoring, Tuning, Advanced Security
- Design of an upload interface
- Platform Migrations Sparc to x86
- Connection of a DB2 gateway
- Conception and implementation of Dynamic Cubes in the areas of equity, Finrep and MREL
- Data Mining
- Implementation of Oracle Transparent Data Encryption
Technologies/Standards: SAP IQ 15/16, SQL Server 2012/2016, Oracle 11/12c, DB2 10/11, Hadoop, Solaris 10, Redhat Linux 7, Docker, IBM Cognos BI 10/11, Apparo Fastedit 2/3, SQL, TSQL, PL/SQL, Unix Shells, Perl, IBM ClearCase, UC4 Automic 10, Informatica 9/10, ER Studio, Powerdesigner, Abacus Davinci, HP Service Manager, HP Quality Center, Kanban, Scrum
Sprachen
Deutsch
Muttersprache
Englisch
Verhandlungssicher
Französisch
Grundkenntnisse