Matthias Löchner-MicroStrategy and DWH Consultant/Developer
Check rate
Experience
IT service provider
- Analysis of the data model for a DWH project with the Federal Network Agency
- Analysis of the data model and performance in Oracle
- Performance optimization in Oracle
- Adaptation of the schema model and expansion/optimization of dossiers
- Modeling of an internal finance DWH and development of reports for internal controlling
- Modeling of the stage, core, business, and data mart layers
- Definition of requirements for the ETL colleagues
- Replacement of the existing reporting tool Cubeware with PowerBI
- Building the semantic layer in PowerBI and development of reports
MicroStrategy and DWH Consultant/Developer
Landesbank Baden-Württemberg
- Replacement of various SAS developments with MicroStrategy dossiers and Office PlugIns
- Expansion of the data model for overall bank management to include loan loss provision data and RWA data with MicroStrategy 2021 on an Exasol database
- Business analysis with the business departments
- Modeling of views and coordination of load logic with the ETL developers
- Expansion of the MicroStrategy model with schema objects
- Development of sample dossiers for analyses together with the business department
MicroStrategy and DWH Consultant/Developer
Talanx AG
- Redesign of the data model and adaptation of 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)
- Adaptation of the existing objects to the new views
- Review of the existing documents and dossiers
- Training on the new data model
MicroStrategy and DWH Consultant/Developer
Landesbank Baden-Württemberg
- Design and implementation of a standardized data model for overall bank management with MicroStrategy 2020 and Oracle for accounting and financial controlling
- Development of a data model together with the business departments and the ETL developers
- Modeling of the DataMart
- Development of MicroStrategy objects from warehouse catalog to dossier
- Design and implementation of sales control for corporate customers with MicroStrategy 10.4 and Oracle
- Design of the reporting strategy for sales control
- Modeling of KPIs together with the business department
- Development of metrics and dashboards
MicroStrategy and DWH Consultant/Developer
Sanacorp Pharmahandel GmbH
- Modeling and development of an application for supplier management with MicroStrategy 10.4 and Oracle
- Business modeling of KPIs for supplier management together with the business department
- Modeling of the DataMart and coordination of development with the database team
- Development of key figures and reports in MicroStrategy
- Design and development of dashboards
IT Subproject Lead and TM1 Consultant
Deutsche Bahn (DB Systel GmbH)
- Redesign of an application for corporate controlling with TM1 and a data warehouse
- Definition and design of the technical architecture with the project team
- Implementation with TM1, Oracle, and Talend
- Development of the risk management module
- Project scope: 8 project members, effort approx. 2,000 person-days
Process Controlling Officer in the Loan and Savings Area
Bausparkasse Schwäbisch Hall AG
Project lead for building a process database to manage the process inventory
Preparation of the functional concept
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
Build-up of a process efficiency cockpit in the loan and savings area
Analysis of work processes in the loan and savings area
Conducting workshops with managers
Design of KPIs
Analysis of data sources
Creation of a prototype with MicroStrategy
Execution and optimization of standard reports and ad-hoc analyses
Delivery of reporting for month-end, quarter-end, and year-end closing
Creation of ad-hoc analyses for savings and loan portfolios with SAS
Introduction of order management for analysis requests
Optimization of operational data inventories
Consultant for Concept Design in Business Intelligence
Bausparkasse Schwäbisch Hall AG
IT subproject lead for a planning application to control processes in the loan and savings area
Introduction of IBM TM1
Planning and coordination 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 lead for migration projects
Subproject lead for BI projects in IT and sales controlling
Data modeling (DataMarts)
Development of reports and dashboards in MicroStrategy
Development of KPIs together with project members from the business department
Maintenance and expansion of existing BI projects
Process Analysis and Software Development
HBC radiomatic GmbH
Introduction of an electronic master file for radio controls
Analysis of the processes for manufacturing radio controls and managing the related documents
Preparation of the functional concept together with department heads
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 controls
Design of the product generator together with product management
Development based on ASP.NET and MySQL
Connection and training of domestic and international branches
Project duration 12 months
Industry experience
See where this freelancer has spent most of their professional time.
Experienced in Banking and Finance, Information Technology, Manufacturing, Transportation, Insurance, and Pharmaceutical.
Business area experience
See which departments and functions this freelancer has contributed to most.
Experienced in Business Intelligence, Information Technology, Project Management, Finance, Accounting, and Operations.
Skills
Certifications
- Gpm Level D
Software Skills
- Microstrategy
- Powerbi
- Ibm Tm1
- Oracle
- Exasol
- Ms Sql Server
- Mysql
- Jira
- Ms Visual Studio
Application Development
- Sql
- Pl/Sql
- Lua
- C#
- Asp.Net
Method Knowledge
- Project Management
- Iiv (Individual Information Processing) In The Financial Sector
- Data Modeling (Data Warehouse And Data Mart)
- Scrum
Business Knowledge In Financial Services
- Overall Bank Management
- Home Savings And Loan Contracts
- Loans
- Planning Processes And Order Control
- It Project Management In The Financial Sector
- It Portfolio Management
- Business Planning
Business Knowledge In The Electronics Sector
- Production Processes
- Sales Control
Languages
Education
FH Ansbach
Diploma in Business Informatics, focus on E-Commerce · Business Informatics · Ansbach, Germany
Certifications & licenses
Statistics
Experience
Global experience
Expertise
Qualifications
Profile
Frequently asked questions
Have questions? Find more information here.
Matthias is based in Kreßberg, Germany.
Matthias speaks the following languages: German (Advanced).
Matthias has at least 18 years of experience. During this time, Matthias has worked in at least 5 different roles and for 7 different companies. The average length of individual experience is 2 years. Note that Matthias may not have shared all experience and actually has more experience.
Based on recent experience, Matthias would be well-suited for roles such as: MicroStrategy and DWH Consultant/Developer, IT Subproject Lead and TM1 Consultant, Process Controlling Officer in the Loan and Savings Area.
In recent years, Matthias has worked for IT service provider, Landesbank Baden-Württemberg, and Talanx AG.
Matthias is most experienced in industries like Banking and Finance, Information Technology, and Manufacturing. Matthias also has some experience in Transportation, Insurance, and Pharmaceutical.
Matthias is most experienced in business areas like Business Intelligence, Information Technology, and Project Management. Matthias also has some experience in Finance, Accounting, and Operations.
Matthias has recently worked in industries like Banking and Finance, Information Technology, and Insurance.
Matthias has recently worked in business areas like Business Intelligence and Information Technology.
Matthias attended FH Ansbach for Business Informatics.
Matthias has 1 certificate: GPM Level D.
The availability of Matthias needs to be confirmed.
Daily rate distribution
The rates shown represent the typical market range for freelancers in this position based on recent contracts on our platform.
Average rates for similar positions
Rates are based on recent contracts and do not include FRATCH margin.
The average daily rate is the mean of all daily rates from recent contracts of comparable freelancers on our platform.
The median daily rate is the middle value of all daily rates — half of comparable freelancers charge less, half charge more. Unlike the average, it is barely affected by outliers.
Calculated based on our freelancers’ daily rates as of 30 Aug 2026. Actual rates may vary depending on seniority level, experience, skill specialization, project complexity, and engagement length.
Similar freelancers
Discover other experts with similar qualifications and experience
Mayooran Thillainathan
Moez Seyedan
Gerald Gastgeb
Michael Köhler
János Kurics
Eric Bouendeu
Kerstin Burgen
Stephan Martin
Christian Dröge
Ulm Paunel
Experts recently working on similar projects
Freelancers with hands-on experience in comparable project as a
Marco Skulschus
Kai Pankatz
Stefan Corsten
Petru Kisalita
Joachim Bleichert
Stefan Wimmer
Torsten Glunde
Serge Kalinin
Guido Klein
Peter Brungs
Nearby freelancers
Professionals working in or nearby Kreßberg, Germany
Johannes Fruntzek
Rolf Funk
Ali Chaari
Maximilian Tritschler
Julia Lach
Erwin Schäberle
Stefan Müller
Jean-Louis Tsalefac
Egor Becker
Tobias Rudolph
