Business Intelligence and Analytics
Welcome to my website. I have been working as a developer and trainer for data analysis, data integration and data platforms for 20+ years.
Many years ago, I studied economics at the University of Wuppertal and management at the Sorbonne in Paris and have a degree in economics.
Project Roles
- Business Intelligence Developer
- Data Analyst
- Data Engineer
- Data Scientist
Company
Since 2020 I live in Zug (CH) and work from there or visit you for seminars and projects.
- Comelio Swiss GmbH in 6300 Zug, Switzerland
- Comelio GmbH in 48249 Dülmen, Germany
Databases
I have been developing databases and data warehouse solutions since 2005.
- Microsoft SQL Server and T-SQL
- Oracle DB and PL/SQL
- Snowflake and SnowSQL
Services
- DB Development
- Modelling (3NF, Star Schema, Data Vault)
Data Science
Since 2010 I have been developing solutions for statistics / Data Science and Data Mining.
- Python
- R
- Minitab
- KNIME
Services
- Descriptive and inductive statistics
- DOE and SPC
- Data Mining and Machine Learning
Data Lakes
I develop data analysis platforms and data lakes with Microsoft.
- Microsoft Azure
- Microsoft Fabric
Products
- Data Factory
- Synapse
- Power BI
- Machine Learning
Reporting
I develop visualization and reporting with:
- Microsoft Power BI
- R and Shiny
- Visualization using Python
- Altova StyleVision
Integration
To build data platforms I use for data integration:
- Microsoft Azure / Fabric Data Factory
- Altova MapForce (Server)
- SQL Server Integration Services
- T-SQL, PL/SQL, Python, Apache Spark
XML
I have been using XML technologies since 1999.
- Modeling with XML Schema
- Transformation and presentation with XSLT and XSL-FO
- Altova StyleVision
- Integration in MS SQL Server and Oracle
References
My projects and seminars took me to India and the USA from 2010 to 2015, but now I only travel in the DACH region or occasionally in the EU.
Over the last 10 years, I have participated in projects in which we built data platforms for business intelligence and business analytics or developed reporting solutions.
“
Public Administration
Development of a data warehouse for the analysis and forecasting of tax revenues and tax expenditures (Berlin)
Modeling, data integration and development of a DWH including OLAP for the analysis of labor market data (Vienna)
“
Finance
Integration of banking systems in a DWH for regulatory reports (Kiel)
Reporting for structured financial products (Zurich)
“
Insurance
Mass production of reports/letters for customers based on XML (Vienna)
Data warehouse/OLAP for statutory health insurance services and billing (Stuttgart)
“
Real estate
Self-service BI / reporting system for real estate (Munich)
Project management for an analysis system for industrial buildings and properties (Bochum)
Trainings
Together with Comelio Seminare I have been offering seminars for 15+ years.
- Data Science with Python and R
- Minitab (SPC, DOE)
- MS Fabric
- MS Power BI
- DB-Development using T-SQL and PL/SQL
- XML-Development using XML Schema, XSLT, XSL-FO, Altova MissionKit
Books
My first books in 2000 covered XML and databases. They were published by Rheinwerk (formerly Galileo Computing), Addison Wesley and mitp.
There are also my two- and six-page short references. The 2-page ones were popular in IT training for many years.
I am currently writing for Comelio Medien.
Research
I have participated in various research projects in the field of analysis and AI.
- Building assessment
- Electronic transport marketplaces
- Ontology-based questionnaires
Cooperations with the Munich School of Philosophy, the Free University of Berlin and the Federal Ministry for Economic Affairs and Innovation.