Microsoft BI Stack, Power BI, Azure DevOps, Microsoft Data Analytics Platform, Azure Stack, SSAS Tab/Multi, SSIS, SSRS, IBCS Reporting
Aktualisiert am 07.06.2021
Profil
Freiberufler / Selbstständiger
Verfügbar ab: 01.10.2021
Verfügbar zu: 100%
davon vor Ort: 0%
MSBI stack
Deutsch
Englisch

Einsatzorte

Einsatzorte

Deutschland, Österreich, Schweiz
nicht möglich

Projekte

Projekte

6 Jahre 3 Monate
2018-01 - heute

O&G, Daisy Mobile, HL Tool, BI Workflow. Creating and customizing BI Reporting and web applications

Business Intelligence Senior Consultant MS SQL Server 2016 PowerBI DAX ...
Business Intelligence Senior Consultant

Language

German

MS SQL Server 2016 PowerBI DAX MDX T-SQL SSAS Tabular SSAS Olap SSIS SSRS .NET Oracle Teradata
Rewe Systems GmbH / Retail, Cologne, Germany
4 Monate
2017-09 - 2017-12

Toori (for client Toyota). Creating mobile reports for after sales with custom web app and embedded PowerBI reports

Business Intelligence Senior Consultant MS SQL Server 2016 PowerBI DAX ...
Business Intelligence Senior Consultant

Language

German

MS SQL Server 2016 PowerBI DAX T-SQL SSAS Tabular TFS git
MediaCom GmbH / Media, Dusseldorf, Germany
5 Monate
2017-05 - 2017-09

Migrating Oracle reports to SSRS Reporting Services and PowerBI

Business Intelligence Senior Consultant MS SQL Server 2016 PowerBI DAX ...
Business Intelligence Senior Consultant

Language

German

MS SQL Server 2016 PowerBI DAX MDX T-SQL SSAS Tabular SSRS Reporting Services TFS
Universal Investments / Financial Services, Frankfurt, Germany
6 Monate
2017-04 - 2017-09

ATLAS II ? Migrating sales controlling system to SQL Server 2014

Business Intelligence Senior Consultant MS SQL Server 2014 SSIS Integration Services SSAS Analysis Services ...
Business Intelligence Senior Consultant

Language

German, English

MS SQL Server 2014 SSIS Integration Services SSAS Analysis Services SSRS Reporting Services PowerBI MDX DAX TFS
Bayer AG / Pharma, Leverkusen, Germany
2 Monate
2017-02 - 2017-03

HANDY - Creating performance dashboards and reports based on PowerBI

Business Intelligence Senior Consultant PowerBI DAX T-SQL ...
Business Intelligence Senior Consultant

Language

German/English

PowerBI DAX T-SQL Oracle DB
DHL / Logistics, Bonn, Germany
2 Monate
2017-01 - 2017-02

KAM - Migrating legacy reports for after sales to SSRS 2016

Business Intelligence Senior Consultant MS SQL Server 2016 PowerBI DAX ...
Business Intelligence Senior Consultant

Project

Project KAM - Migrating legacy reports for after sales to SSRS 2016

  • PowerBI dashboard
  • SSRS report redesign and implementation

Language

German/English

MS SQL Server 2016 PowerBI DAX MDX T-SQL SSAS Tabular SSRS Reporting Services TFS
Daimler Benz / Automotive, Stuttgart, Germany
4 Monate
2016-10 - 2017-01

Planning and implementing a marketing information system, statistics, prediction with Cortana Intelligence Suite

Business Intelligence Principal Consultant and Project Lead MS SQL Server 2016 PowerBI DAX ...
Business Intelligence Principal Consultant and Project Lead

Project

Planning and implementing a marketing information system,

statistics, prediction with Cortana Intelligence Suite

  • Requirements, Documentation, Concept
  • PowerBI Dashboard and SSRS Report Design and Implementation
  • R Scripts for Brand Correlation and Regression Analysis

Language

English 

MS SQL Server 2016 PowerBI DAX T-SQL SSAS Tabular SSRS Reporting Services TFS
British American Tobacco / Tobacco, Sydney, Australia
1 Jahr 4 Monate
2015-07 - 2016-10

CoreX and ATLAS II - Planning, implementing und supporting a global sales information system, volume KPIs, statistics

Business Intelligence Senior Consultant MS SQL Server 2012/2014 SSIS Integration Services T-SQL ...
Business Intelligence Senior Consultant

Project

CoreX and ATLAS II - Planning, implementing und supporting a global sales information system, volume KPIs, statistics

  • Requirements, Documentation, Concept, Release management
  • Data Vault Model/DWH Design
  • Database Schema Design and Implementation
  • SSAS Cube Design and Implementation
  • SSIS ETL Processes Design and Implementation
  • SQL/MDX Queries, Procedures, UDFs, Agent Jobs
  • Report and Dashboard Design and Implementation with
  • Reporting Services, Qlikview, Datazen, XLCubed
  • Hichert IBCS Information Design Principles

Language

German, English 

MS SQL Server 2012/2014 SSIS Integration Services T-SQL MDX SSAS Analysis Services SSRS Reporting Services TFS Unit/NBI-Testing Qlikview XLCubed Datazen
Bayer AG / Pharma, Leverkusen
5 Monate
2015-03 - 2015-07

Planning, Implementing und Supporting HR Information System, HR, Finance, Volume KPIs, Statistics

Business Intelligence Senior Consultant MS SQL Server 2008R2 SSIS Integration Services T-SQL ...
Business Intelligence Senior Consultant

Project

Planning, Implementing und Supporting HR Information System, HR, Finance, Volume KPIs, Statistics

  • Requirements, Documentation, Concept
  • Data Model/DWH Design
  • Database Schema Design and Implementation
  • SSAS Cube Design and Implementation
  • SSIS ETL Processes Design and Implementation
  • SQL/MDX Queries, Procedures, UDFs, Agent Jobs
  • SSRS and Excel Services Report and Dashboard Design and Implementation
  • Hichert Information Design Principles
  • SharePoint Customizing

Language

German, English 

MS SQL Server 2008R2 SSIS Integration Services T-SQL SSAS Analysis Services SSRS Reporting Services Excel Services SharePoint 2010 PowerBI (PowerPivot) jQuery PowerShell TFS
Daimler Benz / Automotive, Stuttgart, Germany
1 Jahr 7 Monate
2014-01 - 2015-07

Implementing and supporting Analytics Framework

Business Intelligence Senior Consultant MS SQL Server 2012 SSIS Integration Services T-SQL ...
Business Intelligence Senior Consultant

Project

Implementing and supporting Analytics Framework 

  • Data Model Design
  • Database Schema Design and Implementation
  • SSIS ETL Processes Design and Implementation
  • SQL Queries, Procedures, UDFs, Agent Jobs
  • Web based Reporting System with D3 jQuery Library

Language

English

MS SQL Server 2012 SSIS Integration Services T-SQL SharePoint 2013 D3 JavaScript .Net
Oliver Wyman / Business Consulting, London, UK
4 Monate
2015-03 - 2015-06

Planning and Implementing DWH 2.0/APS

Business Intelligence Senior Consultant APS HDInsight
Business Intelligence Senior Consultant

Project

Planning and Implementing DWH 2.0/APS

  • Requirements, Documentation, Concept
  • Specification ETL

Language

German, English

APS HDInsight
Daimler Benz (Moovel GmbH) / Automotive, Stuttgart, Germany
3 Monate
2015-03 - 2015-05

Migration Legacy System to MS Azure/SQL Server 2014

Business Intelligence Senior Consultant MS Azure MS SQL Server 2014 T-SQL
Business Intelligence Senior Consultant

Project

Migration Legacy System to MS Azure/SQL Server 2014

  • Requirements, Documentation, Concept
  • Redesign Data Model, Procedures

Language

German, English

MS Azure MS SQL Server 2014 T-SQL
E-Wie-Einfach / Energy, Cologne, Germany
7 Monate
2014-09 - 2015-03

Migration legacy system to SQL Server 2014, planning and implementation of a risk- and opportunity BI system

Business Intelligence Specialist MS Azure MS SQL Server 2014 T-SQL ...
Business Intelligence Specialist

Project

Migration legacy system to SQL Server 2014, planning and implementation of a risk- and opportunity BI system

  • Requirements, Documentation, Concept
  • Data Model/DWH Design
  • Database Schema Design and Implementation
  • SSAS Cube Design and Implementation
  • SSIS ETL Processes Design and Implementation
  • SQL Queries, Procedures, UDFs, Agent Jobs
  • PowerBI and Excel Services Report Design and Implementation
  • SharePoint Customization

Language

English 

MS Azure MS SQL Server 2014 T-SQL SharePoint 2013 Excel Services PowerBI jQuery TFS
PwC / Business Services, Sydney, Australia
5 Monate
2014-03 - 2014-07

Planning, Implementing and supporting modular Analytics Framework

Business Intelligence Architect and Project Lead MS SQL Server 2012 SSIS Integration Services T-SQL ...
Business Intelligence Architect and Project Lead

Project

Planning, Implementing and supporting modular Analytics

Framework 

  • Requirements, Documentation, Concept
  • Data Model/DWH Design
  • Database Schema Design and Implementation
  • SSAS Cube Design and Implementation
  • SSIS ETL Processes Design and Implementation
  • SQL Queries, Procedures, UDFs, Agent Jobs
  • SSRS and Excel Services Report Design and Implementation
  • Hichert Information Design Principles

Language

English

MS SQL Server 2012 SSIS Integration Services T-SQL SSAS Analysis Services SSRS Reporting Services Excel Services SharePoint 2013 PowerBI (PowerPivot PowerMap) TFS
ITSC / Health Insurance, Hannover, Germany
3 Monate
2014-04 - 2014-06

Migration SAP BO Reporting System to SQL Server Reporting Services and SharePoint Integration

Business Intelligence Project Manager MS SQL Server 2012 SSIS Integration Services T-SQL ...
Business Intelligence Project Manager

Project

Migration SAP BO Reporting System to SQL Server Reporting

Services and SharePoint Integration

  • Requirements, Documentation, Concept
  • Database Schema Redesign and Implementation
  • Tuning SQL and MDX Queries
  • SSAS Analysis Services Cube Redesign
  • SSIS ETL Processes Design and Implementation
  • SSRS Report Design and Implementation
  • Hichert Information Design Principles
  • SharePoint Portal Design and Implementation

Language

German, English

MS SQL Server 2012 SSIS Integration Services T-SQL SSAS Analysis Services SSRS Reporting Services Excel Services SharePoint 2013 PowerBI (PowerPivot PowerView PowerMap) TFS
Schwartz Group ? Lidl / Retail, Neckarsulm, Germany
3 Monate
2014-01 - 2014-03

Migration Reporting MS Navision to SQL Server Reporting Services

Business Intelligence Senior Consultant MS SQL Server 2008R2 SSIS Integration Services T-SQL ...
Business Intelligence Senior Consultant

Project

Migration Reporting MS Navision to SQL Server Reporting Services

  • Query Tuning SQL and MDX
  • Database Schema Design and Implementation
  • SSIS ETL Processes Design and Implementation
  • SSRS Report Design and Implementation on SharePoint

Language

German, English

MS SQL Server 2008R2 SSIS Integration Services T-SQL SSAS Analysis Services SSRS Reporting Services SharePoint 2010
Schustermann & Borenstein / Retail, Munich, Germany

Aus- und Weiterbildung

Aus- und Weiterbildung

Education/Qualifications

2012 ? 2014

University Hagen

Master of Science (M.Sc.),BusinessInformatics

2006 ? 2012

University Hagen

Bachelor of Science (B.Sc.),ComputerScience

2011 ? 2011

University Duisburg-Essen

SAPBusinessIntelligence

2010 ? 2010

University Duisburg-Essen

SAPERP

2006 - 2009

Bachelor Professional of Financial Consulting (CCI)

Financial Consulting

Certifications

2013

Microsoft Certified Solutions Associate: Querying SQL Server 2012

Microsoft Germany

2011

Microsoft Certified IT Professional: Business Intelligence Developer 2008

Microsoft Germany

2011

Microsoft Certified Technology Specialist: SQL Server 2008 Business Intelligence

Microsoft Germany

Position

Position

Entwicklung von Business Intelligence Lösungen basierend auf Microsoft Business Intelligence und Azure Stack

Kompetenzen

Kompetenzen

Top-Skills

MSBI stack

Produkte / Standards / Erfahrungen / Methoden

MS SQL Server 2005, 2008, 2008R2, 2012, 2014, Business Intelligence, SSIS, SSAS, SSRS, SQL, MDX, Data Warehouse, Multidimensional and Tabular Data Modeling, SharePoint, Azure, Azure ML, Data Mining, Process Mining, Power BI, Power Pivot, Power View, Power Map, Business Analytics, ETL, Big Data, HDInsight, Web Intelligence

Employment History

February 2015 ? now

CEO and Founder - Business Intelligence Senior Consultant

Solutions:

Delivering Business Intelligence and Data Analytics Solutions based on Microsoft BI Stack and Cortana Intelligence Suite

 

January 2014 ? January 2015

KI Business Performance GmbH

Business Intelligence Senior Consultant

As a Senior Consultant and team leader of the SQL Server developer team I am responsible for success of the Business Intelligence projects. I am also responsible for design, implementation and deployment of services and solutions including:

Solutions:

  • Business Intelligence Solutions
  • Self-Service Reporting
  • Executive Dashboards
  • Management Reports
  • Technology: MS SQL Server 2008 R2, 2012, 2014, SSIS, SSAS, SSRS, SharePoint 2010, 2013, Excel 2010/2013, PowerBI, Excel Services

Services:

  • Business Intelligence Consulting
  • Architecture
  • Implementation & Development
  • Data Integration & Extraction
  • Training & Workshops

January 2014 ? January 2015

Oliver Wyman 

Business Intelligence Senior Consultant, Decision Centricity Team

Planning, Implementation and Support for Business Analytics Framework:

Solutions:

  • Business Intelligence Solutions
  • Technology: MS SQL Server 2012, T-SQL

Services:

  • Business Intelligence Consulting
  • Business Analytics in Retail

September 2014 ? February 2015

PwC Australia 

Business Intelligence Specialist

Migration Legacy System to SQL Server 2014, Planning and Implementation of a Risk- and Opportunity BI System

Solutions:

  • Business Intelligence Solutions
  • Self-Service Reporting
  • Technology: MS SQL Server 2014, SSIS, SSAS, Excel 2013, PowerBI, SharePoint 2013

Services:

  • Business Intelligence Consulting
  • Implementation & Development
  • Data Integration & Extraction

July 2012 ? December 2013

Volkswagen AG Germany 

Business Intelligence Consultant

As a Senior Consultant and team leader of the SQL Server developer team I am responsible for success of the Business Intelligence projects. I am also responsible for design, implementation and deployment of services and solutions including:

Solutions:

  • Business Intelligence Solutions
  • Self-Service Reporting
  • Executive Dashboards
  • Management Reports
  • Technology: MS SQL Server 2005 & 2008 & 2008 R2 & 2012, SSIS, SSAS, SSRS, SharePoint 2010, Excel 2007/2010

Services:

  • Business Intelligence Consulting
  • Architecture
  • Implementation & Development
  • Data Integration & Extraction
  • Training & Workshops

 

October 2010 ? June 2012

Obungi GmbH Germany

Business Intelligence Developer

  • Worked on several Business Intelligence projects, involved in full life cycle of BusinessIntelligence/DWH
  • Designed and developed a Data Mining Solution for RYF Coiffeur Hamburg
  • Designed and developed ETL, DWH and OLAP Database and Cube for Eucon GmbH
  • Designed and developed an OLAP Database and Cube for Generali Versicherung Munich
  • Requirements gathering, documentation and ETL for Vapiano S.E. Bonn
  • Business Intelligence support for HypoRealEstate and Hamburger Sparkasse
  • Technology: MS SQL Server 2005 & 2008 & 2008 R2, SSIS, SSAS, SSRS, Excel 2007

 

April 2009 ? October 2009

EWE Tel GmbH 

Project Assistant

  • Process Analysis and documentation with ARIS

Project support, workshops, training

Programmiersprachen

Basic
Visual Basic
C#

Datenbanken

Azure Data Factory
Cortana Intelligence Suite
Datawarehouse
Dax
ETL
MDX
Microsoft Analysis Services
Microsoft Azure SQL Database
Microsoft Data Analytics Platform
MS SQL Server
PowerBI
R
Reporting Services
SQL
SQL Azure
SSAS
SSIS
SSRS

MS SQL Server, Microsoft Data Analytics Platform, Cortana Intelligence Suite, Azure SQL Database, Azure SQL Data Warehouse, Azure Data Factory, Big Data Strategy, Business Intelligence, Business Analytics, ETL, SSIS, SSAS, SSRS, Reporting, MDX, DAX, SQL, R, Data Modeling, Datawarehouse, Multidimensional DBMS,Tabular Datamodel,Power BI, XLCubed, Mobile BI, SharePoint

Branchen

Branchen

  • Automotive: Volkswagen AG, Daimler AG
  • Pharma: Bayer AG
  • Logistics: DHL
  • Tobacco: British American Tobacco
  • Retail: Schustermann & Borenstein AG, Metro AG, Lidl, Auchan
  • Banking & Financial Services: Hamburger Sparkasse, HypoRealEstate, NordLB
  • Business Services: Oliver Wyman, PwC
  • Insurance: ITSC GmbH, Generali Versicherung AG, Eucon GmbH, Daimler BKK
  • Services: RYF Coiffeur, Vapiano S.E.
  • Energy: EWE, E-Wie-Einfach
  • Telecommunication: Zain Telecom, EWE Tel GmbH

Einsatzorte

Einsatzorte

Deutschland, Österreich, Schweiz
nicht möglich

Projekte

Projekte

6 Jahre 3 Monate
2018-01 - heute

O&G, Daisy Mobile, HL Tool, BI Workflow. Creating and customizing BI Reporting and web applications

Business Intelligence Senior Consultant MS SQL Server 2016 PowerBI DAX ...
Business Intelligence Senior Consultant

Language

German

MS SQL Server 2016 PowerBI DAX MDX T-SQL SSAS Tabular SSAS Olap SSIS SSRS .NET Oracle Teradata
Rewe Systems GmbH / Retail, Cologne, Germany
4 Monate
2017-09 - 2017-12

Toori (for client Toyota). Creating mobile reports for after sales with custom web app and embedded PowerBI reports

Business Intelligence Senior Consultant MS SQL Server 2016 PowerBI DAX ...
Business Intelligence Senior Consultant

Language

German

MS SQL Server 2016 PowerBI DAX T-SQL SSAS Tabular TFS git
MediaCom GmbH / Media, Dusseldorf, Germany
5 Monate
2017-05 - 2017-09

Migrating Oracle reports to SSRS Reporting Services and PowerBI

Business Intelligence Senior Consultant MS SQL Server 2016 PowerBI DAX ...
Business Intelligence Senior Consultant

Language

German

MS SQL Server 2016 PowerBI DAX MDX T-SQL SSAS Tabular SSRS Reporting Services TFS
Universal Investments / Financial Services, Frankfurt, Germany
6 Monate
2017-04 - 2017-09

ATLAS II ? Migrating sales controlling system to SQL Server 2014

Business Intelligence Senior Consultant MS SQL Server 2014 SSIS Integration Services SSAS Analysis Services ...
Business Intelligence Senior Consultant

Language

German, English

MS SQL Server 2014 SSIS Integration Services SSAS Analysis Services SSRS Reporting Services PowerBI MDX DAX TFS
Bayer AG / Pharma, Leverkusen, Germany
2 Monate
2017-02 - 2017-03

HANDY - Creating performance dashboards and reports based on PowerBI

Business Intelligence Senior Consultant PowerBI DAX T-SQL ...
Business Intelligence Senior Consultant

Language

German/English

PowerBI DAX T-SQL Oracle DB
DHL / Logistics, Bonn, Germany
2 Monate
2017-01 - 2017-02

KAM - Migrating legacy reports for after sales to SSRS 2016

Business Intelligence Senior Consultant MS SQL Server 2016 PowerBI DAX ...
Business Intelligence Senior Consultant

Project

Project KAM - Migrating legacy reports for after sales to SSRS 2016

  • PowerBI dashboard
  • SSRS report redesign and implementation

Language

German/English

MS SQL Server 2016 PowerBI DAX MDX T-SQL SSAS Tabular SSRS Reporting Services TFS
Daimler Benz / Automotive, Stuttgart, Germany
4 Monate
2016-10 - 2017-01

Planning and implementing a marketing information system, statistics, prediction with Cortana Intelligence Suite

Business Intelligence Principal Consultant and Project Lead MS SQL Server 2016 PowerBI DAX ...
Business Intelligence Principal Consultant and Project Lead

Project

Planning and implementing a marketing information system,

statistics, prediction with Cortana Intelligence Suite

  • Requirements, Documentation, Concept
  • PowerBI Dashboard and SSRS Report Design and Implementation
  • R Scripts for Brand Correlation and Regression Analysis

Language

English 

MS SQL Server 2016 PowerBI DAX T-SQL SSAS Tabular SSRS Reporting Services TFS
British American Tobacco / Tobacco, Sydney, Australia
1 Jahr 4 Monate
2015-07 - 2016-10

CoreX and ATLAS II - Planning, implementing und supporting a global sales information system, volume KPIs, statistics

Business Intelligence Senior Consultant MS SQL Server 2012/2014 SSIS Integration Services T-SQL ...
Business Intelligence Senior Consultant

Project

CoreX and ATLAS II - Planning, implementing und supporting a global sales information system, volume KPIs, statistics

  • Requirements, Documentation, Concept, Release management
  • Data Vault Model/DWH Design
  • Database Schema Design and Implementation
  • SSAS Cube Design and Implementation
  • SSIS ETL Processes Design and Implementation
  • SQL/MDX Queries, Procedures, UDFs, Agent Jobs
  • Report and Dashboard Design and Implementation with
  • Reporting Services, Qlikview, Datazen, XLCubed
  • Hichert IBCS Information Design Principles

Language

German, English 

MS SQL Server 2012/2014 SSIS Integration Services T-SQL MDX SSAS Analysis Services SSRS Reporting Services TFS Unit/NBI-Testing Qlikview XLCubed Datazen
Bayer AG / Pharma, Leverkusen
5 Monate
2015-03 - 2015-07

Planning, Implementing und Supporting HR Information System, HR, Finance, Volume KPIs, Statistics

Business Intelligence Senior Consultant MS SQL Server 2008R2 SSIS Integration Services T-SQL ...
Business Intelligence Senior Consultant

Project

Planning, Implementing und Supporting HR Information System, HR, Finance, Volume KPIs, Statistics

  • Requirements, Documentation, Concept
  • Data Model/DWH Design
  • Database Schema Design and Implementation
  • SSAS Cube Design and Implementation
  • SSIS ETL Processes Design and Implementation
  • SQL/MDX Queries, Procedures, UDFs, Agent Jobs
  • SSRS and Excel Services Report and Dashboard Design and Implementation
  • Hichert Information Design Principles
  • SharePoint Customizing

Language

German, English 

MS SQL Server 2008R2 SSIS Integration Services T-SQL SSAS Analysis Services SSRS Reporting Services Excel Services SharePoint 2010 PowerBI (PowerPivot) jQuery PowerShell TFS
Daimler Benz / Automotive, Stuttgart, Germany
1 Jahr 7 Monate
2014-01 - 2015-07

Implementing and supporting Analytics Framework

Business Intelligence Senior Consultant MS SQL Server 2012 SSIS Integration Services T-SQL ...
Business Intelligence Senior Consultant

Project

Implementing and supporting Analytics Framework 

  • Data Model Design
  • Database Schema Design and Implementation
  • SSIS ETL Processes Design and Implementation
  • SQL Queries, Procedures, UDFs, Agent Jobs
  • Web based Reporting System with D3 jQuery Library

Language

English

MS SQL Server 2012 SSIS Integration Services T-SQL SharePoint 2013 D3 JavaScript .Net
Oliver Wyman / Business Consulting, London, UK
4 Monate
2015-03 - 2015-06

Planning and Implementing DWH 2.0/APS

Business Intelligence Senior Consultant APS HDInsight
Business Intelligence Senior Consultant

Project

Planning and Implementing DWH 2.0/APS

  • Requirements, Documentation, Concept
  • Specification ETL

Language

German, English

APS HDInsight
Daimler Benz (Moovel GmbH) / Automotive, Stuttgart, Germany
3 Monate
2015-03 - 2015-05

Migration Legacy System to MS Azure/SQL Server 2014

Business Intelligence Senior Consultant MS Azure MS SQL Server 2014 T-SQL
Business Intelligence Senior Consultant

Project

Migration Legacy System to MS Azure/SQL Server 2014

  • Requirements, Documentation, Concept
  • Redesign Data Model, Procedures

Language

German, English

MS Azure MS SQL Server 2014 T-SQL
E-Wie-Einfach / Energy, Cologne, Germany
7 Monate
2014-09 - 2015-03

Migration legacy system to SQL Server 2014, planning and implementation of a risk- and opportunity BI system

Business Intelligence Specialist MS Azure MS SQL Server 2014 T-SQL ...
Business Intelligence Specialist

Project

Migration legacy system to SQL Server 2014, planning and implementation of a risk- and opportunity BI system

  • Requirements, Documentation, Concept
  • Data Model/DWH Design
  • Database Schema Design and Implementation
  • SSAS Cube Design and Implementation
  • SSIS ETL Processes Design and Implementation
  • SQL Queries, Procedures, UDFs, Agent Jobs
  • PowerBI and Excel Services Report Design and Implementation
  • SharePoint Customization

Language

English 

MS Azure MS SQL Server 2014 T-SQL SharePoint 2013 Excel Services PowerBI jQuery TFS
PwC / Business Services, Sydney, Australia
5 Monate
2014-03 - 2014-07

Planning, Implementing and supporting modular Analytics Framework

Business Intelligence Architect and Project Lead MS SQL Server 2012 SSIS Integration Services T-SQL ...
Business Intelligence Architect and Project Lead

Project

Planning, Implementing and supporting modular Analytics

Framework 

  • Requirements, Documentation, Concept
  • Data Model/DWH Design
  • Database Schema Design and Implementation
  • SSAS Cube Design and Implementation
  • SSIS ETL Processes Design and Implementation
  • SQL Queries, Procedures, UDFs, Agent Jobs
  • SSRS and Excel Services Report Design and Implementation
  • Hichert Information Design Principles

Language

English

MS SQL Server 2012 SSIS Integration Services T-SQL SSAS Analysis Services SSRS Reporting Services Excel Services SharePoint 2013 PowerBI (PowerPivot PowerMap) TFS
ITSC / Health Insurance, Hannover, Germany
3 Monate
2014-04 - 2014-06

Migration SAP BO Reporting System to SQL Server Reporting Services and SharePoint Integration

Business Intelligence Project Manager MS SQL Server 2012 SSIS Integration Services T-SQL ...
Business Intelligence Project Manager

Project

Migration SAP BO Reporting System to SQL Server Reporting

Services and SharePoint Integration

  • Requirements, Documentation, Concept
  • Database Schema Redesign and Implementation
  • Tuning SQL and MDX Queries
  • SSAS Analysis Services Cube Redesign
  • SSIS ETL Processes Design and Implementation
  • SSRS Report Design and Implementation
  • Hichert Information Design Principles
  • SharePoint Portal Design and Implementation

Language

German, English

MS SQL Server 2012 SSIS Integration Services T-SQL SSAS Analysis Services SSRS Reporting Services Excel Services SharePoint 2013 PowerBI (PowerPivot PowerView PowerMap) TFS
Schwartz Group ? Lidl / Retail, Neckarsulm, Germany
3 Monate
2014-01 - 2014-03

Migration Reporting MS Navision to SQL Server Reporting Services

Business Intelligence Senior Consultant MS SQL Server 2008R2 SSIS Integration Services T-SQL ...
Business Intelligence Senior Consultant

Project

Migration Reporting MS Navision to SQL Server Reporting Services

  • Query Tuning SQL and MDX
  • Database Schema Design and Implementation
  • SSIS ETL Processes Design and Implementation
  • SSRS Report Design and Implementation on SharePoint

Language

German, English

MS SQL Server 2008R2 SSIS Integration Services T-SQL SSAS Analysis Services SSRS Reporting Services SharePoint 2010
Schustermann & Borenstein / Retail, Munich, Germany

Aus- und Weiterbildung

Aus- und Weiterbildung

Education/Qualifications

2012 ? 2014

University Hagen

Master of Science (M.Sc.),BusinessInformatics

2006 ? 2012

University Hagen

Bachelor of Science (B.Sc.),ComputerScience

2011 ? 2011

University Duisburg-Essen

SAPBusinessIntelligence

2010 ? 2010

University Duisburg-Essen

SAPERP

2006 - 2009

Bachelor Professional of Financial Consulting (CCI)

Financial Consulting

Certifications

2013

Microsoft Certified Solutions Associate: Querying SQL Server 2012

Microsoft Germany

2011

Microsoft Certified IT Professional: Business Intelligence Developer 2008

Microsoft Germany

2011

Microsoft Certified Technology Specialist: SQL Server 2008 Business Intelligence

Microsoft Germany

Position

Position

Entwicklung von Business Intelligence Lösungen basierend auf Microsoft Business Intelligence und Azure Stack

Kompetenzen

Kompetenzen

Top-Skills

MSBI stack

Produkte / Standards / Erfahrungen / Methoden

MS SQL Server 2005, 2008, 2008R2, 2012, 2014, Business Intelligence, SSIS, SSAS, SSRS, SQL, MDX, Data Warehouse, Multidimensional and Tabular Data Modeling, SharePoint, Azure, Azure ML, Data Mining, Process Mining, Power BI, Power Pivot, Power View, Power Map, Business Analytics, ETL, Big Data, HDInsight, Web Intelligence

Employment History

February 2015 ? now

CEO and Founder - Business Intelligence Senior Consultant

Solutions:

Delivering Business Intelligence and Data Analytics Solutions based on Microsoft BI Stack and Cortana Intelligence Suite

 

January 2014 ? January 2015

KI Business Performance GmbH

Business Intelligence Senior Consultant

As a Senior Consultant and team leader of the SQL Server developer team I am responsible for success of the Business Intelligence projects. I am also responsible for design, implementation and deployment of services and solutions including:

Solutions:

  • Business Intelligence Solutions
  • Self-Service Reporting
  • Executive Dashboards
  • Management Reports
  • Technology: MS SQL Server 2008 R2, 2012, 2014, SSIS, SSAS, SSRS, SharePoint 2010, 2013, Excel 2010/2013, PowerBI, Excel Services

Services:

  • Business Intelligence Consulting
  • Architecture
  • Implementation & Development
  • Data Integration & Extraction
  • Training & Workshops

January 2014 ? January 2015

Oliver Wyman 

Business Intelligence Senior Consultant, Decision Centricity Team

Planning, Implementation and Support for Business Analytics Framework:

Solutions:

  • Business Intelligence Solutions
  • Technology: MS SQL Server 2012, T-SQL

Services:

  • Business Intelligence Consulting
  • Business Analytics in Retail

September 2014 ? February 2015

PwC Australia 

Business Intelligence Specialist

Migration Legacy System to SQL Server 2014, Planning and Implementation of a Risk- and Opportunity BI System

Solutions:

  • Business Intelligence Solutions
  • Self-Service Reporting
  • Technology: MS SQL Server 2014, SSIS, SSAS, Excel 2013, PowerBI, SharePoint 2013

Services:

  • Business Intelligence Consulting
  • Implementation & Development
  • Data Integration & Extraction

July 2012 ? December 2013

Volkswagen AG Germany 

Business Intelligence Consultant

As a Senior Consultant and team leader of the SQL Server developer team I am responsible for success of the Business Intelligence projects. I am also responsible for design, implementation and deployment of services and solutions including:

Solutions:

  • Business Intelligence Solutions
  • Self-Service Reporting
  • Executive Dashboards
  • Management Reports
  • Technology: MS SQL Server 2005 & 2008 & 2008 R2 & 2012, SSIS, SSAS, SSRS, SharePoint 2010, Excel 2007/2010

Services:

  • Business Intelligence Consulting
  • Architecture
  • Implementation & Development
  • Data Integration & Extraction
  • Training & Workshops

 

October 2010 ? June 2012

Obungi GmbH Germany

Business Intelligence Developer

  • Worked on several Business Intelligence projects, involved in full life cycle of BusinessIntelligence/DWH
  • Designed and developed a Data Mining Solution for RYF Coiffeur Hamburg
  • Designed and developed ETL, DWH and OLAP Database and Cube for Eucon GmbH
  • Designed and developed an OLAP Database and Cube for Generali Versicherung Munich
  • Requirements gathering, documentation and ETL for Vapiano S.E. Bonn
  • Business Intelligence support for HypoRealEstate and Hamburger Sparkasse
  • Technology: MS SQL Server 2005 & 2008 & 2008 R2, SSIS, SSAS, SSRS, Excel 2007

 

April 2009 ? October 2009

EWE Tel GmbH 

Project Assistant

  • Process Analysis and documentation with ARIS

Project support, workshops, training

Programmiersprachen

Basic
Visual Basic
C#

Datenbanken

Azure Data Factory
Cortana Intelligence Suite
Datawarehouse
Dax
ETL
MDX
Microsoft Analysis Services
Microsoft Azure SQL Database
Microsoft Data Analytics Platform
MS SQL Server
PowerBI
R
Reporting Services
SQL
SQL Azure
SSAS
SSIS
SSRS

MS SQL Server, Microsoft Data Analytics Platform, Cortana Intelligence Suite, Azure SQL Database, Azure SQL Data Warehouse, Azure Data Factory, Big Data Strategy, Business Intelligence, Business Analytics, ETL, SSIS, SSAS, SSRS, Reporting, MDX, DAX, SQL, R, Data Modeling, Datawarehouse, Multidimensional DBMS,Tabular Datamodel,Power BI, XLCubed, Mobile BI, SharePoint

Branchen

Branchen

  • Automotive: Volkswagen AG, Daimler AG
  • Pharma: Bayer AG
  • Logistics: DHL
  • Tobacco: British American Tobacco
  • Retail: Schustermann & Borenstein AG, Metro AG, Lidl, Auchan
  • Banking & Financial Services: Hamburger Sparkasse, HypoRealEstate, NordLB
  • Business Services: Oliver Wyman, PwC
  • Insurance: ITSC GmbH, Generali Versicherung AG, Eucon GmbH, Daimler BKK
  • Services: RYF Coiffeur, Vapiano S.E.
  • Energy: EWE, E-Wie-Einfach
  • Telecommunication: Zain Telecom, EWE Tel GmbH

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.