SUMMARY

• Over Six years of IT experience with strong techno - functional experience in design, implementation, upgrade and customization of Oracle Applications R12/11i Financials (GL, AP, PO, AR, Cash Management, AOL), Order Management (OM) and Inventory.
• Expertise with Forms and Reports 6i and 10g, Discoverer 9i, SQL*Plus, PL/SQL, BI (XML) Publisher & Workflow Builder.
• Knowledgeable in new R12 concepts of MOAC, Ledgers, Ledger Sets, Data Access Sets, Definition Access Sets and SLA.
• Worked as Techno-Functional consultant in the R12 implementation/upgrade projects.
• Responsible for Design and Development of Interface Programs.
• Developed data conversion systems for various modules (GL, AR, AP, OM and INV) through interface programs using PL/SQL and SQL*Loader.
• Knowledgeable and experienced in TCA Architecture.
• Experienced in Developing Technical Specification and Design Documents.
• Experienced in Modifying Standard Oracle Workflows to suit the business requirement.
• Extensive experience in development of Custom Forms using Template.fmb, customizations using Custom.pll, Forms Personalization and OA Framework Personalization and customization of existing Oracle reports..
• Strong programming experience in creating Procedures, Packages, Cursors, Functions, Triggers and other database objects using SQL and PL/SQL.
• Proficient in writing and tuning complex SQL statements, complex joins and sub- queries.
• Experienced in fine-tuning code for improved performance.
• Experienced in UNIX SHELL Scripting.
• Strong Analytical, Problem solving and communication skills.
• Strong communication and inter-personal skills at the technical and user level.
• Capable of working independently with minimum supervision or as a great team member.

TECHNICAL SKILLS

ERP: R12, 11i

Modules: GL, AP, FA, AR, PO, CM, INV, SYSADMIN, AOL, OM, BOM, WIP

Languages: SQL, PL/SQL, Java, XML

Database: Oracle 7.3/8i/9i/10g

Operating Systems: UNIX (Sun Solaris, AIX, HP-UX), Windows

Software Tools: Toad, SQL*Loader, Discoverer 2.5/4i/9i, MS Project, MS Office, Visio, Oracle Workflow 2.6, BI Publisher.

GUIs: OracleForms 10g/ 9iAS/ 6i/4.5,Oracle Reports 10g/9iAS/6i/2.5

PROFESSIONAL EXPERIENCE

Confidential, Chatsworth, CA

Oracle Applications Techno Functional Consultant

Responsibilities:

• Implemented GL, PO, AP, AR, INV and FA
• Involved in Requirement gathering and performing Gap Analysis.
• Involved in the design of the Chart of Accounts structure based on the requirements of both the companies.
• Designed a conversion approach to convert Open Transactions in PO, AR, and AP along with conversion of Trial Balances.
• Converted Inventory Items, Item cross s and Item categories from the legacy systems using standard Oracle Import Programs.
• Loaded Suppliers, Supplier Sites and Customers using Standard Oracle import programs.
• Converted Open Purchase Requisitions and Standard Purchase Orders using Requisition Import and Import Standard Purchase Orders Program
• Converted Open AP transactions using Payables Open Interface Program.
• Converted Open AR Transactions (Invoices/CM/DM/Deposits, On-Account receipts) using Autoinvoice Master Program and Oracle Public API’s
• Loaded GL balances into R12 using the Journal Import program.
• Modified standard Oracle reports AP Aging report, AR Aging report, AR Commitment balance to excel format using XML Publisher
• Developed a custom check print format to suit the client’s banks requirement using XML Publisher.
• Modified standard Oracle workflow PO Requisition Account Generator to generate the expense account based on a DFF on the requisition line.
• Disabled the Post button on the Journals, using Forms Personalization.

Environment: Oracle Applications 12.1.3, PL/SQL, SQL*Loader, TOAD, Forms 10g, Reports 10g, GL, AP, AR, PO, INV, Oracle Workflow

Confidential, Beachwood, Ohio

Responsibilities:

• Worked extensively on AP, PO and INV
• Created Technical Design Documents (MD70)
• Converted Items and Item Categories from legacy system
• Developed a package to convert Onhand Quantities
• Designed and developed a package to convert Stock Locaters using stock locator API
• Developed custom forms like Inventory Adjustment Form and Purchase Order Closer form.
• Developed custom XML reports like Top 20 Vendor report, Open/Closed/Cancelled/Finally Closed PO report.
• Performed forms personalizations based on customer requirements.
• Prepared FNDLOAD scripts to migrate Concurrent Programs, Value Sets, Personalizations etc. between various environments.

Environment: Oracle Applications 12.0.6, PL/SQL, SQL*Loader, TOAD, Forms 10g, Reports 10g, AP, PO, INV

Confidential, Chatsworth, CA

Oracle Applications Techno-Functional Consultant

Responsibilities:

• Extensively worked on OM, INV, AR, AP, FA, PO and GL.
• Developed a custom package to import Non-Revenue transactions into GL using Journal Import.
• Designed and developed Outbound Interface Program using Oracle’s Shipping Execution Public API to send pick released orders to an external system.
• Designed and developed Inbound Interface Program using Oracle’s Shipping Execution Public API’s to ship-confirm the deliveries shipped in the external warehouse.
• Developed a package to import Items using Open Item Interface.
• Developed a code for Exporting Sales Orders, Items, Customers, Vendors and Payments from Oracle Applications into external system (ALLIANT).
• Designed and Developed a package for Importing Invoices from external system
• Developed a process to import Receipts into Oracle Receivables using Lockbox.
• Developed a package to import Sales Orders received through EDI using Order Import.
• Created a package to import Returns (RMA’s) received at the external warehouse. .
• Created a package to import Price Modifiers for returns. (This is used for returns on product sold in clearance at certain special prices).
• Developed custom reports AP Aging by Company Group, Print Sales order Acknowledgement, Print Selected Invoice(s), Sales Velocity by product, Sales Velocity by Period using Reports 6i.
• Modified the OM Order Line workflow to include Approval steps for certain order types.
• Developed a Material Transactions Interface package to import inventory adjustments made at the warehouse.
• Developed custom forms using Template.fmb to hold additional item information and attached it to the master item form.
• Provided production support to resolve day to day functional/technical issues.

Environment: Oracle Applications 11.5.8, PL/SQL, SQL*Loader, TOAD, Forms 6i, Reports 6i, SQL*Plus, Oracle 9i, GL, OM, INV, AR., AP and PO

Confidential, Fort Wayne, IN

Oracle Applications Techno-Functional Consultant

Responsibilities:

• Extensively worked on AR and Claims (Trade Management).
• Designed and developed a package to load Credit Memo’s from an external system (CASC) into Oracle Receivables using Auto Invoice.
• Developed a package to close any claims using the Claims Public API if a credit memo was created to settle a claim.
• Developed a package called ITEM-TRANSFER to transfer invoices, claims and receipts belonging to one customer to another customer.
• Developed a package to write-off claims whose age exceeded certain number of days using the Claims Public API.
• Designed a Custom form ‘SLICE & DICE’ using Template.fmb enabling the users to query the invoices, receipts and claims of a customer and perform desired actions like Write-off, Adjustments, Item-Transfer, Create-Claim etc on these items.
• Using Custom.pll disabled the application lines on the Receivable Applications form if a DFF was set to a specific value.
• Developed a Custom Workflow to create adjustments for invoices using the Adjustment API.
• Developed a Custom Workflow to write-off Receipts using AR Receipts Public API.
• Customized existing Oracle Report Aging Bucket by Collector to add additional fields as per business requirement.

Environment: Oracle Applications 11.5.10, PL/SQL, SQL*Loader, SQL Developer, Forms 6i, Reports 6i, SQL*Plus, Oracle 9i, AR and Trade Management, Oracle Workflow 2.6