EY Jobs

TCSAPSAP BW HANA_Staff

Consulting

Requisition # CHN000ID

Post Date Jan 08, 2021

Purpose and Objectives:

The SAP BI & Analytics looking for SAP BW HANA professionals with experience in SAP BW & HANA to work on various projects for our customers across the globe.

Skills and Experience:

• 6 to 11 Years of experience in SAP BI/BW, HANA Native Modelling & reporting.

• Experience on BW on HANA modelling components such as Composite providers, ADSO and Virtual Info-providers, Open ODS.

• Experience in mixed scenarios with BW and HANA models.

• Working experience on BW on HANA, BW versions 7.4 & 7.5 and BW4HANA are preferred

• Should have experience on HANA modelling, graphical calculation view, scripted calculation view, also knowledge of HANA SQL and

• Experience with various Data Provisioning technique included SAP SLT, SDI

• Good to have BW4HANA upgrade or migration project experience which includes familiar with BW Cockpit activities, Routine/Code Adjustment, 3.x to 7.x conversion, ODP framework

• Good to have Knowledge on In-Place and Remote conversion activities

• Scripting experience including ability to write complex stored procedures and HANA views using SQL, to enhance the data models in SAP HANA using AFL, CE functions, and ANSI-SQL.

• Administer data models in SAP HANA, including setting of information validation rules, managing schemas, the importing/exporting and transporting of data models.

• Apply advanced data modelling techniques, including currency conversion, variables and input parameters. Implement decision automation using business rules.

• Monitor, investigate and optimize data models and reporting performance on SAP HANA. Advise on modelling approach and tools to achieve optimum performance.

• Evaluate the impact of different implementation options such as table joins, aggregation, or filters. Understand the implication on performance of the various reporting tools and connection types

• Knowledge about the concept of authorization in SAP HANA, and implement a security model using analytic privileges, SQL privileges, pre-defined roles and schemas.

• Good Understanding of ABAP, extractor enhancement, user exits, customer exits, ABAP on HANA coding principles and PL/SQL

• Hand’s on experience of LO cockpit based extractions, setup tables, cutover plan.

• Must be experienced in developing BEx Queries and integration with BO reporting tools

• Proficient in SAP BI/BW Back-end development and configuration, testing and pre-production support, Performance Optimization

• Responsible for root cause analysis and providing solutions for production and development issues

• Sound knowledge of data provisioning into the SAP HANA database using SLT, BODS bringing data from ECC and Flat files, BODS

• SAP BI Analytics on HANA views using Lumira, BOBJ, Excel

Responsibilities :

• Strong hand’s on experience of HANA Modelling: Table creation (row store, column store), ABAP Procedures, data modelling, modelling views (Calculation, Attributes views), decision tables, analytical privilege

• Experience in HANA Programming including SQL scripting, windows functions, CDS Views

• Experience in all scenario: ODP, Table based, Application based with S/4 HANA system for both SAP and Non-SAP systems

• Need to work as a team leader (technical leader) to contribute in various technical streams of cloud implementation project.

• Planning and monitoring of the project deliverables from the team.

• Mentor the project team in executing the identified projects

• Regular status reporting to the Manager and onsite coordinators

• Interface with the customer representatives as and when needed

• Willing to travel to the customers locations on need basis

Nice to have:

• Knowledge of SAP ABAP and SAP Basis

• Experience in data provisioning using smart data access/ smart data Quality (SDI/SDQ)

• Working knowledge in SLT- both table and application based replication

• SLT performance optimization concepts(Reading type, master job)

• Create and configure connection SLT to HANA

• Create and configure connection SLT to ECC

• Good to have experience with visualization tools like SAC, Lumira, Tableau, Qlikview, Power BI, Fiori