VENKAT RAPARTHI Cell#: 309-***-****

Email: acczbb@r.postjobfree.com

Worked as BI / APO BW Functional Lead /BPC Consultant for IBM(Panasonic )

from Dec 2006 to

Jan 2014 and available immediately .

Location: NEWARK, NJ

Professional Summary:

. Having 11 years of SAP BW/BI, 3 years of SAP/ABAP Programming and 2

years of Dot Net Programming experience

. Worked in 6 full life cycle project implementation including 2 in

ABAP, 1 in BI and 2 in APO-BW and 1 in BPC

. Have a good Experience in BI 7.0,BI 7.4,BW 3.5, ECC 6.0 SAP R/3 4.0,

SAP R/3 4.6, SAP R/3 4.7 and SCM 5.0

. Good hands on experience in BI,APOBW.BPC,ABAP,UNIX,VBA,SAP Notes

. Discuss with business partners about estimation of each project and

proposed Design

. Translating business requirements into functional specification

document

. Handling production support efficiently and resolving problem tickets

as per SLA and update the status of issues to the user on time

. Perform blueprint, project plans, gap analysis,testing plans,

contingency and cut-over plans and post-implementation support

. Prioritize projects and communicate to key stakeholders on time

. Gap Analysis and process improvement

. Highly contribution whenever system performance is not good

. Identify correct tools and correct platform for large scale projects

. Ability to effectively lead, builds, deliver, and execute complex BI

initiatives

. Designed complex POS(point of sales) Reports and these reports are

very useful for PNA to identify which channel partner store has

Panasonic stock and which store has large Panasonic model sales

. Developing system design document and discuss with team members about

project design. Conducting weekly

Meetings with onshore and offshore team members about status

of problem tickets and status of new projects

Development

. Redesigning of complex loads during upgrade from BW to BI upgrade

. Good experience in business planning tools BPS and IP and creating

function types using FOX and custom types

. Info-Cube management with Aggregates, compression, Rollup,

Reconstruction, BIA, Indexes and partitioning

. Extensive BW development skills in Creating Generic data sources,

Infoset, Application process design, Open Hub, Infpspoke, Cube

Design, ODS Design, update rule, Info source, transfer rules, Defining

the jobs in Process Chain, Designing transformation and DTP,EPM.

. Extensive functional knowledge of FI, SD,MM, Inventory Management

Modules in ECC and GATP,SNP Modules,CTM,CIF,integration modules in

APO

. Performance improvement for complex data loads and BEX Reports

. Installing business content, extending and enhancing as per

requirement

. Extensive ABAP/4 development skills using SAP Script, Smart Forms,Web

Services, BDC, Reports, Function Modules, Data Dictionary, Dialog

Programming, BAPI,RFC, User Exit, BTE, BADI, OOABAP, LSMW,EDI, IDOCS,

ALE,APO-ABAP

. Experience in SAP Application lifecycle Domains. (Application

Development (AD), Application Management (AM) and Application

Outsourcing (AO))

. Good Experience in SONY specific Diversion Process module

. Full cycle implementations of SAP R/3 and BW with hands on experience

of ASAP methodology

. SAP Implementation experience in Steel, FMCG, Auto Mobile and

Consumer Electronics industry domains

Technical Skills:

SAP SAP R/3 4.0/4.6/4.7D/ECC 6.0 - FI, COPA, SD, MM

SAP BW BW 3.5 / BI 7.0,BI 7.4,IP - FI(GL,AR,AP), COPA, SD, MM, DP,

SNP, GATP

Financial General Ledger, New general ledger, Account Receivable,

Accounting General Ledger Configuration, SAP master and Transactional

data, Including General Ledger, Chart of Accounts, Customer

master, Credit Management, Lock Box Processing, Taxation

SCM GATP- ATP Check,Allocation Check, CVC Creation,

Configuring Business events and

SCM ATP Groups, Back order Processing

SNP- CTM,ATP to Physical Receipt Process,Fairshare

Process, Transport lanes, PNA

Subcontract Process, Optimization of overseas Factory POs

shipments, CIF and

Integration Modules

DP - Developed Macros

Master Data- Product Location, TLB Master Data

Maintenance

Sales and Configuring order types, pricing procedures, billing types,

Distribution Credit Management, define condition tables, configuring Sap

script and Smart forms for SD documents, enhancing SD

Communication structures, configuring IDCS for point of

sales,TAB order processing, Mass Serial numbers entry in

VA01 screen enhancements

Material Material master (all views),enhancing MM classification,

Management Inventory management, Purchase requisition to PO conversion

process, Movement types, Drop ship POs, Landed Price,

Moving Avg Price, configuring and enhancing purchase order

IDOC structure, configuring NACE output types

Testing Tools E-CATT

Design Tools MS Visio

Estimation Tool SAP core Estimator

Methodology ASAP, Accenture Delivery Methodology (ADM) and Rapid

transition Suite (RTS),SDLC

QMS QPI, SQA, Six Sigma, Defect prevention Methodology

Batch Management Control-M job scheduling, MAESTRO Job Scheduling

Other Skills ASP, VB, Oracle, SQL Server, UNIX, VISIO 2000, COM, MTS and

MS Office

Document Solution Manager, RFS Tool

Depository

Reporting Tools BEX, WAD,EPM Microsoft addin,Cognos

EMPLOYMENT HISTORY:

1)Client Name: IBM/Panasonic, Newark, NJ

Dec 2006 to Present

Project Title: Panasonic BI-APO

BW Lead/ Solution Architect/BPC

Technology: SCM 5.0,ECC 6.0, BI 7.0, BI 7.4,Unix Scripts,TWS Job

scheduling, peregrine, RFS Tool, Solution Manager

Responsibilities:

. Involved in 2 APO BW Implementations, BI Upgrade from BW 3.5 to BI 7.0

and BPC implementation.

. Suggested and implemented cost saving customized tools in BI and APO

. Actively Involved in gathering Requirements, sizing, Converting

business requirements into functional requirements, System Design

document,Modeling/Designing, Developing, System testing and prepare

test data for UAT and finally deploying SAP BW objects in Production

Environment

. Run UAT results with stake holders

. Successfully implemented several mid-range projects

. Converting User exits for Enhancements of all standard extractors into

BADIs in ECC during ECC and BW upgrade

. Redesigning of BI loads during Panasonic Company split and tuned them

on functionality level

. Developed complex logic in ECC extractor BADI to split the sales key

figures into different buckets for revenue recognition project

. Resolving the production issues based on Severity level

. Delegating tasks to my off shore team as per priority

. Designed data modelling, Dimensions, Models, BADIs,optimization,input scheduling templates and BPMs in BPC implementation and

supported this application

. Understanding Panasonic third-party vendor tools and developed most

complex interfaces to BI,APO with them

. Extracted data from SAP Logistical systems using standard content data

sources and enhanced standard data sources, developed Generic data

extraction. Very proficient with the Logistics Cockpit, maintenance

and enhancement of LO data sources, LO delta modes, LO delta queue,

and the initialization of the init/delta process for LO data sources

utilizing setup tables

. Developed complex reports in BI, APO and BPC for various modules

. Extracted Sales Orders, Deliveries and Invoiced into APOBW for APO

Planning and extracted Inventory snapshot from ECC

. Extracted FI-GL, FI-AR, FI-AP, COPA, SD, MM, APO planning data into

SAP BI and APO BW respectively

. Implemented Integrated Planning (BPS) tools to load data into APO

Planning area using WAD and implemented function type Exits

. Extracted data from DP,SNP and GATP planning area and loading into

Info cubes

. Creating MPOS and creating Data sources based on Master data Planning

object structure(MPOS) in DP, SNP and GATP Modules

. Developed SQVI queries in ECC to validate BI Reports as on required

. Enhanced FI data sources using BTE technique in ECC

. Extracting Master data of Material, GL Master, Customer, PPrice,

Purchase Inforec, Vendor Master, Sales district and APO Product

master, Vendor Location and Plant location extraction and loading

into Info objects.

. Created Process and Meta chains for MM, SD, FI, DP, SNP and GATP Job

scheduling

. Implemented BEX user exits and Report to Report interface (RRI)

according to business requirement

. Developed VBA Macros in BEX reports according to business requirement

. Run BI Statistics on regular interval to make system healthy

. Designed Fair share process. This process is for allocation for

monthly and weekly customers

. Crating Remote cubes for GATP,DP and SNP Planning Area

. Performance tuning of Complex data loads and tuning of existing Custom

data source extractors

. Worked on Open Hub, APD and RSCRM_BAPI Technology to generate the

files from BI and FTP to third party systems(PSI DW and FTA

forecasting tool)

. Extensively MS Access used for Production data validations

. Finding reliable SAP Notes and applied them

. Involved in Data centre migration project

. Developed CIF User exits and CTM run User exits in APO

. Developed Unix Shell Scripts to transfer files from SAP Application

server to legacy systems and vice versa

. Preparing BI data flow diagrams using Visio in each module and

uploading into Solution Manager Tool

2)Client Name: BROE Inc, Denver, CO Oct

2006 to Dec 2006

Project Title: Broe BI

Consultant

Technology: SAP ECC 6.0 SP6, BI 7.0

Description: The BROE Inc is into Real Estate, Transportation (OmniTRAX

Inc), Energy and Strategic Capital. This project is postproduction

enhancement.

Responsibilities:

. Extraction of SD and FI-CO data from R/3

. Loaded transaction data and initialized deltas for FI Line Items and

transaction data

. Developed BEX Reports in FICO and SD Modules

. Finding reliable OSS Notes and applying them

. Implemented User exit for BEX.

3)Client Name: SONY/ACCENTURE, Mumbai, India Nov

2003 to October 2006

Project Title: SOAR SAP Application Management Project

BW/ABAP Lead -Architect

Technology: Unix SAP R/3 Enterprise 4.7D/ECC 5.0, BW, APO, CONTROL-M, LSMW,

Solution Manager, SAP Core Estimator Tool, DB2, MS Visio and MS access.

Description: Sony Electronics Inc. launched the SOAR program to

establish a scalable, upgradeable, and cost-effective solution based on SAP

technology. The aim is to increase sales, productivity, speed-up the order-

to-cash cycle, improve customer satisfaction, and reduce inventories. SOAR

is a new system integrating SD, MM, FI-CO and it has more than 165

interfaces some inbound and some outbound. Sony R/3 system is connected

with SONY APO, BW and many Legacy Systems.

Responsibilities:

. Estimate the time efforts for each object by using estimator tool

before designing

. Translating SAP functional document into SAP Technical document

. Providing guidance and share knowledge to the team members relating to

area of specialization

. Code review of the team's objects, documenting the code review check

list and maintaining those in Solution Manager

. Extraction for FICO, SD and MM data

. BEX Reporting and workbooks

. Monitoring Data loading jobs and resolving the issues if jobs abends

. Implemented User Exits to enhance standard LO Extractors

. Gathered requirements, prepared technical document and developed

objects based on the technical document

. Developed Complex reports, in FICO, MM and SD modules

. Involved in configuration and trouble shooting in FI Module

. Implemented new User Exits, BAPIs, BTEs BADIs and LSMW

. Worked on ALE/EDI/IDOCS with IDOC Extension

. Implemented SAB101 process in Finance module

. Implemented LSMW applications for one time data upload into SAP

. Developed BDC-Upload tool using VBA macros which generates the file in

a required format for any SAP transaction

. Supporting clients request prioritization process by providing high

level estimates for design and implementation efforts

. Prepared broad level diagrams in Visio for complex interface programs

on an end user's request

. Wrote Unix Shell Scripts to transfer files from SAP Application server

to legacy systems and vice versa

. Finding the reliable OSS Notes for FI-CO, SD, MM

. Performance tuning of complex reports

. Created functional specs, resolved break fixes, unit testing,

functional testing for diversion process and FI reports

. Testing applications and fixing the issues during the upgrade of the

project from SAP R/3 4.7D to ECC 5.0

. Providing cause for cancelled SAP jobs, providing recovery procedure,

documenting recovery procedure in solution manager database and

solving the production issues

. Created testing solution and user documentation for FI and SD Reports

. Good experience in Taxation (Calculating tax through TAXAWARE system)

. Worked with the end users to gather requirements for the application

. Worked with process owners on their issues and impacts with relevant

client sponsors

. Taking the ownership of SEV-1 tickets and resolving the same within

SLA framework

. Ensuring SLA compliance for deliverables

. Involved in Quality Audit

4)Client Name: Tata Chemicals LTD/Nelito Systems Ltd

Jan 2002 to Nov 2003

Project Title: SAP OPTIMIZATION SAP

Technical Consultant

Technology: SAP R/3 4.0B/4.6B, BIW, Unix and ORACLE

Description: SAP OPTIMIZATION is a post implementation project and FI-

CO, SD, PP, MM, PM, QM, TCL specific Salt distribution System modules were

implemented as a part of this project. HR Module was introduced in this

project after the upgrade from 4.O to 4.6. This Project has three company

codes Tata Chemicals, Tata Fertilizers, Tata cement and the inter company

posting in FI is carried out in this Project. The data extraction from R/3

to BW and BW reports were developed in FI-CO module.

Responsibilities:

. Understanding the functional requirements and converting them into

technical requirements

. Developed the SAP objects in various modules FI, SD, MM and Salt

distribution system based on technical requirements

. Prepared Unit test results and maintained the documentation for each

SAP object

. Trouble shooting of user issues

. Involved in Project upgrade from 4.O to 4.6

. Developed ABAP Routines in BW

. Travelled to Distributor and CFA locations to give end user training

on for the Salt Distribution System

5)Client Name: Mahindra Ugine Steel Company

Apr 2001 to Dec 2001

/Bristlecone (Mahindra Consulting Ltd)

Project Title: Mahindra Ugine Steel Company SAP Implementation SAP

Technical Consultant

Technology: Windows, SAP R/3 4.6C, Oracle.

Description: Mahindra Ugine Steel Company (MUSCO) Stampings is a leading

manufacturer of critical stamping

Components for the automotive, defense, railway,

consumer durables & general

Engineering sectors .MUSCO implemented QM, MM, SD

and FI Modules in SAP.

Responsibilities:

. Worked at client locations to gather requirements from Functional Team

. Involved in Developing ALV Reports, SAP Scripts,BDC and customized

function modules objects

. Maintained technical design documents, unit test cases in proper

repository

. Involved in full life cycle.

6)Client Name: Bristlecone(Mahindra & Mahindra/Mahindra Consulting LTD)

Sept 2000 to Mar 2001

Project Title: Mahindra & Mahindra SAP Implementation SAP Technical

Consultant

Technology: Windows, SAP R/3 4.6C, Oracle.

Responsibilities:

. Involved in developing objects and unit test cases for MM and SD

Modules

. Code review of the objects before delivering it to Project Leader

. Debugged SAP standard Programs based on functional team requests to

adapt the SAP standard functionality into customized programs

Education and Professional Training:

. B.E (Electronics and Telecommunications Engineering)

June 1991 to May 1995

. PGDCA (Post Graduate Diploma in Computer Applications)

. Completed Training in E-CATT, and BW from SAP Labs

Contact this candidate