Keywords
Sales
Project Leader
Business Analyst
Business Development
PowerBI
Requirement Engineering
Financial forecasts
Business Intelligence and DWH
Solution Architecture BI/DWH
Software Selection Processes
Reporting
SQL
Business Requirements
Databases
IIS
MS SQL
Business Intelligence
OLAP
Cognos
DWH
Data Analyst
Business Analysis
BI-Strategy- and Architecture Consulting
Skills
Available as Freelance / Interim manager
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
- 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
Project history
Valora, National Suisse, UBS, Zurich Insurance Group, Nestle,
Local Availability
Only available in these countries:
Germany, Austria und Switzerland
DACH
