Philipp Gies-BI Consultant

Energy management (2023-08-01 – present):

Design a planning solution to improve energy efficiency

Develop concept for an energy management system

Plan a component for action planning to gradually reduce energy consumption

Evaluate planned actions based on opportunities, risks, and effectiveness for inclusion in planning

Define requirements for a data model to compare planned and actual data in the dashboard

Consulting (2023-05-01 – present):

Extend the accantec PerCon authorization management to IBM Planning Analytics

Analyze authorization requirements and align them with IBM Cognos Analytics and Tableau

Expand accantec PerCon to include IBM Planning Analytics via REST API

Print (2023-04-01 – present):

Support implementation of a data warehouse solution with IBM Cognos Analytics 11

Assist in the implementation of a reporting system based on the standard data warehouse

Support report developers and develop custom controls to optimize the user interface

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

Optimize, extend, and operate a legacy BI planning landscape

Upgrade the Jedox solution from version 2019.1 to 2022.2

Optimize ETL processes and reports and implement automated ETL

Integrate various accounting and management systems

Write back completed plans into source systems and implement complex allocation logic

Build and maintain dimensions and hierarchies (corporate structure, P&L)

Develop planning scenarios for FP&A and create reports for budget monitoring

Design and implement new OLAP cubes and reporting

Conduct end-user training as required by clients

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

Migrate and optimize an existing Jedox solution

Merge the reporting system and planning system into Jedox

Build a central group reporting with plan vs. actual reconciliation for FP&A

Optimize KPI calculations, existing reports, and build new reports

Create forecast reports, manage permissions, and provide user training in an international environment

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

Further develop and maintain an existing Jedox solution

Design and develop new OLAP cubes for controlling

Build hierarchies in dimensions (e.g., P&L) and update the Jedox system in a Linux environment

Provide user training for report creation

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

Design and develop a BI planning solution in Jedox with data warehouse setup

Create ETL processes to load dimensions and OLAP cubes

Build reports, planning input forms, and implement business logic (P&L, allocation logic)

Implement planning and analysis reports as well as security concept in Jedox

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

Migrate and optimize an existing Jedox solution

Upgrade the Jedox solution and migrate ETL processes from Pentaho Kettle to Jedox Integrator

Optimize SQL queries, conduct system analysis, remove redundancies, and develop new ETL processes

Analyze and adjust existing reports

Staffing agency (2022-07-01 – 2022-10-31):

Migrate a Jedox solution from version 5 to 2022.2

Perform system update with configuration adjustments and analyze performance issues

Optimize the OLAP database by slimming down dimensions and removing unused cubes/data

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

Create OLAP cubes in Microsoft SSAS

Build dimensions and hierarchies and calculate metrics using MDX

Provide user support for Power BI requests