SAP BW/HANA
Gurgaon (Gurgaon) IT development
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.
·
Should have experience on HANA modelling, graphical calculation view, scripted calculation view, also knowledge of HANA SQL.
·
Working experience on BW on HANA, BW versions 7.4 & 7.5 are preferred
·
SAP HANA modelling and scripting experience including ability to write complex stored procedures and HANA views using 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
·
Script to enhance the data models in SAP HANA using AFL, CE functions, and ANSI-SQL.
·
Knowledge about the concept of authorization in SAP HANA, and implement a security model using analytic privileges, SQL privileges, pre-defined roles and schemas.
·
Implement data models with SAP HANA using analytical and calculated views. Should be able to advice on the modelling approach and best practices.
·
Ability to design and build complex workflows to facilitate various business requirements
·
Should have knowledge on CDS view, embedded analytics
·
Experience in data provisioning using smart data access/ smart data Quality (SDI/SDQ)
·
Good to have HANA upgrade or migration project experience
·
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
·
Proficient in design, developing & support of custom BW objects using BW LSA++ (Layered Scalable Architecture)
·
Proficient with SAP BW on HANA system architecture design and performance optimization Creates transformations,
·
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 :
·
Understand source system and analyse source data.
·
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 BW4HANA architecture
·
Good to have experience with visualization tools like Lumira, Tableau, Qlikview, Power BI, Fiori
·
Knowledge of SAP SLT
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.
·
Should have experience on HANA modelling, graphical calculation view, scripted calculation view, also knowledge of HANA SQL.
·
Working experience on BW on HANA, BW versions 7.4 & 7.5 are preferred
·
SAP HANA modelling and scripting experience including ability to write complex stored procedures and HANA views using 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
·
Script to enhance the data models in SAP HANA using AFL, CE functions, and ANSI-SQL.
·
Knowledge about the concept of authorization in SAP HANA, and implement a security model using analytic privileges, SQL privileges, pre-defined roles and schemas.
·
Implement data models with SAP HANA using analytical and calculated views. Should be able to advice on the modelling approach and best practices.
·
Ability to design and build complex workflows to facilitate various business requirements
·
Should have knowledge on CDS view, embedded analytics
·
Experience in data provisioning using smart data access/ smart data Quality (SDI/SDQ)
·
Good to have HANA upgrade or migration project experience
·
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
·
Proficient in design, developing & support of custom BW objects using BW LSA++ (Layered Scalable Architecture)
·
Proficient with SAP BW on HANA system architecture design and performance optimization Creates transformations,
·
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 :
·
Understand source system and analyse source data.
·
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 BW4HANA architecture
·
Good to have experience with visualization tools like Lumira, Tableau, Qlikview, Power BI, Fiori
·
Knowledge of SAP SLT