PROFILE 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 R12/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 knowledge 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 knowledge 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 knowledge of Oracle Apps Data model and how to leverage the data for effective 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 help 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/4i,XML 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

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 Acknowledgement(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

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.
• Gathered 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.OAF Responsibilities:
• 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

Consultant

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. This 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 sameDeveloped 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 have 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…Reports
• 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.