SUMMARY:

• 13 years of IT industry experience encompassing a wide range of skill set, roles and industry verticals.
• Proficient experience with Payables (AP), General Ledger (GL), Account Receivable(AR), Cash Management, Oracle Purchasing, iProcurement, Order Management (OM), Inventory, Bill of Material(BOM), Work In Process(WIP) and iStore modules.
• Expertise in Oracle SQL Plus, PL/SQL, Oracle Application Framework(OAF), Oracle Forms6i and Oracle Reports6i, BI Publisher with Burst functionality, Oracle performance management and Workflow.
• Strong Experience in data conversions and migrations using Interface tables and APIs from Feeder and Legacy systems to Oracle Application 11i and R12 suite.
• Worked in various Onsite - Offshore model projects. Worked as onsite and offshore lead. Lead and managed a team of 15+ members.
• Ability to lead and facilitate cross-functional teams to deliver complex projects in 11i and R12.
• Proven expertise in Sourcing Rule, Advanced Pricing, Purchasing Hierarchy AND Oracle Approval Management (AME).
• Extensively used TCA (Trading Community Architecture) to create suppliers.
• Involved in development of RICE components using SQL, PL/SQL, Developer 2000, BI Publisher as per Oracle Applications coding/ Customization/ User Interface standards and Coding techniques in Oracle Applications.
• Strong technical skills and extensive experience in Oracle Application AOL objects, Oracle PLSQL, Oracle BI Publisher, OAF, Oracle forms and Reports, including debugging and fine tuning of PLSQL Programs.
• Developed test scenarios and performed functional testing and documented test results.
• Excellent interpersonal, communication skills and understanding of Business applications. Willing to take up challenging assignments and interested to work in all kinds of modules and emerging technologies.

TECHNICAL SKILLS:

Version: Oracle Apps 11.5.8 to 12.1.3

Oracle Apps Modules: Oracle Payables(AP), General Ledger(GL), Account Receivables(AR), Cash management, Oracle Purchasing, iProcurement, Order Management(OM), Inventory, Manufacturing - MRP, BOM, WIP, Oracle iStore

Reporting Tools: BI Publisher and Developer 2000

Application Tool: JDeveloper and Workflow

Languages: Oracle PL/SQL

Version Control and Migration Tools: Kintana and PVCS

PROFESSIONAL EXPERIENCE

Confidential

Oracle Application Consultant

Environment - Oracle Payables, Cash Management, General Ledger (GL), Oracle Purchasing, and Oracle iProcurement.

Responsibilities:

• Responsible and owner for Purchasing, iProcurement, Payables Modules and developed various objects in Purchasing, Payable modules.
• Involved in design and development of oracle general ledger (GL) outbound interface with external system - HFM.
• Involved in design and development of oracle general ledger (GL) inbound interface with source system - Blackline.
• Involved in design and development of oracle payable (AP) inbound interface program to import data from source system for two suppliers - CINTAS and Good Year.
• Involved in design and development of oracle application framework (OAF) page to display and process the new supplier data for smart form refund process.
• Involved in oracle application framework extension and personalization.
• Involved in design and development of smart form check request report dat sends purchase requisition PDF copy along with attachment in the mail. The report is implemented through BI publisher with BI bursting technology and oracle BLOB conversion functionality.
• Involved and resolved field users’ iProcurement access issue and configuration setup.
• Involved in iProcurement approval hierarchy setup and resolved approval hierarchy issue due to wrong approval management (AME) setup.
• Involved in oracle user form personalization and disabled many critical fields but enabled only password reset field for helpdesk support team.
• Involved in Registration/Migration of concurrent program, executable, Creation of Responsibility, request Group, Menu, value set, Request Set, Forms, Functions in System Administration and AOL.
• Prepare the custom functional design document and user guide for all new custom projects and changes.
• Involved in all functional and technical production support L1, L2 and L3 activities and resolved the issue through tickets.

Confidential

Lead and Technical Consultant

Environment - Account Payables (AP), Account Receivables (AR), General Ledger (GL), Cash Management, Manufacturing, Order management, Purchase Order, Inventory, Oracle Sales and Marketing, and custom modules (MSM, BBB) in 12.1.1

Responsibilities:

• Extensively involved in migration project from the version 11.5.10 to 12.1.1, own and tested the oracle purchasing, order management modules for AKT application.
• Fit gap analysis based on the client requirement and R12 functionality change.
• Functional setups in the R12 instances during the build activities.
• Retrofitting of existing RICE components to R12.
• Involved in design, development and testing of outbound interface finance transaction data of AP, AR and GL with SAP application.
• Involved in design, development and testing of new custom Quotation report.
• Involved in design, development and testing of custom forms such as Quote Analysis form, Award Approval form for MSM custom module.
• Involved in design, development and testing of auto sourcing rule creation program and auto population of discrete job attribute values dat populated when user releases the DJ from MRP workbench.
• Prepare the custom functional design document and user guide for all the new custom application and enhancements.
• Perform month end inventory period, purchasing period, and general ledger period closure activities for SGP organization.
• Perform all the costing activities such as standard cost rollup, interim cost update and BOR rollup activities.
• Involved in all functional production support L1, L2 and L3 activities and resolved the issue through tickets.
• Involved and completed functional testing of DRP every year.

Confidential

Offshore Team Leader (Techno-Functional)

Responsibilities:

• Implemented inbound and outbound interfaces from order management to external application and vice versa.
• Implemented inbound order import interface from external applications.
• Implemented master item and customer data conversion.
• Designed and developed many custom reports in Oracle order management for order tracking.
• Designed and configured oracle iStore for each customer.
• Designed and configured oracle CRM for customer relationship among buyer, vendor and factory.
• Prepared functional and technical design documents and user guide for each new iStore customer site.

Confidential

Offshore Technical Leader

Responsibilities:

• Involved in development of Inline upgrade application interfaces and DRM application interfaces.
• Development of custom API’s to call Process order API to create RMA order and applying Receipt for the respective RMA order.
• Developed a new program to end date pricing lines.
• Technical design for data interface with the customer for RMA- Receipt program.
• Walkthrough with the business users on RMA order process.
• Coordination to migrate the code to test cycles using Kintana migration tool.
• Involved in bug fixes during test cycles.