DWH development based on MS SQL Server, data from FIS® Cross-Asset Trading and Risk Platform (formerly Front Arena).
Development in T-SQL and Python (Jinja2 template engine).
Modeling and automation with Data Vault.
Reporting with MS Power BI, training and rollout.
Key technologies and methods: MS SQL Server, Data Vault, UML, T-SQL, Python, FIS Cross-Asset Trading and Risk Platform, MS Power BI.
Project scope: 50-100%.
Aug 2023 - Aug 2024
1 year 1 month
Lindenberg im Allgäu, Germany
MS Power BI Developer, Data Warehouse Developer
Liebherr-Aerospace Lindenberg GmbH
Migrated QlikSense reports to MS Power BI and redeveloped reports following reporting guidelines.
Further developed a DWH in MS SQL Server with SSIS, SSAS, T-SQL.
Visualized and analyzed production, machine and ERP data.
Key technologies: MS SQL Server, Analysis Services Tabular Model (SSAS), MS Power BI, DAX.
Project scope: 25-50% (Detail: 75% part-time).
Jun 2022 - Dec 2023
1 year 7 months
Hanover, Germany
MS Power BI Developer, Oracle Developer
HDI / Talanx AG
Migrated IBM Cognos Report Studio to Microsoft Power BI using Oracle DB as data source.
Developed with Oracle SQL and PL/SQL.
Analyzed data from business processes.
Key technologies: Oracle DB, MS Power BI.
Project scope: 25% (Detail: 25-50% part-time).
Jan 2022 - Present
3 years 7 months
Zug, Switzerland
Managing Director, BI / DWH Developer, Data Analyst, Business Analyst, Data Engineer
Comelio Swiss GmbH
Jun 2021 - Dec 2023
2 years 7 months
Stans, Switzerland
MS Power BI Developer, Data Warehouse Developer
SoftwareOne AG
Replaced existing MS SQL Server Analysis Services OLAP cubes and SSRS reports with an Azure-based solution using SSAS Tabular and MS Power BI, including SQL Server database development and MS Azure Data Factory with Power Query/M for data integration, analysis, and visualization of Microsoft Dynamics CRM data.
Automated processes with MS Power Automate.
Supported migration from SSAS and MS SQL Server to Databricks.
Collaborated continuously with teams in India.
Key technologies: MS SQL Server, SSAS Tabular Model, MS Power BI, DAX, statistics with R.
Project scope: 50-100% (Detail: full-time then 50% part-time).
Jul 2020 - Oct 2020
4 months
Berlin, Germany
XML Consultant
Cornelsen Verlag GmbH
Consulting and development for a digitalization project of schoolbooks.
XML single-source publishing with DITA, oXygen, XSLT and Schematron, technical consulting, quality assurance.
Modeling with BPMN/UML.
Key technologies (table): XML single-source publishing with oXygen, DITA, XSLT, XML Schema/Schematron.
May 2020 - May 2021
1 year 1 month
Munich, Germany
Data Warehouse Developer
E.ON Energie Deutschland GmbH
Further developed and modeled a Data Warehouse solution with Snowflake and SnowSQL.
Data integration with Python/XSLT for contract, customer and market data.
Key technologies: Snowflake DB, SnowSQL, Python/XSLT, MS Power BI.
Project scope: 100% (Detail: full-time then 50% part-time).
May 2020 - Aug 2020
4 months
Berlin, Germany
Web Developer
Comelio GmbH
PHP web development, PostgreSQL, XML integration, XSLT, Bootstrap.
Apr 2020 - Jul 2020
4 months
Mülheim, Germany
Data Integration Specialist, Team Lead
Siemens Gas and Power GmbH
Consulting and development for document management and XML single-source publishing.
XML data integration and transformation with Altova MapForce, XSLT and Python across applications for power plant planning and construction.
Key technologies (table): XML data integration, Altova MapForce, Python.
Jun 2019 - May 2020
1 year
Vienna, Austria
Data Warehousing Specialist
Bundesrechenzentrum GmbH Arbeitsmarktservice
Modeled and developed Data Warehouse with Oracle (legacy) and MS SQL Server for labor market data using Data Vault modeling.
T-SQL and MDX programming and SSAS for OLAP.
Automation and modeling with WhereScape Red and WhereScape 3D.
Modeled, designed and developed a self-service BI platform based on MS SQL Server 2017 Azure (Azure Data Lake, Azure Data Factory) and MS Power BI.
Modeled with SSAS Tabular Model and DAX, and used R and Shiny for visualization and forecasting for marketing analyses in real estate and market data.
Replaced T-SQL and MDX calculations in SSAS with DAX.
Key technologies: MS SQL Server, MS Power BI, DAX, T-SQL and R, Azure Data Lake/Data Factory.
Project scope: 50%.
Apr 2018 - May 2019
1 year 2 months
Munich, Germany
Data Integration Specialist
Loyalty Partner GmbH (PayBack)
Developed configurable data integration solutions with SSIS and T-SQL for Navision on MS SQL Server 2014 for billing with PayBack partners and for the data warehouse.
Key technologies: MS SQL Server, T-SQL, SSIS, ETL.
Project scope: 50%.
May 2016 - Apr 2018
2 years
Kiel, Germany
Data Warehousing Specialist
HSH Nordbank AG
Data Vault modeling, created interfaces with Talend and added Java/PL/SQL Apex programming to various banking systems to build a central data platform for statistical analysis of customers, deals, risks, payments and regulatory reporting.
Documented domain-specific language for automatic generation of Data Vault structures in an Oracle Enterprise Data Warehouse with SQL, PL/SQL, Java, Xtext.
Analyzed and recommended improvements for throughput and query performance.
Key technologies: Oracle DB, PL/SQL and Apex, Java, ETL, Data Vault.
Project scope: 100%.
Jan 2016 - Apr 2016
4 months
Hamburg, Germany
Business Intelligence Specialist, Data Warehousing Specialist
Toolport GmbH
Modeled and built a Data Warehouse for e-commerce and marketing analyses.
Designed, consulted and executed with MS SQL Server using Data Vault, and developed OLAP cubes with SSAS.
Data integration and quality control via SSIS and reporting with SSRS and Power BI.
Extended and displayed in R/Shiny for forecasting/segmentation.
Time series analysis, regression and cluster analysis.
Project management: SCRUM, Jira.
Key technologies: MS SQL Server, SSAS, SSIS, SSRS, MS Power BI/Shiny, Data Vault, Data Warehousing, T-SQL, R.
Project scope: 100%.
Jan 2015 - Dec 2015
1 year
Paris, France
Data Science Specialist
Atradius Credit Insurance N.V.
Analytics system for global market and financial data, including data integration, regression models, classification and time series analysis for credit insurance.
Consulting and coaching for data acquisition, interface definition and data quality.
MS SQL Server, T-SQL, OLAP and data mining with SSAS and SSIS.
Oracle, PL/SQL programming.
Developed statistical models for default probability using Naive Bayes, Bayesian networks, neural networks, logistic regression, R programming, data mining in MS SQL Server and Oracle, visualization in R/Shiny.
XSLT, XML Schema, Altova MapForce and SSIS for data integration, quality and transformation.
Key technologies (table): MS SQL Server/T-SQL, Oracle DB/PL/SQL, R and data mining.
Mar 2014 - Feb 2016
2 years
Vienna, Austria
Team Lead, Reporting Specialist
Österreichische Beamtenversicherung ÖBV
Automatic generation of 500+ PDF documents and reports from a Data Warehouse with customer and claims data and XML interfaces.
Project management including tech consulting, data modeling, coaching.
Oracle DB, PL/SQL, XSLT, XML Schema, Altova StyleVision for presentation and Talend for data integration.
Bundesministerium für Wirtschaft und Innovation Hochschule für Philosophie München
Ontology-based survey system for multidimensional and interactive questionnaires.
Integrated standard analyses (descriptive stats, tests, correlation) and multivariate methods like regression, MDS, clustering.
Overall project lead (with Comelio GmbH).
Technologies used (detail): MS SQL Server, .NET, OWL, XSLT, XSL-FO.
Key technologies (table): ontology-based survey, Oracle, PL/SQL, Java, OWL, R and data mining, XML Schema/Schematron.
Jan 2012 - Dec 2012
1 year
Munich, Germany
Reporting Specialist, Team Lead
Logit Management Consulting GmbH
Multilingual analysis system for employee surveys with up to 400M records per survey.
Dynamic report generation and team-level analysis with up to 10,000 individual PowerPoint reports including correlation, clustering, discriminant analysis, logistic and other regressions.
Technical project lead for software/DB dev, data analysis, quality, integrity.
Sub-project lead.
Software used: MS SQL Server (SSIS, SSRS, SSAS), .NET, VBA, XML Schema.
Key technologies (table): MS SQL Server, SSRS, C#, VBA, T-SQL.
Jan 2011 - Dec 2012
2 years
Berlin, Germany
Data Science Specialist, Team Lead
Gesellschaft für Konsumforschung (GfK) GmbH Coca Cola AG
Interactive analysis system with complex retail product placement calculations (for Coca Cola).
Mobile survey for ~600 people to capture in-store product placements.
Technical project lead for software/DB dev, data analysis and quality.
Software used: MS SQL Server (SSIS, SSRS, SSAS), MS Access, VBA, .NET.
Key technologies (table): MS SQL Server, SSAS, SSIS, SSRS, Data Warehousing, T-SQL.
Jan 2011 - Dec 2011
1 year
Stuttgart, Germany
Business Intelligence Specialist, Team Lead
AOK Baden-Württemberg
Data Warehouse for insurance claims, including modules for online reporting, forecasting and fraud detection plus data integration/quality.
Technical project lead and coaching for software/DB dev, data analysis.
Software used: MS SQL Server (SSIS, SSRS, SSAS), .NET.
Key technologies (table for AOK AG): MS SQL Server, SSAS, SSIS, SSRS, MDX, DMX, T-SQL.
Jan 2010 - Dec 2015
6 years
Chennai, India
BI / DWH Developer, Data Analyst, Business Analyst, Data Engineer
Comelio Business Solutions, Pvt. Ltd
Jan 2010 - Dec 2013
4 years
Miami, United States
BI / DWH Developer, Data Analyst, Business Analyst, Data Engineer
Comelio, Inc.
Jan 2010 - Dec 2011
2 years
Business Intelligence Specialist, Team Lead
Santander Consumer Bank AG
Key technologies: Oracle DB, Oracle OLAP, PL/SQL.
Jan 2008 - Dec 2009
2 years
Berlin, Germany
Business Intelligence Specialist, Data Integration Specialist, Team Lead
Deutscher Bundesrat
Data Warehouse with interactive reporting and complex data integration for state budgets.
Time series analysis and forecasting.
Project lead with DB/software dev and data analysis, quality.
Software used: MS SQL Server (SSIS, SSRS, SSAS), T-SQL, .NET, VBA, XML, OWL.