SUMMARY

• Oracle Applications Consultant with having around 7 years of experience in Software Development which includes System Study, Design, Development and Post implementation maintenance and support of various versions of Oracle Applications e - Business Suite
• Experience in oracle applications financials, manufacturing and various supply chain modules which include Accounts Payables (AP), Accounts Receivables (AR), General Ledger (GL), Fixed Assets (FA), Purchasing (PO), Project Accounting(PA),Order Management (OM), Cash Management (CM), Inventory (INV), Bill Of Materials (BOM), Oracle Process Manufacturing (OPM), Work In Process (WIP), Oracle Projects, Customer Relationship Management (CRM),HRMS, AME, EBTax, iProcurement, iExpense, iSupplier Portal .
• Experience working on Conversions, Interfaces, Reports and Forms which include developing of new forms and customization of old forms, and development of reports using standard RDF report/ XML publisher/ BI publisher and customization of old reports.
• Proficient in developing PL/SQL program units using Procedures, Functions, Packages and Triggers, public API’s.
• Experience working in all the RICEF components which includes new implementation and Upgrades from 11i to R12.
• Well versed with client server environment & tools like SQL*LOADER, TOAD and WORKFLOW BUILDER.
• Good understanding of business process operations, organizational assessment and translating them into functional requirements .
• Good knowledge of Supply Chain Management, Order to Cash (O2C) and Procure to Pay (P2P) business cycles with Customer Relational Management (CRM).
• Extensive Experience with AOL to develop Flex fields, Reports, and Value sets and Concurrent programs and registered in AOL .
• Involved in 3 implementations, which includes full-cycle implementations. As well provided support during go live critical times and post-production maintenance phase to different clients .
• Experienced in Forms customization and personalization registering them as concurrent programs in Oracle applications using AOL .
• Expertise in Implementing software development life cycle policies and procedures .
• Experienced in Customizing and developing Oracle Reports 6i/10g .
• Good experience in implementation process mapping, functional requirement analysis, Gap analysis, post implementation production support, business users (development of material), presentations, testing and documentation .
• Identified product gaps, coordinated with Development Team by creating TAR/SR’s and obtained one-off fixes. Managed and monitored TARs for several P1 Issues. Provided on site solutions and resolved showstopper issues .
• Good experience in providing user after the acceptance of the application .
• Experienced in Customizing and developing reports using BI Publisher/ XML publisher, Discoverer .
• Excellent problem solving, communication, analytical, interpersonal & leadership skills .
• Trouble-shooting user problems during the go-live phase .
• Quick learner with ability to develop proficiency and adapt to new technologies and methods in a short period of time.

TECHNICAL SKILLS

ERP: Oracle E-Business Suite v R12, 11.5.10, 11.5.10.2

ERP Modules: General Ledger (GL), Accounts Payables (AP), Accounts Receivables (AR), Purchasing (PO), Fixed Assets (FA), Project Accounting (PA), Order Management (OM), Cash Management (CM), Inventory (INV), Bill Of Materials (BOM), Work In Process (WIP), Oracle Projects, HRMS, AME Customer Relationship Management (CRM), Oracle Process Manufacturing (OPM), iProcurement, iExpense, iSupplier Portal

Interface Tools: SQL Plus, Toad, SQL * Loader, Developer 2000/6i, Workflow Builder 2.6, Java

RDBMS: Oracle 10g/9i/8.0.5/7.3, MS Access

Languages: SQL, PL/SQL,C, C++, Java

Reporting Tools: Forms & Reports Builder 6i/10g/11g, Discoverer, BI Publisher, OAF (OA Framework)

PROFESSIONAL EXPERIENCE

Confidential, CA

Oracle Apps Techno-Functional Consultant

Environment: Oracle Applications 11.5.10.2, R12.1.3, GL, AR, AP, PO, PA, OM, BOM, INV, iProcurement, EBTax, AOL, Oracle 10g, PL/SQL Developer, SQL*Plus, Toad, Forms 11g, Reports 11g, BI Publisher, UNIX, ADF, SVN .

Responsibilities:

• Analyzed the business processes, requirements, mapped with Oracle features, done the Gap Analysis.
• Coordinate Pilot Room Conference with end user to study gaps.
• Participated in quality reviews to ensure traceability of the designs to the requirements .
• Prepared high-level and low-level designs for bridging and migrating data to AP, AR and PA modules.
• Designed, developed and documented for Conversion of Purchase Requisitions, Purchase Orders, Suppliers, Supplier Sites, and Items.
• Worked on creating AOL users and assigning Responsibilities using User Form.
• Worked on the Panaya tool to compare 11i and R12 objects.
• Worked on User group assignments using SQL queries.
• Extracted data from CARS system for 11i data.
• Personalized User creation form.
• Integrated and Imported sales orders into Order management system from Online sales order management system using PL/SQL Api's .
• Imported the journal entries from legacy system to Oracle General Ledger using SQL*Loader, PL/SQL package and populated the data into the GL interface.
• Developed SQL Loader Programs and PL/SQL procedures to load
• Invoice data into Oracle from various feeder systems .
• Receipts data from the Bank files into AR tables using Auto Lockbox.
• Developed an interface to provide General Ledger accounting information using DB Links
• Coordinated with External systems, functional and testing teams in various stages of interface development.
• Written an Interface for Account Payables (AP) Invoice Upload, which creates invoices from a CSV file.
• Developed an Inbound Interface between web based Order Management System to Order Management (OM) for open Sales Orders.
• Design, Documented and developed Conversion routines, Custom PLSQL API for Item Import and BOM Import and successfully loaded the items and BOM.
• Worked on TCA conversions.
• Integrated EBTax engine with AP, AR modules to calculate International import, export and other taxes.
• Developed pl/sql API to integrate EBTax with Accounts Payables .
• Developed pl/sql API to integrate EBTax with Accounts Receivables .
• Experienced in AR auto invoice setup and configurations of Collections work bench.
• Worked on several customizations on Oracle AR such as mass application of receipts in AR, Cascading of AR statuses (customization), enhancing the Oracle AR adjustment approvals, enhancing the interest accrual process.
• Extensive experience of order flows and multi org setup in order to cash process.
• Involved in setting up of Stores, Content zones, Smart forms in iProcurement .
• Involved in Implementation of iProcurement module and Customization of interfaces in this Module.
• Involved in setting up Direct Punch-out, Indirect Punch-out and Catalog Setup in iProcurement
• Did Smart forms in iProcurement for a Non-Catalog request as per user requirements.
• Involved in customizing Requisition Package in iProcurement as per the client requirements.
• Designed and Developed Sales Orders Items shortages report, Daily Inventory Transaction Report.
• Worked extensively with the clients teams and coordinated with the offshore teams.
• Initialized Document sequencing during transaction numbering.
• Customized the Backorders Detail Report, Backorder Summary Reports.
• Worked on FSG Reports .
• Worked on Sales Order ADF Form .
• Extracted data from panaya to work on 11i and R12 objects.
• Worked with SVN to perform code checkin and checkout of SQL scripts, Shell Scripts.
• Worked on several packages and programs to improve performance using Sql Trace and TKPROF file .
• Performed Sql tuning to increase execution performance of programs using Explain plan .
• Extracted custom object data from 11i and R12 systems Unix scripts.
• Worked on BIPS Reports and Concurrent programs extracts.
• Worked on Concurrent Request monitoring application.
• Worked on the Quality center for Preparing Test plans.
• Prepared Technical Specification (MD70) documents.
• Involved in developing the user manual and giving presentations to the users in coordination with the SEAB team on any new enhancements.

Confidential, Torrance, CA

Oracle Apps Techno-Functional Consultant

Environment: Oracle Applications R12.1.3, R11.5.10.2, GL, AR, AP, FA, CM, PO, OM, PA, AME, iExpense, AOL, ADF, PL/SQL, Oracle 10g, SQL*Plus, Toad, Forms 10g/6i, Reports 10g/6i, SVN, BI/XML Publisher .

Responsibilities:

• Involved with study of existing system, preparing the Functional (MD50), Technical (MD70) design document and Conversion Mapping Document (CV40) to extract data from Oracle Applications, modify the data and upload back to Oracle .
• Performed GAP analysis and prepared solution presentation for review.
• Customized the payment, accounting workbench and Credit Card Registration forms for Tokenization project.
• Prepared extraction scripts to fetch payments, adjustments and refunds.
• Developed conversion programs to load back the updated credit card information.
• Modified order payment process for credit card payments.
• Modified payment inquiry report.
• Worked on Token generation ADF Form .
• Developed check printing for SCM team.
• Worked on the payment form for Korea and Brazil changes to be sent to the HPS system.
• Worked on implementing iExpense .
• Worken on below iExpense setups -
• Define Accounting Flexfield,updated Internet Expense Messages, defined Contact us Information, Global Policy Information, define Employees, Security Profiles, System Profiles, Define Payable Lookups, Expense Clearing Account, Expense Report Options, Enable auto Tax Calculation, Auto Tax Calculation, Tax Code Default Hierarch, define Expense Report Templates, Establishing Corporate Credit Cards Define Oracle Internet Expense Setup .
• Created AME rules for iProcurement, iSupplier and AP Invoices .
• Integrated Primavera system to Project Accounting using PL/SQL Api's .
• Worked on the Primavera reports.
• Developed Project Accounting reports for Reconciliation with the Primavera system for Project, Resource level reconciliations.
• Worked on the unapplied receipts report.
• Designed interfaces for Bank Reconciliation and Positive Pay transactions through Oracle Cash Management .
• Setups to create, itemize, withdrawals of iExpenses as well as setting up of approval limits.
• Worked on the Benavides implementation project packages.
• Developed package for splitting the create receipt program to run faster.
• Worked on the post production and correction of data after Tokenization Implementation.
• Worked on the Primavera to Oracle data import Packages.
• Worked on sales register report .
• Personalized Payment and Accounting workbench forms for Tokenization.
• Personalized the Invoice Entry form .
• Involved in transferring to the General Ledger, Running the Journal Import Program during Period end Process.
• Defined payment terms in Payables .
• Worked on Trial Balance, Income statement FSG Reports .
• Configured the setup for raising Batch invoices and Batch payments of Oracle Payables.
• Assist users to progress orders from order import to ship confirmation and auto-invoicing.
• Performed system administration functions such as creation of request groups and concurrent programs.
• Developed Bloomberg program to import currency conversion data to R12 GL Daily rates.
• Developed Credit Card Transactions Report.
• Developed several reports in General Ledger such as Balance-Trial Balance Reports, to keep track of inter company revenues.
• Developed Multi-Org all inventory value Report which shows us month-end inventory quantities and value across all warehouses in total using XML Publisher.
• Customized seeded oracle inventory transaction summary report and material account distribution detail report .
• Did forms personalization to make view only forms.
• Worked on several programs to increase their performance using Sql tuning .
• Used Oracle Application Object Library (AOL) features like Value Sets, Descriptive Flex fields, Concurrent Programs, Profile Options, standard request submissions (SRS) and parameters in the process of development.
• Wrote MD70, CV40 documents forProject Transactions.
• Performed CRP tests at client’s location.
• Involved in production support of payment application and month end closing .

Confidential, Reston, VA

Oracle Apps Techno-Functional Consultant

Environment: Oracle Applications R12.1.3, GL, AR, AP, FA, CM, PO, INV, HRMS, iProcurement, AME, AOL, PL/SQL, Oracle 10g, SQL*Plus, Toad, Quest STAT, SQL Navigator, PL/SQL, Forms 10g, Reports 10g.

Responsibilities:

• Designed, documented (prepared CV40 Conversion Mapping Document, and MD70 Technical Specification Document) and developed Conversion process for Customers (as TCA architecture), Suppliers, Supplier Sites, Bank Branches, Bank Accounts, Open Purchase Orders, and Reports.
• Participated in the transitions of the customization functional designs of R12 to the technical designers.
• Create RICEW components functional designs.
• Experienced in System Integration with 3rd party System Integrators and financial Institutions .
• Designed Staging tables, Developed conversion routines, Custom PL/SQL API for Customers (as TCA architecture), Suppliers, Supplier Sites, Bank Branches, Bank Accounts, Open Purchase Orders.
• Fully responsible for designing and implementing of Accounts Receivable (AR) Module: Defined Transaction Types & Sources and Standard Memo Lines.
• Designed and Developed an Item Conversion to Import legacy inventory item data to oracle inventory using item import.
• Developed Multi-Org all inventory value Report which shows us month-end inventory quantities and value across all warehouses in total using XML Publisher.
• Developed Auto Lockbox interface with Wells Fargo Bank and Oracle Account Receivables for loading Payment receipts.
• Designed and developed Bank Reconciliation Interface with Wells Fargo Bank for Cash Management.
• Defined payment terms in Payables module.
• Importing and entering invoices and invoice distributions of Oracle Payables.
• Automated calculation and accounting of partially recoverable and non-recoverable value-added tax, sales and use tax, withholding tax, and regional and local taxes supported by Oracle Payables.
• Configured the setup for raising Batch invoices and Batch payments of Oracle Payables.
• Customized Trail Balance Aging Reports, Daily Sales orders reports, Daily item transaction reports and Printed purchase order Reports.
• Customized NACHA file format for Wells Fargo.
• Customized Positive Pay (ARP) layout for Wells Fargo.
• Involved in transferring to the General Ledger, Running the Journal Import Program during Period end Process.
• Worked on Income Statement and Balance sheet FSG reports .
• Configured the setup for raising Batch invoices and Batch payments of Oracle Payables.
• Experience of working on Dunning Plan setups using correspondence templates.
• Customized FAST FORMULAE for Payroll elements and Approval Management (AME)
• Integration of AME with Self Service HR processed like terminations.
• Involved in iProcurement Setup .
• Utilized Forms Personalization utility to call a PLSQL procedure and updated the AR Descriptive flex fields with Depot Repair flex field data.
• Created a Report for End Users to get the vendor and its site information.
• Post-production troubleshooting and analysis of Service Agreements/Contracts (including Service Contracts and Contracts Core (OKS/OKC) modules), Install Base (CSI), TCA, and tax issues with Contracts (AR).
• Involved in Customizations and Extensions for HRMS.
• Created custom payroll reports like Earnings report, Deduction Report, Tax Balance report, and Costing reports.
• Involved in some activities for Oracle System Administration module such as registering the Users and assigning responsibilities, printers in Oracle Apps.
• Creating new responsibilities and defining the required system profile options.
• Prepared Test scripts and involved in Application Integration Testing and System Integration Testing at clients place.
• Involved in Unit, system and Integration testing of Interfaces.
• Worked on Manager Self Service and Employee Self Service.
• Self Service Customization for entering Absences, Absence reports.
• Configured Workflow for approval Process .
• Provided daily support for Purchasing, Receiving users.
• Involved in production support after the go live .

Confidential, Kansas City, MO

Oracle Apps Techno-Functional Consultant

Environment: Oracle Applications 11.5.10.2, AP, AR, GL, FA, OM, PO, PL/SQL, TOAD, Forms 6i, Reports 6i, SQL*Loader, SQL*Plus, UNIX, Kintana, Shell scripts.

Responsibilities:

• Involved with study of existing system, preparing the Functional (MD50), Technical (MD70) design document and Conversion Mapping Document (CV40) to extract data from legacy system into Oracle Applications .
• Designed, documented and developed Staging tables, Conversion routines, and Custom PL/SQL API for
• Suppliers, Supplier Sites, Supplier Contacts, Customer Import (Parties, Party Sites, Party Accounts, and Party Account Uses) using TCA .
• Written an API for Converting the Invoice Payments (AP) and was able to convert all the Historical Invoice Payment History into Production.
• Performed role in implementing the Procure to Pay (P2P) cycle of Oracle applications which involved conversion of Oracle PO/AP modules, conversion of static data (Vendors, Employees).
• Assisted client in design customization of the process to interface invoices, from legacy systems, to Oracle AP and AR.
• Created Custom GL Alert to send the email notifications when GL period is open/close.
• Created new end-to-end processes for Procure to Pay processes for accurate purchase order creation.
• Developed an Interface Program to Load Inventory Items, Inventory cross, Manufacturers Cross and Manufacturers into the Base Tables.
• Designed and developed an interface between third party billing system (INTUIT) and Oracle Receivables to load external invoices data on daily basis. Used SQL*Loader for import INTUIT invoices into Staging tables, and developed PL/SQL API for complete validation of data and inserting into Interface tables.
• Developed Conversion program to import Vendor/Supplier Information into Purchasing by loading data into staging tables from legacy system, validating data using PL/SQL API and tan loading the data into Vendor information Base tables.
• Worked on Oracle API bug in Vendor Sites Open Interface Import causing all the legacy data to be rejected because of duplicate Vendor Site Code.
• Responsible for providing production support for fixed assets (FA) and Account payables and Accounts Receivables.
• Developed a procedure to provide a flat file for a system containing relevant billing, open transaction, adjustment, payment and reimbursement information in the ORACLE for that system.
• Involved in customization of several standard reports to serve important business processes very specific to the client. Such reports include
• Purchase Order Detail Report in PO.
• Invoice on hold report, Vendor, Payments and analysis reports in AP.
• Customer, receipts, invoice, and adjustment reports in AR.
• Customized the Journal Entries Report in AR which is used to review the details that make up the General Ledger journal entries.
• Involved in Building Customizations and Enhancements using Reports.
• Modified Invoices form in AP and Transactions form in AR to restrict data access.
• Customized the Order and Line workflow to send Email notifications when the line total crosses certain amount.
• Customization of AP Invoice Approval workflow.
• Customized PO approval workflows and configured approvals using Oracle Approvals Management.
• Prepared Technical Specification (MD70) documents.