SAP Data & Analytics – Technologies & Competencies

Overview

As a SAP Data & Analytics expert, I support customers from requirements analysis to design, data modeling and ETL processes to migration, operation and performance optimization of their analytics landscapes.

• Many years of international project experience in consulting and development
• Backend and frontend expertise in the SAP analytics environment
• Focus on performant, maintainable data models and stable processes
• Support for business units (controlling, finance, sales, logistics etc.)
• 2nd and 3rd level support, system monitoring & troubleshooting

SAP Data & Analytics Focus Areas

SAP Datasphere

• Requirements analysis, design and modeling (Data Builder & Business Builder)
• Data integration from SAP and non-SAP sources
• BW Bridge – using existing BW objects in Datasphere
• Security (roles & authorizations), space management, connections
• System configuration, administration and support

SAP Analytics Cloud (SAC) – including integrated planning

• Design and implementation of stories, dashboards and planning applications
• Building datasets and models (Classic & Optimized)
• Planning, budgeting and forecasting (IP / integrated planning)
• Scripting / programming in SAC (stories & planning), custom widgets
• Design of analytic applications
• Connections, access control and ongoing support

S/4HANA Embedded Analytics & SAP Fiori

• Requirements analysis, design and development of analytical apps
• KPI-based reports & dashboards in the Fiori Launchpad
• Custom analytical queries and custom CDS Views
• SAP Fiori & SAPUI5 development
• Support in cloud and on-premise scenarios

SAP BW/4HANA

• Design, modeling and building complex data flows
• Backend and frontend development (including planning, reporting, analytics)
• Migration to BW/4HANA, hybrid modeling (XS Classic & XS Advanced / HDI)
• ABAP and AMDP programming for transformations & routines
• Process chains, authorizations, transport system, Eclipse-based development
• Reporting including Analysis for Office (AfO)

SAP BW 3.5 to BW 7.5 on HANA

• End-to-end development: DataSources, DTPs, InfoPackages, transformations
• Modeling complex process chains and data flows
• SAP HANA analysis processes, APDs (ABAP), Open Hub, Broadcaster
• BEx reporting tools (Query Designer, Web Application Designer, Report Designer)
• Templates & dashboards (WAD, SAP Portal), ABAP user exits & BADIs
• Migration and performance optimization of existing BW landscapes

S/4HANA, ECC & Platform Competencies

S/4HANA (Cloud & On-Premise)

• S/4 Embedded Analytics
• DataSources (master and transactional data, business content)
• CDS Views & CDS View Migration (CDS View Entities)
• SAP HANA calculation views
• HANA stored procedures, SQLScript, partitioning

SAP ECC

• DataSources (master & transactional data, business content)
• LO-Cockpit and CMOD enhancements
• ABAP user exit variables, BADIs, function modules
• Master data modeling and support

SAP HANA & SAP HANA Cloud

• SAP HANA native development & SQLScript
• Modeling HANA artifacts
• Installation and management in SAP BTP

SAP BTP & Basis-related Topics

• SAP BAS – Business Application Studio, ABAP environment
• Management of instances & subscriptions (Cloud Foundry, services)
• SAP HANA Cloud service, schemas & HDI container
• Connections, HANA Cloud Connector, security & authorizations
• Integration of source systems (SAC, Datasphere, BW, S/4HANA, ECC, non-SAP)
• System monitoring, performance optimization and support

Programming & Development

• CDS views programming (ABAP CDS, annotations, associations)
• AMDP & ABAP (transformations, routines, user exits, BADIs)
• SAC scripting (stories & planning) and custom widgets
• HANA SQLScript (procedures, logic at DB layer)
• SAP UI5 & JavaScript for Fiori/web frontends
• Other web & script languages: PHP, jQuery, HTML, CSS, Visual Basic

Modules & Business Areas

Expertise in numerous SAP modules and business processes, including:

• Finance & Controlling:
  FI – Financial Accounting,
  CO – Controlling,
  CO-PA – Controlling – Profitability Analysis,
  EC-PCA – Enterprise Controlling – Profit Center Accounting,
  BCM – Bank Communication Management,
  BPC – Business Planning and Consolidation
• Procurement & Logistics:
  MM – Materials Management,
  MM-PUR – Purchasing,
  MM-IM – Inventory Management,
  MM-MRP – Material Requirements Planning,
  MM-IV – Invoice Verification,
  MM-VIS – Merchandise Calculation,
  SD – Sales and Distribution,
  SD-PR – Sales Pricing,
  PP – Production Planning,
  POS DM – Point of Sale Data Management
• Service & Maintenance:
  SM – Service Management,
  CS – Customer Service,
  PM – Plant Maintenance
• Real Estate & Time Management:
  RE-FX – Flexible Real Estate Management,
  CATS – Cross-Application Time Sheet
• HR & CRM:
  HCM – Human Capital Management,
  HR – Human Resources,
  CRM – Customer Relationship Management
• Planning & Reporting:
  BW-IP – Business Warehouse Integrated Planning

Working Methods & Services

• Requirements analysis, design & architecture consulting in analytics
• Migration of large data volumes (incl. big data and system changes)
• Review & documentation of existing BW/analytics landscapes
• Integration test execution and support for kernel/system upgrades
• Know-how transfer, workshops on BW data modeling and ABAP development
• Training and support for key users (2nd & 3rd level support)