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.
Comelio GmbH was founded in Berlin in 2000. From 2008 to 2015, there were two additional locations: Comelio, Inc. (Miami, FL) and Comelio Business Solutions Pvt Ltd (Chennai, India). In 2022, Comelio Swiss GmbH was founded in Zug (Switzerland) where I now live and work
Project Roles
- Business Intelligence Developer
- Data Warehouse Developer
- Data Analyst
- Data Engineer
- Data Scientist
- Business Analyst
Certifications
- Power BI Data Analyst Associate
- Fabric Analytics Engineer Associate
- Azure AI Fundamentals
- Azure Data Fundamentals
- Trainer
Company
Since 2020 I live in Zug (CH) and work from there or visit you in Switzerland, Liechtenstein, Germany or Austria 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
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 in Azure & Fabric
- Azure Synapse Analytics
- Power BI
- Azure Machine Learning
- OneLake
Reporting
I develop visualization and reporting with:
- Microsoft Power BI
- Microsoft Power BI Report Builder
- 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. JSON follwed in 2013.
- Modeling with XML Schema and JSON 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.
“
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)
Public Administration
“
Integration of banking systems in a DWH for regulatory reports (Kiel)
Reporting for structured financial products (Zurich)
Development of a DWH and reporting solution for risk analysis (Düsseldorf)
Finance
“
Mass production of reports/letters for customers based on XML (Vienna)
Data warehouse/OLAP for statutory health insurance services and billing (Stuttgart)
Database and reporting solution for process analytics (Hannover)
Insurance
“
Self-service BI / reporting system for real estate (Munich)
Project management for an analysis system for industrial buildings and properties (Bochum)
Real estate
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.