We provide IT Staff Augmentation Services!

Techno Functional Consultant Resume

3.00/5 (Submit Your Rating)

Memphis, TN

Summary

  • Around 7 years of Experience in design, development and implementation in SAP R/3 and APO as a Techno functional Consultant in several R/3 & APO implementations, Post Go-LiveSupport, and Upgrade.
  • Complete understanding and working knowledge of the full life cycle implementation of SAP R/3.
  • Extensive experience of working in the Modules of SD, MM, PP, HR, WM, BW, CRM, FI /CO & APO.
  • Expertise in writing Technical Specifications
  • Expertise in Unit Testing and Integration Testing.
  • Worked on various Implementation, Upgrade (SCM 3.0 to 5.0, SCM 4.0 to 5.0 and ERP 3.1h to 4.6c, 4.6c to ECC 5.0/6.0) and Support projects
  • Worked on Interfaces, Conversions, Customizations, Reporting using SAP R/3.
  • Worked on SAP Script, Smart Forms, Module Pool Programming, Screen Painter, Menu painter, BADI and User Exits
  • Extensively worked on SAP Reports (Classical/Interactive)
  • Strong expertise on Livecache data extraction, BDC, BAPI, Business Objects, BADI, LSMW, RFC, ALE,BSP, EDI & IDOCS, Web Methods, XI, Netweaver
  • Worked on APO modules DP, SNP, PP/DS, GATP and EM interfaces
  • Worked on Asset, ANSI X12, EDIFACT, XML, EDIINT AS2,Gentran, GIS, Netweaver, WAS 6.4, EP
  • Extensive Experience in Report Writer, ALV Grid Control, Performance Tuning and Troubleshooting SAP.
  • Excellent communication, analytical skills and experience in interacting with Clients and End-users.
  • Good at team participation, inter-team coordination and leadership capabilities.

Technical Skills:

ERP

SAP R/3 (3.1 H to 4.7) ECC 5.0 ECC 6.0

SAP Tools

ABAP Workbench, LSMW, BDC, User Exits, ALE, ALV,BSP

Operating Systems

Windows NT/2000, UNIX (Sun Solaris, Linux)

Languages

ABAP/4, PL/SQL, Open SQL, C, C++, VB 6.0, JAVA

RDBMS

Oracle 8i, MS-SQL Server 2000, MS Access 2000

Database

Oracle, MS Access, SQL Server

Testing Tools

CATT and eCATT

Web Design Tools

HTML, XML,UML, JavaScript, VBScript

Upgrade

SCM 3.0 to 5.0 , SCM 4.0 to 5.0 and ERP 3.1h to 4.6c,
4.6c to ECC 5.0/6.0

Confidential, Memphis, TN Oct’07 – till date
Responsibilities:

  • Customized purchase requisition realignment using standard SAP Heuristic SAP_PP_009
  • I2P template uses portal to create, maintain and delete customers, vendors and banks data. Portal forms the entry point of these data, which are transferred to MDM, for duplication checks and then transferred to the R3 system using Web methods Interfaces. Guided Procedures are used to implement the workflow for creation, modification and deletions. UWL is also implemented to handle the tasks of approval. MDM 5. 5 SP5 is used to hold the repositories of the customers, vendors and banks. The user interface is implemented using Web Dynpro.
  • Maintained Planning board profiles and Planning Groups
  • Defined functions for context Menu in DS Planning Table
  • Defined functions for the tool bar in the Detailed Scheduling Planning board
  • Configuration of DP and SNP, Prototyping Capable to Match (CTM) and Vendor Managed Inventory (VMI)
  • Developed a custom program which is an enhancement to the standard SAP transaction /sapapo/ac42 is used to view the selected product allocation group\'s allocation status in APO. The main FM ZSP_R2814_QUOTA_DISP_QTY used in this program is built by selectively copying the standard sap FM /SAPAPO/QUOTA_DISPLAY_QTY. Product allocation group details got from table/sapapo/t190g.
  • Developed a program to extract possible entries for a specified planning book using function module /SAPAPO/MSDP_PB_F4_DVIEW
  • Created a DP Object to Compare ZDD2PCP Planning Object Structure data and corresponding Master Info object data and create entries in the realignment table.
  • Developed a application for Mass deletion of CVC’s
  • Designed and developed an End routine for allocation staging cube
  • Created an User-exit Macro for Trades Receipt and extracting time series values from the trades planning book from the table T_C_TAB. The table entries are explicitly defined by their Z line index and their C column index.
  • Developed a downstream constraint report to give the planner a view of how production planned to come off the Paper Machine and rewinder. This would allow them to make adjustments to the schedule if certain down stream constraints are likely to be broken.
  • Created an update program for both delta and full update Master data update for Ship from in APO
  • Configuration of Core Data Interfaces (CIF and Integration Models) and Livecache consistency checks
  • Worked on PP/DS Remote Weekly heuristic to reschedule Sheeter Orders by getting the alternate best SOS and reschedule on the highest source
  • Developed a program to generate SNP PPMs from PPDS PPMs
  • Worked on production support where method get_duration_calc to get the duration during order configuration gives an error
  • Developed an interactive On Roll Status heuristic report to launch from the PP/DS Planning Board for the resource displaying block schedule with dates and capacity information including multiple pegged inputs.
  • Added the new functionality for EAL (Extended Application Logging) for V4 PPM filtering messages during the order creation. EAL will be parameterized to allow analyst to turn logging on or off using User profile - Parameters
  • Worked on Trim Release Controlled Replan Light to replan the creation of new receipt elements for those segments with unfirmed receipts that are considered in the planning run. Receipt elements created in one simulation version are unknown entities for other concurrent simulation versions. So, when the same planning segment is considered in multiple simulations replans, and both simulations are eventually merged to the active version, surplus receipts will be created in the active version for the same demands considered in the respective simulations.
  • Added the additional functionality needed in the CreateFromTemplate BAPI call (ManufactOrderAPS.CreateFromTemplate BAPI) to support the X-Trim to APO trim release
    Process.
  • Created a proof of concept for the incremental requirements associated with CPB sheeting processes such as Converting Production from an Intermediate (DPR) PE Roll Make to Order Sheet, Orders quoted from a Master Roll (Multiple Input Material) and the Scheduling Off-Line Cartonizer
  • Updated the CMS load program to load Split State and loaded the data in the CMS load file into table A937 in R/3.
  • Created a Requirement Routine 901 to use with the listing or exclusion functionality for PRD4 materials, on-XPEDX intracompany sales orders and alter the standard listing functionality (which permits a customer to only buy listed materials) to allow materials to be bought by listed customers in R/3 EDV system.
  • Created a conversion exit for Roll Diameter CONVERSION_EXIT_ZROLD_INPUT/OUTPUT for the data element /BIC/OIZDAROLDIA
  • Created a Batch Delete Flag Control Program to speed up the process of batch archiving by marking them for deletion using this report before the actual batch job runs in R/3 EDE System.
  • Worked on the enhancement to automate the population of the Last Date of Change (LDC) for sales order items when Capable to Promise (CTP) availability checking is initiated and saleable quantities are confirmed both in R/3 and APO.
  • Developed a report to give the sales text for any given plant/material/material group/material type/distribution channel to resolve the production issue.
  • Designed a Customer communication Workflow tool for the Right Fax Communication with SAP R/3

Environment: SAP R/3 4.7, SCM 5.0, Web methods, BW, SD, MM, PP, BDC, BAPI, BADI, RFC, CRM

Confidential, Golden, CO Jun\'07 – Sep’07
Responsibilities:

  • Involved in Technical upgrade from SCM 3.0 to SCM 5.0
  • Involved in SP28 SPAU and SPDD Corrections during upgrade both in dev(AD2) and testing(AQ2) systems
  • Interfaces have been created using ABAP, and XI as the middleware used to connect SAP/ non SAP system
  • Designed and implemented a financial master data portal and automate the master data distribution process to various SAP/ non SAP systems. MDP is used to enter all financial data which is developed using Web Dynpro and EP (Enterprise Portal). ECCS is used for consolidating all the financial data. Used MDM (Master Data Management system) to store data centrally. And using XI(SAP exchange Infrastructure) the data is integrated with all the systems
  • Created Integration model for material, sales order, purchase order, process order , PPM and resources and resolved issues during consistency checks and CIF from R/3 to APO
  • Worked on BAPI_TPVSSRVAPS_GETORDERSETS and implemented BADI User exit in order to derive the mode from a freight unit field
  • Implemented OSS notes in R/3 ECC 6.0 and APO 5.0 System related to SCM Upgrade , CIF and Live Cache performance
  • Upgraded and Implemented OSS notes 506832 and 518274 to fit in ECC 6.0 environment as Coors needs to CIF specific material group
  • Resolved Internal error generated during optimization when attempting to run optimization from PPDS planning board
  • Defined new Class to satisfy the requirement of PPDS module in APO: Class with ‘300’ class type (Variants) for the usage in MRP3 view for Characteristic Based Planning in PPDS module.
  • Implemented BADI for PP/DS Components , mode linkage and schedule error
  • Customized the standard TP/VS transaction /SAPAPO/VS01 in order to optimize the demands and supplies through Load builder ( iLog ) and save the results in R/3
  • Replaced the custom FM ZVS_ORDER_GET which is a copy of standard and in new version it is obsolete so replaced around 15 programs with the new SAP provided FM
  • Removed user exits which is no longer needed in 5.0 environment
  • Worked on custom program ZSNP_CREATE_TLB_ORDERS to create TLB orders which is a copy of standard program based on Coors requirements
  • Deleted unwanted planning book ZCBL_SNP_BOOK4 in AD2 and AQ2
  • Worked on PP/DS Flex report and replaced the old objects with the new parameters during upgrade
  • Enhanced missing PALLET field in table maintenance
  • Worked with iLog TP/VS resource to bring SO\'s, PO\'s and TLB Orders in Load Builder
  • Developed a program to delete existing old orders in dev environment
  • Worked on SNP CBL Production plan report and enhanced to new environment as in SCM 5.0 SAP does not maintain version in constant which results in COM error
  • Worked on User exit ZXAPOBAPIUSERU06 Changes to component SCM 5.0
  • Worked on Sorting order in User exit ZXCIFUSERU16
  • Implemented OSS note to resolve mode linkage issue during PPM transfer
  • Worked on report to adjust MATMAP table entries
  • Worked on FM ZLB_EXCHANGE_DATA in order to exchange data between Load Builder and APO
  • Worked on SNP Product split program as it was showing more than 15 short dumps due to upgrade
  • Developed a program to remove Config Id
  • Created a message class specific to EM to capture the errors during shipment release
  • Worked on BW Update rules during CBL Loads which gave the error during unit conversion
  • Worked with EM Consultant to bring shipments from R/3
  • Worked on User exit to change freight unit data using profile parameters and schedule lines
  • In order to improve the performance of MB5B transaction I have applied various OSS notes and utilized enhancement spots for Coors specific changes and removed custom MB5B program which is a copy of standard

Environment: SAP ECC 6.0, SCM 5.0, Web methods, EM, BW, SD, MM, PP, BDC, BAPI, BADI, RFC

Confidential, Louisville, KY Oct’06 – May’07
Responsibilities:

  • Involved in Technical upgrade from SCM 4.0 to SCM 5.0
  • Implemented OSS note manually to provide additional functions to the report /sapapo/sdrqcr21 to updatethe CIF queue
  • Implemented over 50 OSS notes in R/3 and APO System related to SCM Upgrade, GATP Issues and CIF. Implemented SAP Notes for SCM 5.0 SP8
  • Worked on Customer user exit ZCIFMEIN is used to modify inbound materials to APO and changed the User exit code in APOCF012
  • Worked on PPDS transaction /SAPAPO/CDPS1 - View 1 Overall profile and the work area which shows different blocks with the same color
  • Involved in part of a team to test R/3 Plug-In for SAP SCM (R/3 D46 and APO-Dev)
  • Implemented BADI to UpdateSNPPPMsduringconversionfromPPDSPPMs
  • Developed custom program to update the status of PPMs using BAPI
  • Enhanced custom program to Update table /sapapo/plan_gen based on certain conditions to enable batch processing of SNP PPM Generation
  • Worked on the issue in the test SCM 5.0 environments the optimizer does not schedule the order so that they adhere to the blocks.
  • Created a custom programto UpdateApplicationlogs fromthereleaseofDPtoSNP
  • Worked on CIF User exit : IncludeZXCIFUSERZZZ and ZXCDPSUSERU05 to get order data
  • Created SecondaryIndexfortable/SAPAPO/ORD_LINK to improve the performance
  • Worked on User exit to changetheCorrelationProfile - EXIT_SAPL10400_005
  • Worked on GATP Product Allocation report using BAPI to search for sales order quantities and stock transport order quantities.
  • Created BDC to Update the Control Recipe status using Call transaction CO57
  • Developed a custom program to update BMU audit allocation process in BW
  • Developed Barrel Inventory report for Liquidation model in WMS
  • Worked on MAB Packaging Report and created table Maintenance with default values for ZBATFGAUGE table
  • Enhanced Product catalog report by adding set class filter
  • Modified Perfect Order metrics – Shipment table with additional fields, indices and table maintenance
  • Modified SAP Script to read an exchange rate directly instead of calculating it, to eliminate rounding errors. Using a function call to get the rate.
  • Modified smart forms to change source of date and country fields to adjust to Canadian Customs Invoice
  • Worked on R/3 SD Sales Order Schedule Line User Exit - MV45AFZZ
  • Developed BDC to post GL Accounts for Necho Expense management Interface in FI/Co
  • Enhanced Reference material tracking report as ALV report with new matkl column.
  • Developed BDC to upload Bank details in HR and R/3
  • ChangestoSTBinreportZHR_REPORT_9701_SUMMARY. Worked on break-fix while printing more than one summary at a time, Prior Plan Amt doesn’t show on all of them.
  • Developed new BDC to copy 401k record on 169 and populate participation date in HR
  • Worked On HeadcountLogisticsReport :Changes to report to comply with new ethnic categories mandated by the OFCCP
  • Developed Change in Position Notification report for BF security department in HR and

RFC setup with APO-P, BW-P and ERP-P

Environment: SAP 4.6c, SD, MM, WMS, PP, FI/CO, SCM 5.0, HR, BDC, BAPI, BADI, RFC, SCRIPTS, SMARTFORMS

Confidential, Bridgewater, NJ Jan’05 – Feb’06
Responsibilities:

  • Technical specifications and requirement gathering from the functional and business people for different development objects
  • Developed XML output for Sample Guardian Interface and Clarity Management for Shipment, Product Lot and Returns.
  • Reports to validate GATP and BOP processing (Before and After)
  • Implemented OSS notes as per SAP GATP development team suggestion and other notes on APO and R/3.
  • Core Interface (between APO and SAP R/3) Analysis
  • Developed report to calculate and update the fixed cost of multi-level BOM Cost Roll Up.
  • Connecting SAP HR Payroll and FI/CO using ALE
  • Created HR Payroll Report of an employee for a determined month.
  • Created a BSP using the Model View Controller technique and Generated PDF output for shipment report from a BSP in order to send it to FI accounting.
  • Retrieved inputs from html page using HTMLB and MVC techniques.
  • Used CATT to Upload Master Data.
  • Converted the existing SAP Script forms into SMARTFORMS, developed a comprehensive routine for print procedure of the SMARTFORMS: AP Check Register, Billing Invoice, AR Account Statement, AR Due List, Credit Memo/Debt Memo.
  • Hands-on security upgrade using SU25 and Profile Generator (PFCG)
  • Wrote a Manager’s Summary Report where it will display quarterly actual verses target Inventory stock and output displayed by using the ALV.
  • Wrote a program to check the duplicate invoices in Transaction “MIRO”. The SAP FUNCTION \'MRM_DUPLICATE_INVOICE_CHECK\' is used to check the duplicate invoices
  • Used the ABAP runtime analysis tool (SE30), SQL Trace (ST05), System dump analysis (ST22) to analyze and improve runtime performance of the existing ABAP programs.
  • Built custom-defined user-exits, enhancements and variants which are used in the areas of product costing, general ledger accounting, profit-center accounting, and material sales determination, billing and shipping.
  • in file processing errors.
  • Created a LSMW project to Update Customer Master Records
  • Enhanced the business functionality by incorporating and configuring new BADI’s
  • Created invoice using BAPI as several occurrences of same Purchase Order item in one invoice by referring OSS Note 518338.
  • Created a RFC enabled function module, which generates the sales and shipping details of the day.
  • Designed, developed, tested and implemented Workflow for Vendor Master Creation.
  • Created a report to check the status of Inbound IDOC along with Sales Orders generated using ‘EDI_DATA_INCOMING’ against Customer Purchase Orders.

Environment: SAP ECC 5.0, SD, MM, PP, FI/CO, SCM 4.0, WAS 6.4, HR, CATT, BAPI, LSMW, EDI ANSI X12 EDIFACT, WORKFLOW

Confidential, Phoenix, Arizona Aug’03 – Dec’04
Responsibilities:

  • Develop technical specifications based on business process specifications through user interaction.
  • Stock Ageing Report, which shows the stock ageing after deducting the reserved items.
  • Generated ALV reports to display the outgoing payments and interests etc. in Accounts Payable
  • Developed an ALV report to change the price on POs and an interface to post the changed POs to OPIS.
  • Stock Transfer Reports, which shows Goods receipts, report for a plant from other plants.
  • Modified the Shipping and Delivery Routing Reports, Added new fields from LIKP table. The fields added were Bill of Lading, Group Number and the Group Description.
  • Involved in Unit, User Acceptance and Integration Testing
  • Developed an Automatic Transfer Order Creation process from the released work order by using call transaction BDC Technique.
  • Also involved in testing the data in QA box before entering into production system
  • Involved in Detailed Documentation
  • 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.
  • Used existing IDOC type to send the customer master data, vendor master data and material master data from the sender system to the receiver system.
  • Created a LSMW Project to changes the specific customer master records.
  • Developed the user-defined screens using SMARTFORMS, The areas covered were Billing, Sales Determination, Material Requirements Planning, Product Costing and General Ledgers.
  • Review and correction of sensitive authorizations (s_tabu_dis, s_rfc, etc.), including creation and assignment of custom authorization groups for sensitive tables
  • Worked on custom-defined User-exits, Enhancements and Variants.
  • Worked as team member responsible for Configuration & Development of EDI, ALE and IDOCS in SD and MM modules.
  • Configured the RFC destinations, Ports, Partner functions and Logical systems for ALE Transfer the transactional and Master data.
  • Developed ALE Inbound and Outbound scenario for Purchasing & Selling Scenario
  • Using ALE, updated data from development client to production client for secondary sales
  • Customized IDOC’s for Sales and Distribution module to generate order, delivery and billing using EDI subsystem, i.e., GENTRAN for certain distributors to generate invoice
  • Responsible for configuring the EDI process to enable the client to exchange documents with the business partners. It involved configuring the Inbound/Outbound process for EDI documents such as Purchase Orders, Sales Orders, and Request for Quotation.
  • Resolved production anomalies by analyzing error conditions, coordinating error corrections, and making appropriate program modifications for the upgrade.

Environment: SAP 4.6c, SD, MM, PP, FI/CO, HTML, Win Runner, EDI, Gentran, RFC, SAP SCRIPTS, SMARTFORMS

Confidential, VA Feb’03 – Jul’03
Responsibilities:

  • Development of reports a) Purchase Orders, Schedules and Goods Movements, b) Vendor Worksheet, c) Price Change Worksheet, and d) Moving Average Report.
  • Enhancement of Payment Exception Report: This report is developed to extract open item data based on the specified date on the selection-screen and the selected checkbox.
  • Developed an Enhancement of Payment Exception ALV Report for analysis of AP open item data via aging period wise.
  • Mapping routing rules in IDOC.
  • Developed a report to display open POs quantity, current available stock, goods receipt quantity, delivered quantity etc as per the data entered on selection-screen.
  • Wrote a custom Trial balance report to pull the dollar amounts for the G/L Accounts from the GLT0 table.
  • Developed Interface to validate and uploaded messages into SAP Ztables for further use.
  • Developed a report to provide a detailed review of data in the shipment system.
  • Developed a report for Ware house finished goods stock report.
  • Generated Smart Forms for Purchase order, Sales order, Dunning letters
  • A copy of a standard program RFKORD50 is created to print correspondence Invoice using a SMARTFORM form
  • Enhanced the Accounts Payable check printing process, and created a corporate logo and signature for use in AP check printing Layout Sets and developed Layout & program to print Invoices for Billing Documents
  • Extensively used flat files and BDC programs for automatic data migration from existing system of Customer (legacy system) to SAP R/3 system.
  • Analyzed the supplied data and wrote BDC programs to transfer material master, customer and inventory data. Modified the standard layout set for Purchase order to add LOGO.
  • Involved in Debugging using ABAP debugger, runtime Debugging Analysis, solving problems, including research, driving to Root Cause, and creating efficient solutions.

Environment: SAP 4.6c, SD, MM, PP, FI/CO

Education:Bachelor of Engineering

We'd love your feedback!