SAP Data Modeling

Tata Consultancy Services; Pune District; On-site; INR 3,200,000 - 4,600,000; Full time

Job summary

Tata Consultancy Services in Pune is seeking an experienced SAP BI/HANA consultant to lead modelling, development and reporting across SAP BW, HANA native and related BI tools. You will interact with client managers, translate requirements into robust data models and drive delivery of complex BI solutions.

Strong hands-on experience with SAP BW on HANA, native HANA modelling, data provisioning, and familiarity with S/4HANA or BW/4HANA is preferred.

Qualifications

• Experience delivering SAP BI/HANA solutions in large environments.
• Strong modelling, design and development of BW/HANA based solutions.
• Knowledge of data provisioning and replication tools.
• Expertise with reporting tools including BOBJ, SAC, Tableau, Power BI.

Responsibilities

• Expertise with Native HANA modelling - design and debug views.
• Understand transport mechanisms using CHARM or similar tools.
• Provide strong reporting capabilities with SAC, Tableau, BOBJ.
• Work with BW on HANA and SAP ECC functional areas; BW/4HANA knowledge preferred.

Skills

SAP BW/HANA modelling

Analytical & communication skills

Client interaction

SAC/Tableau/BOBJ reporting knowledge

Tools

SAP Business Objects

Tableau

Power BI

SAP SAC

LT Replication Server

Data Services

SQL Script

XSJS / OData / Web services

Job description

• At least 7+ years of experience in SAP BW/HANA modelling and reporting
• Primary responsibility to deliver technical and functional aspects of the SAP BI / HANA solution.
• Strong in design, development, implementation and support of SAP BW and HANA based solutions including SAP Business Warehouse (BW), Enterprise (Native) HANA and SAP BI/Business Objects in large and complex environments.
• Experience with SAP (Native) HANA data modeling, schema management, content import & export, data provisioning technology including SAP LT Replication Server and Data Services.
• Knowledge of various reporting tools like SAP Business Objects (BOBJ) SAP SAC Tableau, Power BI SAC
• Good to have experience with SAP (Native) HANA and SAP BW Security concepts including User Management, Roles, and Privileges.
• Expert hands-on knowledge in BW4/HANA, NW BW 7.x and HANA architecture and features
• Proficient on Business Warehouse modeling components such as Info objects, Datastore objects, Multi-providers, Virtual providers, Open hubs Composite providers, open ODS, ADSO, etc.
• Should have good functional knowledge on commonly used SAP modules
• Strong Analytical and Communication skills, with capability to interact directly with client manager

Key Responsibilities*

• Expertise with Native HANA MODELLING - Designing Views (Attribute View, Analytic View, Calculation View), Stacked Calculation Views, Views that needs multiple table functions, counters, Restricted and Calculated measures, input parameters, filters, transparent filters. Debugging Views. HANA Modeling using SQL Script and CESQL scripting. Also trained on XSJS, OData, web services, SDI/SDA.
• Understand the Transport mechanism using CHARM or similar tool
• Strong reporting knowledge using Analytical tools like SAC, Tableau, BOBJ etc.
• Strong Working Experience of SAP BW on HANA, Native HANA, SAP ECC Functional (FI, OTC, WHM etc.) is a must.
• Working knowledge of S/4HANA or BW/4HANA is preferably