Resume

Sign in

SAP BW, BO, BW on HANA

Location:
United States
Posted:
January 04, 2017

Contact this candidate

VENKATA RAMANA N

585-***-****

acx4gm@r.postjobfree.com

SAP BI/BW Consultant – Work Experience

* + years of experience in SAP BI, worked in different types of projects, implementation, production support and transition

Excellent communication with users during support and for requirement gathering in implementation phase.

Expertise in SAP HANA Studio Modelling in creating various information models like Attribute, Analytic and Calculated Views.

Involved in Extraction, Data modelling and Design of Info Objects, Cubes, DSO Objects, Transformations, Composite Providers, Multi Providers, Process Chains, Generic Data Sources

Worked extensively on Logistics Cockpit extractions for uploading the data from R/3 to BW, initialized delta and uploaded transaction data from R/3 systems.

Excellent with incident resolution, change management, Service now and IBM Tivoli monitoring tool

Documentation in the form of RCAs, TDD and FSD.

Trained in SAP HANA, SAP BODS, SAP BO, SAP Lumira and Business Objects Analysis tool (MS office)

SAP BW ON HANA

Good exposure on SAP HANA Studio, Data Modeling using Attribute Views, Analytic Views and Calculation Views.

Good exposure on replicating and loading tables in HANA using BODS, SLT

Creating Calculation and Analytic views on the replicated tables.

Used CE Functions for reading the data for information Views.

SAP BW/SAP CRM/Oracle as source using SLT and HANA as target with SAP Data Services as the Integrator and developed Jobs in SAP Business Objects Data services (BODS).

Good exposure in HANA Optimized Info Cubes, Open ODS View, Transient, Composite, Hybrid Providers

SKILL SET

SAP BI-BW

SAP BI-BW 7.4 on HANA

SAP Lumira

SAP-Business Objects

IBM Tivoli Tool

Work Experience

Total experience of 7+ years in SAP BW for various projects.

SAP BW on HANA Consultant

Eastman Kodak

October 2013 to Present

Responsibilities:

BW 7.4 on HANA upgrade checks, cleaned up space, retired 3.x objects like infospokes.

Testing of BW 7.4 on HANA in Sandbox environment

Worked on HANA optimized objects

Created Attribute, Analytical and Calculation views

Worked extensively on creating BW end-to-end implementation models: extraction, modeling and reporting.

Weekend Migrations

Year End Activities

Cut over activities across applications like SEM, SA and SD

Pre-Post cutover activities for SP upgrade, Stack upgrade and Security upgrade

Enhancements

Converted infopackage groups to process chains

Created SAP OSS notes and coordinated with SAP for complex issues

Automation through process chain and Tivoli Workload Scheduler

Fixing batch failures immediately

Worked on different kind of user tickets

User issues,

-Reports (Like values are not being reflected in the reports, Bex Analyzer issues)

-Analysis issues, Deltas, Routines, Infoproviders

-Maintaining Work History for all the tickets until it is closed

-Reconciliation issues

SAP BW Consultant

National Grid

July 2010 to September 2013

Responsibilities:

Worked extensively on Logistics Cockpit extractions for uploading the data from R/3 to BW and initialized delta and uploaded transaction data from R/3systems.

Created Line Item dimension for the performance of info cube.

Enhanced the extract structures by adding new fields.

RRI interface between the summarized and detail level reports.

Prepared technical specifications based on the functional requirement.

Creation of Generic data sources using table, view and Infoset query.

Extracted data from non-sap system (oracle database) through DB connection

Creation of various Reports using variables, variable offset, Restricted Key figures and Structures, Filters, conditions and exceptions.

Transported different objects from Development to Quality and Production.

Developed LO customization, extract structures and data sources in sales and material management to facilitate the data extraction to BW

Worked on variables using customer exit to meet the end user requirement.

Developed Process Chains for Daily/Monthly data uploads.

Created Aggregates on the Info cubes to improve the Performance during reporting performance.

Involved in writing Routines (Start / End Routines).

Changes to the existing Reports & Creation of new Reports as per Client’s requirement.

Trained end users to use the new reports and familiarize them with BW functionality.

SAP BW Consultant

Sealed Air

March 2010 to July 2010

Responsibilities:

Performed analysis, design, development and implementation of customized Infocubes and ODS Objects.

Created info objects, data sources, DSOs, transformations, transfer rules and Infocubes

Used function module based extractor to extract the data from R/3.

Created multiprovider for better performance

Created a process chain for automating the whole process

Developed reports on Multiprovider, created variables, cell formatting, formulas, calculated key figures and restricted key figures.

SAP BW Consultant

Kone

June 2009 – February 2010

Responsibilities:

Contribution in the Implementation phase:

Installation of Business content data sources and activation of Standard BW objects.

Design, develop and implement SAP BI 7.0 objects including Extraction, Transformation and Load processes,

Data store objects, Cubes and Reports.

Data Extraction from R/3, Creating Info packages, Scheduling and Monitor settings.

Worked on Logistics Cockpit extractions for uploading the data from R/3 to BW and initialized delta and uploaded transaction data from R/3 systems by V3 updates.

Generic data sources based on views.

Development of objects as per report's requirements.

Transporting objects from development to Quality and to Production by raising SD Ticket.

Involved in creation of design document for info Objects, info sources, info providers, and

Queries.

Involved in System Integration Testing.

Flat file extraction.

Involved in creating process chain to automate the flat file extraction using ABAP code.



Contact this candidate