Data Science, Data Analytics, Controlling, Finance, Statistics
Aktualisiert am 03.04.2024
Profil
Freiberufler / Selbstständiger
Remote-Arbeit
Verfügbar ab: 03.04.2024
Verfügbar zu: 100%
davon vor Ort: 100%
Data Scientist
Finanzcontrolling
Statistik
Big Data Analytics
IT-Controlling
Python
R
SAP
Cognos
Informix
SQL
MS SQL Server
Teradata
Oracle
MicroStrategy
German
Muttersprache
English
fluent
French
Grundkenntnisse

Einsatzorte

Einsatzorte

Cologne (+50km) Düsseldorf (+50km) Bonn (+50km)
Deutschland
möglich

Projekte

Projekte

3 years 5 months
2016-12 - 2020-04

Product Management

Business / Data Analyst
Business / Data Analyst
  • Calculation and data analysis based on a data lake on the platform Oracle
  • Data mining and reporting for all departments in particular management, product management, marketing and
  • Creating reports for regulatory requirements at home and abroad (e.g.: BaFin)
  • Product and price calculations
  • Statistical evaluations and forecasts in a strategic project
  • Creation of Sales and Cost Reports & Simulations
  • Python, SQL and VBA programming
Payments International GmbH, permanent, Cologne / Financial services
7 months
2016-03 - 2016-09

Risk-Management

Interim Data Analyst
Interim Data Analyst
  • Responsibility for collections and factoring in the
  • risk management area
  • Management of the external financial and collection service providers for collection and factoring as well as the external dunning process
  • Collaboration in the preparation of monthly financial statements
  • Planning and calculation of the allowance for doubtful accounts and adjustment of the value adjustments
  • Identification and clarification of collection discrepancies between financial service providers, Douglas and collection service providers
  • Further development of the reporting system
  • Construction of an inkasso database as an interface between financial service providers and inkasso service providers
  • Statistical Modelling and forecasts
Parfümerie Douglas GmbH, Cologne / online trading
3 years 8 months
2012-07 - 2016-02

Marketing of film-products

  • Marketing of film-products via Internet (websites, IMD, Itunes, Netflix und Lovefilm)
  • Creation of business, sales, marketing and financial plans in the context of financing film projects
  • Creating and marketing campaigns for financing feature film projects via crowdfunding and investment platforms (lndiegogo, Startnext, Kickstarter and lnnovestment)
self-employed, Cologne / Media
3 years 10 months
2008-09 - 2012-06

Create and analyze contribution margin analyses

Senior Controller
Senior Controller
  • Create and analyze contribution margin analyses for major suppliers
  • Preparation of monthly and quarterly reports to senior management
  • Calculation of detailed profitability and variance analyses
  • Development of information systems for supplier analysis
  • Support of the strategic project for the optimization of supplier relationships
  • Research of corporate structures and financial data of suppliers with business information services (such as: Bureau van Dijk)
  • Creation of supplier benchmarks and portfolio analyses
  • Creation of technical and functional requirements (TRS, BRS: Technical Requirements Satements based on the specifications of the specialist department).
  • Coordination and communication of TRS /BRS documents with lT (Business Intelligence) and specialist department
  • Guidance of programmers in the implementation of technical requirements
  • Guidance of programmers in the implementation of technical requirements
  • Organization, execution and participation in the User Acceptance Tests
  • Education and training of the end users
  • Training in AML techniques (26-28 June 2011) TMA Akadem?e
Metro Group AG, Düsseldorf / wholesale trade
6 months
2008-03 - 2008-08

Preparation of the monthly sales and earnings report

Department Manager Sales-Controlling
Department Manager Sales-Controlling
  • Preparation of the monthly sales and earnings report for the management and the supervisory board
  • Cost and profitability calculations
  • Preparation of simulation calculations for strategic scenarios with effects on the short-term income statement
  • Budget preparation and forecast calculations
  • Analysis of quantity and price deviations and preparation of target/actual comparisons
  • Control of the investment calculations
Metro Cash & Carry Deutschland GmbH, Düsseldorf / wholesale trade
3 years 5 months
2004-10 - 2008-02

Development of a financial system

Controller; Project Manager MIS
Controller; Project Manager MIS
  • Development of a financial system for worldwide use
  • Preparation of cost reports of transfer costs for internal customers worldwide
  • Analysis of costs on a European and global level
  • Advising internal customers from countries and world regions on cost issues
  • Coordination of the deployment of external and internal programmers in Malaysia and Germany
  • Project Management:
    • Setting milestones
    • Control of the achievement of sub-goals in terms of time, budget, and content
    • Budget planning and control, forecasts
    • Hiring and coordination of programmers
  • Creation of technical and business requirements (TRS, BRS: technical specifications based on the requirements specifications of the business department)
  • Coordination and communication of the TRS /BRS documents with the lT (business intelligence) and specialist departments
  • Definition, structure and creation of datamarts
  • Simulation of applications in MS SQL Server, Oracle and MS Access
  • Setup and definition of a reporting system
  • Definition of interfaces
  • Definition of the relevant hardware
  • Guidance of the programmers in the implementation of the technical requirements defined in the BRS /TRS
  • Organization, implementation and participation in user acceptance tests
  • Training of end users (country and regional controllers)
DHL Global Management GmbH, Bonn / Logistics
8 months
2003-12 - 2004-07

Preparation of cost reports

Cost Analyst
Cost Analyst
  • Preparation of cost reports for logistics costs of Ford of Europe
  • Analysis and distribution of logistics costs to cost centers and cost types of the individual European plants
  • Consolidation of logistics costs on a European level
Exel GmbH, Cologne / Logistics
1 year 5 months
2002-07 - 2003-11

Establishment of a management information and control system

Business Analyst
Business Analyst
  • Establishment of a management information and control system for recording global inventories and cash flows
  • Automation of annual planning and strategic planning
  • Consolidation of globally generated cash flows at procurement level
Japan Tobacco International GmbH, Cologne / Consumer-Goods
1 year 1 month
2001-06 - 2002-06

Preparation of budget planning and target/actual comparisons

Budget Analyst
Budget Analyst
  • Preparation of budget planning and target/actual comparisons
  • Preparation of cost type, cost center and cost unit analyses
  • Improvement of business processes and procedures
  • Optimization of budget and actual cost reporting
  • Creation of a headcount database
Ford Werke AG, Cologne / Automotive
1 year 9 months
1999-09 - 2001-05

Preparation of the budget planning of the company

Assistent im Controlling
Assistent im Controlling
PDM GmbH & Co Kg / Plant Engineering

Aus- und Weiterbildung

Aus- und Weiterbildung

4 years
2020-07 - now

studies: MicroMaster in Statistics and Data Science

MITx via platform edx
MITx via platform edx

  • Online: Statistics and Data Science, MITx (in progress)
  • statistics, machine learning, stat. Analysis, probability

1 year 9 months
1993-04 - 1994-12

Bachelor of Business Administration

GSBA, Zürich
GSBA, Zürich
Focus on company leadership and marketing

Kompetenzen

Kompetenzen

Top-Skills

Data Scientist Finanzcontrolling Statistik Big Data Analytics IT-Controlling Python R SAP Cognos Informix SQL MS SQL Server Teradata Oracle MicroStrategy

Produkte / Standards / Erfahrungen / Methoden

Skills and Experiences

  • Statistical Modelling
  • Data-Analysis / Data-Mining
  • Development of Financial Systems and Databases (BI)
  • Reporting
  • Process-Analysis
  • Machine Learning
  • Statistics
  • Project-Management
  • Profitability-Analysis
  • Gross Profit Analysis and Calculation
  • Financial-, Purchasing-, Sales-Controlling
  • Budgeting
  • Cost-Accounting, Calculation, Pricing
  • Forecasting
  • Scenario-, Sensitivity-Analysis
  • Company Evaluation (DCF-Method)
  • Anti Money Laundering / AML 


IT-Skills

  • MS Excel, -Word
  • VBA Programming
  • SQL Programming
  • R Programming
  • Python Programming
  • Databases: MS SQL Server, MS Access, Oracle, lnformix, Teradata
  • Reporting-Systems: Microstrategy, Cognos (IBM)
  • SAP CO/Fl/BW/Bl/CREST
  • MS Visio
  • MS Powerpoint
  • MS Project
  • Confluence, Jira, Gliffy (Atlassian)


Experiences

2016 - 2020

Role: Business / Data Analyst

Customer: Product-Management


2016 - 2016

Role: Interim-Controller, Data-Analyst

Customer: Controlling & Risk-Management


2009 - 2012

Role: Senior Controller, Department Manager

Customer: Sales-Controlling & Purchasing


2004 - 2008

Role: Controller, Corporate Finance


2004 - 2004

Role: Cost-Analyst, Cost control


2002 - 2004

Role: Business-Analyst, Purchasing


2001 - 2002

Role: Budget-Analyst, Research & Development


1997 - 1999

Role: Business-Analyst

Einsatzorte

Einsatzorte

Cologne (+50km) Düsseldorf (+50km) Bonn (+50km)
Deutschland
möglich

Projekte

Projekte

3 years 5 months
2016-12 - 2020-04

Product Management

Business / Data Analyst
Business / Data Analyst
  • Calculation and data analysis based on a data lake on the platform Oracle
  • Data mining and reporting for all departments in particular management, product management, marketing and
  • Creating reports for regulatory requirements at home and abroad (e.g.: BaFin)
  • Product and price calculations
  • Statistical evaluations and forecasts in a strategic project
  • Creation of Sales and Cost Reports & Simulations
  • Python, SQL and VBA programming
Payments International GmbH, permanent, Cologne / Financial services
7 months
2016-03 - 2016-09

Risk-Management

Interim Data Analyst
Interim Data Analyst
  • Responsibility for collections and factoring in the
  • risk management area
  • Management of the external financial and collection service providers for collection and factoring as well as the external dunning process
  • Collaboration in the preparation of monthly financial statements
  • Planning and calculation of the allowance for doubtful accounts and adjustment of the value adjustments
  • Identification and clarification of collection discrepancies between financial service providers, Douglas and collection service providers
  • Further development of the reporting system
  • Construction of an inkasso database as an interface between financial service providers and inkasso service providers
  • Statistical Modelling and forecasts
Parfümerie Douglas GmbH, Cologne / online trading
3 years 8 months
2012-07 - 2016-02

Marketing of film-products

  • Marketing of film-products via Internet (websites, IMD, Itunes, Netflix und Lovefilm)
  • Creation of business, sales, marketing and financial plans in the context of financing film projects
  • Creating and marketing campaigns for financing feature film projects via crowdfunding and investment platforms (lndiegogo, Startnext, Kickstarter and lnnovestment)
self-employed, Cologne / Media
3 years 10 months
2008-09 - 2012-06

Create and analyze contribution margin analyses

Senior Controller
Senior Controller
  • Create and analyze contribution margin analyses for major suppliers
  • Preparation of monthly and quarterly reports to senior management
  • Calculation of detailed profitability and variance analyses
  • Development of information systems for supplier analysis
  • Support of the strategic project for the optimization of supplier relationships
  • Research of corporate structures and financial data of suppliers with business information services (such as: Bureau van Dijk)
  • Creation of supplier benchmarks and portfolio analyses
  • Creation of technical and functional requirements (TRS, BRS: Technical Requirements Satements based on the specifications of the specialist department).
  • Coordination and communication of TRS /BRS documents with lT (Business Intelligence) and specialist department
  • Guidance of programmers in the implementation of technical requirements
  • Guidance of programmers in the implementation of technical requirements
  • Organization, execution and participation in the User Acceptance Tests
  • Education and training of the end users
  • Training in AML techniques (26-28 June 2011) TMA Akadem?e
Metro Group AG, Düsseldorf / wholesale trade
6 months
2008-03 - 2008-08

Preparation of the monthly sales and earnings report

Department Manager Sales-Controlling
Department Manager Sales-Controlling
  • Preparation of the monthly sales and earnings report for the management and the supervisory board
  • Cost and profitability calculations
  • Preparation of simulation calculations for strategic scenarios with effects on the short-term income statement
  • Budget preparation and forecast calculations
  • Analysis of quantity and price deviations and preparation of target/actual comparisons
  • Control of the investment calculations
Metro Cash & Carry Deutschland GmbH, Düsseldorf / wholesale trade
3 years 5 months
2004-10 - 2008-02

Development of a financial system

Controller; Project Manager MIS
Controller; Project Manager MIS
  • Development of a financial system for worldwide use
  • Preparation of cost reports of transfer costs for internal customers worldwide
  • Analysis of costs on a European and global level
  • Advising internal customers from countries and world regions on cost issues
  • Coordination of the deployment of external and internal programmers in Malaysia and Germany
  • Project Management:
    • Setting milestones
    • Control of the achievement of sub-goals in terms of time, budget, and content
    • Budget planning and control, forecasts
    • Hiring and coordination of programmers
  • Creation of technical and business requirements (TRS, BRS: technical specifications based on the requirements specifications of the business department)
  • Coordination and communication of the TRS /BRS documents with the lT (business intelligence) and specialist departments
  • Definition, structure and creation of datamarts
  • Simulation of applications in MS SQL Server, Oracle and MS Access
  • Setup and definition of a reporting system
  • Definition of interfaces
  • Definition of the relevant hardware
  • Guidance of the programmers in the implementation of the technical requirements defined in the BRS /TRS
  • Organization, implementation and participation in user acceptance tests
  • Training of end users (country and regional controllers)
DHL Global Management GmbH, Bonn / Logistics
8 months
2003-12 - 2004-07

Preparation of cost reports

Cost Analyst
Cost Analyst
  • Preparation of cost reports for logistics costs of Ford of Europe
  • Analysis and distribution of logistics costs to cost centers and cost types of the individual European plants
  • Consolidation of logistics costs on a European level
Exel GmbH, Cologne / Logistics
1 year 5 months
2002-07 - 2003-11

Establishment of a management information and control system

Business Analyst
Business Analyst
  • Establishment of a management information and control system for recording global inventories and cash flows
  • Automation of annual planning and strategic planning
  • Consolidation of globally generated cash flows at procurement level
Japan Tobacco International GmbH, Cologne / Consumer-Goods
1 year 1 month
2001-06 - 2002-06

Preparation of budget planning and target/actual comparisons

Budget Analyst
Budget Analyst
  • Preparation of budget planning and target/actual comparisons
  • Preparation of cost type, cost center and cost unit analyses
  • Improvement of business processes and procedures
  • Optimization of budget and actual cost reporting
  • Creation of a headcount database
Ford Werke AG, Cologne / Automotive
1 year 9 months
1999-09 - 2001-05

Preparation of the budget planning of the company

Assistent im Controlling
Assistent im Controlling
PDM GmbH & Co Kg / Plant Engineering

Aus- und Weiterbildung

Aus- und Weiterbildung

4 years
2020-07 - now

studies: MicroMaster in Statistics and Data Science

MITx via platform edx
MITx via platform edx

  • Online: Statistics and Data Science, MITx (in progress)
  • statistics, machine learning, stat. Analysis, probability

1 year 9 months
1993-04 - 1994-12

Bachelor of Business Administration

GSBA, Zürich
GSBA, Zürich
Focus on company leadership and marketing

Kompetenzen

Kompetenzen

Top-Skills

Data Scientist Finanzcontrolling Statistik Big Data Analytics IT-Controlling Python R SAP Cognos Informix SQL MS SQL Server Teradata Oracle MicroStrategy

Produkte / Standards / Erfahrungen / Methoden

Skills and Experiences

  • Statistical Modelling
  • Data-Analysis / Data-Mining
  • Development of Financial Systems and Databases (BI)
  • Reporting
  • Process-Analysis
  • Machine Learning
  • Statistics
  • Project-Management
  • Profitability-Analysis
  • Gross Profit Analysis and Calculation
  • Financial-, Purchasing-, Sales-Controlling
  • Budgeting
  • Cost-Accounting, Calculation, Pricing
  • Forecasting
  • Scenario-, Sensitivity-Analysis
  • Company Evaluation (DCF-Method)
  • Anti Money Laundering / AML 


IT-Skills

  • MS Excel, -Word
  • VBA Programming
  • SQL Programming
  • R Programming
  • Python Programming
  • Databases: MS SQL Server, MS Access, Oracle, lnformix, Teradata
  • Reporting-Systems: Microstrategy, Cognos (IBM)
  • SAP CO/Fl/BW/Bl/CREST
  • MS Visio
  • MS Powerpoint
  • MS Project
  • Confluence, Jira, Gliffy (Atlassian)


Experiences

2016 - 2020

Role: Business / Data Analyst

Customer: Product-Management


2016 - 2016

Role: Interim-Controller, Data-Analyst

Customer: Controlling & Risk-Management


2009 - 2012

Role: Senior Controller, Department Manager

Customer: Sales-Controlling & Purchasing


2004 - 2008

Role: Controller, Corporate Finance


2004 - 2004

Role: Cost-Analyst, Cost control


2002 - 2004

Role: Business-Analyst, Purchasing


2001 - 2002

Role: Budget-Analyst, Research & Development


1997 - 1999

Role: Business-Analyst

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.