Matthias Löchner
MicroStrategy and Data Warehouse Consultant/Developer
Experience
IT Service Provider
- Analyzing the data model for a DWH project with the Federal Network Agency
- Analyzing the data model and performance in Oracle
- Optimizing performance in Oracle
- Adjusting the schema model and expanding/optimizing dossiers
- Modeling an internal finance DWH and developing reports for internal controlling
- Modeling the Stage, Core, Business, and Data Mart layers
- Defining requirements for the ETL team
- Replacing the existing reporting tool Cubeware with PowerBI
- Building the semantic layer in PowerBI and developing the reports
MicroStrategy and Data Warehouse Consultant/Developer
Landesbank Baden-Württemberg
- Replacing various SAS developments with MicroStrategy dossiers and Office plug-ins
- Extending the data model for group bank management to include risk provisioning data and RWA data using MicroStrategy 2021 on an Exasol database
- Conducting business analysis with the business units
- Modeling the views and coordinating the loading logic with the ETL developers
- Extending the MicroStrategy model with schema objects
- Developing sample dossiers for analyses together with the business unit
MicroStrategy and Data Warehouse Consultant/Developer
Talanx AG
- Redesigning the data model and adjusting documents and dossiers using MicroStrategy 2021 and PostgreSQL
- Analyzing the current data model
- Redesigning the data model (base tables and views for MSTR)
- Adapting existing objects to the new views
- Reviewing existing documents and dossiers
- Conducting training on the new data model
MicroStrategy and Data Warehouse Consultant/Developer
Landesbank Baden-Württemberg
- Designing and implementing a unified data model for group bank management with MicroStrategy 2020 and Oracle for accounting and financial controlling
- Developing a data model together with business units and ETL developers
- Modeling the data mart
- Developing MicroStrategy objects from the warehouse catalog to the dossier
- Designing and implementing sales management for corporate clients with MicroStrategy 10.4 and Oracle
- Designing the reporting strategy for sales management
- Modeling KPIs together with the business unit
- Developing metrics and dashboards
MicroStrategy and Data Warehouse Consultant/Developer
Sanacorp Pharmahandel GmbH
- Modeling and developing an application for supplier management using MicroStrategy 10.4 and Oracle
- Modeling KPIs for supplier management with the business unit
- Modeling the data mart and coordinating development with the database team
- Developing metrics and reports in MicroStrategy
- Designing and developing dashboards
IT Sub-project Manager and TM1 Consultant
Deutsche Bahn (DB Systel GmbH)
- Redesign of an application for corporate controlling using TM1 and a data warehouse
- Definition and design of the technical architecture with project team members
- Implementation using TM1, Oracle and Talend
- Development of the risk management module
- Project scope: 8 team members, effort about 2000 person days
Process Controlling Specialist in the Loan and Savings Division
Bausparkasse Schwäbisch Hall AG
Project management for building a process database to manage 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 team members, effort about 300 person days
Development of a process efficiency cockpit in the loan and savings division
Analysis of work processes in the loan and savings division
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
Performing month-end, quarter-end and year-end reporting
Creation of ad-hoc analyses for savings and loan portfolios using SAS
Introduction of order management for analysis requests
Optimization of operational data sets
Business Intelligence Concept Specialist
Bausparkasse Schwäbisch Hall AG
IT sub-project management for a planning application to control processes in the loan and savings division
Implementation of IBM TM1
Planning and management of internal and external staff
Design of the planning processes in TM1
Project scope: duration 14 months, 8 team members, effort about 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
Sub-project management for BI projects in IT and sales controlling
Data modeling (DataMarts)
Development of reports and dashboards in MicroStrategy
Development of KPIs together with business team members
Maintenance and expansion of existing BI projects
Process Analysis and Software Development
HBC radiomatic GmbH
Introduction of an electronic master record for radio controls
Analysis of the processes for manufacturing radio controls and managing related documents
Creation of the functional specification in collaboration with department heads
Development using VB.NET and MySQL
Setup of a scanning line and training of staff
Project duration 18 months
Development of an online product generator for radio controls
Design of the product generator in collaboration with product management
Development using ASP.NET and MySQL
Integration and training for domestic and international branches
Project duration 12 months
Skills
Certifications
- Gpm Level D
Software Knowledge
- Microstrategy
- Powerbi
- Ibm Tm1
- Oracle
- Exasol
- Ms Sql Server
- Mysql
- Jira
- Ms Visual Studio
Application Development
- Sql
- Pl/sql
- Lua
- C#
- Asp.net
Methodology Knowledge
- Project Management
- Iiv (Individual Information Processing) In The Financial Sector
- Data Modeling (Data Warehouse And Data Mart)
- Scrum
Industry Knowledge Financial Services
- Group Bank Management
- Home Savings
- Loans
- Planning Processes And Order Management
- It Project Management In The Financial Sector
- It Portfolio Management
- Business Planning
Industry Knowledge Electronics Sector
- Production Processes
- Sales Management
Languages
Education
Ansbach University of Applied Sciences
Diploma in Business Informatics, specialization in E-Commerce · Business Informatics · Ansbach, Germany
Certifications & licenses
GPM Level D
Similar Freelancers
Discover other experts with similar qualifications and experience
Data Engineer
SCRUM Master / DevOps Coach
Requirements Engineer
Manager SAM Service Development
Senior Data Engineer
Quality Assurance Manager (QSV)
Data Engineer Lead
Product Owner Frontend
Reporting and Analytics for HR
Sabbatical, professional development
Requirements Engineer
Business Analyst, Data Warehouse Developer
Data Warehouse Architect and Lead Data Modeler
Workshop Leader 'Introduction to AI Development Tools'
Freelance BI/DWH/ETL Specialist
Expert in Data Warehousing and Business Intelligence
Business Intelligence Coach
Interim Controller
Architect & Technical Team Lead & Senior Developer
Change Manager / Sales Transformation
SSIS Development
Freelance Interim CFO
Power BI Expert
Senior Business Analyst for Customer Data
BI consultant
Managing Partner without operational responsibilities
Oracle Project Management and DBA
Business / Functional Analyst and Oracle Developer DWH
Head of Finance | PMO
