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.

Azure Databricks, Data Mining, Data Science, Datawarehouse / DWH, Microsoft Azure, Projektleitung / Teamleitung (IT), Python, Software Architektur / Modellierung, Transact-SQL (T-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.

Datawarehouse / DWH, Microsoft Power Apps, Microsoft Power BI, Microsoft SQL-Server (MS SQL), Microsoft SQL Server Integration Services (SSIS), SQL, Transact-SQL (T-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.

Azure Databricks, DevOps, Git, Microsoft Azure, Microsoft Power Apps, Microsoft 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#, Datawarehouse / DWH, Microsoft 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 (MDX), Oracle Business Intelligence (BI), SQL, Transact-SQL (T-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, Datawarehouse / DWH, Microsoft Azure, Microsoft 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 (MDX), Transact-SQL (T-SQL), VBA (Visual Basic for Applications)