EHANA ( Reporting and Analytics)
Also must have good HANDS EXPERIENCE ON EHANA/Native Hana.
- Expertise in EHANA object Development including HANA calculation graphical views, SQL scripted views, Scaler and table function, Stored procedures.
- Strong experience with SQL Script, PL/SQL, Stored Procedures, Function Calls, Designing Tables, Table Functions & HANA views (Calc Views).
- Apply advanced data modelling techniques, including currency conversion, variables and input parameters. Implement decision automation using business rules.
- Knowledge about the concept of authorization in SAP HANA, and implementing a security model using analytic privileges, SQL privileges, pre-defined roles, and schemas.
- Evaluate the impact of different implementation options such as table joins, aggregation, or filters.
- Should adhere to Data Architecture, Modelling and Coding guidelines.
- Preparation of Design documents and/or Technical Documents.
- Able to identify performance bottlenecks in HANA objects and tune those objects to improve performance.
- Provide and develop best practices for application development on the EHANA platform.
- Design applications to deal with real-time reporting requirements.
- Provide scalable solutions for large data volumes (Terabytes of data) and complex reporting needs.
- Perform Hands-on analysis, design and deployment of solutions.
- Monitor, investigate and optimize data models and reporting performance on SAP HANA.
- Understand the implication of the performance of the various reporting tools and connection type.
- An advantage will be given if having working experience on reporting tools such as SAP Business Objects (Webi, AO) & SAC.
- Preferred to have Tableau experience as well.
#J-18808-Ljbffr