Sap Data

Ramya Raju

*******@***-***.*** / 732-***-****

SUMMARY

8+ years of experience in Data Analysis, Design, Implementation and Support of Business Intelligence, OLTP, OLAP, ETL, Data warehousing, Data mining, DBMS and Data Modeling using SAP HANA, SAP Business Objects, SAP BODS, SAP BW on HANA

Good understanding of HANA architecture, SAP in-memory computing, column store, row store tables, engine

Expert in creating HANA information models such as attribute views, Analytical views, Calculation views, scripted calculation views and CE functions.

Expert experience in creating Input parameters, variables, hierarchies, currency conversion, calculated column, restricted column, counter and time data generation

Expert in performance optimization of HANA views that uses high volume of data

Expert in data provisioning techniques such as SLT, BODS, SDI and SDA

Hands on experience in Smart data access – created remote source, virtual tables to remotely access data from source and used them in HANA data models

Experience in Smart data integration – created Replication task, flow graphs - Data Sink, Template Table, Filter, Sort, Pivot table to perform extract, transform and load data from multiple sources

Experience in data replication from SAP source system to SAP HANA system using SLT (Configure, Monitor)

Experience in HANA Security including User creation, Roles/Privilege assignment and creation of analytical privileges

Experience in transport management to transport delivery units by configuring change management

Experience in creating CDS artifacts in HANA to create entities in HANA and load data into the tables

Experience in creating CDS Views, XSODATA services, XSJS jobs, Job Scheduling in XS Admin

Expert HANA XSA Modeler with experience in creating Entities, Calculation views, Procedures using HDB module and creating XSODATA services, XSJS using NodeJS module

Experience in HANA history tables to analyze the slowly changing dimensions

Experience in sentimental analysis using text analysis and text mining options in HANA

Extensive experience in creating Tables, Constraints, Index, Partitions, Views, Triggers, Joins, stored procedures, Dynamic SQL and Analytical functions

Experience in creating HANA models based on missed architectural development using BW Master Data along with transactional data from HANA tables.

Good understanding of Composite providers, ADSO, Virtual master data provider in SAP BW on HANA

Experience in creating SAP BOBJ Web Intelligence Reports based on Universe/Bex Query/ SAP HANA Data Models

Experience in creating universe by connecting to both SAP and Non-SAP data sources, created Joins, Prompts, List of Values, Aggregates, Calculated columns and Derived table

Experience in creating web Intelligence reports with Breaks, cross tabs, ranking, drill down, conditional formatting, various charts, prompts using rich client/BO portal.

Experience in SAP BOBJ CMC - promotion management, connections, user management, Scheduling, security

Experience in creating SAP Lumira story boards using data from HANA/ Universe/ Bex Query/ Oracle/ Excel

Experience in creating calculated measures, dimensions and visualizations using Bar, Pie, Line, Heat map, Geographical charts, hierarchies, Predictive analysis, Merge and link multiple datasets in Lumira and published the reports to BI server/ Lumira Server for teams

Experience in creating Analysis for Office reports with data from HANA cubes

Experience in creating SAP Design studio dashboards with dynamic navigation, reports links, prompts with data from HANA models

Experience in SAP BODS using Data Services Designer to perform ETL from multiple sources including Flat Files, Excel workbooks, XML; SAP ECC and third-party tools through Data Store setup and custom transfer program

Experience in creating TYPE I, II SCD (Slowly Changing Dimensions) JOBS

Experience in creating workflows and data flows in BODS using joins, lookups, match, merge transform, custom functions and o Used Formats and Transforms including Flat File formats, Query, Table Comparison, History Preserving, Hierarchy Flattening, Match Transform, Validation Transform, Key Generation and Map Operation

Experience in using Performance Tuning techniques to improve Throughput of data

Good understanding of SAP MM, SD, FICO, ISU and SCM

TECHNICAL SKILLS

Databases : SAP HANA 2.3/2.1/1.12/1.10/1.9

Scripting Language : SQL, PLSQL

ETL : SAP BODS 4.1, SLT, SDI

Report Tools : SAP BOBJ 4.1, SAP Lumira 1.27/1.28/1.29/2.0, Analysis for Office - 2.2, SAP Design Studio 1.6

Service Management Tools : SM7, HPQC, Jira, Solution Manager

SDLC Techniques : Waterfall, Agile

EDUCATION

B.E (Computer Science and Engineering), Anna University (India), Year 2010

PROFESSIONAL EXPERIENCE

OpsVeda Inc Jul 2020 – Till Date

SAP HANA Modeler

Duration : Jul ’2020 – Till Date

Technology : SAP HANA, PostgreSQL

SM tool : Jira

Description:

Real time analytics product built on SAP HANA. Solution on Order Fulfilment, Supply Management, Manufacturing Intelligence, Inventory Optimization, Logistics & In-Transit, Perspective maintenance.

Project Responsibilities:

Worked in development of product engine that cleanse, transform and load the ERP data into the HANA system

Created analytics based on Business logic and user expectations

Interacted with Business to understand the requirements and customize the product based on new inputs

Worked with business users to understand the issue and fix them

Interacted with Business to understand the pain points and help them with automated solutions

Customized the HANA driven product into non-SAP solution using PostgreSQL as database

Migrated the SAP HANA Database objects to PostgreSQL object

Customize the product based on business requirements from various customers

Performance analysis and improvement of database objects

Worked in JIRA for defect management and change management

created tables, views, procedures, function, indexes, partitions, XSODATA services, Dynamic SQL, exception handling.

Accenture India Oct 2017 – Jun 2019

Application Development Team Lead

Project #1:

Client : American tire and rubber manufacturing company

Duration : Apr ’2018 – Jun’ 2019

Technology : SAP HANA, BO, BODS, PostgreSQL, Alteryx, Tableau

SM tool : Service Now

Description:

The scope of the project is to provide a set of BI reports to highlight Pricing, Growth, Annual Performance, demand planning and Inventory.

Project Responsibilities:

Interacted with Business to understand the BI requirements

Created HANA calculation views based on SAP tables to perform calculation based on business logic

Created HANA CVS using nodes such as projection, aggregation, join, star join

Created input parameters to HANA views and applied them as filters, created calculated columns, restricted columns

Applied currency conversion in the semantics of HANA views. Used data masking option in HANA CV’s for data security

Worked in optimization of HANA views for better performance

Created ETL jobs in SAP BODS to load transformed data from SAP ECC/Oracle/ MS SQL Server to HANA

Created universe with data from SAP HANA cubes/ Bex Query/ Oracle and created filters, prompts, list of values

Used the HANA cubes/universe to create Web intelligence reports and analysis for office reports and published them on BI Server

Worked in transport and promotion management of HANA Views/Universe/ reports between environments

Engaged in unit testing, SIT, UAT and deployment

Experience in HANA/BOBJ up gradation and performed tasks such as compatibility analysis, known issues and risks analysis, solution for known issues, upgrade plan, backup plan

Worked in Alteryx workflow design by segregating them to load data into landing, staging and main tables

Analyzed the data in the source, cleansing and transformation requirements, Table design with column specification and data type

Created the tables in PostgreSQL database with constraints, Indexes and Partitions

Created workflows in Alteryx along with macros and monitored the table during loads to avoid redundant and duplicate data in the tables

Worked in creating/modifying tableau reports using objects from PostgreSQL database and published the workbook onto tableau server

Used data blending option in tableau to merge two data sets in Tableau, created Maps, charts, tables and graphs along with filters, drilldowns, calculated dimensions/measures in tableau to provide users with visualizations based on reporting requirements

Project #2:

Client : British multinational consumer goods company

Duration : Nov ’2017 – Mar ‘2018

Technology : SAP HANA, BO, BI

SM Tool : HPQC

Description:

The scope of the project is to provide a set of BI reports to highlight sales and Inventory.

Project Responsibilities:

Created Reporting requirement specification document based on Business requirements

Participated in Design calls to discuss about the field mapping, calculations, and reporting layout

Created HANA calculation Views based on business rules/logic

Created composite providers, ADSO and Bex query using BW modeling perspective

Created BO Web Intelligence reports using data from HANA models/ Bex Query

Worked in report privileges and folder access privileges in SAP BO based on user roles

Created Parameterized Report, drill downs, linked report and Sub Report by Year, Quarter, Month, and Week

Worked in performance tuning of HANA views for better performance

Worked in SIT and bug fixes, engaged in Deployment and UAT

Cognizant Technology Solutions Apr 2005– Oct 2017

Associate Projects

Project #1:

Client : Leading American Public Utility Company

Duration : Nov ’2016 – Oct’ 2017

Technology : SAP HANA, Analysis for Office, SAP Design Studio, SAP BODS

Description:

The scope of WRAM project is to provide a set of regulatory reports to highlight the under or over-recovery of revenue with targets and provide ability to reconcile FI-CA and GL balances at account level.

Project Responsibilities:

Analyzed business requirements and created functional, technical design documents

Technical feasibility analysis of HANA model, prompts, design report layout, drill downs

Replicated data from ECC to HANA using SLT

Replicated data such as Prior Balance, Adopted, purchased data from non-sap systems using BODS

Plan, co-ordinate and track timelines, allocate tasks and deliverables with team

Developed HANA views and performed unit testing and functional testing

Transported the views between systems and performed SIT

Create Analysis for Office reports and SAP Design studio dashboard on HANA information model

HANA Views performance analysis and improvement

Created SAP Lumira storyboard with data from HANA information models

Project #2:

Client : American manufacturer & marketer - skincare, makeup, fragrance and hair care products

Duration : Mar ’2016 – Nov ‘2016

Technology : SAP HANA, SAP BO 4.1 – Web Intelligence, IDT, SAP Lumira, SAP BODS

SM Tool : HPQC

Description:

The scope of Retail insights reporting is to provide Ad-hoc reporting model for Trade/Retail reporting built on SAP HANA, SAP BW and SAP BO.

Project Responsibilities:

Attended requirement gathering workshop, presented Solutions, Technical Feasibility Analysis

Participated in Project Review meetings and governance calls, conduct status calls

Created SDI flow graphs and scheduled XSJS jobs to load data from source files using file adaptor

Created BODS jobs to load sales target data from non-saps system.

Created HANA calculation views for ad-hoc reporting

Worked in mixed scenario architecture of SAP HANA transactional data and BW Master data Info Object to model HANA views

Created Universe using HANA data model as source

Transported views/ Universe/Reports between environments

Created web Intelligence reports and Lumira dashboards and published them onto BO Server

Worked in performance analysis and improvement of HANA Views/ Universe

Project #3:

Client : American multinational conglomerate corporation

Duration : Oct ’2015 – Mar ’2016

Technology : SAP Lumira, Oracle, SAP BO – Web Intelligence

Description:

The scope of ERC reporting is to provide Reports on the vehicles passes through the toll, revenue earned, smart card users and categorization of vehicles, Multi axle vehicle passing timings and peak traffic timings.

Project Responsibilities:

Created business intelligence reports models based on business requirements too highlight revenue, Peak traffic timings, Vehicle count based on Axle, Video/Image processing

Created tables, materialized views in Oracle database

Worked in performance tuning on Views

Created Stored procedures to perform some of the transformations and aggregates and store them in tables that are used for reporting

Created Web Intelligence reports to visualize the data using Maps, Graphs, Charts

Created SAP Lumira story boards based on Materialized views from Oracle

Published the Web intelligence reports/ Lumira dashboards on BI server

OpsVeda Asia Private Limited Aug 2013 – Mar 2015 Member of Technical Staff

Client : Manufacturing and Logistics, Retail & Consumer Goods, Healthcare

Duration : Aug ’13 – Mar ‘15

Technology : SAP HANA database developer - PLSQL

SM Tool : JIRA

Description:

Real time analytics product built on SAP HANA. Analytics on Orders created, shipped, exceptions in the order management, Supply chain, container prioritization, shipment and manufacturing.

Project Responsibilities:

Created procedures to cleanse and transform data from staging to main tables

Created column tables with Key constraints, Indexes, and partitions

Created static procedures, dynamic procedures, and functions to implement business logic

Created table types to use as parameters for the stored procedures

Utilized exception handling in procedures and returned the error messages based on the exceptions

Created XSODATA to implement CRUD support on master data tables

Customize the product based on business requirements from various customers

Performance analysis and improvement of database objects

Worked in JIRA for defect management and change management

Closely work with SAP UI5 team to showcase data on UI5 dashboard

Worked on single sign on testing and disaster recovery testing for the clients

HCL Technologies Jul 2010 – May 2012

Software Engineer

Client : A British retail and commercial bank

Duration : Jul ’10 – May ‘12

Technology : Oracle, PLSQL, UNIX Shell Scripting, Perl Scripting

SM Tool : SM7

Description:

The scope of the project is to provide financial reporting solution to the customers. Reports such as ER (Effective Rate) and PL (Profit and Loss).

Project Responsibilities:

Run Scheduled data loads and fix problems related to loads.

Monitor data loads to oracle database and check for issues/data errors/load errors

Run SQL scripts to correct the data error and rerun the load process

Extract and analyses daily, monthly, and Quarterly reports and share it with customer

Incident management and resolution with the timelines

Analyze the change request and develop the changes (Oracle procedures and PERL Script)

Interact with the Support teams for the data loads

Contact this candidate