PROJECT HISTORY

03.2022 – 07.2022

Customer: Uniper AG
Roll: SAP Project Management Consultant/HANA Rollout BW/BI Expert

Branch: Energy

Project description: Prepare, finalize and rollout a BW4/HANA ready implementation of FI/CO data model

Task/Results:

Prepare a rollout schedule and training plan using O365 tools based on input from a project workshop.
Prepare rollout documentation using O365 tools to facilitate the rollout based on input from a project workshop.
Store all documentation in either SharePoint or Teams within the client´s environment
Co-ordinate the implementation of the rollout schedule and training plan to implement the new data model across Finance and other related teams
Conduct internal stakeholder briefing sessions before, during and after the rollout with the goal that all queries are addressed
Document using O365 tools any requirements / issues given as feedback from the key stakeholders during the rollout.
Create a Webi cockpit to analyze and evaluate query usage data.
Creation of BW queries based on the new BW4HANA data model to implement user requirements during the Roolout.
Creation of SAC Stories(DataSet)/ Dashboards to replace the old WebApp reports.
Creation of Microsoft Power BI user manuals and training of business users.
Creation of Webi user manuals based on Sap BI 4.3 Fiori Launchpad and training of business users
Creation of SAC reports and the user manuals for Power/Report users

11.2021 – 03.2022

Customer: SmartShift (USA) à SharedHealth - Canada
Roll: Technical BW/BI Expert

Branch: Pharma

Project description: Installation / Migration and customization of SAP BW/BO Applications to SAP BW 7.5 on Hana and to BIP 4.2 SP09

Task/Results:

Installation and configuration of BI 4.x platforms on Unix server.
Configuration and customization of the BW and BI applications settings.
Review and customization of SAP Business Object security management.
Configuration and maintenance of relational/olap (BICS) BO connections.
Analysis, review, and configuration of Data Federator/ Universes (Data Foundation and Business Layers).
Creation, configuration and maintenance of BO servers and Central Management Console, including SSL Config, WebServices, Auditing, Promotion Management, Monitoring and Data Federator Services.
Create and configure SAP BW RFC connections between BW 7.5 on HANA and Data Federator.
Analyze and customize BW objects (Hana Optimized Objects) on the migrated applications.
Creation and support of SAP BI reporting applications (SAP AfO, SAP Webi)
Handling internal product and OSS tickets for migration issues.
Managing incidents and service requests.
Prepare go-live cutover plan for BI 4.2
Support Go-live and post go-live activities.
Documentation

06.2018 – 30.09.2021

Customer: Cognizant à Sanofi
Roll: Technical Expert/ Transition and Service Delivery Lead

Branch: Pharma

Project description: Maintenance and coordination of the global SAP and Non-SAP BW/BI Application Systems ( LSM EMEA Local & BI Solutions)

Task/Results:

Counterpart of the Sanofi Customer Service Manager for Sanofi LSM EMEA Local & BI Solutions.
PoC for several Global SAP BI-BW incl. (SAP BW-HR) -/4HANA and nonSAP BI Applications.
Managing different Onsite and Offshore Teams > 20 People more than 3 years
Transition Lead for several SAP BI/BW Applications.
Responsible for taking the transition for the assigned-set of applications, proactively highlighting issues and road-blocks in a timely manner to the Service Delivery Manager.
Responsible for complete and timely transition of the new applications for the owned-domain- areas including development of complete transition documents and deliverables as agreed as part of the transition plan.
Responsible for carrying out internal reviews of the artefacts (during Transition / execution) and onboarding technical team.
Responsible for documenting the relevant GxP and nonGxP and SOX relevant SOP’s and identifying areas of improvements
Proactively propose continuous service improvement (CSI) ideas to improve and/or enhance the performance of the applications
Execute continuous service improvement and automation initiatives as directed by the Service Delivery Manager.
Reporting to Global Service Delivery Lead on the overall service delivery performance of the assigned set of applications.
Preparing of the Service Delivery Review Meetings for Global SAP BW/BI Applications
Analysis of EWAs for all global SAP BW applications and support of the operational SAP BW and SAP BW/HANA systems, including coordination of system activities such as system copies, upgrades, and application of patches.
Data extraction from various sources. (SAP R / 3, SAP BW/4HANA, File) and quality assurance of the data.
Optimization of SAP BW systems through compression, aggregates, rebuilding of updates, creation of indices, etc.
Review Implementation of solutions for bug fixes / enhancements and ensure adherence to technical and quality standards and guidelines
Perform technical impact assessment due to changes (minor enhancements)
Problem / Incident and Service Request Management (Service Now Ticketing Tool)
Support of the business and power users for different Front-end tools (SAP AfO, SAP Webi, SAP BEx, Qlickview and Qlick Sense)
Planning and executing year-end activities for global SAP BW Applications
Update documents using PUMA Methodology in the GEODIS Tools

06.2018 – 30.11.2018

Customer: ProSystem IT
Roll: BO Technical Expert

Branch: IT

Project description: Installation/Upgrade/Migration BODS Platform

Task/Results:

SAP Information Platform Services (IPS)
SAP Data Services 4.2
Universumsdesigner, Informationdesigner, WebI-RichClient, QaaWS-Designer
Data Services Designer
Planning and implementation of BIP, DS / IS system upgrades and patching.
Configuration and customization of settings on the platform.
Connection of BODS Central Repositories
BODS Data Services Management Console (DSMC)
Configuration and administration of BO connections / universes.
Creation Query as a Webservices
Support activities

12.2017 – on-going

Customer: SHE Informationstechnologie AG
Roll: Administrator / Developer Business Object Platform

Branch: IT Informationstechnologie

Project description: Installation/Upgrade Business Object Platform and Administration

Task/Results:

Inventory on the already installed BI 4.x platform.
Planning and implementation of BO system upgrades and patching.
Migration of universes and reports from BP 3.x to 4.x.
Configuration and customization of settings on the BI platform.
SAP Business Object Authorization Management
Configuration and administration of relational BO connections / universes.
Creation, configuration and administration of the Business Object Server and Central Management Console incl. Auditing, Promotion Management, Monitoring Services.
Instruction and training of business / power users in the BO tools
SAP BO Workshop preparation and implementation with SAP
Implementation of change requests

04.2013 – 07.2018

Customer: Deutsche Pfandbriefbank
Role: Senior SAP BW / BO Consultant/- Maintenance

Industry: Banks

Project description: Maintenance of the operational BW/BO Systems. Run The Bank

Tasks and Results:

SAP BW

Support of the operational SAP BW systems including coordination of the system activities such as: system copies, upgrades, recording of patches.
Technical conception / modeling / development incl. Routines and transport
Data extraction from various sources. (SAP R / 3, SAP BW, File) and quality assurance of the data.
Optimization of SAP BW systems through compression, aggregates, archiving, rebuilding of updates, creation of indices, etc.
SAP BW Load Management and Monitoring, Process Chain Monitoring
Problem and Incident Management
Support of the business and power users
Implementation of change requests
Test and quality assurance
Transition Lead for several Applications.

SAP NW Portal

Development and support of Ivews, Protal roles and folder structures.
Connection of SAP BW and BO reports to the portal.
Connection and maintenance of Web Dynpro HR applications in the portal
Content Administration, System Administration
Implementation of change requests

SAP Business Object

Support of SAP Business Intelligence systems including infrastructure activities such as: installation, upgrades and patches.
Integration and integration SAP and non SAP systems
Server administration, system administration and configuration
Upgrades (3.x to BO 4.x) and migration of universes and reports to BO 4.x.
User administration (LDAP, SAP, Enterprise)
Authorization management (application, object, user)
Administration via Central Management Console incl. Auditing, Promotion Management, Monitoring Services, Version Management.
Instruction and training of Business and Power Users in the BO Tools
Development of SAP BO reports with various BO tools
Implementation of change requests
Documentation and go-live support

Other:

Preparation / coordination and transfer of maintenance activities to the sub-banks.
Development and maintenance of the wiki tool with Confluence
Ticket processing with the ticket system OSM-Q and Jira

11.2012 – 03.2013

Customer: Deutsche Pfandbriefbank
Role: Senior SAP BW / BO Consultant/Developer

Industry: Bank

Project description:

SAP Business Objects 4.0 is to be installed and used as a strategic reporting tool. For this purpose, a workshop with the supplier SAP should be prepared and carried out. It must be ensured that the integration and conection into BW functions smoothly. For the preparation of the reports, the interface "BICS" should be used if possible. All reports should be integrated into the SAP NW Portal after creation.

Tasks and Results:

Tool validation SAP Business Object SAP BO 4.0
SAP BO workshops preparation and implementation
Connection and integration of SAP BW and BO.
User and authorization management SAP BW / BO
Report creation using SAP Business Objects tools
Integration of the reports in the BW Portal - SAP BO Administration
Test Support and Support Activities SAP BW and BO
Go-live support SAP BW and BO
Training the business and power users
Documentation and delivery

04.2012 – 10.2012

Customer: Deutsche Pfandbriefbank
Role: Senior SAP BW / BO Consultant/Developer (Freelancer)

Industry: Banks

Project description:

Modeling and development of a new BW system. The existing system should be transferred to a new system according to reporting requirements. The new system should be extended and modeled to map the whole bank in BW. The system consists of approx.> 2000 Info objects in> 200 InfoProviders over four layers. For Ad-hoc Reports BW Enterprise DWH Layer should be provided.

Tasks and Results:

Analysis of the source systems / preparation and planning
Conception and process modelling
Data Modeling / Implementation SAP BW 7.3
Development and Transport (8 BW Systems)
Data extraction from SAP R / 3 and non SAP systems
Quality assurance, troubleshooting
Test support and support activities
Process chain monitoring,
Go-live support
Training of business / power users
Documentation and delivery

03.2011 -12.2012

Customer: Deutsche Pfandbriefbank
Role: Senior SAP BW / BO Consultant/Developer (as SAP employee)

Industry: Banks

Project description:

Re-modelling and Extension of an existing BW system. Extension of the data model consisted of approx.> 1400 Info objects in> 150 InfoProviders over three layers. The entire bank should be mapped with all units in BW. In addition, the data should be loaded crosswise and horizontally in the system. Based on this data storage, the reports should be provided via Bex tools and published in the portal

Tasks and Results:

Analysis of source systems (CML, CMS, BP, FI and non SAP)
Conception and preparation for the implementation
Data modeling, development (back-end & front-end)
Data extraction from SAP R / 3 and non SAP systems
Creation of SAP BEx queries and BusinessObjects reports
Setup of SAP BW test systems, quality assurance, and troubleshooting.
Data loading, process chain monitoring
Release Management and Transportation.
Go-live support
Training of business / power user

02/2011 - 03/2011

Customer: Robert Bosch GmbH Stuttgart
Role: Business Process SAP BW / BO Consultant/Developer

Industry: Automotive

Project description:

Planning Tool Evaluation: Within the scope of this project, the functionality of the Business Objects Planning and Consolidation Tool have to be displayed and presented in a demo according to customer requirements.

Tasks and Results:

Technical Conception
Representation of BPC functionalities
Data modeling and implementation of a scenario according to customer requirements
Creation of BPC planning layouts and reports
Presentation / handover

12.2010 – 02.2011

Customer: Robert Bosch GmbH Stuttgart
Role: Business Process SAP BW / BO Berater/Entwickler

Industry: Automotiv

Project description:

Preparation and testing of a technical concept for analysis and
Visualization of the degree of utilization of SAP ERP systems.
In this Pilot project should the key figures from the Solution Manager
be displayed using Bex tools. This usage data should be displayed in a
different BEx report according to time series

Tasks and Results:

Functional conception and process presentation
Analysis of Solution Manager tables
Creation of data models (InfoObjects, DSOs, InfoCubes, transformations, etc.)
Creation of Bex Reports
Creation of process chains
Presentation of results.

12/2010 - 02/2011

Customer: SAP Deutschland AG, Walldorf
Role: Business Process SAP BW / BO Consultant / Developer

Industry: Information Technology

Project description:

Development of a BW Demo System for the reporting requirements of the department. Depending on the customer requirement, BEx queries should be created and made available as a basis for BO reports. Based on the development of the new BO 4.0 security concept was created and presented as a webinar.

Tasks and Results:

Collection of requirements and technical conception
Development of data models and data flows according to reporting requirements
Analysis and design of BW queries and BOBJ reports
Development of a webinar: SAP BOE 4.0 Security Concept.
Presentation of results and handover

11.2010 – 12.2010

Customer: Deutsche Bank Frankfurt
Role: Business Process SAP BW Consultant/Developer

Industry: Bank

Project description:

Creation of a BI-IP demo according to customer requirements. Based on a scenario, the functionalities of BW-integrated planning should be presented. The results of the demos should be displayed using the SAP BEx Web Application Designer.

Tasks and Results:

Presentation of BI-integrated planning functionalities
Data modeling and development in BW
Creation of aggregation levels, planning functions and planning equations
Creation of Web Application Designer applications, planning masks and templates.
Presentation of the results and handover of the documentation

06/2010 - 11/2010

Customer: SAP AG, IT Department, Walldorf
Role: Project- /subproject management

Industry: Information Technology

Project description:

Transfer of activities from 2nd level to 3rd level support team in india. For a total of 30 employees, tasks, stafing activities, permissions, performance reviews should be coordinated and executed. As a single point of contact between the partner teams and SAP IT, all initiatives should be coordinated, and the results evaluated. The results should be aligned with the SAP IT management

Tasks and Results:

Single point of contact between Indian partner and SAP IT for all activities.
Project management in the transition from 2nd level to 3rd level support.
Authorization tasks for all team members.
Coordination and Cooperation - Incident and Problem Management.
Analysis and design of process chains.
Coordination of processes between SAP IT and Tata Consulting Services

01/2010 - 06/2010

Customer: SAP AG, IT Abteilung, Walldorf
Role: Projekt- /Teilprojektleitung, SAP BW Berater

Industry: Information Technology

Project description:

Coordination and design of the processes or services between SAP IT and the Indian outsourcing partner. In this international project, all existing services should be analyzed to enable the system review. It should be analyzed how services are better controlled, monitored and centralized as much as possible. In another project, the data flows in SAP BW would have to be analyzed and implemented. Solution Manager test functionality is used to test the data delivery from different sources for different areas. In the Solution Manager test catalogs, test cases should be created and assigned to the persons. The test process and test flows should be coordinated and documented.

.

Tasks and Results:

Single point of contact between IT and the Indian partner
Analysis of process chains in BI systems and creation of a concept to centralize the monitoring of the process chains.
Inventory and review of existing services and documentation.
Description and documentation of processes and transfer of process chains to the partner team
Coordination of the transfer process between SAP IT and partner teams
Analysis and design of data flows in BW.
Development, documentation and administration of the test tasks in the Solution Manager.

09.2009 -12.2009

Customer: Mercedes-Benz Leasing GmbH, Stuttgart
Role: SAP BW Business Process Consultant

Industry: Bank

Project description:

Implementation of an internal control system for credit risk reporting and stress testing.

Tasks and Results:

Collection of requirements / technical conception and process presentation.
Test case specification and determination of test data
Conducting technical tests and evaluating the results
Checking the data quality in the system
Support of BEx reports for stress testing.

03.2009 -08.2009

Customer: Dresdner Bank AG, Frankfurt a.M
Role: SAP BW Business Process Consultant

Industry: Bank

Project description:

In the project, all data streams must be loaded automatically by means of process chains. In order to simplify the monitoring of the process chains, a mechanism should be built. The development should be documented as a manual and handed over to the staff of the IT department during several sessions.

Tasks and Results:

Creation of technical concepts for the automation of BW data flows by means of process chains
Modeling and implementation of the data model.
Creation of process chains
Creation of a user manual
Training and handing over of the chains to the Dreba company

11.2008 -02.2009

Customer: Mercedes-Benz Bank, Stuttgart
Role: SAP BW Business Process Consultant

Industry: Bank

Project description:

Implementation of an internal control system.

Creation of an internal control system using two reconciliation processes

"(Main / subledger reconciliation, final costing:

Tasks and Results:

System and data model analysis
Preparation and planning of the project
Technical IT concept
Data modeling / implementation, transport and test support in SAP BW
Report creation using SAP BEx
Implementation of APD models to check and validate data delivery from different systems.
Test support and support activities
Documentation and delivery

03.2008 – 10.2008

Customer: Dresdner Bank AG, Frankfurt a.M
Role: SAP BW Business Process Consultant

Industry: Banken

Project description:

Development of a new BW system as a Global Reporting Platform for Dresdner Bank.

Tasks and Results:

Source system analysis, conception and data modeling
Analysis and development of the financial model (securities, derivatives, loans, liabilities, collateral, FI postings, accruals, profit centers)
Harmonization of master and transaction data
Creation of data models (InfoObjects, DSOs, InfoCubes, transformations, routines, etc.)
Creation of customizing tables
Creation and documentation of process chains
Evaluation and implementation of front-end requirements
Knowledge Transfer