AddThis Social Bookmark Button
Ramesh Narala ( Available )
Azusa, California - 91702 USA
Expertise :ABAP, MDM, XI
Status :Have Work Visa
Job Type :
All - W2,1099,Corp-to-Corp
Position :Computer and Mathematical, Computer Programmers, Computer Software Engineers, Applications

Resume
 
Summary





More than 9 years of IT experience with 7+ years as an SAP ABAP Consultant.
As a SAP Technical Consultant have worked with various Industry verticals engaged in Automotive and Automotive Parts Manufacturing, Pharmaceuticals, Food and Heavy Duty Manufacturing. Have customized various functional areas like SD, MM, PLM, BI/BW, QM, SCM, MDM and FI/CO in SAP according to various business requirements. are part of Requirements gathering, Technical Specification designing, Knowledge transfer, Technical implementation, Testing and Debugging and Post Implementation Support.
Key Competencies in SAP : Reporting : Classical, Drill down/ Interactive, ALVs.
Data Dictionary Maintenance : Tables, Structures, Match Code Objects, views, lock objects, Table maintenance generator, Data elements and Domains.
Forms : SAP Script And SMARTFORMS Customizing existing ones and Designing new ones
Dialog Programming : Screen Painter, Module Pool Programs, Menu designing etc.
Modularization techniques : Subroutines, Includes, Function Modules Normal and RFCs
Master Data Maintenance : BDC, LSMW, Data Extracts, Data Mapping, Data Conversion, Data Uploads using Interfacing techniques etc.
Extensive experience in Object Oriented Programming.
Enhancements and Modifications using BADI s and User Exits.
Interface Technologies : ALE/EDI, IDOC generation, Extension of the existing IDOC types to create new IDOC types, written several Function Modules, User Exits and Enhancements to customize the ALE/EDI process. Process Management using SAP Workflows.
Experience in SD, MM, PP, BI, SCM, FI/CO, PLM and QM functional areas and in the use of ABAP to enhance, extracts the data and customizing these modules.
SAP Upgrades from 4.6C to ECC 5.0 and ECC 6.0. Performance Tuning and Troubleshooting SAP.
Extensive Experience in SAP ECC 5.0, SAP ECC 6.0.
Experience in Web Dynpro ABAP, XI.
Very exposure to ABAP HR Infotypes, Logical databases and Macros.
Extensive Knowledge of Workflow, BOR and OO Workflow using ABAP classes.
Positive work attitude and self motivated to work independently and and in a team. Excellent Communications and interpersonal skills.


Employment

March, 2008 -  March, 2009
Senior SAP ABAP Consultant

Intel Chandler , AZ . SAP NetWeaver 2004s SAP ECC 6.0
EIRP the first production implementation of the next generation SAP EDM xApp solution for Enterprise Master Data management developed by SAP and the EIRP team. EDM addresses shortfalls in SAP MDM for configurable workflow and business rules, flexible hierarchy management and a relational data repository solution.
Responsibilities : Developed a Web Dynpro application which takes the input file from the front end or shared drive and updates the classification data for the given materials.

Created VIEWS, WINDOWS and other UI elements along with re-use of ALV component, the application will display different ALV grids on the same view container dynamically and developed service class methods for data manipulation.
Developing a Web Dynpro application for Mass Upload and Characteristic SWAMP reports.
Defect fixing, enhancements-Web Dynpro UI, Change/Create RFC s and Classes.
Developed a conversion program to update the Supplier ID with new 1 in the HR master record table.
Developed the TDD s Technical Design Documentation for all the objects developed.
Creating new InfoObjects, InfoSources, DTP s and Transformations.
Generating proxy classes and creating logical ports to call web services inside class methods.
Developing XI configuration for RFC adapter and writing JAVA functions for XI mapping.
Monitoring the MDM syndication for BI.
Exception handling.


January, 2008 -  March, 2008
Senior SAP ABAP Consultant

Walt Disney Los Angels , CA . SAP ECC 6.0 Intel Chandler , AZ . SAP NetWeaver 2004s SAP ECC 6.0
Developed remote enable custom function modules to integrate r/3 with portal to create, change and copy material BOM s.
Developed a custom function module to retrieve data for various FI reports.
Developed a custom function module to calculate the Net Price for the given customer and material.
Performance tuning.
Defect fixing.


August, 2007 -  December, 2007
Senior SAP ABAP Consultant

Westborough , MA SAP 4.7 ECC 5.0 ECC 6.0

Developing a custom report which is to replace the SAP standard report RSADRQU2, in order to facilitate the customer to use the external reference data to update the BP s addresses in the database. Basically the report retrieves the address data to be validated from a standard index type table and calls a RFC function module external program to validate and update the address data against a third party database and return it to the calling program. Once the data is received the report will call the function module ADDR_WRITE_TO_QU_INDX to update the index type table with the modified data.
Design and developing an IMG activity which by execution prompts the user to select the RFC destination for postal validation for each country in the t005 table. If the data is exists, the user is prompted to change the RFC destination for all countries or the desired 1 and takes him to the table maintenance. Developed a custom table, maintenance view, transaction and an ABAP program to meet the above requirement.
Developed an ABAP program to create Business Partner from flat file using the BAPI
BAPI_BUPA_CREATE_FROM_DATA and the function module ALSM_EXCEL_TO_INTERNAL_TABLE to read the data from the Excel file. The user will select the flat file from the front end and execute the report which intern create the Business Partners and outputs their numbers in a list.
Modified the BADI methods ADDRESS_SEARCH of the definition ADDRESS_SEARCH and ADDRESS_POSTAL_CHECK of ADDRESS_CHECK to resize the ALV grid output screen with respect to the number of records retrieved.


March, 2007 -  July, 2007
SAP Technical Consultant

ConAgra Foods Inc , NE .- SAP ECC 5.0 SAP ECC 6.0 Westborough , MA SAP 4.7 ECC 5.0 ECC 6.0
Developing RM/QM interface program which is used by platform quality to trigger the creation of an Inspection Plan in back ground at the creation time of new specification. To achieve this many validations are to be performed on Material Plant Usage Inspection type and so on and using the BAPI, BAPI_INSPECTIONPLAN_CREATE is created in back ground and log report is generated for failed specifications in order to correct them and execute in UPDATE mode.
Developed a custom program to upload planned shipment path data from the custom table ZPTHDTA
Path Data for Smart Ops - Sourcing Data to application server by creating a logical path and using the functional module FILE_GET_NAME to execute the same program in different SCM landscapes.
Developed a custom CLASS to ensure that only new Product Hierarchy is posted for all the transactions going forward in BI landscape in the process of restating. The CLASS is re-used everywhere in the start routine of the update rules for all ODS objects which are affected by the New Promo Group change.

Developed a ABAP program to update ODS active tables for the values of Product Hierarchy and Marketing Hierarchy based on the selection criterion, The program was developed using FIELD-SYMBOLS to create Dynamic Internal tables and Work areas for ODS tables.
Developed custom CLASSES to re-stamp the values in ODS tables for PROFIT CENTER, COST CENTER from the respective XREF tables.
Developed a custom program to upload different flat file loads to various info cubes. It creates an info package using the bapi BAPI_IPAK_CREATE, if none exists with that file name and provides the user an option to delete the previously loaded requests with the same file name as of that of the running file load.
Created custom GENERIC DATA SOURCES with generic delta for extracting inbound delivery from Production Receipts header and details, Custom VIEWS were developed on LIKP and LIPS tables for extraction.
Installed Business Content Extractors for transactional and master data for BI P2P, PLM and ALM.
Few of them are : a DataSources for Transactional data
, 2LIS_05_Q0TASK, 2LIS_17_I3OPER, 2LIS_17_I3HDR etc.
Enhanced the BI data source 2LIS_08TRTLP shipment delivery stages with fields from LIKP, VBAK, VBAP tables and populated the data for the same by enhancing the include program ZXRSAU01 in the user-exit function module EXIT_SAPLRSAP_001 of enhancement RSAP0001.
Enhanced the BI data source 2LIS_17_I3OPER, Plant Maintenance Order Process, to get the PARTNER data from the partners table IHPA, by enhancing the append structure of extract structure
MC17I30OPR with custom field for partner and written the user-exit code to populate the data.


Jul', 2006 -  February, 2007
SAP Technical Consultant

Church and Dwight Inc Princeton N SAP ECC 5.0
Developed user interactive ALV reports using ABAP Objects.
Developed Packaging, Test method, Graphics specifications, each spec consists of development of about 8 screens for various sections for Create/Modify/Display transactions with features incompliance with SAP standards.
Developed dialog programs for various dynamic call requirements like displaying details of chosen RDR in a dialog container ALV Grid and used number of function modules both standard and custom as well for the user actions on ALV Grid.
Developed LSMW to load legacy data into SAP, developed LSMW programs for each individual specification.
Developed an ABAP program to migrate long texts to upload as Standard Text objects.
Developed recording objects in LSMW for custom transactions and performed validations on required fields in LSMW while uploading the data files populated default values in LSMW for the required fields.
Developed BDC programs for the data migration to run as back ground jobs for huge volume of data.
Created Z tables, domains, data elements, custom search help parameters, function modules and includes.
Developed E-R diagrams for the custom transactions using Above Soft Analyzer.
Created number ranges to generate the Spec number automatically when it is CREATE transaction, developed lock objects for master tables to avoid duplicate sessions.
Used Field symbols extensively. Used Field Symbols to call methods dynamically.
Developed Smartforms and associated driver programs for each spec to list the Spec data and converted them to PDF format.
Developed end to end ALE configuration for Material Master, BOM.


July, 2005 -  June, 2006
SAP MM/PP/FI/SD/ALV/ALE/LSMW/Data Conversion/User Exit/SAP Script technical Consultant

Nephron Pharmaceutical FL SAP 4.7

Developed technical specifications for interfaces, user exits and screen exits in accordance with all the project objectives.
Created ALV reports for Sales and Distribution that gives daily quote activity, sales activity, total dollars shipped, to ship, sales forecast and freight amount.
Configured ALE interface for migrating Customer master, Vendor master, part of Material Master Data info records and pricing condition records from 4.0B to 4.7 environments.
Written 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.
Design and develop technical specifications needed in business processes which process can use SAP standard and which should be handled by enhancements, user exits or modifications.
Created a Safety Stock Analysis report to display the safety stock of all materials for the given plant code, used as working tool for inventory rationalization.
Developed BDC programs to interface with different sub-systems. Interface programs included Material Master and Customer Master. The interfaces were both on-line and in batch processing modes to load and modify master data in logistics and SD modules.
Created an interactive report for extracting data from SAP tables Vendor master, Purchase Orders, Invoices to be transferred to vendors using non-SAP systems for reconciliation and their local use.
Worked on user exists for sales orders, communication method and pricing conditions, Function Location Number Range and Notifications.
Developed Sap Scripts and print programs for Quotation and Sales Order Confirmation.
Worked on Screen Variants, Transaction Variants for Quotations and Sales orders.
Developed the user-defined screens using SMARTFORMS, the areas covered were Billing, Sales determination, Materials Requirements planning, Product Costing and General Ledgers.
Created an ABAP routine to read the Selection Screen fields at any time. This could be used with any screen such that the user-entered values is read dynamically and the possible entries for the help values is programmed automatically.
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.
Developed a BDC program for changing the Purchase Order, Sales Order creation, Material creation, changing the material type in the material master transaction.

Developed Dialog Programs for Sales, Technical Support and Production personal which gives advantage to pull information on sales order.


September, 2004 -  July, 2005
SAP MM/SD/QM/SMART FORMS/ALE/IDOC/ALV/WORKFLOW/BADI Technical Consultant

TriVirix , NC SAP 4.6C-
Translated Business specifications to technical specifications.
Developed BDC program to check price variance for materials from different vendors. Check for the existing info record for the given vendor and show the difference in prices. Given the error message and generating BDCs to create info records for those vendors does not have info records.
Developed interactive reports to produce primary list and secondary list for the sales area ; the customers for that sales area, materials orders by the customers, its customer material information and the net price for that particular material.

Developed a transaction used to handle return orders giving the user more freedom of selection. This transaction is used to process all the return orders and can create service orders and notifications. After completing all the activities on return orders depending on the requirement, outbound deliveries is created. This transaction is used to print all the necessary documents in all stages of the return order processing.
Worked extensively on Smartforms like Sales Order Preview, Sales Order Confirmation.
Developed Smart forms for packing labels which include Barcodes and written print program. And worked on Barone software for same labels.
Developed and modified various sapscripts for production order, purchase order, GI-note, sales order delivery note, quotation script, debit/credit memo.
Configured workflow setup developed custom templates in QM notifications, calibrations, MM material master creation and purchase requisition approval.
Worked on Credit Card Validations at Header and Item Level based on shipping point for Sales orders.
Worked on ALE/ IDOC s for rejection codes in Sales order.
Developed Application List Viewer report for price exception report for a particular period.
Involved in creation and modification of new and existing reports in sales, delivery and billing.
Worked on BADI Implementations for SD module BADI_SD_Accounting_Item, BADI_SD_SALES, BADI_SD_SALES_ITEM. The method ITEM_CHECK checks whether the line item has a hazardous material and displays a pop up message if there is a hazardous material.
Involved in performance and tuning of objects. Involved in studying and applying OSS notes.


October, 2003 -  August, 2004
SAP SD/FI/ALV/BAPI/ALE/IDOC Technical Consultant

Hormel , MN SAP 4.6C-

Developed an ALV report that gives daily status of goods movement in the warehouse for a particular storage bins for estimating efficiency and further analysis on that storage location.

Developed report that generates customer summary balances for the selected date. Picks up the customer related line items corresponding to the selected FI documents and calculates the total debits, total credits and transaction balance for each customer.
Developed ALV reports for showroom replenishment, open delivery report, inventory adjustments which downloads to the excel sheet.
Created and maintained Data Dictionary objects like domains, data elements, views and lock objects.
Developed conversion programs for Purchase Orders, Info Records and Bill of Materials to transfer data from legacy system to SAP system.
Worked on BAPIs for creation of sales order, inquiry and simulation to get pricing conditions.
Changed credit card userexit to prevent credit card authorization for ship complete orders where not the entire product is available.
Configured ALE interface between R/3 systems. This instance was used to send the created Material Master to the corporate office using the object MATMAS.
Configured interfaces between SAP R/3 and legacy systems. The interfaces are PORDER, INVOICE and BILLING.

Sent Master data and Transaction data from 1 client to other client using BAPI and IDOC.

Developed a user defined BAPI function modules to display the order status.

VALEO INC, AUBURN HILLS, MI. - SAP


January, 2003 -  September, 2003
SAP SD/MM/ALV/ALE/EDI/IDOC/User Exit Technical Consultant

4.6B- Hormel , MN SAP 4.6C-
Created an ALV report that display month wise sales details by comparing with previous month and yearly sales details with selection criteria based on date.

Configured EDI environment using Message Control, Partner Profile, Port Definition, Condition Record, Process Code and Segment Definitions.
Configured interfaces for distributing master data like MATMAS, CREMAS, ORDERS and DEBMAS. Extended ORDERS03 and used enhancements to populate data into the extended segments.
Implemented Outbound IDOC processing module, Extended IDOCs and implemented user-exits, Implemented reports on IDOC tables integrated with Document flow to ease EDI operations.
Worked on user exit to replace the partner number by the Customer number in E1EDKA2.

Worked on IDOCs through EDI with message control for transferring PO to vendor. Worked in developing interfaces to different vendors for sending purchase orders and receiving confirmation using EDI and IDOCs. Maintained daily EDI transmission activities and setup new customers to the system.
Designed and developed programs to manipulate data in pre and post EDI Translation processes ; improving system efficiency and reporting. Worked on different IDOC issues in inbound processing for creation of application document.
Produced documentation and procedures regarding the proper use and operation of the EDI data communication environment.


June, 2002 -  December, 2002
SAP FICO/MM/ALE/EDI/BDC/User Exit Technical Consultant

AutoLek Inc INDIA
Technical team member for the implementation of the FI/CO and MM modules, the design and development of a custom front end application for the entry of freight forwarding orders in R/3.
The front end component included the definition of custom tables, screens and dialog programs to achieve the functionality required by the client. Integration with standard R/3 functionality included the development of automated entry of data into CO-Internal Orders, MM-Purchasing, FI-AP and FI-AR. The implementation of R/3 with the custom functionality allowed the client to achieve dramatic cost savings and timesavings in data entry and analysis from their legacy system.




Education

Master s in Computer Applications , India .



Skills


ERP Applications : SAP ECC 5.0, SAP ECC 6.0, NetWeaver 2004S SAP Tools : ABAP Workbench, LSMW, BDC, User Exits, ALE, ALV WebDynpro, XI/PI, Workflow. Operating Systems : Windows NT/2000, UNIX. Languages : ABAP/4, PL/SQL, Open SQL, C, C++, VB 6.0, JAVA. RDBMS : Oracle 8i, MS-SQL Server 2000, Access 2000. Web Designing Tools : HTML, XML, JavaScript, VBScript, Adobe Interactive forms. Visualization Tools : Microsoft Visio, Power Point. Database : Oracle, Access, SQL Server. Testing tools : Winrunner, Testdirector and QTP.



Miscellaneous

Configured the business process document to identify the appropriate EDI interface in SAP. Setting up Basic EDI Configuration. Setting up message condition, port and partner profile. Extension of Basic IDoc s and development. Configured INBOUND and OUTBOUND IDoc s.
Enhanced custom code in Sales Order Processing User Exits
USEREXITREADDOCUMENT
USEREXITSAVEDOCUMENTPREPARE
Designed the mechanism offered by SAP to transport Legacy into SAP systems using BDC s. Batch Communication interface for Vendor Master XK01 was generated to transfer from legacy system to the SAP R/3 system, for creating new Vendors using the classical batch input method.
References Available Upon Request
Ramesh Narala
2