Sap Bw Data Integration

KIRAN

Email: *****.******@*****.***

SAP DWC/SAC Consultant

Contact: +1-925-***-****

www.linkedin.com/in/sap-bw4hana

. 14+ years of experience in SAP Datasphere, BW, BW4HANA, SAC, HANA

Modeling.

. Good Experience in SAP DATASPHERE concepts

. Created Models, data flows and data integration process

. Worked on BW Bridge to migrate BW4HANA into public cloud.

. Very good experience in data builder objects in Datasphere

. Datasphere is integrated with SAC and built reports

. Implementation and support experience in SAP BW and HANA with SD, FI

Modules

. Good experience in SAP HANA modeling and BW4HANA development

HANA: Good Knowledge on HANA Architecture, In-Memory database, Row Store,

Column Store.

. Good experience in data provisioning using SLT, Flat file data loading.

. Understand the business requirement from Users and prepared the business

blue print Analyze the existing system data flows and prepare IIT, FIT

and TS documents.

. HANA modeling: creating schemas and HANA information models, Variables

and input Parameters, Currency conversion, Good Experience in creating

Calculated columns and restricted measures, Decision tables

. Experience in Privileges and Decision tables. Knowledge on Authorizations

and security

. Strong experience in SLT for SAP system to HANA system, Flat file data

loading, Delivery unit and views Migration to Calculation view

. Good SQL knowledge and Joins which is used in HANA views. And basic HANA

SQL script

SAC: Design and solution of SAC implementations in BI, planning, reports,

and dashboards

. Hands-on experience configuration and Integration of Live Data Connect

(LDC), Import data connection and data acquisition SAP BW and S4HANA

. Worked as a visualization expert to implement the best visual stories for

customers and KPIs

. Experience in creating story canvas, responsive, grid, optimized story

designing, formulas, cross calculations, input controls, linked analysis

. Experience in data modeling, custom hierarchies, custom calculations,

formatting values, data wrangling, dimensions, and Measures

. Design and configuration of the planning environment, building of

Models and Dimensions, Input Forms, Reports

. Design, develop E2E flow including modeling, extraction, reporting of

budget, plan, forecast reports

BW/4HANA: Creating info objects in Eclipse based, ADSO and HCPR, Consuming

HANA models in SAP BW, knowledge on ODP framework, LAS and LSA++

architecture. Creation of data flows

SAP BW experience: Data modelling including performance tuning.

. Worked on LO Cockpit Extraction, Generic extraction, LO-Data Source

Enhancement

. Experience in ABAP coding for Start, End, expert routine and data source

enhancement.

. Created Bex reports, calculated key figures, Restricted key figures,

Variables, Condition

. Processing Types, Exception highlighting, Filters, Free Characteristics,

Structures

Process chain: Created Process chains, monitoring and resolving the issues

in Production

Educational qualification:

. Bachelor of Technology Engineer in Computer science in 2004.

Client: ABB

Feb 2024 -Till date

Role: SAC Datasphere Lead

Responsibilities:

. Extensively worked on implementing the FI GL, AR, EWM models in DWC

. Imported Tables like local and Remote table from S4HANA

. Creating data models, data flows, and data integration processes

. Creation of remote tables, Data builder objects in Datasphere

. Creation of stories and applications based on live data.

. Data transformation in SAP Datasphere/SAC.

. Extracted data using Replication flows and data flows into local tables

. Created Graphical views for Text and Dimensions & Hierarchies

. Implementing the S4HANA GL or Profit center or Cost center Hierarchies in

DWC using external Hierarchy and Hierarchy with Directory

. Designed Graphical views to integrate data using joins and associating

master data

. Created Analytical models to expose the business logics to other

applications like SAC

. Persisting the data for views and Created Task chains to automate the

Dataflow

. Transporting the DWC objects using export and import mechanism

. Design and architecture of SAC solutions based on business requirements

and best practices. This involves understanding business processes, data

sources, and reporting needs to create an effective solution blueprint

. Integrating data from multiple sources like DWC, S4HANA,BW live queries

and import data

. Lead the development of data models and datasets within SAC to support

reporting and analysis requirements. This includes defining dimensions,

measures, hierarchies, and calculated fields to ensure data accuracy and

relevance.

. Guide the development of reports, dashboards, and visualizations in SAP

Analytics Cloud. Work with business users to understand their reporting

needs and translate them into actionable insights through intuitive and

interactive dashboards

. Translating Business requirements into SAC stories like Head count,

Material Stock, GL Balances, Internal income statement etc.

Client: GSK

Sept 2019 - Dec 2023

Role: BW Lead consultant

Responsibilities:

. Involved in end-to-end implementation from BW4HANA to SAC

. Worked on BW Bridge, Prepared the modeling tools, Monitoring BW bridge

jobs

. Leading offshore team size of 6 members

. Creating End to end Data flow from ECC to BW4HANA

. Created Composite providers and ADSO's,

. Transforming the data using Rule groups and End-routine

. Worked on LO extraction and enhancements

. Created Bex queries for different business scenarios and supports to SAC

. Process chain creation and periodic data loading

. Worked on with custom development solutions, complex scenarios by

optimized stories, Linked analysis, Jump reporting

. Developed Stories by Live Connection Models and Import Models. Reports

and visualizations, based on stories & Canvas, Blending data.

. Development of Live Models based on BW/4HANA System.

. Developed and maintain dimension properties to be leveraged in

calculation

. Developed configured layout using analytics application

. Created Bex query reports to support SAC backend

. Configured Connection between SAC and BW4HANA system

. Security configuration at model, dimension, story and file structured

level

Client: ELI LILLY

July 2018- Aug2019

Role: BW Lead consultant

Responsibilities:

. Strong experience in BW/4 HANA Development, modeming best practices for

better performances.

. Created the Generic Data Source on top of the view.

. Created the Dataflow, Composite Provider, ADSO, Calculation view.

. Worked on Mixed Modelling Scenario such using ADSO in calculation view

and CV back to Composite for reporting Purpose.

. Worked on activation of the standard content on BW side and ECC side.

. Worked on ABAP routines in transformation level

. Worked on setting up BW Cockpit to do BW Administrative tasks.

. Enhancement of SD and FI data sources as per the client requirement

. Tables replicated using SLT Hana modelling views created.

. Variables and input parameters, performance tuning, Conversions. Unions,

Join operations.

. Prepared cut over activities, TS, training documents.

. Hyper care activities after completion of Go Live

Client: PLDT

March 2016 -June 2018

Role: Senior BW consultant

Responsibilities:

. Requirements gathered from PLDT clients

. Created business blueprint according to client requirement

. Complete green field BW modelling done and transported objects across the

landscape.

. Prepared cut over activities, TS, training documents.

. Tables extracted from ECC using SLT into HANA as per the business

requirement

. Created packages, Attribute views and Analytical views and Calculations

views

. Bex reports are created as per user requirement which is act as source to

power BI

. Completed UAT demo with business users and changes done as per their

suggestions

. Prepared UAT sign off documents, Technical specification documents, and

cutover activities.

Client: WALMART

Nov2014 -Mar 2016

Role: Senior BW consultant

Responsibilities:

. Analyze Alteryx system work flow and created TS document and interaction

with users for confirmation.

. Tables extracted from ECC using SLT into HANA as per the business

requirement

. Created packages, Attribute views and Analytical views and Calculations

views

. Bex reports are created on top of Composite provider, RRI configuration.

. Completed UAT demo with business users and changes done as per their

suggestions

. Prepared UAT sign off documents.

Client: CARLSBARG

Feb 2013-Oct 2014

Role: BW consultant

Responsibilities:

. Install Business content, identifying characteristics and key figures,

created Info Areas, Info Object Catalogs, PSA, DTP, Info package,

transformation, DSO, Info cube, Multi provider.

. Good experience in BW reporting using Bex Query designer.

. Created Bex Queries using, Formulae, Variables, Calculated, restricted

key figures

. Process chain monitoring which are scheduled on daily weekly monthly

basis

. Error rectification whenever the process chains failed.

Client: ALGHANIM INDUSTRIES

Mar2009-Jan 2013

Role: BW Consultant

Responsibilities:

. Install Business content, identifying characteristics and key figures,

created Info Areas, Info Object Catalogs, PSA, DTP, Info package,

transformation, DSO, Info cube, Multi provider.

. Involved in creating Aggregates, Partitioning, Indexes, Roll-up and

Compression

. Created Bex Queries as per the requirement.

. Daily Monitoring Data Loads for meta chains based on daily, weekly and

monthly basis

. Resolving data loads failed for each meta chain and maintained for future

analysis purpose

Contact this candidate