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 (SCM)
• 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 11i and R12.
• Worked on Forms Personalization.
• Worked on P2P and O2C R12 cycles.
• 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 Publisher Reports.
• Experience in Application Object Library (AOL) for registration of Forms, Reports, Concurrent Programs and oracle API’s.
• 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

Confidential, Chicago

Oracle EBS Developer

Responsibilities:

• Analyzing and understanding business requirements.
• Discussions with Customers for gathering the requirements and impact analysis
• Worked on Closing Out AR Converted Transactions in OMAR and creating Credit Memos in GF.
• Handled Service Contract Conversions.
• Worked on creation of Custom QA Checks
• 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.
• Worked on Supplier Registration and Supplier user registration.
• 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 (SCM and Finance modules), SQL, PL/ SQL and 12c Data base.

Confidential

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.
• 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,.
• Involved in the design and development of Interface program in Oracle Account Receivables to import Invoices from Legacy to EBS

Environment: Oracle AppsR12 (SCM and Finance modules), 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.
• UsedSQL*Loaderas 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(Finance), 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.

Confidential

Oracle Developer

Responsibilities:

• Analysis of functionality flow in business scenario.
• Gathering Information from client and various tools like QC, Doors.
• Confidential Test Script development for given business scenario in AP, AR, GL, CM, PO and INV modules
• Functional review of test scripts developed by other peers.
• Client liaison for functional flows.

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

Confidential

Techno-Functional Consultant

Responsibilities:

• Change Request analysis, including Impact Analysis, Development of new customizations and changes to existing customizations.
• Developed and customized of BI Publisher Reports.
• To aid in enhancements for production & to perform the fitment analysis for any change with-in the design of any component
• Developed Interfaces for Customer Import and AR, AP, GL and PO interfaces.
• Prepared the Unit Test Plan Documents
• Prepared Technical(MD 070), UTP, Installation(MD 120) Documents.

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

Confidential

Technical Consultant

Responsibilities:

• Providing production support on CRM.
• Developed and maintained shell scripts.
• Interfacing with end users to identify functional and d technical issues and Incident resolution
• Customer Interface to move the Customer address to one organization to another organization.
• Writing PL/SQL code and Designing Data fix scripts using Standard API’s
• Writing Code fixes to remove bugs in e-business modules (membership, renewals and reminders).
• Providing the quick solution for urgent issues.
• Designing Technical Documents for the implemented data and code fixes

Environment: Oracle Apps11i, SQL, PL/ SQL and Oracle 9i Data base