image Burghardt Benz 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
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

Good knowledge in SAP FI, CO & MM
Good knowledge in Oracle eBS AtF und ItF

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
  • 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
IndustryFinancial Services
Location / languageFrankfurt am Main / german
Task / responsabilityDWH/BI Architecture and ETL implementation
Used toolsOracle 11g, Microsoft SQL Server, SSIS & SSAS
03/2021 - current & 08/2010 - 03/2019 Business Analysis and Dataloading project SIMS
IndustryFinancial Services
Location / languageFrankfurt am Main / german - english
Task / responsabilityDWH Coach, Business Analyst, DWH/BI Architect (incl. Data Vault 2.0)
Used toolsCognos 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.
Location / languageHamburg / german
Task / responsabilityProjectmanager, Business Analyst
Used toolsCognos Series 7, Cognos 8, DB2
09/2009 - 07/2010
(Engagement 50%)
Projectmanagement „Sales and Costreporting“with special requirement RealTime Data Warehousing.
Location / languageHamburg / german
Task / responsabilityProjektmanager, Business Analyst
Used toolsInformatica PowerCenter 8.6, Cognos 8, ERWin, Oracle
12/2007 - 08/2009 Project „MIS“ Flexible profit and loss statement and Customer segmentation report.
IndustryFashion / Retail
Location / languageHaibach / german
Task / responsabilityData Warehouse Architect, Business Analyst and Data Warehouse Coach
Used toolsCognos Data Manager, Cognos 8, DB2
11/2007 - 07/2008 Modelling and Implementing of an global used Balanced Scorecard System
IndustryAutomotive / Finance
Location / languageStuttgart, Berlin / german - english
Task / responsabilityRequirements engeneering / Documentation, Planning and Design, Projectmanager
Used toolsIBM 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].
Location / languageForchheim / english
Task / responsabilityData Warehouse Architect, Business Analyst and Data Warehouse Coach
Used toolsCognos 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.
Location / languageStuttgart / english
Task / responsabilityData Warehouse Architect, Business Analyst and Data Warehouse Coach
Used toolsInformatica PowerCenter
01/2004 - 06/2005 Data Warehouse for analysing the portfolio of a Car-Leasing company.
IndustryAutomotive / Financial Services
Location / languageRome – Italy / english
Task / responsabilityExterner Projectmanager, Business Analyst and Data Warehouse Coach
Used toolsCognos DecisionStream, Cognos ReportNet
02/2003 - 12/2003 Project PACE - Data Warehouse for analysing customer profability
Location / languageWiesbaden / english
Task / responsabilityProjectmanger, Business Analyst and Data Warehouse Coach
Used toolsInformatica PowerCenter, Cognos Series7
02/2002 - 01/2003 Modelling Data Warehouse for workers' compensation board
Location / languageMannheim / german
Task / responsabilityRequirements engeneering and Data Warehouse Modelling
Used toolsMID Innovator, Ascential DataStage
04/2001 - 12/2002 Integration Data Mart „Inventory Management“ to existing Data Warehouse
Location / languageDüsseldorf / german
Task / responsabilityDesign und Modelling
Used toolsCognos DecisionStream, Cognos Series6