SUMMARY

• Having 12+ Years of experience in the areas of analysis, design and development of Oracle Applications 11i and R12 Financial and Supply Chain Management Modules
• Good Technical Development skills with hands on working experience on RICE Components in the domain of Oracle Applications E - Business Suite(EBS) using SQL, PL/SQL Developer.
• Extensive experience with analysis, design, development, customization and implementation of ERP Oracle applications (Oracle Account Receivables, Oracle Order Management, Oracle Purchasing, Oracle Payables, Oracle General Ledger, Fixed Assets, Inventory, Oracle Service contracts).
• Proficient in analysing and translating business requirements to technical requirements and architecture
• Involved in Full Life Cycle Implementations and Support of Oracle Applications.
• Worked on Forms Personalization.
• Worked on P2P and O2C cycle.
• Expertise in Developing Procedures, Functions, Packages and Triggers in PL/SQL.
• Experience in Inbound Data Migration using SQL*Loader and Outbound Interface using UTL FILE package.
• Good knowledge in Development of XML Reports.
• Good exposure to Oracle Application Implementation Methodology (AIM 3.0).
• Experience with Oracle and other Utilities: TOAD, SQL Developer, PL/SQL Developer and SSH client.
• Used advanced PL/SQL features like PL/SQL tables, records, Bulk collect, Pragmas for error handling and cursors for data processing.
• Proficiency in understanding client business needs, handling the issues and assisted users in implementing oracle applications according to the requirements.

TECHNICAL SKILLS

Applications: Oracle Applications (R12/11i)

Technologies: SQL, PL/SQL, Workflow, Oracle Forms and Reports and XML Publisher

Modules: AP, AR, INV, FA, PO, OM and GL

RDBMS: Oracle 9i, 10g, 11g

Tools: & Utilities: SQL*Loader, SQL*Plus, TOAD, WinSCP and Putty

GUI: 10g Developer Suite, Workflow Builder

PROFESSIONAL EXPERIENCE

Oracle EBS Developer

Confidential

Responsibilities:

• Analyzing and understanding business requirements.
• Discussions with Customers for gathering the requirements and impact analysis
• Developing design documents for each customized object.
• Working on the system integration and production issues.
• Creating new service contracts and renewing the existing contracts based on the request from customer service management team (CSM)
• Provide IT fixes and solutions for the issues faced in contracts creation, PO and invoice creation.
• Developing the custom business objects.
• Activating contracts in R12 and Smart client. Create or modify the IB records based on requirements
• Coordinating with CSM team through smart cases and updating the work logs in the smart cases until closure.
• Configuration of Systems/Instances either manually or using WebADI tool in Install Base.

Environment: Oracle AppsR12, SQL, PL/ SQL and 12c Data base.

Confidential, Chicago

Senior Oracle EBS Developer

Responsibilities:

• Working closely with the functional consultants to understand the requirements and design feasible solutions accordingly.
• Technical consultant for modules like AP, AR, INV, OM. Developing/Customizing interfaces, XML reports, Conversions for various modules as per business requirement
• Worked on Closing Out AR Converted Transactions in OMAR and creating Credit Memos.
• Preparation of Technical Documentation as well as development for the new enhancements.
• Worked on USA Export license hold enhancement in Order Management
• Worked on enhancement to send AR Invoices to Denmark Government from Greenfield system.
• Handled Procurement Conversions (ASL, SR, SR Assignment)
• Worked on Configuration of the Sourcing module - Setting up the supplier, Supplier Communications
• Worked on the Setups of the Professional Buyer work center in Oracle Purchasing.
• Worked on the i-Supplier portal setups - defining the supplier registration process, supplier creation and approval process etc,.
• Testing of the customized component (TCS Testing Methodology).This is done by running the business case scenario in Production clone instances so that there are no issues faced by the business users in the production instance.
• Involved in the design and development of Interface program in Oracle Account Receivables to import Invoices from Legacy to EBS

Environment: Oracle AppsR12, SQL, PL/ SQL, and 11g Data base.

Confidential

Oracle Senior Developer

Responsibilities:

• Developed the outbound Interface to extract open Invoices in Account Receivables.
• Developed the Item On-hand quantity Interface.
• Data Migration from the existing 11i system to Oracle EBS R12.
• Worked on AR Transaction interface to load data from legacy system.
• Used SQL*Loader as an ETL tool to load data into the staging tables.
• Prepared the Unit Test Plan Documents
• Prepared Technical (MD 070), UTP, Installation (MD 120) Documents.

Environment: Oracle Apps11i and R12, SQL, PL/ SQL, Oracle 9i and 11g Data base.

Confidential

Technical Developer

Responsibilities:

• Development/Enhancement of the Oracle interface PL/SQL packages for loading the data from external files into oracle applications database.
• Data Migration from the existing 11i system to Oracle EBS R12
• Developed interface programs in AP, AR, GL modules
• Developed XML publisher reports.
• Involved in the Analysis, Design, Coding and Testing of the application.

Environment: Oracle Apps11i and R12, SQL, PL/ SQL, Oracle 9i and 11g Data base.

Confidential

Oracle Senior Developer

Responsibilities:

• Worked on GL interface to import the Journals data from Legacy to Oracle Applications GL base tables using the standard program ‘Journal Import’.
• Developed Supplier Outbound Interface
• Developed AR Invoice Outbound Interface.
• Developed Inventory Item Outbound Interface.
• Worked on Form Personalization to add concurrent program to the oracle applications front end in the actions button.
• Designed and developed rtf for the AR credit balance reports.
• Conversion of data from source system to target system for INV, AP, AR from 11i & custom legacy systems.

Environment: Oracle Apps11i and R12, SQL, PL/ SQL, Oracle 9i and 11g Data base.