Age group 1973 | graduate in business administration | Data Warehouse and Business Intelligence expertise since 1999 |

My mission - Data Warehouse and Business Intelligence. I can say that with full conviction and a clear conscience, because I was able to collect almost 20 years of experience in these areas and have worked with a wide variety of tools in a wide variety of industries.

The architecture and data modelling of BI systems and data warehouses were and are the focus. Detailed business analyzes and technical knowledge of data management and reporting round off my service portfolio.

Methodology	ModellingData Vault 2.0 3NF Star Schema
IT-Knowledge	BI and DWH Tools Expert for Cognos Series7 / Cognos 8, 10 & 11 Expert for Cognos DataManager Very good knowledge in Informatica PowerCenter 8.x Very good knowledge in Microsoft SSIS, SSAS and PowerBI Knowledge in SAP BW ERP Good knowledge in SAP FI, CO & MM Good knowledge in Oracle eBS AtF und ItF Datenbanken Expert for Oracle [SQL & PL/SQL] Expert for Microsoft SQL Server [SQL & Transact-SQL] Good knowledge for IBM DB2
Foreign languages	Englisch fluent in written and spoken

08/2010 - current	Freelance expert for DWH and BI Key tasks: Project planning and koordination Architecture Data modelling ETL implementation Business Intelligence modelling Business Intelligence reporting
12/2002 - 07/2010	Business Unit Manager Information Management objective partner AG, Weinheim Key tasks: Defining Business Case for Business Unit Sales and marketing Project akquisition Project planning und -management Project staffing Employee selection Teammanager for 15 employees Responsability Sales and aquisition Team growth
12/1999 - 11/2002	Consultant Information Management objective partner AG, Weinheim Consulting and implemantion for Business Intelligence and Data Warehouse

06/2018 - current & 03/2011 - 12/2014	Business Analysis, designing and implemanting in project DekaDiVA Industry Financial Services Location / language Frankfurt am Main / german Task / responsability DWH/BI Architecture and ETL implementation Used tools Oracle 11g, Microsoft SQL Server, SSIS & SSAS
03/2021 - current & 08/2010 - 03/2019	Business Analysis and Dataloading project SIMS Industry Financial Services Location / language Frankfurt am Main / german - english Task / responsability DWH Coach, Business Analyst, DWH/BI Architect (incl. Data Vault 2.0) Used tools Cognos 8/10 & 11, Oracle 11g, PL/SQL & Informatica PowerCenter
09/2009 - 07/2010 (Engagement 50%)	Projectmanagement „Migration to Cognos 8“ within the topics commission controlling, asset development und customer value. Industry Insurance Location / language Hamburg / german Task / responsability Projectmanager, Business Analyst Used tools Cognos Series 7, Cognos 8, DB2
09/2009 - 07/2010 (Engagement 50%)	Projectmanagement „Sales and Costreporting“with special requirement RealTime Data Warehousing. Industry Pharma Location / language Hamburg / german Task / responsability Projektmanager, Business Analyst Used tools Informatica PowerCenter 8.6, Cognos 8, ERWin, Oracle
12/2007 - 08/2009	Project „MIS“ Flexible profit and loss statement and Customer segmentation report. Industry Fashion / Retail Location / language Haibach / german Task / responsability Data Warehouse Architect, Business Analyst and Data Warehouse Coach Used tools Cognos Data Manager, Cognos 8, DB2
11/2007 - 07/2008	Modelling and Implementing of an global used Balanced Scorecard System Industry Automotive / Finance Location / language Stuttgart, Berlin / german - english Task / responsability Requirements engeneering / Documentation, Planning and Design, Projectmanager Used tools IBM Cognos 8 (Metric Studio), Oracle, Informatica PowerCenter 7
09/2006 - 11/2007	Coaching Data Warehouse within the context of the global project „HERO“ [introducing ERP Systems von Oracle eBS]. Industry Packaging Location / language Forchheim / english Task / responsability Data Warehouse Architect, Business Analyst and Data Warehouse Coach Used tools Cognos Decision Stream, Cognos ReportNet, Oracle 9
01/2006 - 08/2006	Consulting for CPM Suite Cognos8. Installation und Configuration Migration Cognos S7 to Cognos ReportNet Creating operational concepts Providing Proof of Concepts
06/2005 - 12/2005	Sales Data Warehouse for an automotive supplier. Industry Automotive Location / language Stuttgart / english Task / responsability Data Warehouse Architect, Business Analyst and Data Warehouse Coach Used tools Informatica PowerCenter
01/2004 - 06/2005	Data Warehouse for analysing the portfolio of a Car-Leasing company. Industry Automotive / Financial Services Location / language Rome – Italy / english Task / responsability Externer Projectmanager, Business Analyst and Data Warehouse Coach Used tools Cognos DecisionStream, Cognos ReportNet
02/2003 - 12/2003	Project PACE - Data Warehouse for analysing customer profability Industry Pharma Location / language Wiesbaden / english Task / responsability Projectmanger, Business Analyst and Data Warehouse Coach Used tools Informatica PowerCenter, Cognos Series7
02/2002 - 01/2003	Modelling Data Warehouse for workers' compensation board Industry Public Location / language Mannheim / german Task / responsability Requirements engeneering and Data Warehouse Modelling Used tools MID Innovator, Ascential DataStage
04/2001 - 12/2002	Integration Data Mart „Inventory Management“ to existing Data Warehouse Industry Chemie Location / language Düsseldorf / german Task / responsability Design und Modelling Used tools Cognos DecisionStream, Cognos Series6