Business Intelligence Consultant und Projektleiter
Aktualisiert am 25.03.2022
Profil
Freiberufler / Selbstständiger
Verfügbar ab: 01.01.2023
Verfügbar zu: 100%
davon vor Ort: 100%
English
excellent knowledge
German
mother tongue
Spanish
beginner

Einsatzorte

Einsatzorte

München (+100km) Berlin (+100km) Ravensburg (+100km) Malchin (+100km) Mindelheim (+100km)
Österreich, Schweiz
nicht möglich

Projekte

Projekte

9 Jahre 5 Monate
2014-10 - heute

Business Intelligence Consulting

BI Architect responsible, Release Manager
BI Architect responsible, Release Manager
  • BI-Projects with Consulting, Development and Technical Lead roles.
SQL Server 2014 SSIS SSAS SSRS XLCubed
Bayer
Australia/New Zealand & Brazil, China & Switzerland
8 Monate
2018-02 - 2018-09

Designed and developed a data integration platform

Consultant and Developer
Consultant and Developer

Designed and developed a data integration platform for the rollout of a new Dynamics CRM system. Migrated the existing Cognos/DB2 BI platform to the Microsoft BI-Stack.

SQL Server 2017 MDS SSIS Cozyroc PowerApps SSAS (tab. Model) Power BI
Data Integration CRM & BI Migration (Hagemeyer)
6 Monate
2017-04 - 2017-09

Designed the target data model

Consultant
Consultant

Designed the target data model for the BI part of the new Integrated Multi-Channel Marketing initiative for Bayer Pharma.
Consulted on KPI definitions and identified and documented gaps in definitions, processes and source systems.

Amazon Redshift
IMCM (Bayer AG)
3 Jahre
2014-10 - 2017-09

Setup of a new, cross-divisional

various on request
various on request

Setup of a new, cross-divisional CRM BI solution for strategic countries at Bayer based on Veeva (Salesforce) and sales data (SAP, IMS, Wholesaler).

SQL Server 2014 SSIS SSAS SSRS XLCubed Power BI Tableau
CORE.X BI (Bayer AG)
6 Monate
2014-04 - 2014-09

Backpacking

Backpacking through India, Nepal, Taiwan and Indonesia

Asia
6 Jahre 1 Monat
2008-03 - 2014-03

Local data consolidation layer Australia

Technical Lead
Technical Lead

Consolidated customer and contract data from different internal
and external source systems for a new Salesforce CRM system
with focus on data consolidation and cleansing.

SQL Server 2012 SSIS SSRS
Daimler
6 Jahre 1 Monat
2008-03 - 2014-03

After-Sales China

Project Manager
Project Manager

Set up a new BI solution to monitor, analyze and improve the performance of the whole Daimler after-sales process in China.

SQL Server 2012 SSIS Cognos 10.1
Daimler TSS
6 Jahre 1 Monat
2008-03 - 2014-03

Telematics BI China

Technical Lead
Technical Lead

Set up a new BI solution to monitor, analyze and improve the product.

SQL Server 2008 R2 SSIS SSAS SSRS
Daimler TSS
6 Jahre 1 Monat
2008-03 - 2014-03

Car2go BI

Technical Lead
Technical Lead

Set up a company-wide BI solution for financial - customer - and
quality analysis after the product launch of Daimler mobility services (car2go).

SQL Server 2008 R2 SSIS SSAS SSRS SharePoint insights
Daimler TSS
Ulm, Germany
6 Jahre 1 Monat
2008-03 - 2014-03

Daimler Trucks Product Testing

Consultant & Developer SQL Server 2005/2008 R2 SSIS SSRS ...
Consultant & Developer

Set up a new BI solution to monitor the testing process & quality
of new trucks and their components before product launch.

SQL Server 2005/2008 R2 SSIS SSRS SharePoint (incl. custom web part)
Daimler TSS
Ulm, Germany
6 Jahre 1 Monat
2008-03 - 2014-03

Expatriate in China

1 year on-site assignment in Beijing for project management and coordination in BI projects with a development team in Kuala Lumpur and part of the pioneer team for a new office setup in China.

Daimler TSS
Ulm, Germany
5 Monate
2007-10 - 2008-02

Business Intelligence diploma thesis

Designed and implemented a PowerPoint rendering extension for MS SQL Server Reporting Services (SSRS).

Daimler TSS
Ulm, Germany
7 Monate
2007-03 - 2007-09

Project Management internship

Implemented and customized a project management software (Planta Project) and set up a portal solution on SharePoint basis with integration of Planta Project reports.

Micronas GmbH
Munich, Germany
6 Monate
2005-04 - 2005-09

Management Information System internship

Designed, implemented and maintained interfaces and reports on OLAP technology to monitor the production process for Mercedes A – Class.

Daimler AG
Rastatt, Germany

Aus- und Weiterbildung

Aus- und Weiterbildung

4 Jahre 5 Monate
2003-10 - 2008-02

Diploma in Business Information Technology

German Diploma ?Wirtschaftsinformatik? with major eBusiness and Internet, University of Applied Science Weingarten, Germany
German Diploma ?Wirtschaftsinformatik? with major eBusiness and Internet
University of Applied Science Weingarten, Germany
  • Dipoma degree: 1,6 (approximate equivalent: A-)
  • Participated on an 6 month students exchange program at Shinawatra University in Bangkok, Thailand where I developed my personality and intercultural skills

Position

Position

Business Intelligence Consulting und Development

Kompetenzen

Kompetenzen

Schwerpunkte

Core Knowledge Areas:

  • Business requirements analysis and documentation
  • ETL, DWH Design and Implementation (Star-/Snow-Flake Schema, Data Vault, RDM)
  • OLAP Cube Design and Implementation
  • Data Visualization (Reporting, Scorecards, Dashboards)
  • Technical focus on MS BI Stack (SQL Server, SSIS, SSAS, SSRS, SharePoint BI), web services and collaboration systems

Produkte / Standards / Erfahrungen / Methoden

Cognos 10.1
SharePoint (incl. custom web part)
SharePoint insights
XLCubed

During 9 years? working as Developer, Consultant and Project Manager in different Business Intelligence projects all over the world I have experienced that the key success factor for delivering valuable and sustainable BI solutions is a strong understanding of the business and their processes along with a sound knowledge of BI concepts and methodologies. With my hands-on development skills and ability to inspire and communicate with a wide variety of people I can always take full responsibility for a successful delivery of BI solutions in the whole software development lifecycle. During long- and short-term on-site assignments in Australia, Brazil, China and Malaysia I have developed strong communication skills and proofed my flexibility to adapt quickly and efficiently to new working environments.

Skills and Strength Processes & Methodologies:

  • Business Requirements Analysis and Documentation
  • Project Management
  • ETL, DWH Design and Implementation (Star-/Snow-Flake Schema, Data Vault, RDM)
  • OLAP Cube Design and Implementation
  • Data Visualization (Reporting, Scorecards, Dashboards) Tools & Technologies
  • MS BI-Stack (SSIS, SSAS, SSRS), SharePoint Insights (Excel Services, PowerView, SSRS), MS Visual Studio, MS Team Foundation Server, Jira, MS Office, MS Visio, IIS, Navision, Datazen, Power BI, XLCubed, Tableau, PowerApps, CozyRoc, PowerDesigner, MDS

Betriebssysteme

Windows

Programmiersprachen

.Net
ASP.Net, VB.Net, C#
Basic
DAX
JavaScript
MDX
PHP
PHP
PL/SQL
T-SQL
VBA

Datenbanken

DB/400
MS Access
MS SQL Server
MySQL
ODBC
SQL Server
2005, 2008 R2, 2012, 2014, 2017
SSAS
SSIS
SSRS

Einsatzorte

Einsatzorte

München (+100km) Berlin (+100km) Ravensburg (+100km) Malchin (+100km) Mindelheim (+100km)
Österreich, Schweiz
nicht möglich

Projekte

Projekte

9 Jahre 5 Monate
2014-10 - heute

Business Intelligence Consulting

BI Architect responsible, Release Manager
BI Architect responsible, Release Manager
  • BI-Projects with Consulting, Development and Technical Lead roles.
SQL Server 2014 SSIS SSAS SSRS XLCubed
Bayer
Australia/New Zealand & Brazil, China & Switzerland
8 Monate
2018-02 - 2018-09

Designed and developed a data integration platform

Consultant and Developer
Consultant and Developer

Designed and developed a data integration platform for the rollout of a new Dynamics CRM system. Migrated the existing Cognos/DB2 BI platform to the Microsoft BI-Stack.

SQL Server 2017 MDS SSIS Cozyroc PowerApps SSAS (tab. Model) Power BI
Data Integration CRM & BI Migration (Hagemeyer)
6 Monate
2017-04 - 2017-09

Designed the target data model

Consultant
Consultant

Designed the target data model for the BI part of the new Integrated Multi-Channel Marketing initiative for Bayer Pharma.
Consulted on KPI definitions and identified and documented gaps in definitions, processes and source systems.

Amazon Redshift
IMCM (Bayer AG)
3 Jahre
2014-10 - 2017-09

Setup of a new, cross-divisional

various on request
various on request

Setup of a new, cross-divisional CRM BI solution for strategic countries at Bayer based on Veeva (Salesforce) and sales data (SAP, IMS, Wholesaler).

SQL Server 2014 SSIS SSAS SSRS XLCubed Power BI Tableau
CORE.X BI (Bayer AG)
6 Monate
2014-04 - 2014-09

Backpacking

Backpacking through India, Nepal, Taiwan and Indonesia

Asia
6 Jahre 1 Monat
2008-03 - 2014-03

Local data consolidation layer Australia

Technical Lead
Technical Lead

Consolidated customer and contract data from different internal
and external source systems for a new Salesforce CRM system
with focus on data consolidation and cleansing.

SQL Server 2012 SSIS SSRS
Daimler
6 Jahre 1 Monat
2008-03 - 2014-03

After-Sales China

Project Manager
Project Manager

Set up a new BI solution to monitor, analyze and improve the performance of the whole Daimler after-sales process in China.

SQL Server 2012 SSIS Cognos 10.1
Daimler TSS
6 Jahre 1 Monat
2008-03 - 2014-03

Telematics BI China

Technical Lead
Technical Lead

Set up a new BI solution to monitor, analyze and improve the product.

SQL Server 2008 R2 SSIS SSAS SSRS
Daimler TSS
6 Jahre 1 Monat
2008-03 - 2014-03

Car2go BI

Technical Lead
Technical Lead

Set up a company-wide BI solution for financial - customer - and
quality analysis after the product launch of Daimler mobility services (car2go).

SQL Server 2008 R2 SSIS SSAS SSRS SharePoint insights
Daimler TSS
Ulm, Germany
6 Jahre 1 Monat
2008-03 - 2014-03

Daimler Trucks Product Testing

Consultant & Developer SQL Server 2005/2008 R2 SSIS SSRS ...
Consultant & Developer

Set up a new BI solution to monitor the testing process & quality
of new trucks and their components before product launch.

SQL Server 2005/2008 R2 SSIS SSRS SharePoint (incl. custom web part)
Daimler TSS
Ulm, Germany
6 Jahre 1 Monat
2008-03 - 2014-03

Expatriate in China

1 year on-site assignment in Beijing for project management and coordination in BI projects with a development team in Kuala Lumpur and part of the pioneer team for a new office setup in China.

Daimler TSS
Ulm, Germany
5 Monate
2007-10 - 2008-02

Business Intelligence diploma thesis

Designed and implemented a PowerPoint rendering extension for MS SQL Server Reporting Services (SSRS).

Daimler TSS
Ulm, Germany
7 Monate
2007-03 - 2007-09

Project Management internship

Implemented and customized a project management software (Planta Project) and set up a portal solution on SharePoint basis with integration of Planta Project reports.

Micronas GmbH
Munich, Germany
6 Monate
2005-04 - 2005-09

Management Information System internship

Designed, implemented and maintained interfaces and reports on OLAP technology to monitor the production process for Mercedes A – Class.

Daimler AG
Rastatt, Germany

Aus- und Weiterbildung

Aus- und Weiterbildung

4 Jahre 5 Monate
2003-10 - 2008-02

Diploma in Business Information Technology

German Diploma ?Wirtschaftsinformatik? with major eBusiness and Internet, University of Applied Science Weingarten, Germany
German Diploma ?Wirtschaftsinformatik? with major eBusiness and Internet
University of Applied Science Weingarten, Germany
  • Dipoma degree: 1,6 (approximate equivalent: A-)
  • Participated on an 6 month students exchange program at Shinawatra University in Bangkok, Thailand where I developed my personality and intercultural skills

Position

Position

Business Intelligence Consulting und Development

Kompetenzen

Kompetenzen

Schwerpunkte

Core Knowledge Areas:

  • Business requirements analysis and documentation
  • ETL, DWH Design and Implementation (Star-/Snow-Flake Schema, Data Vault, RDM)
  • OLAP Cube Design and Implementation
  • Data Visualization (Reporting, Scorecards, Dashboards)
  • Technical focus on MS BI Stack (SQL Server, SSIS, SSAS, SSRS, SharePoint BI), web services and collaboration systems

Produkte / Standards / Erfahrungen / Methoden

Cognos 10.1
SharePoint (incl. custom web part)
SharePoint insights
XLCubed

During 9 years? working as Developer, Consultant and Project Manager in different Business Intelligence projects all over the world I have experienced that the key success factor for delivering valuable and sustainable BI solutions is a strong understanding of the business and their processes along with a sound knowledge of BI concepts and methodologies. With my hands-on development skills and ability to inspire and communicate with a wide variety of people I can always take full responsibility for a successful delivery of BI solutions in the whole software development lifecycle. During long- and short-term on-site assignments in Australia, Brazil, China and Malaysia I have developed strong communication skills and proofed my flexibility to adapt quickly and efficiently to new working environments.

Skills and Strength Processes & Methodologies:

  • Business Requirements Analysis and Documentation
  • Project Management
  • ETL, DWH Design and Implementation (Star-/Snow-Flake Schema, Data Vault, RDM)
  • OLAP Cube Design and Implementation
  • Data Visualization (Reporting, Scorecards, Dashboards) Tools & Technologies
  • MS BI-Stack (SSIS, SSAS, SSRS), SharePoint Insights (Excel Services, PowerView, SSRS), MS Visual Studio, MS Team Foundation Server, Jira, MS Office, MS Visio, IIS, Navision, Datazen, Power BI, XLCubed, Tableau, PowerApps, CozyRoc, PowerDesigner, MDS

Betriebssysteme

Windows

Programmiersprachen

.Net
ASP.Net, VB.Net, C#
Basic
DAX
JavaScript
MDX
PHP
PHP
PL/SQL
T-SQL
VBA

Datenbanken

DB/400
MS Access
MS SQL Server
MySQL
ODBC
SQL Server
2005, 2008 R2, 2012, 2014, 2017
SSAS
SSIS
SSRS

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.