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 SolutionTasks:- 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 EnergyTasks:- 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 DWHCustomer: 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) DWTasks:- 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 BDWTasks:- 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-MigrationTasks:- 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 InformaticaCustomer: 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 StructuresCustomer: 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