Freelancerprofil: -0631816
SAP Berater BI/BW, BI-IP, BI-SEM/BPS, Query Designer, BW on HANA, BEx, BO, SCM, OTC
- Position:
- IT Beratung / Consulting
| Projekte im Werdegang |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 08/2016 - | SAP-HANA, Excel COCA-COLA (CCEP) ? BW on HANA - Off invoice planning, BI-IP planning project Creation of data source/extraction structures in ECC, DSO's, Cube's, Transformations (Start/End routine) Multiproviders, Aggregation Levels, Input Queries, 7.4. Comment function, planning functions, process chains, data locking and authorisation Based on actual data, I created a Top down and Bottom up planning with BI-IP, using Analysis for Excel as frontend tool |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 01/2016 - 07/2016 | Finanzwesen, Excel IP planning projects ? Financial planning - Cash flow, balance sheet and P&L planning for all departments at Gazprom Germany with BI-IP and Analysis for Excel ? Overhead planning - Overhead planning based on cost elements, cost centres, projects, wbs elements, including comments for German, Russian and English |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 05/2011 - | Einkauf/Lieferantenmanagement COCA-COLA (CCEAG) Dec 2105 ? Forecast/demand/promotion planning with BI-IP ? Implementation of Coke One project (BI, BO, SCM), mainly for OTC - SD, DSD, MM ? Support, maintenance and further development after Coke One implementation ? Project management Managing test coordinators and test users for a global template roll out in Germany Managing implementations with team members from the US, Spain, India, Philippines and Germany |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 01/2011 - 04/2011 | ? Support of Cobra Application
Support of the BW-IP Cobra application, which involves: Month-end, quarter-end and year-end closing, Error ticket handling and Front-end/ Back-end Support of the tool
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 09/2008 - 12/2010 | ? Cobra Project
This is a web based BI-IP implementation on top of a BW development, extracting data from R/3 applications
The project provides a tool to plan and report the entire value chain. I was responsible for Inventory-, Order/Sales
Revenue- and Balance Sheet Planning and Personnel Costs/ HR planning
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 09/2008 - 04/2011 | |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 04/2008 - 07/2008 | ? Chiron Project - Indonesia Implementation
This project is the implementation/ rollout of the Chiron template to Indonesia
I was responsible for Integrated Planning, Master data management and BI Data Architecture
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 12/2007 - 07/2008 | ? Chiron Project - Australia Support
I supported the current solution/ production system and the GFO Planning process
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 04/2007 - 11/2007 | ? Chiron Project - Australia Implementation
This project is the implementation/ rollout of the Chiron template to Australia
I was responsible for Integrated Planning, Master data management and BW Data Architecture
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 05/2006 - 03/2007 | Weber ? Chiron Project - Template This is a BI Integrated Planning project based on SAP Net Weaver 2004s for Upstream (E&P). It is a Bottom up template development and comprises R/3 data collection, Data Warehouse Modelling and Integrated Planning. I was responsible for Integrated Planning, Master data management and BI Data Architecture |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 10/2005 - 05/2006 | Hyperion, MS Office, SEO/SEM - Search Engine Optimization & Marketing, SEO/SEM - Search Engine Optimization & Marketing ? Group GFO Project The Group GFO project has been initiated to replace the current Group GFO Hyperion and MS Excel based system with a BW/SEM system in order to have a more robust and controlled solution. I was responsible for building the BW SEM backend and frontend components |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 04/2005 - 10/2005 | SEO/SEM - Search Engine Optimization & Marketing ? Alliance Project/ Support This is an outsourcing/ support project to maintain and enhance a SEM-BPS/BCS and BW solution. I was responsible for supporting and developing SEM BPS, BW Workbench and BEX Reporting |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 12/2004 - 02/2005 | SEO/SEM - Search Engine Optimization & Marketing, Hyperion, SEO/SEM - Search Engine Optimization & Marketing, SEO/SEM - Search Engine Optimization & Marketing task of this blueprint was creating a detailed design document for the Enterprise projects (Downstream) - a SEM/BW implementation to replace the current Hyperion system for planning. I was responsible for the technical system design (data architecture - BW and SEM, master data, loading procedure/ data flow) and prototyping BG (March 2005) This was a Dash Board implementation for the senior management. I was responsible for prototyping a SEM/BW solution |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 12/2004 - 07/2008 | |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 06/2004 - 10/2004 | Finanzwesen, SEO/SEM - Search Engine Optimization & Marketing, SEO/SEM - Search Engine Optimization & Marketing, SEO/SEM - Search Engine Optimization & Marketing project involves the budget planning for a financial advisor company with SEM-BPS/ BW. It includes Profit Loss, headcount, investment, customer and cost planning. The planning is web based and monitored by the Status and Tracking System (STS) Technical details and responsibilities Creating the data architecture in SEM and BW Data Warehouse including ? Planning areas (layouts, planning functions), web folder, STS structure ? Cubes, ODS, multi provider, info objects, update rules, master data, hierarchies and info sources Management reporting - creating of queries for Profit & Loss statement, personnel costs/ HR planning, investment and cost centre data including ? Restricted and calculated key figures, structures, hierarchies and formulas Authorisation for BW and SEM: roles, profiles, authorisation objects and users Transport of BPS and BW objects |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 01/2004 - 05/2004 | Pharmazie, SEO/SEM - Search Engine Optimization & Marketing ? Janssen Pharmaceutica - SAP Competence Centre I was responsible for the implementation of profit & loss planning in Scandinavia and sales planning in UK with SEM- BPS/BW. This was based on Cost Centre Accounting (CCA), Internal Orders (OPA) and Profitability Analysis (COPA) from R |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 02/2003 - 12/2003 | Finanzwesen, SEO/SEM - Search Engine Optimization & Marketing, SEO/SEM - Search Engine Optimization & Marketing, SEO/SEM - Search Engine Optimization & Marketing project replaces financial software with SEM-BPS/BW for the worldwide controlling department in order to speed up the planning process and the management reporting. The planning process involved sales, profit & loss, and product planning. The planning is web based and monitored by the Status and Tracking System (STS) It is an international project with teams from Bearing Point US/ Germany and SAP Belgium/ US I am responsible for the SEM BPS Implementation in the European team REWE - BALANCED SCORECARD (JAN 2003) This project was a Balanced Scorecard prototype implementation for a supermarket chain (Penny), which included web reports, web based planning and web based balanced scorecard and management cockpit I was responsible for the design of BW, SEM BPS/CPM and knowledge transfer to the client |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 02/2003 - 05/2004 | |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 11/2001 - 11/2002 | SAP-R3, SEO/SEM - Search Engine Optimization & Marketing, SAP - Industry Solutions, SEO/SEM - Search Engine Optimization & Marketing, SEO/SEM - Search Engine Optimization & Marketing, SEO/SEM - Search MOL (Gas and Oil Company) - BUSINESS PROCESS REENGINEERING Accenture and SAP managed this project, which was a full SAP/ R3 implementation including BW and SEM-BPS The average number of people using SAP is 3500. Approximately 600 users will work with BW and SEM-BPS. The planning project comprises ? Capex, Opex, Sales, Profit & Loss, Balance sheet and Cash Flow planning (SEM-BPS), Top down, Bottom up and KPI planning (SEM-BPS, BSC), Consolidation (SEM-BCS), Balanced Scorecard (SEM-BSC) ? Management Reporting (BEX Analyzer), Data Architecture (Workbench) I was responsible for managing the technical integration with the BW and the SEM team, including 4 consultants and 4 users |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 08/2001 - 10/2001 | Finanzwesen, SEO/SEM - Search Engine Optimization & Marketing ABN AMR- FINANCIAL BUSINESS ARCHITECTURE The objective of this internal project was to develop a performance measurement framework that allows the CEO and Board to set the strategic goals and direction of the enterprise The project comprised the creation of a Strategic Planning Model in BPS - Balance Sheet, Profit & Loss, hierarchical planning with SEM and BW Hierarchies and Capital Market Interpreter (BPS) - Balanced Scorecard and Management Cockpit (CPM) and management reporting via the internet (Bex Analyzer) I lead implementation of the BPS functionalities and preparation of presentation material the co-ordination of the technical implementation, was responsible for coaching team members |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 06/2001 - 08/2001 | ABN AMRO, Rolls Royce
Scottish Courage
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 03/2001 - 06/2001 | NESTLE - BALANCED SCORECARD
This project involved developing and designing the Balanced Scorecard and the Management cockpit and was a natural succession of the earlier work done regarding the related module of Business Planning and Simulation
My task was the technical implementation of the Balanced Scorecard, the creation of BPS planning data and to train the client in BPS and Balanced Scorecard
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 11/2000 - 02/2001 | Automobil/ Fahrzeugindustrie, SEO/SEM - Search Engine Optimization & Marketing, SEO/SEM - Search Engine Optimization & Marketing, SEO/SEM - Search Engine Optimization & Marketing, SEO/SEM - Search Eng BMW - E-PROCUREMENT SYSTEM The objective of the project was the creations of a global electronic procurement system, in order to reduce costs by automate and standardise the process of ordering consumer goods. This will lead to a competitive advantage in the automotive market and includes streamlining business processes, decentralising, improve quality of information and flexibility - worldwide access via SAP and Internet I was responsible for the implementation of the strategic planning with SEM-BPS SAP AG (WALLDORF) - QUALITY CHECK for SEM/ BW 3.0A (OCT 2000) In this project I tested BSC functionalities for the 3.0 A Version of SEM, which was released December 2000 KPMG CONSULTING - SEM/ BW 2.0B Prototype (SEP 2000) At this project we created a SEM Prototype, which involved strategic planning, Balanced Scorecard, management reporting, dynamic simulation and business information collection will lead |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 09/1999 - 10/1999 | SEO/SEM - Search Engine Optimization & Marketing KPMG CONSULTING - SEM 1.0A Creating the first integrated SEM 1.0 Prototype for SAPhire in the US, which included BW, BPS and Powersim I was responsible for BPS implementation and the Integration of BPS and Powersim data |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Branche |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Banken & Finanzen Gesundheitswesen Öl- und Gasindustrie | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Kenntnisse |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Ausbildung & Zertifikate |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| k.A | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Sprachen |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| deutsch | (++++) | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| englisch | (++++) | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| russisch | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Sonstiges |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
für Freelancer
für Kunden
Kontakt
people4project GmbH
Lörenskogstr. 3
85748 Garching bei München
Lörenskogstr. 3
85748 Garching bei München
+49 (89) 55 29 39 - 40
