SUMMARY:

• 9 years of experience in the Oracle EBS implementing ERP systems primarily using PL/SQL, Workflow Builder, Developer 2000/6i/9i/10g, SQL* Loader, Discoverer, XML publisher and Oracle Applications.
• Successfully completed 4 Full life cycles projects with Oracle Applications 11i (11.5.10, 11.5.8, 11.5.6 and 11.5.4) and recent experience in R12.
• Strong experience in system study, business requirement analysis and business process analysis.
• Extensive Experience in Account Payables (AP), Account Receivables (AR), General Ledger (GL), Fixed Assets (FA), Cash Management (CM), E Business Tax (eBTax), Project Accounting (PA), Advanced Global Intercompany System (AGIS), Inventory (INV), Bill of Materials (BOM), Work in Process (WIP), Purchasing (PO), Order Management (OM), Advanced Pricing, Service Contract, Record to Report and AOL modules.
• Proficient in Procure to Pay (P2P), Order to Cash (O2C) cycles.
• Good understanding of data flow in the different modules of Oracle Applications.
• Good understanding and knowledge of the Apps data model, which helps in all aspects of development cycle such as building Custom Reports, data validation, data import etc.
• Involve in Implementation, customization of several Oracle Financial Applications, Data mapping of Oracle functionality with Business requirements, historical conversions, interfaces and customizations.
• Expertise in preparing AIM (Application Implementation Methodology) Documents and User Manuals Functional Specification Document (MD050),Technical Design Document (MD070/CV060) and Conversion Mapping Document (CV040).
• Worked extensively on full life cycle implementations of Order to Cash (O2C) and Procure to Pay (P2P) and Fixed Asset to GL and Supply chain business flows.
• Integration of Modules and Business rules along with Setups, Standard and Custom Interfaces, custom reports and other customizations in Oracle Applications have been successfully implemented using strong technical and functional understanding of modules.
• Technically proficient in RICEF (Reports, Interfaces, Conversions, Extensions and Forms) methodologies including Implementation, Interfacing, Conversion and Data Migration, experience in up gradation to Oracle Apps 11i.
• Hand on experience in P2PCycle in end to end as per technical.
• Production Support on Oracle modules covering: Procure to Pay (P2P), Oracle General Ledger (GL), Oracle Advanced Collections, and System Administrator.
• Assist in implementation of Oracle Financials (P2P, GL and Advanced Collections) across the organization.
• Experience in generating Standard, Discoverer6i/9i and XML publisher reports.
• Expert inOracleApplication Framework (OAF) applications, customization ofOAFpages, extension and creation of newOAFpages in JDeveloper 9i and 10g environment.
• Expert in requirement gathering, design and development of custom applications inOracle Applications Framework (OAF) environment.
• Responsible for Managing and coordinating test sessions like Conference Room Pilots (CRP) and User Acceptance Testing (UAT).
• Have full life cycle implementation experience and enhancement experience on Procure to Pay (P2P) and Order to Cash (O2C) business processes with good analytical skills necessary to satisfy development, testing, documentation, and change management requirements.
• Work on helping teams adopt Acceptance Test Driven Development (Requirements By Example or Behavior Driven Development).
• Experience with test automation tools like QTP, JIRA, Load Runner and Quality Center
• Work on coaching others including task based mentoring and one on one Coaching, especially entry level employees.
• Involve in Unit Testing and System Testing.
• Work closely with Developers team for different issues
• Test new enhancements for a Business Process
• Involve End - to-End testing for business process using all application tiers.
• Involve in troubleshooting issues on Auto Import Program for all the import process including Invoice, Requisition, Receipts, Asset, Inventory, etc.
• Experience in Forms9i/6i/4.5i creation, customization and personalization and registering them as concurrent programs in oracle applications by using Application Object Library (AOL).
• Well versed with client server environment & tools like SQL*LOADER, TOAD and WORKFLOW BUILDER.
• Identify product gaps, coordinated with Development Team by creating Service Requests (SR) and obtained one-off fixes. Managed and monitored SRs for several P1 Issues. Provided on site solutions and resolved showstopper issues.
• Experience with ticketing systems (Jira) and agile development board.
• Strong communication skills with ability to manage expectations of Business and IT users. Possess good organizational, analytical and problem solving skill.

TECHNICAL SKILLS:

ERP Software: Oracle Applications R12.2.5, 11.5.10,11.5.9,11.0.5 Order Management, Purchasing, Inventory, Bill of materials, Work in Process, Advanced Pricing, Shipping, Purchasing, Cash Management, General Ledger, Accounts Payables, Accounts Receivables, Fixed Assets, General Ledger, HRMS, Payroll, INFOR.

EBusiness suit modules: GL, AP, AR, AGIS, eBTax, SCM,PO WSH, INV, OM, Record to Report HRMS, SYSADMIN

Databases: Oracle 11g/10g/9i/8i,SQL Server, MS Access 2003.

Languages / others: C/C++, Java, PL/SQL, SQL / Unix Shell Scripting

Oracle Tools: XML/BI Publisher, Oracle Forms / Reports 6i/10g, SQL Loader, SQL Plus, SQL Developer, Toad, Oracle Workflow Builder, Noetix views, APEX, JDeveloper, Cloud IO.

PROFESSIONAL EXPERIENCE:

Confidential, NC

Oracle EBS Financial Techno Functional Consultant

Responsibilities:

• Developed and customized Financial Modules (AP, CM, GL, AR, PO, OM), Interacted with end users to gather requirements and Draft specifications for development Phase.
• Technically proficient in Order-to-Cash (O2C) and Procure-to-Pay (P2P).
• Strong Domain knowledge in various business flows including Financial Modules like Account Receivables, Account Payables, and Order to Cash (O2C) and Procure to Pay (P2P) cycles.
• Developed Extensions to custom business flow from Order management, install base to service contractsfor raising credit memos and invoices in AR.
• Implemented Advanced Global Intercompany System (AGIS) for all the 46 countries to have Intercompany Transactions with any of the Entities.
• ConfigureOracleR12 FA, AR, AP AND EBTax to include integration withVertexand the TCA setups.
• Designed, developed and documented an inbound interface for AP Invoices from windows-based applications.
• Assisted client in design customization of the process to interface invoices, from legacy systems, to Oracle AP.
• Worked on Auto Lockbox Interface Account Receivable module for automatically processing receipts that are sent directly to the bank instead of manually feeding them in Oracle Receivables.
• Designed documented and developed interface Cash Management module for uploading Bank statements.
• Enhancing the COPS (Change of Project Status) Process to integrate with Iprocurement in order to change the project status to over budget when the requisition commitment amount is greater than budget amount.
• Personalized page to enable submit button on the train flow of iProcurement page
• Designed and Developed Custom Reports,(Customer, Vendor, Sales Order, Purchase Order, Aging Reports) as per the user requirement using Oracle Apex (Application Express) 3.2
• Customized the workflow for Fixed AssetFAAccount Generator Process "TRU Generate Default Accounts" with new custom settings for UK instance.
• Worked on the issue where the drill-down from the GLto the Fixed AssetFASub-Ledger was not available. (Found bug in the Oracle Standard system).
• Worked on end to end testing for P2P & O2C Processes for 12.1.3 upgrade (from 12.2.2) and resolved few upgrade issues.
• Worked on the development of Interfaces, Data Conversions,developing new Forms, Reports, Customizing Oracle Reports in Order to Cash Cycle touching various modules such asGL, AR, FA, CM, OM.
• Handling daily tickets related to various user problems in FA, AP, AR, GL and CE modules.
• EB-TAX Rate Analysis: Provided a solution to the Tax team to understand and comprehend the tax rates provided byVERTEXand uploaded every month. This solution helps the team to understand the increased, decreased tax rates along with any Jurisdiction and name changes
• Participated in all the phases of the Parthenon interface Process development involving analysis, design, development,testingand deployment of the project.
• Actively participated in planning project backlogs, 2-week sprints and daily stand up meetings to analyze the time frame and report the status of the project.
• Involved in making the detailed Project Test Plan regarding the scope and focus of the testing (TE 10), Test Strategies
• Written standard Integration test scripts forOracleFinancials, Order to Cash and Procure to Pay Modules.
• Act as a Test liaison between business users and technical team.
• Customizations, Personalization's and Extensions on Contracts Workbench Administrator web page usingOracleApplication Framework as per client requirements.
• Created custom page using OA Framework to view AP invoice History.
• Created Test Scripts (TE040's) for UAT sessions.
• Prepared project deliverable such as requirements gathering documents, future business mapping documents, SanitytestingResults, Data collection Templates, User acceptancetestingand obtained business user signs off.
• Involved in design and developing all the packages, procedures, trigger and custom DB objects for the project.
• Created a newOAFscreen for production tracking of Batches, Resources inOAFProcess Manufacturing (OPM) module.
• Extension of Sub-Inventory transferOAFscreen to issue Billet Items (Finished goods) in BOM (Bill of Materials).
• Used Oracle Apex (Application Express) 3.2 to query the data and developed packages, procedures, and functions
• Designed, Documented and Developed inbound interface between 3rd party payroll system Ceridian and oracle General ledger for importing the journal entries, using Shell script, SQL*Loader, PL/SQL package and populated the data into the GL interface and developed a PL/SQL API to run journal import concurrent program and send an email notification to a group of people.
• Developed AR invoices batch report using XML/BI Publisher. Created Data Definition Templates, rtf templates and split the xml file using bursting feature in XML Publisher reports.
• Customized Account Payables (AP) Reconciliation Reports like Accounts Payable Trial Balance report, Posted Invoice Register, Posted Payment Register, Unaccounted Transactions report and consolidation journal report in General Ledger (GL)
• Developed Custom Reports for Billing History by Client, Invoices by Client Report and Projects NDR Report using Discoverer 4i.
• Designed and developed new Form using TEMPLATE.fmb for Purchase Returns irrespective of Purchase Order Number.
• Did forms personalization to make view only forms.
• Customized the Accounts Payable (AP) Vendor Entry Form as per business requirements.
• I have been the SME for supporting the Oracle EBS suite modules: GL, AR, AGIS, CM, eBTax, AP support for month-end close and on-going support lead
• Module focus: GL, AP, AR, CM, TCA, Inventory, EBTax/Vertexintegration, IExpense, SLA, FAH, and AGIS.
• Was working for Receivables, iReceivables, Cash Management,eBTax, Subledger Accounting, Advance Collections and Bill Presentment Architecture as part of product support team.
• Created new users, new menus, new responsibilities, registered concurrent programs and request sets.
• Did daily support to financial department to fix everyday tickets, month end and quarter end closing. Created service requests (SR/TAR) with metalink.
• Oracle EBS suite support, OTC,AGIS, EBTax, P2P,RtoR Lead SME for system and end-user errors and issue that arise from day to day activities.
• GL financial model support lead, support and month-end close SME.
• Used FNDLOAD to download and upload AOL data (request groups, menus, forms, functions; responsibilities; flex field value sets; users) from one instance to another instance.

Confidential, CA

Oracle EBS Financial Techno Functional Consultant

Responsibilities:

• Designed customizations, interface/conversion mapping, pre-production testing, and related documentation.
• Developed and customized Financial Modules (GL, AR, AP, PO), Interacted with end users to gather requirements and Draft specifications for development Phase.
• Written an API for Converting the Invoice Payments (AP) and was able to convert all the Historical Invoice Payment History into Production.
• Strong Domain knowledge in various business flows including Financial Modules like Account Receivables, Account Payables, Order to Cash (O2C) and Procure to Pay (P2P) cycles
• Implementing, Customization ofOracleE Business Suit (EBS). Strong in SCM (INV, PO, OM) and
• Financials (AP, AR, GL), Procure to Pay (P2P), Order to Cash (O2C), internal sales order, drop shipment, back to back cycle.
• Designed service contract API's program and data mapping from Siebel to Oracle.
• Designed the Install Base, service contract Concurrent Program, Executable, Request set, Values Sets and Report (RDF) file, shell script and PLSQL programs for applications.
• EBTax: We performed system configuration for multiple tax regimes
• Involved EBTax performed Self-Assessment setup for different countries - process included requirement analysis, design and implementation
• Performed upgrade activities related to EB-Tax andVertexintegration.
• Have extensively worked on implementations of EB-Tax withVertex/Sabrix Integrations.
• Responsible for running Receivables open interface, imported data into RA interface tables and used the Auto Invoice to import the customer invoices.
• Developed PL/SQL Procedures for Customer interface using TCA in Accounts Receivables according to Client Requirements.
• Provided Production Support to resolve issues for P2P & O2C modules
• Extensively worked on EB-Tax integrations withVertexand Sabrix/ Confidential OIDT.
• Invoked standard API’s within custom packages for creating and updating Customer, Sites and Contacts.
• Strong Oracle RICE development experience in all AP, AR, GL, PO and OM Modules.
• Implementation of oracle Applications (PO, AP, INV, iProcurement, iExpenses and AR)
• Oracle On-Demand; Modules: PO, IProcurement, OM, INV, Discrete Manufacturing and Quality and numerous 3rd Parties’ Software.
• Responsible for converting the entire Historical Purchase Orders (PO) using Import Standard Purchase Orders into Production.
• Responsible for converting all the Historical Purchase Order Receipts using Receiving Transactions Processor into Production.
• Designed, developed and documented an inbound interface for AP Invoices from windows-based applications.
• Did Consolidation setups for Consolidation set, Consolidation, segment rules in General Ledger Module throughout global companies
• Responsible for providing production support for Account Receivables (AR) and Account payables (AP).
• Designed, documented and developed Bank Reconciliation interface to Oracle Cash management Interface.
• Responsible for running the Open Interface to import data from OM interface tables into the base tables.
• Involved in Implementation of iProcurement module and Customization of interfaces in this Module.
• Developed an interface program to load data from custom tables to interface tables and then created journals into Oracle General Ledger as per business requirements.
• Creating staging tables required for loading the legacy data and loading the staging tables with the legacy data using SQL Loader.
• Developed Item Master Conversion program using Item Interface inOracleInventory (INV).
• Worked on Open Item Interface to convert Purchased Item Information from Custom Purchasing System toOracleInventory (INV) module.
• Developed Invoice Custom Form in AP usingOAF.
• Modified the HRMS (Hire, Re-Hire, and CWK Hire) Self Service Pages to include the Costing information on the Review Page usingOAF.
• Developed a PL/SQL program, which reconciles the Reply Bank file data (Lockbox) and calls Receipt API to reverse the receipts for which credit card status is declined.
• Prepared project deliverable such as requirements gathering documents, future business mapping documents, CRP Scripts, SanitytestingResults, Data collection Templates, User acceptancetesting, obtained business user sign off
• Facilitate CRP (Conference Room Pilots), SIT (System IntegrationTesting), and UAT (User Acceptance Testing).
• Worked on different customization of pricing and quoting modules during implementation
• Customized forms using CUSTOM.PLL file to meet the specific requirements.
• Utilized Forms Personalization utility to call a PLSQL procedure and updated the AR Descriptive flex fields with Depot Repair flex field data.
• Experience in System Administration activities like Managing Concurrent Programs and Responsibilities.
• Created a Report for End Users to get the vendor and its site information.
• Customized Transaction register, Adjustment report, Receipts Register, aging 7 buckets or 4 buckets Reports in Account Receivables (AR).
• Customized Account Payables (AP) Reconciliation Reports like Accounts Payable Trial Balance report, Posted Invoice Register, Posted Payment Register, Unaccounted Transactions report and consolidation journal report in General Ledger (GL).
• Designed and developed complex Discoverer reports by communicating and interpreting end-user business requirements.
• Registered customized Oracle reports and XML Publisher reports using System Administrator and Application Developer.
• Created custom templates with Data Definitions for XML Publisher and Developed reports using reports 9i and registered as XML reports in applications.
• Uploaded and attached the templates to the custom report in XML Publisher and processed the reports by customizing XML Gateway for the purpose of EDI.
• Defined rules in Oracle Approvals Management (AME) to send Email notifications.
• Customized PO approval workflows and configured approvals using Oracle Approvals Management.
• Customized the Procurement CARD Employee Verification and Manager Approval flow using Oracle Workflow.
• Customized the existing workflow by adding notifications at the time of Purchase Order approval and also involved in customizing Requisition package in I-Procurement modules as client requirements.
• Customization of AR Invoice Approval workflow.
• Worked with the client SME’s in developing solution designs that ensured business requirements were met.
• Oracle EBS suite SME for support for system, end-user issues and month-end system support
• Handling daily tickets related to various user problems in FA, AP, AR, GL, CE,and eBTax modules.

Environment: UNIX, Oracle Applications (R12) - AP, AR, Purchasing, GL, FA, Cash Management, OM, INV, TCA, Procurement (iProcurement, iSupplier Portal, Purchasing, Payables), Work Flow, Oracle Approvals Management (AME), OA Framework, Oracle 10g, Forms 9i, Reports 9i, Discoverer 4.1/9.0.2, XML publisher, SQL*Loader, PL/SQL developer, UNIX, Java, JDK, J2EE, TOAD.

Confidential, CA

Oracle Techno Functional Consultant

Responsibilities:

• Designed and developed an interface custom package to create and Update vendor/vendor sites implementation according to BR, which is not provided by standard API’s.
• Communication from legacy to Oracle applications were established through IBM MQ series using data contracts, which were signed off for both parties integrating the applications.
• Designed and developed the Reconciliation process for GL module.
• Performed Standard Functionality testing in AR, AP, GL, FA, Cash Management, i-Expense, E-Business Tax and Sub Ledger Accounting
• Was involved in Standard Functionality testing in Phase I and Phase II for 3 instances.
• Tested Multi-Org Setups as a result of the new Parts Operating Unit that is being introduced as part of the upgrade to Release 12.
• Involved in Unit Testing and System Testing.
• Documented and communicated test results to the Test Management and Business Management Team
• Provided hands on to business user community for Post- Production support issues & daily and month-end closing of accounting periods for GL.
• Written an API for Converting the Invoice Payments (AP) and was able to convert all the Historical Invoice Payment History into Production.
• Written an Interface for Account Payables (AP) Invoice Upload, which creates invoices from a CSV file.
• Strong Oracle RICE development experience in all AP, AR, GL, PO, INV and OM Modules.
• Did Consolidations setups for mapping set, mapping, segment rules in General Ledger throughout global companies.
• Setting up system for foreign currency translation and re-evaluation performing financial consolidation of multiple currency set of books.
• Invoked standard API’s within custom packages for creating and updating Customer, Sites and Contacts.
• Developed PL/SQL Procedures for Customer interface in Accounts Receivables (AR).
• Analyzed, developed, configured and tested the UHG customer model into the Oracle 11i TCA (Trading Community Architecture) framework.
• Responsible for creating an interface for Purchase Order upload, which creates PO from a CSV file.
• Written PL/SQL packages with cursors, functions and procedures for inserting the data into vendors, invoices and purchase orders interface tables from various staging tables while validating the data.
• Prepared Technical Specification (MD70) documents.
• Responsible for running Receivables open interface, imported data into RA interface tables and used the standard API Auto Invoice to import the customer invoices.
• Analysed requirements of the client for various legacy applications that needed migration and integration with Oracle Applications.
• Prepared high-level and low-level designs for bridging and migrating data to AP, AR and PA modules.
• Created shell scripts to load data into staging tables of expenditures, tasks, events and projects of project accounting using SQL*Loader direct path.
• Worked on Inbound and Outbound programs for passing the Picked lines to the 3rd party system and shipping the records sent from 3rd party system back to Oracle.
• Created test scripts for every level of testing from unit testing stage to integration testing.
• Oracle EBS suite SME for support for system, end-user issues and month-end system support
• Was actively involved in designing and developing new Project Costing Report in PA reports using Reports 6i to suit business requirement.
• Customized Account Payables (AP) Accounting and Reconciliation reports like Payables Accounting Entries Report, Accounts Payable Trial Balance Report, Payables Account Analysis Report, Payables Accounting Entries Report, Payables Accounting Process Report, Period Close Exceptions Report, Posted Invoice Register, Posted Payment Register, and Unaccounted Transactions Report.
• Did Generation of Consolidation, Translation and Revaluation reports for multi-set of books and multi-currency sites.
• Developed parameterized reports using Discoverer Plus in Order Management.
• Used XML publisher to print, email and fax the reports.
• Designed XML Templates, XML publisher reports. These are configured to generate output in PDF formats.
• Responsible for customizing Workflow for orders by adding custom Holds for certain customers and added payment terms for the customers.
• Customized AP Invoice, Approval workflow and added new workflow function to validate 2/3way match and to get requester information from requisition into Invoice. very knowledgeable in the following areas: Order-to-cash & Supply chain, Oracle Order Management including pricing, Oracle Inventory, Purchasing, and Oracle Costing Modules. Extremely familiar with all aspects related to the functional aspects and data structures of these applications
• Performed system administration functions such as creation of users, Responsibilities and Menus and Functions.
• Involved in Unit testing and wrote test cases for QA, also involved in UAT (User Acceptance Test).
• Involved in bug fixing reported from QA and End users.
• Involved in Postproduction Support, work involved supporting Apps, support in .

Environment: Oracle Applications - AP, AR, GL, OM, PO, INV, Service Contracts, Work Flow, Oracle 10g, Forms 9i/6i, Reports 9i/6i, SQL*Loader, XML Publisher, BPEL, PL/SQL developer, TOAD, Java.

Confidential, NY

Oracle Techno Functional Consultant

Responsibilities:

• Implemented Oracle Financials 11i Account Payables and Project accounting for a large distribution network of a major apparel company.
• Designed customizations, interface/conversion mapping, pre-production testing, and related documentation.
• Worked on Oracle API bug in Supplier Sites Open Interface Import, causing all the legacy data to be rejected because of duplicate Vendor Site Code.
• Responsible for converting the entire Historical Purchase Orders (PO) using Import Standard Purchase Orders into Production.
• Responsible for converting all the Historical Purchase Order Receipts using Receiving Transactions Processor into Production.
• Responsible for converting all the Historical Invoices using Payables Open Interface Import into Production.
• Written an API for Converting the Invoice Payments and was able to convert all the Historical Invoice Payment History into Production.
• Wrote pl/Sql packages/procedures to retrieve order-booking data, based on the search criteria entered in the OA Framework based search screen.
• Handled the implementation stages for EDI, Financials, Purchasing and setting up the interface for Order Management system.
• Worked with interfaces from AP to PA (Project Accounting).
• Developed an interface program to load data from custom tables to interface tables and then created journals into Oracle General Ledger as per business requirements.
• Customized various reports by adding new fields as per the business requirements.
• Created reports from the scratch as per users requirements in PA, AP and AR
• Created custom templates with Data Definitions for XML Publisher and Developed reports using reports 6i and registered as XML reports in applications.
• Developed several reports in General Ledger (GL) such as Balance-Trial Balance Reports, to keep track of inter company revenues.
• Customized revaluation status report and responsibility report in General Ledger (GL).
• Customized the Oracle Seeded Order Management Transaction Type workflow to add workflow functions for email Notifications when the order is booked using Workflow Builder.

Environment: Oracle Applications 11.5.9 (11i) - PA, AP, AR, GL, OM, PO, TCA, iProcurement, OA Framework, Work Flow, Oracle 9i, Forms 6i, Reports 6i, XML publisher, SQL*Loader, PL/SQL developer, TOAD, Java.