Sap Technical Consultant Resume
SUMMARY
- SAP Technical Consultant with 8 Years of IT experience in analyzing and developing technical solutions.
- Involved in the full life cycle implementation, upgrade and production support projects in various SAP R/3 versions.
- Possess a combination of business experience and technical expertise, which enables in contributing and adding more value to SAP projects both technically and functionally.
- Experience in establishing project standards, templates and procedures in design/architecture.
- Committed team player with high degree of conceptual and analytical skills combined with good communication, presentation, interpersonal and documentation skills.
- Work independently and collaboratively with team members to achieve common goals, while maintaining responsibilities and commitments.
- Extensively worked with creation of data dictionary objects including Domains, Data Elements, Tables, Views, Lock Objects, Search helps, Index and Views.
- Multiple projects on Data Migration with BDCs, Legacy System Migration workbench (LSMW) for data upload for various SAP Projects.
- Experience in documenting and developing the RICEF objects i.e. Reports (ALV, SALV & Classical), Interfaces (EDI/ALE IDOCs, BAPI), Conversions (BDC & LSMW), Enhancements (User Exits), Forms & Labels (SAP Script, Smart Forms, Adobe Forms).
- Experience in Reports (Classical, Interactive and ALV Reports) using ABAP/4.
- Experience in On-Line Transaction Programming (Dialog Programming / Module pool, Screen Painter and Menu Painter).
- Experience in Batch Data Communication (BDC).
- Experience in Legacy System Migration Workbench (LSMW) and BAPI.
- Strong experience working in SAP Scripts and Smart Forms.
- Experience in Standard User Exits, BADI and Enhancement Spots to enhance the functionality of Standard Business applications.
- Experience in ALE/ EDI /IDOC configurations includes creating Logical System, Port Definitions, RFC destinations, and Partner Profile generation.
- Experience in Open SQL statements.
- Experience in creation and enhancement of IDOC's.
- Have been involved in Performance tuning, Testing and Optimization of code.
- Experience in analyzing, developing and completing assigned break/fix requests.
- Experience in finding/applying OSS notes for functional/technical fix.
- Experience in Technical Development Process including Requirement Analysis, Review of Functional Specifications, Technical Specifications, Coding, Unit & Integration Testing and Quality Reviews
- Experience in other tools like Debugger, Screen Painter, Menu Painter, Function Library, Runtime Analyzer and Dump Analyzer.
- Knowledge of different functional areas of SAP R/3 like MM, SD, PM, FI & CO.
- Experienced in SAP Versions R/3 4.6c, R/3 4.7 and ECC 6.0
- Bachelor of Engineering (Computer Science)
Client : Confidential, Lake Shore, IL
Role : SAP ABAP Consultant
Duration : 05/2012 - 07/2012.
Modules : SD, MM & FI
Environment : ECC 6.0
Scope : Re-design the existing Webdynpro for Quote system.
Confidential, supplies facilities maintenance and other related products in North America and Asia. The company operates in three segments, Branch-based Distribution, Acklands-Grainger Inc. (Canada) and GHC Specialty Brands.
The Branch-based Distribution businesses include Grainger\'s Industrial Supply division; Grainger\'s Export division; Grainger\'s Global Sourcing division; Grainger S.A. de C.V. (Mexico); Grainger Caribe, Inc. (Puerto Rico); Grainger Colombia (Colombia) and Grainger China, LLC China Distribution. Grainger distributes various supplies, such as material handling, safety and security, cleaning and maintenance, pumps and plumbing, electrical, lighting, ventilation, tools, metal working, fluid power, heating and air-conditioning products, motors, and power transmissions.
Auckland's - Grainger Inc. is Canada\'s leading broad-line distributor of industrial, fleet and safety products.
GHC Specialty Brands is the result of Grainger\'s acquisition of Lab Safety Supply and several other catalog companies, including Gempler\'s, Ben Meadows, High smith, and Mc Feely\'s. It markets safety and other industrial products to customers under several brands throughout North America.
Grainger serves customers through a network of approximately 415 branches, 9 distribution centers, numerous catalogs and direct mail pieces and several Web sites. W. W. Grainger, Inc. was incorporated in 1927 and is based in Lake Forest, Illinois.
A unique aspect that sets W. W. Grainger apart from other industrial supply companies is that they have an extensive, on-site; U.S. based Technical Product Support for all of their products. Their Technical Product Support Specialists have hands-on experience and training, who have the ability to assist with the correct product selection, application assistance, installation and troubleshooting.
Responsibilities:-
- Have created a Class for RTA rules which will validate the RTA rules for all countries. Also created several methods to check: RTA, Track Code, Contract, Sales Org, Exporting Customer, Vendor's Brand, Quote Overlap, Vendor's item, discontinued item, Cost & Exportable item within that class to validate the quotes.
- Have created RTA parameter table which will hold RTA rules for all countries. This table will be accessed by Sales Org, RTA Rules ID and Customer Segment type. This table is equipped with all the functionality like: users have single full screen maintenance view like a spreadsheet, time stamp, transaction code etc.
- Have created a Class for Quote Search and several methods within it to find the user specific quote quickly, where user can find the quote by quote number, customer number, country code, sales org, etc. and integrated within the existing Webdynpro using FPM (Floor Plan Manager).
- Have done the performance tuning for several classes and methods to Re-Design the existing webdynpro. In this process have broken several deep structures, classes and Methods into smaller parts and re-integrated in the existing webdynpro using FPM (Floor Plan Manager).
- Have created a custom utility program to locate the BADI's for SAP Transaction code or Program using tables: tstc, tadir, modsapt, modact, trdir, tfdir, enlfdir, sxs_attrt, tstct. Using this program users need to just pass the transaction code or program name on selection screen and this custom program will automatically give user the list of the BADI's used in the Transaction Code or Program.
- Have created a custom utility program to find the USER EXITS for SAP Transaction code or Program using tables: tstc, tadir, trdir, tfdir, modsapt, modact, enlfdir, sxs_attrt, tstct. Using this program users need to just pass the Transaction code or Program name on selection screen and this program will give user the list of user-exits used in Transaction code or Program.
- Have created a SMART FORM for PO (Purchase Order) and also created a custom program to convert the output of SMART FORM into PDF format.
- Have created a custom program to send the SMART FORM's output as attachment in PDF format for PO in email.
- Uploaded Purchase Order Using LSMW in Standard Batch/Direct Input Method, using multiple flat files for generating the PO, one file for Header data and another one for Item data.
- Uploaded Material Master Data using BAPI method in LSMW.
- Developed an LSMW to change routing transaction CA02.
- DevelopedBDCprogram to uploadcustomer masterdata.
Client : Confidential, Libertyville, IL
Role : SAP ABAP Consultant
Duration : 01/2012 - 04/2012.
Modules : SD, MM, FI & PP
Environment : ECC 6.0, APO, CRM, BW, EDW
Confidential, Incorporated is an independently-owned global company that develops, manufactures and markets healthcare products, servicing over 90 countries. The scope of the project is to provide production support for the existing systems.
Responsibilities:-- Have created a 3-way match program or triangular extract to load the Transfer Price , Info-Record & Standard Cost, using this extract loading one incoming file of Transfer Price and based on this incoming transfer price file, creating three different file Transfer Price, Info-Record and Standard Cost with help of Master table. Using this extract updating or creating entries for SAP using Transactions VK11, VK12, ME11, ME12 and MR21. During the validation of records if any error occurs then generating a error file and downloading the error file on User's Specific path, also giving ability to user to see the error log on front-end, also giving an option to User for fast data entry screen in spread-sheet on Selection-Screen if user does not have a Transfer-Price file and user wants to enter few records manually for transfer price and based on these entries user can generate Info-Record and Standard Cost. This program is equipped with TEST MODE, SUPPORT EMAIL etc Functionality.
- Have created a master table to load the combined data of Transfer Price, Info-Record and Standard Cost and also created a load program to load the data in this master table and validate the data before loading into master table. In master table loading multiple vendors in one lane and triangular extract is creating separate Info-Record for each vendor and updating SAP, Also giving authority to specific users to load the data and delete the data into table. Created entry screen in SM30 for this table using screen painter.
- This table is equipped with Time-stamp, Transaction Code etc, functionality.
- Have created a Dormant Users Report to replace the current intelli corp report.It's kind of report for all inactive users in all existing system. The data is based on tables USR02, USR06 etc. Also it is summarized by USER ID. The systems are reviewed by this are R/3, APO and CRM for 90 days and BW & EDW for 365 days. Bringing the data from all system based on user criteria using RFC in ECC and then generating a report in ALV.
- Have Created an Extract to Generate a Report of Transfer Price for Price Group or Materials and Customer/Materials in various format. The data is based on tables A032, A005, KONP etc. Also it is summarized by Customer number or Price Group, Sales Org and Distribution Channel. The program is equipped with various functionality like User can display the report in Text or Spreadsheet format, Download the report in Text or Spreadsheet format or directly print without display or download in portrait format. Also user can include discontinued material and additional column headers for New Pricing (For New customer/Price Group). Also User has option to choose Layout on selection screen before executing the program.
- Have Created a custom program to clear the LOCK BOX PROCESS, for document type DZ, DA and RX for specific region, company code and customer, it's kind of rebate processing. If any balance is due and rebate is due, and it's debit or credit then it's clearing and offsetting the amount and after processing, it's posting the document using Transaction codes FB05 and F-30, modified the standard sap program SAPMZLCK.
- Have created a SAP LICENSE COUNT REPORT in ALV to replace current intelli corp report. The data is based on tables USR02 and USR06 and it is summarized by User ID. The systems reviewed by this are R/3, BW, APO, CRM and EDW.
- Have Created a Reservation No Production Order Report for Demand Management and Production Planning(PP), this is a consolidated report to analyze and monitor materials with reservation requirements , no open production orders to cover material requirements and Bulk SLOC to cover the reservation requirements. Planner can view a consolidated report, usually for a plant. The report is showing the output as Plant, Material, MRP Controller, Reservartion Date, Reservation Quantity and Comment. The selection screen input parameters include PLANT, MATERIAL, MRP CONTROLLER AND DATE RANGE. Also the output could be downloaded in excel sheet format as well as viewable in SAP screens in ALV format.
- Have Created a ALV Report that checks to make sure an Email account Exists for a ECC user and it's a valid email address to replace the current intelli corp report. Data based on tables USR02 and ADR6, and bapi bapi_get_details, Also Setting filter as Valid To date (USR02.GLTGB) > = Today's date and User Type (USR02.USTYP) = 'A' (Dialog).
- Have created a SMART FORM to include a personalized document with free delivery orders using reason codes 172, 206, 208 & 209.According to business the form output trigger along with picklist.The output is restricted only for some deliveries with reason codes 172, 206, 208 and 209 by business. The order reason (AUGRU) is not available in the communication structure KOMKVB2 but available in field catalogue so appending it into communication structure KOMKVB2 and utilizing the SAP provided user exit to fill the order reason in communication structure and dependent access sequence identified while triggering the output.
- Have Created a Program to determine the Storage location on Sales Order. When Sales order is created the Storage location is populating up front in sales order from the configuration table TVKOL and if Storage location is determined on sales order, SAP will not re-determine the storage location during the creation of delivery. Using this program saving freight cost.
- Have created a program to provide mechanism to create a time delay as one of the steps in a background job. This program utilizes the transaction SM36 as the tool to schedule background jobs and giving ability to include a job step to introduce a time delay, as a first, last or intermediate step. The time delay step can be used in several background jobs, using a job and step specific delay duration.
- Developed a BDC call transaction program in MM to load Material Master Data into SAP system from legacy system.
- Involved in writing Batch Data Communication (BDC) programs for transferring the vendor master legacy data to SAP R/3 system using Batch Input Method.
Client : Confidential, IL
Role : SAP ABAP Consultant
Duration : 06/2010 - 12/2011.
Modules : SD, MM & FI-CO
Environment : ECC 6.0
Confidential, is the third largest credit bureau of the United States which offers credit related information to the potential creditors.Trans Union is implementing SAP in South Africa Region. The scope of the project is to migrate the data from legacy to SAP.
Responsibilities:-- Responsible for production support, developing the custom objects and unit testing and documentation for the objects.
- Prepared technical specifications and developed the report for Equipment Master Records along with classification data.
- Have created a outbound extract for People Soft, In this extract the program is fetching all the GL Account data from various SAP tables like bseg, bkpf, knb1, skb1, t001 and various custom tables and storing in a fix length file format on application server at comm directory in a specific layout required by People Soft. This extract runs on monthly basis. This program fetch the data based on user criteria then maps with various requirements from the data of several custom tables then it converts the data as per people soft requirement then it\'s generate a fix length file and stores it on application server as per people soft required layout. This program is automated to run on a fix date of every month. This program is equipped with TEST MODE, SUPPORT EMAIL etc Functionality.
- Have created a inbound and outbound extract for AIS (Automobile magazine just like Kelly Book Value in United State, Trans Union runs this business in South Africa.) Subscription renewal. AIS send a CSV file every month which holds the data for their potential customer for subscription renewal of their magazine. This extract is reading that file from Application Server and storing in two custom tables in a specific layout. This program is not doing any sap posting because this is a subscription renewal Performa. From here an outbound extract is passing the data of these two custom tables to LASER.COM third party for printing in a specific layout required by AIS. This program is equipped with TEST MODE, SUPPORT EMAIL etc, Functionality. This program runs on monthly basis and this is automated to run on a fix date of every month.
- Have created a extract for Trans Union monthly payroll system. Trans Union send a flat file very month which holds the data for employee's salary, bonus, incentives, etc., this program is reading that file and if files passed all the validation then it\'s posting all the data in SAP or generating a document in SAP and posting this document. This program is equipped with TEST MODE, SUPPORT EMAIL etc Functionality. This program runs on monthly basis and automated to run on a fix date of every month.
- Implemented a Business Add-Ins (BADI) to extend Customer Master Transaction.
- Prepared technical specifications and developed Smart Form to print the SAP Task lists types inspection plans, reference operation sets and routings.
- Modified a Smart Form as per the client requirement for the Invoice summary.
- Modified a Smart Form according to the client requirement for QM - Audit Execution Form.
- Prepared technical specifications and developed BDC to delete routing PRT's using the transaction CA02.
- Prepared technical specifications and developed extract & ALV report for any newly created Bill of Materials or any Bill of Materials which have been changed during a given timeframe.
- Prepared technical specifications and developed extract & ALV report for Past Due Production Orders with standard cost
- Prepared technical specification and developed extract & ALV report for Planned Orders.
- Added the Auto E-mail notification functionality to the existing objects like Stock Overview report, Material Receipt List report and Back Orders/Zero Shipped Orders report.
- Enhanced the functionality of the Record Usage Decision based on the business requirements.
- Developed a transaction to delete the error IDocs from the IDoc lists and to store the deleted IDocs information in a table based on plant, customer and date.
- Converted a large number of custom reports to more efficient ALV reports and added ALV feature to existing reports.
- Involved in Performance Tuning for the existing reports.
Client : Confidential
Role : SAP ABAP Consultant
Duration : 03/2009 - 05/2010
Modules : SD, MM, FI-CO, PP, PM
Environment : ECC 6.0
Profile:-
Confidential, is amultinational corporation headquartered inSan Jose, California, that designs and sells consumer electronics, networking, voice, and communications technology and services. The scope of the project is to implement SAP ECC.6.0 and migrate from the existing legacy system.
Responsibilities:-
- Responsible for preparing technical specifications from functional Specifications.
- Involved in understanding of existing landscape/interfaces for feasibility study.
- Worked on very complex and high priority enhancements/ modifications.
- Worked extensively on ALV reports, Interactive reports and Module pool programming.
- Worked on several reports for Performance improvement (SQL based) and Usability Improvement (Selections and Outputs)
- Created Vendor Performance Report that lists Vendor Name, Materials Supplied, Planned & Actual Delivery times, Payments Terms and Prices.
- Developed Material Master detailed report. With material, plant and material type as input, output list will have total quantity by material group and plant.
- Developed BDC program to upload Source List for Material into SAP R/3 system.
- Implemented a Business Add-In (BADI) to raise an error message if a user doesn't have permission to create a Goods Receipt for specific document type.
- Created an interactive report that lists the Purchase orders. It allows the user to select types of purchase orders in specified time period. Also it allows the user to drill from the basic list for a subsequent list of the line items for the selected purchase order.
- Worked extensively on Smart Forms and SAP scripts.
- Uploaded Vendor Master Data into SAP using recording method in LSMW.
- Created an IDOC that was generated automatically whenever a Purchase Order is created or changed.
- Used SQL Trace and ABAP Runtime Analysis for performance enhancement of extraction
- Used Change and Transport management System for transport of adhoc custom development request to project servers and/or quality environments
Client : Confidential, Deerfield-IL.
Role : SAP ABAP Developer
Duration : 01/2008 - 02/2009
Modules : SD, MM, PM, WM, FI-CO
Environment : SAP R/3 4.7
Profile:-
Confidential, is a leader manufacturing company of Alcoholic Beverages. The scope of the project was to roll-out SAP.
Responsibilities:-
- Was responsible for Interaction with functional consultant for Functional Specification Development. Converting Functional Specification to Technical Specification. Technical Specification Review, Coding, Code review, Unit testing.
- Optimization & Performance tuning of Reports and Transactions. Analysis of reports.
- Worked on a User Exit to capture the various reason codes for short pick quantity than the original delivery quantity in the delivery document. Custom function module is created and raised to capture reason codes also updated in audit table with all information.
- GR/IR Report: Developed a customized Report which shows the Goods Receipt and Invoice receipt details for the PO for a specific Date Range on the screen and then transfers the data in two files as well. One file is for Goods Receipt and the other is for Invoice Receipt.
- Involved in setting up the Port definition, RFC Destination, Partner profile, Filter objects and tested the Inbound/Outbound IDoc Process.
- Developed a very complex Report for SDA Shipment Reconciliation which will provide the Billing team a tool to resolve SDA inventory reconciliation issues related to shipments to the SDA being processed for the correct week/in store date. This report compared SDA orders against inventory transactions to compare that inventory has been posted properly for the SDA orders.
- Worked on Dialog programming to create complex screens, table control, tab strips, custom container etc.
- Developed a Dialog program for Material Details, Vendor Details, and Customer Details using tab-strips. This front end was created to Add, Modify, and views the respective details from Z tables and SAP tables.
- Developed an IDOCs with serialized message distribution, IDOCs are created, sent and posted in a specific order message types MATMAS (material master) and CLFMAS (classification) are assigned to a serialization group for dispatching materials and their accompanying classifications.
Client : Confidential, Toledo-Ohio.
Role : SAP ABAP Developer
Duration : 07/2007 - 01/2008
Modules : SD, MM, FI-CO, WM, PM
Environment : SAP R/3 4.7
Profile:-
Midwest Tape is a full service DVD, music CD, and audio book distributor, conducting business exclusively with public libraries. The scope of the project was to implement SAP, migrating from the existing legacy system.
Responsibilities:-
- Responsible for documentation, developing the object and unit testing and for the SAP custom objects.
- Developed a Complex ALV (ABAP List Viewer) Based Utility tool with facility to drill down to different levels.
- Developed Customer Lock Box Payment Report for identifying incoming check related information with details pertaining to the collection of receivables from customers.
- Created Vendor Request on-line Processing using dialog programming. This program gathers requests from users for vendors to be added to the system or changed within the system. It is kept in sync with the vendor files on the mainframe. It creates unique vendor numbers for new vendors. It also prints a few control reports.
- Developed an interface by using a BADI (Business Add Ins)to create a sales order from third party front end.
- Incoming invoice created using a BADI. (Business Add Ins).
- Modified transactions according to the user requirements.
- Developed report for approval of stock adjustment for all vendors. Developed report for inter plant material dispatches. Developed Goods Receipt Analysis report which gives the details of the materials received, either by company code, or by storage location or by date.
- Developed Record Transaction using Legacy System Migration Workbench (LSMW) to migrate free service coupon data.
- Designed and developed a BDC program to upload Work Center data and Vendor master data from legacy to SAP R/3.
Client : Confidential, Oakbrook-IL.
Role : SAP ABAP Developer
Duration : 11/2006 - 06/2007
Modules : SD, MM, FI, PP & PM
Environment : SAP R/3 4.6c
Profile:-
Confidential, is the largest retailer-owned cooperative and clear leader in the convenience segment of the hardware industry in terms of wholesale and retail sales and strength of the brand. The scope of the project was to roll-out SAP modules based on the implementation done for the parent company, Siemens AG in Germany.
Responsibilities:-
- Responsible for developing Custom Objects, unit testing & documentation for the objects and production support.
- Developed a report to display all the Purchase Orders for the purchasing organization. The report displays the total and individual values of all the Purchase Orders.
- Developed Classical and Interactive reports to display the Bill of Material for the given assembly line and find the parts & stock list along with their cost.
- Developed an Interactive report to find the average capacity version/cycle time for a given work center and display its equipments.
- Created various ALV reports including Vendor wise Rejection Report, Inspection Status Report, Production Plan Report, MIS reports like Error Analysis report etc.,
- Developed reports like Listing of Moving Average Price for a particular material and its stock value.
- Developed conversion programs for Vendor Master and Customer Master using Legacy System Migration Workbench (LSMW).
- Developed the layout set for Quotation Format according to the client's requirements and write a Print program.
- Modified the invoice layout set according to the client's requirements.
- Created a User Exit to include Material Description when Goods Receipts is entered with respect to Purchase Order.
Client : Confidential, Beed-India
Role : SAP ABAP Developer
Duration : 03/2003 - 10/2006
Modules : SD, MM, FI, PP & PM
Environment : SAP R/3 4.6c
Profile:-
Confidential, is a leading equipment manufacturer in INDIA. The scope of the project was to implement SAP, migrating from the existing legacy system.
Responsibilities:-
- Setting up and defining logical systems, RFC destination, customer distribution models, generating partner profiles, messages types, IDOC types, Port definitions, Message control using SAP Cross Application ALE Process.
- Outbound Process - Stand-alone programs, Message Control, Extended/Reduced IDOCs & change pointers
- Inbound Process - Via Function Modules & workflows.
- Worked Extended Idoc concepts which internally use the Customer exits.
- Modified the purchase order (MEDRUCK), Invoice (RVINVOICE1) & Sales order (RVORDER01) layout sets.
- Developed a stand-alone print program by modifying the customized pricing program to print the official price list and weekly price quotes for the customer.
- Worked on BDC to upload data into SAP R/3 like
- Purchase order using transaction ME21.
- Customer Master Data using transaction XD01.
- Modified Standard Layouts as per the Client's Specification like
- Modified Standard Layout RVINVOICE01.
- Included standard text according to the user requirements.
- Changed a custom layout of Smart form for printing Contract for the seed Growers and changed the logic in the Print Program to calculate the percentage of planting payments, harvesting charges, hauling charges.
- Modified a Custom layout of Smart form to change the verbose and to accommodate more owners(customers)
- Worked with Order Management - SMARTFORM Shippers Letter of Instructions to change the export shipment based on final Shipment point (Delivery).
- Involved in the ALE integration of workflow to process the inbound errors.
- Worked with Module pool (screen & Menu) painter to call sub screens & adding menu items to the existing screen.