Cloud Data & AI Solution Architect | Senior BI Consultant

2/2021 – 6/2021

Development of workflows and a web app for the digitalization of documents, text analytics and semantic search.

- Conceptual design and feasibility analysis (operational, technical, QA, etc.).
- Development of a sustainable, robust and automatic text recognition (OCR) method for multilingual (scanned) documents.
- Research and development of document processing and Deep Learning methods for the automatic document layout understanding.
- Realization of Computer Vision and AI-based methods for the identification and recognition of text-objects inside documents and the extraction of their content in a structured format.
- Intelligent and automatic classification and categorization of documents based on data/text mining and pattern recognition techniques.

Technologies: MS SQL Server, MS Azure technologies, Python, Github/Gitlab, JIRA, Confluence.

Databricks, Data Mining, Data Science, Data Warehousing, Microsoft Azure, Projektleitung / Teamleitung (IT), Python, Software Architecture, Transact-Sql

5/2020 – 2/2021

- Conceptualization, Design Thinking and implementation of a digital transformation roadmap incl. strategic data modelling and democratization.
- Legacy DWH architecture modernization and optimization, as well as application rationalization.
- Performance analysis and optimization of DWH, ETL processes, T-SQL queries and stored procedures.
- Analysis, design and implementation of a dynamic security role application concept.
- Data-driven analysis and determination of disturbing factors for the improvement of application quality and Customer Experience in operative systems.

Technologies: MS SQL Server (SSIS, T-SQL), Excel, Power Pivot, Power Query, SQL Server Profiler, Power BI, Github, Confluence, JIRA.

Data Warehousing, Powerapps, Power Bi, Microsoft SQL-Server (MS SQL), Microsoft SQL Server Integration Services (SSIS), SQL, Transact-Sql

10/2018 – 4/2020

Realization of a modern Enterprise Data Platform and data migration from a legacy DWH system

- Analysis of legacy monolithic DWH platform status, technical debts, platform bottlenecks, organizational boundaries and data life-cycle.
- Feasibility analysis and implementation of a new modular, decoupled and collaborative DPAAS (Data Products as a Service) Enterprise architecture.
- Definition of transformation strategy incl. the security concept from the legacy monolithic architecture to a cloud-native architecture, ensuring cross-organizational compliance.
- Implementation of strategies for data migration, data governance, data quality, data modeling, data lineage, data literacy, Master Data Management, monitoring and data orchestration.
- Development of a lean and effective Target Operating Model (TOM).
- Building an Enterprise Scale Data Management & Analytics Landing Zone’s architecture.
- Realization of an automated on-demand provisioning process of Data Engineering workspaces (Sandboxes) for data engineers and ML/AI/data scientists.
- Development and implementation of build/release/deployment pipelines incl. IaC (CI/CD, DevOps and DataOps).
- Development of various MVP, Use Cases and Microservices.

Technologies: MS SQL Server, MS Azure ecosystem technologies, Terraform, Kubernetes, Docker, Databricks (pySpark, Python, pySQL), Power BI, Power Apps, Github, Confluence, JIRA.

Databricks, DevOps, Git, Microsoft Azure, Powerapps, Power Bi, Microsoft SQL-Server (MS SQL)

2/2018 – 2/2021

Realization (design, development, testing and roll out) of a multi-layer DWH architecture for data analysis and reporting, incl. 3rd Level Support.

- Conceptual design and implementation of a complex ETL solution for data evaluation and consolidation from different underlying source systems.
- Design and development of multi-layer DWH architecture, incl. data source and extraction layer, staging area, data cleansing, business and presentation layers, as per Kimball DWH design methodologies.
- Responsible for maintaining the DWH database schemas, entity relationship diagrams, data modeling, tables, stored procedures, functions, constraints, indexes, views and complex SQL statements.
- Performance tuning/optimization of T-SQL queries and ETL processes.
- Creation of jobs, alerts and scheduled executions of SSIS Packages using SQL Server Agent.
- Designing, prototyping and developing high-visibility interactive dashboard solution for operational and functional reporting, providing tracking of different Key Performance Indicators (KPIs) and metrics from ODS and OLAP cubes.
- Monitoring full, incremental and daily loads and supporting all scheduled ETL jobs for batch processing.
- Responsible for doing deployments between different environments and maintaining version control using MS Team Foundation Server (TFS).
- Creation of technical specification and ETL mapping documents with entity relationship and UML diagrams.

Technologies: MS SQL Server (SSIS, SSAS, SSRS, T-SQL, MDX), Oracle DB 11g, Excel (Power Pivot, Pivot Tables), SharePoint (Dashboards, ScoreCards), VBA, C#.

C#, Data Warehousing, Power Bi, Microsoft SQL-Server (MS SQL), Microsoft SQL Server Analysis Services (SSAS), Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), MultiDimensional EXpressions, Oracle Business Intelligence (BI), SQL, Transact-Sql, VBA (Visual Basic for Applications)

2/2017 – 10/2018

Development of a cloud-based and AI-powered material quality control system for car seats in automobile industry, in the field of interconnected devices and IoT.

- Conceptual design, feasibility analysis and data strategy based on customer needs.
- Carve-out of data science operations unit for industrialized delivery with specific service catalogue (A/B- and multivariate testing, use case automation, code standardization, scalability, etc.).
- Development of a ML/AI-powered cloud-based solution for the automatic material quality control of car seats based on high-resolution cameras and optical sensors.
- Automatic data-driven report of product condition based on real-time cognitive results.
- Automatic detection and classification of the detected wrinkles, damages and defects.

Technologies: MS Azure, Excel, Power BI, Python, Computer Vision, Data Analytics, Github, JIRA.

Data Science, Data Warehousing, Microsoft Azure, Power Bi

11/2015 – 1/2017

Realization of a DWH, OLAP and Reporting solution for an international finance company to consolidate and generate its financial reports.

- Analysis and verification of the newly defined business and technical requirements.
- Development of cross-functional architecture and utilization of centralized consolidation with high level of standardization to ensure security, compliance, data validity and quality standards.
- Extension of legacy DWH architecture, dimensionality optimization and development of OLAP cubes.
- Realization (design, implementation and quality testing) of user interfaces and ETL processes to check data integrity and to perform data cleansing, data profiling and data transformation.
- Development of migrations strategies to cloud and overcoming the internal data silo issues.
- Development of a data-layer structure for daily cash-flow analysis, evaluation and reporting.
- Optimization of SSIS (ETL) packages to improve the daily load performance using SQL performance tuning methodologies.
- Design and implementation of business Operational Data Storage (ODS) to integrate corporate data from different heterogeneous data sources, in order to facilitate operational reporting.

Technologies: Hyperion, MS Azure, MS SQL Server (SSIS, SSAS), Excel (Power Pivot, Pivot Tables), BIML, MDX, C#.

C#, Microsoft Azure, Microsoft SharePoint Server, Microsoft SQL-Server (MS SQL), Microsoft SQL Server Analysis Services (SSAS), Microsoft SQL Server Integration Services (SSIS), MultiDimensional EXpressions, Transact-Sql, VBA (Visual Basic for Applications)