Business Intelligence, ETL, Projektmanagement, Business Analyst, Datawarehouse(DWH) Analysis, Reporting, Statistik und IT-Trainer, Six Sigma Black Belt, IT-Development, Consulting, Pentaho

Welcome to my profile



Education and Training

1990 – 1997 University of Applied Sciences Flensburg. Study of Mathematics

 - Excellent diploma: “The application of Johnson’s transformation systems in statistical quality control”

1998  Degree in applied Mathematics

1999 co-author on published articles
-        “Calculation of process capability indices for non-normal distributed data, at Arbeiten aus dem Institut für Statistik und Ökonometrie der Universität Kiel,”
-        “Nonnormal Quality, in Qualität und Zuverlässigkeit Nr. 4“.

2000 Certified Clarify Consultant (by Nortel Networks)

2003 Certified Six Sigma Black Belt (by Motorola University)

2008 Certified ITIL v3 Foundation (by APM Group)


Summary
I already started working as an IT developer and statistical data analyst during my studies of applied mathematics strongly focussed on IT and economics 14 years ago. After some years of IT development and statistical data analysis I became interested in the people behind the front-ends/reports and decided to work as an IT consultant.
Combining IT development, statistical data analysis and consultancy experience I was lucky to be able riding the wave of the Business Intelligence hype at start of the century. This led me to some DWH and business analysis  projects as an analyst and developer. At the same time I started my first steps in the continuous improvement and change management area as a trainer and consultant for Six Sigma.
Working close to internal and external customers during my consultancy, analyst and trainer jobs, I soon realised that meeting customer requirements - by simply listening to their needs before developing by guess - is the most effective way to deploy (IT) service changes. So I started working in the field of project management …
…. combining my IT development, statistical data analysis, consultancy, trainer and project management experience doesn't make me a SME in all fields !
I’m a guy with a pragmatic hands-on mentality and a holistic approach who is able to either be part of a team or else lead a project without being lost when talking to technical or business stakeholders in a wide range of industries.
Enjoy life!




Projects Overview

•        Project Management and Team Leadership
•        Statistical data analysis
•        Process improvement via Six Sigma
•        Business-/Datawarehouse Analysis und Implementation
•        IT-support/consulting for a Business Intelligence solution
•        IT-support/consulting for a customised CRM application
•        Five waves of Six Sigma Black Belt candidates co/trained and coached
•        Four waves of Six Sigma Green Belt candidates co/trained and coached
•        Design, development and delivering of statistical training’s
•        Design, development and delivering statistical software
•        Design, development and delivering training for an IT-Helpdesk department
•        Design, development and delivering web–strategies and web based  e-learning strategy
•        Functional consulting in a wide range of industries
•        …




Software Experience ( tools used in projects )

•        MS-Office + other MS-Applications
•        MS Windows xxx, Linux, OS/2, BS 2000
•        MySQL, Oracle, STN
•        SQL, C, Perl, PHP, SAS (Base, AF, Graph, Makro)
•        CGI, HTML
•        Clarify
•        Minitab, SAS/JMP, SPSS
•        Pentaho Toolset
•        SAP PLM
•        …



Data Analysis

•        DMAIC, Project Planning,
•        Cause & Effect
•        Process Mapping
•        Hypothesis testing
•        ANOVA
•        Measurement System Analysis
•        Statistical Process Control
•        Time Series Analysis
•        Categorical Data Analysis
•        DOE
•        Multivariate Analysis
•        Cluster analysis
•        …



Project details

---

2003– up to date   ~15 days/year lectures/trainings at universities
Project lead  --- lectures/trainings for statistical data analysis

Intro to statistical data analysis for students and doctoral candidates with various software packages

Tools: SAS/JMP, Minitab, Six Sigma Toolset, MS Excel, MS PowerPoint

---

2008 Sept. – July 2009  currency automation systems company
Team member (SME)  --- statistical feasibility study and BI/DWH implementation

Conducting a feasibility study to prove if the basic assumptions and sufficient data for reliability statistics can be achieved and setup reporting framework from scratch.

•        Functional consulting at development of requirement profiles of specialist areas
•        Workshops and presentations
•        Implementing a BI solution based on a DWH via a open source tools. (backend/DB design, ETL steps, reporting, frontend design, development of statistical routines, SQL )
•        Statistical data analysis

Tools: MS Excel, MS Access, MS PowerPoint, Pentaho, MySQL, SAP PLM , Oracle

---

2008 May – Aug. 2008   internal & formation of a market research company
Partner  --- project management, training development

Developing a framework for Lean Six Sigma trainings and define research outline.

•        Design Six Sigma and Lean trainings
•        Workshops and presentations

Tools: MS Excel, MS PowerPoint, MySQL, Perl, Minitab, SAS/JMP, SPSS

---

2007 Sept. – April 2008 internal & formation of a consulting company
Partner  --- conduct meta study, DWH outline

Conducting a feasibility study to build an intellectual property (IP) DWH  to provide asset management companies with insights concerning IP activities related to financial market performance.

•        Workshops and presentations
•        Statistical data analysis
•        DWH outline

Tools: MS Excel, MS PowerPoint, MySQL, Perl, Minitab

---

2007 Febr. – Oct. 2007 Telecommunication  Carrier
Team member  --- project management, KPI Analysis

The customer intends to implement a KPI system to relate a gratification system on team performance as a Six Sigma project.

•        Additional to project management the goal is to support the Six Sigma methodologies and application of corresponding tools
•        Functional consulting at development of requirement profiles of specialist areas
•        Workshops and presentations
•        Statistical data analysis

Tools: MS Project, MS Excel, MS Access, MS PowerPoint, MySQL, PHP, Six Sigma Toolset, Minitab

---

2006 Nov. – Jan.  2007 Communications  company
Team member  --- supporting order fulfilment process

Foreign to my usual work, I a agreed on a temporarily substitute for a ”long term disability leave” of a team member from predecessor project in a line position. Acting as customer interface to support solutions to ad hoc customer issues and improve existing processes in the order fulfilment environment.

Tools: MS Excel, MS PowerPoint, RosettaNet

---

2006 June – Oct. 2006 Communications  company & Telecommunication  Carrier
Project manager

The customer intends to setup a pilot for a VMI solution to strengthen the CPFR effort with the customer.

•        Functional consulting at development of requirement profiles of specialist areas
•        Workshops and presentations

Tools: MS Project, MS Excel, MS Visio, MS PowerPoint, RosettaNet

---

2005 Sept. – May 2006       Energy Company
Lead Project --- project management, Data warehouse Analysis and Reporting

Confidential project so just outlines:
The customer intends to report energy consumption data at optimal tax conditions.

•        Functional consulting at development of requirement profiles of specialist areas
•        Interrogate and aggregate large amounts of data from DWH with SQL
•        Interpretation and presentation of the findings
•        Statistical data analysis

Tools: MS Excel, MS Access, MS PowerPoint, MySQL, Perl, Minitab, Sharepoint

---

2005 April – May 2006        e-Commerce/Bank &   formation of a consulting company
Lead Project --- project management, Development, Analysis and Reporting

Confidential project so just outlines:
The customer intends to operate an internet platform to perform a scoring on special customer segments.

•        Functional consulting at development of requirement profiles of specialist areas
•        Development of the concept
•        Programming of cgi scripts
•        Interrogate and aggregate data from DB with SQL
•        Interpretation and presentation of the findings
•        Statistical data analysis

Tools: MS Excel, MS Access, MS PowerPoint, MySQL, Perl, Minitab, SAS/JMP

---

2004 Sept.  – Mar. 2005 Telecommunication carrier
Team member --- Business-/Datawarehouse AdHoc-Analysis

•        Specify requirements with internal customer
•        Interrogate and aggregate large amounts of data from DWH with SQL
•        Process extracted data in MS-Excel
•        Interpretation and presentation of the findings
•        i.e. customer and financial data (Revenue, Churn, ARPU, Retention, Usage, …….. )
•        Statistical data analysis

Tools: MS Excel, MS PowerPoint, Oracle, TOAD, Crystal Reports, SPSS

---

2002–2004         --- follw. ~10 days/month ‘til 2005 Bank
Lead Project --- Consulting, Design, Development

Confidential project so just outlines:
The customer intends to market an innovative idea concerning the assessment value of companies.

•        Functional consulting for development of requirement profiles of specialist areas
•        Data management and data import from different sources. Examination of the data integrity. Data dimensioning and data aggregation
•        Statistical model fit and analysis with presentation
•        Data modeling for the database
•        Statistical data analysis

Tools: MS Excel, MS PowerPoint, MySQL, Perl, Minitab, SAS/JMP, STN

---

2002     --- 1 month (project stopped) Dispatch department
Lead Project --- Consulting, Design

 

The customer uses a very inaccurate planning tool. The arising cost/losses by i.e. storage of wrongly bought commodity are very high. The large quantity of different articles (several 10,000) is to be summarised in 10-15 groups concerning the number of sold articles per day, starting from distribution of the respective advertising medium. Furthermore the effects of the placements in the advertising medium are to be examined. The resulting models and realisations are to predict the sales figures in a program to be developed, in order to support the purchase.

•        Functional consulting for development of requirement profiles of specialist areas
•        Preparation of statistic contents for the Kickoff Meeting
•        Data modelling for the database and data mining tool
•        Statistical data analysis

Tools: MS Excel, MS PowerPoint, MySQL

---

2002     --- 6 month          Building material manufacturer
Team member --- Consulting, Development

The customer uses several hundred Excel sheets for the site controlling. The users are given rigid reports for their daily work.

•        This reporting as well as the data retention and preparation now are to be replaced and in some subranges to be extended by a Datawarehouse solution. The requirements to the new reporting are user satisfaction, flexibility, expandability and maintenance ability. Furthermore the application is to be web based, in order to always have current reports firmspreadingly available.
•        Functional consulting for development of requirement profiles of specialist areas.
•        Design and development of reports within the specialist areas.
•        Data management including the data import from source systems, examination of data integrity.
•        Data dimensioning und data aggregation.
•        Co-operation with the production of reports (form layout).

Tools: MS Excel, MS Access, MS PowerPoint, MySQL, Perl, PHP

---

2001     --- 7 month  Oil company
Team member --- Consulting, Development

The customer uses an application of MS-Access for controlling of their gas stations both for the indoor service and for the field service. This is a single place application under Windows/NT. The users get rigid reports for their daily reporting work. For the order this reporting as well as the data storage and evaluations is now to be replaced and in some subranges extended by a SAS solution. The requirements of the new reporting are user satisfaction, flexibility, expandability and maintenance ability. The centre of attention is not only the solution for the indoor service but also the binding to the field service (contentwise and technical).

•        Functional consulting at development of requirement profiles of specialist areas.
•        Design and development the report with the specialist area
•        Data management including the data import from the source systems, examination of the data integrity. Data dimensioning und data aggregation.
•        Co-operation with the production of reports (form layout).
•        Development of a demo report to predict sales figures.

Tools: MS Excel, MS PowerPoint, SAS, SAP, Oracle

---

2000/2001         --- 8 Month Telecommunication company
Subproject lead & Team member --- Training, Coaching, Consulting, Development

The customer uses a self-developed software for the CRM, consisting of several tools, using this software for both, backoffice and frontoffice (in particular in call centers and customer centers). This heterogeneous software collection now is to be replaced by a fully professional CRM Tool (Clarify).

•        Functional consulting at development of requirement profiles of the specialist areas, in the subproject CCI (workshops and presentation of Clarify).
•        Development of application forms (layout); development of functionality behind the forms with ClearBasic
•        Development of test scenarios.
•        Development of training course documents and execution
-        of the master trainer training course
-        of the final user training course
-        of the Helpdesk training course
•        Supervision of the IT specialist area and the Helpdesk during pilot phase.

Tools: MS Excel, MS PowerPoint, Clarify, Oracle, TOAD

---

2000     --- 8 Month follw. ~5 days/year ‘til 2004 eCommerce & formation of consulting company
Lead Project --- Design Development

The customer intends to operate an internet platform. The goal is to deal political parties like shares in order to achieve current forecasts at any time by direction tendencies. This procedure is then intended to be used for market and public opinion polls.

•        Functional consulting at development of requirement profiles of specialist areas
•        Development of the concept
•        Co-operation with the design of the data base
•        Programming of cgi scripts
•        Development and layout of HTML sides
•        Statistical data analysis

Tools: MS Excel, MS PowerPoint, MySQL, Perl, SAS/JMP

---

1999-2004         ---  approx. 60 days per year Communications company
Lead Project & Team member --- project management, Training, Coaching, Consulting, Development

•        Delivery of Six Sigma Training focussed on applied statistics with subsequently coaching and
mentoring:
-        Green Belt Training (4 classes conducted)
-        Black Belt Training (5 classes conducted )
•        Functional consulting at the development of requirement profiles of the specialist areas.
•        Coaching Black Belts and Green Belt to meet their goals.
•        Development of course for measurement system analysis.
•        Consulting and Development in case of statistical software solutions.
•        Statistical data analysis

Tools: MS Excel, MS PowerPoint, Minitab, SAS/JMP, Six Sigma Toolset

---

1999     --- 6 Month Beverage industry
Lead Project --- Consulting, Design, Development

The customer wants to use the latest methods to accomplish the existing statistic process control. Due to the database conventional methods do not supply reliable results. As solution the implementation of a statistics tool is to serve for transforming and evaluation of the data. Furthermore the new application should be internet based.

•        Functional consulting at development of requirement profiles of specialist areas.
•        Analysis of the existing it-infrastructure and server.
•        Testing of functionality and stability of this server.
•        Development of the statistic transformation software (self-development in C). Development of cgi scripts.
•        Design layout of HTML.
•        Presentation
•        Statistical data analysis

Tools: MS Excel, MS PowerPoint, MySQL, Perl, SAS/JMP

---

1999     --- 3 Month Publisher
Lead Project --- Design Development 

The customer wants to examine old customers concerning crosselling potential. This analysis is build on the data of the existing customers. It is to be examined whether weekly forecasts of the sales figures are possible.

•        Development of the ETL (Extract Transform Load) step;
Data analysis and preparation for the statistics tool.
•        Fitting models and choosing the best  transformation of the data. Comparison of the results by a self-developed program.

Tools: MS Excel, MS PowerPoint, MySQL, Perl

---

1997/1998         --- 8 Month Insurance
Subprojectlead &Team member --- Design Development

The customer is in the situation to supply and train the salesforce, in particular the field service, with the most current information. Beside the delivery reception of these information must be ensured. The conventional procedure (dispatch of CDs) is to be replaced by a central administered information pool. This info pool is also to be used as training media. Those solution consists of the development of a WBT application (web based training) in relation of an e-Learning-strategy (hardware and software)

•        Functional consulting at development of requirement profiles of specialist areas
•        Development of the concept
•        Co-operation with the selection of the hardware
•        Co-operation with that Design of the data base
•        Programming of cgi scripts
•        Design and layout of website
•        Presentations

Tools: mSQL, Perl

---

1994/1995         --- 12 Month Construction industry
Team member       

The customer operates a large-scale building site for the establishment of a holiday park. For flow control the  construction supervisors report directly to the management. These status reports are to be co-ordinated and examined by a responsible person and then to be reported to the management.

•        Co-ordination of the construction supervisors of the German, Netherlands and British companies involved for the in time completion of individual building phases.
•        Controlling and presentation of the current situation for the management with a critical path method.

Tools: proprietary software

---

1994     --- 6 Month IT company
Team member --- Development         

The customer is a system house and sells its own software for the quality management. In order to be independent, an own compiler was developed, to integrate programs for data acquisition of measuring instruments. It is necessary to change all past programs to the language

•        Development of software with a company developed compiler for quality management applications.
•        Statistical data analysis

Tools: C, proprietary DB

---

1990-1998         ---  8 Years University of appplied science
Student --- learning and development         

Study of applied mathematics with majors in financial mathematics, statistics and programming

Tools: SAS, SPSS, Pascal, C, Fortran, TeX/LaTeX,