SAP BW on HANA

Tekskills; Chennai District; On-site; INR 1,800,000 - 2,400,000; Full time

Job summary

Tekskills in Chennai seeks an experienced SAP BW on HANA professional to own the end-to-end data lifecycle across multiple waves—from discovery to steady-state transition. You will design and implement ADSOs, CompositeProviders, Open ODS Views, and BW queries, ensuring robust data modeling and scalable solutions.

You will drive integration design, performance engineering, security, and governance, working with SLT/SDI, BODS, and CDS extractors.

Qualifications

• Minimum 5+ years of SAP BW on HANA experience.
• Strong knowledge of ADSOs, CompositeProviders and Open ODS Views.
• Experience with HANA modeling and performance tuning.

Responsibilities

• Own E2E lifecycle across multiple waves: discovery, blueprinting, detailed design, build, test, cutover, hypercare, steady-state transition.
• Data modeling on HANA-optimized BW: ADSOs, Open ODS Views, CompositeProviders, InfoObjects, BW Queries.
• Develop HANA-native artifacts: Calculation Views, SQLScript, table functions, performance-aware modeling.
• Design integration: SLT/SDI, SAP Data Services, ODP, CDS data extraction, flat files, APIs.
• Drive performance engineering: pushdown, RSRT analysis, aggregates and partitioning.
• Ensure security & compliance: BW authorizations, HANA privileges, data masking.
• Manage transport: CTS+/Charm and cross-landscape strategies.
• Enable reporting: BEx/Analysis for Office, SAC, and BI connectors.
• Promote data quality & governance: profiling, reconciliation, lineage.
• Lead cutover & hypercare activities: data loads, reconciliations, RCA.

Skills

SAP BW on HANA

BW/4HANA

ADSOs

CompositeProviders

Open ODS Views

InfoObjects

DTPs

Transformations

Calculation Views

SQLScript

Education

Bachelor's degree in IT/CS

Tools

Solution Manager

Jira

Git

MS Office

Job description

Job description :

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