SAC & Datasphere Data Governance Reporting.
Introduction of a data governance reporting to report master data quality in customer, vendor and material master data. Datasphere was used as the data warehousing solution and SAC as the frontend.
Project management
Workshop facilitation
Solution architecture design
Development team coordination
Solution presentation
Skills:*
SAP Datasphere
SAP Analytics Cloud
MS Azure reporting based on SAP BW data.
Connection of SAP BW 7.5 on HANA to MS Azure via Azure Data Factory.
Solution architecture design
Development team coordination
Customer workshops
Requirements analysis and capture
Solution presentation
Skills:*
Microsoft Azure
Azure Data Factory
Azure Data Lake Storage
Azure Synapse
SAP BW 7.5 on HANA
AWS PoC + SAP BW support.
The project aimed at partial offloading of SAP BW data to Amazon Web Services – specifically to S3 and Athena – and reintegration of the data into the existing SAP BW data models via Smart Data Access.
Additionally, connection and building of data models in SAP BW on HANA for SAP SuccessFactors (Recruiting).
Project management
Solution design
SDA setup
AWS tool integration
SuccessFactors integration via SDI
Data modeling in SAP BW
Skills:*
SAP Smart Data Integration (SDI)
SAP Smart Data Access (SDA)
SAP BW 7.5 on HANA
Amazon Athena
Amazon S3
SAC marketing reporting based on Google Analytics and BigQuery.
Introduction of SAC reporting based on data from Google Analytics (marketing), SAP Marketing Cloud (campaign data), SAP BW (SD data) and Sprinklr (social media data). Google BigQuery was used as the combined database, where the non-SAP data was loaded and combined with the SAP BW data via Smart Data Access (SDA). SAP Analytics Cloud reports were then created based on the SDA models.
Project management
Technical solution rollout
Conceptual rollout (target landscape design and use cases)
Google environment setup
Data model development in Google BigQuery
Data flow scheduling with Google DataForm
GCP integration with live access to BigQuery/Cloud Storage
SAC training for customer stakeholders
Skills:*
SAP BW 7.5 on HANA
SAP Analytics Cloud
SAP Smart Data Access (SDA)
Google BigQuery
Google Cloud Platform (GCP)
Google DataForm
Google Analytics
Google Cloud Storage
Future data platform design.
Series of workshops to design the customer’s future analytics landscape, considering the existing architecture and requirements.
Challenge: migrate the existing SAP Analytics landscape to a newer version (BW/4 or Datasphere) and integrate it with analytics applications (data lake/machine learning) in GCP.
Requirements analysis
SAP BW 7.5 on Oracle system analysis
Review of existing GCP applications (BigQuery, Cloud Storage)
Target architecture definition/design
SAP Datasphere evaluation
Workshop moderation
Target concept development
Results presentation
Skills:*
SAP Datasphere
SAP Analytics Cloud
SAP BW 7.5 on AnyDB
SAP BW/4HANA
Google BigQuery
Google Cloud Platform (GCP)
Google Cloud Storage
Building the "Business Analytics Platform" area for SAP and non-SAP
Introduction of SAP BW Bridge for SAP DWC in ramp-up.
One of the first customers to implement SAP BW Bridge for the existing SAP DWC in ramp-up.
Project management
Coordination with SAP
Technical rollout (Data Warehouse Cloud/Datasphere)
Conceptual rollout (target landscape design and use cases)
Feasibility study on whether migrating SAP BW on HANA to BW/4 via Data Warehouse Cloud/Datasphere + Bridge becomes obsolete
GCP integration with live access to BigQuery/Cloud Storage
Results presentation at an SAP event
Skills:*
SAP Datasphere
SAP BW Bridge
SAP Data Provisioning Agent (DP Agent)
SAP BW 7.5 on HANA
Predictive Sales.
Introduction of AI-based sales lead generation using existing customer master data, orders and revenues from the last 10 years.
Project Manager:*
Project management
Requirements gathering and analysis
Results presentation
Stakeholder management
Internal customer acquisition
Senior Developer:*
Building necessary data structures in SAP BW on HANA 7.5
Automated data transfer from SAP BW to Google BigQuery
Setup of Google Cloud Vertex AI Engine to run Jupyter Notebooks with Python code (AI/ML calculations)
Data flow and structure setup for importing AI results back into SAP BW
SAC report creation for end-user result evaluation
BEx Query design and creation
Skills:*
Google BigQuery
Google Cloud Platform (GCP)
Google Cloud Storage
SNP Glue
Machine Learning
Python
Jupyter Notebooks
SAP BW 7.5 on HANA
SAP Analytics Cloud
Test management
Scrum
BEx Query Designer
Cloud Data Warehouse implementation based on Google BigQuery.
Build and launch a cloud DWH on GCP. Data ingestion from source systems was handled via Google Cloud Dataflow; data storage was set up in Google BigQuery. Process control and scheduling were done using Google Cloud Composer (Apache Airflow). Main data sources were SAP BW, Salesforce and Google Analytics.
Project management
Coordination of Google specialists with the SAP project team
Creation of sender data structures in SAP BW
Table and structure setup in Google BigQuery
Bidirectional data exchange connection between BigQuery and SAP BW
Skills:*
SAP HANA 2.0
Apache Airflow
Google Cloud Composer
Google Cloud Dataflow
Google Cloud Storage
Google Cloud Platform (GCP)
Google BigQuery
SAP Smart Data Access (SDA)
Test management
Scrum
Sales Forecast.
Forecasting future company revenues based on current and historical business figures for the CFO. Used machine learning algorithms (Python) with Jupyter Notebooks in GCP.
Project management
Requirements analysis and CFO coordination
Data scientist coordination
Connecting result data to SAP BW
SAC report creation
BEx Query design and creation
Skills:*
SAP Analytics Cloud
SAP BW 7.5 on HANA
SAP HANA 2.0
SAP Smart Data Access (SDA)
SAP Analytics Cloud Analytics Designer
ABAP
Google Cloud Platform (GCP)
Google BigQuery
SNP Glue
Test management
Scrum
BEx Query Designer
Sales Funnel Reporting rollout.
Introduction of sales funnel reporting based on Salesforce CRM data using SAP BW on HANA and SAP Analytics Cloud.
Project management
Stakeholder management
Requirements gathering through workshops
Development: building data structures
SAC report creation
Agile SCRUM approach
BEx Query design and creation
Skills:*
SAP Analytics Cloud
SAP HANA 2.0
SAP BW 7.5 on HANA
SAP Smart Data Access (SDA)
SAP Analytics Cloud Analytics Designer
ABAP
Google Cloud Platform (GCP)
Google BigQuery
Test management
BEx Query Designer
Scrum
Salesforce Sales Cloud
Ramp-up of SAP Data Warehouse Cloud (DWC).
Introduction of SAP Data Warehouse Cloud / Datasphere as a ramp-up project with SAP. Integration of existing SAP BW systems via Data Provisioning Agent. SAP Analytics Cloud remained the reporting frontend.
Project management
Coordination with SAP
Coordination with internal IT (infrastructure and SAP development)
Test management
Target landscape design
DP-Agent setup
Demo data model creation in Data Warehouse Cloud / Datasphere
Skills:*
SAP Datasphere
SAP Data Provisioning Agent (DP Agent)
SAP Smart Data Integration (SDI)
SAP Analytics Cloud
SAP HANA 2.0
Salesforce CRM reporting in SAP BW and SAC.
Build and launch a comprehensive CRM reporting based on Salesforce Sales Cloud. Integration of Salesforce with existing SAP BW 7.5 on HANA via HANA Smart Data Integration. Creation of BW data structures and deployment of CRM reports in SAP Analytics Cloud.
Project Manager:*
Project management
Procurement of HANA SDI Salesforce adapter
Stakeholder management
Workshop series with business users to gather requirements
Test management
BEx Query design and creation
Agile SCRUM approach
Solution Architect:*
Future system landscape design
Data integration design
HANA object creation
Data structure and load process development
SAC report development
Skills:*
Salesforce Sales Cloud
SAP Analytics Cloud
SAP BW 7.5 on HANA
SAP HANA 2.0
SAP Smart Data Integration (SDI)
SAP Analytics Cloud Analytics Designer
Test management
Scrum
BEx Query Designer
Upgrade from SAP BW 7.40 to 7.50 on HANA.
Project to upgrade BW 7.40 SP13 on HANA to BW 7.50 SP13 on HANA.
Project Manager:*
Project management
Testing and test coordination
SAP Basis service provider coordination
Senior Developer:*
ABAP code adjustments
Note implementation
Skills:*
ABAP
SAP Analysis for Office
SAP Analytics Cloud
SAP HANA 1.x
SAP BW 7.5 on HANA
Test management
SAP BW 7.x on HANA
Branch Manager Cockpit introduction.
Migration of existing WAD reports (around 25) to the Branch Manager Cockpit – SAC stories.
Project Manager:*
Project management
Stakeholder management
Agile SCRUM approach
Senior Developer:*
Authorization setup
SAC structure setup
BEx Query definition and creation
SAC story creation and linking
Skills:*
SAP Analytics Cloud
SAP HANA 1.x
SAP BW 7.x on HANA
SAP Analysis for Office
ABAP
BEx Query Designer
Scrum
BEx Web Application Designer
Upgrade SAP BO 4.1 to BO 4.2.
Upgrade of SAP Business Objects Enterprise Platform 4.1 to 4.2 SP06 including frontend add-ons for Lumira Designer and Crystal Reports.
Project management
Test management
Stakeholder management
External service provider coordination
Skills:*
Crystal Reports
SAP Business Objects
SAP Design Studio 1.6
SAP Lumira
SAP Analytics Cloud introduction.
Introduction of SAP Analytics Cloud as a frontend tool to replace Lumira Designer and Web Application Designer 7.x for 1900 users.
Project Manager:*
Project management
Study with business users on use of existing reports
Derivation of future requirements and use cases for cloud technology (e.g. mobile use, shift from list reports to dashboards)
Introduction of agile development practices
Presentation at internal customer fair
Senior Developer:*
Setup of Apache Reverse Proxy on AWS servers for live data connections
SAP BW 7.40 preparation via note implementations and code adjustments
SAC report creation and rollout
Authorization concept development
BEx Query design and creation
Skills:*
SAP BW 7.x on HANA
SAP Analytics Cloud
Apache Reverse Proxy
CORS
ABAP
Scrum
BEx Query Designer
Migration SAP BW 7.31 on Oracle to SAP BW 7.40 on HANA.
Migration of existing SAP BW 7.31 on Oracle to SAP BW 7.40 on HANA (SUM-DMO).
Project Manager:*
Project management
Stakeholder management
Test management coordination
SAP coordination
Senior Developer:*
Housekeeping and data archiving to shrink DB size
Note implementations
ABAP code adjustments
Function testing
Skills:*
ABAP
SAP BW 7.x on AnyDB
SAP BW 7.x on HANA
SAP HANA 1.x
SAP Analysis for Office
BEx Query Designer
BEx Web Application Designer
BOE 4.1 Platform introduction including Analysis for Office and Crystal Reports.
Introduction of SAP Business Objects 4.1 Platform with frontend tools Analysis for Office 1.2 and Crystal Reports.
Project management
Stakeholder management
Technical BO Platform setup
Connection to existing SAP BW 7.01
Coordination with infrastructure IT for SMS software distribution package for Analysis for Office
Crystal Report prototype (report book for branch managers)
Test management
Skills:*
SAP Business Objects
SAP Analysis for Office
Crystal Reports
SAP Lumira
SAP Design Studio 1.6
Discover other experts with similar qualifications and experience