Sap Hana Bw

Sensitivity: Internal & Restricted

RANGA MOHAN

SAP Datasphere/Hana Consultant

Email: *****************@*****.*** Phone: +1-201-****-*** Summary:

SAP BW HANA consultant having 13 years of relevant experience included Experience in Sap Datasphere, SAC, Native HANA Applications, ABAP, Hana XSA, S/4 Hana, SAP BW, BW on Hana, BW4 Hana, SAP BO, Power BI and Tableau.

Certified in SAP Hana, Datasphere and Snowflake.

SAP Certified Application Associate – SAP Datasphere, SAC, SAP HANA

Certified in AWS Cloud practitioner and solution architect.

Having the hand on experience in setting up the environments and provisioning the accounts for SAP Datasphere, SAP Hana Cloud and SAP BW.

Managed all phases of project from requirements gathering, Blueprinting, Configuration, Integration testing, Go Live, Documentation, Post Go live support and end user training.

Involved in business process blueprinting and subsequent solutions architecture design.

Worked with business stakeholders and technical stakeholders in developing models, dimensions, members, and hierarchies.

Provided training for business users.

Involved in the Data import and loading the data sets like master data, transaction data into SAP Datasphere and SAP Hana.

Having experience Configuring the SAP Data Provisioning Agent and Model transfer from SAP BW/4 and replication of data from SAP Hana.

Having the experience in exporting the data from SAP Datasphere to other system by creating the export pipelines.

Having ETL experience in SDA, SLT and BODS. Creating, monitoring and scheduling the jobs.

Experience in ETL with BODS like Case, Query, Merge, SQL, Validation, Table Comparison and History preservation transforms in BODS 4.1 for extracting data to HANA.

SAP Analytics Cloud – Analytics, Planning and Data Visualization.

Worked as Architect for different projects by providing the solutions to the requirements and coordinated with the FSD and TSD to implement the best solutions.

Design and implement data models using SAP Datasphere.

Good understanding of joins, cardinality, and associations.

Good experience in CDS Views creation in S4HANA system and real time replication.

Develop analytics solutions using SAP SAC, including data visualization and reporting

Having the experience in building the Power BI Dashboards by using the Hana views.

Having the Experience in XS Development like XS OData, XSJS Services and Debugging the code to identify and analyse the issues.

Optimize data performance and scalability using SAP Native HANA

Expertise in SAP Native HANA applications which includes hands-on experience in BOBJ- Web Intelligence reporting experience for Adhoc reports and Analysis for Office 2.3 on top of HANA.

Experience on creating Attribute views, Analytical Views, Graphical Calculation Views, Stored Procedures, Table functions, Scalar Functions and Debugging.

Worked on Creating Advanced DSOs in BW Perspective of HANA Studio and exposing them to Open Hub Destinations to create Interfaces.

Worked on Generic Extractions based on Tables and Views to extract data from ECC.

Extracting the Master data and loading them to Info-Objects Creating Info packages, Transformations, DTP’s and understanding ABAP code wrt START and END routines to derive the required logics.

Good Understanding of the Basic ABAP statements like Structures, Internal Tables, Work areas And Field Symbols.

Sensitivity: Internal & Restricted

Good knowledge on Open ODS Views, Virtual Providers, Transient providers and Composite providers.

Creating Bex queries as per the user requirements and developing BO reports as per required specifications.

Good knowledge of SAP HANA Architecture and led the project by providing the solutions to the requirements.

Having the experience Agile methodology. Used the Jira and azure for the sprint planning and tracked the progress through the stories.

Providing effort estimations to different RFS’s that are coming up and which require team’s involvement.

Having the good debugging skills by using the DO begin statement.

Used the select, insert, update, create, alter, drop statements.

Used Date Time Function, Data Type Conversion Functions, String Functions, Aggregate functions like to date, cast, trim, string, max, min, age, count etc...

Migration of Existing Script Based Calculation Views to Table functions.

Having the experience in writing complex stored procedures, Table Function & Scalar Function

Having the experience in writing the procedures to materialize the logic by designing the custom tables.

Having experience in HANA XSA.

Cloning the repository, creating local branch, Merging the changes with Master by running the pull request.

Deploying the objects from Dev, QA & PROD by running the pipeline.

Worked on Information Design Tool - Creation of Data Foundation, Universe for reporting on top of HANA.

Worked on Power BI to build the dashboards.

Have experience in building the tableau dashboards.

Hands on experience in Data Provisioning and replicating data from source system to HANA Database using SLT Replication Technology.

Reconciliation of data at Table, View and reporting levels.

Experience with HANA-SQL Scripting - Operators, Joins & Unions, Sub Queries etc

Worked on Creating Advanced DSOs in BW Perspective of HANA Studio and exposing them to Open Hub Destinations.

Understanding the requirements and coordinating with ABAP’er to achieve the required logic.

Good Understanding of the Basic ABAP statements like Structures, Internal Tables, Work areas and Field Symbols.

Solving the defects raised during Unit testing and User Acceptance Testing Phases.

Expertise in Data Modelling, Extraction and Loading. Experience:

Client : CN Rail

Project : Datasphere Implementation, SAC, S4 Hana, BW/4 HANA Duration : Sep 2023 – Apr 2025

Lead Technical Consultant:

Managed all phases of project from requirement gathering, Blueprint, configuration, Integration testing, Go Live, Documentation, Post Go live support and end user training.

Coordination with the offshore onsite team in onsite – Offshore model for analysing and delegating work to offshore team.

Involved in the discussion with the functional team about the business needs and ways to optimize solutions.

Sensitivity: Internal & Restricted

Involved in the Preparation of Functional Specifications with the Functional consultants, Validating functional specifications.

Assigning the functional specification to the team to prepare the technical specifications and worked on the Reliability T spec.

Reviewing the Technical specifications and code review.

Coordinated with the team to develop the models as per the T Specs

Involved in the Data Integration Connect & Configure SAP Data Provisioning Agent.

Involved in the integration of CDS views with Datasphere using business content.

Involved in the Data replication from different source into Datasphere like BW, S/4 Hana, Hana etc..

Setting up the environments and provisioning the accounts.

Importing the Data and loading the data into sap Hana and datasphere.

Data push to different target systems by crating the export pipelines.

Involved in creating and enhancing the ABAP CDS views and BW4 models and then Datasphere objects.

Migrated the query from BW4 Hana to Datasphere for further development.

Created 2VF, 3VF and Analytical model.

Review of the models developed as per the T spec.

Involved in Development testing and the quality testing of the models.

Developed the Mechanical daily status report and R4C.

Developed SAP Analytics Cloud analytics solution involving data wrangling, model development, Story development, KPI Dashboarding of reports.

Developed calculated and restricted dimensions.

Configured connections between SAC and BW4/HANA system.

Key point of contact in communicating business requirements for reporting needs.

Conduct work effort estimation and develop work plans

Creating the CR to deploy the objects in PROD.

Designing and implementing data models using SAP Datasphere.

Developing analytics solutions using SAP SAC, including data visualization and reporting.

Created the R4C and Daily Mechanical Status Report by using the SAC.

Creation and maintenance of task chains, fact models, consumption models and Snapshot models.

Optimizing data performance and scalability using SAP Native HANA.

Integrating data from various sources using SAP Datasphere.

Collaborate with stakeholders to define data strategies.

Provide technical guidance and mentoring to junior team members.

Stay up to date with SAP innovations and roadmap.

Collaborate with cross-functional teams (IT, business) to drive data-driven decision-making. Client : Apple, CA

Project : Hana Development & Enhancement

Duration : Jan 2023 – Aug 2023

As an SAP HANA Consultant:

Optimal Design and Development considering Performance challenges.

Decode the SQL Script from sub-queries and nested queries, developed a replica in HANA Environment for Pipeline Orders, Contracts, NPS, Propensity related data etc.

Developing Calculation views, Table FUNCTION & Stored Procedures.

Data Validation and comparison with justification to ranking discrepancies among Planning group data and unique account data.

Responsible for supporting and independently completing project tasks

Creation and enhancement of SAP HANA Web-based applications with emphasis on data modelling. Sensitivity: Internal & Restricted

Providing technical expertise on SAP architecture and making recommendations to improve performance.

Conduct work effort estimation and develop work plans

Create, enforce, and adhere to HANA development standards

Developing SAP HANA information models such as Procedure and Hana Views (Calculation views) with graphical, SDA (Smart Data Access).

Change Manager and solution manager for deployments.

Created a DataMart procedure for credit allocation as part of the performance issue.

Worked on the credit allocation project for Vietnam.

Debugged the code to find the issue from reporting level to table.

Created auto sys jobs to schedule the loads and monitoring.

Worked on tableau reports.

Coordinating with the UI developer to test the reports and deploy objects to PROD.

Creating the CR to deploy the objects in PROD.

Worked on the performance issue of treasury procedure.

Connecting with the client to get the requirements.

Attending the meetings with the product owner to get the clarification.

Giving the demonstration to the Product owner and stakeholders. Client : Cisco, CA

Project : Supply Chain

Duration : Nov 2021 – Dec 2022

As an SAP HANA Consultant:

Decisions to ETL Team for Re-Scheduling of Procedure –time cycles for their runtime variations.

Fixing the OOM issues in Production system.

Correcting the syntax errors in Load test scripts for a huge number of objects in Stage environment as part of Upgrade activities

Handling the performance tuning concerns like run-time and memory consumption for numerous flows based on expensive statements, solutions.

Analysis of UI applications at different levels of interfaces i.e. XSJS, UI and HANA and consolidating the objects that would need changes for performance optimisation with pushdown filters.

Partitioning of tables across Stage and Production Systems, determining the Keys

Solved uneven node distribution issues for large number of partitioned tables for incorrect keys

Automation of valid- data updates for Stage data in copied environment with trigger mechanisms.

Inserting scripts of objects from new sprints to load tests.

Helped cisco junior engineers fix the issues at UI level implementing HANA logics.

Precise Changes on Objects in stage environment followed by Data validation.

Data validations & Deployments.

Postman checks for XSJS code issues with front end applications.

Validation of Invalid Procedures in Production Environment.

Code changes in XSJS for data type conversions and enhancement reflections done at HANA model level.

Data validation wrt ETL sourcing and target tables, HANA Flows and UI data.

Input Parameter mappings as part of enhancement to all dependent flows as part of enhancements.

First point of contact for clarifications on missing data with comparison of Stage and Production flows. Sensitivity: Internal & Restricted

Client : Service Now

Project : Hana Implementation

Duration : Nov 2020 – Oct 2021

As an SAP HANA Consultant:

Creating the Hana models to build the Tableau Dashboards

Worked for different projects like Customer Advocacy, CMO and GSD comes under Marketing domain.

Interacted with Business stake holders to understand their reporting requirements, business rules for marketing domain.

Created the Base models, enter price models and Reporting models based on the business requirement like Contacts, Requests, Pipeline and GRC models.

Created the Table Functions wherever required to achieve the requirement.

Crated transpose table function by using the sql script for specific requirement.

Created a procedure to read the data from table function and load into materialised table.

Frequently used select, sub select, case, count, aggregation function, order by, where clause while writing the SQL script.

Created table function to normalize the data in a specific table and used that in further models.

Created calculated columns like Opportunity Category based on the stage.

Updating all the technical design documents for release specific changes across all interfaces, Solution manager uploads in the created paths, getting the required approvals (SQA and Final) for deployment into Pre-Production followed by Production.

Performance tuning of Existing flows that are causing Memory consumption issues in Production based on Plan-Visualizer results.

Query Pruning and Exception Aggregation, Implementation of the techniques at necessary places to

Improve performance and Fix the Wrong Aggregation results.

Development of New requirements accordingly as per the Specification Documents via Graphical calculation Views, Scripted Calculation Views, and Stored Procedure definition changes.

Active Participation in Sprint status calls and SIT status calls.

Enhancements to the existing Flows according to the requirements and deliverables within the sprint period in agile methodology SCRUM

Unit testing

Defect handling during UAT Phases.

Involved in the enhancements of GSD like Pipeline definition change, deriving the commissionable flag, Opportunities by SDR/SDR Manager and OpportunityClosedLostReasonCode

Created the Change Requests to deploy the objects by attaching the performance stats and getting the peer approval and manger approval for low-risk CR.

Interacting with integration team for the data load into Hana dB and data issues.

Worked closely with the Tables reporting team for all the requirements. Client : Kraft Heinz, TX

Project : HANA Implementation - Compass & River

Duration : Nov 2018 – Oct 2020

As an SAP HANA Consultant:

Using the SAP HANA studio created the data modeling for calculation views.

Analysis of data as a Pre-development activity to make sure the requirement sync’s up with the existing data.

Development of Dimension CV’s and Cube based CV’s accordingly to the Business requirements.

Creating Input parameters for the views accordingly to the specification

Creating the Restricted Columns and Calculated columns as per the requirement

Connecting with the UI team for the json formats input and output.

Creating the XSJS and ODATA services as per the UI requirement. Sensitivity: Internal & Restricted

Creating the custom tables and filling through procedures.

Creating views for master data and transaction data.

Proposals for Package restructuring as Dimensions CV’s, Reusable CV’s and Reporting CV’s.

Refactoring the objects.

Creating of procedures and table function based on the user requirement.

Interaction with the client to get the requirement.

Using filters for data restrictions and calculating the columns to get required data values.

Transporting the Hana views from dev to QA and QA to Reg.

Working on the performance tuning of Hana views.

Handling the performance questions raised and making changes in models as per the requirement at backend.

Implementing enhancements based on Change requests.

Identify and Fixing issues and improvising/optimizing solutions.

Answering the questions raised by the users.

Working on the production defects if anything raised by customer.

Worked on the River enhancements in two phases and delivered successfully.

Worked on the Routine 57 project – its all about the MOPs.

Attending the client calls to get the requirements and for clarification.

Trained people (Freshers) on Hana and utilized them in the project.

Teaching the Hana for the team.

Client : Mohawk Industries, TX

Project : HANA Implementation

Duration : Aug 2017 – Oct 2018

As an SAP HANA Consultant:

Development of HANA Information Models i.e. Dimension CV’s and Cube based CV’s accordingly to the Business requirements of

Sales Order document item

Sales Invoice Item

GL Line Items

GL Trial Balance

Inventory Activity

Inventory Balance

Freight Shipment

Freight Accrual

Freight Expense

Order Document Header

Sales Invoice Header

Stock Transfer Orders: Intra and Inter

STO Service KPI

Customer Master

Vendor Master.

Goods in Transit

KPI Requirements

Creating Variables, Input parameters, Restricted Columns and Calculated columns as per the requirement.

Consumption of HANA views through Microsoft Excel thru MDX Providers. Data Reconciliation at Table level, view level and Excel level.

Importing Custom tables loaded via BODS to QA and Sandbox systems.

Intimating the Client about the required and missing Join’s from specifications when the

Aggregation results appear wrong.

Sensitivity: Internal & Restricted

Proposals for Package restructuring as Dimensions CV’s, Reusable CV’s and Reporting CV’s.

Refactoring Migration of existing Attribute Views and Analytical Views to Graphical Calculations views after the upgrades.

Handling the performance questions raised and making changes in WIP models as per the

Requirement at backend.

Solving defects during testing phases.

Client : Estee Lauder, NY

Project : ESL- APOLLO (HANA Implementation)

Duration : Jun 2016 – Jul 2017

As an SAP HANA Consultant:

Quick understanding of the flows created and reconciliation of data at Table, View and Web- Intelligence reporting levels

Created Process chains for the developed flows, scheduling, monitoring and fixing issues

Worked with ECC data sources creation of Generic data sources from tables, activation of Standard Data sources and enhancing them as required.

Worked with Filling up setup tables for Lo Extractors

Monitoring the schedule reports daily in Bo tool and resolving the issues of failed reports

Collection of objects manually, Creation of TR’s (workbench and relocation TR’s), releasing them and importing the objects in target system and solving related issues

Worked with loading of Flat file, Extraction from ECC (Full and Delta), master data and transactional data

Creating Bex queries as per the user requirements and developing BO reports as per required specifications.

Customizing the universes as per requirements

Preparation of Unit test documents with the relevant screenshots for different test cases and Sharing with client

Uploading the unit test template with all relevant screenshots and uploading them to a shared Drive to take it forward.

Handled the change requests in BW for the parent-child Hierarchy missing data with ABAP’er Co-ordination during the IAT Phase.

Solved defects that came from Web-Intelligence reporting perspective for an Unnecessary Excel Instance in QA and PROD and from HANA view levels.

Handled the defects during Integration testing phase.

Level by level data analysis in HANA and giving justifications to the user with the root source of Data.

Client : Telstra-APS

Project : BW on HANA Implementation

Duration : Sep 2014 – May 2016

Role : SAP BW Consultant

Roles & Responsibilities

Worked on Creating Advanced DSOs in BW Perspective of HANA Studio and exposing them to Open Hub Destinations to create Interfaces.

Worked on Generic Extractions based on Tables and Views to extract data from ECC.

Extracting the Master data and loading them to Info-Objects Creating Info packages, Transformations, DTP’s and understanding ABAP code wrt START and END routines to derive the required logics.

Sensitivity: Internal & Restricted

Coordinating with SAP PI team to process the generated files from AL11 Directory to Kinaxis.

Handling the Change requests for the design changes in the developed Flows

Handling Daily Loads in Quality for Testing and Production Systems making prior loads to dependency objects first and then to Actual flows.

Changing the default paths of Open hub Destinations to AL11 paths using ABAP programs.

Good Understanding of the Basic ABAP statements like Structures, Internal Tables, Work areas And Field Symbols.

Solving the defects raised Testing Phases.

Performing Consistency checks for Transports and releasing them in SE09.

Good knowledge on Open ODS Views, Virtual Providers, Transient providers and Composite providers. Client : SABRE HOLDINGS

Project 2 : BW - Enhancements

Duration : Jun 2012 – Aug 2014

Role : SAP BW Consultant

Roles & Responsibilities

Worked on Master and Transactional Data Source Enhancements like Material Number, Plant, Vendor, Work Centre, General Ledger, Purchasing Scheduled Line and Sales Document Header Status.

Created info objects, characteristics and key figures.

LO-Extraction, Generic Extraction [ Table, View and Function Module]

Analysis of FS and BR documents and in design of TS documents

Handling the change requests

Worked on Classical Info-cubes, DSO’s, DTP's and transformations.

Data Validations at Table level, BW Interface level and Bex Query Designer reporting levels.

Worked in Bex Query Designer with Cell Definitions, Offsets, Restrictions, Conditions, Filters and Strong Knowledge on variables and Replacement paths, CKF and RKCF etc.

Performance tuning activities like Aggregates, Compression, Partitioning, read mode of Queries, Line- Item Dimension and High Cardinality etc.

Load Monitoring and Fix Process Chain Issues.

Co-ordination with ABAP'er to achieve the required logic wrt Start, Field, END & Info Package Routines.

Knowledge of BW Related core-ABAP.

Responsible for handling monthly SLA reports

Report the monthly and movement reports of Inventory to client from ECC.

Configuring exchange rates in development, quality and production systems in ECC side User purging in ECC and CTS activities to Quality and Production. Education:

Bachelor of Science in Mathematics and Computer Science from Sri KrishnaDevaraya University

Contact this candidate