SUMMARY

• Over 8 years of Professional experience on Oracle Applications as an Oracle Applications Techno - Functional consultant, which includes project management, effort and time estimation, project scheduling and monitoring with emphasis on ensuring timely deliverables.
• Extensive experience in customization, implementation, maintenance and support of Enterprise Business Applications using Oracle R 12/11.5.10/11.5.8/11.0.6 e-Business Suite.
• Conversant in implementing OM (Order Management Advanced Pricing), Manufacturing (INV, WIP, BOM), PO (Oracle Purchasing), Oracle Financials (GL, AP, AR, FA, PA), and AOL (Application Object Library).
• Proficient in functional noledge of Order to Cash, Procure to Pay and Financial business processes withOrder-to-Cash(O2C), Procure-to-Pay(P2P)
• Experience in designing, developing, implementing and customizing RICE (Reports, Interfaces, Conversions and Extensions) Components.
• Well versed with client server environment and tools like SQL*Plus, PL/SQL, SQL*Loader, Toad, Oracle*Forms, Oracle*Reports, Workflow, Discoverer and modified the formats using XML publisher for customizations as per client specifications.
• Technical expertise in AOL concepts like Concurrent Programs, Request Sets, Flex Fields, Registration of forms, tables and columns. Creating users, menus, form functions, responsibilities and function security.
• Experience testing Conversions, Interfaces, Data Migration, Customization, configuration, and functionality checks for ERP implementations.
• Technical Experience in custom form development, Zoom functionality, Custom.pll and Form personalization
• Developed many reports and also convert many seeded RDF reports in to XML-publisher reports.
• Good in writing Stored procedures, Packages, Triggers and functions using SQL, PL/SQL and Performance Tuning of SQL queries, and using SQL*Loader
• Experienced in Registering of Custom Applications/Table/Schemas in Oracle Applications.
• Proven track record in implementing and upgrading technical teams in conversions and customization of Financial Applications, modifying standard Reports/creating custom Reports, Discoverer installation and custom views.
• Solid working noledge in analyzing and understanding the source/existing/legacy system business functionality and preparing the functional and Technical Design Documents(MD50, MD70, MD120) using AIM Methodologies.
• Experience in all phases of the Software development life cycle (SDLC) in an ERP environment.
• Thorough noledge of Oracle Apps Data model and how to leverage the data for TEMPeffective reporting.
• Involved in all stages of development with strong implementation skills spanning Full life cycle implementations and production support.
• Excellent work ethics and interpersonal skills that halp in communicating with the fellow team members, Managers, Developers and Users.
• Ability to learn and adapt to new technologies, good team player in dynamic work group environments and also self motivated to work independently with excellent communication skills.

TECHNICAL SKILLS

ERP/Modules: OM, AP, PO, AR, GL,AOL,INV,WIP,BOM,MRP, CTO (Configure to Order)

Processes: Order to Cash and Procure to pay processes

Programming Languages: C, JAVA, SQL, PL/SQL, HTML,UNIX SHELL SCRIPTING

Development Tools: Forms 10g/6i, Reports 10g/6i, Workflow Builder 2.6, Discoverer 10g/4iXML Publisher (BI Reports),OAF,ADF,appLOAD

Database: Oracle 8i/9i/10g, SQL,MS Access

Operating System: Windows 98/NT/2000/XP, UNIX,MS-DOS

Programming Tools: SQL*PLUS, SQL* Loader, TOAD9.0, Putty

Office Tools: MS PowerPoint, MS Word, MS Excel

PROFESSIONAL EXPERIENCE

Confidential, NC

Oracle Apps Consultant

Environment: Oracle Applications R12 Upgradation/Implementation (OM, Advanced Pricing, AR, PO, INV), Oracle 10g, SQL, PL/SQL, Oracle Forms, Oracle Reports, XML Publisher Reporting, Forms Personalization, TOAD, UNIX Shell Scripting, appLOAD.

Responsibilities:

• Involved in conversion program to validate the data from legacy system to Oracle Apps R12 for different modules like Accounts Payables (AP), Accounts Payables Invoices Conversion, Customer Conversion and Purchase Order (PO) Conversion, Sales Order (SO), Pricing information before loading them into Base Tables using appLOAD tool.
• Involved in Customer Outbound Interface conversion from Legacy System (Billing) into Oracle Account Receivables by using Customer Interface.
• Developed Quote Printing templates such as Quote Print to display the Quote lines, Price Adjustments information in the format as required by user and Customized to generate PDF output. Removed Quoting document using HTML in 11i and generated output using XML Publisher in R12.
• Extensive experience with pricing engine and pricing modifiers in OM. Performed changes Custom Mapped Pricing Attributes for multiple promotional discounts as per client’s requirement.
• Worked on OM Processing Constriants.
• Developed various reports in OM and Advanced Pricing like Sales Order Backlog Report, Sales Order Acnoledgement(SOA) Report, Proforma Invoice Report, Return Material Authorization (RMA) report. Created custom templates with Data Definitions for XML Publisher and Developed reports using reports 10g and registered as XML Publisher reports in applications.
• Designed and Developed the Sales Order Conversion to load historical orders and regular orders in OE from Seibel. The Updated Orders will be updated back in oracle through the interfaces.
• Extensive experience identifying product gaps coordinated with development team by creating TAR SR and obtained one-off fixes. Managed and monitored SR TARs for several P1 issues.
• Developed Error correction forms in OM, PO and AR so that the end users can reprocess the errors directly through the form
• Designed and Developed Outbound Programs for orders and shipping, which picks data based on released status

Confidential, Atlanta, GA

Techno Functional Consultant

Environment: Oracle Applications 11i Implementation (PO, INV, OM, WIP, BOM), Oracle 10g, SQL, PL/SQL, Oracle Forms, Oracle Reports, XML Publisher Reporting, Forms Personalization, TOAD, UNIX Shell Scripting.

Responsibilities:

• Involved in Creation and Customization of Order Entry, Order Booking, Reservation, Pick Release, Pick Confirm, Ship Confirm, Enter Invoice and Close order in Order to Cash (OTC) cycle.
• Converted a Discrete Job Pick List report in to XML Publisher report and made the item number in to Barcode to enable reading by hand held devices.
• Gatheird requirements and developed WFS Order Entry RMA Report
• Set up Email Alerts for pick release holds.
• Developed Unshipped Items Report.
• Designed a report to display Back Ordered Item Detail Report with Customer Name, Date From and Date To etc as parameters.
• Developed a concurrent program for doing mass update of resources like time used in the BOM or WIP.
• Customized and modified the existing forms using Form builder according to the requirement of the Business user.
• Customized forms using Forms Personalization techniques.
• Designed and developed highly complex Quote Build page using OAF Sub-tab layout, Advanced Table, LOV, Show/Hide regions.
• Developed custom OA Framework pages using OAF components like: LOV, Show/Hide Region, Advanced Table, Simple Search Region.
• Developed custom business logic in BC4J components like View Objects (VO), View Links (VL), Entity Objects (EO) and Application modules (AM) using JDeveloper.
• Developed and deployed OA extensions involving VO, EO and Nested AM substitutions.

Confidential, CA

Oracle Apps Consultant

Environment: Oracle Applications R12 Upgradation/Implementation (PO, AP, INV, OM, WIP, BOM, Service Contracts, Installed Base, Advanced Pricing), Oracle 10g, SQL, PL/SQL, Oracle Forms, Oracle Reports, XML Publisher Reporting, Forms Personalization, TOAD, UNIX Shell Scripting.

Responsibilities:

• Developed a concurrent program to load data for new cost types and cost elements for the Items.
• Developed a concurrent program for doing mass update of resources like time used in the BOM or WIP.
• Developed, implemented and unit tested AP Invoice interface. dis involved importing data from the legacy system into staging tables using SQL Loader, validating the data using PL/SQL procedure, inserting data into interface tables and running the invoice import concurrent program to load the data into oracle AP tables.
• Working on Interfaces and conversions for Oracle E-Business (11.10, R12) for AP, PO, OM, INV and other modules.
• Worked on several API’s for interface and conversions of the same
• Developed Reports using XML Publisher (BI Reports) Reporting Tool:
• Customized existing custom Oracle reports to replace plain text output to PDF format using XML Publisher. Worked on XML Publisher bursting to send PDF reports via email.
• Customized the Auto-Commercial invoice report and converted in to XML Publisher report.
• Customized the pick slip report in to a XML publisher report and also converting the things like Delivery number, Picking-Batch number in to Bar codes.
• Modified all the reports like pick slips to has bar code on them so that we can use mobile hand held devices to read the report.
• Customized the pick slip report to change the sort order from item number to sub-inventory.
• Converted many of the oracle seeded reports in to XML Publisher reports.
• Designed many XML publisher reports with features like bar codes, logos etc
• Designed and developed a report to summarize back orders and lost sales as per business requirements.
• Involved in determining the reasons for error records Order import interface and fixed them some common errors will be like wrong tax rate, Customer not present in system etc
• Prepared a report for all open sales orders by customer.
• Prepared a report that checks inventory before release of sales order.
• Designed a report to display Back Ordered Item Detail Report with Customer Name, Date From and Date To etc as parameters.
• Designed report to check for inventory before pick release of sales orders.

Confidential, NC

Oracle Apps Consultant

Environment: Oracle Applications R12 Implementation (PO, INV, AP, AR, Advanced Collections and GL), Oracle 10g, SQL, PL/SQL, Oracle Forms, Oracle Reports, XML Publisher Reporting,OAF Forms Personalization, TOAD, UNIX Shell Scripting.

Responsibilities:

• Customers using TCA API’s in AR Module.
• Invoices using Invoice Interface in AR Module.
• Receipts using Auto Lockbox in AR Module
• Orders in OM Module
• Items and Item Categories using Item Interface in INV Module.
• Involved in Creation and Customization of Order Entry, Order Booking, Pick Release, Pick Confirm, Ship Confirm, Enter Invoice and Close order in Order to Cash (OTC) cycle.
• Org Name:-Ability to has org name populated as default.
• Template Name:-Adding Items in Item Master. Display default value
• Cancelled Requisitions:-How to copy cancelled requisitions.
• Developed new Forms as per Client requirement in Custom modules.
• Customized Existing forms as per client requirement.
• Customized Purchase order form by using CUSTOM.pll
• Performed functional analysis for the Multi org setup.
• Developed reports for sending weekly report to the particular Vendor by email attachment. Developed Shell Script and custom Package to achieve dis requirement.
• Preparing Day to Day code migration scripts to migrate the custom code to one instance to another instance using SHELL Scripts.
• Preparing MD70, MD120 using AIM Methodology.
• Handling the enhancements due to change in business rules.
• Creating one-time reports and ad-hoc SQL queries.
• Customizing of standard forms to meet user requirements.
• Resolving production issues logged by users.

Confidential, Birmingham, AL

Oracle Apps Consultant

Environment: Oracle Applications 11.5.10, Oracle 9i, AR, OM, INV, AP, PO, PL/SQL, SQL * plus, TOAD, Oracle Forms 6i, Oracle Reports 6i, Oracle XML Publisher.

Responsibilities:

• Purchase Order Details
• SCM Purchase Request Log
• AP Summary Cash Requirements
• AP Detailed Cash Requirements
• Invoice on Hold Report
• Purchase Order for Modifications
• Customization of Distribution set listing Report.
• Payables Accounting Entries Report
• Developed PO and AP Analysis Report
• AR All Invoice aging report By Date
• Development components
• Customization of seeded Aging 7 & 4 Bucket reports.
• Customized seed Payables posted invoice register Data template report for London & Singapore.
• Developed new Aging report for TCE to show customer balance for 12 periods based on as of date.
• Customized seeded Commercial & Pack Slip Reports.
• Linking Sub ledgers with GL using xla (sub ledger account tables) tables.
• Developed 26 different rtf’s templates (XML reports) for AR invoice report & many others
• Custom Min Max Report Program
• Create new custom Item Types
• Enable Descriptive Flexfields for holding min and max qty
• Wrote a PL/SQL program to get the min max setting at the item type level
• Wrote SQL statements to get quantity on hand, what TEMPhas been ordered, how many are at requisition
• Created requisition interface record for replenishment
• Customized PO Approval workflow PO Module
• Customized AP Approval workflow in AP Module
• Porting custom reports from 11.0.3 to R12.
• Development of new custom reports (XML reports) for sites based on requirements.
• Customized seeded XML & Data template reports.
• Gathering requirements from different sites BA’s & end users.
• Preparation of technical design doc’s and
• Managing offshore team. .
• Day to day monitoring of Concurrent programs.
• Handling the enhancements due to change in business rules.
• Creating one-time reports and ad-hoc SQL queries.
• Customizing of standard forms to meet user requirements.
• Analysis of all scenarios/paths an order line can go through, and issues that may occur during the full lifecycle of a purchase order.
• Resolving production issues logged by users.

Confidential, San Jose, CA

Oracle Apps Techno Functional Consultant

Environment: Oracle Applications 11i PO, INV, iProcurement, GL, AP, HR, SQL*Loader, SQL*PLUS, TOAD, Reports 6i, Workflows, UNIX Shell Scripts

Responsibilities:

• Developed Custom Item create Interface program to populate the Items, revisions, categories, cross-references information.
• Developed Custom Item Update Interface program to populate the Items, revisions, categories, cross-references information.
• Developed Custom program to interface PO’s in PO Module
• Developed Purchase order Interface to upload the STANDARD Purchase order transactions into the Oracle apps Base tables.
• Developed Requisitions Open Interface to upload the Requisitions transactions into the Oracle apps Base tables.
• Developed custom outbound interface for New Hire Report to report Virgina state Government by-weekly by FTP in HRMS Module.
• Developed Custom outbound Interface to send the APNACH file to the Bank by FTP for Employee Expense Direct Deposit in AP Module.
• Developed Material On-hand Quantity Interface to transfer the Material Transactions information into Legacy Flat file.
• Developed Custom outbound Interface to send the Invoices file to third party system in AP Module.
• Developed Custom outbound Interface to send the Payments file to third party system in AP Module.
• Customized Project Expense Report Account Generator in iExpense Module to populate the Account for Direct Projects
• Customized PO Account Generator Workflow to generate Accrual, Variance and Encumbrance Accounts
• Customized PO Requisition Account Generator Workflow to generate Accrual, Variance and Encumbrance Accounts
• Reconciliation Reports for Item Interface, Requisitions Interface, PO Interface, Invoice Interface, Payments Interface
• Resolving the issues which are getting from the clients.
• Developing Reports, Customization of Reports and Developing of Interfaces.
• Testing the resolved objects and preparing the quality documents.

Confidential

Oracle Apps Developer

Environment: Oracle Applications 11i, Oracle 9i, AP, OM, INV, BOM, WIP, Shipping, Reports 6i, Forms 6i, Toad, Discoverer Reports, Windows NT.

Responsibilities:

• Locators and On Hand Quantities in WIP Module.
• Bank and Accounts Information for Employee Direct Deposit in AP Module.
• Suppliers and Supplier Sites in AP Module.
• Developed Custom program to convert Routing, Item Cost in Costing Module
• Created Month End Parts ordered report
• Created Business Area’s for the Requested Report.
• Created Folders and setup joins between folders. user security and privileges at business area level
• Created Work books based on the Business area.
• Assign the workbooks to the requested responsibility.
• Periodic backups of EUL and Export, Import of Business Areas from one instance to another
• It contains Part number, requisition number, po number, list price by Period
• It compares with budget figure in GL based on Expense Account on PO Line Distributions
• Used FND LOAD utility to migrate concurrent programs, value sets, Concurrent Managers, Context-Sensitive DFF, Profile Options, Form Personalization’s etc.
• Used Data Load utility to load key flex field segment values data.
• Developed technical documentations of work done complying with AIM Methodologies.
• Test the report in different instances
• Developed Bug fixed for each call.
• Develop the Technical design document
• Fixing Bugs and Changes.
• Prepare all the quality documents

Confidential

Oracle PL/SQL Developer

Environment: Oracle 8i, SQL, PL/SQL, Developer 2000, Forms 4.5, Reports 2.5, SQL*Loader, HP UNIX, Windows 2000/NT

Responsibilities:

• Developed Procedures & Functions to check validity & integrity of data.
• Create views to extract data from base tables & publish the data to the end users.
• Used Built-in Packages provided by oracle for debugging.
• Reviewing / Testing Procedures & Functions developed by the team members.
• Creating SQL Scripts to monitor the discrepancy database and resolve the discrepancies.
• Developed/Modified Shell scripts to regulate batch jobs.
• Creating test data and load it into database to verify the functionality of procedure & functions.
• Migrated the data from external files into Database tables using SQL *Loader.
• Extensively involved in performance and tuning of all SQL and PL/SQL code.
• Wrote Procedures, Functions and SQL Loader scripts.
• Developed Database objects like Views, Materialized Views, Indexes, Sequences, and Synonyms.
• Involved in Designing and development of Enquiry & Application submission modules
• Using oracle Forms and generated custom reports.
• Created Database Triggers to populate tables for Reference data and Exposure data.
• Created PL/SQL Packages for easier application design and improved Performance.