Projektleiter/Business Analyst/Solution Archtitect DWH/BI /Datenvisualisierung /Advanced Analytics

Available as Freelance / Interim manager

• Expert Knowledge in Business Analysis, Requirement Engineering, Business Intelligence and DWH
• Solution Architecture BI/DWH, BI-Strategy- and Architecture Consulting, Software Selection Processes
• Practice-Skills in Program- and Project-Management (IPMA and Scrum certified)
• Business Development, Product Manager Power BI Custom Visuals – IBCS (R) Charts, Ultimate Waterfall Chart and Ultimate Variance Chart
• BI Processes/ BI Organisation
• Azure & Power BI Advisor
• Power BI Trainings - https://dataviz.boutique/blog
• Power BI Development
• Power BI Custom Visuals
• Power BI Business Data Modelling
• Power BI Report& Data Model Development
• Data warehouse
• Power BI Custom Visuals Development
• https://dataviz.boutique/
• Cloud Data Warehouse Snowflake
• Exasol, Azure DWH, Cloud DWH Tool Evaluation

 
Sector Consumer Goods ~ 800 Person Days
-Finance and Sales Reporting with MS SQL Server 2008 R2 Analysis Services
-Forecasting “Cost of Goods sold” Application with MS SQL Server 2008R2 (OLAP)
-ETL Design For Dynamic Budgeting Application with MS SQL Server 2005

Sector Retail ~ 550 Person Days:
-Financial P+L Reporting MS SQL Server 2008 (AS) (DWH)
-Contribution Margin Reporting MS SQL Server 2008 (AS)
-Financial P+L / Balance Sheet Reporting MS SQL Server 2008 R2 (AS) (DWH)
-Financial Consolidation Reporting MS SQL Server 2008 (AS) DWH

Sector Financial Services – Banking, Investment Banking ~ 480 Person Days
-Human Resources DWH and Reporting with MS SQL Server 2005 (AS)
-Financial P+L Reporting MS SQL Server 2005 (AS) (DWH)
-Financial P+L Planning ETL MS SQL Server 2005 (DWH)

Sector Insurance
-Financial Consolidation Reporting MS SQL Server 2005 (AS) DWH ~ 140 Person Days
-Financial Consolidation ETL MS SQL Server 2005 (AS) DWH ~ 150 Person Days
-Poll/Survey Analytical System with MS SQL Server 2005 (AS) ~ 50 Person Days
-Customer Analysis MS SQL Server 2012 (AS) ~ 50 Person Days

General
SQL Development, T-SQL
OLAP (Online Analytical Processing) projects for customers
Database design and DWH Design according to Ralph Kimball (http://www.ralphkimball.com/)
Extraction, transformation, and loading (ETL) processes between different data sources and targets.
Dimensional modeling (including slowly changing dimension, Many2Many)
Developing fact tables as data source for OLAP cubes
Design and implementing reports for end-user of OLAP databases
Information Design
Technical architecture design business intelligence systems