SUMMARY

• Over 7 years of experience in Designing, Developing, Customizing, Testing, Data conversion, Implementing and Upgrading Oracle Applications R12, 11i using ORACLE 10g/9i/8i, SQL, PL/SQL, Forms 10g/9i/6i, Reports 10g/9i/6i, Discoverer 10g/4i, XML Publisher, Unix, Linux and Shell Scripting.
• Proficient working in GL, AP, AR, OM, INV, PO, IBY, CE, BOM, iStore, iSupplier, iExpenses, OGA, AOL, Alerts, System Administration and Supply Chain modules.
• Expertise in RICE components.
• Good knowledge in Order to Cash (O2C) and Procure to Pay (P2P) cycles.
• Involved in two full life cycle implementations.
• Experience working on Sub ledger Accounting (SLA) Engine.
• Expert in custom Form Development, Form Personalizations and CUSTOM.pll.
• Extensive experience in Trading Community Architecture (TCA).
• Proficient in designing and development of Interface/Conversion programs to import data from legacy systems and integrate it into Oracle Applications using open interfaces and APIs.
• Extensive experience in designing and developing new reports and customizing standard Reports using Oracle Reports 10g/9i/6i, Discoverer 10g/4i and XML Publisher.
• Proficient in writing SQL, PL/SQL Packages, Stored Procedures, Functions, Database Triggers, Exception handling, SQL * Loader scripts and shell scripting. Worked with SQL*Plus, Toad, SQL Developer, PL/SQL Developer.
• Tuned SQL queries and performed refinement of the database design leading to significant improvement in system response time and efficiency.
• Extensive experience in customizing and developing new workflows using Workflow Builder including workflow notification enhancements, workflow customizations.
• Experience in System Administration including Oracle Applications activities like defining responsibilities, value sets, flex fields, registering menus, forms, reports, concurrent programs, request sets, form functions, profiles and providing support to apps users for any technical issues and Strong knowledge of AOL and Approvals Management(AME).
• Experienced various stages of Software Development Life Cycle Process (SDLC) and its deliverables.
• Profound knowledge of Test Plan and Test Case Design. Experience in writing Test cases, Test execution, Defect tracking and Test reporting.
• Hands on experience in Manual testing and Automated testing using Test Director, Quality Center(QC), Quick Test Pro(QTP) and Load Runner.
• Experience in supporting the production system and handling day - to-day issues.
• Experience in writing numerous MD050, MD070, MD120, CV40 and CV60 according to Application Implementation Methodology (AIM) and also writing Test Script documents in Financials modules.
• Excellent knowledge of Multi-Org and Multi-Currency implementation solutions.
• Strong interpersonal, analytical, and communication skills, proven ability as an efficient team member in System Analysis, Design, Development, Migrating and documentation. Result oriented, organized with good Presentation skills.
• Excellent learning skills to adapt the rapid changing technologies and implementing the same at work. Would be willing to work independently or as part of a team.

TECHNICAL SKILLS

ERP: Oracle Applications R12/11i

Oracle Applications: Accounts Payable (AP), Accounts Receivable (AR), General Ledger (GL), Order Management (OM), Inventory (INV), Purchasing (PO), Bills of Material (BOM), IBY, iStore, iSupplier, iExpenses, Project Accounting, Cash Management (CE), OGA, Work in Progress (WIP), QP, WSH and AOL.

Tools: Forms 10g/9i/6i, Reports 10g/9i/6i, SQL*Plus, TOAD, Oracle Discoverer10g/4i, XML Publisher, SQL*Loader, SQL Developer, PL/SQL Developer, SQL navigator, Workflow builder, JDeveloper, Test Director, QTP 10(Quick Test Pro), QC, Load Runner and Putty.

RDBMS: Oracle 11g/10g/9i, SQL Server.

Languages: SQL, PL/SQL, C, C++, HTML, VB.NET, XML, DHTML, Core JAVA and Shell Scripting.

Version Control: PVCS, SVN, KINTANA

Document Methodologies: MD050, MD070, MD120, CV40 and CV60

OS: UNIX, Sun Solaris, Windows 95/98/2000/NT/XP/Vista/Windows7 and Linux.

PROFESSIONAL EXPERIENCE

Confidential, Sidney, OH

Oracle Techno-Functional Consultant

Responsibilities:

• Gathered and analyzed the requirements and prepared High level and Low level design documents (Technical Specifications (MD070), Conversion Mapping (CV060) and MD050) for conversions and various customizations in Supply Chain Management (SCM) and Financial modules namely Accounts Receivables (AR), Inventory, Accounts Payables (AP) and General Ledger (GL).
• Conducted Current State Analysis and Gap Analysis.
• Worked on R12 global implementation, currently the legacy system is mainframe. We migrated the data from mainframe to Oracle R12.1.3 and developed the RICE objects as per the requirement.
• Configured payments (banks, bank accounts, payment formats, payment process profiles and payment process templates) module for processing Check, ACH and Wire payments from two corporate bank accounts.
• Developed interfaces for AP Invoices, AR Invoices, GL Journal and also Intercompany Invoices.
• Developed Journal Entry interface by writing a custom package to validate the data from the flat file and populate the same into GL interface table.
• Designed and developed outbound Payment Interfaces to Confidential and Chase Banks for processing ACH and Wire payments.
• Created SQL*Loader control programs and PL/SQL validation procedures to execute along with Order Import Interface (OM) programs to support the interface requirements.
• Designed, documented and developed Data Conversions for Master data.
• Converted the customer information from legacy system into oracle Applications using API to load HZ tables in TCA.
• Developed data conversion process to load the pricelists data from legacy system into the oracle base tables usingQP: Bulk import of price lists API.
• Developed a XML Check Template as per Chase bank preprinted check format, for in house Check Printing.
• Created EUL and Workbooks for the users using Discoverer.
• Development of ’EMR ONTpacking Slip Report ECT’ and ’EMR Non-Moving Inventory Report ECT’ usingOracle reportsfor the Client.
• Development of ‘EMR AP Check Printing ECTI’,’ERS Payment Format Report’ usingXML publisher.
• Customized Account Payables (AP) Reconciliation Reports like EMR AP Trail Balance Report, Posted Invoice Register, Unaccounted Transactions report, Invoice on hold report and Supplier listing report, Purchase Order Detail report in PO.
• Customized Account Receivables (AR) Reconciliation Reports like Active customer listing report, Unmatched Receipts report and Invoice aging report.
• Registered customized Oracle reports, XML Publisher reports and XML RTF templates using System Administrator, Application Developer and XML administrator responsibilities.
• Created new Custom Forms for displaying the payments and Refund amounts using template.fmb.
• Forms Personalization Utility has been used to call a PL/SQL procedure and update the AR Descriptive flex fields.
• Worked on OM API’s for scheduling sales orders, applying holds and book the order.
• Developed customized workflow definitions for business functionality like LSN and creating Sales Order Quotes using Standard APIs.
• Worked on OM Generate Cost of Goods Sold Account Workflow.
• Made OM Line Level Workflow Changes for ATO Model Items.
• Developed a PL/SQL program, which reconciles the Reply Bank data file (Lockbox) and calls Receipt API to reverse the receipts for which credit card status is declined.
• Optimizing the Performance of SQL scripts and Oracle Application/Performance Tuning.
• Involved in implementation of Order to Cash cycle including Order Entry, Order Booking, Pick Release, Ship Confirm, and Interfacing to Receivables.
• Created Custom Responsibilities and Custom Menus as per requirements and migrated to Production.
• Studied the application and use-cases, analyzed user requirements of the application and prepared pre-conditioned data for testing the application.
• Developed automated test scripts from manual test cases for Regression testing based on the requirement documents using Quick Test Professional (QTP).
• Performed Data Driven Test with Quick Test Professional (QTP) to test the application for different sets of data and reported defects in Quality Center (QC).
• Experience in Performance testing the applications using LoadRunner.
• Prepared documents for all RICE development.
• Experience working in a distributed team environment.

Environment: Oracle Applications Suite R12 (AP, AR, GL, OM, INV, CE, IBY and AOL), OBIEE Analytics, Forms 10g/6i, Reports 10g/6i, Discoverer, XML Publisher, RDMS 11g, Workflow Builder, SQL*Plus, SQL*Loader, TOAD, QTP 10, QC, LoadRunner, PVCS, Linux.

Confidential, Cleveland, OH

Oracle Techno-Functional Consultant

Responsibilities:

• Designed and documented Functional (MD050), Technical Specification (MD070), Conversion Mapping (CV040) documents.
• Configured functional setups in various Financial and Supply Chain modules like Payables, Receivables, Inventory, Order management and General Ledger like Order & Line Types, defined custom profiles, Invoicing rules, responsibilities, menus, security profiles, security rules, financials options, payables options, tax configurations, receipts, calendar, currency, chart of accounts and Conversion rates.
• Implemented Order Returns with and without credits which involved setting up transaction type, loading order using SQL*Loader, creating receipts to close the order.
• Developed Auto Apply Credit to Invoice (AR) and implemented a unique solution to resolve manual application of credit memos to invoices using AR RECEIPT API PUB.
• Designed and Developed interfaces between third party systems and AP module for processing payments.
• Designed, Documented and Developed an Interface between ADP payroll and General Ledger to load journals into GL on monthly basis.
• Designed and Developed Order Import Interface for daily and weekly feeds of orders.
• Used Auto Invoice Interface to import Standard Invoices into Oracle receivables using a control file, PL/SQL Packages/Procedures and Auto Invoice Import program.
• Customized Corporate Budget Inbound Interface program for Sherwin Williams STORES division, which imports updated Budget data for all Sherwin William nationwide stores into Oracle standard budget tables after doing required business validations.
• Designed and Developed GL Outbound Interfaces, which extracts data from Oracle General Ledger and sends them to a reporting team with the help of a tool called Hyperion (which is the major reporting tool for Sherwin Williams to report critical financial data).
• Developed AP payments Outbound Interface to Asian Banks. Payment types include ACH, USD wires, and EFTs.
• Experience in importing requisitions from legacy system to Oracle Purchasing through Requisition Open Interface (PO).
• Developed conversion routines for data migration activities.
• Involved in the development of TCA Customer Conversion program which includes data validation and API calls.
• Designed Corporate Budget Conversion program, which does all business validations on the developed Budget Import program. Did all necessary setups like all Budget names and Budget Organizations and Fiscal years for defined budgets and budget organizations.
• Created custom Staging tables and PL/SQL API’s to validate and load transactions from third-party systems into Oracle.
• Worked on shell scripts to move files from shared directory to server, load data into the tables using SQL*Loader and sending reports to users.
• Designed and developed Custom AP Payment Check format program which creates payment file in custom format, designed by business users and send it to Check printing group.
• Involved in customization of Monthly Journal Entry Detail Report and Monthly Journal Entry Transaction Currency Report. The business users have extensively used these reports for month end closing.
• Modified print purchase order report to print EDI order.
• Designed XML Template reports to generate output in PDF format and used company specific templates to develop reports using XML Publisher 5.0.
• Customized Positive pay report to generate a file and upload to Citi Bank.
• Developed Inv Movement Report, Accrual Reconciliation Report and Error Reports in Manufacturing and Financial modules Using Reports 10g.
• Customized the AR invoice form, AR customer screen using Forms 10g.
• Customized the Oracle Purchase Order form using Forms Personalization.
• Developed custom package to apply holds and other customizations with various scenarios to call them from CUSTOM.PLL
• Customized the Workflow for the Order Line flow.
• Customized the workflow to handle price notification and approval for multiple levels of the organization.
• Designed and developed Custom General Ledger Translation program, which can be used to translate all the foreign sets of books to US dollar sets of books. This translation program is really useful for the smooth closing of their books without hitting any major issues during month end close.
• Created new inventory organization, which allows Internal Transfers.
• Developed Base line scripts for testing the future releases of the application using Quick Test Pro(QTP).
• Created the virtual users to check the performance of the screen by Load Runner.
• Used Test Director as a Defect Management Tool for creating test plans, documenting them and for creating test cases.
• Used Kintana for Code migration.

Environment: Oracle Applications R12 (GL, AR, AP, IBY, CE, OM, PO, INV), Oracle 10g, Forms 10g, Reports 10g, Discoverer 9i/10g, XML/BI Publisher, Workflow Builder, TOAD, RDMS 11g, Forms Data Loader, QTP, Test Director, Load Runner, Kintana and UNIX.

Confidential, Las Vegas, NV

Oracle Technical Consultant

Responsibilities:

• Involved in the study of existing system, preparing the Technical (MD70) design documents and Conversion Mapping Document (CV40) to extract data from legacy system into Oracle Applications open interface tables.
• Configured functional setups for various Financial and Supply Chain modules (AP, AR, GL, OM, INV).
• Designed and developed staging tables, conversion routines, Custom PL/SQL API’s for converting Suppliers, Supplier Sites, Supplier Contacts, Customers using TCA, Open AP Invoices, and Open AR Invoices from legacy system into Oracle Applications.
• Designed and developed an Interface between web based Order Management systems to Oracle Order Management for creation of sales order which involved development of a UNIX shell script which calls SQL Loader program to load data into custom staging tables and check for uniqueness of the files in UNIX directory to avoid duplicate data.
• Worked on Web ADIs and Excel based uploads to enable users enter the invoices into Oracle Payables.
• Created flex fields as required in the forms of various modules like AP, AR and GL.
• Developed custom form, invoice view form in AR inquiry responsibility using TEMPLATE.fmb & Customized around 15 standard forms through CUSTOM.pll and Forms Personalization.
• Customized AR account status Report, and AP Trial Balance report using Report 10g tool.
• Using XML publisher, Sales order Acknowledgement Report has been developed and also customized AR to GL Reconciliation Report.
• Involved in the design of more than 10 reports using Reports 6i, Discoverer and XML Publisher in Order Management, General Ledger, Payables, Receivables and Purchasing.
• Developed Custom Discoverer reports like Monthly customer sales report, Monthly region sales report, Invoices summary report, Invoice payments summary report, Account Status Report and Bank Account Listing.
• Developed a report, which showed requisition details, purchase order details, receiving details, invoicing details and payment details in Oracle Procure to Pay Cycle.
• Customized the Workflow API packages to Call the API packages.
• Interacted with Oracle Support regarding localization patches and issues.
• Implemented System Administrative activities like creating new Menus, new Responsibilities, new Functions, and User Authentication security system profile.
• Used PVCS for Code migration.
• Raised RFCs and worked with DBAs for code migration from lower environments to production instance.

Environment: Oracle Applications R12 (OM, INV, PO, AR, AP, GL and AOL), Reports 10g/6i Forms 10g, XML Publisher, Web ADI, Workflow Builder, SQL*Plus, TOAD, SQL*Loader, Oracle BI, Discoverer 10g, PVCS (Version Control Software) and UNIX.

Confidential, Plymouth, MN

Oracle Technical Consultant

Responsibilities:

• Involved in the implementation of design, development and testing phases which accompanied by high degree of user interaction.
• Prepared Technical Specification documents (MD70).
• Configured functional setups in various modules like Payables, Receivables, Purchasing and General Ledger.
• Designed and Developed standard invoice interface to load all PO and non-PO Invoice information for internal customers and suppliers into Oracle and payment outbound interface to Bank of New York (payment types: foreign wires, foreign drafts, USD wires, ACH and checks).
• Involved in import of invoices, receipts, credit memos, and debit memos into Oracle Receivables.
• Developed Receivable Open Interface and ran it to import data into RA interface tables and used the standard API “Auto Invoice” to import the customer invoices.
• Developed Payments outbound interface and FTP’d the extracted file to outside back office system. Wrote shell script for FTP and the technical document.
• Developed transactions and their related customer extract interface from AR module to generate out file to AR collect which facilitates collection of invoices created in Oracle receivable module.
• Developed conversion code for Customer, Open Invoices and Item in which many business validations have been taken care before loading all the data into Oracle interface tables.
• Created reports from the scratch as per user’s requirements in AP, AR and OM using Reports 6i and XML Publisher.
• Developed Discoverer reports and Excel based reports for Receivables and Payables.
• Tools such as ITG Kintana (Ver: 6.0.0) have been used to migrate numerous RICE objects.
• Interacted with IBM India development team on daily basis and on time delivery of all the components was provided in spite of aggressive onsite schedule.
• Interacted with oracle support and raised TARs to resolve issues during implementation.

Environment: Oracle Applications 11.5.10 (GL, AP, AR, PO, and AOL), TOAD, Oracle Discoverer 4i, Unix and Shell scripting ITG Kintana 6.0, Reports 6i, XML Publisher, SQL*Plus, SQL*Loader.

Confidential

Software Engineer

Responsibilities:

• Development of Forms based on Procedures/Views etc.
• Designed and developed Technical document (MD70).
• Wrote a program to load external data from legacy using SQL*Loader into AP INVOICES INTERFACE and AP INVOICE LINES INTERFACE tables.
• Worked on customizing standard Lockbox interface for Receivables.
• Developed script to import customer information from legacy system into Receivables using SQL*loader and PL/SQL.
• Created PL/SQL and SQL*Loader scripts as a part of conversion process to extract the legacy data from existing application and loading into Oracle standard tables.
• Developed customized multiple reports and forms in AR, AP, GL, OM modules according to the requirements.
• Developed custom code, forms and reports as per the users requirement, registered them with the application.
• Wrote database triggers as needed to meet business functionalities.
• Used triggers, stored-procedures, built-in tools for maintaining and management of the database.

Environment: Oracle Applications 11i, Oracle 9i, PL/SQL, SQL* Loader, Forms 6i, Reports 6i, TOAD and SQL Developer.