Job Description :
Scope of work:

SAP-BW/HANA is an advanced computing platform designed to accelerate business processes, deliver stronger data intelligence, simplifying the traditional data warehousing architecture and maximizing the speed and scale of reporting by reducing the complexity of data movement and preparation as well as reinforcing the ability and agility to integrate and aggregate enterprise data into a single view in order to facilitate decision-making.

This position will serve to reinforce the ERP project''s capacity for the development of SAP BW/HANA in the Umoja solution, particularly to design and build new functionality of the HANA data models data reporting structure, extraction using SLT and BODS, analysis of the landscape infrastructure and HANA platform upgrades.

Techno-functional duties:

Under the supervision of Senior ERP officer, the SAP BW/HANA Consultant will be responsible for the following technical duties:

A. HANA Data Modelling

Data sourcing for HANA modelling [Extraction, Transformation and Load (ETL) jobs in BODS/SLT for transferring data from SAP and non-SAP systems]
Design of SAP HANA data modelling objects [using Attribute View, Analytic View, Calculation View, Scripted views, Procedures, Table functions and Triggers],
Development of ABAP-programmed CDS views in Gateway Front End and Back End Servers.
Development of HANA Design time repository objects and transport to upper landscapes.
Development of HANA Hierarchies using standard and advanced HANA 2.0 functionalities.
Design and Build in HANA XS Advanced Runtime with exposure to microservices architecture with support to multi language runtimes like Node.js , Java, C++ including the setup of XSA identity provider.
Experience with HANA Live Content
Design, implement, and monitor of SAP SLT replication schemas in SAP HANA [real time synchronization].
Monitoring/reviewing the quality and integrity of the reporting objects, including optimization of HANA model performance by analyzing Expensive Statement Trace, SQL Plan Cache, Runtime Statistics, Plan Visualization Etc.
Development of use cases and prototypes for different business scenarios for showcasing the capabilities and give management the options during decision making process

B. SAP BW [Business Warehouse]

Experience in Data-Modelling, Data Extraction, Data Loading, Scheduling, Monitoring, Reporting and Performance Tuning.
Experience in ABAP programming, BADI, User Exits.
Extensively worked on designing/creating Info Objects, Info Sources, Transfer structures, Communication structures, Standard and Custom Info Cubes, Data Store Object (DSO
Having expertise in understanding the R/3 and ECC 6.0 System and considerable experience in SAP BW/BI, documenting, design and Analysis of reports Using Analysis Workspace.
Performed LO Cockpit extraction, Knowledgeable in LIS, Generic and CO-PA extraction.
Expertise in Report Generation. Worked extensively on BEx Analyzer in building Queries using Filters, Variables, Structures, Restricted Key Figures, Calculated Key Figures, Conditions, Exceptions and created aggregates for frequently used queries.
Knowledge On WEB Intelligence Reporting, Crystal reports, Open Hub Concept.
Experience in Data loading, Monitoring and Scheduling using Process Chain.

C. Front End Reporting and Data Visualization:

Development and customization of SAP User Interface application using SAPUI5, FIORI with integration to data sources using oData Services, CDS view, etc.
Development of advanced visualization scenarios using Tableau and SAP Lumira and integration to HANA for sourcing data.
Development of Front End Reports using Web Intelligence, Crystal Reports, Analysis Workspace and other reporting tools.

Experience and skill requirements:

At least ten years of full-time progressive experience on BW/HANA development.

Advanced ABAP programming.

Extensive experience in scripting:
i. SQL using advanced SQL and HANA Functions.
ii. Java Script with knowledge in server side scripting like XSJS and node.js

Ability to review functional specifications for data models, data reports, queries and other objects for BW/HANA Data Models.

Experience in data extraction and loading from SAP and non-SAP source systems, including
BODS, SLT and data transformation in SAP BW.

Ability to develop and review technical specifications and documentation