BI sowie DWH Entwicklung mit Microsoft. Sowie Data Science mit R und Python. Big Data Entwicklung mit Pyspark.
Aktualisiert am 18.03.2022
Profil
Freiberufler / Selbstständiger
Remote-Arbeit
Verfügbar ab: 01.01.2023
Verfügbar zu: 100%
davon vor Ort: 100%
Data Engineering
SSIS
Microsoft-SQL-Server
Apache Hop
Python
Matillion
Kafka
Pyspark
Databricks
Redshift
SSAS
SSIS
Pentaho
Beautifulsoup
API
FastAPI
Microsoft Azure
Big Data
Postgres
Dutch
English
German
Spanish
Turkish

Einsatzorte

Einsatzorte

Düsseldorf (+20km) Essen (+75km) Mülheim an der Ruhr (+20km) Ibbenbüren (+75km)
möglich

Projekte

Projekte

5 Jahre 2 Monate
2019-02 - heute

Datawarehouse and Cube Developement

Developer Datawarehousing Python Web Scraping ...
Developer
  • Conceptioning of data pipelines from start to finish
  • Accessing datahubs for over 10 datasources via API-Requests
  • Scraping eCommerce data from websites with Selenium
  • Parse the data with beautifulsoup (Python)
  • Building ETL Pipelines with Matillion, Python, TSQL and SSIS
  • Model the data in SQL-Server and Redshift
  • Building Multidimensional OLAP Cubes in SSAS
Redshift S3 Matillion Python Beautifulsoup SSIS Sql-Server SSAS
Datawarehousing Python Web Scraping SSIS MS SSAS
Düsseldorf
1 Jahr
2018-02 - 2019-01

Building Datawarehouse

Developer Kafka MongoDB PySpark ...
Developer
  • Building Datawarehouse on Azure with Azure Data Factory
  • developing deduplication job in Hive / Scala
  • conceptioning real time dataflow of environment sensors (MQTT) to AWS
  • Automatic deployment of backup mechanisms (Zookeeper)
  • Connecting SAP to Datalake with Spark and Kerberos
HQL Scala TSQL AWS Python Ansible
Kafka MongoDB PySpark Pandas
Energy
Dortmund / Essen
2 Jahre 8 Monate
2015-10 - 2018-05

Requirements engineering

Developer SSIS Microsoft SQL Server 2014 BIML
Developer
  • Requirements engineering,
  • developement of monitoring system of loads,
  • loading datamarts with SCD1 with new data suppliers,
  • Social Media data ETL,
  • creating template system as well as visual autodocumentation system,
  • automated ETL with BIML,
  • DWH Loading with SSIS,
  • REST-API development C#
TSQL SSIS Apache (NIFI) SQL Server 2012 SSIS SSRS Tableau HortonWorks
SSIS Microsoft SQL Server 2014 BIML
Media
Düsseldorf
1 Monat
2015-09 - 2015-09

SAP Web Intelligence

Trainer
Trainer

Preparing and executing of enduser-trainings for Tool „SAP BusinessObjects Web Intelligence“

SAP BusinessObjects BI 4.1
Pharma
Hannover
3 Monate
2015-06 - 2015-08

Analysis car park utilization

Developer
Developer
  • Developement of loadjobs from CSV to SAP HANA via SAP BusinessObjects Data Services 4.2
  • modelling of Analytical Views in SAP HANA
  • Creating of a SAP Design Studio-Dashboard

SAP Data Services SAP HANA Cloud Platform. SAP Design Studio
IT-Consulting
Köln
1 Monat
2015-06 - 2015-06

SAP Business Objects Universe-Design-Tool

Trainer
Trainer

Preparing and executing developer-trainings for „SAP BusinessObjects Universe-Design-Tool“

Health insurance
Bochum
3 Monate
2015-04 - 2015-06

Salesreporting & Data Loading

Developer
Developer
  • Demand recording, developement of SAP BusinessObjects Data Services (BODS) based ETL-Jobs, incl. historization,
  • creating of a webscrapper (Python)
  • Universe developement (UDT)
  • WebIntelligence-Reporting
IT-Consulting
Köln

Aus- und Weiterbildung

Aus- und Weiterbildung

EDUCATION:

2007 - 2008

Institution: Hochschule Niederrhein

Abschluss: Dipl. Wirtsch.-Ing. (FH) 

2004 ? 2007

Institution: Fontys Hogeschool Venlo NL

Abschluss: Pre Degree 

2003 - 2004

Institution: Berufskolleg Kleve

Abschluss: Professional High School 

2000 - 2003

Institution: Convent Spedition GmbH & IHK

Abschluss: Truck Manager

CERTIFICATES & COURSES:

  • Query SQL Server 2012
  • Getting and Cleaning Data
  • Hadoop Certified Developer
  • R Programming
  • Scalable Machine Learning
  • Exploratory Data Analysis
  • Introduction to Big Data with
  • Apache Spark
  • SAP Business Warehouse powered by SAP
  • HANA
  • Process-Mining in Action
  • Quering with Transact-SQL
  • Computing for Data Analysis
  • Linux LPIC 101
  • Regression Models
  • Data Analysis
  • Developing Data Products
  • Practical Machine Learning
  • The Data Scientists Products

Kompetenzen

Kompetenzen

Top-Skills

Data Engineering SSIS Microsoft-SQL-Server Apache Hop Python Matillion Kafka Pyspark Databricks Redshift SSAS SSIS Pentaho Beautifulsoup API FastAPI Microsoft Azure Big Data Postgres

Produkte / Standards / Erfahrungen / Methoden

PROFILE:
ETL, Data-Mart Design, Vizualising and Big Data. Using Microsoft, Pentaho as well as SAP Tools. On Premise as well as Azure

LAST EMPL

06/2018 ? today:

Client: Innogy Consulting GmbH, Düsseldorf

Role: Senior Specialist Digital & Data

04/2015 ? 05/2018

Client: Rheindata GmbH, Köln

Role: Data Engineer

07/2011 ? 03/2015:

Client: Van Eupen Logistik GmbH, Essen

Role: IT-Prozessmanager

Tasks:

  • Development of a KPI-system based on Norm VDI4490
  • Conceptioning and development of DataMarts and ETL-Jobs (PDI) for DW
  • Developement of a monitoring system based on SQL2008 and DB2 for several
    departments
  • Programming dynamical performance-dashboards in realtime with Pentaho
    tools
  • Creating a recommendation system and order forecasting as webapplication
    with R and Shiny
  • Implementation of a EDI warningsystem incl. report bursting
  • Dataanalysis for processdefinition within new customer business as well as
    identification of processdrivers

03/2010 ? 06/2011

Client: Van Eupen Logistik GmbH, Essen

Role: Junior IT-Processmanager

Tasks:

  • Logistical process definition in contract logistics (fullfillment)
  • IT requirements engineering (Microsoft Dynamics NAV)
  • Accompanying new clients from first contact over process requirements,
    interface definition, programming overview, tests, implementation and training
  • Processanalysis and evaluation within controlling

09/2009 ? 02/2010

Client: Research institute GEMIT, Mönchengladbach

Role: scientific assistant

Tasks:

  • Taking care of logistical research projects
  • Acquisition of public and private subventioned research budgets with logistic
    / process relation (for NRW as well as Euregio)
  • Creating organizational manual for an international RFID project

Einsatzorte

Einsatzorte

Düsseldorf (+20km) Essen (+75km) Mülheim an der Ruhr (+20km) Ibbenbüren (+75km)
möglich

Projekte

Projekte

5 Jahre 2 Monate
2019-02 - heute

Datawarehouse and Cube Developement

Developer Datawarehousing Python Web Scraping ...
Developer
  • Conceptioning of data pipelines from start to finish
  • Accessing datahubs for over 10 datasources via API-Requests
  • Scraping eCommerce data from websites with Selenium
  • Parse the data with beautifulsoup (Python)
  • Building ETL Pipelines with Matillion, Python, TSQL and SSIS
  • Model the data in SQL-Server and Redshift
  • Building Multidimensional OLAP Cubes in SSAS
Redshift S3 Matillion Python Beautifulsoup SSIS Sql-Server SSAS
Datawarehousing Python Web Scraping SSIS MS SSAS
Düsseldorf
1 Jahr
2018-02 - 2019-01

Building Datawarehouse

Developer Kafka MongoDB PySpark ...
Developer
  • Building Datawarehouse on Azure with Azure Data Factory
  • developing deduplication job in Hive / Scala
  • conceptioning real time dataflow of environment sensors (MQTT) to AWS
  • Automatic deployment of backup mechanisms (Zookeeper)
  • Connecting SAP to Datalake with Spark and Kerberos
HQL Scala TSQL AWS Python Ansible
Kafka MongoDB PySpark Pandas
Energy
Dortmund / Essen
2 Jahre 8 Monate
2015-10 - 2018-05

Requirements engineering

Developer SSIS Microsoft SQL Server 2014 BIML
Developer
  • Requirements engineering,
  • developement of monitoring system of loads,
  • loading datamarts with SCD1 with new data suppliers,
  • Social Media data ETL,
  • creating template system as well as visual autodocumentation system,
  • automated ETL with BIML,
  • DWH Loading with SSIS,
  • REST-API development C#
TSQL SSIS Apache (NIFI) SQL Server 2012 SSIS SSRS Tableau HortonWorks
SSIS Microsoft SQL Server 2014 BIML
Media
Düsseldorf
1 Monat
2015-09 - 2015-09

SAP Web Intelligence

Trainer
Trainer

Preparing and executing of enduser-trainings for Tool „SAP BusinessObjects Web Intelligence“

SAP BusinessObjects BI 4.1
Pharma
Hannover
3 Monate
2015-06 - 2015-08

Analysis car park utilization

Developer
Developer
  • Developement of loadjobs from CSV to SAP HANA via SAP BusinessObjects Data Services 4.2
  • modelling of Analytical Views in SAP HANA
  • Creating of a SAP Design Studio-Dashboard

SAP Data Services SAP HANA Cloud Platform. SAP Design Studio
IT-Consulting
Köln
1 Monat
2015-06 - 2015-06

SAP Business Objects Universe-Design-Tool

Trainer
Trainer

Preparing and executing developer-trainings for „SAP BusinessObjects Universe-Design-Tool“

Health insurance
Bochum
3 Monate
2015-04 - 2015-06

Salesreporting & Data Loading

Developer
Developer
  • Demand recording, developement of SAP BusinessObjects Data Services (BODS) based ETL-Jobs, incl. historization,
  • creating of a webscrapper (Python)
  • Universe developement (UDT)
  • WebIntelligence-Reporting
IT-Consulting
Köln

Aus- und Weiterbildung

Aus- und Weiterbildung

EDUCATION:

2007 - 2008

Institution: Hochschule Niederrhein

Abschluss: Dipl. Wirtsch.-Ing. (FH) 

2004 ? 2007

Institution: Fontys Hogeschool Venlo NL

Abschluss: Pre Degree 

2003 - 2004

Institution: Berufskolleg Kleve

Abschluss: Professional High School 

2000 - 2003

Institution: Convent Spedition GmbH & IHK

Abschluss: Truck Manager

CERTIFICATES & COURSES:

  • Query SQL Server 2012
  • Getting and Cleaning Data
  • Hadoop Certified Developer
  • R Programming
  • Scalable Machine Learning
  • Exploratory Data Analysis
  • Introduction to Big Data with
  • Apache Spark
  • SAP Business Warehouse powered by SAP
  • HANA
  • Process-Mining in Action
  • Quering with Transact-SQL
  • Computing for Data Analysis
  • Linux LPIC 101
  • Regression Models
  • Data Analysis
  • Developing Data Products
  • Practical Machine Learning
  • The Data Scientists Products

Kompetenzen

Kompetenzen

Top-Skills

Data Engineering SSIS Microsoft-SQL-Server Apache Hop Python Matillion Kafka Pyspark Databricks Redshift SSAS SSIS Pentaho Beautifulsoup API FastAPI Microsoft Azure Big Data Postgres

Produkte / Standards / Erfahrungen / Methoden

PROFILE:
ETL, Data-Mart Design, Vizualising and Big Data. Using Microsoft, Pentaho as well as SAP Tools. On Premise as well as Azure

LAST EMPL

06/2018 ? today:

Client: Innogy Consulting GmbH, Düsseldorf

Role: Senior Specialist Digital & Data

04/2015 ? 05/2018

Client: Rheindata GmbH, Köln

Role: Data Engineer

07/2011 ? 03/2015:

Client: Van Eupen Logistik GmbH, Essen

Role: IT-Prozessmanager

Tasks:

  • Development of a KPI-system based on Norm VDI4490
  • Conceptioning and development of DataMarts and ETL-Jobs (PDI) for DW
  • Developement of a monitoring system based on SQL2008 and DB2 for several
    departments
  • Programming dynamical performance-dashboards in realtime with Pentaho
    tools
  • Creating a recommendation system and order forecasting as webapplication
    with R and Shiny
  • Implementation of a EDI warningsystem incl. report bursting
  • Dataanalysis for processdefinition within new customer business as well as
    identification of processdrivers

03/2010 ? 06/2011

Client: Van Eupen Logistik GmbH, Essen

Role: Junior IT-Processmanager

Tasks:

  • Logistical process definition in contract logistics (fullfillment)
  • IT requirements engineering (Microsoft Dynamics NAV)
  • Accompanying new clients from first contact over process requirements,
    interface definition, programming overview, tests, implementation and training
  • Processanalysis and evaluation within controlling

09/2009 ? 02/2010

Client: Research institute GEMIT, Mönchengladbach

Role: scientific assistant

Tasks:

  • Taking care of logistical research projects
  • Acquisition of public and private subventioned research budgets with logistic
    / process relation (for NRW as well as Euregio)
  • Creating organizational manual for an international RFID project

Vertrauen Sie auf GULP

Im Bereich Freelancing
Im Bereich Arbeitnehmerüberlassung / Personalvermittlung

Fragen?

Rufen Sie uns an +49 89 500316-300 oder schreiben Sie uns:

Das GULP Freelancer-Portal

Direktester geht's nicht! Ganz einfach Freelancer finden und direkt Kontakt aufnehmen.