SAP BW HANA_Senior

Job Description

SAP BW and HANA Job Description 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

,

Keyskills :
sap bisap bwsap abapsap hanapower bisap basisroot causeuser exitsflat filesdata modelsdata qualitydata modelingsql scriptingreporting toolssap bw hana