SUMMARY

• Techno Functional Consultant, with over 17 years of experience, 14 years in Oracle Applications, as a Systems Analyst and Programmer, primarily in the Oracle environment. Very strong in design, development and implementation of enterprise applications. Has extensive experience with:
• ORACLE Applications 10.5/10.6/10.7/11.0/11i 11.5.9 to 11.5.10.2 /R12 12.1.3
• Modules: AP, PA, CE, AR, GL, PO, OE/OM, INV, BOM, WIP, EDI e-Commerce Gateway , XML Gateway, Workflow, Oracle Business Event System BES , AME, Alerts, AOL, SYS ADM, Shipping, Planning MDS/MPS/MRP , ASCP, Supplier Scheduling, Procurement Contracts.
• ORACLE 11/10g/9i/8i/7.x / 6.0
• OAF/Jdeveloper
• Forms/Reports 10g,Developer 6i Forms 6i, Reports 6i , XML Gateway Message Designer, Discoverer, HTML DB and XML Publisher.
• Developer 2000 Oracle Forms 4.5, Oracle Reports 2.5/2.0
• SQL Forms 3.0/2.3, SQL Plus, SQL Navigator, SQL Report Writer, SQL Menu 5.0, SQL Loader, Toad, PL/SQL Developer
• Quest Stat
• C, Pro C, Pascal, C , PL/SQL
• Unix, MS Windows XP
• Major Assignments

As a Lead Applications techno functional Consultant for Confidential

• Oracle Applications rel. 11i 11.5.10.2 and R12 12.1.3 upgrade, for York and other manufacturing sites, primarily in Procure-to-Pay P2P AP, PO, I-Supplier, Procurement Contracts, Sourcing , ASN/ERS and Other Financial modules such as GL, AR, CE and PA, that involved basic requirements gathering, functional design, technical design, development, testing, CRP, deployment and documentation.
• 1. Oracle Applications rel. R12 12.1.3 , for BAE Headquarters and INC, primarily in Procure-to-Pay P2P AP, AME, PO, I-Procurement and Other Financial modules such as GL, AR and CE, that involved basic requirements gathering, functional design, technical design, development, testing, CRP, deployment and documentation.
• Involved in the following activities:
• Gathering requirements for the custom applications including workflows, extensions, interfaces and conversions.
• Preparing functional and technical design documents.
• Responsible for Requirements gathering, Application Map, Gap Solution, Design, Development, Testing, User Training and Documentation. Coordinating with the team on a daily basis and reporting the status.
• Module set-ups for the respective workflows, interfaces, extensions and conversions.
• Implementing conversions
• To convert all Vendors, Quotes, RFQs, open Reqs, Open Standard and Blanket Purchase Orders PO from the legacy Cullinet system.
• Involved in converting customers, AR invoices, items, on-hand quantities, Employees, GL journals, projects and contracts etc.
• Involved in Conversion reconciliation issues and various other reporting requirements.
• Implementing workflows
• PO , Requisition and Supplier Invoices Account Generator Workflow customization.
• PO and Requisition Approval Workflow customization.
• Auto Create Document Workflow customization.
• Supplier User Registration Workflow customization.
• Purchasing Documents reminder notification workflow customization.
• AP Payment Event Notifications WF.
• AP invoice WF for BAE HQ, using AME.
• RTV Debit Memo Notification WF customization.
• Etc.
• Implementing various interfaces:
• To send various files to ISIS as per BAE Global planning requirements. items, PO, vendors, planning data etc
• To send/receive data to/from Propricer proposal system.
• To send receiving data to Clear Orbit system.
• To send/receive PO-GL/Invoices data to/from Data2 Info system.
• To send the AP checks extract to Paybase.
• To send the Electronic Payments EFT file as per the bank requirements.
• Bank Statements to Cash management.
• Etc.
• Implementing Extensions
• ASN/ERS portal personalizations and extensions.
• Small Business Reporting process. Govt. 294/295 ISR/SSR reporting requirements
• ISP invoice attachment and two-way match hold process.
• Purchasing control automatic release process.
• Purchasing Contract Flowdown Process.
• AutoReschedule PO custom process.
• ERS conversion custom process.
• Customization of PO/Req/Procurement Contract/RFQ/Quote analysis print process.
• Auto sourcing documents set-up extracts used in the control process.
• Etc.
• Involving in integrating Oracle EBS with various other third party systems such as Peoplesoft Garnishments, Union Welfare , Feith image system , ProPricer, Clear Orbit TAKE etc.
• Involved in R12 Retrofit/testing/CRP for various RIEW objects, part of R12 upgrade project.
• Involved in integrating with Data Warehouse system.
• Performing system administration functions such as defining value sets, creating concurrent programs and executables and involved in registering applications, creating users, managing concurrent managers.
• Used Stat tool from Quest for migration.
• Testing the conversions and interfaces in Development, Test and UAT User Acceptance Testing instances prior to transfer into the production environment, assisting in Conference Room Pilots CRP with users and Source Code maintenance.
• Conducting performance tuning, interface monitoring, troubleshooting and performing Support Center activities, such as developing adhoc reports for the users immediate needs etc., upon system activation, for 11i and R12 HQ .

As a Senior Applications techno functional Consultant for Confidential

• , participated in the implementation of EAM, primarily in integrating Oracle Applications rel. 11i 11.5.9 with Maximo, including Procure-to-Pay P2P AP, PO, INV and GL modules, that involved basic requirements gathering, functional design, technical design, development, testing, CRP, deployment and documentation.
• Involved in the following activities:
• Mapping business needs to application features.
• Gathering requirements for the custom applications including interfaces and conversions.
• Preparing solution, functional and technical design documents.
• Prepared Project Use Cases as per Sarbanes-Oxley SOX compliancy requirements.
• Responsible for Requirements gathering, Application Map, Gap Solution, Design, Development, Testing, User Training and Documentation.
• Module set-ups for the respective interfaces and conversions.
• Implementing interfaces, using BEA web logics as the middleware,
• To interface and load the Standard Purchase Orders from EAM-MAXIMO using Oracle 11i Standard Purchasing Interface.
• To interface and load the PO Receipts from EAM-MAXIMO using Oracle 11i Standard Receiving Interface.
• Involved in implementing interfaces,
• To interface and load the Expense AP invoices from EAM using Oracle 11i Standard Payables Open Interface.
• To interface and load the GL journals from EAM using Oracle 11i Journal Import.
• To send the EAM-MAXIMO related POs and PO Receipts from Oracle 11i to EAM.
• To send Vendors from Oracle 11i to EAM-MAXIMO.
• To send Items and the related ASL data from Oracle 11i to EAM-MAXIMO.
• To send the GL account segment values from Oracle 11i to EAM.
• Involved in Implementing conversions,
• To convert all the required vendors from Oracle 11i to EAM.
• To convert all the items required for EAM from Oracle 11i.
• To convert all the required accounts from Oracle 11i GL.
• Performing system administration functions such as defining value sets, creating concurrent programs and executables and involved in registering applications, creating users, managing concurrent managers.
• Testing the conversions and interfaces in Development, SIT and UAT User Acceptance Testing instances prior to transfer into the production environment, assisting in Conference Room Pilots CRP with users and Source Code maintenance.
• Conducting performance tuning, interface monitoring and performing Support Center activities, such as developing adhoc reports for the users immediate needs etc., upon system activation.

As an Applications techno functional Consultant for Confidential

• Involved in the following activities:
• Mapping business needs to application features.
• Gathering requirements for the custom applications including extensions, interfaces and conversions.
• Preparing functional MD50 , technical design MD70 and System Audit Check List Client Custom Standard documents.
• Responsible for Requirements gathering, Application Map, Design, Development, Testing, User Training and Documentation.
• Involving in integrating Oracle Applications with Maximo, Primavera and other Government legacy systems i.e. CEFMS RMS.
• Implementing interface to bring the vendor address and contact details from CEFMS and RMS into Oracle, using vendor APIs.
• Implementing Project Workbook, a tool used for project analysis that gives actual and budgeted details for the project. It is a web based query tool designed and developed in HTML DB, pulling real-time data from main applications Oracle, Maximo and Primavera,
• Involving in interfacing AP invoices and Project Contracts from legacy Federal Government systems CEFMS and RMS.
• Involving in implementing various custom Project Summary analysis reports, using tools Discoverer and HTML DB.
• Performing system administration functions such as defining value sets, creating concurrent programs and executables and involved in registering applications, creating users, managing concurrent managers.
• Conducting performance tuning, interface monitoring and performing Support Center activities, such as developing adhoc reports for the users immediate needs etc., upon system activation.

As a Lead Applications techno functional Consultant for Confidential

• Involved in the following activities:
• Mapping business needs to application features.
• Gathering requirements for the custom applications including workflows, extensions, interfaces and conversions.
• Preparing solution, functional and technical design documents.
• Prepared Project Use Cases as per Sarbanes-Oxley SOX compliancy requirements.
• Responsible for Requirements gathering, Application Map, Gap Solution, Design, Development, Testing, User Training and Documentation. Coordinating with the team on a daily basis and reporting the status.
• Setting-up, implementing XML Gateway module, integrating with Oracle Business Event System BES , Tibco and BEA Web logic WLI .
• Requirements Gathering, Functional/Technical Design and mapping of EDI/XML transactions AP Invoices EDI 810, PO 850 in and out of Oracle.
• Design, Development Testing of Message map customizations using Message Designer.
• Design, Development Testing of Subscriptions for the business events as per BES.
• Module set-ups for the respective workflows, interfaces, extensions and conversions.
• Implementing conversions
• To convert all open Standard and Blanket Purchase Orders PO from the legacy PU purchasing system.
• To convert all the items required for Store Development.
• Implementing workflows
• Non-PO AP Invoice Routing Approval Workflow as per Albertsons requirements.
• AP-PO Tolerance Workflow for PO backed AP invoices as per Albertsons matching tolerance requirements, using AME approval management rules.
• Implementing the PO Requisition Approval Workflow Customization.
• Implementing interfaces, using BEA web logics as the middleware,
• To send the AP checks extract Positive Pay File to OSCK Albertsons Outstanding Check System , which in turn will be sent to the bank.
• To load the cleared AP check file back from the bank/OSCK for reconciliation.
• To send the Electronic Payments EFT as per EDI/Gentran requirements.
• To send AP Payment file for 1099 reporting as part of CA EDD requirements.
• Implementing Extensions
• Supplier Credit Netting in AP, as per custom credit netting rules.
• Duplicate Invoices Process in AP, as per custom duplicate invoices check process.
• Customization of Account LOV in I-Procurement.
• Key Member Maintenance, Task Maintenance, Asset Copy to Project task in Projects PA .
• Involving in integrating Oracle AP with various other source legacy AP systems such as Garnishments, Union Welfare, Webex etc.
• Involving in P-Card Interface Analysis, AP Invoice Expense Accrual extension, PO report customization, PO workflow customization, Project Budget Conversion, Electronic Invoice Solution I-supplier , Conversion reconciliation issues and various other reporting requirements.
• Analysis of using the standard EDI transactions i.e. Electronic Funds Transfer EFT and other standard EDI transactions with e-commerce gateway.
• Performing system administration functions such as defining value sets, creating concurrent programs and executables and involved in registering applications, creating users, managing concurrent managers.
• Testing the conversions and interfaces in Development, SIT and UAT User Acceptance Testing instances prior to transfer into the production environment, assisting in Conference Room Pilots CRP with users and Source Code maintenance.
• Conducting performance tuning, interface monitoring and performing Support Center activities, such as developing adhoc reports for the users immediate needs etc., upon system activation.

As a Lead Applications Consultant for Confidential

• Mapping business needs to application features.
• Gathering requirements for the custom applications, extensions, interfaces and conversions.
• Standardizing the documents as per GE Tollgate process.
• Preparing solution, functional and technical design documents for the conversions, extensions and interfaces.
• Managing technical developers and reporting on daily basis.
• Responsible for Requirements gathering, Design, Development, Testing, User Training and Documentation.
• Setting-up of Projects module, which also involved set-up of Norway and Netherlands units of APS in addition to the US unit. Also included in the set-up of other modules such as AP, AR, CE, OM and PJM.
• Designing and Developing open AR, Open Sales Order, Inventory Inventory Product Line Purchasing Commodity Item Category Codes, On-Hand quantities , Supplier Part Numbers, Manufacturer Part numbers, PO, Supplier Conversions from Visibility GE Global legacy systems.
• Designing OM-shipping reports as per the client requirements.
• Customization of OM standard workflow.
• Designing and developing an interface to send the Order shipping information to legacy.
• Designing and Developing Labor Billing Extension to calculate the ST and OT hours based on the expenditure type, which also involved applying specialty rates if the project is classified as hazardous or emergency or both.
• Designing and Developing Custom Voucher Billing Extension to bill the customer as per the agreement for voucher provider projects. It involves billing customer 25 of the voucher amount as down payment and the remaining balance should be billed as installments for the next 12 months.
• Designing the integrations between 11i Projects and ARTEMIS, which involves bringing the project definitions through AMG , labor non-labor hours from ARTEMIS to11i through Transaction Import and also the outbound from 11i.
• Implementing a conversion to convert all the unmatched open AP invoices from the Legacy system Visibility.
• Implementing a conversion to convert all the matched open AP invoices from the Legacy system GE Global.
• Implementing interfaces to bring/send the IBS GE Internal Billing System AP/AR invoices into/from 11i. It also includes design of a custom form using Forms 6i.
• Implementing an interface to bring the project-related Outbound Freight expenses into 11i Projects, as charges, from GE Freight Payment Center i.e. CBSI .
• Implementing an interface to bring the project-related internal T L expenses into 11i Projects, as charges, from GE Travel Expense Processing Center i.e. TEPC .
• Implementing an interface to bring the project-related P-Card GE Purchase Card or Procurement Card purchase expenses into 11i Projects, as charges, from GE P-Card Processing Center i.e. PARIS .
• The interfaces are designed in compatible with webMethods publish and subscribe approach.
• Analysis of using the standard EDI transactions i.e. Electronic Funds Transfer EFT and other standard EDI transactions with e-commerce gateway.
• Implementing an interface to bring the Banker's Trust bank statements from the bank in BAI2 format and load into 11i Cash Management for the possible Reconciliation with sub-ledger transactions.
• Implementing an interface to bring the Fleet Bank statements from the bank and load into 11i Cash Management for the possible Reconciliation with sub-ledger transactions.
• Implementing an interface to bring the Bank Of America statements from the bank and load into 11i Cash Management for the possible Reconciliation with sub-ledger transactions.
• Involving in Conversions such as Inventory Item, Stock Locators , WIP, FA, Customer Conversions and other Workflow customizations.
• Involving in the AP check extract interface upgrade to 11i to Poorman-Douglas Fleet Bank to print checks and send them to the respective vendors.
• Involving in the module set-ups for the respective interfaces, extensions and conversions.
• Performing system administration functions such as defining value sets, creating concurrent programs and executables and involved in registering applications, creating users, managing concurrent managers
• Testing the conversions and interfaces in Development, CRP, SIT and UAT User Acceptance Testing instances prior to transfer into the production environment, assisting in Conference Room Pilots CRP with users and Source Code maintenance
• Conducting performance tuning, interface monitoring and performing Support Center activities, such as developing adhoc reports for the users immediate needs etc., upon system activation.

As a Lead Applications Consultant for Confidential

• Mapping business needs to application features
• Gathering requirements for custom applications
• Preparing solution, design and migration documents
• Involving in Implementing and integrating Oracle Applications with other custom applications such as the ABAMS Automotive Business Assembly Management System and I2.
• Involved in Y2K testing of the overall applications implementation. Testing after applying set of the standard Y2K patches supplied by Oracle.
• Assisting in the set-up and launching of various processes available in oracle modules such as Planning MDS/MPS/MRP , Shipping etc.
• Designing and developing an interface for the engine serial numbers to provide usage and information retrieval flexibility Order Entry allowing accurate tracking of inventory.
• Delivery and Departure Order Shipping Planning.
• Designing and Developing Custom OE reports including shipping.
• Designing and developing an interface to generate a flat file for printing the AIAG Automotive Industries Actions Group Labels, used while shipping the engine.
• Designing a form to setup Customer-AIAG Label name X-reference
• Designing and Developing an interface to compare the Legacy BOM Structure with the corresponding Oracle BOM structure to resolve data discrepancies
• Involving in Implementing EDI Transactions, Outbound Planning schedule SPSO-830-DELFOR , Outbound Shipping Schedule SSSO-862-DELJIT Inbound ASN ASNI-856-DESADV , as part of the development of electronic-pull signal JIT-Kanban module for container management system. Also involving in implementations of other EDI transactions such as Payables Invoice Inbound INI-810-INVOIC etc.
• Designing and Developing custom DELJIT Issues Returns EDI outbound extract programs for CAMBAR trading partner supplier of Cummins JEP.
• Designing and Developing reports and alerts for Shipping, Inventory and various other modules based on user needs
• Performing system administration functions such as defining value sets, creating concurrent programs and executables and involved in registering applications, creating users, managing concurrent managers
• Conducting performance tuning and interface monitoring upon system activation

As an Oracle Applications Consultant for Confidential

• . Involved in the following activities:
• Designing and developing an interface that loads the Axiohm printer serial number in the printer's memory of the WIP module
• Designing and developing an interface to download the data needed for the legacy system to generate the aged trial balance report
• Designing and developing the commit ship date report
• Designing and implementing the customer x-reference, customizing the standard invoice print report to print the customer cross-reference
• Upgrading the system from Oracle Applications version 10.6 to 10.7

As an Oracle Applications Consultant for Confidential

• Conducting requirements analysis, designing, developing, testing and documenting the system
• Setting up the order cycles, order types, standard value rule sets for the Tupperware Express as well as Traditional orders
• Designing and developing AR GL interfaces for a custom order cycle
• Implementing manifests for carriers UPS, CTC, RPS and USPS for the Shipping function
• Designing and Developing custom EDI module to communicate electronically with the trading partners customers, suppliers, shipping carriers UPS, CTC, RPS USPS to send the manifests .
• Designing and developing a custom document interface for use with an existing document set
• Developing a form that allows the user to create a bill of lading for different trailers carriers
• Customizing various standard delivered reports such as pick slip, pack slip, consolidated pick slip, sales journal reports, Inventory reports
• Performing system administration functions such as creating users and responsibilities, managing concurrent manager, creating concurrent programs and registering applications

As a Software Engineer Confidential

• Identifying the required areas of customization
• Making Client presentations based on discussion of needs
• Setting up Order Entry functions such as defining order cycles, order types, standard value rule sets, price lists, and discounts
• Developing an Interface module to upload orders from major customers and regional sales offices into order interface tables
• Setting up Oracle Purchasing for business needs including defining jobs, position hierarchies, document controls and position control, assigning employees to a job and position, defining buyers, standard notes, and freight carriers
• Developing a GL Interface module to periodically import data from an external Payroll System
• Loading customer data such as profiles, banks, addresses, contacts, phones, payment methods and descriptive field data into the customer interface
• Implementing descriptive flex fields in a Customer Entry Form module to upload data from the existing system
• Performing system administration tasks such as registering applications and Oracle IDs and defining logical databases and data groups
• As a Systems Analyst participated in the design and development of a Surveillance System that was an on-line inquiry system giving the exchange user the capability to monitor possible trading violations by its members. Involved in the following activities:
• Designing and developing a batch program that loads data from flat files into Oracle tables
• Designing and developing a screens-and-menus-front-end system for surveillance purposes
• As a Programmer/Analyst Confidential
• Developing and maintaining the Billing module that generates the collection notices for project, finance loans
• Designing, developing and implementing the Adjustments sub-module that allows users to change matured and unmatured amounts making the necessary accounting entry adjustments
• Designing and developing budget related reports such as profit and loss account report, commitments report
• As a Programmer, participated in the design, development, and implementation of a Bank Automation System - an Integrated Solution BASIS . This project involved the design, development, and implementation of Computer Operations Management, Customer Management, and Account master modules of the banking system.