ANKA-Consulting GmbH - SAP BW/4HANA and Analytics Expert

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:

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:

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:

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:

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:

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:

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:

.

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:

 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:

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