Professional Summary:

• Around 9.4 years experience in Oracle Applications Development, Customization, Extension, Migration and Interfacing.
• Development skill in EBS technical part of Oracle Applications 11i/R12, in Financials and Supply Chain Management Modules GL, AP, AR, OM, PO, INV, FA, BOM, WIP, MRP, I expense and I procurement, HRMS , Advanced Pricing and SLA based projects.
• Expertise in Oracle Database, Developing Packages, Procedures, Functions, Packages Database Triggers by using PL/ SQL.
• Experience in Oracle EBS R12 application, Oracle EBS 11i application, BI Publisher -XML Reports and Oracle 9iAS discoverer Reports.
• Having experience as a Technical consultant Order to Cash flow, Procure to pay flow, Shipping, Oracle Cost Accounting, Pricing, Inventory flows, Oracle Manufacturing ,Oracle Distributions e-Business Suite module standard API's applications with Understanding of AIM Methodology and involved in creating technical deliverables like MD70, MD120, etc.
• Worked on experience in Implementation/Support projects and worked on RICE Components.
• Worked in SDLC life cycle for Oracle Applications Development, Customization, Extension, Migration and Interfacing.
• Having Experience in Implementation/Support projects for order to cash and procure to pay cycle as Technical consultant /techno-functional consultant/analyst.
• Experience in Development and customization of Oracle Reports 10g/9i/6i and Oracle Forms 10g/9i/6i
• Expertise in full suite of Oracle Tools including SQL Loader, TOAD, SQL Plus, SQL Developer and Developer 2000/6i/9i/10g and experience with Oracle 10g database
• Experience in Sys Admin and Application Object Library AOL for registration of Forms, Reports, Concurrent Programs and Menus.
• Experience in extending core applications through custom development of new Forms
• Forms Personalization and Custom PLL.
• I was using the API's for Conversions. and interfaces
• Experience with software development AIM methodologies and processes using testing methods
• Strong interpersonal, analytical and communication skills, proven ability as an efficient team member in System Analysis, Design, Development, Migrating and documentation.

Area of expertise:

• Oracle Applications Sys Admin, AOL, Application Developer, Oracle Alerts, XML
• Bi Publisher AP, AR, GL, OM, PO, INV, BOM, WIP, IExpence. Knowledge of Oracle Implementation Methodology AIM
• Application Tools Reports 6i, Forms 6i, Developer 2000, 9i, 10g.
• Databases Oracle 8i/9i/10g
• Database Tools Toad, SQL Loader,Workflow2.5.,PL/SQL Developer, oracle discoverer reports, SQL PLUS, SQL Developer ,Edit Plus, Kintana tool, lotus notes, VSS,PVCS, Remady, Service now tool, Secure FTP and Oracle Reports 6i/9i/10g, packaging tools such as Clear Case, Clear Quest.
• Scripting Languages Unix Shell scripts,
• Languages/Packages SQL, PL/SQL, D2K Forms, Reports,
• Operating Systems Sun Solaris 8.x/9.x, HP/UX 11/10.2, Linux, Windows
• XP/2000/NT

Projects Experience

Confidential

Oracle apps consultant

Development of Custom solution and Integration with Oracle Modules

This is integration project and I am involved in Design and Development of custom solution for oracle e-Business Suites EBS order management, Inventory, purchase order and involved in support of General ledger, account Payables.

Responsibilities:

• Involved in fixed assets interface creation from source system to oracle e business suites
• Working on SVN tool for Change management process.
• Involved in writing packages, procedure ,trigger and functions.
• Involved in Requirement Analysis and Client Interaction. This involves analyzing MD50 Functional Spec and writing MD70 Technical Spec
• Working on OM, PO, AP supplier conversions.
• Interacted with the user group on a regular basis to discuss requirements and updates.
• Involved in AOL activities.

Environment: Oracle Applications 11i, FA, AP, GL, AR, SQL, PL/SQL, SQL Loader, Oracle, Reports, Win SCP, Putty, UNIX, TOAD, Windows XP, Oracle alerts, AIM methodology..

Confidential

Oracle apps consultant

Responsibilities:

• Involved in fixed assets interface creation from JDE system to oracle e business suites. Fixing the interface issues.
• Working on STAT tool for Change management process.
• Involved in Requirement Analysis and Client Interaction. This involves analyzing MD50 Functional Spec and writing MD70 Technical Spec
• Working on order Management conversions.
• Worked on AP supplier interface.
• Interacted with the user group on a regular basis to discuss requirements and updates.
• Involved in Account Payable interface for integration of JDE systems.
• Involved in AOL activities.

Environment: Oracle Applications 11i, FA, AP, GL, AR, SQL, PL/SQL, SQL Loader, Oracle, Reports, Win SCP, Putty, UNIX, TOAD, Windows XP, Oracle alerts, AIM methodology..

Confidential

Oracle apps consultant

Responsibilities:

• Involved in Order management interface creation. Writing database trigger, function, procedure and packages.
• Worked on New Gates Price Schedule form, Gates Special form, and Gates Default form creation from scratch.
• Worked on Service Contracts, Installed Base modules for client for customized process
• Involved in handling OM interfaces and reports issues for client for customized process.
• Fixing the interface issues in order management.
• Involved in Requirement Analysis and Client Interaction. This involves analyzing MD50 Functional Spec and then writing MD70 Technical Spec
• Designed the High-level document and strategy for development and implementation of solution.
• Interacted with the user group on a regular basis to discuss requirements and updates.
• Involved in registering the Forms, Functions, Menus, Responsibilities, Concurrent programs Reports.
• Involved in Peer review, unit testing of objects creating a ldt files for concurrent programs.
• Helped create PL/SQL programs to create sales order using order import program Interfaces.
• Worked with software development methodologies. Testing with available data by using testing Methods.

Environment: Oracle Applications R12/11i, INV, SQL, PL/SQL, SQL Loader, Oracle, Reports, Forms, UNIX, TOAD, Windows XP, XML Publisher, Oracle alerts, AIM methodology..

Confidential

Oracle apps consultant

Responsibilities:

• I was supporting the Oracle Inventory, Order management, Oracle iProcurement, I expense, Oracle Purchasing, Oracle Payables issues for clear wire project.
• Worked on open po conversion and receipt conversion.
• Involved in GL accounting setup issues for troubleshooting AP in voice payments Process.
• Involved in handling GL, AP, interfaces and reports issues for client for customized process.
• Handling the costing module issues in service now tool.
• Involved in supporting the issues/incidents on Service Contracts, Installed Base, order management and Inventory modules.
• Handling AP invoice attachment issues, AP invoice payment related incidents in service now tool.
• Handling the Discoverer report issue and resolved.
• Involved in Requirement Analysis and Client Interaction. This involves analyzing MD50 Functional Spec and then writing MD70 Technical Spec
• Designed the High-level document and strategy for development and implementation of solution.
• Interacted with the user group on a regular basis to discuss requirements and updates.
• Extensively used AOL and System Administrator modules for Registering Application, Forms, Functions, Menus, Responsibilities, Concurrent programs Reports.
• Implemented form level security so that certain users don't have access to some features.
• Coordinated in creation of various reports using Oracle Reports and XML Publisher.
• Helped create PL/SQL programs to create items using Open Interfaces.
• Worked with software development methodologies. Testing with available data by using testing Methods.
• Created TAR with oracle support and worked towards resolving critical issues.
• Daily Updates on Open incident assigned to me or Offshore.
• Monitoring the incidents raised by the Clearwire users using the Service now tool.
• Investigation and resolution of the incidents based on the priority of the issue.
• Also working on Change request and fixing it with required changes it.
• Handling Data-Fix Requests and involved in data fix migration process from offshore.
• Root cause analysis of repeated issues.
• Updating the daily incident tracker on share points.
• Analyzing/ Replicating the issue in SUPPORT and DEV instance for all incidents
• Creating DATA Fix and testing into SUPPORT and DEV instance.
• Follow up On Change request and taking all the required sign off.
• Creating the Step Document or Process Document for onshore.

Environment: Oracle Applications 11i, INV, SQL, PL/SQL, SQL Loader, Oracle, Reports, Forms, UNIX, TOAD, Windows XP, XML Publisher, AIM methodology.

Confidential

Responsibilities:

• Involved in Requirement Analysis and Client Interaction. This involves analyzing MD50 Functional Spec and then writing MD70 Technical Spec , Unit test plan.
• Created new form to insert, update and view budget data.
• Customized the Sales order form to reflect the budget details.
• Used PL/SQL to define and manipulate database tables.
• Interacted with the user group on a regular basis to discuss requirements and updates.
• Designed, developed and tested Oracle PL/SQL packages, stored procedures, functions and triggers to track the budgets, return orders, at the order level and the line level.
• Used AOL and System Administrator modules for Registration of Developed and Customized reports.
• Tested the functionality and involved in resolving issues, bug and code fixes.

Environment: Oracle Applications R12, Order Management, Oracle Inventory, SQL, PL/SQL, Oracle Forms, UNIX, TOAD, Windows XP.