Data analytics/Data integration. Jahrelange Erfahrung als Manager Analytics bei der TAS von EY und als Simulationsentwickler bei Fraunhofer
Aktualisiert am 18.02.2025
Profil
Freiberufler / Selbstständiger
Remote-Arbeit
Verfügbar ab: 28.03.2025
Verfügbar zu: 100%
davon vor Ort: 100%
Simulationsmodell
Big Data Analytics
ETL
Projektmanagement
VBA
Python
Java
C++
SQL
Alteryx
Excel macro-programming
German
Muttersprache
English
Verhandlungssicher
French
Fortgeschritten
Portuguese
Grundkenntnisse

Einsatzorte

Einsatzorte

Deutschland, Schweiz, Österreich
möglich

Projekte

Projekte

7 Monate
2022-07 - 2023-01

Process automation

VBA Developer
VBA Developer
  • Collaboration with stakeholders to identify problems and quick wins in the current processes
  • Development of several VBA-macro-based Excel-tools for automated updating of sanctions lists
  • Development of VBA-macro-based Excel-tool for information exchange and updates on critical alerts
  • Documentation of code, creation of manuals and training of staff in the VBA basics and structure of the tools and code
International German bank, sanctions&embargoes team
4 Monate
2020-09 - 2020-12

HR forecast model

Data analyst
Data analyst
  • Building a machine learning model with Python, trained on HR data on employee basis, to predict employee turnover depending on HR policy scenarios (salary structure, holidays ?)
Client in the health sector (hospitals and care homes)
5 Monate
2019-09 - 2020-01

Planning tool

Manager
Manager
  • Client needed a tool to manage contractual data for his series and films and feed a financial forecast model
  • Advising the client on the most appropriate solution together with financial modelling colleagues
  • Supervising a senior consultant
  • Development of an Excel input mask to create new and change existing contractual data storing it in and loading it from an SQL Server database via VBA macros connecting via OLEDB and an Excel forecast model, calculating on basis of that data, connected via OLEDB as well
Company in the entertainment sector, mid-market
7 Monate
2019-07 - 2020-01

Carve-out analytics

Data team manager
Data team manager
  • Project planning and milestone definition in coordination with client and other work streams
  • Coordination of data extraction from client?s ERP system with client
  • Oversight and training of combined data integration and financial modelling team
  • Consolidating financial data with finance team
  • Delivery of an integrated data cube, using Alteryx workflows and python scripts to cleanse and combine financial data from the clients ERP systems and management reports to show financials of different carve-out perimeters in an Excel workbook loading data via power pivot and feeding a financial forecast model
  • Creation of a PowerBI dashboard
Leading company in the security technology sector
9 Monate
2018-08 - 2019-04

Carve-out analytics

Data team manager
Data team manager
  • Project planning and milestone definition in coordination with client and other work streams
  • Oversight and training of the data integration team
  • Delivery of an integrated data cube, using Alteryx workflows and python scripts to cleanse and combine financial data from the clients ERP systems to show financials of different carve-out perimeters in an Excel workbook loading data via power pivot
  • Creation of a PowerBI dashboard 
Leading company in the retail sector
4 Monate
2018-06 - 2018-09

Planning tool

Senior Consultant
Senior Consultant
  • Client needed a new approach to plan utilisation of his equipment on different construction sites
  • Advising the client on the most appropriate solution
  • Development of a planning tool with Excel interface and VBA macros to write data into and retrieve data from an underlying Access database via OLEDB connections
Company in the construction sector, mid-market
5 Monate
2018-05 - 2018-09

Strategic Workforce Forecast Model

Data analyst/Model developer
Data analyst/Model developer
  • Analysis of turnover rates, promotion rates and transfer rates of all service and subservice lines in python based on HR data of five recent years
  • Building a forecast model in Excel with HR planning scenarios and calculations performed in VBA
EY HR (internal project)
6 Monate
2018-01 - 2018-06

restructuring

Senior Consultant
Senior Consultant
  • Client was reorganising the structure of his main divisions
  • To analyse the financials of the new divisions, the same methodology as in carve-out projects was applied
  • In collaboration with other workstreams, an Alteryx workflow was developed to cleanse and combine the data of a complex landscape of ERP systems to get the theoretical financial data of the new divisions
restructuring
4 Monate
2018-02 - 2018-05

employee?s travel patterns

Data analyst
Data analyst
  • Building a python data model based on data from the travel department, performing a k-means/k-modes-clustering to identify patterns of irregularities
EY Advisory (internal project)
10 Monate
2017-06 - 2018-03

Carve-out analytics

Senior Consultant
Senior Consultant
  • Client was to take over a competitor and for regulatory reasons had to carve out part of his business, with the perimeter of the carve-out demanded by the authorities still unclear at project start
  • In collaboration with other workstreams, an Alteryx workflow was developed to cleanse and combine the data of a complex landscape of ERP systems (that had historically grown within the organisation) to get the theoretical financial data of all possible perimeters and further analysis, like price-volume analysis was performed in an Excel model
  • Current-trading update in the final stages of the project
Leading global pharmaceutical and biotechnology company
2 Monate
2018-01 - 2018-02

analysis of register data

Data analyst
Data analyst
  • Building an access database with transaction data from cash register and performing exploratory analysis with Spotfire (visualisation software)
  • Creation of a dashboard with Spotfire
Client in the gastronomy sector (restaurant chain)
6 Monate
2017-01 - 2017-06

Route profitability tool

Senior Consultant
Senior Consultant
  • Development of a database to combine operational (down to single aircrafts) and financial data of a low cost carrier belonging to our client to break down profitability to single routes 
International airline
4 Monate
2016-09 - 2016-12

employee migration

Data analyst
Data analyst
  • client wanted an analysis about migration of his employees during the 2015 refugee crisis
  • Development of a data model with Python based on HR data for the year 2015 to show employee movement between different locations
BAMF (Federal Agency for Migration and Refugees)

Aus- und Weiterbildung

Aus- und Weiterbildung

2 Jahre 1 Monat
2014-09 - 2016-09

Cultural Sciences with a focus on philosophy, literature and history

Fernuniversität Hagen
Fernuniversität Hagen
1 Jahr 6 Monate
2011-04 - 2012-09

Business and economics

Johannes Gutenberg University of Mainz, Faculty of Economics, Mainz, Germany
Johannes Gutenberg University of Mainz, Faculty of Economics, Mainz, Germany
7 Jahre 6 Monate
2003-04 - 2010-09

Masters Degree in Physics (Dipl. Phys.)

Johannes Gutenberg University of Mainz, Institute for Physics, Staudinger Weg 9, 55116 Mainz, Germany
Johannes Gutenberg University of Mainz, Institute for Physics, Staudinger Weg 9, 55116 Mainz, Germany
  • Wide range of experimental physics and theoretical physics, advanced mathematics, chemistry, nuclear chemistry, particle physics, stochastic processes, statistical mechanics and Monte Carlo Simulations

Kompetenzen

Kompetenzen

Top-Skills

Simulationsmodell Big Data Analytics ETL Projektmanagement VBA Python Java C++ SQL Alteryx Excel macro-programming

Produkte / Standards / Erfahrungen / Methoden

Work experience:
2022-01 - heute
Rolle: Freelance analytics consultant


Aufgaben:

  • Analytics and automation projects


2020-03 ? 2021-03
Rolle: Manager Analytics

Kunde: Accuracy Deutschland GmbH, Munich


Aufgaben:

  • Proof of concept and go-to-market of advanced analytics projects for the German market


2018-10 ? 2020-02
Rolle: Manager, Transaction Advisory Service, Member of the TAS young leadership board

Kunde: Ernst & Young WP GmbH, Munich


Aufgaben:

  • Business Modelling
  • Advanced Data Analytics
  • Data Integration and Data Visualisation
  • Economic Advisory
  • Automation


2016-06 ? 2018-09
Rolle: Senior Consultant, Transaction Advisory Service
Kunde: Ernst & Young WP GmbH, Munich


Aufgaben:

  • Business Modelling
  • Advanced Data Analytics
  • Data Integration and Data Visualisation
  • Economic Advisory


2011-09 ? 2016-04
Rolle: Junior Researcher and PhD Student (TU Berlin, from February 2013 onwards), Business Area Transportation Systems
Kunde: Fraunhofer-ISI Institute for Systems and Innovation Research, Competence Centre Sustainability and Infrastructure, Karlsruhe, Germany

Aufgaben:

  • Policy analysis in transport, energy, climate and technology field;
  • System Dynamics modeling, ASTRA-D model (passenger and freight modules)
  • Agent Based modeling
  • Transition modeling


2007-04 - 2010-12
Rolle: Student Employee
Kunde: Johannes Gutenberg University of Mainz, Institute for Physics, Staudinger Weg 9, 55116 Mainz, Germany


Aufgaben:

  • Supervisor of student experiments
  • Supervisor of exercise groups
  • Researcher in computational physics


2002-04 ? 2003-03

Rolle: Military Service, Signal Corps, Staff Soldier Heeresführungskommando (Army Forces Command)


Technical skills and competences:

C++, Java, Python, Alteryx, VBA, SQL, PowerBI, MS Excel, MS Access, Gnuplot, LaTex, Repast Simphony, Simulation modelling (Agent Based, System Dynamics), Data Bases, Data Analysis, Data Integration, Regression Modelling, Spotfire, Vensim


Organisational skills and competences:

Leader of project teams developing carve-out data models in the context of big corporate carve-outs in DAX (German stock exchange) listed companies as well as middle market companies, EY internal trainer for Alteryx, VBA and Spotfire (data visualisation), member of the EY TAS young leadership board

Einsatzorte

Einsatzorte

Deutschland, Schweiz, Österreich
möglich

Projekte

Projekte

7 Monate
2022-07 - 2023-01

Process automation

VBA Developer
VBA Developer
  • Collaboration with stakeholders to identify problems and quick wins in the current processes
  • Development of several VBA-macro-based Excel-tools for automated updating of sanctions lists
  • Development of VBA-macro-based Excel-tool for information exchange and updates on critical alerts
  • Documentation of code, creation of manuals and training of staff in the VBA basics and structure of the tools and code
International German bank, sanctions&embargoes team
4 Monate
2020-09 - 2020-12

HR forecast model

Data analyst
Data analyst
  • Building a machine learning model with Python, trained on HR data on employee basis, to predict employee turnover depending on HR policy scenarios (salary structure, holidays ?)
Client in the health sector (hospitals and care homes)
5 Monate
2019-09 - 2020-01

Planning tool

Manager
Manager
  • Client needed a tool to manage contractual data for his series and films and feed a financial forecast model
  • Advising the client on the most appropriate solution together with financial modelling colleagues
  • Supervising a senior consultant
  • Development of an Excel input mask to create new and change existing contractual data storing it in and loading it from an SQL Server database via VBA macros connecting via OLEDB and an Excel forecast model, calculating on basis of that data, connected via OLEDB as well
Company in the entertainment sector, mid-market
7 Monate
2019-07 - 2020-01

Carve-out analytics

Data team manager
Data team manager
  • Project planning and milestone definition in coordination with client and other work streams
  • Coordination of data extraction from client?s ERP system with client
  • Oversight and training of combined data integration and financial modelling team
  • Consolidating financial data with finance team
  • Delivery of an integrated data cube, using Alteryx workflows and python scripts to cleanse and combine financial data from the clients ERP systems and management reports to show financials of different carve-out perimeters in an Excel workbook loading data via power pivot and feeding a financial forecast model
  • Creation of a PowerBI dashboard
Leading company in the security technology sector
9 Monate
2018-08 - 2019-04

Carve-out analytics

Data team manager
Data team manager
  • Project planning and milestone definition in coordination with client and other work streams
  • Oversight and training of the data integration team
  • Delivery of an integrated data cube, using Alteryx workflows and python scripts to cleanse and combine financial data from the clients ERP systems to show financials of different carve-out perimeters in an Excel workbook loading data via power pivot
  • Creation of a PowerBI dashboard 
Leading company in the retail sector
4 Monate
2018-06 - 2018-09

Planning tool

Senior Consultant
Senior Consultant
  • Client needed a new approach to plan utilisation of his equipment on different construction sites
  • Advising the client on the most appropriate solution
  • Development of a planning tool with Excel interface and VBA macros to write data into and retrieve data from an underlying Access database via OLEDB connections
Company in the construction sector, mid-market
5 Monate
2018-05 - 2018-09

Strategic Workforce Forecast Model

Data analyst/Model developer
Data analyst/Model developer
  • Analysis of turnover rates, promotion rates and transfer rates of all service and subservice lines in python based on HR data of five recent years
  • Building a forecast model in Excel with HR planning scenarios and calculations performed in VBA
EY HR (internal project)
6 Monate
2018-01 - 2018-06

restructuring

Senior Consultant
Senior Consultant
  • Client was reorganising the structure of his main divisions
  • To analyse the financials of the new divisions, the same methodology as in carve-out projects was applied
  • In collaboration with other workstreams, an Alteryx workflow was developed to cleanse and combine the data of a complex landscape of ERP systems to get the theoretical financial data of the new divisions
restructuring
4 Monate
2018-02 - 2018-05

employee?s travel patterns

Data analyst
Data analyst
  • Building a python data model based on data from the travel department, performing a k-means/k-modes-clustering to identify patterns of irregularities
EY Advisory (internal project)
10 Monate
2017-06 - 2018-03

Carve-out analytics

Senior Consultant
Senior Consultant
  • Client was to take over a competitor and for regulatory reasons had to carve out part of his business, with the perimeter of the carve-out demanded by the authorities still unclear at project start
  • In collaboration with other workstreams, an Alteryx workflow was developed to cleanse and combine the data of a complex landscape of ERP systems (that had historically grown within the organisation) to get the theoretical financial data of all possible perimeters and further analysis, like price-volume analysis was performed in an Excel model
  • Current-trading update in the final stages of the project
Leading global pharmaceutical and biotechnology company
2 Monate
2018-01 - 2018-02

analysis of register data

Data analyst
Data analyst
  • Building an access database with transaction data from cash register and performing exploratory analysis with Spotfire (visualisation software)
  • Creation of a dashboard with Spotfire
Client in the gastronomy sector (restaurant chain)
6 Monate
2017-01 - 2017-06

Route profitability tool

Senior Consultant
Senior Consultant
  • Development of a database to combine operational (down to single aircrafts) and financial data of a low cost carrier belonging to our client to break down profitability to single routes 
International airline
4 Monate
2016-09 - 2016-12

employee migration

Data analyst
Data analyst
  • client wanted an analysis about migration of his employees during the 2015 refugee crisis
  • Development of a data model with Python based on HR data for the year 2015 to show employee movement between different locations
BAMF (Federal Agency for Migration and Refugees)

Aus- und Weiterbildung

Aus- und Weiterbildung

2 Jahre 1 Monat
2014-09 - 2016-09

Cultural Sciences with a focus on philosophy, literature and history

Fernuniversität Hagen
Fernuniversität Hagen
1 Jahr 6 Monate
2011-04 - 2012-09

Business and economics

Johannes Gutenberg University of Mainz, Faculty of Economics, Mainz, Germany
Johannes Gutenberg University of Mainz, Faculty of Economics, Mainz, Germany
7 Jahre 6 Monate
2003-04 - 2010-09

Masters Degree in Physics (Dipl. Phys.)

Johannes Gutenberg University of Mainz, Institute for Physics, Staudinger Weg 9, 55116 Mainz, Germany
Johannes Gutenberg University of Mainz, Institute for Physics, Staudinger Weg 9, 55116 Mainz, Germany
  • Wide range of experimental physics and theoretical physics, advanced mathematics, chemistry, nuclear chemistry, particle physics, stochastic processes, statistical mechanics and Monte Carlo Simulations

Kompetenzen

Kompetenzen

Top-Skills

Simulationsmodell Big Data Analytics ETL Projektmanagement VBA Python Java C++ SQL Alteryx Excel macro-programming

Produkte / Standards / Erfahrungen / Methoden

Work experience:
2022-01 - heute
Rolle: Freelance analytics consultant


Aufgaben:

  • Analytics and automation projects


2020-03 ? 2021-03
Rolle: Manager Analytics

Kunde: Accuracy Deutschland GmbH, Munich


Aufgaben:

  • Proof of concept and go-to-market of advanced analytics projects for the German market


2018-10 ? 2020-02
Rolle: Manager, Transaction Advisory Service, Member of the TAS young leadership board

Kunde: Ernst & Young WP GmbH, Munich


Aufgaben:

  • Business Modelling
  • Advanced Data Analytics
  • Data Integration and Data Visualisation
  • Economic Advisory
  • Automation


2016-06 ? 2018-09
Rolle: Senior Consultant, Transaction Advisory Service
Kunde: Ernst & Young WP GmbH, Munich


Aufgaben:

  • Business Modelling
  • Advanced Data Analytics
  • Data Integration and Data Visualisation
  • Economic Advisory


2011-09 ? 2016-04
Rolle: Junior Researcher and PhD Student (TU Berlin, from February 2013 onwards), Business Area Transportation Systems
Kunde: Fraunhofer-ISI Institute for Systems and Innovation Research, Competence Centre Sustainability and Infrastructure, Karlsruhe, Germany

Aufgaben:

  • Policy analysis in transport, energy, climate and technology field;
  • System Dynamics modeling, ASTRA-D model (passenger and freight modules)
  • Agent Based modeling
  • Transition modeling


2007-04 - 2010-12
Rolle: Student Employee
Kunde: Johannes Gutenberg University of Mainz, Institute for Physics, Staudinger Weg 9, 55116 Mainz, Germany


Aufgaben:

  • Supervisor of student experiments
  • Supervisor of exercise groups
  • Researcher in computational physics


2002-04 ? 2003-03

Rolle: Military Service, Signal Corps, Staff Soldier Heeresführungskommando (Army Forces Command)


Technical skills and competences:

C++, Java, Python, Alteryx, VBA, SQL, PowerBI, MS Excel, MS Access, Gnuplot, LaTex, Repast Simphony, Simulation modelling (Agent Based, System Dynamics), Data Bases, Data Analysis, Data Integration, Regression Modelling, Spotfire, Vensim


Organisational skills and competences:

Leader of project teams developing carve-out data models in the context of big corporate carve-outs in DAX (German stock exchange) listed companies as well as middle market companies, EY internal trainer for Alteryx, VBA and Spotfire (data visualisation), member of the EY TAS young leadership board

Vertrauen Sie auf Randstad

Im Bereich Freelancing
Im Bereich Arbeitnehmerüberlassung / Personalvermittlung

Fragen?

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

Das Freelancer-Portal

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