Profilbild von Michael Fuhrmann Senior Solution Architect & Developer  BI aus Berlin

Michael Fuhrmann

verfügbar

Letztes Update: 06.09.2022

Senior Solution Architect & Developer BI

Firma: GF-Partners GmbH
Abschluss: nicht angegeben
Stunden-/Tagessatz: anzeigen
Sprachkenntnisse: deutsch (Muttersprache) | englisch (Muttersprache) | französisch (gut)

Dateianlagen

CV Fuhrmann Michael english.pdf
CV Fuhrmann Michael english.docx

Skills

  • SAP BW
    • BW/4HANA
    • BW on HANA
  • SAP CAR
    • Assortment Planning 
    • Merchandise Planning
    • Allocation Management
  • SAP Basis
    • Setup ABAP Stack Systems (CAR, Gateway, BW etc.)
    • Setup SAC including Cloud Connector/ Live Connection
  • WebDynpro ABAP
    • Various Project also building web interfaces between webdypro applications and non sap applications
  • ABAP OO
    • Very strong knowledge in OO Programming concepts
  • BI-IP
    • Various planning projects beginning with SAP BPS up to SAC
  • Analysis for Office
  • Lumira
  • SAP Analytics Cloud

Projekthistorie

04/2020 - 06/2020
Platinum Solution Architect BI
BAYER

Industry: Pharmaceuticals
Project Description Middle Up - Planning
Role: Platinum Solution Architect BI
Responsibilities / - Lead architect for the technical planning solution
Deliverables: - Developing data-models (Composite Providers & ALVLs),
data-flows
- Building an admin cockpit to support the planning process
as well as maintain needed customizing such as hierarchy
maintenance, mappings, masterdata
- Integrate planning solution into core reporting (COPA)

04/2018 - 06/2020
Senior Solution Architect BI
Tom Tailor

Industry: Fashion Retail
Project Description Merchandise Planning
Role: Senior Solution Architect BI
Responsibilities / - Lead architect for the technical MPR solution
Deliverables: - Developing data-models (Composite Providers & ALVLs),
data-flows( SLT and SDA )
- Optimizing dataflows with help of expert routines
- Developing of Channel Plan, Store Plan and Mechandise
Plan
- Creating relevant planning functions type SQL script and
FOX
- Setting up Analysis for Excel Workbooks with own ribbons
- Setup authorization concept with front-ends to support
manual maintenance by business
- Automation of weekly and daily loads

04/2014 - 06/2020
Senior SAP BI Solution Architect
Siemens AG

Industry: Utilities
Project Description BW on HANA & PAK Case Study
Role: Senior SAP BI Solution Architect
Responsibilities / - Evaluating Performance Increase by using BW on HANA
Deliverables: - Performance Analysis BI-IP Planning Solution by using BW
on HANA vs BW on HANA incl. PAK
- Redesign of Planning Functions Type Exit -> FOX
- Setting Application Live
- Hypercare
- Enhancing and Extending the application

04/2007 - 06/2020
Senior Solution Consultant
Raiffeisen Bank

Industry: Banking
Project Description: Integrated Planning
Role: Senior Solution Consultant
Responsibilities/ Deliverables: - IP - Review
- Developing enhancements for comment handling

01/2018 - 03/2018
Customer
Hessen Forst

Industry: Public Sector
Project Description Economic Planning with SAP WebDynpro ABAP / Reporting
with Design Studio/ Analysis Office
Role: Technical Lead / Senior SAP BI Solution Architect
Responsibilities / - Enhancing the previously implemented planning solution by
Deliverables: building an interface from sales planning to order creation

08/2017 - 12/2017
Senior Solution Architect BI
Under Armour

Industry: Fashion Retail
Project Description Assortment Planning




SAP Project Experience - Detail


Role: Senior Solution Architect BI
Responsibilities / - Review of existing Planning Application
Deliverables: - Re-Design of Assortment Planning Application
- Concept & Implementation of Ladder Plan
- Performance Improvements by replacing planning functions
by AMDPs

01/2017 - 08/2017
Senior Solution Architect BI
Lanxess

Industry: Chemistry
Project Description Transfer Price Planning
Role: Senior Solution Architect BI
Responsibilities / - Re-Design of old Transferprice Planning Tool
Deliverables: - WebDynpro Framework for Data Maintenance
- Creation of Authorization Concept
- Analysis Office Workbooks for Reporting
- Process Chains for Event triggered Data Initialization and
Reference Data Creation
- Interface to Update Price Conditions in ERP

01/2017 - 08/2017
Senior Solution Architect BI
Lanxess

Industry: Chemistry
Project Description Sales Rolling Forecast Planning
Role: Senior Solution Architect BI
Responsibilities / - Review of existing Sales RFC Solution
Deliverables: - Re-Design of Characteristic Relationships (PAK)
- Enhancing the Admin Cockpit (Webdynpro ABAP) by
WebDynpro Component Interfaces to Run Process Chains
and Planning Sequences
- Framework to Run Exit Functions Type SQL Script via
Background Process with enhanced Logging and E-Mail
Interface for Business Users
- Replacing ABAP Exit Planning Functions with SQL Script &
AMDP

08/2014 - 01/2017
Technical Lead / Senior SAP BI Solution Architect
Hessen Forst

Industry: Public Sector
Project Description Economic Planning with SAP WebDynpro ABAP / Reporting
with Design Studio/ Analysis Office
Role: Technical Lead / Senior SAP BI Solution Architect
Responsibilities / - Framework for a WebDynpro ABAP based Planning
Deliverables: Solution ( Transactional & Master Data )
- Flexible WebDynpro Framework fully cutomizable
- Third Party Tool Integration (GIS) based on Javascript,
HTML - Island, UI5 and SOAP
- SAP Portal Integration
- Implementing the technical requirements
- Using BO Front - Ends (e.g. Design Studio & Analysis
Office)

07/2015 - 04/2016
Senior Solution Architect BI
Daimler AG

Industry: Automotive
Project Description HRePlan - HR Planning
Role: Senior Solution Architect BI
Responsibilities / - Review of existing HR Planning Solution
Deliverables: - Web Front-End Performance Analysis
- Authorization Concept Review
- Solution Design Specification

03/2010 - 04/2014
Technical Lead Architect
Esprit

Industry: Retail
Project Description EPS
Role: Technical Lead Architect
Responsibilities / Deliverables: - Lead architect for the technical MAP / BI solution
- Developing data-models, data-flows, extractions and
retractions to ECC
- Developing the complete Allocation and Subsequent
Allocation tool for fashion, essentials and nos
- Creating a planning function framework optimized to handle
mass data
- Creating a framework to parallelize planning functions as
background jobs
- Automation of store order generation for fashion allocation
depending of warehouse ETA date
- Creating a sales oriented replenishment for Subsequent
Allocation
- Creating the assortment planning for MFO (Made for Outlet)
- Creating a mark down optimization tool for MFO
- Creating/ replacing the MAP standard interface
- Creating the NOS handling and planning solution
- Creating various WebDynpro ABAP applications to steer the
highly automated ordering tools

06/2013 - 12/2013
Customer
Hoffmann-La Roche AG

Industry: Pharma
Project Description Cost Center Planning / Reporting with PAK / BW-on-HANA
Role: Technical Lead / SAP BI Architect




SAP Project Experience - Detail


Responsibilities / Deliverables: - Framework for a Cost Center solution which incorporates
planning as well
- Using BW-on-HANA with PAK (Planning Application Kit)
- Optimizing architecture for HANA capabilities
- Steering and managing the project
- Implementing the technical requirements
- Using BO Front - Ends (e.g. Analysis Office)

01/2012 - 07/2013
Senior Solution Consultant BI & Architect
Siemens AG

Industry: Utilities
Project Description eFMT - Financial Forecasting
Role: Senior Solution Consultant BI & Architect
Responsibilities / Deliverables: - Taking over an escalated project and leading it to a
successful Go-live
- Complete responsibility for the planning/forecasting
application
- WebDynpro master data planning in BW




SAP Project Experience - Detail


- Planning Function Type Exit and FOX
- Data Slices Type Exit
- Characteristic Relationships Type Exit and DSO
- Performance improvements through architectural & concept
- Changes as well as improved coding

01/2008 - 02/2010
Senior Solution Consultant BI & Architect
ECCO

Industry: Retailer / Fashion Industry
Project Description: Merchandise & Assortment Planning ( MAP )
Role: Senior Solution Consultant BI & Architect
Responsibilities/ - The project aims on optimizing and harmonizing the buying
Deliverables: - Process.
- Realizing a Budget Planning for the individual shops with
- Open-to-Buy, Main Order, Stock on Hand and Discounts
- Realizing a Merchandise Planning for all shops within a
Market
- on Customer Type level
- Realizing a complex Like-for-Like Analysis for complete new
- Products with a flexible ranking application to shift the focus
on
- certain products
- Realizing a Marketing Option, in which products could be
- forced in or out according to the product strategy of the
season
- Realizing a Shop Order Proposal with a powerful planning
- engine taking, Budgets, Prices, Ranking, Actuals and Clusters
- into account to come up with a buying proposal for each
- individual shop
- Creating the complete datamodel and dataflows
- Possibility for the end-users to upload flat-files ( e.g. for
- Adjusted prices within a market )
- Data Slicing Concept
- Realizing a complete Status & Tracking System ( STS ),
which
- allows the end-user to submit a plan and to
- approve or reject. The different statuses are visible at all
- times and have impacts on the planning ( e.g. while the
- plan is send for approval planning is not possible, neither after
- plan is approved, though is a plan rejected it is open for
- planning again )
- Realizing the different planning environments in the SAP web
- ( WAD ) as well as in SAP Excel ( BEx Analyzer )

06/2007 - 11/2007
Senior Solution Consultant BI
Hoffmann-La Roche AG

Industry: Pharmaceutical & Diagnostics
Project Description: Global HR Planning
Role: Senior Solution Consultant BI
Responsibilities/ - The project was focussing on implementing a global HR
Deliverables: planning application
- BW: Data model, roll menus, web templates used for
integrated reporting.
- BPS: Conception & Implementation of the planning application
- BSP programming for uploading attachments (PDF, Excel,
Word) based on certain characteristic selections made in the
planning environment.

04/2005 - 06/2007
Solution Consultant BI
Schweiz Tourismus

Industry: Tourismus
Project Description: Reporting and Planning with BW-BPS
Role: Solution Consultant BI
Responsibilities/ - Data modeling
Deliverables: - Implementing queries, web reports & templates
- Developing & implementing PDF web printing Consultant
Solution (Java Engine & Servlet )

08/2006 - 06/2007
Senior Solution Consultant BI
Hoffmann-La Roche AG

Industry: Diagnostics
Project Description: Global Planning Initiave
Role: Senior Solution Consultant BI
Responsibilities/ - The project was focussing on implementing a worldwide
Deliverables: planning application for Sales, COGS, Cost Center, CAPEX,
Period Costs und P& L
- BW: Data model, roll menus, web templates used for
integrated reporting. Implementation of "Web printing with
Excel" - print enhancement for web reports (ABAP OO)




SAP Project Experience - Detail


- SEM/ BPS: Designing a planning scenario including
implementation of planning areas, planning levels, planning
sequences, data slices, exit - variables, exit - planning
functions as well as characteristic relation - exits.
- Implementation of table maintenance screens including
related transaction codes
- Enhancing the application class:
o Event-triggered buffer-refresh
o Changing look and feel of the planning layout (OWC)
o Displaying of comments (OWC)
o Executing planning sequences "On Save"
- Implementing a java script library (mime repository) for frontend
enhancements (hiding columns/ rows, populating error
messages as pop-up, inventing error conditions with coloring
of certain cells, maintaining comments via pop-up window

- Definition of front-end layouts:
o Templates used for web interfaces with header area
showing certain planning attributes
o Integration of check reports via IFRAME
o Templates used for WAD with header area and
additional buttons
- Implementation of custom STS logic with ABAP OO for
SALES, Cost Center und CAPEX:
o Locking of single profit centers/ cost centers
according to authorizations (own authorization
concept with transparent tables -> User : Nodes)
o Status reports (Status of the relevant cost center/
profit center)
- Implementation of a graphical start page for the whole
planning process

09/2005 - 08/2006
Solution Consultant BI
Hoffmann-La Roche AG

Industry: Diagnostics
Project Description: Reporting & Planning with BW-BPS
Role: Solution Consultant BI
Responsibilities/ - Replacing the status and tracking systems with a ODS / data
Deliverables: slice consultant solution
- BW: Creating data model & function modules
- SEM/ BPS: Creating planning areas, level, data slices and
exit variables
- Query Design

06/2005 - 09/2005
Solution Consultant
Schweiz Tourismus

Industry: Tourism
Project Description: Project and cost centre analyses and planning
Role: Solution Consultant
Responsibilities/ - Data model
Deliverables: - Business information collection via routins and formules
- Reporting
- Planning structures
- User exits
- Web interfaces
- Web role menu as a "single-point-of entry"

07/2005 - 09/2005
Solution Consulant BI
Firmenich

Industry: Perfumery and flavor chemicals
Project Description: Proof of concept
Role: Solution Consulant BI
Responsibilities/ - Development and implementation of a prototype
Deliverables: - Data modeling in BW: Creating cubes, info-objects, infosources,
transfer- and communications structures, updaterules

- Setting up aggregates for reporting
- Implementing queries
- CSV - File Upload: dynamic generation of CSV-Files out of
an access database with VBA programming

02/2005 - 07/2005
Solution Consultant BI
SIS

Industry: Banking
Project Description: Planning with BW-BPS
Role: Solution Consultant BI
Responsibilities / Deliverables: - Data modeling
- Creating web interfaces, web reports & templates
- Implementing BW Web printing Consultant Solution with java
script

01/2005 - 04/2005
Solution Consultant BI
Panalpina AG

Industry: Logistics
Project Description: Implementing a data model for SEM-BPS
Role: Solution Consultant BI
Responsibilities / Deliverables: - Web Application Designer (WAD) with iFrames and enhanced
functionalities
- Implementing BW Web printing Consultant Solution with java
script

Reisebereitschaft

Weltweit verfügbar
Profilbild von Michael Fuhrmann Senior Solution Architect & Developer  BI aus Berlin Senior Solution Architect & Developer BI
Registrieren