Vishwa Santhosh Kumar Duvva

abj32x@r.postjobfree.com

SAP BW/BI/ABAP

+901-***-****

Summary:

Having 9+ years of IT experience in SAP as BI & BW 3.5 / 7.0 / 7.3/7.4

Techno-Functional Consultant and ABAP Developer.

Thorough understanding of SAP BW/BI architecture including Modeling custom

infocubes, Data Store Objects, and Data Sources and Planning Scenarios.

Thorough understanding of SAP ERP Functional areas - FI, CO,

SD,OTC,RTR,P2P, MM, Vistex,Pricing,CRM.

Proficient with BW Admin Workbench, Data Extraction, BODS,Transformation

(ETL) and Loading, Transport management, Bex 7.0 Analyzer, query

performance tuning, and aggregates.

Worked extensively with Process Chains, ETL (LO & LIS Cockpit), Delta

Initialization, performance tuning, and investigations with transfer/update

rules,APD'S and Open Hub Destinations.

Extraction and enhancement of datasources from ECC, SCM and CRM systems.

Requirement gathering and lead the team (Offshore and onsite model).

SAP HANA, BW HANA architecture, design and data modeling expertise.

Developed data models using SAP HANA studio and SAP BW powered by HANA.

Expert skills in Data Services/Data integrator in design, creation, and

implementation of BODS/BODI Jobs. Performed complex transforms in dataflow

using data services.

Creation of generic Datasources using Function Modules and Tables/Views.

Involved in writing Routines (Start, End, Expert, and Infopackage).

Extensive knowledge in Data source Enhancement, Generic Extractors, User

Exits, Data Loading (Full /Delta Up-Load), Scheduling, Monitoring, Process

Chains, MultiCube, Data Mart and Open Hub Service.

Involved in Entire SDLC process ( Function spec/Tech spec preparation and

review, Coding and testing faces)

Expertise in understanding SAP R/3 system and experience in ABAP/4

programming techniques

Expertise in Front-End Business Warehouse components like Query

development, Calculated and Restricted key figures, structures, Variables,

BEx analyzer, WAD (Web Application Designer), Jump analysis using RRI

(Report-to-Report Interface), Web Reports, WEBI, Xcelsius and Dash Boards.

Well Knowledgeable on Data Integrator between SAP BI and Business objects

Reporting Environments.

Worked on Non-SAP data source like Flat file, DB2 .

Good knowledge in using Universe Designer over BEx queries and Info Cubes

to migrate & model data from BI to BO for reporting. Excellent skills to

develop reports using WEB I. Valuable knowledge of Crystal Reports.

Extensive experience in Business objects reporting, in the context of

developing the Universe using the Universe Designer and the Analytics using

Xcelsius, Webi and Crystal.

Extensive experience in Classical and Interactive Reports, Transactions,

BDC, Scripts, LSMW, ABAP/4.X Development Workbench, Data Dictionary

Objects, User Exits, Performance Tuning, SAP Internet Transaction Server,

Web Application Server.

Developed objects in the Domains of Retail, Pharma,

Automotive,Manufacturing, Transports, Educational industry and Finance.

Exposure to ALE, BAPI, BADIs, IDOC

Academic Qualification:

Master of Business Administration (M.B.A) with Systems from Osmania

University, 2005.

Bachelor of Computer Applications (BCA) from Osmania University, 2003.

Expertise in SAP BW & BI:

Modeling: Extensively involved in creating Info Objects, Info Sources,

Infocubes, DSO objects, MultiProviders, Data Sources, Transfer rules,

Update rules, Communication structures, Extractors, Info packages, Info

object catalogs, Info Package groups and Process Chains. Involved in

infocube and Datastoreobject Re-construction.

Extraction: Lo, Generic, LIS, Flat file and Legacy systems for master and

transactional data. Activating Data Sources, setting up of V3 updates,

deleting setup tables and filling up of cluster tables, customizing and

enhancement of Extract Structures.

Reporting: Bex 7.0-analyzer, Report Designer, Web Report Designer and

Condition reporting, Exception highlighting, restricted key figures,

Variables, filters, Free Characteristics, Variants, and Structures.

Performance Issues & Tuning: Aggregates, BI Statistics, Indexes,

Partitioning and Compression.

Technical Expertise:

Data Warehousing SAP BI 7.0 (Modeling, Transformations, Data loading, Process

chains, Data flow Design and Data Reconciliation, BI

Integrated Planning), SAP BW 3.5/3.1C

ERP SAP R/3 4.6/4.7C - FI/CO, SD, MM, PP, PM, QM. SAP Netweaver

New Dimensional Products (APO, SRM and CRM)

Reporting Bex 7.0 Query Designer, Bex 7.0 Report Designer, Bex7.0 Web

Reporting, Bex 7.0 Broadcaster, Visual Composer, Portal

Report Designer, Crystal Reports with Crystal Enterprise11

And Business Objects (WEBI, Crystal Reports, DESKI and

Excelcius).

Languages ABAP/4,C, C++,Visual Basic, Java, J2EE, EJB, HTML, XML

Databases: Oracle, MS-SQL server, DB6, MS-Access

Operating Systems: Windows 2000/ NT/98/95

Projects Exposure: SAP

Project # 1

Customer : HP - Hewlett Packard

Project Period : Nov 15, 2012 - Till date

Role in the project :Sr.SAP BI/HANA/ABAP Consultant

Environment : SAP ECC 6.0, BI 3.5/7.0/7.4, FI/CO, SD, MM, CRM,

SAP BEx Analyzer, SAP HANA 1

Brief Description of Project:

The Hewlett-Packard Co is an American multinational information

technology corporation. It provides products, technologies, software,

solutions and services to consumers, small- and medium-sized businesses and

large enterprises, including customers in the government, health and

education sectors.

Roles & Responsibilities.

Worked in complete BI flows for master and transactional data consisting of

various SAP Modules like FI, MM, SD, LO cockpit.

Migration of data flow from 3.5 TO 7.0.

Created generic datasources using Table/View, Function Module to extract

data from R/3 source system.

Extensively involved in Activating Business Content for Standard Infocubes,

InfoSources & InfoObjects of S&D Module as per the Client Requirements.

Created and Maintained Transfer Structures, Communication Structures,

Transfer rules and Update Rules for InfoSources, ODS objects and Infocubes

User Exits and Enhancements.

Generated transactional Data InfoSources and Master Data InfoSources

(Texts, Attributes and Hierarchies)

Worked with Transactional Data InfoSources to load Data from SAP R/3 and

Flat Files systems into SAP-BW.

Worked on the new functionalities of SPO, Hybrid provider, Transformations,

Info package, DTP, Open Hub service, Process chains, improved data loads

for DSO & Master data in SAP BI 7.3.

Designed the HANA solution and developed HANA data models.

Created HANA attribute views, analytical views and calculation views in

HANA

Worked with BEx Analyzer to generate Queries and also published the queries

onto the web using Free Characteristics, RRI-Jump Queries Calculated and

Restricted Key figures, Filters, Variables and Exceptions

Created Daily Sales Reports which involves Daily Sales Orders, Order

Reasons, Customer Group and other important sales data.

Created daily invoicing report involving all import billing data and

Created daily back order report involving import sales, material and date.

Project # 2

Customer : ABBOTT Laboratories. Symphony Phase-I

implementation, Waukegan, IL

Company : IBM

Project Period : June 2011 - April 2012

Role in the project : Sr. Consultant.

Environment : SAP BI/BW (3.5, 7.0,7.3), ECC 6.0, SD, MM, FI,

SAP BEx Analyzer.

Brief Description of Project:

Abbott laboratory is a global, broad-based health care company devoted to

discovering new medicines, new technologies and new ways to manage health.

Our products span the continuum of care, from nutritional products and

laboratory diagnostics through medical devices and pharmaceutical

therapies. Our comprehensive line of products encircles life itself -

addressing important health needs from infancy to the golden years.

Abbott has sales, manufacturing, research and development, and distribution

facilities around the world, close to where our customers need us to be. We

are recognized for our global reach and our ability to serve our customers

around the world.

Roles & Responsibilities.

Worked in complete BI flows for master and transactional data consisting of

various SAP Modules like FI, MM, SD, LO cockpit.

Created generic datasources using Table/View, Function Module to extract

data from R/3 source system.

Extensively involved in Activating Business Content for Standard Infocubes,

InfoSources & InfoObjects of S&D Module as per the Client Requirements.

Created and Maintained Transfer Structures, Communication Structures,

Transfer rules and Update Rules for InfoSources, ODS objects and Infocubes

Generated transactional Data InfoSources and Master Data InfoSources

(Texts, Attributes and Hierarchies)

Worked with Transactional Data InfoSources to load Data from SAP R/3 and

Flat Files systems into SAP-BW.

Worked on LO Cockpit and LIS Extractions

Loaded the data from R/3 to BW.

Created Info Packages and Info Package Groups and scheduled them.

Enhanced standard extractor to populate the custom fields using user exits.

Worked in LO extractors and activation of LIS datasources.

Installed the Standard Business Contents for all standard InfoObjects with

transfer rules, update rules, DSO etc.

Involved in the activity of migrating the 3.x Datasources to 7.0 along with

the standard transformation/routines.

Created Write-optimized and Standard DSOs as per business requirement in

different BW layers.

Created Open Hub Destination to load the BW data to 3rd party system.

Worked in ABAP routines - Start routine, End routine and Expert Routines in

transformations - written codes for master data look-up, filtering data

from source package, used function module for various conversions, etc.

ABAP coding in ECC side - creating Programs for append structure fields in

CMOD, worked in Function Module for generic datasource.

Worked in Data Modeling - Creating InfoObjects, Datasource, Infopackage,

DTP, Transformations, DSO, Infocubes, Open Hubs, etc.

Data loading and unit testing with proper documentation.

Involved in the activity of Process Chain creation for Master and

Transaction data.

Involved in the Transport collection activity for moving the objects from

Dev to QA system.

Project # 3

Customer : Cardinal Healthcare MBT, DUBLIN, OH

Company : IBM

Project Period : Aug 2010 - May 2011.

Role in the project : Sr. Consultant.

Brief Description of Project:

Cardinal Health, Inc. is a health care services company based in Dublin,

Ohio. Cardinal health specializes in health care supply chain services,

providing pharmaceuticals and medical products. Cardinal has an existing

implementation of one or two SAP modules. The current implementation will

be implemented across 5 geographies for the entire SAP BI module.

Roles & Responsibilities.

Customized Info Objects, Info Sources and Info Cubes.

Worked extensively on standard and custom defined LIS, LO-Cockpit, and

Installed relevant SAP business content.

Used LO structures for extracting sales order, delivery billing

information.

Created and worked on daily basis with Extractors, Generic Extractors

Designing of Info cubes and ODS objects by considering the different

business scenarios.

Worked in complete BI flows for master and transactional data consisting of

various SAP Modules like FI, MM, SD, VISTEX, LO cockpit.

Created generic datasources using Table/View, Function Module to extract

data from R/3 source system.

Enhanced standard extractor to populate the custom fields.

Worked in LO extractors and activation of LIS datasources.

Installed the Standard Business Contents for all standard InfoObjects with

transfer rules, update rules, DSO etc.

Involved in the activity of migrating the 3.x Datasources to 7.0 along with

the standard transformation/routines.

Created Write-optimized and Standard DSOs as per business requirement in

different BW layers.

Created Open Hub Destination to load the BW data to 3rd party system.

Worked in ABAP routines - Start routine, End routine and Expert Routines in

transformations - written codes for master data look-up, filtering data

from source package, used function module for various conversions, etc.

ABAP coding in ECC side - creating Programs for append structure fields in

CMOD, worked in Function Module for generic datasource.

Worked in Data Modeling - Creating InfoObjects, Datasource, Infopackage,

DTP, Transformations, DSO, Infocubes, Open Hubs, etc.

Data loading and unit testing with proper documentation.

Involved in the activity of Process Chain creation for Master and

Transaction data.

Involved in the Transport collection activity for moving the objects from

Dev to QA system.

Environment: SAP BI/BW (3.5, 7.0),ECC 6.0, SD, MM, FI,CRM, SAP BEx

Analyzer.

Project # 4

Customer : Fender Musical Instruments Corporation,

Scottsdale, AZ

Company : IBM

Project Period : Jan 2010 - July 2010.

Role in the project : Consultant.

Brief Description of Project:

Fender Musical Instruments Corporation (FMIC) is the world's foremost

manufacturer of guitars, basses, amplifiers and related equipment.

Security Upgrade of BW 3.5 to BI 7.0 with Analysis Authorization.

The objective of this project is to upgrade BW system from 3.5 to BI 7.0

SP13 and to migrate the existing reporting authorization to Analysis

authorization using RSEC_MIGRATION.

Responsibilities

Full Life cycle upgrade experience includes current system study, proposed

the design of target database, Business requirement gathering, gap

analysis, system design, configuration and upgrade, regression testing, Go-

Live and Production support for BI 7.0 system and training to end users.

Migrate the existing security (authorization objects for BEx) from 3.5 to

BI 7.0 (Analysis Authorization).

Designed and implemented analysis authorizations using RSECADMIN where new

authorizations required.

Implementing the BI 7.0 concepts of Transformations and DTPs using the

existing datasource migration.

Create the new BI authorization objects and assign it to users via roles,

also direct assignment.

Complete migration of datasource from 3.x to 7.0 and check the behavior of

extraction and its recovery for the procurement cycle.

Post Production support, which involves daily monitoring of data loads via

process chains, trouble shooting and correcting the known errors and

escalating the unknown to the SAP support team.

Redefine the procurement process chain to schedule the load as per SAP's

benchmark

Redefine the queries based on the Procurement process and creating them

using New Netweaver 2004s Front-end tools - like report designer, Web

Application designer etc.

Co-ordinate with SAP support through Service marketplace (formerly OSS) for

solving the high priority problems thought tickets.

End user training in new functionalities of BI 7.0, Design of BW models,

data flow involving DTP and TRFs, migration of datasources and its effects

and new reports created using 2004s Front-end Tools.

Environment: SAP BI/BW (3.5, 7.0), ECC 6.0, SD, MM, FI,CRM SAP BEx

Analyzer.

Project # 5

Customer : Veolia RICEF Development (France)

Company : IBM

Project Period : Jan 2009 - Dec 2009.

Role in the project : Sr. Consultant.

Brief Description of Project:

Veolia Environnement is a multinational company with activities in four

main areas - water management, waste management, energy and transport

services. In 2007, it had revenues of $47 bn and employed around 300,000

people. Veolia Water specializes in water and wastewater services for

municipal and industrial clients, deploying specific solutions tailored to

local needs worldwide.

Roles & Responsibilities.

Designing and modeling the entire architecture for the Data Extraction and

Infoproviders and process automation for the data loads.

Designing the Custom Extractions from the CRM system for the Business

Planning and Enrollments Modules.

Designing the Flat file Extractions for the Budgeting Forecasting Modules.

Designed and Developed the Process automation for the Master data loads and

the Transactional Data Loads.

Developed the custom extraction for the Organizational unit User Data. This

is used for deriving the Territory, District, Region and Business Segment

Users for accessing the data at their levels.

Helped the Security Design to develop the roles and authorizations.

Developed the Planning Layouts and Interfaces to execute the planning

functions.

Environment: SAP BI/BW (3.5, 7.0), ECC 6.0, SD, MM, FI, SAP BEx Analyzer.

Project # 6

Customer : The Walt Disney Company (BVHE) Project U.S

Company : IBM

Project Period : July 2008 - Dec 2008.

Role in the project : Consultant

Brief Description of Project:

The Disney Legends program was established in 1987 to acknowledge and honor

the many individuals whose imagination, talents, and dreams have created

the Disney magic. Since its inception, the program has honored many gifted

animators, Imaginers, song writers, actors and business leaders as having

made a significant impact on the Disney legacy.

Roles & Responsibilities.

Created generic data sources using Table/View, Function Module to extract

data from R/3 source system.

Enhanced standard extractor to populate the custom fields and debugging the

code.

ABAP coding in ECC side - creating Programs for append structure fields in

CMOD, worked in Function Module for generic data source.

Worked in ABAP routines - Start routine, End routine, field routine and

Expert Routines in transformations - written codes for master data look-up,

filtering data from source package, used function module for various

conversions, etc.

Worked in Data Modeling - Creating InfoObjects, Datasource, Infopackage,

DTP, Transformations, DSO, Infocubes, Multi providers and Info Provider

etc.

Created Bex Reports.

Worked on activating business content.

Worked on CRM commissions' module extensively.

Extensively involved in Activating Business Content for Standard Infocubes,

InfoSources & InfoObjects of S&D Module as per the Client Requirements.

Created and Maintained Transfer Structures, Communication Structures,

Transfer rules and Update Rules for InfoSources, ODS objects and Infocubes

Generated transactional Data InfoSources and Master Data InfoSources

(Texts, Attributes and Hierarchies)

Worked with Transactional Data InfoSources to load Data from SAP R/3 and

Flat Files systems into SAP-BW.

Worked on LO Cockpit and LIS Extractions

Loaded the data from R/3 to BW.

Created Info Packages and Info Package Groups and scheduled them.

Worked with PSA in Monitoring the Data Transfer from Source systems into

BW.

Worked on activating the standard business content infocubes.

Generated and Maintained Aggregates and Rollup activities.

Involved in Designing the Queries and Optimization of the queries is taken

care.

Identifying the reporting Requirements by circulating the Requirement

gathering Templates

Conducted the Work Shop on Reporting requirements.

End user training on making use of the reports generated by BW System

Environment: SAP BI/BW (3.5, 7.0), ECC 6.0, SD, MM, FI, SAP BEx Analyzer.

Project # 7

Customer : Vodafone EVO, UK

Company : Accenture Services PVT LTD

Project Period : Aug 2007 - June 2008.

Role in the project : Consultant.

Brief Description of Project:

Vodafone is the largest mobile telecommunications network company in the

world by turnover and has a market value of about 86 billion (November

2006).

Roles & Responsibilities.

Full Life cycle upgrade experience includes current system study, proposed

the design of target database, Business requirement gathering, gap

analysis, system design, configuration and upgrade, regression testing, Go-

Live and Production support for BI 7.0 system and training to end users.

Migrate the existing security (authorization objects for BEx) from 3.5 to

BI 7.0 (Analysis Authorization).

Designed and implemented analysis authorizations using RSECADMIN where new

authorizations required.

Implementing the BI 7.0 concepts of Transformations and DTPs using the

existing datasource migration.

Create the new BI authorization objects and assign it to users via roles,

also direct assignment.

Complete migration of datasource from 3.x to 7.0 and check the behavior of

extraction and its recovery for the procurement cycle.

Post Production support, which involves daily monitoring of data loads via

process chains, trouble shooting and correcting the known errors and

escalating the unknown to the SAP support team.

Redefine the procurement process chain to schedule the load as per SAP's

benchmark

Redefine the queries based on the Procurement process and creating them

using New Netweaver 2004s Front-end tools - like report designer, Web

Application designer etc.

Co-ordinate with SAP support through Service marketplace (formerly OSS) for

solving the high priority problems thought tickets.

End user training in new functionalities of BI 7.0, Design of BW models,

data flow involving DTP and TRFs, migration of datasources and its effects

and new reports created using 2004s Front-end Tools.

Environment: SAP BI/BW (3.5, 7.0), ECC 6.0, SD, MM, CRM,FI, SAP BEx

Analyzer.

1

2

3 Project # 8

Customer : COACH, USA

Company : Accenture Services Pvt Ltd.

Project Period : March 2006 - July 2007.

Role in the project : Consultant.

Brief Description of Project:

Coach is a leading American marketer of fine accessories and gifts in

leather, suede and signature fabric. Offerings include handbags & purses,

wallets. Coach, Inc. (Coach) is a designer and marketer of handbags and

accessories. The Company offers luxury lifestyle accessories to the

customers and provides consumers with fresh and relevant products. Coach's

handbags and accessories use a range of quality fabrics and materials

Roles & Responsibilities.

Scheduling and monitoring of Info Packages.

Maintaining queues related to system-generated tickets and customer

generated tickets.

Maintaining Rechecks for verifying the data in SAP R/3 and SAP BW or not

after the data loads.

Monitoring of Info Packages and Process Chains and analyzing the reasons

for frequent failures of Info Packages and Info Package Groups.

Involved in escalating prioritized tickets regarding extractions,

performance issues and load failures.

Involved in managing of Infocubes, which includes compression, rollup,

index management, aggregates and reconstruction.

Receiving customer generated tickets and resolving them via E-mail and

phone.

To inform on-site people if there any dead locks.

Interacting with the customer for clarifying queries regarding tickets

posted by him.

Maintaining history for all the tickets until they are closed

Environment: SAP BI/BW (3.5, 7.0), ECC 6.0, SD, MM, FI/CO, SAP BEx

Analyzer.

Project # 9

Customer : Siemens PG, USA

Company : Accenture Services Pvt Ltd.

Project Period : June 2005 - Feb 2006.

Role in the project : Technical Developer.

Brief Description of Project:

Siemens is one of the world's leading suppliers of components and systems

to companies in the energy and electricity industry

Roles & Responsibilities.

Created IDOC Extension for IDOC TYPE BOMMAT04 added two segments Z1MATH1 as

a child segment in E1MASTM and Z1POMD1 as a child segment in E1STPOM.

Fields added in Z1MATH1 are MAKTX Material Description, DATUB Valid to date

and AENNR Change number. Fields added in Z1POMD1 are MAKTX Component

description DATUB Valid to date and AENNR Change number

Created a program which gives all BOMs which have created or changed on

particular date and when we select any BOM and execute which is distributed

and IDOC is created this has selection screen of fields 1. Date, message

code (EDIDC-MESCOD) Logical system (TBDLST-LOGSYS).

Created an interface program for all these Idoc data to file. This program

has a selection screen of 1.IDOCTYPE, IDOC status, and Input message,

Output message.

Interaction with the client for understanding Business Subjects and also

involved in creating the documents like Functional and Technical

Specification.

Developed IDOC and Enhancement Framework.

Developed Conversion program (using BDC's).

Creating layout using SAP Scripts, Smart forms.

Generated Reports (Classical and Interactive) and ALV Reports.

Functional Spec's review

Preparation of technical specification and Technical Spec's review

Engage in actual development (coding / creation of custom objects)

Code review for developed objects and preparing Q.A Review reports.

Tracking and maintaining the issue resolution.

Created an outbound interface program which will extract POD data from all

tables of VTRKH, VTRKP, VEPO, LIKP, LIPS, VBAK, LFA1, LFB1, ADRC, KNA1

with selection screen of POD Date, POD Status, Sales Organization and

Sales Order type and sending that data to external systems Mosaic etc via

SAP XI.

Created a Layout and has written program logic to extract the data in a

script by using perform for INVOICE

Environment: 4.7 EE, SAP Script, ABAP

Key Strengths

Ability to quickly master new software's and apply its full range of

capabilities.

Flexible and versatile to adapt to any new environment and work on any

project.

Possess strong problem solving and analytical skills with ability to follow

project standards and procedures as per client specifications.

Excellent work ethics, self-motivated, team player, and team oriented.

Productive coding habits, excellent logical aptitude and communication

skills

Contact this candidate