SAP Hana BW Consultant
Intellipro Group
Richmond, VA
Description:
SAP BW4HANA and Embeded Analytics Developer
Hybrid Onsite
1 week Office, 1 week Remote
This position is for an experienced resource to develop B4 HANA models using Advanced DSOs (ADSO), Open ODS View, Composite Providers and HANA Analysis Processes (HAP). Develop XSA for HANA framework, HANA models using Calculation Views (Graphical & Scripted), Procedures, Decision Tables, Analytic Privileges, Packages, Schemas, Delivery Units etc.
Specific responsibilities include:
- Strong experience in Native HANA and BW on HANA involving data modeling, data provisioning, reporting and security areas
- Strong knowledge in integrating BW with S4 HANA for Utilities, SAP Service Cloud, HR, FI & MM
- Experience implementing SAP HANA & BW projects including Requirement Gathering, Design, Development, Unit Testing, Integration Testing, UAT, Documentation, Deployment and End User Training
- Experience in modeling B/4 HANA objects like Advanced DSOs (ADSO), Open ODS View, Composite Providers and HANA Analysis Processes (HAP)
- Expertise in designing solutions involving SAP HANA models in BW & BW models in HANA and provided solutions for Mixed Scenarios reporting for EDW on HANA Implementation projects
- Experience with SAP Embedded Analytical and Integrated planning
- Extensively worked on creating HANA Views to cater the requirements
- Extensively worked on HANA Calculation Views (Graphical and Scripted) and HANA CDS views
- Experience in extracting data from anyDB (Oracle, MSSQL, etc.,) to HANA using Smart Data Integration (SDI) involving complex mappings to transform data into the required target format
- Involved in creating Native HANA Applications using XSJS, OData services, CDS Views
- Knowledge on working with Virtual Data Models (Consumption Views, Extension Views and Interface Views involving Basis and Composite Views) covering role based operational reports for lines of business
- Experience with SAP HANA XSA development (Language, syntax, OData, XSA command tool)
- Experience on replicating real-time data from different SAP sources to SAP HANA using Data Services, SAP LT replication server (SLT), Smart Data Integration (SDI) and Smart Data Access (SDA)
- Expertise in creating HANA relevant objects like Attribute Views, Analytical Views, Calculation Views, Analytical Privileges, Stored Procedures, Scripting Calculation Views for accommodating complex business scenarios
- Experience in creating and consuming Virtual Tables in HANA Modeling, using SDA to access data stored in remote data sources
- Experience in SAP BW Data modeling of InfoCube, MultiProvider, Virtual Provider, Transient Provider, Composite Provider, DSO, InfoObjects, SPO, Datasource, Transformation & DTP, Process Chains, Open Hub Destination (OHD) and APD
- Experience on replicating real-time data from different SAP sources to SAP HANA using Data Services, SAP LT replication server (SLT), Smart Data Integration (SDI) and Smart Data Access (SDA)
- Expertise in creating HANA relevant objects like Attribute Views, Analytical Views, Calculation Views, Analytical Privileges, Stored Procedures, Scripting Calculation Views for accommodating complex business scenarios
- Experience with SAP BPC 10.x is a PLUS
- Create and maintain high level implementation plans, design documentation, and data and process models
- Work with the users, technical and solution architects to define the data requirements and structure for the application
- Model and design the application data structure, storage, and integration
- Prepare data for testing, execute and verify test cycles