SAP BW/BI Berater mit integrierter Planung

5/2013 – 12/2013

Adjustment of a existing Data model from Data Source in R/3 to Queries:
- Extension with Infooobjects
- Implementation of a new Method in End-/Startroutines
- Verification of Data for the Areas SD, MM, IM and QM after Implementation of the Method with BO Analysis for Excel
- Enhancement of a generic Data source extract structure in R/3
- Extension of an User Exit via SAP Enhancements to fill the new fields in the data source
- Implementation of Routines for DTP’s to read an entry from a table
- Programming of an Include for Calculation on plan data

Implementation of a Data model to cover the request for KPI Reporting:
- Creation Info Objects, DSO’s Cubes, Info Sources and Data Sources for Flatfile Upload
- Implementations of Start Routines to modify data e.g. move from Key figure model to Accounting model
- Set up of a Query as Infoprovider to upload data to a DSO
- Download data from write-optimized DSO to a file with Open Hub

Sap Bi

6/2012 – 2/2013

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 busi-ness 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

SAP BI-IP, Sap Bi

4/2010 – 6/2012

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 require-ments
- 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

SAP BW

10/2009 – 1/2010

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 from Business Blueprint to Support during Go-Live.

SAP BI-IP

11/2008 – 6/2009

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) from Business Blueprint to Support during/after Go-Live.

SAP BI-IP

6/2007 – 8/2008

- 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

SAP BW

1/2007 – 3/2007

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

SAP BI-IP

10/2006 – 6/2007

Implementation of an Intercompany Reconciliation Tool in BW 3.5. and SEM-BPS to monitor the debit and credit postings within the affiliated companies from Business Blueprint to Support during/after Go-Live.

SAP SEM-BPS

2/2005 – 9/2006

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

SAP BW

7/2004 – 1/2005

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

SAP Archiving

6/2004 – 6/2004

User Training in SAP Business Explorer, Analysis and OLAP Functionality

Schulung / Training (IT)

10/2003 – 5/2004

- 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

Sap Bi

7/2003 – 10/2003

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

SAP SEM-BPS

5/2003 – 7/2003

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

SAP SEM-BPS

8/2002 – 4/2003

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

Microsoft Business Intelligence

2/2002 – 7/2002

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

SAP R/3