Solution Consultant SAP BI / Analytics

Profile
Senior Consultant SAP BW, SAP Analytics Cloud, BI-IP, S4/Hana embedded Analytics and SAP CO. 
Data Warehousing: Extraction, Staging, Reporting, Planning - 22 years SAP BW experience plus 3 years SAP ERP experience 

• Wide range of integration knowledge within SAP Business Suite 
• Deep understanding of Logistics and Financials in SAP Business Suite 
• Experience with big system landscapes (BW-BW: 1:n; BW-ERP: n:n) 
• ABAP/ABAP-OO Programming 
• CDS Views 

SAP experience - Overview 

• Project Management (lead), Team Lead, Scrum Master 
• Solution Architect 
• SAP S/4 Hana Embedded Analytics, SAP Analytics Cloud
• SAP BW on HANA (BW 7.50), BW/4Hana: Modeling, Implementation, Operations 
• SAP Business Objects (WebIntelligence, Analysis Office, SAP Lumira) 
• SAP Analytics Cloud
• SAP S/4 Embedded Analytics 
• Extraction of non-Netweaver-based solutions like SAP CLM, SAP Ariba, ServiceNow via SQL 
• SAP BI-IP 
• SAP Business Suite CO (Consultant level) 
• SAP Business Suite PS, FI, SD and MM  
• Conceptual design of interfaces 
• Industries: Manufacturing, Chemical, Pharmaceutical, Retail, Engineering.

Tool experience 

• ServiceNow 
• Jira 
• Micro Focus ALM (HP-ALM): Projects, Requirements, Incidents, Tests, Reporting 
• SAP Solution Manager
• MS Power BI/Power Pivot 
• MS-Office (including VBA), MS-Visio 
• Smartsheet, MS Project. MS Sharepoint 
• R-Studio / R 
• Google Suite (gDoc, gSheet etc. including JavaScript Macros, Google Data Studio) 

SAP Experience - Details 

---

Customer: Finance/Controlling, Berlin, Germany 
Duration: 15 month 
Industry: Services 
Project: S/4 Implementation 
Function: Solution Consultant S/4 HANA Embedded Analytics
Tasks / Results: 
CDS-Views: creation, enhancement,
Authorization Concept for Universal Journal (ACDOCA/ACDOCP), redefining DCL.
Fiori Elements: List reports, WebDynpro Grid reports

• Open Item Report (similar to S_ALR_87012178 -
  Customer Open Item Analysis(Overdue))
• Recurring Postings/Dauerbuchungen (Table BKDF)
• Project, Cost Center, Profit Center Actuals (Table
  ACDOCA, VDM: I_JournalEntryItemCube - Journal Entry
  Item Cube)
• Project, Cost Center, Profit Center Actuals/Plan (Tables
  ACDOCA/ACDOCP, VDM: I_ActualPlanJrnlEntryItemCube
  Actual Plan of Journal Entry Item - Cube)
• Commitments (Table COOI)
• Statistical KeyFigures (Tables COSR/FINSSKF, VDM:
  I_FinStatisticalKeyFigureItem - Statistical Keyfigures per
  period)
• Profit Center Reports with 2 structures (BW/Query
  Designer on CDS)

SAP BW on Hana FI/CO Reports

• Sales Tax Report (0FI_GL_4)
• Cost Center Actual/Plan (0CO_OM_CCA_1, 0CO_OM_CCA_9)
• WBS-Elements (0CO_OM_WBS_6)

Report Painter on Universal Journal (Tables ACDOCA and
ACDOCP)

• Cost of Sales reporting (UKV/GKV)
• Plan/Actual Reports (WBS Elements, Cost Center, Profit
  Center)

---

Customer: None 
Duration: 5 month 
Industry: None 
Project: Self education: SAP Analytics Cloud, S/4 HANA Embedded Analytics 
Function: n/a 
Tasks / Results: Build Dashboards, Planning models and Predictive Scenarios in SAC. 
Build Reports in S/4 HANA 
- Overview Pages 
- Smart Business KPIs 
- Multidimensional Reports 
- Analytics List Pages 
- CDS Views  

---

Customer: Procurement, Basel, Switzerland 
Duration: 12 month 
Industry: Pharmaceuticals 
Project: Implementation of a cloud-based procurement system (GEP) 
Function: Scrum Master for Invoice to Pay stream 
Tasks / Results: Scrum Master 

---

Customer: Procurement, Basel, Switzerland 
Duration: 2 month 
Industry: Pharmaceuticals 
Project: Analyzing Catalog Software for Procurement 
Function: Analyst 
Tasks / Results: Analyzing functions of Simeno Catalog Software (Ariba Company) against ServiceNow catalog function. 

---

Customer: Procurement, Basel, Switzerland 
Duration: 12 month 
Industry: Pharmaceuticals 
Project: Decommission of SAP HR system (replaced with Workday) 
Function: Solution Architect support and Project Management support 
Tasks / Results: Architecture Backend, Support testing (HP-ALM), Project Management support 

---

Customer: Procurement, Basel, Switzerland 
Duration: 30 month 
Industry: Pharmaceuticals 
Project: Shared Service Center KPI – Analytics and Reporting 
Function: Solution Consultant SAP BI – Global Architect – Analytics and Reporting 
Tasks / Results: Architecture Backend. 
Interim Team Lead (Development team). 
Conceptual Design of Shared Service Center Reporting with 100 KPIs for activities in 
- ServiceNow (Incidents, Requests) 
- Creation of Master Data (Cost Centers, Assets, Internal Orders, WBS elements etc.) 
- Creation of Transactional Data (Purchase Orders, Shopping Carts, COPA postings, CO Postings, FI postings etc.). 
- SAP Workflow data 
- Financial Closing Cockpit (FCC) 
- Ariba  

---

Customer: Procurement, Basel, Switzerland 
Duration: 9 month 
Industry: Pharmaceuticals 
Project: Source to Pay Program – Analytics and Reporting 
Function: Solution Consultant SAP BI – Global Architect – Analytics and Reporting 
Tasks / Results: Architecture Backend, Development lead Backend. 
- Interim Team Lead (Development team). 
- Conceptual Design of SAP SRM Reporting for Shopping carts, 
- Purchase Orders, Confirmations (Extraction, Staging). 
- Analyzing Self-Service options with BW Workspaces. 
- Decision support for usage BW on HANA or native HANA as Reporting basis. 
- Analysis Frontend: SAP BO and Tableau Software. 
- Conceptual Design of SAP Sourcing-CLM (Contract Lifecycle Management) Reporting: Extraction, Staging, Reporting and Authorization. 
- Solution Design for divisional reporting (identifying data in cross-divisional organizations (Pharma and Diagnostics). 
 

---

Customer: Financial, Mannheim, Germany 
Duration: 24 month 
Industry: Diagnostic 
Project: ERP on HANA (replace regional ERPs with global ERP on HANA) 
Function Solution: Consultant SAP BW 
Tasks / Results: Migration and adaption of twenty global and regional reports. 
Implementation of a Purchase Goods Analysis (PGA) report. 
- Extraction of costing data (0CO_PC_PCP_01 “Product Cost Planning: All Calculations”)  
- Comparing costings in status released (FR) and not released  (KA/VO) and conditions 

more details can be found in attached CV.