RAVI SHANKAR NALLAM

SAP BI Consultant

ace3zy@r.postjobfree.com

+91-961*******

Professional Skill Summary

• Having total and relevant experience as 3 years in SAP BI using Version Sap BI 7.0

• Expertise in analysis, design, enhancements, operation & maintenance, implementation

and support in SAP BW/ BI

• Expertise in Extraction, Transformation and Loading (ETL) operations with SAP and Non

SAP Systems. Expertise in implementing LO cockpit, Data source enhancements.

• Expertise in working with SAP and Non SAP source system and maintenance of delta

and update mechanism.

• Expertise in creation and monitoring of Process chains and error rectification.

• Advanced knowledge on Bex Analyzer and Query designer.

• Experience on Info cube management and performance tuning with Aggregates,

Compression, Rollup, and Creation of Indexes.

Educational Qualification:

• Masters (M.sc) in Business Information Systems Management (2010-2011) from

Middlesex University, London.

• B.Tech from JNTU KAKINADA in the year 2009 with 60.6%.

• Intermediate from Board of Intermediate Education in the year 2005 with 77%.

• SSC from Board SSC Education in the year 2003 with 84%

Professional Experience:(All are under contract positions):

• Worked as SAP BI Consultant with Unilever plc, UK from Jan 2013 to April 2014.

• Worked as Junior SAP BI Consultant with AC Nielsen, UK from May 2011 to Dec 2012.

Project Experiences:

Project 1:

Client: Unilever plc.

Organization: Biz Plannet solutions

Role: SAP BI Consultant

Duration: Jan 2013 to April 2014

Responsibilities:

• Designed and developed SD modules in BI 7.0. This includes Order Items, Delivery

Service and Sales History.

• Sales Orders 2LIS_11_VAHDR, VAITM, VCHDR, VCITM, VDHDR, VDITM which includes

Sales Orders Header, Item, Delivery Header, Delivery Item, Billing Document Header,

Billing Document Item.

• Extensively worked on Sales History Historical reports sourced historic data from SAP

ECC system for Master Data and Historical Reporting.

• Loading data from Flat file by creating custom Info objects and Data sources.

• Working on SAP BEX Reporting Tool for Creating Query’s as per Client Business

Analysis.

• Monitoring of process chains and fixing data load issues as a part of support.

Project 2:

Client: AC Nielsen

Organization: Biz Plannet solutions

Role: Jr. SAP BI Consultant

Duration: May 2011 to Dec 2012

Responsibilities:

• Developed Info cubes, Multiproviders, DSO, Info objects, DTP and Transformations.

• Worked on Restricted key figures, Calculated key figures, variables, RRI, etc.

• Improved both query and loading performance.

• Worked on Info cube management with Aggregates, Roll up, Compression and Indices.

• Created Transports from development to quality and production system.

• Used PSA edition and error handling, activation of BI contents.

• Enhanced Data sources according to the Business requirements.

• Designed queries using Bex Query designer.

• Worked on Structures, Conditions, and Exceptions.

• Created Open hub destination to provide data to data stage team.

Contact this candidate