SAP Devoper
Resume:
RAMESH
Cell: 937-***-****
Senior SAP ABAP Technical Consultant
SUMMARY
• A Leader with a proven track record of Over 8.0+ years of experience in IT industry, includes 7.0+ years of experience in Implementation, Conversions, Enhancement & Production Support in SAP R/3 as a Technical Consultant. Involved in each and every phase of implementing SAP technology covering 3 full life cycle implementations, right from implementing the ASAP methodologies, designing and developing objects in SAP, 2 Upgrade projects to Newer version, involving in production support and configuring application to the client needs.
• Extensively Worked with ABAP/4 Reports (Classical & Interactive), ALV Reports, Data Dictionary, Module Pool programming, Batch Data Communication (BDC), LSMW, SAP Scripts, SMARTFORMS, Function Modules, Performance Tuning and SAP/ABAP Query in the areas of Sales & Distribution (SD), Material Management (MM), Real Estate Management (RE-FX and Classic), Finance & Controlling (FI/CO), Quality Management (QM), Production Planning (PP), Plant Maintenance (PM) modules.
• Strong Functional & Configuration exposure in functional areas like Sales & Distribution (SD), Material Management (MM), Real Estates (RE), Finance (FI) and Production Planning (PP).
• Knowledge of SAP-ISU, FI-CA and PrintWorkbench
• Expert with interfaces like ALE, IDOC’s and BAPI.
• Expert in SAP Enhancements, User Exits, BADI implementations.
• Experience in Object Oriented Programming (OOPS) ABAP.
• Extensively worked in Data Conversions.
• Very good exposure to Mercury testing tool to create Test Scripts, Script execution.
• Experience in System Design, Documentation, Development, Programming, Testing and Implementation.
• Good communication and inter-personal skills, accustomed to work in a team environment with tight schedules and capable of working efficiently under pressure, manage multiple tasks and cross train sub-ordinates in other Functional areas.
• Proven problem solving, Self-starter and worked individually as well as adapting rapid changes in team environments and priorities.
ABAP EXPERTISE
• ALV Reports, ABAP Query and Module Pool programming.
• BDC, LSMW and CATT tool.
• Conversion and Interface.
• Function Modules, RFC, BAPI.
• Module Pool programs Development including Screens & Menu painter.
• SAP Layout / SAP Script and SMARTFORMS.
• SAP Enhancements includes User Exits, BADIs
• SAP Data Dictionary (Tables, Views, Data Elements, Domain, Search Helps, Lock objects).
SKILLS
Applications : SAP R/3 3.1 H / 4.0 B / 4.6B / 4.6C / 4.7/ECC5.
Operating Systems : UNIX, HP-Unix, Windows 95/98/2000/XP/NT/Vista.
Languages : ABAP/4, SQL, PL/SQL, C and C ++.
Databases : Oracle 9i/8i/8/7.x, DB2, MS SQL Server, MS Access, MS Excel.
GUI : Visual Basic 6.0/5.0,Crystal Reports, and ASP.NET.
EDUCATION
Bachelor of Technology in Engineering, India
EXPERIENCE
Shell Oil, TX June-2008 till Present
Techno-Functional Consultant
Global SAP & AIM-EDMS Projects
Modules: SD, MM and PM
Global SAP Rollout Project: GSAP is global system for refinery business. GSAP will help make it easier to do business with Shell Downstream by implementing a common set of systems on a global scale. It will enable simple, standard business processes replace existing fragmented IT systems, reducing the number of systems. Lower the costs of supporting the IT infrastructure and reduce the cost of compliance.
AIM-EDMS: AIM EDMS is Asset Information Management - Electronic Document and Data Management System, which offers the functionality to manage technical data and documentation related to Asset. AIM builds upon core SAP PM Functionality to provide seamless integration with the engineering processes. Filenet used for actual Electronic document repository. AIM will be interacted with SAP and Filenet to retrieve Electronic document based on Document Info Records in SAP.
Conversions:
• Data Refining and mapping of MM and SD Master data like Material, Vendor, Info records, Customer mapping the same into LSMW and Load programs, which uses BAPI and IDoc to create them in the Global system.
• Developed a comparison report to project the Number of Purchase Requisitions converted to Purchase Orders against Purchase Requisitions not approved.
• Developed a Report to view in one ALV format the sequence of document flow from the initiation of an Planned Order (created after MRP run) against the Sales Order till conversion of the Planned Order to Production Order, Production Order completion, Delivery and Billing.
• Developed Lease Commitment report (Cash Flow): This report is used to generate cash inflow, outflow of Lease Out contract or Lease In contracts. Based on this cash flow, payment commitments will be calculated till next 99 years.
Interfaces:
• Developed RFC function module to create/change/delete Document info record, which will be triggered from AIM
• Developed RFC function module to link/unlink Document info record to Asset (Functional Location/ Equipment)
• Developed RFC function module to create Document BOM
• Developed RFC function module to update long text of Functional Location / Equipment, The file will be FTP ed from AIM via SAP Unix server
• Developed RFC function module to Create/Change Functional Location/Equipment
• Developed RFC function module to Create/Change Characteristics of Functional Location /Equipment
• Developed RFC function module to FTP asset hierarchy information to AIM system
BADI:
• This Enhancement is triggered on creation / change / Display of any Customer Master to store the custom fields necessary to deliver the business case around customer master. More than 20 custom fields with 2 tabs added with this enhancement. The new fields are displayed as planning and Star card information details, which should be added as a separate tab under a new push button in the application bar. Which includes new implementations for the Business Add-Ins (BADI) CUSTOMER_ADD_DATA and CUSTOMER_ADD_DATA_CS
Environment: SAP R/3 4.6C and 4.7, ECC6.0
ChevronTexaco, CA July-2006 to June-2008
Techno-Functional Consultant
Project Olympic
Modules: SD, MM, PM and RE
Project Olympic: Project Olympic is Downstream’s drive to standardize the way it does business worldwide. From Human Resources to supply chain to customer order and delivery, people from around the world within ChevronTexaco are building common business practices and a single information system in order to realize the potential of Downstream’s global functional organization. Project Olympic is a New implementation as well as Upgrade project.
Conversions:
• As part of project Olympic, worked in Conversions area of MM,SD and REAL ESTATE Master data from different region systems (US, Africa, Asia) to Global system, worked on writing Functional specification, Technical Specifications, developed ABAP extraction programs and Technical String Script, TST execution. ABAP program will generate flat files which will be used as input files to LSMW and Load Programs to create Master data in Global environment.
• Data analysis of CLASSIC Real Estate Property master, Lease In (LI) Contracts and Business Partner master data from US, AFRICA and ASIA systems and developed ABAP extraction programs to retrieve data and transform with new mapping then loaded with LSMW tool with BAPI and BDC into FLEX Real Estate (Global System).
Reports:
• Developed Sales Volume/ Revenue Tolerance report: This Report will provide a list of all Sales reported for which the sales volumes entered on Contracts (SAP) do not meet certain criteria or that show significant differences from the previous period.
• Developed PM Material Forecast report: This report lists all materials required for open PM orders.
• Over all PM Work Order Duration: This program is used to calculate duration for all Work Orders created or changed during a particular interval.
• Developed an “EARLY WARNING” report, to facilitate the Purchase Orders which have a delivery due date against their Goods receipt, to be visible to the decision makers.
• Developed an FI report to list out the entire invoice documents, which had a conflict with the Purchase Order, price during invoice verification and the vendor got paid.
• Developed a utility program to upload any Custom table with EXCEL data.
BADI:
• Implemented AFABD_CHANGE Change Relationship to enable the correct population of the Chevron calendar onto shutdown work order relationships.
User Exit:
• Modified the Sale order User Exit (EXIT_SAPMV45A_002) to automatically populate Sold-to while creating Sale Order.
BAPI:
• Developed new Custom BAPI (ZBAPI_RE_LAND_REG_LOAD) and Business Object (ZBUS1502) to populate Parcel data of land (Property Object) on Property master which was used in LSMW as part of Property master data conversions.
Enhancement:
• Worked on a Pricing Routine to calculate the total product cost from the table MBEW. This routine will calculate and populate TPC (Total Product Cost) from table MBEW, if TPC is not populated from a Z-Table.
• Altered Standard Pricing Routine 701 to rounding off to nearest whole number. This enhancement is required to calculate the sales value up to the day of month for a customer (Sold to).
SMARTFORMS/SAP Script:
• Developed Custom SMARTFORM and driver program for creating Invoices in Real Estate FLEX module. For Lease Out contracts (i.e. where Chevron is the landlord) there is a need to invoice customers. The current version of SAP RE-FX (4.7) does not have this capability.
• Plant Maintenance (PM) Work Order form with Notification and without Notification, Used SAP script for this form
LSMW/BDC:
• Developed new BDC program to create Plant Maintenance Work Centers from flat file data.
• Used LSMW tool with BAPI method to create/change Property Objects, LI contracts master data in Flex Real Estate module. Tab delimited flat files used as input to the LSMW. Conversion rules and mapping rules ABAP code written in LSMW Maintain Field Mapping and Conversion Rules step.
• Used LSMW tool with Batch Input Recording method to create/change Business Partners master data in Flex Real Estate module
Environment: SAP R/3 4.6B, 4.6C and 4.7, ECC5 Windows-XP
GE Advanced Materials, WV April-2006 July-2006
Technical Consultant
Modules: MM, PM and PP
Reports:
• Daily confirmation report: Based on the selection criteria entered, the program will locate the PM Work Order where an operation was confirmed within the date range given that also meet the other selection criteria and list the operations grouped and sorted. The Actual finish date of the operation should be compared to the date(s) selected by the user to determine which work orders have had confirmations made within the date(s) requested.
• Material Obsolescence Report: The report is helpful to the Maintenance group for removing obsolete inventory. The Obsolescence Report shows a list of Materials that have not moved in a period of time. Items are shown in structure view for items on BOMs and for items not on BOMs show classifications.
• The Maintenance Work Order Daily Scheduling Report shows a list of open Plant Maintenance work order operations grouped by Maintenance Work Center and sorted by priority then functional location. The report is helpful to the Maintenance group for scheduling work.
LSMW:
• Used LSMW with direct Input method to create Vendors Master data and Materials Master data. Used record method to change some field data in Vendor Master Data.
MeadWestvaco, OH Jan-2005 to April-2006
Technical Consultant
Modules: SD, PP, PM, MM and FICO
Reports:
• Designed and developed Dispatch List: This report is intended to function as a dispatch list for bringing in Production Order information from SAP and combining it with limited instructional information from planning personal. It has update capability to change the status of production order. It does have manual entry fields for communicating information from the scheduler to the operations personnel that will print out this information. The intended audience for the report is supervision and floor personnel involved with the planning and production process. This report will provide the audience with a set of information to assist them in understanding the sequence of orders set up for different production operations/equipment and the relevant characteristics/information about these orders that allows them to be sequenced together.
• Designed and developed Invoice details: CPG group needs a nightly job (Monday – Sunday) to send invoice data to Sony via FTP. The file is set on the MeadWestvaco FTP server by 9:00 pm nightly and downloaded by Sony. (The file is not sent directly to Sony for security reasons.) If there is no invoice data to be sent, a file still must be generated to reflect on invoice data. (No invoice data is indicated in TLR section of the file with zero as the record count.)
• Designed and developed UPC generation tool: Provide the ability to create and assign UPC numbers for new finished goods materials added to SAP. Goal is to generate UPC numbers, store them in a z-table and then access the z-table and assign the UPC to the material in the material creation process. We try to use user exit MGA00001 to assign the UPC; it doesn't look like this will be possible. As we are not successful with the user exit then we provided a screen for the material master coordinator to view the z-table and manually cut and paste the UPC codes into the material.
• Designed and developed MCOP pays sales commissions to third party sales people or groups of people. The report will be written in ALV format to provide the user flexibility in defining what information to download. The actual calculations of the commission amounts will occur in the spreadsheets.
• Designed and developed Excel file Upload for transaction KB21N using BAPI_ACC_ACTIVITY_ALLOC_POST. Excel files Upload for transaction KB31N using BAPI_ACC_STAT_KEY_FIG_POST.
Function Modules:
• Designed and developed a function module ( Z_GET_CHARACTERISTICS1 ) to get material characteristics, when we pass material number and class type parameters, function module will return all characteristics values.
BAPI / Interfaces:
• Changes to ZBAPI_ORDER_STATUS_MCOP, this BAPI will return all sale order statuses of characteristics, Sale document type, Order status, Branching Name, Order status parameters which will given from web system will return all statuses of the Sale order. This BAPI have the facility to select only one Order type at a time, my change is to include the option to send more then one order type at a time and to improved the performance of the program.
SAP Script:
• Designed and developed ZF01 out put type for Invoice printing. Copied RVADIN01 to ZRVADIN01 and layout is developed from scratch according to the business requirement.
• Designed and developed Z010 out put type Bill of Lading (BOL). Copied RVADDN02 to ZLESS_VADDN02RD and developed layout from scratch.
• Major changes to ZEXP output type Proforma invoice. Footer part of the invoice contains declaration text box, line total box, miscellaneous charges box, Invoice total box are moved to main window. It was such a way that once we print invoice each page contains this footer, my requirement is to move this footer part to main window so that once item printing is done, immediately it will print the this footer part unlike it is printing on each page. Modified the form in order to print the data in correctly in all windows.
SMARTFORMS:
• Designed and developed SMARTFORM (ZPP_CPG_SHOPFLOOR_PAPERWORK) which will print the Shop floor paper work with production orders details.
Module pool program:
• Designed and developed a module pool program, which will create an IDOC with barcode information in turn, will send to Bartender s/w to print the barcode. In the selection screen we provided production order number, material information, carton count, pallet count, and pieces/skid etc. , IDOC will be created with all information about the Barcode. This information will be sent to Bartender s/w to print barcodes.
LSMW:
• Used LSMW tool create Customer Master data with LSWM Batch Input recording.
User Exits:
• Modified the Sale order user exit (MV45AFZZ_FORMS) to populate custom inco terms for INCO1 or INCO2 into VBKD (item level) record from custom table for specific Sales area/ Material combination. This is only to be done new orders VA01.
• Modified the Sale order user exit (MV45AFZZ_FORMS) to copy partner address from main item to substituted item, creates an include which will control the copy process based on item category (ZTAX)
• Modified the MeadWestvaco Display/Change Production Order Header Data screen by using screen exit SAPLCOKO1 with this exit I added new sub screen with Rework order information and a button for Shop floor paper print.
Performance Tuning:
• Performance Tuning PPV report: this report will give the business financial purchase price variance reports quickly, now this is being done by down loading information out of SAP from 3 different transactions then developing the reports in excel. This process takes about 3 days to complete. Report that shows Gross price from the PIR record Vs the PO/Invoice Price, this difference is the Purchase Price Variance (PPV) ties to the ledger. Quick turnaround at month-end. This program was taking 15 min in F01 client (Regression test). My task is to improve the performance by using different function modules to get accounting documents by passing material document and changing the select queries etc., after my changes the program taking 33 sec to run in F01 client.
Environment: SAP R/3 4.6C, DB2, Windows-XP
Monsanto, MO Feb-2004 to Dec-2004
Technical Consultant
Modules: SD, QM, FICO
Module Pool Program:
• Modified a custom transaction, it allow customer to receive one invoices for all of the their line conversions made during year rather than multiple bills and changes to Work Sheet Report generated for some royalty types.
• Developed custom program for Luling stores WM-RF Delivery Confirmation. This program was needed to be developed for both standard dialogue and ITS so that it is web-enabled. The process includes Goods movement and Transfer order creation and confirmation for reservation as well as the Purchase order.
• Developed a custom report to be used by the Mexico Seed business to identify all Process Orders (Contracts) that do not have an associated Purchase Order created. There is an additional functionality allowing the user to select icons that execute the BAPI_PO_CREATE1 which will automate the function of PO creation and additional functionality that will allow the user display and/or change a selected Process Order.
• Developed a custom transaction, which will create QM notification.
Reports:
• Developed ALV to list SAP Batch Characteristics for Parent Seed Stock for particular plant. This list is used to update HCS Custom Batch Tables.
• Developed a report, which will produce PDF output, which has all the invoice details of the customers.
• Developed ALV report which displays Invoiced entered by period in Account Receivable.
• Developed ALV report, which displays Custom Cleared Items on period basis.
Function Modules:
• Developed a function module, which will create Inspection for material and batch when a production order is created.
User Exit (Enhancements):
• User exit, which will check the duplication of tax number, which entered in vendor master creation.
• Added Vendor business address field to Vendor master application (SAPMF02K) by using Function module EXIT_SAPMF02K_001
Environment: SAP R/3 4.6C, Oracle 8i, Windows-XP
Fossil, TX Sep-2003 to Jan-2004
Technical Consultant
Modules: SD, MM
Interfaces:
• Developed a program, which uploads file from FTP server and updates Batch Characteristics of material using BAPI.
• Developed a program, which uploads file from FTP server and creates the pricing condition for shipment using Batch Input method.
Reports:
• Created report on material analysis for Purchasing Organization.
• Created report on stock overview under Plant and Storage location.
SAP Script:
• Enhancements to Certificate of Origin: In the process of generating Certificate of Origin, by entering invoice number in VF02, It should trigger the form Z_SD_EXPORT_FUCO, print program RVADAUS1 modified layout and print to meet business requirement.
• Enhancements to Shipper’s Export Declaration: In the process of generating Shipper’s Export Declaration, It should trigger the form Z_SD_EXPORT_FUSD, print program RVADAUS1 modified layout and print to meet business requirement.
Aventis, NJ Jan-2003 to Aug-2003
Technical Consultant
Modules: MM, SD and FI/CO
MM, SD and FI/CO Reports / ALV Reports:
• Cash Book details report for specific posting period with Vendor details.
• Created report of top 50 Vendors for specific period and displaying data in ALV Grid and List formats so users can customize spreadsheet report
• Created report of inactive Vendors list and displaying data in ALV Grid and List formats so users can customize spreadsheet report
• GL Account Analysis report with ALV Grid Control.
• Special Ledger Average daily balance extract with ALV Grid Control.
• Foreign Exchange Revaluation report program with ALV Grid.
BDC / LSMW:
• Used BDC for transferring & conversion data into the SAP system. Developed BDC programs to update and change Customer Master Data by session method for transactions VD01 and VD02 to update KNA1 table.
• Used LSMW tool for Out Line Agreements, it will upload the Data from legacy system to SAP system
Module Pool Program:
• Developed a Dialogue program for Material Details, Vendor Details, and Customer Details using tab-strips this front end was created to Add, Modify, and View the respective details from Tables, SAP Tables. Developed several interfaces using BAPI.
SAP Script:
• Modified the layout sets Purchase order (MEDRUCK), Buyers negotiation sheet (ME_EVLDRUCK) adjusted fields, limited footer to last page. Inserted the company logo and tested it for expected results.
• Modified the existing style and layout set elements of material "Packing List" as per client’s request. New field was added to the layout set RVDELNOTE in order to print bar code for material number on the "Packing List” along with material number itself.
SMARTFORMS:
• Customized SMARTFORM SF_ORDER_PREVIEW to print the shipping address even it is same as
Sold - to - party
USEREXIT:
• In VL01- create delivery order, standard program SAPMV50A, the standard program did not check for storage location equal to space, and delivery quantity less than one when the user click the save button. Therefore I have to insert the additional checking into the user exit routine.
• Developed User Exit for Customer Master to ensure that all US customers have a Group Key (KNA1-LAND1) entered on the customer master.
RFC / BAPI:
• Developed RFC enabled function module to send the Vendor Master details, based on request type either Vendor details or Manufacturer details or Material to Manufacturer details along with error file for any invalid parameters
• Identified standard BAPI’s which meets the requirement
ALE / IDOCS / BAPI:
• Configured communication settings for two ALE Systems. Maintaining the logical system, allocating the logical system to the clients, setting up the RFC destinations, port definition.
• Enhanced Vendor Master to insert business address of the Vendor using User Exits and created new segments, new IDOC type linked with CREMAS02.
Performance Tuning:
• Performance Tuning has been done using SQL trace, Run time analysis and changing the ABAP reports for better performance modifying internal tables and select statements.
Environment: SAP R/3 4.6C, Oracle 8i, UNIX
Sanyo Semiconductor Corp., NJ Apr-2002 to Dec-2002
SAP Technical Consultant
Modules: MM, SD, and FI/CO
SD, MM and FI/CO Reports / ALV Reports:
• Created interactive reports for displaying Vendor information, Stock Variance Report, Goods Receipt and Issue.
• Created reports, which provide Customer summary, Material summary & Total summary of customers in a given date range. It also has the drill down option, which will provide the corresponding details of the sales doc/billing document upon clicking on a particular line.
• Created report on Customer ledger (Customer/Name/Amount/Debit/Credit).
• Special Ledger average daily balance extract with ALV Grid Control/Spreadsheet Interface
• Foreign exchange revaluation report program with ALV Grid/Spreadsheet Control User Interface
SAP Scripts / SMARTFORMS:
• Modified standard script to include logo, contact person details like the email id of the buyer, various texts, various terms and conditions based on document types (user defined) etc.,
• Modified layout set (SD_PACKING_LIST) and print program (SDPACKLI) in SAP Script.
• Customized the SMARTFORMS LE_SHP_DELNOTE for Deliver note.
USEREXIT:
• Developed user exit before saving to Purchase Order (ME21N) to check and make the changes if necessary to header text entered by user (while creating the PO).
• Purchase Order pop-up screen to know total PO value before saving Purchase Order.
ALE / IDOC:
• Involved in configuration of ALE environment, developing Outbound and Inbound process, configuring the partner profile with inbound process code.
• Developed a new custom ALE where the receiver of an internal service must be able to reverse the invoice receipt, which will then cancel the applicable billing document automatically on the service providers system.
• To carry the billing number from the Service Receiver’s system to the Service Provider’s system custom IDOC and the message type has been developed.
QTP Testing Tool:
• Creating scenarios for the training purpose.
• Debugging using object spy and breakpoints.
Environment: SAP R/3 4.6C, ABAP Workbench Tools, Oracle 8.X, UNIX
Bosch Rexroth AG, Germany Feb-2001 to Jan-2002
SAP Technical Consultant
Modules: FI, MM & SD Modules
REPORTS:
• Designed and developed a Sales Report, which is an Interactive Report, gives complete information of sales based upon Sales Office, Sales Group and Sales Area. (VBAK, VBAP, VBUP).
• Developed programs for generating reports of Goods Issue and Goods Receipt. (MKPF, MSEG, MARA).
• Developed a report for MM module that involves all Purchase Order details like PO Number, PO Line Item No, Vendor Name, Document Date, Purchasing Organization, Purchasing Group.
• Worked on Vendor Master listing report which gives information about Vendor Number, Company Code, Purchase Organization, Name and Address of Vendor, and it includes list of all Vendors whom the payment is blocked and the list of all Vendors where the payments block is removed.
BDC Interfaces:
• BDC session for Auto creation of Sales Order. This BDC creates a Sales Order for the Purchase Order created on the current day. The program can be scheduled to run in background. (Transaction VA-01).
• BDC Program to post the amount of consignment stock amount to GL stock account and to the dummy account treated as consignment account. Consignment stock multiplied with the moving average price is posted in to the accounts and the same is reversed again to keep the GL account unaffected. (Transaction F-02).
Module Pool Programs:
• Developed a Dialogue program for changing Material from Material Master. A new Transaction was made to change material by calling transaction MM02. A front end was created to Add, Modify, Delete and View the lead-time and Document Number in a user-defined table.
• Trained end users with ABAP/4 query and explained other user screens.
Performance Tuning:
• Performance Tuning has been done using SQL Trace, Run Time Analysis and changing the ABAP reports for better performance modifying internal tables and Select statements.
SAP Scripts:
• Modified layout set (SD_PACKING_LIST) and print program (SDPACKLI) in SAP Script.
Environment: SAP R/3 4.6B, ABAP Workbench Tools, Oracle 8.X, UNIX
Contact this candidate