LakshminarayanaVelpula E-mail: ac3m7r@r.postjobfree.com

SAP ABAP Techno functional /Data Conversion Expert v: +1-269-***-****

Experience Summary

13+ years of experience in R3 implementation as a Technical Consultant (ABAP, WebDynpro, Workflows. Having extensive work experience in functional areas like SAP SD, MM, IS Utilities, FI, PP, SCM and Data Conversion area for multinational clients.

Strong experience in Food, Chemical and Utilities, Manufacturing and Finance industry clients.

Forms – Worked extensively in SAP scripts, Smart forms, Print workbench and Adobe Interactive Forms.

Reports –extensively worked on ALV, Interactive and Classical Reports.

Dialogue Programming: Worked extensively on module pool programming for developing the custom screens and transactions.

Enhancements – Enhanced Transactions, SAP Applications using Customer exit (CMOD/SMOD), User exits, BAd-Ins (BADIs) and New Enhancement Framework.

Experienced in developing interfaces using ALE, IDOC, RFC, BAPI and EDI.

OO ABAP – Expert skills in Object oriented ABAP (Classes, Methods, Events and Interfaces).

SAP WebDynpro Well Versed in designing and developing WebDynpro applications on various aspects like Context Binding, Model Binding, Data Binding, Actions, Events, Methods, Custom Controllers, Service calls, Supply functions, Views, UI Elements, Contexts, defining Inbound, Outbound Plugs & Navigation Link.

Experience in using Win shuttle tool.

Development of reports using Report writer and Report painter .

Experience in Data Conversions using LSMW, IDOCS and BAPI

Knowledge in using BRF and BRP plus.

Experience in Billing and Rates Process in Utilities Industry.

Experience in Creation of Technical Master Data and Business Master Data,Development of Variant Programs and FQEVENTS

Creation and Configuration of Rates in ISU and updating of Profiles& Web services Development.

Management of the Data Dictionary objects (tables, structures, views, data elements, domains, lock objects, match-code objects).

Worked on SAP VISTEX Sales Incentives, Charge backs and Bill backs .

Extensive experience in PLM & Dispute Management .Handled data conversion for Equipment, Functional Location, BOM, Task List, DMS and Developed many enhancements in Dispute management(UDM_DISPUTE).

Experience in using SharePoint, HP Quality Center and Remedy tools.

Worked on applying OSS Notes, SPAU/SPDD/SPAU_ENH and Unicode Conversions.

Expert in Performance Tuning, Problem Solving, Debugging, Requirement Gathering, writing technical designs for Interfaces, reports and translating business requirements into technical designs, Unit and System Test Plan, Technical flow Diagrams, Unicode conversion.

Educational Qualification

Bachelor of Engineering from Madras University

PROFESSIONAL EXPERIENCE:

DTE Energy, Detroit,MI

April 2015 to till date

Billing and Rates Technical Consultant

Designed and developed the Technical Documentations, Unit Testing as per client requirements.

Design and development of Project Creation and Linkage to site CAP Charges screens development.

Design and development of Auto rate change Enhancement.

Design and development of buy through Period screen Enhancement screens development and sending a voice message to all D8 Customers.

Design and development of RTP formulas for DST Handling.

Design and development of ESRI Street light Inbound Interface.

Design and development of Variant programs for street lights billing.

Design and development of FQEVENTS for Automatic budget billing eligibility check.

We have uploaded Billing Related Installation data, Meter Reads Data and Street light Information data uploaded using winshuttle tool

Design and development of DTV, CSV, DD interfaces development for commercial customer data transfer Meter reads upload and billing.

Design and development of web services development for profile values update.

Creation of test data for business people for test script execution.

Configuration of rates for Industrial and Residential customers.

Creating new a device and attached to installation and creation of bill documents.

Design and development of interactive editable ALV to update billing determinant values.

SADARA Project (Dow Chemical's)

Feb 2013 to April 2015

Sr. SAP Technical consultant ( MM/OTC/PP/FICO modules)

Design and development of Vendor Payment Interface using PEXR2003 idoc to generate Data Medium Electronic Exchange file.

Worked on Check Printing.

Worked on Dunning Letters.

Worked with functional consultants to determine gap analysis of IDOC functionality and determine new user- exit requirements.

Designed and developed the Open and Contract order inbound interfaces via BAPI posting requirements.

Worked on order (OTC) user exists for validate and convert the order data as per client requirements.

Exclusively worked on financial validation and substitution roles for GL posting and vendor invoice validations.

Designed and developed the Vendor invoice posting via EDI 810 IDOC scenarios with XML files via PI.

Worked on Process Orders, Planned Orders, Material documents, PO, Goods Receipts, Goods Issues and Invoice posting enhancements

Designed and Developed the Finance BTE’s, substitution rules, user exists for GL and invoice posing documents.

Exclusively worked on Financial EDI interfaces between Citibank and Chase banking payment interfaces.

Worked on Non PO and PO EDI/IDOC inbound Interface posting of vendor invoice through PI and Gentran system.

Design and development of credit memo workflow.

Worked on workflow bugs and reprocess the workflow etc.

Designed and implemented the Debit memo and credit memo interfaces for Vendor invoices.

Designed and worked on Incoming STO customer invoice posting interface via IDOC and BAPI’s.

Worked on Sales Incentives calculation enhancements in Vistex.

Worked on Charge Backs & Bill Back enhancement in Vistex.

Worked on enhancements (User exist/BAPI/LSMW/BADI’s/LSMW/IDOC, User exit smart forms and ALV Reports).

Designed and Developed the GL posting and validations enhancements, BTE, Substitutions in Finances.

Designed and developed the customer’s credit managements, partner validations and enhancements.

Kellogg’s, Battle Creek,MI

Nov 2010 to Feb 2013

Sr. SAP Technical consultant ( MM/SD/PP/FICO modules)

Designed and developed the Duplicate invoice validations via local files and UNIX files.

Designed and Developed the Credit management, customer credit check and Biller direct applications enhancements.

Implicated new screens in Vendor master transactions i.e. XK01/XK02/XK03 or FK01/FK02/FK03 and MK01/MK02/MK03 t-codes with help of Module pool, user exist, BADI and screen configurations in vendor master.

Designed and Developed the Lockbox entire Cash Application usingEDI IDOCs of FINSTA01 and PEXR2002 via PI and FSCM (Collections and Despites) areas

Conversion of Raw, Finished Product, Spare parts, Semi Finished, Trading Goods Materials and Product Groups.

We have uploaded vendor master data using winshuttle.

Updated material Master data using winshuttle .

Designed and develop the TP balance of AP and AR process report.

Actively supported the production support activities and validated the day-to-day basis of short dumps, monitoring of the batch job, system performance activities.

Fixed Assets conversion with custom fields on standard screen using AS01, AS11 and ABZON.

We have uploaded Purchase Info Records & Sales Orders texts data using winshuttle.

Equipment, FL, BOM, Task List and Source List conversions.

Conversion of DMS Documents with PDF, JPG, Excel, word etc.. Attachments.

Conversion of Customer Material Info Records, Customer material Listing.

Conversion of Equipment, Functional location and task lists.

Conversion of sales orders, Asset accounting and maintenance Orders.

Conversion of 14 different types of Material master Data.

SOLAR8000

Feb 2009 to Nov 2010

Sr. SAP Technical consultant ( Utilities/SD)

Understanding functional designs and created technical designs for AMI smarter meter system. Like single / bulk reads request and response.

Update Buyout Charges and Duration for Partial Payment

HPP plans are eligible per zip code of the service address of the business partner. The enrollment screen enhancement will ensure that a business partner’s premise meets specific criteria for HPP enrollment.

Worked on Inbound / Outbound services for AMI Smart Meter integration.

Implemented BADI (ISU_AMI_ATTR_MR) for Edit and estimation meter reads.

Worked on extensively code reviews to make sure performance and followed naming standards.

The Legacy Bill Correction enhancement provides agents the ability to post an adjustment for an error that was identified in the legacy system. The custom screen simplifies the correction process by displaying available data to assist in correction adjustment entry when available.

Worked on bill print variants.

Worked on lot of interfaces like mobile interfaces, MV90,MVRS(Upload / Download), AMI Integration (Smart meter), web interfaces like IVR.

Implemented various VOFM Routines for example: Pricing condition calculation, Copy

Control, data transfer and Output routines.

Development of BADI Implementation to add customer specific fields in Additional data tab at header and item level in Order/Quotation creation transaction.

IDOC Interface for Order Confirmation, Inbound delivery creation/PGI, Invoice interface.

Development of Automatic Determination of Material when the promotion and stock does not exist using VB11.

Worked on pricing condition based on customer specific scenarios.

SD integration with TREX for enhanced material search and Material creation on the fly

Wolseley

June 2007 to Jan 2009

Sr. SAP Technical consultant ( MM/SD/PP/FICO modules)

Design and development of PO EDI Confirmation interface.

Design and development of Receive Advance Shipment Notification interface

Design of Info Record Maintenance interface

Design and development of Purchase Order information to vendors via EDI / XML interface.

Task list, Functional location and Equipment data uploaded using winshuttle.

Design and development of forecasting exception report.

Design and development of Split monthly forecast into weekly buckets extract forecast to ECC

Design and development of Mass Maintain BOD in APO.

Design and development of Calculate Reorder Point enhancement.

Enhance CIF For Product Master

BAdi Enhancement to Extend Product locations in SPP

BAdi Enhancement to upload fixed demand

BAdi Interface for Source of Supply

Development of CIF Delta Report.

Development of purchase order form.

Design of Distribution Return Requirements enhancement.

Development of Product Transfer Resale Report

Development of Create PO to Vendor Targets

Development of Manual PO Stretching.

Development of Confirmation Failure to Buyer.

THE HOME DEPOT

June 2006 to June 2007

Sr. SAP Technical consultant ( MM/SD/PP/FICO modules)

Designed a workflow when the invoice is parked, mail to be sent to requisitioner of PO.

Modified a work flow when the business partner data is changed mail to be sent to business partner.

Used for Search help addition on the user fields tab in Project builder (CJ20N) transaction.

Developed an interface program to create an outbound file which gets Customer and Vendor specific details based on the selections. This file is sent to D&B to use it as input selections to search in their database. The result is displayed in the list as well.

Purchase Order Form for US and Canada Non-merchandising PO’s.

Customer Invoice Form to include debit and credit lines

THD Mexico paper PO’s form.

Developed a report for automatic clearing and transfer program for unclaimed property.

Site selection report to display all details related to project.

Al-FUTTAIM-STS, Dubai

Nov 2005 to May 2006

SAP Technical consultant ( MM/SD/PP/FICO modules)

Report on Payments made to Government departments using object-oriented concepts.

Famco sales report to display list of last six months sales of current year and Last two years sales.

TBA lead time monitoring report.

Function Module for Customer Credit Memo Creation using F-27.

Function Module for Accounting Document Creation using F-02.

Development of authorization report to check the authorized transactions for specific user and company code.

Summarization of Manual Invoices to Finance Companies report.

Seasonality download for syncron. This program picks data from S662 according to selection criteria and cumulates the sales quantity week wise and Summarized at superseded head of family article into the file according to the mf009 syncron file format specified.

Honda customer upload program to upload data into Custom table.

Developed online program to display Warehouse Information.

Auto clearing of accounting documents, this program will clear the credit card points earned by the customer if the points are older than one year from custom table and create the new document using F-02.

Sales area extension for customer master. This program will extend only unexpanded customers for targeted sales area for a given period using VD01.

Selection of regular vendor using the transaction in purchasing view using MM42.

AF Engineering Invoice layout set development.

Proforma Invoice for AFM.

Development of Packing List for Panasonic gulf smart form.

Development of Quotation for Automotive – Parts.

Kennametal Shared Services

Mar 2005 to Oct 2005

SAP Technical consultant (MM/SD/PP/FICO modules)

Cost Component Split Comparison report .It about the comparison of the present cost and future cost of materials.

Standard vs. Moving Average Inventory Valuation Comparison report.

Inventory Stock Levels report to support quarterly audit and should tie to the Trial Balance.

Plan Versus Actual Labor Confirmation Exceptions report .It will inspect closed labor confirmations or open labor confirmations in which actual reporting exceeds planned reporting or planned quantities exceeds filtered quantity.

Modification of settlement profile report .In exceptional cases old production orders cannot have their deletion flag set because of having balances change these from ‘To be settled in full” to “Can be settled” then archive the orders .

Update Costing Data of Production Order using the transaction CO02.

Cost Center activity prices data load program using KP26 transaction.

GE Advanced Materials

( MM/SD/PP/FICO/SCM modules)

Dec 2004 to Feb 2005

Order header text report to download the header texts of the order into excel file.

EHS chimney report.

A management audit report is used to track whether any purchases which should be routed through SAP are being made without first creating a PO in SAP.

Created the BDC programs for QA01, QA02 transaction to create and change of Inspection lot.

Developed a BDC for Customer conditions using transaction VD51 and VK11.

Attached the factory calendar to the specified plant using QM user exit IWOC0004.

Develop and enhanced the inspection lot certification code changes, then print the inspection lot certificate via smart forms via QA02.

Enhanced the inspection lot status modification using user exist based on status code changes.

SAP script configuration for QA certification using t-code CS82.

Pratt & Whitney

SAP ABAP Consultant

July 2004 to Nov 2004

Conversion of Sales Output Types.

Design and development of Combine Dispute cases enhancement

Design and development of Mass Comment update in Dispute cases.

Design and development of GIS EDI Inbound Customer ORDERS.

Performed SAP4.7C ABAP with PP/MM/SD modules.

Designed & Developed LSMW (batch input method) to upload the asset master data.

Designed & Developed LSMW to upload the customer and vendors master data using FB01.

Designed & Developed LSMW to upload the customer master data without special GL indicator

Generated BDC program to migrate the Info Record data from Legacy system to R/3 using ME11 transaction.

Purchase Order Create (ME21) and Purchase Requisition Create (ME51) Audit Report.

Purchase Order Change (ME22) and Purchase Requisition Create (ME51) Audit Report.

Cancel Invoice (VF11) and Change SO (VA02) and Create Invoice (VF01) Record Details Audit Report.

Pricing condition create (VK11) and Invoice Create (VF01) Audit Report.

SOX KONV Extract using the exit MV45AFZZ.

B.Braun Medicals

Oct 2003 to July 2004

SAP ABAP Consultant (MM/SD/PP/FICO)

Control report to make sure that duplicate invoices are not submitted to vendors.

This Control report was used to determine the possibility of duplicate payment being sent to the supplier .The logic of this report looks at vendor Invoice and Payee to determine the list of payments that meet the criteria of a duplicate.

The purpose of this report is to compare the calculated average selling price for an item to a customer versus the current standard price for that item to the customer.

This is a management report that is used to identify the products on AP Vouchers that have a Purchase price variance between the purchase order and the material master whether it is positive or negative .This will only be used for plants that are going to be purchasing out of SAP.

AMEX procurement Card interface program to upload the procurement card using Post document header data transaction FB01.

Head Count Interface program to upload the head count files using Statistical Key Figures transaction KB31.

Customer master Sales data upload using transaction VD01 .The Customer general data has to be created before this program is executed.

Created a shipping memo layout set, it is used when returning product to a vendor or for sending materials to a vendor for subcontracted items.

Create a quality transfer slip layout set it is needed to pick material from quarantine and to put material away in finished goods.

WATSON Pharmaceuticals

Dec 2002 to Sept 2003

SAP ABAP Consultant (MM/SD/PP/FICO)

This Report list all credits and debits issued to an account .It shows the type of credit issued along with any notes associated with the account.

The shipping statistics report consists of various data related to outbound shipments. This report must have the capability to be generated for a single day's activities or by a date range. The report displays the total number of orders by order type, number of order lines, number of units per line, number of full cases on the order, number of loose units and the order's sales value.

Plan vs Actual Service value report was developed based on the service charges paid to the third party vendors for producing the pharmaceutical products.

Vendor Managed Inventory (VMI) replenishment parameters must be converted from the existing SCORE system to SAP. The replenishment parameters are created for each VMI customer/material combination. Data that must be converted for each ship-to customer and material include target stock level, safety stock and reorder point. The replenishment parameters are used in combination with the sales and stock data from the customer to create VMI sales orders during the replenishment run using MM02.

Convert current and historical WAC price records from logical system i.e. Man fact into SAP price records using (VK15) create condition.

This User Exit will activate the label printing functionality for enabling RF, within SAP.

Contact this candidate