Data Sap

Venkat

Nalluri

SAP- BW/BO Consultant

E-mail: ******.***@*****.***

Phone: +1-913-***-****

Summary

. Over 9 years of IT experience, including 7+ years in SAP BW, SAP R/3

and SAP BI from the blue print to the go-live stages.

. Worked on all phases of data warehouse and database development

lifecycle, from gathering requirements, implementation, testing and

support.

. Functional and Technical expertise in SAP BW in the ECC FI-CO, SD, MM,

PM and PS modules.

. Experience in Data Modeling, Data Extraction, Data Loading (Full

/Delta Up-Load), Scheduling, Monitoring, Process Chains creation,

Reporting - BEx Analyzer/Browser, BEx Query Designer

. Delivered value by working with end users to understand their

perspective and larger needs of the project to solve potential

problems

. Experience in extracting data from R/3 systems using different extract

structures like LIS, LO Cockpit and generic extractors for a variety

of application areas such as SD, MM, PM, FI-CO and PS module.

. Extensive experience in user requirement gathering and gap Analysis.

Liaison between business analyst and technical staff to find

information gaps.

. Expertise in SAP BW components including data Extraction, modeling and

reporting.

. Designed data models, DSO, Info-cubes, and developed queries and

workbooks in the BEx Analyzer using conditions, structures, calculated

and restricted key figures, character variables, formula variables and

text variables.

. Experience in extracting data from R/3 systems using different extract

structures like LIS, LO Cockpit and generic extractors for a variety

of application areas such as SD, MM, PM, FI-CO and PS module.

. Worked extensively with Web Application Designer to publish reports

developed in the query analyzer to the web.

. Hands on experience on Business Objects XI 3.1 tools - Universe, WebI,

Crystal Report 2008.

SAP BI/BW EXPERTISE

. SAP BW components - Strong working knowledge of Info Objects, Info

Cubes, Info Source, Update Rules, Transfer Rules, Transformation Rules,

Data Transfer Process (DTP), Multi Providers, Remote cubes, and Open

Hub Service.

. Extractions - Experience in extracting data from SAP R/3 using LO

Cockpit, Generic Extractions, and also extracted data from the flat

files. Experience in ETL extraction from R/3.

. Extracted data from Logistics SD, MM and FI/CO. Good knowledge in COPA

extraction.

. Data Loading - Experienced in performing data load using Info Package,

performing Initial /Full/ Delta Up-load, Scheduling and Process Chains.

. Customizations - Experience in activating standard Business Content,

and enhancing Info Cubes according to the requirements, Data Source

Enhancement, Formula Builder and update/transfer rules creation.

. Reporting - Experienced in developing Queries with Calculated Key

figures, Restricted Key figures, Structures, Variables, Exceptions,

Conditions and Jump queries.

. BEx - Worked in BEx Analyzer in building Queries, saving it in

Workbooks (Excel Worksheets).

. Web Reporting - Developed web reports, web items, customized web

templates using web application designer (WAD) and query designer.

. Open Hub: Downloaded data from SAP BW into flat files

using Open Hub Services to feed other sources as per the

business requirement

Skills

. Languages : C, Java,VB Script, HTML,

ABAP.

. ERP Tools : SAP R/3 4.6 C, ECC 6.0

(Business Areas: MM, SD, PP), SAP

BW version

3.0/3.1/3.5, SAP BI-7 (NW2004s)

. Reporting Tools : Query Builder, BEx

Analyzer, Business Objects

. Database/Tools : Oracle 10g/9i,

PL/SQL, SQL Navigator, Toad, MS Access

. Web/App servers : Web logic, JBoss,

Apache Tomcat

. MS Office Tools : MS

PowerPoint, SharePoint server, Visio

. Operating Systems : Unix, Linux

and Windows, MAC

. Tools :

Informatica, Quality Center, SAP BEx,

Cognos, BOBJ, Excelsius.

Education Bachelor's degree in Computer Applications

Master's degree in

Information Technology

PROFESSIONAL EXPERIENCE

Project/Perio POLARIS

d Feb'2013 - Till date

Role Sr SAP BI/BW Developer

Company 3M, St Paul,MN

Tools/Languag NW 2004S/BW 7.3, ECC 6.0, CRM, GRC Tool, HANA, Business Objects 4.0.

es

Involved in the project from gathering user requirements, preparation

Responsibilit of technical specifications documents, designing and developing reports

ies and unit testing (UAT).

Designed and developed CRM Mailing Outbounds as a part of Campaign

Report. This includes information like CRM Marketing Element, Sales

Orders to determine prospective customers based on previous sales

through campaigns in CRM.

Created the process chains for CRM Master and transactional data

Created Datasources on CRM which includes Outbound Customer Contacts,

CRM Marketing Element, Trade Promotion, Target Groups - Business

Partners.

Participated in project planning sessions with project managers,

business analysts and team members to analyze business requirements and

outline the proposed solution.

Built and customized Info Objects, InfoCubes, ODSs, Infosets and

MultiProviders based on the functional specifications

Post migration clean and optimization to save 25% of disc space on new

BW 7.3 BW on HANA system.

Created dashboard by using Xcelsius retrieved data from Excel file by

using Live Office.

Created Infopackages in the Development system and performed new

InfoObjects data load tests.

Installed Business Content for Standard InfoObjects, Cubes, DSO and

Queries for CRM.

Monitored data extraction and created queries according to requirement.

Added functionality to Transactional DataSources through Enhancements.

Configured BEx Queries for Free Characteristics, Key Figures

(Calculated and Restricted),Filters, Variables and Exceptions.

Created Business Objects reports, Queries with constant interaction

with the end users. Trained end users in understanding the reports.

Working on production support for GTA project .Monitoring the loads of

data into Business Warehouse and resolve any issues related to daily

loads.

Project/Perio Multi Instance

d Oct'12 - Jan'2013

Role SAP BI/BW Developer

Company Cargill, MN

Tools/Languag NW 2004S/BI 7.3, ECC 6.0, MM, SD, PP, FICO, HANA, Business Objects 4.0.

es

Worked on standard and custom defined LO extractors. Installed relevant

Responsibilit SAP business content. Used LO structures for extracting sales order,

ies delivery and billing information

Created process chains for periodic upload of the master data as well

as the transactional data.

Designed Transformations and DTPs as per the requirement. Developed

ABAP routines and User -exits for this purpose.

Created (Master/Detail, Cross tab, Chart templates) reports using

Crystal Reports.

Extracted data from data sources like 2LIS_02_ITM,

2LIS_02_SCL, 2LIS_02_HDR and populated into the procurement

infocubes 0PUR_C07, 0PUR_C08, and 0PUR_C09 to evaluate service levels.

Worked on Hierarchy Levels and developed hierarchies to support drill

down reports.

Worked on with Business Explorer (BEx) Tools, BOBJ (Webi, Crystal

Excelsius) in providing standard and customized reports and solutions.

Assisted SAP Basis team in installing HANA 1.0 and solely integrated it

with Business Objects 4.0 and BODS4.0.

Created HANA calculation views and developed the Webi reports and

dashboards.

Extensive experience in creating reports with Charts (bar chart, Pie

chart...etc), Cross-tabs and Sub reports.

Worked with business team to closely to clear open CRQ's

Created Transformation Routines, Start Routines, End Routines as per

the requirement and for the lookups from one DSO to other.

Filled setup tables for the LO-Cockpit extraction, performed V3 update

using LBWE to get the data from the outbound queue of the ECC system to

the delta queue of the BI system.

Project/Perio BI Developer

d Oct' 07- Sept 2012

Company Sprint Nextel, Kansas

Tools/Languag Business Objects/BW 7.0, ECC 6.0, SD,FI/CO, BO XI 3.1, crystal reports

es 08, SAP BW/BEX, Dashboard Design, Universe Design, Webi Reports.

Involved in Modeling, Customized Info Cubes, Info Sources, Multi

Responsibilit Providers, Update Rules, and Start Routines, Business Content, Generic

ies data extraction, Data Loading (Full/Delta Up-Load), Scheduling,

Monitoring Performance tuning and extracting.

Responsible for loading Master data (Texts, Attributes and

Hierarchies)/Transaction data from ECC Data Sources and from Flat

Files.

Regarding Logistics Extraction Cockpit, Maintained extract structures

for Sales & Distribution generated data sources & activated the extract

structures for the above modules. Scheduled data uploads in cockpit.

Analyzed the differences between different kinds of Order intakes in

Sales and Distribution.

Worked on Query building, Filtering, Free Characteristics, Restricted

Key Figures and Variables, Query variants using BEx Analyzer.

Worked on with Business Explorer (BEx) Tools, BOBJ (Webi, Crystal

Excelsius) in providing standard and customized reports and solutions

Responsible for monitoring the daily production data loads and fix the

issues.

Created Business Objects reports, Queries with constant interaction

with the end users. Trained end users in understanding the reports.

Functionalities such as Slice and Dice, Drill mode and Ranking were

used for Multidimensional Formatting.

CO-PA Implementation:

Extracted CO data to incorporate overhead Cost controlling and Cost

Center Accounting data in BW reports.

Developed reports for Business profitability analysis, Profitability

summary by product

hierarchy, customer purchase summary, Profitability detail by product.

Responsible for the evaluation of the current system and defining the

scope of the BW project for cost controlling and developing extractors

and reports.

AR and AP Systems:

Implemented Business Content of General Ledger, Account Receivable,

Accounts Payable, Fixed Assets, Controlling and Profitability Analysis.

This involved making changes to extractors for 0FI_AP_4 and 0FI_AR_4,

info-sources, DSOs, Cubes, transformations and multi-providers and 14

queries.

Extracted data from the finance modules like AR, AP and GL and enhanced

the standard datasources 0FI_AP_04, 0FI_AR_04 to meet the client

requirement.

Created Formula Variables, Conditions, Exceptions, Exception, Customer

Exit Variables and Structures for developing BOBJ reports.

Project/Perio SAP BW Implementation

d Aug'06 - Sept '07

Role SAP BI Developer

Company American Standard, NJ

Tools/Languag SAP BW Version 3.1C, BEx Analyzer, Windows, Oracle 9i

es

Worked on various BI 7.0 (NW'2004s) specific features including Data

Responsibilit store Object (Standard, Write optimized, Direct update), DTP,

ies Transformations, Info Sets, Process chains, BI Reporting, Business

Content, Generic extraction

Responsible for interacting with Functional Team to validate data in

R/3 and BI.

Worked extensively on LO Cockpit, application specific and generic

extractors.

Customization according to requirement of data flow by writing ABAP

routines at START, FIELD and END ROUTINE of Transformation.

Extracted Inventory data using 2LIS_03_BX, 2LIS_03_BF, 2LIS_03_UM data

sources. Initialized delta and Uploaded transaction data from R/3

system to Material stocks and Inventory valuation Infocubes.

Analyzed and activated Relevant Business Content and setup R/3, Flat

File and BW as source systems.

Reconciliation of data from various sources including legacy systems as

Present Data ware houses.

Created Process Chains to automate the Master and Transaction data

loading process, Rollups of Aggregates, periodic Deletion of PSA data

and Compression of data content in the Infocube.

Monitored the SAP BW system which includes monitoring of daily loading

of data into Business Warehouse and resolve any issue related to daily

loads.

Created Process Chains, Info Package, Data Transfer Processes, Data

Load Strategies, etc. for smooth functioning of all Master Data &

Transactional data Loads.

Worked on using the import wizard in moving reports and universes from

Dev to UAT and to Production environments.

Created Web Intelligence reports for ad-hoc requirements across the

board for all kinds of users.

Project/Perio SCM Modules

d May '04 - June '06

Role QA Analyst

Company eXensys

Tools/Languag Windows, SAP SD, MM, HP Test Director

es

Responsibilit Tested the SD, MM modules for Warehouse Management & Contract

ies Logistics

Analyzed the Business Requirements to prepare End to End test cases and

detailed Testing scripts, using both Manual & Automation

Tested the reports for data accuracy & Integririty.

Created SQL statements to validate the data through Backend Testing and

gained proficiency with DB configuration and normalized table

structures

Created Excel sheets for Test Plan documents and exported them to HP

Test Director

Used Test Director to download documents specific to Work Items in HP

Test Director, interacting with other user, Input comments conforming

to projects

Hot Deployment testing (Smoke test) on Web-Centric Applications.

Worked with Interim Builds (Combination of Waterfall & Iterative

Testing) and Service Builds.

Interacted with Product Design & Product Development Teams to

understand business & domain for better testing

Contact this candidate