VinayaKumar

SAP HANA and BW Consultant

acy3yx@r.postjobfree.com

630-***-****

Professional Summary

Having 8 years of Extensive experience in SAP HANA, SAP BW, SAP BW on HANA and SAP BO with experience on implementation and support projects including data modeling, extraction and report creation.

Worked on multiple projects, coordinated design efforts within stream, handled Interdependencies and produced estimates for projects.

Key Function Areas

HANA:

Hands on experience in HANA modeling. Experience in creating Attribute views, analytical views and calculated views.

Configured and Extracted data from SAP ECC, SAP CRM and SAP BW on HANA Data Base using SLT, BODS and DXC methods of Data provisioning.

Optimization of the modeling using Calculation Engine (CE) operators in SQL Script.

Application of HANA In-memory concepts.

Experience on trouble shoot and Performance improvements using HANA Database.

Had created Technical Specifications.

Had worked on HANA Security by creation of users, roles, creation of analytic privileges.

Had compared Object Versions and validated information models.

Having knowledge on HANA XSJS programming and developed multiple programs using Java Script consuming Hana Views.

Transported SAP HANA content with Enhanced CTS (CTS+).

Experience in sizing and scaling of SAP HANA

Experience with integration of HANA with BO Components.

BW on HANA:

Created HANA optimized DataStore Object and HANA-optimized InfoCube for faster reporting to accelerate data loads, simplify data modelling and to allow faster remodeling of structural changes.

Had created Virtual, Transient Infoproviders and Composite providers in BW on top of HANA Model, created DB Connect to load data from HANA to DW.

Worked on Layered Scalable Architecture plus plus (LSA++) with SAP HANA

Data Modeling with BW 7.3:

Design & Maintenance of Customized Infoobjects, Info Cubes, DSO Objects, Multi providers, Infosets, Data Marts, SPO’s, Hybrid, Transient and composite Infoproviders.

Experience with SAP BW 7.3 on HANA, SAP BW 7.4 on HANA migration.

Done functional upgrade /Migration of BW 3.5 data flow to BW 7.0.

Worked on SAP BW Accelerator, Real Time Data Acquisition, Currency and Unit Conversion

Created ABAP Routines in transformations and maintained Process Chains.

Good Working knowledge on Graphical Data Modelling.

Data Extraction to BW 7.3:

Data extraction from BW content extractors and customer generated extractors) and cross application specific extractors (generic extractors), flat file.

Maintenance & enhancements of data sources at SAP OLTP source system.

Performance Tuning:

Worked on Aggregates, Indexes, partitioning and Compression/collapse.

Reporting:

Business Objects (BO):

Experience with Installation/upgrading/maintenance of SAP Business Objects 4.x components.

Experience with SAP BO Launch Pad and creation of interactive reports using Webi.

Created BO Reports on top on BEx Queries using BICS Connection.

Developed dashboards using Dashboards 4.1 /4.0/ Xcelsius 2008.

Had created reports in Lumira to handle huge volume of data in real time.

Worked on SAP BI 4.0 Mobility for usage of BO reports with iOS/Android Devices.

Created Semantic Layer (Universe) using IDT,

Created Crystal Reports and Business Explorer reports for search and exploration.

Has experience on SAP BO Design Studio.

BEX:

Developed reports in front-end involving Calculated key figures, Restricted key figures, Structures, Variables, Conditions, Exceptions, Cell Editor, Formulas, RRI’s.

Had created customized Workbooks.

Had created web reports using Web Application Designer formatted reports using report designer.

Had worked on Information Broadcasting for distribution of BI Data through different channels and in different formats.

Had worked on integration of BW Reports to Enterprise Portal.

Skill Set:

OLAP

SAP HANA, SAP NetWeaver BW 7.4, SAP BW 7.3, SAP BW 7.0 and SAP BO 4.1

OLTP

SAP ECC,SAP CRM

Ticketing Tools

Service now ticketing tool, Agile Methodology

EDUCATION:

PROFESSIONAL EXPERIENCE:

John Deere, Moline, IL 03/2016 - Present

Role: SAPBW/HANA Consultant

Roles Performed:

Created Calculation view using SQL scripting

Performed Query Performance Tuning by analyzing and applying aggregates, line item dimensions, data compression, and indices.

Analyzing and working on Performance tuning for HANA objects by using indexes on base tables, Pagination, Splitting the HANA Views based on volume of data being consumed.

Worked on Graphical Data Modelling, created and maintained Process Chains.

Configured SLT, BODS (ETL), DXC to connect SAP HANA with SAP systems (SAP ECC & SAP BW source systems) and extracted tables, performed metadata import, schema mapping.

Extraction data using SAP Landscape Transformation (SLT) as data provisioning to HANA.

Worked on extraction of data from Excel, External data base, SAP BW, SAP ECC, SAP Landscape Transformation (SLT) to HANA Data Base.

Created HANA-optimized InfoCube for faster reporting, to accelerate data loads, simplify data modeling and to allow faster remodeling of structural changes.

Worked on graphical Data modelling.

Technology used in project:

OLAP: SAP HANA, SLT, BODS,SAP NetWeaver BW 7.4

OLTP: SAP ECC

Starwood Hotels & Resorts, Stamford, CT 07/2014 – 02/2016

Role: SAPBW/HANA Consultant

Roles Performed:

Created BW Objects for Gross Reporting.

Had created HANA-optimized DataStore Object and InfoCube for faster reporting, to accelerate data loads, simplify data modeling and to allow faster remodeling of structural changes.

Created Virtual Infoproviders in BW on top of BW and HANA Model, transient Infoproviders for SAP BW OLAP Functions to report on SAP HANA Analytic and Calculation Views.

Loading data from different source systems to HANA using SLT (SAP Landscape Transformation) and SAP Data Services tools.

Implemented and developed various scenarios in SAP HANA system related to modeling (Creating Attribute views, Analytical views and Calculation View), Data provisioning (Thru SAP SLT method), Authorization, Import /export etc.

Involved in Data Provisioning from SAP ECC, SAP BW and non-SAP sources via SLT, BODS and DXC, HANA security including User Management, Roles and Analytic Privileges.

Had designed advanced Infoproviders like SPO, Hybrid, Transient and composite Infoproviders.

Experienced in SAP HANA XS and XSJS to read views in Hana and publish data into file systems in JSON format.

Created ABAP Routines in transformations for lookup, imperative logic and for performance Improvement

Involved in Performance tuning and structural fix for repeated issue.

Had worked on creation of workbooks, web reports and scheduled Webi Reports.

Had created Daily Gross Sales, Daily Department Sales and Product lookup by SKU, Product Lookup by Style and Color, Mid-Week Analysis Reports using Webi Tool.

Technology used in project:

OLAP: SAP HANA, SLT, SAP NetWeaver BW 7.4

OLTP: SAP ECC

Alston, Washington 01/2012 – 06/2014

Role: SAP BI/HANA Consultant

Roles Performed:

Involved in creation of Graphical Data Modelling and calculation views using SQL Scripting.

Had worked on creation of users, roles, creation and assignment of analytic privileges.

Had compared Object Versions and validated information models in HANA.

Involved data replication from SAP ECC to SAP HANA via SAP Landscape Transformation (SLT) had created HANA-optimized DataStore Object.

Had created Virtual Infoproviders in BW on top of HANA Model.

Worked on creation of BW Objects in CRM for Activities, Leads and Opportunities.

Had designed advanced Infoproviders like SPO, Hybrid, Transient and composite Infoproviders.

Extensively work BW/BOBJ front end reporting this include new developments, modification, trouble shooting and performance tuning.

Has created ABAP Routines in transformations.

Monitoring and optimization of the replication process in SLT.

Design Queries using restricted and calculated key figures, Variables, Filter, Free Characteristics.

Experience in preparing technical design documents, Back-up and recovery.

Involved in design and development of Opportunity Pipeline, Service Order Closure, Service Order Lead Time dashboards.

Created reports using Webi for interactive analysis, formatted reports using Crystal Reports.

Created reports using SAP BO Analysis using MS and OLAP tools

Configured SLT, created new SLT schema, replicated the data from SAP ECC and non-SAP data, modified the SLT transformation filtered, and added new fields with logic before data loading.

Technology used in project:

OLAP: SAP HANA, SLT, SAP NetWeaver BW 7.3, NetWeaver 2004’s (SAP-BI 7.0) and SAP BO 4.1

OLTP: SAP ECC, SAP CRM

Johnson and Johnson, Piscataway, NJ 01/2011 – 12/2011

Role: Senior Consultant

Roles Performed:

Experience with SAP HANA data modeling with SAP HANA Studio for creation of Attribute View, Analytic View, and Calculation View.

Experience with SAP HANA Data Provisioning and using SAP LT Replication Server (SLT).

Had created reports using webi for interactive analysis, formatted reports for enterprise reporting using crystal Reports

Created Business Explorer reports for search and exploration.

Created portable applications using BO Widgets.

Developed dashboards using Dashboards 4.0/ Xcelsius 2008.

Created Crystal Reports on top of BW and HANA for enterprise reporting.

Involved in SLT configuration and replication of tables by using various replication techniques.

Involved in performance tuning activities such as query stripping, purge in webi. Experience with SAP BO InfoViews.

Trained resources on hot skills like SAP HANA, SAP BW 7.3 and SAP BO.

Design & Maintenance of Customized InfoObjects, Info Cubes, DSO Objects, MultiProviders and Infosets in SAP NetWeaver BW 7.3.

Had worked on creation of workbooks and web reports.

Performance and sizing tuning- Optimizing data loads, index management, defining InfoCubes aggregates, query optimization.

Solving tickets raised by the users within the SLA Periods.

Experience in preparing technical design documents.

Involved in creation of calculation views using SQL Scripting.

Experience in creating Procedures.

Technology used in project

OLAP: SAP HANA, SAP NetWeaver BW 7.3, SAP NetWeaver 2004’s (SAP-BI 7.0) and SAP BO

OLTP: SAP R/3

SABMiller, Bangalore 05/2009 – 12/2010

Role: SAP BI Consultant

Roles Performed:

Design & Maintenance of Customized Infoobjects, Info Cubes, ODS Objects, MultiProviders, Infosets in SAP NetWeaver 2004’s (SAP-BI 7.0).

Worked on Real Time Data Acquisition, Currency and Unit Conversion.

Designing and monitoring of Process chains.

Working on data archiving, functional upgrade / migration of BW 3.5 data flow to BI 7.0.

Business Content Installation and data loads to installed objects.

Design of Queries using restricted key figures, calculated key figures, Variables, Filter, Free Characteristics, Exceptions, Conditions and Cell Editor.

Had worked on creation of workbooks and web reports.

Evaluated statistical performance using BW Statistics. Extensively worked with performance issues using Aggregates, compression of data, Indexes.

Developed dashboards using Xcelsius 2008.

Created dashboards for SAP Cash Management.

Created dashboards for Balance Sheet, Income Statement and Cash Flow Statement data.

Solving tickets raised by the users within the SLA Periods.

Technology used in project

OLAP: SAP NetWeaver 2004’s (SAP-BI 7.0) and SAP BO

OLTP: SAP R/3

Contact this candidate