RAVI SHANKAR NALLAM
SAP BI Consultant
****.*********@*****.***
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.