SAP BW on HANA

Tekskills Inc.; Delhi; In loco; INR 1.800.000 - 2.400.000; Tempo pieno

Descrizione del lavoro

Tekskills Inc. is seeking a SAP BW on HANA expert to lead end-to-end lifecycle across multiple waves, focusing on data modeling, integration design, and performance optimization. You will work with SLT/SDA/SDI, BODS, and CDS exposure while ensuring security, governance, and efficient data movement.

The role involves hands-on modeling, troubleshooting, and collaboration with cross-functional teams. The ideal candidate brings deep SAP BW/4HANA experience, strong SQLScript skills, and a proven

Competenze

• Proven experience with SAP BW on HANA BW/4HANA architecture and data modeling.
• Strong understanding of ADSOs, Open ODS Views, and CompositeProviders.
• Experience with data extraction, integration, and SAP Data Services (BODS).
• Knowledge of security/compliance (GDPR/PII) and authorization concepts.
• Experience with performance tuning, RSRT analysis, and process chain optimization.

Mansioni

• Own E2E lifecycle across waves: discovery, blueprint, design, build, test, cutover, hypercare, steady-state.
• Model data in BW on HANA, create Calculation Views, and implement data flows with SLT/SDA/SDI and ODP.
• Design integrations using BAPI/RFC, flat files, and CDS extractors; expose with CDS views when relevant.
• Optimize performance: SQLScript, pushdown, aggregates, and partitioning; monitor with RSRT.
• Ensure data quality, lineage, and governance with proper documentation and ownership.

Conoscenze

SAP BW on HANA BW/4HANA

ADSOs

Open ODS Views

CompositeProviders

InfoObjects

Transformations

DTPs

Process Chains

AMDP routines

FOX formulas

Query design

HANA modeling

SLT

SDA/SDI

BODS

ABAP extractors

CDS-based extraction

Data security & GDPR

CTS+/Charm

BEx/Analysis for Office

SAP Analytics Cloud

Strumenti

Solution Manager/Charm

Jira

Azure DevOps

Git

ServiceNow (incidents/changes)

MS Office/Visio

Descrizione del lavoro

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.