04/2017 - 12/2017

Retailer for Appearal and Footwear (Herzogenaurach, Germany) 

Position: It-Audit SAP Integrated Planning with KMPG

 

Position: BI-IP/BW 7,3 on HANA Team Member

Implementation of a Range Architecture (RA) planning application (include financial perspective) to cover an end-to-end tactical range planning process over the next three Seasons based on the SCRUM Method with JIRA:

 

-    Standard and Fox Planning Functions

-    Query Enhancements: Inverse Formulas

-    Master Data Creation with Planning Function

-    Adjustments in the Planning Layout based on Microsoft Office for Analysis: VBA

-    Creation of Test Cases. Sketches, Unit Test (SCRUM)

03/2017 - 06/2017

Retailer for Consumer Electronics (Ingolstadt, Germany) 

Position: It-Audit SAP Integrated Planning with KMPG

08/2016 - 03/2017

Industrial Company (Nürnberg, Germany)

Position: BW on HANA 7.4 Team Member

Concept and Implementation of an Order Generation Process together with the Developer Team:

- Set-up of an Generic Datsaource with a simple Badi Implementation

- Complete Data Flow up to Composite Provider

- Set-up of Andvanced DSO and Composite Provider in SAP Hana Studio

- Generation of an APD Process with download in an ERP Systen

- Queries and Queries Adjustments

04/2015 - 04/2016

Industrial Company (Nürnberg, Germany)

Position: BI-IP/BW 7.3 Team Member

Implementation of a Planning Process to cover the Requirements for a PP Capacity Planning running on BW Integrated Planning:

-    Writing of the technical Blueprint

-    Set-up of Standard Planning Functions and Fox Formulas

-    Fox Planning functions to use the inverse formula method by copying Actual data

-    Debugging of Fox Formulas

-    Set up of Planning queries with inverse Formulas and Disaggregation in Query Designer

- Simple Characteristic Relationship with User Exit

- Technical Documentation

 

Set-up Planning Layouts based on Design Studio (DS):

Embedding the Planning queries and Planning Sequences in DS

 

Support during Go-Live

01/2014 - 01/2015

Footwear an Appearal Company

Position: BI-IP/BW 7.3 on HANA Team Member

Implementation of a Planning Process to cover the Requirements for Wholesale running on BW on HANA Integrated Planning:

-    Implementation of Season and Fiscal Half Year Planning based on a customer defined Season Concept

-    Definition of all Planning functions to use the Planning Application Kit (PAK)

-    Fox Planning functions to use the inverse formula by copying Actual data

-    Debugging of Fox Formulas

-    Generate new Combinations

-    Settings for the Planning Application Kit

-   Currency conversion with FOX Formulas

 

Set-up Planning Layouts based on Business Objects (Analysis for Microsoft Excel):

-    Set up Planning queries with complex inverse Formulas in Query Designer

-    Embedding of the Planning queries in BOA

-    Creating a MS Office Ribbon in BOA for executing the Planning Sequences with VBA based on a How-to Paper from SAP

-    Simple VBA Macros

 

Support during Go-Live, Support after Go-Live

05/2013 ? 12/2013

Industrial Company (Nürnberg, Germany)

 

Position: BW 7.3 Team Member

 

Adjustment of a available Datamodel from Datasource in R/3, Transformations up to Queries

- Implementation of a Method in Start- and Endroutines

- Adjust DSO?s, Cubes, Update Rules, Queries with fields

- Verification of the new data with BO Analysis for Excel

- Verfication

 

Implementation of a Datamodel to cover the request for KPI Reporting

- Set up of write-optinzed DSO?s and Multicubes

- Implementation of a Flat File Upload with Start Routine in Transformation

 

- Downlaod with Open Hub to a Flatfile

 

 

 

06/2012 ? 02/2013 Full life cycle

 

RWE IT (Dortmund, Germany)

 

Position: BI-IP / BW 7.3 Team Member

 

Transfer of a Process Flow ( evaluation of Commodity Derivatives based on IAS 39 on the basis of a a cut-off date) from an existing SAP-BW System 7.0 to a new SAP-BW System  7.3 to fulfill the new requirements and optimazations given by the business with a move from a Key Figure Model to Accounting Data Model.

 

Set-up of a Status Tracking System with traffic lights embedded in a Webtemplate to support of the monthly and quarterly balancing in the accounting system of Affiliated Companies.

 

Definition and implementation of queries

Support during the Go-Live and Key User Training

 

Modelling of Transactional Cubes, Multicubes, Planning Function types together with a programmer, Planning Seqences, Process Chains

Set up of a code of practise for the Support Team, Technical documentation

 

 

 

04/2010 ? 06/2012

Norddeutsche LB (Hannover, Germany)

 

Position: BI-IP / BW Team Member

 

Migration from BW 7.0 to 7.3: Testing and solving problems caused by the Upgrade together with the Basis Team.

 

Re-design of the available Data Flow for planning the Services and Trading Business:

- Modification of the Data Model (DSO?s, Cubes, Transformations, Flat Files)

- Adaption of Queries and Planning functions

- Adjustments of Webtemplates

- Characteristic Relationships and Data Slices Standard and Exit Class

 

Implementations and Adjustments on the actual Planning Tool:

 

- Workshops together with the business to check the practicability of the new requirements

- Set up of a Concept for new planning requirements, corresponding Time Schedule and Estimation and Realization

- Analysis of the occurrence of wrong working Planning functions

- New Customer Exit Variables used in Ready-Input Queries

- Set up of new Ready-Input Queries and adjustments on used queries

- Set up of an Administration Layout where all Formulas, copy functions etc. can be executed by the central department

- Set up of Fox formulas to calculate Unit costs and risk management

-  Adjustment of an existing planning type for Internal cost allocation

- Set up of Characteristic Relationships with Exit class and Standard

- Support during the planning process

- Adjustment of the Authorization for the Planning Areas

- Technical documentation

 

Implementation of a Webtemplate for consolidated companies to enter actual and plan data on a Profitability Analysis Basis:

 

- Set up of Ready-Input Queries with complex structure embedded in a Web Template with Web Items

- Modelling of Transactional Cubes and Multi Providers

- Adjustment of an existing Expert Routine and the data flow to represent the data on IFRS Basis to an existing IFRS Cube

- Adjustments of Process Chains

 

Set up of a Data Flow for uploading Securities, stocks and bonds from a flat file to Multicube via write-optimized DSO:

- Implementation of a write-optimized DSO, Cube and Multicube

- Derivation of Attributes from Master Data

- Simple Routines to adapt data from the Source

- Endroutine to create new data records for reflection and division of Values

- Go-Live

 

 

 

10/2009 ? 01/2010 Full life cycle

 

Omya AG (Oftringen, Switzerland)

 

Position: BI-IP Team Member

 

Implementation of a Web-based Input-Ready Template for Affiliated Companies to enter Income Statement / Personal data and integration in the Portal in Co-operation with the Portal Team:

 

- Modelling of Transactional Cubes and Multi Providers

- Input-Ready Queries embedded in a Web Template with Web Items

- Set up of dynamical Data Providers for Performance improvements during execution of a Web Template

- Set up of Workpackages for Control Locking in IP

- Planning Functions (Copy, Fox Formula, Revaluation )

- Realization of the new Authorization Concept

 

 

 

11/2008 ? 06/2009 Full life cycle

 

Kraft Foods (Zürich, Switzerland)

 

Position: BI-IP Team Member

 

Preparation of the Planning Process (Sales Planning, Cost Base and Rate Calculation) in Co-operation with the Team and Business and Setup of the Business Blueprint (Integrated Planning)

 

- Set up Real-Time Cubes for Planning data and Multi Cubes for Reporting

- Complex Aggregation Areas on Multi Cubes as a Basis for Planning functions

 

- Ready-Input Queries embedded in a Web Template with Web Items (Standard Web Item groups, Button Group, Data Binding,  Dropdown Box, Container Layout and Container, Group, Tap Pages, Info-fields, Commands for Planning Applications)

- Filters for Planning Functions and Queries

- Simple User Exits to derivate Quarter from Month

 

- Variables filled by simple User Exits

- Planning Functions (Copy, Repost, Distribution, Revaluation, Delete)

- Complex FOX Formulas (e.g. create new lines, complex calculation)

 

- File Upload into BI-IP in cooperation with the Basis (How to Paper)

- Copy and Paste Button in Web Application Designer (How to Paper)

 

- Flat File Upload with Error Stack

- Loading Master Data for Planning Process

- Upload planning data from Real-Time Cube to Cube for Reporting with Process Chain

 

- Support of the Key Users during Testing Phase

-  Set up of Planning Sequences in Process Chains embedded in the Planning Template for Business

- Set up Reports for the Business in Bex

 

- Transport of Planning objects

- GO-Live and Support after GO-Live

 

 

06/07 ? 08/08 Full life cycle

 

Schindler AG (Ebikon, Switzerland)

 

Position: BW Team Member /BI-IP Team Member

 

- Migration from BW 3.1 to BW 7.0 in cooperation with the Basis Team and Functional Testing of the System

- Migration of ETL Processes in BW 7.0

- Support of the running System in all BW Areas, Performance Improvements with Aggregates and Technical Settings

- Set up Reports for the Business with Integration to the Portal

- Optimization of Data Models with inconsistencies and Data quality in BW 7.0

- Setting up and Coordination Translation (Setting up Translation environment, Global Worklists)

- Training of a new BW Team member without experience

- Transport

- Integration of Budget values in running reports

- Training guidelines for Key User Training

- Support after GO-LIVE

 

Conception and Implementation of a Sales Planning Process in BI-IP (Integrated Planning in BI 7.0) based on Planning requirements from the Business.

 

 

 

10/06 ? 06/07 Full life cycle

Procter and Gamble / Wella (Darmstadt)

 

Position: SEM BPS and BW Team Member

 

Implementation of an Intercompany Reconciliation Tool in BW 3.5. and SEM-BPS to monitor the debit and credit postings within the affiliated companies:

 

- Business Blueprint

- Modelling Cubes and ETL to upload the open items

- Set up a process in BW-BPS to enter the differences with explanation by the affiliated companies

- Securing the Access to allowed Company Code with authorization variables

- Set correct Web Interface (Application) to create and execute Planning Layout

- Manual Planning: Set up of a Layout with key figures in data columns and rows defined individually

- Set up the Reporting for the Central Bookkeeping department with Bex

- Creation of Data slices to avoid not allowed entries e.g for past month

- Automatic distribution of the open item statements with the Broadcaster for verification in the affiliated companies

- Preparation of Training Documents

- Execution of the Key User Training

- Support after GO-LIVE

 

 

 

01/07 ? 03/07

MAN (Munich)

 

Position: BI-IP Team Member

 

Implementation of a Prototype in SAP Netweaver 2004s with integration to the Portal

 

- Set up of Planning Applications: Delete, Copy, Revaluation, Formulas

- Web Template for Reports with Web Items: Analysis, Chart, Navigation Pane, Filter Pane, Button Group, Dropdown Box, Hierarchical Filter, Container, Container Layout, Group, Input field

- Web Template Parameters all Parameters for Internal Display, Behaviour like Display Variable Screen and Reset Variables Values, Data Binding Variant

- Enterprise Reporting (WAD, Report Designer)

 

 

02/05 ? 09/06 Full life cycle

SCA (Munich / UK, Dunstable)

 

Position: BW Team Member

 

Realization of a Reporting for Home Delivery in UK in BW 3.1 used by an Enterprise Portal:

- Business Blueprint

- Set up of the complete ETL Process in BW ? high complexity due to a unstructured design in R/3

- Prepare Reports for the Portal in Bex Web

- Training documentation and training to the Key Users

- Securing the Access of external customers to the Reports

 

Roll out of BW for affiliated companies (Spain, Italy, Austria)

 

BW 3.1 Support within the productive System for

Inventory Management, Sales and Distribution, COPA

Reorganisation/Redesign and Optimization of the Sales Area

 

 

 

07/04 ? 01/05

Basell (Mainz)

 

Position: Functional ADK Team Lead

 

Worldwide Implementation of SAP ADK and DART for the Main Modules in R/3 in Cooperation with the Basis Team

 

 

06/04

Arcor (Frankfurt)

 

Position: BW Trainer

User Training in SAP Business Explorer, Analysis and OLAP Functionality

 

 

 

10/03 ? 05/04 Full life cycle

Basell (USA)

 

Position: Functional BW Team Lead

 

- Lead of 2.5 team members

- Business Blueprint

- Activation of the Business Content and adjustments due to business requirements for the main modules

- Strong co-operation with BW Basis to solve technical problems and a programmer for complex data load from Quality management data

- Design and implementation of the process for uploading archived data in SAP BW

- Set up Training documentation for holding the User Training in US

- Support after Go-Live

- Substitution of the Project Leader

 

 

 

07/03 ? 10/03

Degussa (Frankfurt)

 

Position: SEM BPS Team member

Design and implementation of a global and integrated data acquisition tool with SAP-SEM (Rel. 3.2) and the corresponding SAP BW Process

 

- Modelling of a Real-Time Cube and a Multi Cube for Reporting

- Planning functions like Fox Formulas, Distribution by reference data, Copy, Repost, Delete, User Exits in co-operation with a programmer

- Preparation of Training Materials and handover to IT Department

 

 

 

05/03 ? 07/03

Behr (Stuttgart)

 

Position: SEM BPS Team member

Implementation of a worldwide integrated strategic purchase planning tool with SAP-SEM (Rel. 3.1B):

 

- Modelling of an Real-Time Cube

- Set up of  a Layout with key figures in data columns and Header area

- Planning functions like Fox Formulas to calculate weighted price, Distribution by

  reference data, Copy, Repost, Delete, Currency translation

- Business Reports (Bill of materials, Comparison Reports etc) in Bex to analyse purchasing data

- Implementation of the Authorization Object

- Preparation of Training Materials and running the training with Users

 

 

 

08/02 ? 04/03 Full life cycle

Basell (Mainz)

 

Position: BW Team member

 

Implementation of BW 3.0 for the Main Modules to SAP BW incl programming of enhancements. Afterwards support of KPMG for the IT Audit. Economical interpretation of the SAP BW Reports.

 

 

 

02/02 ? 07/02

Full life cycle

BMW (Finland, Norway)

 

Position: SAP R/3 Team member

 

- Assisted with the Blueprint phase

- Customizing of the Sales Order, Pricing and Billing

- Set up of Training materials and training of the Users

- Support after Go-Live

 

 

 

02/98 ? 05/01

Consultancy (Munich)

 

Position: Controller

- Set up and run of the central Controlling department

- Reporting to the Top Management

- Roll-out of the Controlling Tools to the subsidiaries (European wide)

- Structured the Sales and Distribution Controlling in co-operation with the Sales Department

- Support of the existing internal SAP-system (CO, SD) and lead of the internal Roll-out  SAP R/3 CO/SD-Billing

 

 

 

10/94 ? 01/98

Conrad Electronic (Hirschau)

 

Position: Controller

- Planning and Budgeting

- Implementation of existing Controlling Tools to new subsidiary companies

- Cost Reporting (European wide)

- Reporting to the Management