Designing & Implementation of delta Lakehouse on sensor data (ingestion, Analytics)

Tasks:

• Designing the Architecture for Lakehouse in Microsoft Azure Cloud
• Implementation of Landing Zone using Azure Databricks (Redis, Azure Function)
• Customizable Framework to implement curated and Serving zone in Azure Databricks (Python)
• Automated ETL/ELT Architecture using Azure Data Factory Pipelines
• ETL strategy for import of Billions of JSON files
• Multiple JSON files with all dynamic Pivoting, Flatten and schema operations using Databricks python notebooks.
• Controlling Table contents & Columns of ALL JSONS Business lines
• Performance & Optimization Techniques on terabytes of data
• Complete Power BI Dashboard for all serving tables.

Skills:
Data Lake, Data Factory, Databricks, Python (PySpark+SQL ,Panda), ESB, Azure Function, Power BI, Dedicated SQL Pool ,Azure DevOps CI/CD ,Git repo, Microsoft Fabrics Platform

---

Designing & Implementation of Microsoft Dynamic 365 Solution (Finance, Order, Product Catalogue Modules)

Tasks:

• Designing the Architecture for D365 in Microsoft Azure Cloud
• Implementation of Landing Zone using Azure Databricks (Redis, Azure Function)
• Customizable Framework to implement curated and Serving zone in Azure Databricks (Python)
• Automated ETL/ELT Architecture using Azure Data Factory Pipelines
• ETL strategy for import of Entities in .CSV files & Model Jsons from ADLS(Changefeed)
• Handling Multiple CSV files and other formats on ADLS Gen2 using automated ETL/ELT Pipelines
• Controlling Table contents & Columns of ALL D365 Entities
• Performance & Optimization Techniques
• Complete Power BI Dashboard for D365

Skills:
Data Lake, Data Factory, Data Bricks, Python, Spark, Azure Function, Power BI Project Management: Azure DevOps with Agile Methodology (CI/CD)-Git

---

Designing & Implementation of Customer360 Solution(Finance, Order, Product Catalogue Modules)

Tasks:

• Designing the Architecture for Customer360 in Microsoft Azure Cloud
• Implementation of Landing Zone using Azure Synapse Pipelines
• Customizable Framework to implement curated and Serving zone in Azure Synapse Workspace
• Automated ETL/ELT Architecture on Azure Synapse
• ETL strategy for import of complex unstructured Files and Raw data from SAP CRM and ERP Systems
• Handling Multiple CSV files and other formats on ADLS Gen2 using automated ETL/ELT Pipelines
• Controlling Table contents & Columns with Synapse Integrate
• Performance & Optimization Techniques
• Complete Power BI Dashboard of C360 Data from CRM

Skills:
Data Lake, Data Factory, Data Bricks, Azure Synapse, Power BI, snowflake, Project Management: Azure DevOps with Agile Methodology-(CI/CD)-Git

---

Designing & Implementation of Data Lake Solution

Tasks:

• Designing Architecture for DATA PLATFORM in Microsoft Azure Cloud
• Cost effective ADLS GEN 2 Solution to handle multiple Source Systems on VMS
• Implementation of Landing Zone using Databricks
• Customizable Framework to implement curated and Serving zone
• Automated ETL/ELT Architecture for complex source systems
• ETL strategy for import of complex Events Data (more than 80 K JSON Files)
• Handling Multiple JSON files and other formats on ADLS Gen2 using automated Framework
• Controlling Table contents & Columns with Databricks
• Performance & Optimization Techniques

Skills:
Data Lake, Data Factory, Data Bricks, Microsoft SSAS, Power BI, Tableau, snowflake, Project Management: Azure DevOps with Agile Methodology-(CI/CD)-Git

---

Global Survey Dashboard for E. ON Energy

Tasks:

• Survey Data for Customers & Non-Customers Suppliers for Multiple Countries
• Implementation of complete Data Warehouse for Survey Data in Microsoft Azure Cloud
• Cost effective Infrastructure in Azure cloud to handle multiple regional Source Systems
• Implementation of Power BI Gen2 Analytics/Reports using Fact & Dimensional Survey data
• Complex data modelling to bring RLS Features
• Automated ETL/ELT Architecture for complex source systems
• ETL strategy for import of complex survey Data (more than 2000 columns in 1 file)
• Handling Multiple CSV files on ADLS Gen2 using automated current & Archiving Procedures
• Transformation of CSV or JSON files into SQL Tables using Data Bricks
• Controlling Table contents & Columns with Databricks
• Performance & Optimization Techniques
• Monitoring Dashboard of ALL ETL/ELT

Skills:
Power BI, Azure Synapse WS, Data Lake, Azure Data Factory, Data Bricks, Power BI, Project Management: Azure DevOps-(CI/CD)-Git

---

Global Sales Dashboard for Hays Clients?- Sales-Channels integration using APIs? Azure (BI&DWH)

Customer: ISMO GmbH (Playmobil Global Product Catalogue Module)

Tasks:

• Implementation of Data Warehouse for Global Sales Data in Azure Cloud
• State-Of-the-Art Infrastructure in Azure cloud to handle the data dynamically.
• Implementation of Power BI Analytics/Reports using Amazon, Print Media & TV & Social Media Data
• ETL Architecture for Web services of Global retail marketplaces
• ETL strategy for Web services
• Handling Multiple CSV files over SharePoint or ftp server
• Atomization of CSV or JSON files into synapse Tables
• Controlling Table contents & Columns with pipelines
• Performance & Optimization Techniques
• Cost effective azure on/off resources
• Power Automate utilizations for smooth executions
• Azure DevOps implementation

Skills:
Power BI, Azure Synapse, Data Lake, Azure Data Factory, Data Bricks, AWS Amazon Redshift, AWS Glue, Project Management: Azure DevOps-(CI/CD)-Git, Research Project- Senior Data Specialist Azure Cloud-Free lancer

---

Sensor Data Operate Project? Azure (BI&DWH)

Customer: Sycor GmbH
Role: Senior BI & DWH Specialist

Tasks:

• Design and development of custom warehouse using Microsoft technologies
• Gather business requirements from business users and functional consultants.
• Preparing the design documents
• Implementation of Data Warehouse & Implementation of Analysis Service model
• Implementation of Power BI Analytics/Reports.
• ETL Architecture: Defining ETL strategy ? keeping in consideration the architecture of data warehouse and volume of data
• Data migration through SQL routines, legacy ETL tools and Azure.
• Data validation through test scripts.
• Performance tuning of ETL through modification in SQL scripts, hints, indexes, table partitioning, optimized database parameters etc.
• Performance tuning of Data lake optimization using Delta tables, partitioning, Zorder etc.
• Implementing solutions to optimize the recurring Cost on Azure based projects.

Skills:
Tableau, Azure Synapse, Data Lake, BLOB Storage, SSAS, Data Factory, Data Bricks, Pyspark, Language (ETL): Python, C#, SQL, Java, R, Scala, DAX, Project Management: Azure DevOps(CI/CD)-Git

---

D365 Finance & Operations, D365 for Retail (BI&DWH)

Customer: Aloys F. Dornbracht GmbH & Co. KG
Role: Senior Software Specialist (BI & DWH)

Tasks:

• Use of Data Management Framework in D 365 F&O and D365 Retail
• Automation of data entities using BYOD & Azure Data Lake
• Implantation of Common data Service with Azure Data Lake
• Implementation state-of-the-art: ETL or ELT options in Cloud
• Link & connect: Power BI Pro to Azure Data Lake using aggregated standard data entities
• Link & Connect: AZURE Data Warehouse to on premise DB using SSIS & Azure data Factory
• Link & connect: Azure Data Warehouse to Power BI pro
• Link & connect: Azure Data Warehouse to Azure Analysis Services
• Link & connect: Run & Execute ML algorithms in azure
• Azure cloud data management

Skills:
Visual Studio (SSIS, SSAS, SSRS), Management Studio (2017), Azure Data Factory, Azure Cloud, Data Lake, Data Bricks, Power BI Pro, BYOD, Cloud DWH DB, ML Studio Project Management: DevOps & Scrum

---

Sales & Margin, Order Entry, Finance, Order on Hand (BI&DWH)

Customer: Beontra GmbH
Role: Data Warehouse/Business Intelligence Consultant

Tasks:

• Migration & Review of OLD ETL design & Architecture (2005,2012)
• Code Review & Refactoring on Known SQL Bugs (Dimensions, Fact tables)
• Data Modelling & RE-Design (Architecture: Star Schema, Snow Flake Schema)
• Atomization of Excel Files with Email Confirmation
• Creation of new Production & Test System: Rerun Strategy
• Financial Data Mart (Income Statement, Balance Sheet, General Account)

Skills:
Visual Studio (SSIS, SSAS, SSRS), Management Studio (2017), Share Point, Microsoft Team Foundation, Service Manager Console, SCRUM, AX System, CRM, DevOps, Jenkin, SVN, GIT

---

B_ANALYTICS, B_TACTICAL & B_CAPACITY Airport DWH

Customer: Adastra GmbH
Role: Data Warehouse/Business Development Consultant

Tasks:

• ETL Implementation (SCD 1..3,Data Transformations)
• Data Profiling (Validation, Cleaning, Standardization)
• Data Modelling & Design (Architecture: Star Schema, Snow Flake Schema)
• Work on New & existing Business Logic and Processes for Sensor Data
• Development of Data Marts for Aviation and Non-Aviation Business
• Financial Data Mart (Income Statement, Balance Sheet, General Account)

Skills:
Pentaho PDI, Pentaho BI Reporter, Pentaho Workbench, Oracle, HP Vertica

---

Volkswagen AG, VSC (Vorserien Center) DW

Tasks:

• ETL Implementation and DWH assessment
• Business Logic & Process: Requirements Analysis for DWH
• Business Logic & Process: Restructuring of existing DWH
• DWH & ETL: Development of Data Marts (Star Schema, Snow Flake Schema)
• Integration: Developed Data Marts with Business Object Universes

Skills:
Informatica PowerCenter, MS SQL Server 2014 (SSIS, SSAS), SQL, PL-SQL, Oracle, SAP BusinessObjects XI, IT Operation Environment: ITIL Processes, SIAM Framework

---

Volkswagen AG, Business Data Warehouse BDW

Tasks:

• Data Flow: Planning & Analysis of Existing DWH
• Data Modelling: Refactoring of Database & Restructuring of Tables
• Migration: PL-SQL Procedures to ETL Development
• Workflow Monitoring & Scheduling Tasks
• Testing (Requirements ->Mapping-> sessions-> workflows)

Skills:
Informatica Power Centre, MS SQL Server SSIS, SSAS, PL-SQL, Oracle IT Operation Environment: ITIL Processes

---

SAP Business Objects Xi4 Training (August 2013)

Tasks:

• Basic Implementations: Objects, Classes & DB Schema, Filter, Hierarchy
• Creation & Optimization: BO Universes Meta Data handling with BO
• Usage: Universes view in WEBi

Skills:
BusinessObjects Web Intelligence, BusinessObjects Universe Design

---

Oracle APEX Training (Mai - June 2013)

Tasks:

• Development: Web sheets, Database and Packaged Applications
• WEB Development: Pages (interactive, responsive, secured, validated)
• Reports: wizard, classic, interactive, webservice
• Charts: Line, Pie & Doughnut, Column, Horizontal Bar, Candlestick, Gantt Application
• Development: Metadata Handling & Data Loading on WEB
• Integration: Plug-ins (Java, JavaScript)

Skills:
SQL, PL-SQL, JEE, Oracle

---

03/2013 - 05/2013: Internes Project QA-FRAMEWORK: Oracle-Migration

Tasks:

• MS SQL: Analyses of Procedures (Current Framework)
• PL-SQL: Planning & Implementation of Procedures (New Framework)
• Code: Exchange Partitions Procedure
• Optimization: Statistics Gathering Procedure
• Development in PL-SQL: Logging-, QA- und QA Test-Procedures
• Auto Documentation using XML approach.

Skills:
MS SQL Server-SQL, PL-SQL, Oracle

---

02/2013: Training in Informatica

Customer: DIMQ GmbH - Köln, Deutschland
Role: Data Warehouse Developer

Tasks:

• ETL Fundamentals
• PowerCenter Transformations, Tasks und workflow management Joins and Link Conditions Sequence Generators, Lookups and Caching Update Strategies, Routers und Overrides Sorter, Aggregator, Unconnected Lookups
• Mapping Parameter/Variables and Mapplets /Worklets.
• Parameter Files and Command Tasks

Skills:
IPC, SQL, PL-SQL, JEE, Oracle

---

Implementation of Tree-Structure with IPC or PL-SQL Structures

Customer: Siemens AG - München, Deutschland
Role: Student

Tasks:

• Planning and Analyses of all Process and Reports
• Database Modelling & Development (Physical)
• ETL Development
• Re-structuring, Testing & Monitoring
• Documentation

Skills:
Informatica PowerCenter, SQL, PL-SQL, Oracle

---

Master thesis

Tasks:

• Business Intelligence & Software Engineering ?Study of state-of-the-art in Data Warehousing and Cloud Storage in context of future integrated Architectures?
• Research in Business Intelligence, Database & Cloud Computing

Skills:
Windows Azure, Amazon, SAP BIOD, Informatica PowerCenter, J2EE , HTML 5

Customer: Via Software GmbH - Dreieich, Deutschland
Role: In-House Software Developer

Tasks:

• Interface Design
• Database Design
• Software Development

Skills:
PHP4, Java (J2EE Framework, J2SE Framework), Java Beans, Java-Script, Eclipse, Dreamweaver, JBuilder X, JBoss, Sun App. Server, Apache web Application Server, Visio, Ms Project