SUMMARY:

• Oracle certified professional with 11 years of professional experience in the IT Industry serving various clients in the area of Financial, Manufacturing, Distribution and Supply Chain as Oracle Applications Technical Consultant.
• Expert in Oracle Development Tools, Technologies and Oracle E - Business Suite (Oracle Applications) RICE components in Oracle Applications release’s 11.5.10, 12.0.6 & 12.1.3.
• Worked extensively in Oracle Applications R12/11i implementation, enhancement & customization of various modules including PO, FA, PA, AP,OM, INV, OPM, AR and HRMS.
• Strong working knowledge of Procure-to-Pay (P2P) and Order-to-Cash (O2C) along with the dependencies and relationships between Oracle Applications modules.
• Sound knowledge on Systems Integration, Interfaces and Conversions between Oracle Applications and legacy systems, Customizations and Development of RICE Components
• Skilled in XML Publisher, Oracle Reports, Discoverer Reports, Oracle Forms, Conversion and Interface Development.
• Skilled in Oracle Database Programming with Queries, Triggers, Stored procedures and PLSQL packages.
• Proficient in Application System Administration activities like creating concurrent programs, application user setup, defining responsibilities, values sets, registering menus, forms, reports, providing support to users on technical issues.
• Proficient in Database design and SQL Performance Tuning.
• Proficient in using tools such as Kintana, PVCS, TOAD, SQL Developer etc.
• Detail oriented with an analytical bent of mind and a positive attitude and a team player with strong planning, organisational, relationship management and communication skills.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, XML

Databases: Oracle 9i, Oracle 10g, Oracle 11g

Operating Systems: Windows 2000/NT/XP/7, MS-DOS, Linux

Tools: BI Publisher, Reports 6i/10g, Discoverer 10g/11g, Forms 6i/10g, Toad, SQL Developer, SQL Loader, Kintana, PVCS

Oracle Applications: Purchasing, iProcurement, Fixed Assets, Project Accounting, Accounts Payables, Order Management, Inventory, Process Manufacturing, Discrete Manufacturing, Accounts Receivables, Human Resources Management System

PROFESSIONAL EXPERIENCE:

Confidential

Application Developer

Responsibilities:

• Involved in testing IP/PO process as part of R12.1.3 upgrade in PO module.
• Involved in Retrofitting the RICE components in R12.1.3 with existing customizations from R12.0.6.
• Developed Oracle Discoverer Reports in PO and FA modules.
• Developed Reports with bursting feature using BI Publisher.
• Customised standard Oracle Reports.
• Developed Inbound and Outbound Interfaces enabling transfer of data between Oracle Apps and external systems.
• Developed PO Conversion for Mexico Implementation.
• Developed several extensions using PL/SQL for PO module.
• Worked on Oracle Form customizations involving custom.pll
• Developed Custom Form to update FA categories.
• Handled bug fixes in Oracle Reports and Discoverer Reports.
• Developed one time data fixes.
• Monitor and Update Oracle SR.
• Analyse and recommend important and critical patches.

Environment: Oracle Apps 12.1.3, SQL, PL/SQL, Oracle 11g, Forms 10g, Reports 10g, Discoverer 11g, BI Publisher 5.6.3, Kintana, PVCS

Confidential

Technical Lead

Responsibilities:

• Customized the AP Trial Balance Report.
• Customized AP Invoice Aging Report
• Customized AP Prepayment Status Report
• Developed Sales Contract Workbench Report for Oracle CRM users in Discoverer
• Developed Return Order Report
• Developed Purchasing Price History Report
• Developed Sales Order Attachments Report
• Developed OPM MFG Analysis Report
• Handled Oracle Form Personalization’s
• Handled Bug fixes in Oracle Forms and Reports
• Handled several change requests in custom Discoverer reports and custom DB objects such as packages.
• Solved day-to-day technical issues and provided solutions to tickets logged in by users in Track IT system

Environment: Oracle Apps 11.5.10, SQL, PL/SQL, Forms 6i, Reports 6i, Discoverer 10g,TOAD

Confidential

Technical Lead

Responsibilities:

• I was involved for short term in this production support project and handled the following objects
• Personalized the pricing modifiers form in Order Management to restrict the duplication of date range in the modifiers.
• Personalized the Sales Order form in Order Management to apply pricing hold on sales order’s where the customer price in the DFF does not match with the unit selling price in the SO lines.

Environment: Oracle Apps 11.5.10, SQL, PL/SQL, Sql Developer

Confidential

Technical Team Lead

Responsibilities:

• Handle financial period closing on every monthly, quarterly, half yearly and annually.
• Actively involved in creation of new objects according to the business needs like Procedures, Functions and Packages using PL/SQL.
• Handle the technical aspects of TAR raised by functional team.
• Solve day-to-day technical issues and provide solutions to tickets logged in by users in Siebel CRM Helpdesk system
• Created Interface to update order types of customers in BILL TO sites.
• Development of Discoverer Reports
• Invoice on Hold
• Invoice Date Detail / Summary Report.
• Invoices paid within terms and delinquent payments
• Aging Outstanding Invoice
• Discounts Taken / Lost
• Purchase Order Entity Report
• Withholding Tax Report
• Invoice Vendor Tax Detail report
• Development / Customization of Oracle Reports
• Aging 4 and 7 buckets report.
• Receiving Account Distribution Report
• PR / PO Approval Cycle Time Reports
• Receiving Value Report.
• Customer Statement of Account.
• Invoice Aging Report
• Customization of XML Reports
• Un-invoiced Receipts Report
• Unified Packing Slip
• Unified Commercial Invoice
• Developed RTF templates for invoices in different languages.

Environment: Oracle Apps R12, Forms 10g, Reports 10g, Discoverer 10g, SQL, PL/SQL, TOAD

Confidential

Technical Consultant

Responsibilities:

• Developed to calculate the cost and usage of materials involved in each project by manipulation of data from AP,PO and Inventory modules.
• Developed to calculate the attrition percentage of the organization.
• Developed to capture the request of the employee seeking transfer.
• Assets Retirement Register.
• Developed to list and calculate the profit and loss through the assets retired from the organization.
• Developed to capture the every day mortality count of chicks starting from hatch date, the reason for mortality of each chick, cumulative mortality, feed received by farm from feed mill or other farms, feed transferred to other farms, feed consumption of the farm and current stock of feed in the farm.
• Developed as item master for broiler medicine.
• Developed to capture the actual feed consumption of chicks with respect to formula consumption.
• Developed to track materials from one form to another.
• Developed to calculate the capacity of farms and their utilization.
• Developed to track materials for which receipt has been made but not delivered to Inventory.
• Move Immediate Report
• Developed to Identify the summary of item values moved from one warehouse to another.

Environment: 11.5.10, SQL, PL/SQL, Forms 6i, Reports 6i, TOAD

Confidential

Technical Consultant

Responsibilities:

• Export Proforma Invoice
• Developed to serve as invoice to foreign customers.
• Export Spare Order Confirmation
• Developed to confirm orders from customers.
• Domestic Spare Offer
• Developed to Invoice for domestic customers.
• Domestic Spare Order Confirmation.
• Developed as Order Acceptance for domestic customers.
• Internal Sale Order
• Developed for inter department sales transactions.
• Domestic Spare Declaration and Insurance Coverage
• Developed as declaration and insurance report for shipping the goods.
• Internal DC
• Developed for inter-departmental delivery of goods.
• Domestic Spare DC
• Developed for shipping delivery of spares to domestic customers.

Confidential

Responsibilities:

• Kit Shortage Report
• Developed to find the shortage of materials while work in process.

Confidential

Responsibilities:

• Material Shortage against Confidential Report
• Developed to find the shortage of materials against Confidential .
• Return to Vendor DC
• Developed for delivery of rejected items to vendors.
• Return to Vendor Invoice
• Developed to invoice back the rejected materials back to vendor for which excise is applicable.
• 57F4 Challan Report
• Developed to outsource manufacturing of spares to outside vendors while raw materials are provided which involve excise duty.
• Move Order Report
• Developed to request materials from stores.
• Control Summary
• Developed to calculate the issues and receipts sub inventory wise for each organisation.

Environment: 11.5.10, SQL, PL/SQL, Forms 6i, Reports 6i, TOAD