Oracle BI / EPM (Hyperion) Consultant

10/2019 – 1/2020

Conception and Implementation of a Cost Allocation
Tool with the Oracle EPM Cloud Solution –
Oracle Profitability and Cost Management Cloud Service (PCMCS)
[1st implementation in Europe]
• transformation of cost allocation processes from different on-premise relational source systems to PCMCS
• Developing Organizational Costs:
• ABC
• CBC calculations
• Overhead allocation
• Designing Management Reports
• automatization with EPM-Automate
• Coaching of administrators and power users

Business Intelligence (BI), Cloud (allg.), Cloud Computing

11/2013 – 3/2020

• Agile Projectmanagement and Agile Software development project: R23ISDB - managing, conception, development, and implementation of
• IT Strategy Monitoring Framework for Customer Experience of all Operating Companies
• ITSMF Cloud Adoption
• IT Transformation Portfolio Management System
• Vendor Management system for each Market
• Dashboard & Scorecard
• New KPIs for Fixed Wireless Access (FWA)
• Process simplification via ODI
• Advancement (continuous development) of an Integrated Network Technology Planning System
• Development of architectures in project feasibilities
• Optimizing Data models for better Performance
• Update of Business logic of EPM applications for Tableau Reporting and processes
• Deployment of a Synchronization Process between Production to Pre-Production
• Backup & Recovery Process
• Performance Tuning
• Redesign of the cost planning processes:
• Simplification & Optimization of Month End Closing Process/Monthly Submission
• Quarterly Submission
• Detailed Network Planning
• Long Range Planning
• Implementing new Strategy Guidance (e.g. 5G roll out)
• Security User Access Management Systems

• EPM Platform Upgrade 11.1.2.4
• EPM Platform Upgrade 11.1.1.3. to 11.1.2.3

• EPM-ORACLE DB-Tableau Reporting

• conception and implementation of Performance Reporting application for Network KPIs for AMAP markets

• OHP – Sharepoint Integration
• Developing and implementation of a quality assurance systems

• Development and implementation of a new architecture for a simplified submission process

Application Operation and Daily Business
• Accountable for initiating and leading projects to improve reporting processes and tools within GNED Planning and IT-Strategy
• Accountable for managing and implementing requirements, demands, changes and incidents for the productive EPM-based applications(users 200+ across 24 markets)
• Supporting main planning phases and month end closing process and development of monthly upcoming processual, technical and functional issues
• designing management reports and dashboards
• Workshops and Training of Interactive- and Power User
• Induction and Training-on-the-job of internal local based Administrators
• Offshoring of month end closing process to India
• Induction of the internal employees
• Transfer of the month end closing process
• Development of monthly upcoming processes

Agile Methodologie, Business Analysis, Business Intelligence (BI), Oracle Hyperion

4/2012 – 7/2018

- Conception and Implementation of the Next Generation Controlling platform, which implements the key enterprise Finance functions month-end closing, management reporting and planning. Figures from DWHs combined into a detailed steering and planning solution for the complete company P&L. The platform consists of 9 core financial models regarding the P&L and performance measurement. The core models are realised as 25 individual Oracle Essbase and Oracle Hyperion Planning applications.

- develop and implement automated intra-application data transfers via a Teradata-based integration layer

- Redesign, Optimization & Tuning of
- business logics
- BSO planning applications
- ASO central reporting applications

- Automatization with
- Oracle Hyperion Data Integration Management
- Oracle Data Integrator

- ETL Processes Hyperion Planning to Hyperion Financial Management System

- Simplification and Renewal of 31 applications landscape

- designing Reporting & Dashboards with
- Oracle Hyperion Financial Reporting
- Web Analysis and Smart View management reports

- developing business logics with
- Business Rules, calculation-, report scripts, MDX

- Platform Upgrade 11.1.2.3
- 32 applications for actuals, plan, converged and special topics


Application Operation and Daily Business:
- Supporting main planning phases in different business units
- supporting the regular month-end closing process
- ETL Process Hyperion Planning to Hyperion Financial Management System
- Offshoring of month end closing process to India
- Workshops and Training of Admin and Power User
- Accomplishment of system analysis
- Validation of business requirements
- Impact Assessment on existing planning processes
- Process optimization, Forecast, Reporting,Testing, QM
- Advancement of Business modeling

Business Analysis, Oracle Hyperion

6/2011 – 3/2012

Conception and Implementation of an Integrated Network Technology Planning with Oracle Hyperion Planning

Oracle Hyperion

2/2010 – 5/2010

Implementation of Oracle Hyperion Financial Management applications:
• building Metadata and developing business rules, reports scripts and Input sheets
• testing and documentation of Oracle Hyperion-Applications

• cleanup and restructuring the financial performance indicatorsplanning and designdocument
• Implementation of Hyperion Financial Management applications and internal quality assurance test
• Restatement 2009, NoInput Routine

Oracle Hyperion

2/2009 – 1/2010

Conception and Implementation of Oracle Hyperion Planning
• concept and implementation of planning processes
• Metadata normalization (Account, Product, Customer etc.)
• create business reports with Smart View
• develop of Business Rules with Oracle Hyperion Essbase
• Implementation of user authorisationconcept
• Admin/Business-User Training

Essbase Performance Tests
o Dense/Sparse Settings
o Cube Split
o Tuning Hyperion Business Rules
o Cost unit accounting (Plandata)
o Monthly change of plan ELSTER
o Actual vs. Plan data
o Consensus process planning
o Long range budget planning
o Migration from Version 9.3.1. to11.1.1.2.
o Training of administrators and End-users

Oracle Hyperion

8/2007 – 1/2008

Support of data preparation in SAP R/3 HR

SAP R/3

10/2006 – 3/2007

Implementing the Controlling Process of furniture company into SAP R/3 (modules: CO,FI and MM).

SAP R/3

5/2006 – 2/2007

Oracle E-business Suite implementation for a German Construction Company in Essen, Germany. Conducted Modules: Finance, Controlling, Procurement, HR, Sales and Project Systems. Duties: Quality Management of the ERP implementation process for module Sales.
• The employment involved designing, planning and conducting software tests
• Responsibility: Accomplishment of internal test activities and consulting the external module tests in collaboration with the customer.
• Furthermore: Expansion of the search tool, change tracking, Riskmanagement data management
• Developing technical documents such as the end-user document, test-scripts, and reports.
• administration of technical failures

Oracle E-Business

6/2005 – 8/2005

Software testing and quality assurance for the CIO department.

Qualitätsmanagement / QS / QA (IT), Technisches Testmanagement / Testkoordination

7/2004 – 12/2004

identification, analysis, evaluation, categorization, and documentation of the dbRAMM QA process risks
Interviewing and developing what-if scenarios of determined IT-Application in collaboration with Managers.

Qualitätsmanagement (allg.), Risikomanagement