OLAP Experts in Germany

• Architected and deployed private cloud data platform on VMware vSphere, integrating Greenplum MPP, Apache Kafka, Kubernetes, and Apache Solr, and developed real-time ingestion pipelines with Kafka Connect and Schema Registry.
• Led Oracle Exadata to Greenplum migration, rearchitected data models, optimized storage, implemented RabbitMQ with Debezium for CDC, and deployed VectorDB for Generative AI.
• Designed and executed multi-cloud migration PoC across AWS, Azure, and GCP, defined KPIs for throughput, latency, and cost efficiency, executed bulk data transfers, validated analytics and streaming workloads, and delivered full-scale architecture recommendations.
• Assessed legacy on-premises infrastructure and designed modern cloud-native data platforms using Greenplum and containerized microservices, advising on scalability, disaster recovery, and high-availability.

• Building, implementing and selling automated Data Science solutions such as Scorecard Factory and Forecast Factory
• Implementation of automated end-to-end cloud processes
• Development of LLM and NLP models
• Creation of interactive reports
• Support for national and international large corporations as well as medium-sized companies in implementing ML projects

• Consulting on complex IT, accounting, controlling, and business intelligence projects from the analysis phase through implementation to go-live support
• Work as consultant, project manager, and subproject manager
• Focus on business process analysis and implementation
• Controlling: sales, marketing, project, financial, and cost controlling
• Accounting: General Ledger, Accounts Receivable, Accounts Payable, asset accounting
• Implementation and training of SAP R/3 FI/CO
• Operational experience in controlling, sales, human resources, and commercial project management before my consulting work

• Led design, development, and deployment of data solutions supporting a major pharma acquisition for Takeda Pharmaceutical Company, delivering transparency reporting systems across Azure,Databricks (Python and Shell Scripting) platforms.
• Owned,Designed and developed scalable ELT pipelines to process Customer and Product data using Azure, complex SQL, Databricks, and shell scripting, enabling efficient data integration and processing across multiple sources including job orchestration and workflow automation.
• Implemented performance optimization techniques (query tuning, parallelism, workload optimization), improving system efficiency and processing time.
• Applied strong analytical and problem-solving skills to assess technical solutions and support business requirements for compliance and transparency reporting.
• Designed scalable data foundations suitable for downstream analytics and AI workloads.
• Led data quality initiatives by assessing multiple source data, defining quality metrics, and establishing processes for monitoring and continuous improvement.

• Establishing the Microsoft Fabric platform with the company as the central data warehouse and reporting system.
• The company migrated several operational systems including D365 to new version. The new data warehouse is based on a Fabric/Power BI architecture with Azure cloud Entra Authentication.

Tasks Performed:

• Full administrative responsibility for the Fabric platform F64 and F32 capacities, as well as two F8 capacities for development and prototyping.
• Integration of Fabric with Microsoft Entra.
• Data modeling for the data warehouse bronze, silver and gold layers using data modeling tools.
• Star Schema as well as entity relationship modeling.
• Data modeling for data marts and for dimensional modeling and Power BI (semantic model).
• Design of data models for Microsoft SSAS multidimensional and tabular OLAP cubes using DAX and MDX.
• Definition of design patterns for the ETL team for loading OLAP cubes (Tabular and MD), star schemas and data vault structures.
• Planning and managing team of 4 ETL and reporting developers.
• Performance Tuning of Power BI reports, particularly the semantic layer, as well as the Fabric notebooks
• SQL Performance Tuning.
• DB Design for Azure SQL.
• Reporting directly to project senior management.

Label: Power BI, Fabric, Analysis Services (multidimensional and tabular), D365, SSIS, Tabular Editor, SQL Server and Azure SQL, TOAD Data Modeler, DBSchema, Visual Studio Code, DAX Studio, SSMS, Visual Studio, Jira and Confluence.

• Implemented the BI solution and replaced the old BI landscape
• Led the “Sales Bonus Plan” subproject: expanded the existing solution and migrated to Azure (Databricks)
• Led the “Cognos Migration” subproject: expanded existing data warehouses based on MS technologies (source systems: Oracle), analyzed business requirements and designed the technical solution
• Expanded the relational DWH database
• Developed ETL processes using SSIS
• Developed the multidimensional database (OLAP Cubes/SSAS)

• Energy Management (2023-08-01 – present):

• Designing a planning solution to improve energy efficiency

• Creating a concept for an energy management system

• Planning a measures planning component to gradually reduce energy consumption

• Evaluating planned measures by assessing opportunities, risks, and effectiveness for integration into planning

• Defining requirements for a data model to compare planned vs actual data in the dashboard

• Consulting (2023-05-01 – present):

• Expanding accantec PerCon permission management to IBM Planning Analytics

• Analyzing permission requirements and aligning with IBM Cognos Analytics and Tableau

• Extending accantec PerCon with IBM Planning Analytics via REST API

• Printing (2023-04-01 – present):

• Supporting the rollout of a data warehouse solution with IBM Cognos Analytics 11

• Assisting in the introduction of a reporting system based on a standard data warehouse

• Supporting report developers and creating custom controls to optimize the user interface

• Healthcare (2020-08-01 – 2023-03-31):

• Optimizing, extending, and operating a long-standing BI planning landscape

• Upgrading the Jedox solution from version 2019.1 to 2022.2

• Optimizing ETL processes and reports, and implementing automated ETL

• Connecting various accounting and management systems

• Writing back completed plans to source systems and implementing complex allocation logic

• Building and maintaining dimensions and hierarchies (company structure, P&L)

• Developing planning scenarios for FP&A and creating budget monitoring reports

• Designing and implementing new OLAP cubes and reporting

• Conducting user trainings based on customer requirements

• Industrial sector (2020-04-01 – 2020-12-31):

• Migrating and optimizing an existing Jedox solution

• Merging reporting and planning systems in Jedox

• Building a central group reporting with plan vs actual comparison for FP&A

• Optimizing metric calculations, existing reports, and creating new reports

• Producing forecast reports, managing permissions, and training users in an international setting

• Finance (2020-05-01 – 2023-03-31):

• Enhancing and operating an existing Jedox solution

• Designing and developing new OLAP cubes for controlling

• Building hierarchies in dimensions (e.g., P&L) and updating the Jedox system in a Linux environment

• Conducting user trainings for report creation

• Trade fair (2020-06-01 – 2023-03-31):

• Designing and developing a BI planning solution in Jedox with a data warehouse setup

• Creating ETL processes to load dimensions and OLAP cubes

• Building reports, planning input forms, and implementing business logic (P&L, allocation logic)

• Implementing planning and analysis reports, as well as a security concept in Jedox

• Industrial sector (2021-03-01 – 2023-03-31):

• Migrating and optimizing an existing Jedox solution

• Upgrading the Jedox solution and migrating ETL processes from Pentaho Kettle to Jedox Integrator

• Optimizing SQL queries, analyzing the system, removing redundancies, and developing new ETL processes

• Reviewing and adjusting existing reports

• Staffing services (2022-07-01 – 2022-10-31):

• Migrating a Jedox solution from version 5 to 2022.2

• Performing a system update with configuration adjustments and performance issue analysis

• Optimizing the OLAP database by streamlining dimensions and removing unused cubes/data

• Finance (2021-10-01 – 2022-02-28):

• Creating OLAP cubes in Microsoft SSAS

• Building dimensions and hierarchies, and calculating metrics with MDX

• Supporting users with Power BI requests

• Support for implementing the Pimcore CMS, support assistance, and partner management for the existing application landscape.
• Know-how transfer to the existing application landscape.
• Advising stakeholders on the new implementation.
• Support in data modeling for Pimcore.
• Designing and overseeing data migrations from Salesforce to Pimcore using ESB.
• Creating user stories.
• 3rd level support for business-critical processes.
• Technologies: Salesforce Marketing, Sales, and Service Cloud; Talend ESB; Pimcore; Shopware; ERP system Move; DB2; MySQL; MS Office; MS Visio; Jira; Confluence.

• While running FP&A processes, initiated and implemented changes therein, improving depth, speed, and accuracy: performance analysis; monthly reporting to the shareholders; forecasting/estimating; annual planning/budgeting
• Quantified and formulated a strategic plan for the Group
• Provided insights leading to operational and strategic decisions
• Ensured timely progress in strategic projects
• Corporate Finance
• Data Analytics
• Presentation/Pitching
• Stakeholder Management
• Strategic Planning / Budgeting

• Responsibility for group-wide financial management with a focus on management, PE, and lender reporting.
• Focus on an integrated financial model (P&L, balance sheet, cash flow), robust liquidity and covenant management, and preparation of decision-ready materials for financiers, auditors, and rating stakeholders.
• Establishment of reporting standards, data logic, and closing routines for high-frequency scalability.
• Further development of an integrated financial model (P&L/BS/CF), including scenario capabilities, sensitivities, and driver-based forecasting logic.
• Design and management of a rolling liquidity plan (short-/mid-term), including working capital mechanisms and financing instruments.
• Preparation and quality assurance of lender reporting, including covenant calculations, bridge analyses, and variance explanations.
• Support for the CFO agenda in financier and stakeholder communication (Q&A, documentation logic, key messages, data consistency).
• Coordination and content input for rating- and financing-related deliverables (e.g., presentations, data rooms, management commentary).
• Management of IFRS/accounting topics (e.g., IFRS 16 lease logic, accrual and reconciliation concepts) to ensure reporting and audit readiness.
• Standardization of reporting structures, templates, and KPI definitions across entities to increase transparency, comparability, and speed.

• Testing the SekIDP and related components
• Test design, execution and automation, microservices, GitHub Enterprise, Eclipse, Katalon Test Platform, API Testing, Confluence 8, JIRA/Xray, Draw.io, Swagger/OpenAPI, Postman, Docker, Kubernetes, Podman, PuTTY, E-Health, Telematik, Gematik standards, EPA, E-Rezept, sektoraler IDP, encryption, XaDES, PaDES, DICOM, HL7, FHIR, IHE, ICD, SSO, SAML/Shibboleth, OAuth, smartcards, JWT, two factor authentication Android and iOS, Wireshark, BrowserStack, Cypress, gRPC, REST, SOAP, WS-Security, Linux Shell, PowerShell, SSH/SSL, Java, Kotlin, Cordova, Gradle, Groovy, Python, TypeScript

• Highly successful role as lead data analytics expert at a US consulting startup.
• Managed stakeholder expectations by ensuring team delivery velocity using Agile and Lean practices.
• Trained and assembled international offshore data science teams of DevOps engineers, BI developers, and technical support specialists.
• As Sparecodes' data analytics experts, we improved our clients’ business outcomes through requirements management, dashboard and report development, migration, automation, and production support using IBM Cognos, AWS, SAP, Oracle, Teradata, CRM, ERP, Confluence, and Microsoft.
• Provided effective coaching and mentoring for international, multicultural teams in a remote environment, covering new tools and techniques, Agile best practices, internal and external communication, and presentation skills.
• Coordinated technical processes efficiently, including managing and implementing project changes and control processes.
• Promoted strong team engagement and supported employees’ career development, including business change management through coaching.
• Enhanced project status reports by providing insights into team productivity, predictability, and backlog burn-down, leading to improved project outcomes.
• Successfully led the coordination and implementation of software solutions for clients in mechanical engineering, including automation system integration and customization to meet client needs.

• Leading a team of 3 business controllers and 1 demand planner.
• Responsibility for reporting, forecasting, planning, and price management.
• Advising and supporting the implementation of annual negotiations with retailers.
• Managing and optimizing controlling processes.
• Close collaboration with sales, marketing, customer service, and accounting.
• Sales approx. €130 million.
• FMCG.

• Interim Head of Controlling at a medium-sized mechanical engineering group: set up corporate controlling, prepared for planned IPO, realigned monthly reporting
• Project at a medium-sized steel and mechanical engineering company: enhanced cost and performance accounting; created a structured operating cost sheet to determine hourly and overhead rates for pre- and post-calculations; set up profit center accounting to show P&L by business units
• Interim CFO at a startup in optics/photonics: prepared financial and liquidity plans for funding rounds and grant projects; acted as contact for investors during due diligence; set up monthly reporting for internal and external stakeholders; prepared annual financial statements in collaboration with external tax advisors (inventory valuation, provisions, etc.); liaison for project sponsors of funded development projects; optimized and digitized financial processes
• Interim Head of Finance at a robotics startup: implemented business processes; supported financing rounds
• Project at a medium-sized mechanical engineering company: implemented cost and performance accounting