Projects

Business Intelligence

BI systems, reporting, dashboards and analytical foundations for decisions.

Data Engineering

ETL, data modelling, performance optimization and stable data processes.

Data Strategy

Strategic development of data-driven companies and platform architectures.

Project Management

Coordination between business units, development teams and management.

01 Current focus areas

Strategic projects & platforms

Enterprise commerce - DWH & BI

Development, ownership and continuous improvement of an enterprise-wide DWH and BI system based on the Microsoft SQL Server stack. Integration of new data sources, standardization of data models, data-quality checks, performance optimization as well as Power BI and SSAS Tabular Cubes as the analytical basis.

MSSQL Server, Azure SQL, SSIS, SSAS Tabular, Power BI, Excel, Azure ML, Python

Technology group - Data Hub

Project support for a central data hub integrating diverse data sources of an international technology group. Focus on harmonized data storage, central platform logic, application integration and operation of data-driven applications.

Data Hub, data integration, data architecture, application logic

02 Project archive

Further projects

Manufacturing company - shop-floor analytics

Development of a data warehouse system to optimize production KPIs and throughput times. Power BI dashboards for real-time monitoring, integration of production data and automation of throughput-time analysis.

Microsoft SQL Server, Power BI, SSAS

Online training company - analytics & lead management

Data warehouse for holistic analysis of online trainings, participant performance, lead tracking, conversion analyses and automated KPI monitoring.

Microsoft SQL Server, Power BI, CRM integration, SSAS

Food retail - enterprise BI

Further development and operation of an enterprise-wide DWH and BI solution for a large German supermarket chain. Work with very large data volumes, ETL development, procedures, cube adjustments and reporting.

Microsoft PDW/APS, MSSQL Server, SSIS, SSAS, Reporting Services, C#

International organization - emissions reporting

Assessment of the business intelligence environment for emissions reporting under the Kyoto Protocol. Technical review of data structures, ETL processes, cubes, deployment, standard reports and analysis tools with roadmap recommendations.

MSSQL, SSIS, SSAS, Excel, Web, Reporting Services, C#, ASP.NET

Online marketing company - BI application

Business analysis, project management and remote support for a BI development team. Migration and modelling of processes from MySQL into DB2/DataStage, development of templates, core and mart modelling.

MySQL, DB2, Oracle, IBM DataStage, QlikView

Mail-order retail - logistics data mart

Support of BI development for a large mail-order retail group. Creation of a data mart for logistics data such as outbound goods, inbound goods, stock, returns and delivery.

MSSQL Server, Teradata, SSIS, TM1, Data Vault, SSAS Tabular

Insurance company - ETL migration

Migration of ETL processes from SAS to IBM InfoSphere DataStage. Consulting for the BI team, data modelling, development of selected data flows and standard processes for logs and data checks.

DB2, IBM DataStage

Logistics and supply-chain consulting

Warehouse, shipment and ABC analysis tool for customer analytics. Design of data model and ETL, nearly automated onboarding for new customers, metadata and performant analysis logic.

DB2, Design Studio, TM1, Framework Manager, TM1 Cubes

Metal goods production - production & financial KPIs

Mapping of enterprise-wide production and financial KPIs in a data warehouse. Trace-back to bills of material, processing of raw-material data and calculation of unit costs per part as a reliable basis for cost and contribution-margin analyses.

DB2, Data Warehouse, production data, financial KPIs, ONE LOAD

Recruitment services - ONE LOAD data acquisition

Introduction of ONE LOAD and implementation support for data acquisition from internal systems. The goal was generic, traceable data acquisition for operational and analytical requirements in recruitment.

ONE LOAD, data integration, internal systems, Data Warehouse

Supplier relationship platform

Analytics module for a multi-tenant supplier relationship platform. Data model, ETL processes, workshops and flexible analysis of supplier performance, purchasing volume and group structures.

DB2, IBM Design Studio, TM1, Framework Manager

Automotive - field sales analytics tool

Analytics tool for field sales employees in the spare-parts and accessories business. Combination of historical and current data from multiple sources, online/offline cubes, standard reports and single point of truth.

Microsoft SQL Server, SSIS, T-SQL, Excel, Access, SSAS

Automotive - integration of vehicle accessories

Integration and functional split of a group company for vehicle accessories into different divisions. Migration of logistics data, mappings, historization and harmonization of transaction and master data.

Oracle, MySQL, Microsoft SQL Server, SSIS, T-SQL, Toad

Automotive - performance dashboard

Contribution to a group-wide performance dashboard for dealers of the Austrian sales and service organization. Weighted KPIs, consistent scaling and quality validation for the logistics division.

MIK-BIS, Excel, T-SQL

Automotive - after-sales parts standards

Introduction of group-wide process and product standards in the complaints process for after-sales parts. KPI comparison, process standards, product audits and process audits in an international environment.

Web platform, KPI models, process analysis

Automotive - forklift control system

IT coordination and process management during the introduction of a forklift control system in a logistics center. As-is/to-be processes, functional concept and coordination between warehouse, business department and IT.

Oracle, Toad, Flowcharter

Automotive - replenishment system

Participation in the project team introducing a new replenishment system in a parts distribution center. Data provisioning, impact analyses and scenarios to reduce inventory value.

ERP system, Oracle

Automotive - core processes parts distribution center

Presentation, documentation and analysis of core processes in a parts distribution center. Basis for ISO 9001, quality management, process improvement, training and later project work.

Flowcharter, ERP system, Oracle, Delphi

Lifestyle company - Data Warehouse

Rebuild of a data warehouse project using the Kimball approach with a single point of truth in the core. Modelling of relevant data sources and reporting processes on a cloud data platform.

AWS Redshift, Matillion, Looker

We are happy to share concrete project information in a direct exchange.

Request project