Philipp Gies-BI Consultant

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