Sap Bw Hana Consultant

Tekskills; Gurugram District; On-site; INR 1,400,000 - 2,200,000; Full time

Job summary

Tekskills in Gurugram is seeking a SAP BW/HANA expert to own end-to-end delivery across multiple waves including discovery, blueprinting, design, build, and hypercare. You will model data on HANA-optimized BW with ADSOs, Open ODS Views, and CompositeProviders, and work with SAP Data Services and ODP extractors.

You will optimize performance, implement HANA-native artifacts, and ensure secure, compliant data processes across integration landscapes.

Qualifications

• Experience with SAP BW / HANA environments (ADSOs, CompositeProviders, Open ODS Views, InfoObjects).
• Proficient in HANA calculation views, SQLScript and data modeling.
• Exposure to SLT/SDI/SDO integration and ABAP extractors is a plus.
• Knowledge of BW/4HANA performance optimization techniques and RSRT/RSRV tooling.

Responsibilities

• Own end-to-end lifecycle across multiple waves: discovery to steady-state transition.
• Design and implement data models on HANA-optimized BW.
• Create and optimize HANA-native artifacts (calculation views, procedures).
• Lead integration design using SLT/SDI/SDA, ODP, CDS and BW extractors.
• Drive performance engineering: SQLScript optimization, pushdown, aggregates, partitioning.
• Ensure security and compliance for GDPR/PII in BW/HANA data.
• Manage transport and change with CTS+/Charm and related tooling.
• Support reporting enablement with BEx/Analysis for Office and SAC connections.

Skills

SAP BW on HANA / BW/4HANA

HANA modeling

Data integration

Performance tuning

Security & compliance

Transport management

Reporting & analytics

Tools

Solution Manager

Jira

Azure DevOps

Git

ServiceNow

Job description

Technical

• SAP BW on HANA / BW/4HANA:
  
  
  
  • ADSOs (all types), CompositeProviders, Open ODS Views, InfoObjects, Transformations, DTPs, Process Chains, AMDP routines, and FOX formulas (if relevant).
  
  
  • Query design: Variables, conditions, exceptions, structures, restricted/calculated key figures, currency/unit conversions.
  
  
  • HANA modeling: Calculation Views (DIM/CUBE), SQLScript, table functions, performance tracing (PlanViz), calculation engine behavior.
  
  
  
  


• Integration & Data Movement: SLT, ODP, SDA/SDI, SAP Data Services (BODS), ABAP extractors, CDS-based extraction, flat files/SFTP, and scheduling/orchestration.


• Performance & Operations: RSRT, ST05, RSRV, RSPC, RSPM, dumps/logs analysis, delta handling, data volume/partitioning strategies, housekeeping.


• Security/Compliance: Analysis authorizations, HANA privileges, compliance for sensitive data (GDPR/PII), auditability.


• Tooling: Solution Manager/Charm or equivalent ALM, Jira/Azure DevOps, Git (where applicable), ServiceNow (incidents/changes), MS Office/Visio.

Solutioning & Delivery

• Own E2E lifecycle across multiple waves: discovery, blueprinting, detailed design, build, test, cutover, hypercare, and steadystate transition.


• Data modeling on HANA-optimized BW: ADSOs, Open ODS Views, CompositeProviders, InfoObjects, BW Queries, and virtual models.


• HANA-native artifacts: Calculation Views (SQLScript/Graphical), table functions, procedures, hierarchies, variables, and performanceaware modeling (partitioning, pruning).


• Integration design: SLT/SDA/SDI, SAP Data Services, ODP (SAPI/ABAP CDS extractors), CDS Views exposure, BAPI/RFC/BW extractors, flat files, and APIs.


• Performance engineering: SQLScript optimization, pushdown to HANA, BW query performance analysis (RSRT), aggregates, compression, process chain optimization, parallelization.


• Authorizations & security: BW analysis authorizations (RSECADMIN), HANA privileges/analytic privileges, data masking/PII handling.


• Transport management: CTS+/Charm, retrofit strategies across multitrack landscapes.


• Reporting & analytics enablement: BEx/Analysis for Office, SAP Analytics Cloud (SAC), and integration with thirdparty BI (e.g., Power BI via HANA/BW connectors).


• Data quality & governance: Data profiling, cleansing, reconciliation, lineage, and documentation with functional ownership.


• Cutover & hypercare: Data loads, reconciliations, defect triage, root cause analysis (RCA), and stabilization.