Description

Role Overview

Experienced SAP BW/4HANA & Power BI Consultant to lead the migration of existing analytical and reporting solutions from legacy SAP BW architecture (DSO, MultiProvider, BEx Query, SAP BO) to the modern SAP BW/4HANA and Power BI ecosystem as well as development of regulatory reporting calculation.

The consultants will redesign and modernize data models using ADSO, Composite Provider, Calculation Views, and Power BI Reports/Dashboards while ensuring performance optimization and functional continuity.

- Key Responsibilities

Migration & Modernization

Analyze existing reports built on DSO, Multi Provider, BEx queries, and SAP BO.

Migrate legacy BW objects to BW/4HANA equivalents:

DSO → Advanced DSO (ADSO)

Multi Provider → Composite Provider

BEx Queries → BW/4HANA Queries

SAP BO Reports → Power BI dashboards

Rebuild data models using HANA Calculation Views where required for performance or business logic enhancement.

Re‑engineer ETL flows and data models for BW/4HANA compatibility.

Data Modeling & Development

Design and implement complex BW/4HANA data models including:

ADSO (Standard, Direct Update, Planning)

Composite Providers

Open ODS Views

HANA Calculation Views (Graphical / SQL Script)

Develop and optimize end-to-end data pipelines.

Power BI Development

Build interactive Power BI dashboards to replace SAP BO reports.

Integrate SAP BW/4HANA and HANA views with Power BI using best practices.

Implement row-level security (RLS), data transformations, and performance optimization in Power BI.

Testing & Validation

Conduct unit testing, integration testing,



and user acceptance testing (UAT).

Validate data accuracy between legacy (BW 7.x + BO) and modernized (BW/4HANA + Power BI) systems.

Documentation & Stakeholder Collaboration

Prepare technical specifications, migration documents, and training materials.

Work closely with functional consultants, business stakeholders, and BI leads to ensure seamless migration.

- Required Skills & Qualifications

Technical Skills

Solid experience in SAP BW 7.x and SAP BW/4HANA.

Hands-on expertise in:

DSO, Multi Provider → ADSO, Composite Provider

Transformations, DTPs, Process Chains

BEx Query Designer

Experience building HANA Calculation Views (SQL Script + Graphical).

Good understanding of SAP ECC/S4HANA data structures.

Soft Skills

Strong analytical and problem-solving skills.

Excellent communication and documentation abilities.

Ability to work independently.

Enable Skills-Based Hiring No ECMS REQ IDAdditional Details

- ECMS REQ ID : 584561
- Project Location 1 : Pan India
- Project Location 2 : (No Value)
- Project Location 3 : (No Value)
- Project Location 4 : (No Value)
- Delivery SPOC : Amit Kumar Agrawal
- Relevant Experience : 6-8 Years
- Mandatory skills : SAP BW/4HANA & Power BI Consultan
- Desired skills : SAP BW/4HANA & Power BI Consultan
- Domain (Industry) : Insurance
- BGC (Before onboarding / After onboarding) : PostOB
- Total Experience (Ex. 5-7 Years) : 10+
- BGC Details : NA
- BGC Vendor : NA
- Mode of Interview : Video Interview
- WFO / WFH / Hybrid : Hybrid
- Please enter shift timings : 12 AM to 9 PM IST
- Shift Timings : Afternoon

📌 Sap Bi (India)
🏢 Trigent Software
📍 India