Manager & Tech Lead | Senior Consultant

• Feb 2022 - Present

Creating next-gen data analytics solutions with Azure Databricks Delta Lake and Apache Spark. Creating next-gen data analytics solutions with Azure Databricks Delta Lake and Apache Spark.

Senior Business Intelligence Engineer

• Mar 2021 - Jan 2022

Backend Product Owner in agile project to implement new group-wide analytics platform. Responsible for solution architecture, requirements analysis, and data warehouse and interface design. Meta data driven automation and implementation of CI/CD process. Coordination of unit and integration testing. Backend Product Owner in agile project to implement new group-wide analytics platform. Responsible for solution architecture, requirements analysis, and data warehouse and interface design. Meta data driven automation and implementation of CI/CD process. Coordination of unit and integration testing.

Senior Consultant BI & Data Management

• Aug 2017 - Feb 2021

Developer of a data warehousing automation suite in a five-person team. Automated generation of SQL code through T4 templates and XSLT, automated generation of ETL processes through BIML. The suite allows fully automated generation and loading of a data warehouse on the basis of metadata. Development of a highly scalable multi-terabyte data warehouse with large 1+ billion rows tables, automated generation of SSIS packages with BIML, optimization of ETL load duration by implementing a highly parallel architecture. Great reduction of the ETL load duration by replacing poorly maintainable SSIS packages with highly optimized SQL procedures. Development of dimensional data models for business specific data marts. Modeling, partitioning and performance optimization of large multidimensional OLAP cubes. Development of complex business logic in SQL and MDX. Creation of dashboards in Pyramid Analytics. Setup of Microsoft Azure infrastructure including Azure Data Factory and Integration Runtime. Preparation and execution of customer workshops to create technical concepts for new BI initiatives. Project manager of several customer projects focused on Data Warehouse and Business Intelligence. Responsible for project coordination, budget control, software architecture, requirements analysis and data modeling. Lead developer of the central ERP software for QUNIS with the features time recording, travel expenses, budget control, project control and invoice generation.

Consultant Business Intelligence

• Jul 2014 - Jul 2017

Decreased report creation effort by 600% through extracting data from 30+ internal and external sources with highly automated C# enriched SSIS and building a 1+ TB data warehouse at a worldwide operating B2B company. Designed Data Vault data model and developed an auditable and resilient data warehouse to meet the strict regulations of Switzerland for the World Economic Forum, Geneva. Reduced data warehouse storage size by 95% and ETL duration by 60% through designing a highly effective data model and optimizing query performance and data storage at a leading local construction firm. Lead developer in modeling and implementing a 500 GB Data Vault data warehouse with 950 tables and 350 stored procedures. Connected 50+ disparate sources and built a DataMart serving over 30 QlikView reports. Built 1-Click CEO dashboard, close interaction with business functions to analyze requirements. Extracted, nurtured and transformed data from numerous source systems and files with SSIS. Oracle data warehouse modeling in 3NF/Inmon and Star/Kimball with Enterprise Architect, development of ETL stored procedures with Oracle SQL Developer and optimizing query performance.

Consultant Business Intelligence

• Jan 2014 - Jun 2014

Conducted in-depth research on social sentiment analysis, reported directly to the Division Manager. Created SSRS reports and PHP/ASP dashboard to visualize data and allow ad-hoc analysis. Interaction with business function to analyze requirements. Built data extraction process, created data model and designed report to identify future business actions for DB Schenker, Frankfurt. Taught SQL and data modeling to associate consultant coworkers. Conducted in-depth research on social sentiment analysis, reported directly to the Division Manager. Created SSRS reports and PHP/ASP dashboard to visualize data and allow ad-hoc analysis. Interaction with business function to analyze requirements. Built data extraction process, created data model and designed report to identify future business actions for DB Schenker, Frankfurt. Taught SQL and data modeling to associate consultant coworkers.

Gap Year

• Oct 2012 - Dec 2013

Career break to expand my English language and social skills, experience a different culture and work on personal improvement. Worked on a dairy farm for five months. Career break to expand my English language and social skills, experience a different culture and work on personal improvement. Worked on a dairy farm for five months.

Software Developer

• Jan 2011 - Sep 2012

Drastically reduced fraud detection response time by developing a C# application to help Trading Surveillance employees an-alyze the market in an unprecedented level of detail.Decreased duration of data extraction, transformation and storage of 1+ billion rows of stock data per day by 45% through SQL query optimization and parallel loading. Implemented 10-second historization process with SQL Server partitioning.Lead Developer of a six-person team in a collaborative project to develop and provide a new innovative trading surveillance system with C# for four other German stock exchanges.Detailed analysis of stock market data with SQL to investigate anomalies and abnormalities, direct report to Head of Trading Surveillance. Development of predictive analytics methods.Generated data-driven insights and reports to allow new and conclusive ways to improve the fight against fraud. Assisted gathering required data to bring cases to court.Improved software testing quality and speed by developing an automated test data generator (Bachelor thesis).

Application Manager

• Aug 2007 - Dec 2010

Crystal Reports development and dashboard design.Implementation and further development of the service management software helpLine (C#).Implementation of interfaces with SQL Server Integration Services (SSIS).Further development of the CRM solution (Java).Development of a software inventory tool (PHP, MySQL).Development of scripts to automate recurring tasks (Windows Powershell, Batch).Monitoring of system critical stock exchange trading systems.

IT Helpdesk Engineer

• Nov 2005 - Jul 2007

Vocational training as IT specialist

• Sep 2001 - Oct 2005