SUMMARY

• Over 16 years of experience in Information Technology, involved in Design, Analysis, Coding, Testing, Conversions, Interfacing, Upgrade, Migration and Support of application in ORACLE 10.7 / 11i / 11x / R12, ORACLE 9i/8i/7.x, Developer - 2000 / Reports 4.5/6i/10g and Complete Software Development Life Cycle (SDLC) of projects.
• Having 15 years of experience in Oracle Application Modules which includes General Ledger (GL), Account Receivables (AR), Accounts Payables (AP),Cash Management, Fixed Assets, TCA, Purchase Oracle (PO), Order Management (OM), Inventory (INV), Shipping, Bill of Materials (BOM), Project Accounting, HRMS, Pay Roll, IRecruitment, IProc, Service Contracts, Install Base, OLFM / OLM
• Developed reports using BI Publisher tools (XML Publisher).
• Proficient in technical aspects of Oracle Applications Customizations, Interfaces and data Conversions.
• Experience in Conversions from legacy system to PO, AP, AR, GL, OM, BOM, INV and Install sources into Oracle Applications using PL/SQL, SQL*Loader.
• Expertise in System Administration and Application Object Library (AOL).
• Expertise setup Users, Responsibilities, DFF’s through AOL
• Wide experience in Production environment and production support.
• Experience in using tools like TOAD, SQL*Loader, Forms (4.5 / 6i/ 10g), Report builder and Workflow.
• Experience in Bug fixing and interaction with Oracle Support.
• Working knowledge of Procure to Pay and Order to Cash flows.
• Exposure on Quote to Cash.
• Experience in RICE (Reports, Interfaces, Conversions and Extensions) components.
• Expertise in developing Forms and reports from the scratch.
• Oracle apps production support according to SOX procedures and policies.
• Strong programming experience PL/SQL.
• Result oriented & committed to meet the goal. Experienced in working in tight schedules.
• Strong in interpersonal skills, communication and presentation skills.

TECHNICAL SKILLS

ERP: Oracle Applications 10.7 / 11i / 11x / R12

Technical Modules: Oracle Workflow, AOL, SYSADMIN & Alert

Functional Modules: AP, GL, AR, FA, CM, PO, OM, INV, BOM, MRP, WIP,TCA, HRMS, Payroll, PA, Service, Service Contracts, IRecruitment, IProc, Iexpenses, OLFM / OLM

OS/Environment: Windows-9X, Windows2000/NT, HP UNIX (Sun OS 5.5.1), LINUX

Languages: PL/SQL, SQL*Loader

Databases: Oracle 9i/8i/8.x/7.x/, SQL*PLUS

Front End: Developer 2000 Forms 4.5 / 6i / 10g, Report 4.5 /6i/10g

Oracle Tools & Utilities: Workflow, SQL* Loader, SQL Navigator, TOAD, XML Publisher, Shell Scripting, Discoverer 10g

Internet Tools: HTML, MS Front Page, VB Script, Java Script, JSP, ASP

Case/call management tool: Remedy 5.01,H P Quality Center

Testing tool: Test Director 8.0, Mercury Interactive

Code Migration Tools: Wincvs, pvcs

PROFESSIONAL EXPERIENCE

Confidential, NJ

Principal Consultant

Responsibilities:

• Created Payment Templates for Checks, Wire Recording and ACH.
• Automate Invoice image URL to Invoice’s.
• Modified existing Form changes based on the new requirements.
• Developed new web ADI for AP invoices.
• Developed AP invoice interfaces for new Suppliers.
• Correcting AP invoice interface error’s day to day.
• Helping and correcting reconciliations in GL.
• Creating lot of reports based on client requirements in all financial modules.
• Complete automation in AP Payment system.
• Modified 1099’s as per client requirements.
• Month-end closing and worked various reconciliation reports.

Environment: Oracle 11g, Oracle Applications R12.1.3, Forms 10g, Reports 10g, Shell Scripting

Confidential, New York, NY

Sr Technical Consultant

Responsibilities:

• Production Support for Oracle Financials, Project’s and other custom modules.
• Working on off-shore and onsite model.
• Working on month-end re-consolation issues, bug fixes and enhancements.
• Provided support to end users & internal users on Oracle Financials, Project’s and other custom modules
• Make sure that resolving the production issues with in SLA’s and follow the escalation process.
• Developed Ad hoc Reports requested by client.
• Suggest improvements in process and methodology.
• Worked on PVCS Version Control used for to migrated codes to other instance.
• Key role in Project Management activities.

Environment: Oracle 8.0.2/10g, Oracle Applications 11.5.9/11.5.10, Forms 6i, Reports 6i, Shell Scripting

Confidential, CT

Sr Technical Consultant

Responsibilities:

• Replace mailx command with utl smtp wrapper pl/sql package in all custom reports to sending e-mails to business users for better tracking.
• 135 Custom reports Finance, Manufacturing and Service Contract modules upgrading from 11.5.9 to 11.5.10 and post go-live production support.
• MD070 for Enhancement for Confidential Siebel Sales Order Pre processor
• MD070 for Enhancement for Confidential Siebel Sales Order Post Import
• MD070 for Enhancement for USPS Address Information Form
• Developed Aging 7 buckets sql report data mart inAR.
• Developed Recurring Revenue monthly summary dollars, unit’s reports for senior management in OLFM / OLM.
• Developed Recurring Revenue Service maintenance in Service Contracts.
• Developed Recurring Revenue Rate Change Protection in Service Contracts.
• Developed Recurring Branch, Dealer, COD in Service Contracts.
• Reconciliation of custom ATLAS postage meter equipment database to Oracle Install base.
• Developed Invoice Re-print XML publisher report in AR.
• Worked on various Production Support issues in forms, Reports and Interfaces.
• Worked on PVCS Version Control for to migrated codes to other instances.
• As part process development setup the value sets, profile options, register concurrent programs in AOL.

Environment: Oracle 10g, Oracle Applications R12.1.3, Forms 10g, Reports 10g, Shell Scripting

Confidential, AZ

Sr Oracle Apps Technical Consultant

Responsibilities:

• Involved in the complete life cycle of upgrade project of Oracle E-Business suite applications from 11.5.7 to R12.
• As a part of pre-upgrade process, involved in migrating of Oracle 11.5.7 custom reports, forms,conversions, interfaces, alerts and post go-live production support.
• As part process development setup the value sets, profile options, register concurrent programs in AOL.
• Developing conversions for Credit Card import in AP & Default Task in PA.
• Making changes in 'Existing Default Employee Expenses Accounting' current form in GL.
• Upgraded Custom Forms/Report upgraded 6i to 10g.
• Worked on PVCS Version Control for to migrated codes to other instances.
• Working on production support, bug fixing, testing and enhancements on Iproc, Procure to Pay and Order to Cash.

Environment: Oracle 10g, Oracle Applications R12.0.6, Forms 10g, Reports 10g, Shell Scripting

Confidential, NC

Sr Oracle Apps Technical Consultant

Responsibilities:

• Worked on production support, bug fixing, testing and enhancements on Oracle Financial (GL, AR, AP, FA, CH), Manufacturing Modules (PO,INV, OM, Shipping, Pricing) and HRMS.
• Provided support to internal users for Procure to Pay cycle.
• Enhancements include the existing functionality of forms, reports, interfaces, workflow and XML publisher reports.
• Worked on enhancement of PO Comparison and other HRMS reports.
• Performed SQL tuning using Explain plan.
• Make sure that resolving the production issues with in SLA’s and follow the escalation process.
• Developed Ad hoc Reports requested by client.
• Support and enhancements to PL / Sql packages using XML parser.
• Worked on PVCS Version Control for to migrated codes to other instances.
• Prepared Technical Documents (MD70) and Test Documents (T20).

Environment: Oracle 10g, Oracle Applications 11.5.10, Forms 6.0, Reports 6.0, PVCS

Confidential, CA

Sr Orcle Apps Technical Consultant

Responsibilities:

• Involved in the complete life cycle of upgrade project of Oracle E-Business suite applications from 11.5.9 to 11.5.10.
• As a part of pre-upgrade process, involved in migrating of Oracle 11.5.9 reports and forms and post go-live production support.
• Vertex returns tax information depending Ordered Items & Type, those information updated to Custom & OM tables using Post Calc Package.
• Implemented Custom Sales Tax Breakup Form of the Order Entry screen for Countries: US, CA & APAC.
• Imported open PO’s from legacy system using Import Standard Purchase Order.
• Developed Order Import Error Report in OM
• Developed Purchase Order report, Packing slip report, Custom Open Sales Orders Report (by Customer) report using XML Publisher.
• Import Price Catalogs (Blanket Agreements) Using the Purchasing Documents Open Interface
• Imported Bills and Routing from legacy system using Import Bills & Routings.
• Prepared Technical Documents (MD70) and Test Documents (T20).

Environment: Oracle 10g, Oracle Applications 11.5.10, Forms 6.0, Vertex

Confidential, IN

Sr. Technical Consultant

Responsibilities:

• Imported open PO’s from legacy system using Import Standard Purchase Order.
• Imported open AP Invoice’s from legacy system using Payables Import.
• Imported open AR Invoice’s from legacy system using Auto Invoice Master Import.
• Imported journals in to GL from legacy system using GL Import interface Program.
• Imported Bills and Routing from legacy system using Import Bills & Routings.
• Imported Serialized Items from legacy system using Install Base Open Interface concurrent program.
• Imported ITEM’s from legacy system using item import.
• Custom Open Purchase Orders Report (by Buyer) report developed using XML Publisher.
• Prepared Technical Documents (MD70) and Test Documents (T20).

Environment: Oracle 10g, Oracle Applications R12, Forms 10g

Confidential, CA

Oracle Techno-Functional Lead

Responsibilities:

• Involved extensively in Design, Development and Implementation of Custom Reports, Forms, Workflows and Conversions.
• Developing Generic Packages using PL/SQL to migrate data from Legacy to Oracle Systems (PO, AP Invoice).
• Customized Shipping Module (Independent Shipping System) - Extensively worked on ORACLE APPS 10.7
• Responsible customizing standarad reports in AR, AP, BOM, WIP, PA and writing Custom reports in AR PO, AP using Oracle reports.
• Part of Production Support team working on day to day production issues of 11i Instances.
• Forms Development and Customizations
• Developed Oracle Alerts send the report output to email addresses.
• Added the new functionality Trade Sphere approval process in standard Order Line Workflow:
• Performed SQL tuning using Explain plan.
• Prepared Technical Documents based on Functional Documents.
• Provided support to end users & internal users for Order-to-Cash cycle.
• Make sure that resolving the production issues with in SLA’s and follow the escalation process.
• Developed Ad hoc Reports requested by client.
• Suggest improvements in process and methodology.
• Worked on WINCVS Version Control used for to migrated codes to other instance.
• Key role in Project Management activities.
• Prepared OPS presentations using MINITAB for Seagate high level management.
• Involved in peer discussions

Environment: Oracle 9i, Oracle Applications 11.5.10, Forms 6i, Reports 6i, WINCVS, H P Quality Center

Confidential, WA

Sr. Technical Consultant

Responsibilities:

• Customized Universal Work Queue (UWQ) to add custom node to the queue.
• Developed extensions to create Service Request, Tasks, and Notes in Service module.
• Involved in developing form personalization to the Create Service Request form.
• Developed form to show the service request details associated with the Sales orders.
• Migrated data from legacy systems into AP Invoice interface and gl interface tables.
• Developed WASAU inbound Interface, which is used to receive cash and check payment from customer.
• Developed Vendor Campaign or Recurring Commitment Extract in bound interface, which is used to sending invoice to client before receiving payment.
• Performed SQL tuning using Explain plan
• Preparing Technical Documents based on Functional Documents.
• Post Implementation Support for custom objects.
• Make sure that resolving the production issues with in SLA’s and follow the escalation process.
• Suggest improvements in process and methodology.
• Key role in Project Management activities.

Environment: Oracle 9i, Oracle Applications 11.5.7, Forms 6i, Reports 6i

Confidential

Sr.Technical Consultant

Responsibilities:

• Involved in the complete life cycle of upgrade project of Oracle E-Business suite applications from 11.5.8 to 11.5.10.
• As a part of pre-upgrade process, involved in migrating and retrofitting of Oracle 11.5.8 reports and forms and post go-live production support.
• Developed close to 20 new reports as part of 11.5.10 up gradation project.
• Prepared Unit Test Documents after upgrade.
• Updated Technical documents to adhere with the CEMLI standards.

Environment: Oracle 9i, Oracle Applications 11.5.8/11.5.10, Forms 6i, Reports 6i and workflow 2.5

Confidential, TX

Technical Consultant

Responsibilities:

• Migrated data from legacy systems into AP Invoice and RA interface tables.
• Customized the Aging Seven Buckets, Customer Statement Reports in AR
• Developed Recurring Exception Report in GL
• Developed Daily Rate interface in GL
• Developed Vendor Conversion Program in PO.
• Customized Purchase Order report in PO.
• Customized Sales Order in OM.
• Customized Order Entry Form to match the Business Requirement in OM.
• Performed SQL tuning using Explain plan.
• Preparing Technical & Test Documents based on Functional Documents.

Environment: Oracle 8i, Oracle Applications 11.0.3

Continental, TX

Technical Consultant

Responsibilities:

• Involved in Developing and Customizing Interfaces, Workflows in PA and PO modules.
• Customized standard ‘PA Project Workflow’ according to the client requirements.
• Migrated data from legacy systems into RA interface tables.
• Customized standard ‘Requisition Approval Workflow’ according to the client requirements.
• Extensively worked in tuning the SQL queries using Explain Plan, tkprof and SQL*Trace.
• Involved as a SysAdmin and AOL activities.
• Imported journals in to GL from legacy system using GL Import interface Program.
• Worked on the flowing major Conversions (PO, PO Receipts and SO).
• Prepared Technical & Test Documents based on Functional Documents.

Environment: Oracle 8i, Oracle Applications 11.5.7

Confidential

Oracle DBA

Responsibilities:

• Worked as an Oracle DBA and coordinated with on-site and offshore team.
• Writing stored procedures, functions and triggers.
• Maintaining quality standards.
• Performance tuning.
• Logical backup (import and export).
• Used SQL*Loader utility for data uploads
• Maintenance of different Crown jobs.

Environment: Oracle 8i, Web Logic 6.0