Sales Project

Vrushali A.

***************@*****.*** Ph. No : 614-***-****

Summary

Total of 8 years of experience specializing in SAP ABAP, Netweaver, and Workflow as Sr. ABAP

Technical Consultant and 2 yrs in Oracle 9i with Developer 2000. Further SAP exposure includes APO,

Sales and Distribution (SD), Finance (FI), Controlling (CO) Material Management (MM), Inventory &

Human Resource.

Strong coding, Debugging skills, Performance tuning & User Authorization Check, Production

•

support, Trouble Shooting, Tracking Technical issues & Bugs Fixing. Involved in Integration

Testing, Unit Testing & Regression Testing.

Extensive experience in defining user requirement, analysis, design, development,

•

documentation, unit testing, debugging, using run time analysis and SQL Trace and maintenance

of ABAP/4 programs.

Worked in projects for clients in Retail, Automotive, Manufacturing, Chemicals, Paints, Sound

•

System, Pharma, Search Engine & Oil & Gas.

Worked in Full life cycle Implementation, Upgradation Project with Transaction code like SPDD

•

and SPAU migration project from ver. 4.7c to ECC 6.0.

Worked on ABAP Oriented Programming (Opp’s) and SAP Net Weaver Portal.

•

Data Dictionary Objects Tables, Views, Data type, Lock object and Search help.

•

Reports both Classical and Interactive and ALV s and Interactive Reports through ALV.

•

Developed Dialog Programming calling of multiple screens in sequence from one Transaction,

•

Using Tab strip control, Table Control, Screen Elements like text, Icons using Modal Dialog box, etc.

Data Conversion BDC - Call Transaction, Session methods, LSMW, CATT, Interfaces technologies

•

in RFC (created new RFC destination), /ALE/EDI, IDoc, BAPI.

Forms Modification of Sapscripts & Smartforms

Experience in Development of Enhancements User-Exits & BADI’s, functional exits Field Exits and

extending Standard SAP Tables.

Design development and Monitoring of custom applications and schedule Batch Jobs and

•

Transport Request.

Workflow: Workflow template, Role, Organizational Planning, Object Design, Methods

•

Development, Sub Types, Delegation, Event linkage, Binding, Container Assignments.

EDUCATION AND TRAINING

MBA from NMiMS with First Class Mumbai India.

•

Diploma in Information System Mgmt from Aptech Mumbai India

•

Advanced Computer Diploma from Bostan Institute Mumbai India.

•

BA Economics (Honors) From D.G Ruparel College Mumbai India.

•

SAP-ABAP Training from Mumbai India.

•

Oracle 9i Training from Mumbai India.

•

Technical Skills:

ERP Applications SAP R/3 3.1, 4.5B, 4.6C, 4.7D and ECC 6.0

SAP Interface tools Workflow, Netweaver, ALE, IDOC, LSMW, EDI and BAPI’s, CATT, BADI

SAP Modules APO, SD, MM, FICO, HR

Operating Systems UNIX, Windows 98/NT/XP

Languages ABAP/4, C, Developer 2000

Software SAP R/3 FI/CO, SD, MM, HR, PP.

Databases Oracle 8.x and 9i, DB2 6.1

Applications Developer 2000, Reports

General Tools: Microsoft Office 2000(Word, Excel, Power Point)

Professional Experience

Client: Limited Brands, Columbus Ohio

Business Type: Retail

SAP Module: SD, FICO, MM, WM, PP

Role : Sr.ABAP Lead Developer

Project Title: Implementation Project ECC 6.0

Environment : Main frame Sever - Windows 98 / 2000 – PC

Period Worked : Aug 2008 – Till Date

Responsibility : Limited Brands sells personal care and beauty products, apparel and accessories through its

Victoria's Secret, Pink, Bath & Body Works, C.O. Bigelow, La Senza, White Barn Candle Co. and Henri

Bendel brands. Our headquarters are located in Columbus, Ohio. We also have offices in New York, New

York, Kettering, Ohio and Rio Rancho, New Mexico.

ALE/EDI/IDOC Interface (FI): Developed an inbound IDOC interface to post the vendor

•

invoices received by SAP in IDOC.

Configured ALE and transferred the material data, customer data and vendor data using IDOC.

•

Designed and developed outbound EDI Invoice (810), inbound purchase order acknowledgment

•

Performed analysis, design, and related IDOC configuration activities like creating partner profile,

•

port definition, message type, creating output determination procedure(s), process code, condition

records, and extending IDOC(s).

Developed table maintenance generators for some ZTables.

•

Developed custom BDC for populating the scheduling agreements data contains statistical delivery

•

date depending on the vendor confirmation.

Invoice/Credit/Debit (FI): Developed a conversion (BDC) program to import data from Excel sheets

•

to post the customer invoice (FB70) and customer credit/debit memo (FB75) documents in SAP.

Developed a BDC for inserting new records in the table control using transaction XK02.

•

Migration of vendor master and material master into SAP from legacy system by using LSMW.

•

Involved in the initial data transfer and mapping of legacy data to SAP using call transaction method

•

and batch recording method of LSMW.

Price Deviation (SD, MM, and FI): This is a report program showing the price deviations of all the

•

purchased materials due to monthly fluctuations in the exchange rates.

Generated a report that lists out the purchasing document (Purchasing requisitions and purchasing

•

orders) which requires rescheduling. This report allows the material planner to control stock, thereby

avoiding overstock as well as stock out situation.

Created an interactive report for displaying the sales order item details based on the selection made

•

in the corresponding header data details which are displayed in the basic list.

VOFM - added new pricing routine to maintain sales order to change price based on condition and

•

quantity.

Modified MEDRUCK as per the client’s requirement.

•

Involved from the beginning in developing the dunning procedure as per the requirement to print the

•

dunning letters per credit control area of customers followed by invoices associated with the dunning

form, development included two SAP scripts for dunning letters and invoices and the print program.

Modified Script for purchase order and delivery.

•

Designed various customized smart forms such as delivery note and quotation confirmation.

•

Modified standard Workflow to determine approving agents using a ZTABLE rather than from

•

organization structure by implementing a BADI.

Enhanced goods issue to include hold functionality through BADI methods and to display all the

•

incoming materials

Developed the production order and in corporate a Workflow, by using Adobe Interactive Forms.

•

Check order quantity (SD): User exit for VA01, which checks if the order quantity is more than the

•

available quantity. If so, it blocks the sales order in VA01 transaction. And modify user exits for

adding fields to pricing fields catalogs

User Exit, billing invoice number ranges (SD): Written a user exit, which generates custom number,

•

ranges at the end of VF01 transaction

Dunning, F150 (FI/CO): Involved from the beginning in developing the dunning procedure as per

•

the requirement to print the dunning letters per credit control area of customers followed by invoices

associated with the dunning form, development included two SAP scripts for dunning letters and

invoices and the print program.

Client: Magna International,Troy Michigan.

Business Type: Automotive

SAP Module: SD, MM, PP, APO

Role: Sr. Abap Consultant

Project Title: Upgrade Project from 4.7 to ECC 6.0

Environment: IBM - Server and Windows 2000 / Windows ME – PC

Period Worked: Sep 2007 - Aug 2008

Responsibility : Magna International provides Automotive and its accessories. It involves to streamlining

the procurement process by using SAP NetWeaver Exchange Infrastructure 3.0 to implement the

following integration scenarios. Replication of vendor details from legacy system to SAP

R/3.Replication of vendor details from legacy system to Oracle 9i database system. Creation of Purchase

Order in R/3 for data coming in from third party web application and SAP Web AS 6.40 application.

Modification of all Z-Programs to match version upgrades in 4.7Bc with Current Versión ECC 6.0

•

(SD, MM, FICO, CIN Module) to accommodate growing needs of the organization with

Involvement in requirement gathering and Technical spec design out of Functional Specs for the

indirect material procurement solution at Lubrizol.

Worked with the transaction for SPDD for dictionary objects.

•

Worked with the transaction for SPAU to process Repository objects needing adjustment.

•

Responsible for debugging and tracking down problems in source code that

•

are inaccurate or causing problems.

For global business processes Unicode is the encoding standard which provides the basis for

•

processing, storage and interchange of text data in any language in all modern software and

information technology protocols.

Testing with different enhancement during upgrade.

•

Design process of new objects that were introduced in order to carried out program conversions

•

and fixes for code that were affected by the earlier versions.

Involved in designing and development of technical specifications and functional review

•

documents.

Developed a new conversion program for loading Measuring Points using LSMW.

•

Customized the Production order Standard Work Flow. When creating a Production order, Work

•

Flow is started to inform the production scheduler. For this dynamic hierarchical approval is needed.

Updated MRP data by using BDC and LSMW in material master.

•

Integration of R/3 with APO systems (SCM 4.10 and SCM 5.10) OOPS Methodologies:

•

Developed interfaces between APO systems and R/3 using OOPS concepts.

Created Implementation for BADI /SAPRCX/BAPI_PROCESS and developed code using

•

OOPS methods to populate certain fields during Load Event for the APO system.

Developed process code for IDOC type EVMSTA by calling BAPI /SAPTRX/

•

BAPI_EH_ADDEVENTMSG in APO system with OOPS methods.

Worked in development of MRP list, to display last planning run.

•

Developed a program to post accounting documents using BAPI.

•

Developed a SMARTFORM to print the contents of SD invoice.

•

Created a ALV report by retrieving the data from multiple tables which displays grand totals of units

•

and sales amounts of different types of sales of a product and performed calculations for the user

analysis according to client requirements.

Developed a new BDC program for creation of Material groups using standard batch input method

•

Created commission report for the sales department sorted by sales representative. The data is

•

extracted from VBAK, VBAP, KONV, and MARA tables.

Developed a program to post accounting documents using BAPI.

•

Configured ALE to distribute Material Master Data and Vendor master data.

•

Created new IDOC type ZMATMAS0 as a copy of MATMAS01. Extended this new IDOC type

•

with a new segment for Material master data group with new material.

Created a ALV report by retrieving the data from multiple tables which displays grand totals of units

•

and sales amounts of different types of sales of a product and performed calculations for the user

analysis according to client requirements.

Client: Shure Incorporated, Chicago, IL

Business Type: Sound System

SAP Module: SD, MM, FI

Role: SAP ABAP Consultant

Project Title: Maintenance Project

Environment: SAP R/3 3.1i, 4.6C, 4.7, Windows 98, DB2 6.1

Period Worked: Feb 2007 - Sep 2007

Responsibilities : Shure Incorporated's corporate headquarters and all North American manufacturing plants

are certified to the ISO 9001:2000 standard.

Used LSMW for mapping fields from the legacy system and created routines for data upload using

•

data extracts for sequential files on the application server (UNIX) and UPLOAD/WS_UPLOAD for

local files on the presentation server.

Created custom reports using ALV by leveraging the SAP standard Transactions codes like ME2L,

•

VL10B.

Modified Purchase Order SAP Script for Consignment Order based on the different document type

•

and by adding the Doc. Type conditions for different types of forms.

Resolved issues related to Route Determination, Delivery and shipping point determination.

•

Implemented a BADI for Goods Receipt (MIGO) to dynamically enter the date and time of when

•

goods were received.

Worked on the Purchase Order (MM) user exit EXIT_SAPMM06E_012, for changing the

•

Tolerance level based on the value of the Purchase Requisition.

Involved in development and enhancement of FICO reports and interfaces for all the rollouts.

•

Involved in enhancing a Common interface program which will run more than one interface and

•

upload the master data on a single run.

Aging report: Developed Account receivables Aging report.

•

Developed and modified smartforms to print invoices, account statements etc.

•

Created and modified lsmw for vendor, material, customer and GL posting uploads etc.

•

Involved in adding fields to predefined applications using Dialog programming using PAI and PBO

•

events.

Designed and developed a chat tool in SAP using dialog programming which allows the user to pop

•

up messages to the users who are logged into a SAP system.

Designed and developed a mailing report program which consolidates the sessions, Jobs ran on a

•

date and its status as an Excel and send to the specific user.

Configured setting up Partner Profiles, Ports and RFC Destinations.

•

Created new IDOC type extension by using basic type ORDERS01.

•

Created and Modified segments, message types, IDOC types, partner profile and output condition

•

types.

Enhanced IDOC segments and used user-exists related to Customer and material to populate the

•

custom segments.

Created partner profile and configured both Inbound and Outbound parameters.

•

Analyzed and tuned programs to improve bad performance system by using runtime analysis and

•

SQL trace.

Client: Occidental Chemical, Dallas, TX

Business Type: Paints

SAP Module: SD, FI, PP

Role : SAP ABAP/4 Consultant

Project Title : Support Project

Period Worked : Sep 2006 – Feb 2007

Environment: IBM - Server and Windows 2000 / Windows ME – PC

Responsibilities: Occidental Petroleum Corporation (NYSE: OXY) is an international oil and gas exploration

transportation and marketing and production company, as well as a major North American chemical

manufacturer with Head Quarters in LA in three core regions of the world: the United States, Middle

East/North Africa and Latin America.

Responsible for creation of stand-alone Outbound IDOC through MASTER_IDOC_DISTRIBUTE

•

function module with the data and control records

from EDID4, EDIDC tables.

Transfer data from Legacy to SAP using SQL queries.

•

Created custom IDocs for EDI (810) Invoice by extending the INVOIC02 IDoc type and adding the

•

logic in the User Exit (EXIT_SAPLVEDF_002).

Modified the user exit ZXM06U42 and created screen fields and developed a program to update

•

acknowledgement and change request in PO.

Wrote inbound interface using BAPI function call BAPI_MATERIAL_SAVEDATA to update the

•

capacity usage field, MKAPV in MLGN table with right volume of the material in packed condition.

To maintain the Change Number classification, BAPI_OBJCL_CREATE, BAPI_TRANSACTION

•

_COMMIT function modules are used.

Client: TriVirix, Milaca, MN

Business Type: Contract Manufacturing

SAP Module: SD, MM, FI, PP

Role: SAP ABAP/4 Trainee

Project Title: Support Project

Period Worked: Jan 2006 – Sep 2006

Environment: SAP R/3 4.5B, 4.6C and 4.7D, Windows XP, Oracle 8.x

Responsibilities: TriVirix is a full service contract manufacturing company focused on the manufacture and

design support of complex electro-mechanical medical, diagnostic, analytical and life-science devices.

Handled Data Migration for Customer Master using Batch Data Communications (BDC) Sessions

•

method.

Designed technical specifications based on business requirements.

•

Developed Report for Purchase Order mass history display.

•

Developed Report to display invoice details of completed Sales Order for given period.

•

Developed Report to show movements of material for various movements types using ALV.

•

Integrated MM module with FI to get the posting of Materials account.

•

Developed a BDC program to upload GL and AUC accounts based on posting key using transaction

•

F-02. This program would first simulate the upload and then process it if successful.

Created IDOC extensions for basic IDOC type ORDERS05 for incoming sales order and also

•

modified the posting program.

Used BAPI function module BAPI_ACC_GL_POSTING_POST posting GL accounts.

•

Involved in development of custom tables, data elements, domains, views and Match codes using

•

Data Dictionary.

Involved in developing reports stock ageing, inventory profile by value, monthly stock movement

•

report for consignment and stock ledger report.

Apply User Exits/Enhancement concepts to create user defined fields in SAP screens and menu

•

elements.

Client: Mayflower Pharmaceuticals, Boston, MA

Business Type: Pharma

SAP Module : HR

Roles : SAP ABAP Technical Consultant

Environment: Main frame Sever - Windows 98 / 2000 - PC

Project Title: Maintenance Project

Period Worked: Aug 2005 – Jan 2006

Responsibilities

Analyzed Payroll and Time management reports requirement and prepared High level and detailed

•

specification and collected basic requirement for coding the Report programs.

Transport the program from Development box to Quality assurance and Production box.

•

Performed Gap analysis and formatting report specification.

•

Preparing User design documentation.

•

Develop the program and test the program with respect to its performance and accuracy.

•

Created a Dynamic Program to update Info type 0003 whenever Info type 0014 or 0015 created for

•

retired and terminated people.

Extensively worked on Reports like Modified Remuneration statement Report RPCEDTUO &

•

Modified STD SAP RPLICO10 program

For Flexible employee report to suit client requirement, deduction Wage type Summary reports, Base

Payroll / Work Hours Report, Employee turn over report, compensation report, age & years of service

Report & Shift time recording report using Object Oriented Programming concept.

User Exits done for Benefit Life / AD&D Plan - To change Employee Cost and Employer Credit for

•

each age band and salary, Salary and Age freeze for Life/AD&D and LTD Plans & Cats User exit for

single screen solution for employee Pay information for HR/Payroll and employee time for work

order & refresh Cat2 time entry screen when wrong entry made.

BDC and LSMW used for New Hire Data & Incentive Pay details to upload in SAP system.

•

Client: Internet Search and related services AltaVista - Palo Alto, CA, USA

Business Type: Search Engine

SAP Module : MM, FI

Roles : SAP ABAP Consultant

Environment: Oracle Database NT-server - Windows PC

Project Title: Support Project

Period Worked: Mar 2005 – Aug 2005

Responsibilities

Implemented SAP Script Invoice and Purchase order forms.

•

Customized check printing form.

•

Developed classical and interactive reports: Foreign balance, Open PO listing with status,

•

Sales Tax report, Invoice list by vendor.

Company: Reliance Infosolutions Pvt. Ltd. India

Business Type: Oil & Gas

SAP Module : FI, MM

Roles : Sr.SAP ABAP Consultant

Environment: OS - SUN OS, Back-end – Informix, Front-end – SAP GUI

Project Title: In-house Project

Period Worked: April 2003 – Dec 2005

Responsibility: Automatic LPG System (FI)

Developed the Program handling technicalities Internal Tables, using standard FM

•

FIRST_DAY_IN_PERIOD_GET & LAST_DAY_IN_PERIOD_GET for monthly calculation of

truck, ALV Report.

ALV Report was displayed for Error Log. Error Log was button used in application tool bar and

•

logic was maintained in user command of events of ALV.

Remote Function Module (RFC) was called in Program for calculation, because price, distance &

•

web-bridge were maintained in another server.

Customized tables were used like z-tables to determine freight rate and standard Kms maintained by

•

Reliance.

Update the Pricing tables where condition types were determined like ZFRL for Inter-Reliance

•

Freight rate & Transporter Freight Rate.

Studying the functional requirements by analyzing existing system.

•

Gathering requirement for development of interface.

•

Preparing User Interface design documentation.

•

Test the Program with respect to its Performance & Accuracy.

•

Plasma Storage System – Reliance Life Science By (RIL Group) - India

Responsibility – Plasma (Blood Donation) as the main Product. The Blood is bifurcated based on Blood

Groups. The activity included vehicle loading, security checks, physical counting, weighment & GRN. (MM)

Led a team of 5 members in Designing & Maintaining the Project Plan for Data Migration &

•

Interface between SAP & Legacy System

Studying the User requirements, preparing technical Specifications, Preparing Unit Test Plan, Coding

•

and Testing the Unit Test Plan, Documenting the Test Results & Development.

Study the existing Developed Programs and Change the code to improve performance.

•

Legacy data (Text File) is uploaded through function module Upload.

•

SAP generates Consignment nos. automatically through function module number_get_next.

•

Validations are done through Select Criteria to check for GRN done or not. Minipool is generated

•

once material is accepted through online Program (Table Control) .Standard BAPI's another viz

BAPI_BATCH_CREATE & MB_CREATE_GOODS_MOVEMENT &

MB_POST_GOODS_MOVEMENT to capture movement in SAP System.

Scrapping Material is done through BDC for movement Type 951 for tcode MB1A.

•

This report is used to capture the donors detail on daily basis.

•

Performance Tuning for all Programs developed in the Project.

•

Understanding existing System and Modifying program with new Version through Version

•

Management.

New Development for Reports Programs for email to send excel file with multiple work sheets

•

using Object Oriented Pro. Concept.

New Development for Reports Programs using Dynamic internal Tables.

•

Company: Tata International Limited (India)

Business Type: Leather Products

SAP Module : SD

Role: SAP ABAP Consultant

Environment: OS– Windows, Back-end - SQL Server, Front-end SAPGUI

Project Title: In-house Support Project

Period Worked: May 2001 – April 2003

Responsibility : The Project is based on number of vendors identify for TIL and find bank details and how

many sales orders are confirmed or cancelled as per send Invoices to the respective vendors.

Program will extract data from standard tables of SD depending on requirement.

•

Based on Selection Criteria the interactive report will displayed for Vendors.

•

Based on Interactive Report through ALV Secondary List to display Bank Details for that Vendor

•

No.

BDC is done for Tcode VA01 for updating Sales Order for that customer through Batch Input

•

Session.

Classical Report was generated for cancellation of orders.

•

SAPSCRIPTS were used to print logo (using tiff files) and invoices for that particular vendor.

•

Status of the process was sent to concerned authority through email (SAP SO Objects) using

•

Function Module SO_NEW_DOCUMENT_ATT_SEND_API1.

Study the existing Developed Programs, Change the code to improve performance through

•

Performance Tuning.

Using Runtime Analysis analyse the performance of Transactions, Programs and Function modules

•

created in ABAP Workbench.

Using Performance Trace Record access, Locking activities and remote calls of reports and

•

transactions in trace file and Analyze.

Non-SAP EXPERIENCE

Aarambh Marketing Services - India

END USER on HRIMS System

Project Brief: Maintain Employee Master Data for new hiring, Competency Mapping, through PMS,

Identifying training needs based on PMS rated.

Period Worked: Jan 1999 - Mar 2001

Zenith Ltd - Inventory Control System - India

Oracle Programmer

Period Worked: April 1997 - Dec 1999

Environment – D2K (Forms ver. 4.0, Reports ver. 2.0), OS – Windows, Backend – Oracle.

Project Brief: Zenith Limited is into manufacturing of Zenith Steel Pipes. It is into manufacturing of Chemicals

& Rubbers. Its plant is located at Khopoli and Tarapore. Head office is at Church gate (Mumbai). The project

was on Inventory control systems, which deals with maintaining details of the firm. It includes the processing of

transaction on records and involves addition, deletion, updating of data, keeping tracks of the quantities of stock

of the products utilized and after optimum utilization reordering of the stocks of products.

Responsibility: As a programmer, I was mainly responsible for understanding the requirement, coding,

testing & analysis.

Company : PC Techno ledge Center Pvt. Ltd - India

Period Worked: May 1995 - April 1997

Role : Support Executive.

Arranging and Conducting Corporate Training Programs.

•

Orientation of all the software’s.

•

Installation and Trouble Shooting of various software.

•

References: Available upon Request

Contact this candidate