Data Sap

Vamsi Chaitanya

Sr. SAP BI/BW Developer

Phone: 832-***-****

Email: ***********@*****.***

Professional Summary

. 8 years of experience, in SAP BI 7.0 and BW 3.5 (EDW, Extractors,

Reporting query and analysis, WAD).

. Strong experience and active participation in all phases of a project:

This includes requirement gathering, Modeling, design and development,

Extraction of data, Reporting, Performance tuning, Archiving, Testing,

Process chains and transportation connection.

. Involved in 6 full life cycle implementation of BI projects - BI project

with Logistics which includes Inventory (SD, MM, PP, QM) FI/CO, AR, AP

and SL(Special Ledger)

. Effective in executing multiple tasks and assignments ahead of schedule.

Having good analytical and communication skills, demonstration ability and

having knowledge on EP.

SAP BI Expertise

. Having end to end experience on from Blueprint to Go live and support,

Data Modeling, Extraction, Scheduling, Performance Tuning and strong

experience on data warehousing workbench (EDW) and BEx reporting, web

reporting WAD, APD.

. Experience with new features of Netweaver 2004s BI (DTP, Transformations,

Open Hub, new DSO features, new front-end tools, WAD, APD, integration to

portal, UD connection).

. Modeling- Designing and development of Info Cubes, Info objects, data

source, Transformations, data store objects (DSO), multi-providers, Info

sets, Aggregates.

. Extractions - Extracted data from R/3 with different application specific

and cross- application specific like (LO-cockpit, CO-PA,Business Content,

Generic extractors) from SD, MM, FI/CO and worked with standard extractors

from FI/SL and non-SAP systems flat files,

. Customizations-Enhancement of the standard Business Content for user

specific Requirements, enhancing standard extract structures, enhancing

Data source, (CMOD), Info Spokes, Data Mart interface with BW myself, DB

connection, UD, XML connection, and Archiving, User Exists.

. Data Loading-Creation of Process chains, meta chains, scheduling jobs

. Reporting- Worked Extensively in BEx Analyzer, in building Queries,

Making global and local structures, filters, Restricted key figures,

Calculated key figures, Variables, Exceptions, Cell definitions, formula,

Conditions, RRI jump queries, Workbooks, BEx Browser. Extensively worked

on (WAD) Web Application Designer and APD, BEx

. Worked with standard technical content, ST03 and ST05, Performance tuning

at data extraction level, modeling level, Query designing level. Info cube

partitioning, compression, Aggregates, Indexes, Data Loading Sequence,

Debugging and monitoring capabilities using Query Trace.

. Have worked with the most of loadings from FI, MM, SD, and R/3, flat

files and was the key member in fixing the load issues (timestamp, delta

failures, short dump errors) in production.

. Technical specifications- Prepared documentation to keep track of design

of cubes and DSO, multi provider etc capturing the requirements and

maintaining detail documents.

ABAP - Creation of reports, routines and enhancing user exits and knowledge

on cross application components like ALE, IDOCS, BAPI, RFC.

. Capable of conducting training sessions, KT for users on BI modeling,

reporting etc.

Technical Skills

SAP BW: SAP BI 7.0 (NW2004s) BW 3.5/3.1C/3.0B

Reporting Tools: BEx, Web Reporting

Languages: ABAP/4, C

DBMS: Oracle 8i, MS-SQL Server, MS Access, VBA.

Operating Systems: UNIX, Windows 2000NT, Windows 2003 server.

Packages Known: MS-Office, MS Project

Professional Experience

Client: Honeywell

Apr 09 - Till date

Location: Morristown, NJ

Role: Sr.SAP BI Consultant

Responsibilities:

. Involved in gathering Business Requirements from Users & Business

Analysts for data modeling and design Report and prepared technical

specifications.

. Created InfoObjects, DataSources, InfoSources, Transformations, Routines,

InfoPackages and Data Transfer Process to load Master and Transactional

data from SAP R/3, Flat Files, into BI NW 2004s environment.

. Worked extensively on SAP BI back-end to configure InfoCube, DSO,

InfoSource and InfoPackage.

. Extensively worked on BEx Analyzer, Query Designer, BEx Browser and WAD.

Used Calculated Key Figures, Restricted Key Figures, Variables, Cell

definitions, Conditions and exceptions in the Query creation.

. Designed the Aging reports on Inventory

. Designed Global template for UOP and migrated 3.5 workbooks to BI 7.0.

. Developed Special ledger, Costing reports in BEx query designer by

utilizing various BEx capabilities such as Structures and cell

referencing.

. Monitored the SAP BI system which includes monitoring of daily loading of

data into Business Warehouse and resolve any issue related to daily loads.

. Created Process Chains, InfoPackages, Data Transfer Processes, Data Load

Strategies, etc for smooth functioning of all Master Data & Transactional

data Loads.

. Loaded the data from R/3 to BI and used initialization with delta update

and full update methods and enhancement of various objects.

Environment: SAP BI 7.0 Netweaver 2004s and SAP R/3 4.7, ECC6.0

Client: UOP LLC

Dec 07- Mar 09

Location: Marlton, NJ

Role: Sr.SAP BI Consultant

Responsibilities:

. Conducted requirement gathering workshops with business users. Provided

overview of BW architecture, data modeling, InfoCubes, ODS objects and

reporting functionality.

. Collected requirements in application areas of FI-CO, Distribution and

COPA.

. Defined KPIs for Profit & Loss reports like Operating profit and Gross

Profit for dash board reporting

. Developed COPA, Analysis of Change, and Distributed Cost Reporting

requirements.

. Developed Business Functional model for company business process and

Technical specifications

. Participated in architecture design for the Project & cube definitions &

designs.

. Developed Account based COPA proto type using Cost based COPA to

reconcile COPA data with PCA data

. Worked on activation of the business content for cost controlling and

cost center InfoCubes.

. Created InfoCubes, DSO, info sources and data sources from business

content, COPA and LIS extract structures for FI-CO and SD modules.

. Extended the extract structures by adding new fields and populating them

with the user and function exits.

. Used BEx analyzer to create various reports based on the different

InfoCubes, created calculated key figures and restricted key figures to

improve report output.

. Created a Data Source for cost based profitability analysis in the OLTP

system, replicated to BW system and activated business content of CO-PA

for sales and profitability analysis.

. Interaction with key users along with the BW program Manager to gather

user requirements

. Preparation of Detailed Design Document & Test Cases for testing the

solution

. Created APD, which gives a snap shot of Daily Inventory data across

Material and Plant.

. Involved in Integration Testing, GUI Testing, and Regression Testing

. Prepared Test Plans based on Functional Requirements and Design

Documents.

. Involved in User Acceptance Testing (UAT).

. Transports across the Quality and Production systems

Environment: SAP BI 7.0, SAP R/3 ECC6.0, ABAP/4, BEx Analyzer,, FICO, SD,

MM

Client : Krishidhan Seeds Limited

Nov 06 -

Dec 07

Location: Aurangabad, India

Role: SAP BI Consultant

Responsibilities

. Creating technical Specifications for data mapping, conversion Plan, OLTP

extract processes and legacy extract procedures.

. Analyzing the exiting BW objects for the requirements of the affiliate

and issue new change request for customization and creation for the same.

. Extracted data from SD modules and uploaded the data into the

procurement cubes via 2LIS_11_VAHDR, 2LIS_11_VAITM, and 2LIS_11_VASCL.

. Developed ODS object to load SD Sales Order, Delivery note, Billing

document Data from Business Content delivered InfoSources, defined the

update rules and worked on 0IC_CO3, 0IC_MC01 cubes.

. Responsible for the activation of SAP pre-delivered content and Info

Cubes in the area of Vendor Evaluation

. Developed custom extractors on the R/3 OLTP systems and defined the

extract structures on the source and target systems.

. Coded ABAP Routines for transfer rules, update rules, conversion routines

in BW system.

. Improved data load and query performance by doing compression,

aggregates, partitioning.

. Worked on system tools for tuning like RSRV, ST05.

. Created transfer structures, transfer rules, update rules including

necessary routines wherever required for ODS and Info Cube level.

. Involved in creating reports for Plant Maintenance area, Sales and

distribution area, Inventory Management and ware house management.

. Created Generic Data sources according to business requirements with

views and infoset query.

. Developed Aggregates for Query optimization. And monitor data loading

into the Info Cubes.

. Automated Data Loads through Process Chains.

. Scheduled monthly loads according to the business needs.

. Worked on Web Application Designer (WAD) and published reports on Web

and published iView on Portal.

. Resolved data issues and Query issues of the end users of the BW system.

Client: Dmart

Nov 05 - Oct 06

Location: Mumbai, India

Role: SAP BI/ BW Consultant

Responsibilities:

. Involved in Full life cycle implementation.

. Prepared various design documents for Legacy and SAP systems.

. Created various Customized Info Cubes, Data Store Objects (DSO) and Data

sources.

. Activated Standard Info cubes, DSOs, Update rules, Queries from BI

content.

. Scheduled data loads to DSO and Info Cubes by Full and Delta update

methods.

. Created RFC Connection between Source system and BI system

. Extracted data from 0RT_C02, 0RT_C37, 0SD_O06, 0FIGL_C10, 0FIAP_C03,

0RT_C05, 0RT_C40

. Created Transformation for mapping the fields and written the routines.

. Created Data Transfer Process (DTP) to load the data from various Source

Systems to Data targets.

. Created Info packages to load the data into PSA.

. Created process Chains for automated data loads.

. Transportation of objects from Development to QA and Production systems.

. Written Start and End Routines.

. Setup the Statistical Setup for the LO-Cockpit and used the V3 Update for

Delta Management.

. Created of reports using BEx Analyzer

. Created Restricted Key Figures, Calculated Key Figures, Variables, and

Exceptions.

. Created Variable Offsets for the different Queries.

. Created Web templates using Web Application Designer (WAD)

. Developed various jump targets (RSBBS).

. Enhanced data source for appending fields in to the structure and filling

them using User Exit.

. Modified existing queries based on change request and saving query

results with different criteria for supporting different business

scenarios.

Environment: SAP BI 7.0, BEx Analyzer, BEx Browser, WAD, ECC 6.0,

Client: Connect well industries Pvt ltd

Aug 04 - Oct 05

Location: Mumbai, India

Role: SAP BI Consultant

Responsibilities:

. Ability to Create, configure and maintain data targets: InfoObjects,

DataStore Object and InfoCubes in the BI System.

. Complete command on data extraction from the Source System and R/3 into

the BI System.

. The capacity of DataSource creation in R/3 to advance fields from both

SAP and Non-SAP systems in the form of tables, views and Infoset into the

required Application Components.

. Applied the replication function for the transformation of the DataSource

into the BI System.

. The use of the Transfer Rules, Transfer and Communication Structures to

enhance data mapping or assignment for data targets by the use of update

rules.

. Usage of Master Data and maintenance: Texts, Attributes and Hierarchies.

. Creation and maintenance of InfoProviders, MultiProviders for query

development and reporting.

. Extensive use of Administrative Workbench (AWB) as well as BEx Query

Designer, BEx Analyzer and Web Application Designer.

. Performance optimization in data modeling, loading and reporting through

the use of Aggregates and BW Statistic.

. Efficiently used Process Chain in scheduling sequential and parallel

processes.

. Experienced in the role of a functional analyst to interact with

individuals during project requirement and implementation of integrated

systems.

Client: The Industrial Company-TIC,

May 03 -

Jul 04

Location: Chennai, India

Role: SAP BW Consultant

Responsibilities:

. Involved in Transferring & Replicating the Transfer Structure, Applying

Transfer Rules, assigning Data Source to Info Source.

. Worked extensively on LO COCK-PIT extractors for Loading Data.

. Installing the relevant Cubes & Info Sources in Business Content,

Creating Data Targets, maintaining Update Rules, Creating Info package,

uploading the data.

. Analyzed and Activated Business Content.

. Used ODS to stage the data before transferring the ODS contents to the

Info Cube.

. Extraction of data from SAP R/3 for various info cubes including Customer

Info cube, Material info cube.

. Data upload for both Master data and Transactional Data from the source

system into the SAP BW.

. Scheduling Info packages for loading Master Data and Transaction Data &

Monitoring.

. Monitor data loading into the Info Cubes with respect to BW Data. Data

loading was monitored and the failed data packets were analyzed and if

possible manually edited in PSA (mostly for invalid characters) and re-

loaded to Info cube.

. Worked extensively on BEx-Analyzer and BEx- Browser. Developed flexible

queries using filters, navigational attributes in BEX-Analyzer to

facilitate data analysis in a drill down or summarized way to give

detailed levels of information.

Environment: SAP R/3 4.6C, ABAP/4

Contact this candidate