DigiHelic Solutions - SAP HANA Consultant - Data Services (3-6 yrs)

Experience : 3+ yrs.

Location : PAN India ,Hybrid.

Job Description :

- Extensive experience with HANA modelling (V1. 0 SP 12 and newer).

- Business analysis capabilities (ability to interact directly with business user to establish requirements for modelling).

- Domain expertise a very strong generalist would be preferred, and if specialized, then expertise in Finance (especially management and corporate reporting).

- Technical HANA expertise (security, BASIS, administration).

Provide HANA modelling and architect services including :

- Develop reusable HANA models in accordance with consolidated design principles and documented design detail including an attempted definition and identification of all tables, fields, joins, filters, formulas/logic/calculations and any other business and data requirements.

- HANA data models with consumption of Hierarchies, Calculated Columns.

- SAP HANA modelling and scripting experience including ability to write complex stored procedures, Table Functions 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.

- 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.

- Assist in the elicitation and documentation of requirements on occasion where it is beneficial to the project and/or deliverable.

- Identify new and/or updated cross reference table architecture, modification, and integration into the reusable HANA models to capture and manage consolidated master data.

- Support project-related ETL and reporting deliverables working with the extended project team.

- Provide guidance on best-practices and architecture standards where these have not yet been put in place by the company.

- Provide input and feedback on overall solution architecture for consolidated reporting solutions, from source through ETL and modelling to data access and reporting.

- Provide functional input and expertise where applicable.

- Measurement of HANA database performance and tuning.