Matthias L.
BI and DWH Consultant
Experience
IT Service Provider
Analysis and optimization of the data model with Oracle and MicroStrategy
Analysis of the data model for a DWH project with the Federal Network Agency
Analysis of the data model and performance in Oracle
Performance optimizations in Oracle
Adjustment of the schema model and expansion/optimization of dossiers
Modeling of the data warehouse and development with PowerBI
Modeling of an internal financial DWH and development of reports for internal controlling
Modeling of the stage, core, business and data mart layers
Requirement definition for the ETL colleagues
Replacement of the previous reporting tool Cubeware with PowerBI
Building a semantic layer in PowerBI and developing reports
MicroStrategy and DWH Consultant / Developer
Landesbank Baden-Württemberg
Replacing SAS projects with MicroStrategy
Replacing various SAS developments with MicroStrategy dossiers and Office Plug-Ins
Extending the overall bank management data model with risk provisioning data and RWA data using MicroStrategy 2021 on an Exasol database
Business analysis with the specialist departments
Modeling of views and coordinating load logic with the ETL developers
Extending the MicroStrategy model with schema objects
Developing sample dossiers for reports together with the business unit
MicroStrategy and DWH Consultant / Developer
Talanx AG
- Redesigning the data model and adjusting documents and dossiers with MicroStrategy 2021 and PostgreSQL
- Analysis of the current data model
- Redesign of the data model (base tables and views for MSTR)
- Adjusting existing objects to the new views
- Reviewing the existing documents and dossiers
- Training on the new data model
MicroStrategy and DWH Consultant / Developer
Landesbank Baden-Württemberg
Designing and implementing a unified data model for overall bank management with MicroStrategy 2020 and Oracle
Implementation for the accounting and financial controlling areas
Developing a data model together with the business units and the ETL developers
Modeling of the data mart
Developing the MicroStrategy objects from the warehouse catalog to the dossier
Designing and implementing sales management for corporate customers with MicroStrategy 10.4 and Oracle
Designing the reporting strategy for sales management
Modeling KPIs together with the business unit
Developing the metrics and dashboard
Modeling of the data mart
MicroStrategy and DWH Consultant / Developer
Sanacorp Pharmahandel GmbH
- Modeling and development of an application for supplier management with MicroStrategy 10.4 and Oracle
- Functional modeling of KPIs for supplier management with the business unit
- Modeling of the data mart and coordinating development with the database team
- Developing the metrics and reports in MicroStrategy
- Designing and developing the dashboards
IT Subproject Lead and TM1 Consultant
Deutsche Bahn (DB Systel GmbH)
- Redesign of an application for corporate controlling
- Implementation using TM1 and a data warehouse
- Definition and design of the technical architecture with the project team
- Implementation using TM1, Oracle, and Talend
- Development of the risk management module
- Project scope: 8 project members, effort approx. 2000 person-days
Process Controlling Specialist in the Lending and Savings Division
Bausparkasse Schwäbisch Hall AG
Project management to build a process database for managing the process inventory
Creation of the functional specification
Definition of interfaces to IT applications
Implementation as a GWT-based web application
Project scope: duration 10 months, 12 project members, effort approx. 300 person-days
Setup of a process efficiency cockpit in the lending and savings division
Analysis of work processes in the lending and savings division
Conducting workshops with managers
Design of KPIs
Analysis of data sources
Creation of a prototype with MicroStrategy
Execution and optimization of regular reports and ad-hoc analyses
Reporting for month-end, quarter-end, and year-end
Creation of ad-hoc analyses on savings and loan portfolios using SAS
Introduction of an order management system for analysis requests
Optimization of operational data sets
Business Intelligence Concept Specialist
Bausparkasse Schwäbisch Hall AG
IT subproject management of a planning application to control processes in the lending and savings division
Introduction of IBM TM1
Planning and management of internal and external staff
Design of planning processes in TM1
Project scope: duration 14 months, 8 project members, effort approx. 800 person-days
Implementation of BI projects with MicroStrategy
Product responsibility for the BI tool MicroStrategy
Improvement of the software development process for BI projects
Project management of migration projects
Subproject management for BI projects (IT and sales controlling)
Data modeling (DataMarts)
Development of reports and dashboards in MicroStrategy
Development of KPIs together with project team members in the business unit
Maintenance and enhancement of existing BI projects
Process Analysis and Software Development
HBC radiomatic GmbH
Introduction of an electronic master file for radio control systems
Analysis of the processes for manufacturing radio control systems as well as managing the associated documents
Creation of the functional specification in collaboration with department managers
Development based on VB.NET and MySQL
Setup of a scanning line and training of employees
Project duration 18 months
Development of an online product generator for radio control systems
Design of the product generator for radio control systems in collaboration with product management
Development based on ASP.NET and MySQL
Integration and training of domestic and international branches
Project duration 12 months
Languages
Education
Ansbach University of Applied Sciences
Diploma in Business Informatics, focus on E-Commerce · Business Informatics · Ansbach, Germany
Certifications & licenses
GPM Level D
GPM
Similar Freelancers
Discover other experts with similar qualifications and experience
- English
- Deutsch
2025 © FRATCH.IO GmbH. All rights reserved.