BW Hana Mumbai

Job Description

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: 3 to 9 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 Hands 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 SLTSalary: Not Disclosed by RecruiterIndustry: IT-Software / Software ServicesFunctional Area: IT Software - Application Programming, MaintenanceRole Category: Programming & DesignRole: Team Lead/Technical LeadEmployment Type: Full Time, Permanent ,

Keyskills :
sapbwonhana rootcauseanalysis sapbi sapbw saphana powerbi rootcause userexits flatfiles datamodels dataquality datamodeling reportingtools validationrules storedprocedures workingexperience systemarchitecture architecturaldesign tatement