SAP BW on HANA

Tekskills; Hyderabad; On-site; INR 2,500,000 - 4,500,000; Full time

Job summary

Tekskills is seeking a seasoned SAP BW/HANA architect to own end-to-end BI delivery across multiple waves. You will model data with ADSOs, CompositeProviders, and Open ODS Views, and craft calculation views and SQLScript for high performance.

Responsibilities include integration design (SLT/SDI/ODP), data governance, and security controls, with collaboration across cross-functional teams and stakeholders.

Qualifications

• Experience with SAP BW/4HANA BW on HANA and data modeling across ADSOs/CompositeProviders.
• Proficient in HANA-native artifacts: calculation views, SQLScript and graph modeling.
• Knowledge of data movement across SLT/SDI/ODP and ABAP extractors.
• Familiar with performance tools and security/compliance considerations (GDPR/PII).
• Experience with ALM tools like Jira or Azure DevOps and source control (Git).

Responsibilities

• Lead end-to-end BI solution design from discovery to hypercare across waves.
• Model data on HANA-optimized BW, create ADSOs, Open ODS Views and CompositeProviders.
• Develop and optimize calculation views, SQLScript, and table functions.
• Design integrations: SLT, SDA/SDI, ODP, CDS extractors, and flat files.
• Ensure data quality, governance, and security across the BW/HANA landscape.
• Coordinate transport, cutover planning, and performance tuning activities.
• Enable reporting using BEx/Analysis for Office and SAC integrations.

Skills

SAP BW on HANA BW/4HANA

ADSOs

CompositeProviders

Open ODS Views

InfoObjects

Transformations

DTPs

Process Chains

AMDP routines

FOX formulas

Calculation Views

SQLScript

PlanViz

RSRT

ST05

RSPC/RSPM

SLT/SDA/SDI

Data Services (BODS)

BAPI/RFC BW extractors

CDS Views

Jira

Azure DevOps

Git

ServiceNow

MS Office/Visio

Tools

Jira

Azure DevOps

Git

ServiceNow

MS Office/Visio

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.