BI-Experte mit über 20 Jahren Erfahrung. Schwerpunkt ist MicroStrategy und DB-Entwicklung/Modellierung
Aktualisiert am 26.07.2024
Profil
Freiberufler / Selbstständiger
Remote-Arbeit
Verfügbar ab: 26.07.2024
Verfügbar zu: 100%
davon vor Ort: 100%
BI-Experte
Database-Skills
MicroStrategy Analyst
Datenbank-Entwicklung
Datenbank-Modellierung
MicroStrategy-Architect
MicroStrategy
Analyst
DWH-Architektur
SQL
ETL
APEX-Grundkenntnisse
English
Fortgeschritten
German

Einsatzorte

Einsatzorte

Bonn (+50km)
Deutschland
möglich

Projekte

Projekte

10 Monate
2023-09 - heute

Analytics for B2B-data

Developer
Developer

Developing Dasboards for a small B2B-data project with Oracle Apex. I created dashboards for a startup B2B-Analytics. I created new DB-Objects, Reports and Dashboards needed to analyse B2B-Data.

  • Planning&Designing Apps in Oracle APEX
  • Creating DB-Objects with Oracle SQL-Workshop
  • Creating Pages, Dashboards with App-Builder in Oracle-APEX

5 Jahre 8 Monate
2017-05 - 2022-12

Sales Cockpit 2020

MSTR Project lead / Analyst Teradata 16.2
MSTR Project lead / Analyst

As a MicroStrategy consultant with developer skills I managed the migration from an existing sales application to MicroStrategy dashnoards. I realized with GDC Colleagues the complete implementation and design together with the customer. Sales Cockpit 2020 is a dashboard application including nearly 40 KPIs for all stores on several region levels. With this application business can analyse his own region from different perspectives.

  • Gathering, specification and discussion of requirements with Business
  • Coordination of GDC developers and design team in Warsaw
  • Implementing RS Documents
  • Creating MSTR-Objects in MicroStrategy Architect
  • Creating Cubes&Reports&Dashboards for business
  • Performance analysis

Teradata 16.2
REWE
Cologne / Germany
10 Monate
2020-11 - 2021-08

Customer Journey

Analyst / Architect
Analyst / Architect

The customer satisfaction surveys carried out by Telekom are made available in MicroStrategy dossiers for evaluations

  • Creating the connection to the Backend/Database
  • Creating the schema Layer in MSTR
  • Implementing visualisations in MSTR-Dossiers
  • Performance analysis
  • Connecting to Database: Impala
  • Creating Cubes
  • Gathering, specification and discussion of functional requirements with BI-team
  • Creating MSTR Schema-Objects and application Objects in MicroStrategy
  • Discussion of design requirements with BI-team
  • Quality Check of the DWH-Data with SQL-Statements in SQL-Editor of Impala

Rel. DB MicroStrategy
Deutsche Telekom
Bonn
2 Jahre 1 Monat
2018-05 - 2020-05

different projects in BI Team

Analyst / Developer Oracle 19
Analyst / Developer

Together with the BI team from ThyssenKrupp Steel we migrated all reports from Busieness Objects to MicroStrategy. All reports/dashboards are migrated completely.

  • Gathering, specification and discussion of requirements with BBS and Business
  • Implementing Reports, RS Documents & Dossiers in MSTR
  • Implementing Dossiers&RS Documents for business
  • Creating MSTR-Objects in MicroStrategy Architect
  • Creating Cubes&Reports
  • Performance analysis

Oracle 19
ThyssenKrupp-Steel,
Duisburg / Germany
2 Jahre 5 Monate
2015-01 - 2017-05

Dev@Com Web Reporting

Business analyst / Developer / MSTR Project lead Oracle
Business analyst / Developer / MSTR Project lead

I participated in a full cycle MicroStrategy Dasboard implementation as a consultant. I supported development with designing and building dashboards for the business side. As an business analyst with developer skills I created new MicroStrategy Schema Objects, Reports and dashboards required from business. The Dev@Com Web-Reporting is intended to support business analyzing complaints, issues and deviations in the production process. Dev@Com Web-Reporting allows responsible personnel to analyze data contained in the (transactional) Dev@Com system. This analysis provides data relating to product information (including trend analyses); performance assessments such as timelines of file closure and file status checks, and provide reports to meet regulatory reporting requirements.

  • Gathering, specification and discussion of requirements with Business
  • Documentation of the requirements
  • Coordination of GDC Colleagues in Warsaw and communication with IT-Backend team
  • Implementing in MSTR, Rep. Services Documents & Visual Insight
  • Connecting new tables in the DWH
  • Creating MSTR-Objects in MicroStrategy Architect
  • Creating Cubes&Reports&Dashboards for business
  • Performance analysis

Oracle
Bayer Health Care
Leverkusen / Germany
2 Jahre 11 Monate
2014-07 - 2017-05

Performance analysis

BI-Developer
BI-Developer

  • Gathering, specification and discussion of functional reqs with BI-team
  • Creating the connection to the Backend/Database
  • Creating the schema Layer in MSTR 
  • Implementing visualisations in MSTR-Dossiers 
  • Performance analysis
  • Creating Cubes
  • Creating MSTR Schema-Objects and application Objects in MicroStrategy

MicroStrategy Oracle
Bayer
Leverkusen
13 Jahre 8 Monate
2000-07 - 2014-02

DWH-Mobile

BI-Analyst / Data-Analyst Informatica AB Initio Cognos ...
BI-Analyst / Data-Analyst

Creating/Developing Database objects in DWH

  • Requirement management
  • Backend/Database (Oracle)
  • ETL-Tasks (Informatica, AB Initio)
  • Performance analysis
  • Creating Cubes (Cognos)
  • Gathering and documentation of functional requirements with BI-stakeholders
  • Discussion of design requirements with BI-team
  • Quality Check of the DWH-Data with SQL-Statements and PL/SQL Scripts in Oracle
  • Creating/maintaining DB-Objects in Oracle
  • Creating/maintaining ETL- flows in Informatica
  • Performance analysis in Oracle to get better User-Acceptance

Oracle Informatica PowerCenter
Informatica AB Initio Cognos PL/SQL
Deutsche Telekom
Bonn

Aus- und Weiterbildung

Aus- und Weiterbildung

8 Jahre 11 Monate
2001-08 - 2010-06

Business Information Systems

Master, FH Ludwigshafen, Graduate School Rhein Neckar
Master
FH Ludwigshafen, Graduate School Rhein Neckar

  • Business Performance Management
  • Business Intelligence

2 Monate
2001-03 - 2001-04

Certification "MicroStrategy Certified Architect"

Certificate MicroStrategy Certified Architect, MicroStrategy Köln
Certificate MicroStrategy Certified Architect
MicroStrategy Köln

Kompetenzen

Kompetenzen

Top-Skills

BI-Experte Database-Skills MicroStrategy Analyst Datenbank-Entwicklung Datenbank-Modellierung MicroStrategy-Architect MicroStrategy Analyst DWH-Architektur SQL ETL APEX-Grundkenntnisse

Schwerpunkte

MicroStrategy
Experte
Oracle
Experte
Oracle APEX
Basics
ETL
Fortgeschritten
SQL
Experte
DWH
Experte
BI
Experte

Produkte / Standards / Erfahrungen / Methoden

Profile

I am a Professional Services consultant, born 1970 with over 20 years of experience in Business Intelligence projects. I started as Developer Consultant in BI Projects with Programming Database and ETL Processes at T-Mobile Germany in 2000. Later my part were Requirements Gathering, Conceptual Design and Data Modeling in different projects. In 2010 I visited the Graduate School Rhein Neckar to graduate in Business Information Systems and to get more theoretical Knowledge about Business Intelligence Processes. I?m well versed in Databases&SQL and Conceptual Design and interested in creating the fundament for BI projects like Data Modeling and creating the base reports for the processes coming later.


Proprietary Skills:

  • Data Modeling
  • DB-Development
  • Building Reports&Dashboards


Other Technical Skills:

  • Database
  • ETL
  • SQL
  • Oracle

Special Skills:

  • Requirement Analysis
  • Documentation

Branchen

Branchen

  • Telecommunication
  • Sales
  • Industry

Einsatzorte

Einsatzorte

Bonn (+50km)
Deutschland
möglich

Projekte

Projekte

10 Monate
2023-09 - heute

Analytics for B2B-data

Developer
Developer

Developing Dasboards for a small B2B-data project with Oracle Apex. I created dashboards for a startup B2B-Analytics. I created new DB-Objects, Reports and Dashboards needed to analyse B2B-Data.

  • Planning&Designing Apps in Oracle APEX
  • Creating DB-Objects with Oracle SQL-Workshop
  • Creating Pages, Dashboards with App-Builder in Oracle-APEX

5 Jahre 8 Monate
2017-05 - 2022-12

Sales Cockpit 2020

MSTR Project lead / Analyst Teradata 16.2
MSTR Project lead / Analyst

As a MicroStrategy consultant with developer skills I managed the migration from an existing sales application to MicroStrategy dashnoards. I realized with GDC Colleagues the complete implementation and design together with the customer. Sales Cockpit 2020 is a dashboard application including nearly 40 KPIs for all stores on several region levels. With this application business can analyse his own region from different perspectives.

  • Gathering, specification and discussion of requirements with Business
  • Coordination of GDC developers and design team in Warsaw
  • Implementing RS Documents
  • Creating MSTR-Objects in MicroStrategy Architect
  • Creating Cubes&Reports&Dashboards for business
  • Performance analysis

Teradata 16.2
REWE
Cologne / Germany
10 Monate
2020-11 - 2021-08

Customer Journey

Analyst / Architect
Analyst / Architect

The customer satisfaction surveys carried out by Telekom are made available in MicroStrategy dossiers for evaluations

  • Creating the connection to the Backend/Database
  • Creating the schema Layer in MSTR
  • Implementing visualisations in MSTR-Dossiers
  • Performance analysis
  • Connecting to Database: Impala
  • Creating Cubes
  • Gathering, specification and discussion of functional requirements with BI-team
  • Creating MSTR Schema-Objects and application Objects in MicroStrategy
  • Discussion of design requirements with BI-team
  • Quality Check of the DWH-Data with SQL-Statements in SQL-Editor of Impala

Rel. DB MicroStrategy
Deutsche Telekom
Bonn
2 Jahre 1 Monat
2018-05 - 2020-05

different projects in BI Team

Analyst / Developer Oracle 19
Analyst / Developer

Together with the BI team from ThyssenKrupp Steel we migrated all reports from Busieness Objects to MicroStrategy. All reports/dashboards are migrated completely.

  • Gathering, specification and discussion of requirements with BBS and Business
  • Implementing Reports, RS Documents & Dossiers in MSTR
  • Implementing Dossiers&RS Documents for business
  • Creating MSTR-Objects in MicroStrategy Architect
  • Creating Cubes&Reports
  • Performance analysis

Oracle 19
ThyssenKrupp-Steel,
Duisburg / Germany
2 Jahre 5 Monate
2015-01 - 2017-05

Dev@Com Web Reporting

Business analyst / Developer / MSTR Project lead Oracle
Business analyst / Developer / MSTR Project lead

I participated in a full cycle MicroStrategy Dasboard implementation as a consultant. I supported development with designing and building dashboards for the business side. As an business analyst with developer skills I created new MicroStrategy Schema Objects, Reports and dashboards required from business. The Dev@Com Web-Reporting is intended to support business analyzing complaints, issues and deviations in the production process. Dev@Com Web-Reporting allows responsible personnel to analyze data contained in the (transactional) Dev@Com system. This analysis provides data relating to product information (including trend analyses); performance assessments such as timelines of file closure and file status checks, and provide reports to meet regulatory reporting requirements.

  • Gathering, specification and discussion of requirements with Business
  • Documentation of the requirements
  • Coordination of GDC Colleagues in Warsaw and communication with IT-Backend team
  • Implementing in MSTR, Rep. Services Documents & Visual Insight
  • Connecting new tables in the DWH
  • Creating MSTR-Objects in MicroStrategy Architect
  • Creating Cubes&Reports&Dashboards for business
  • Performance analysis

Oracle
Bayer Health Care
Leverkusen / Germany
2 Jahre 11 Monate
2014-07 - 2017-05

Performance analysis

BI-Developer
BI-Developer

  • Gathering, specification and discussion of functional reqs with BI-team
  • Creating the connection to the Backend/Database
  • Creating the schema Layer in MSTR 
  • Implementing visualisations in MSTR-Dossiers 
  • Performance analysis
  • Creating Cubes
  • Creating MSTR Schema-Objects and application Objects in MicroStrategy

MicroStrategy Oracle
Bayer
Leverkusen
13 Jahre 8 Monate
2000-07 - 2014-02

DWH-Mobile

BI-Analyst / Data-Analyst Informatica AB Initio Cognos ...
BI-Analyst / Data-Analyst

Creating/Developing Database objects in DWH

  • Requirement management
  • Backend/Database (Oracle)
  • ETL-Tasks (Informatica, AB Initio)
  • Performance analysis
  • Creating Cubes (Cognos)
  • Gathering and documentation of functional requirements with BI-stakeholders
  • Discussion of design requirements with BI-team
  • Quality Check of the DWH-Data with SQL-Statements and PL/SQL Scripts in Oracle
  • Creating/maintaining DB-Objects in Oracle
  • Creating/maintaining ETL- flows in Informatica
  • Performance analysis in Oracle to get better User-Acceptance

Oracle Informatica PowerCenter
Informatica AB Initio Cognos PL/SQL
Deutsche Telekom
Bonn

Aus- und Weiterbildung

Aus- und Weiterbildung

8 Jahre 11 Monate
2001-08 - 2010-06

Business Information Systems

Master, FH Ludwigshafen, Graduate School Rhein Neckar
Master
FH Ludwigshafen, Graduate School Rhein Neckar

  • Business Performance Management
  • Business Intelligence

2 Monate
2001-03 - 2001-04

Certification "MicroStrategy Certified Architect"

Certificate MicroStrategy Certified Architect, MicroStrategy Köln
Certificate MicroStrategy Certified Architect
MicroStrategy Köln

Kompetenzen

Kompetenzen

Top-Skills

BI-Experte Database-Skills MicroStrategy Analyst Datenbank-Entwicklung Datenbank-Modellierung MicroStrategy-Architect MicroStrategy Analyst DWH-Architektur SQL ETL APEX-Grundkenntnisse

Schwerpunkte

MicroStrategy
Experte
Oracle
Experte
Oracle APEX
Basics
ETL
Fortgeschritten
SQL
Experte
DWH
Experte
BI
Experte

Produkte / Standards / Erfahrungen / Methoden

Profile

I am a Professional Services consultant, born 1970 with over 20 years of experience in Business Intelligence projects. I started as Developer Consultant in BI Projects with Programming Database and ETL Processes at T-Mobile Germany in 2000. Later my part were Requirements Gathering, Conceptual Design and Data Modeling in different projects. In 2010 I visited the Graduate School Rhein Neckar to graduate in Business Information Systems and to get more theoretical Knowledge about Business Intelligence Processes. I?m well versed in Databases&SQL and Conceptual Design and interested in creating the fundament for BI projects like Data Modeling and creating the base reports for the processes coming later.


Proprietary Skills:

  • Data Modeling
  • DB-Development
  • Building Reports&Dashboards


Other Technical Skills:

  • Database
  • ETL
  • SQL
  • Oracle

Special Skills:

  • Requirement Analysis
  • Documentation

Branchen

Branchen

  • Telecommunication
  • Sales
  • Industry

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.