EY TC_SAP_SAP BW HANA_Staff in Chennai, India
TCSAPSAP BW HANA_Staff
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
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