Scope of work:
This position will serve to reinforce the ERP project's capacity for the development of BI, particularly with respect to design/redesign of data models and semantic layer as well as the related reporting structure, etc, including with respect to extraction and synchronization across the different SAP systems for data aggregation and reporting. Finance Data modeling and front-end Reporting visualization focus.
The design and build of new HANA data models and data reporting structure would be of particular importance, including in respect of the related extraction methods using SLT and BODS, as well as in connection with the landscape infrastructure and platform upgrades for HANA.
Expertise on BI and data modeling for the below functional areas in SAP is specifically required:
Funds Management (FM)
Grants Management (GM)
Business Planning and Consolidation (BPC)
The scope of work includes Front-end reporting visualization using the SAP systems to integrate data sources to HANA for sourcing data [oData Services, CDS view, etc] in order to develop Front-end Reports using Web Intelligence, Crystal Reports, Analysis Workspace and other reporting tools.
Under the supervision of Senior ERP officer, the SAP BW/HANA Consultant will be responsible for the following technical duties:
A. SAP BW [Business Warehouse] and Hana Modelling
SAP BW modelling with respect to SAP HANA using composite providers, Advance DSOs, ODP, LSA ++ and using BW objects exposed as HANA views.
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],
Analysis, design and modeling for the main SAP functional areas used at United Nations: Accounting (FI), Fund Management (FM), Grants (GM), Budgets Planning and consolidation (BPC).
Development of ABAP-programmed CDS views in Gateway Front End and Back End Servers.
Development of HANA Design time repository objects and HANA Hierarchies using standard and advanced HANA 2.0 functionalities.
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. Front-end Reporting and Data Visualization:
Development of advanced visualization scenarios using SAP tools and systems and integration to HANA for data sourcing.
Development of Front-end Reports using Web Intelligence, Crystal Reports, Analysis Workspace and other reporting tools.
Hands-on experience on building calculation views used for HanaXS oData supporting Fiori Analytical Applications.
EXPERIENCE and SKILL REQUIREMENTS [desirable composite summary]:
At least ten years of experience on development of Data Modelling and BI in SAP [HANA, HANA Live Content and BW/BI] with experience on end-to-end BW on HANA implementation.
At least 5 years of experience on BI development and reporting for the wider SAP Finance areas
[particularly, Accounting (FI); Funds Management (FM); Grants (GM); and BPC].
Experience shall include review of functional specifications for queries and other objects for BW/HANA Data Models, designing/creating Info Objects, Info Sources, Transfer structures, Communication structures, Standard and Custom Info Cubes, Data Store Object (DSO).
Implementing SAP BW on HANA-specific modelling [like Composite Providers and exposing BW objects in HANA Views, Operational Data Provisioning, LSA++, etc] and developing and handling of hybrid scenarios - BW data models and HANA views [Schemas and tables on HANA, attribute view, analytical view and Calculation views].
Experience managing SAP BW tables in HANA distribution environment and integration of BW/BO/HANA.
Extensive experience in Data extraction from SAP and non-SAP source systems, including BODS, SLT and data transformation in SAP BW.
Experience in Data loading, Monitoring and Scheduling using Process Chain.
Expertise in design and build of reports [WEB Intelligence Reporting, Crystal reports, Open Hub Concept, including documenting the design and analysis of reports using Analysis Workspace.
Experience with BEX Analyzer to build Queries using Filters, Variables, Structures, Restricted Key Figures, Calculated Key Figures, Conditions, Exceptions and aggregation for reusable queries.
Experience on 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 on SAP User Interface application using SAPUI5, FIORI with integration to data sources using oData Services, CDS view, etc.
Basic understanding of the related administration of SAP Systems, particularly R/3 and ECC 6.0, and including security for BI.
Technical and programming skills:
Advanced ABAP programming, BADI, User Exits.
Extensive experience in scripting:
SQL using advanced SQL and HANA Functions.
Java Script with knowledge in server-side scripting [XSJS and node.js]
For Immediate Response call 732-876-7620, or send your resume to RecruiterAJ@Trigyn.com
TRIGYN TECHNOLOGIES, INC. is an EQUAL OPPORTUNITY EMPLOYER and has been in business for 30 years. TRIGYN is an ISO 9001:2015, ISO 27001:2013 (ISMS) and CMMI Level 3 certified company.