SUMMARY

• Over 6+ years of experience in Oracle Applications Implementation, Customization and Supporting Projects.
• Expertise includes customization and testing of applications involving Oracle Applications Financial Modules Order Management, Payables, Accounts Receivable, General Ledger, Purchase Order and Cash Management.
• Good knowledge in AOL modules like System Administrator and Application Developer in registering concurrent programs, forms, functions, menus, reports and creating value sets, DFF’s, profile options, printers in providing support to Business Users in resolving technical issues.
• Worked on 24*7 environments to provide production support
• Experienced in Loading Customers Data using Oracle TCA Api’s.
• Responsible for understanding and analyzing RICE (Reports, Interfaces, Conversions, Extensions) Component Methodologies.
• Experience in Developing and customizing Reports using Reports 10g, XML Publisher
• Expertise in Customizing Oracle Forms with Forms Personalization, Custom.pll, Template.fmb on Forms 6i.
• Good understanding and working experience P2P and O2C cycles.
• Strong programming knowledge in creating Procedures, Functions, Packages, Triggers, Cursors and other database objects using SQL, PL/SQL.
• Wrote Technical Documentation Specifications like MD070.
• Good programming knowledge in Oracle 10g/11g and pl/sql using TOAD, SQL * plus, SQL Developer and also having good knowledge in Shell Scripts.
• Good debugging skills and good at using Exceptions and Error Handling.
• Good at Performance tuning using EXPLAIN PLAN and TK Prof Tool.
• Strong Analytical, Diagnostic and Troubleshooting skills and ability to work in a dynamic, team - oriented environment. Worked as a single point of contact for Reporting projects.

TECHNICAL SKILLS

ERP Modules: Oracle Applications R12, 11.5.10, (OM, AR, PO, AP, GL, Inv, CE)

Database: Oracle 11g/10g/9i/8i.

Tools: Developer 2000/10g(Forms, Reports),Discoverer 10g/9i/4i, XML Publisher, TOAD, SQL * Loader.

Utilities: Secure CRT, Winscp, FileZilla, Putty.

Languages: SQL, PL/SQL, Shell Scripts, C, JAVA, HTML and XML

Operating Systems: UNIX, Windows 7.

PROFESSIONAL EXPERIENCE

Confidential, Collierville, TN

Techno Functional consultant

Responsibilities:

• Worked on Auto Invoicing to import Invoices from legacy systems into Oracle Receivables (AR).
• Worked on various inbound & outbound interfaces for AR and GL modules.
• Interfaced with business users to prepare and update Business Process Requirements (BPR) and Software System Requirements (SSR). Created test cases and test scripts.
• Worked extensively in preparing Technical Design Documents MD 070 based on the Functional Requirements.
• Ensured all artifacts complied with corporate SDLC Policies and guidelines.
• Responsible for the Design and co-ordination with the Applications Development team for data conversions, interfaces and data extraction.
• Extensively worked on Importing the Invoice data from Various Legacy systems
• Conduct System / Integration tests on configured Oracle applications system and custom built reports, interfaces, extensions, etc.
• Worked on 24*7 environment to provide production support
• Worked with QA team to design test plan and test cases for User Acceptance Testing (UAT).
• Responsible for loading the Customer Bank Account Details into Oracle Cash Management Tables.
• Developed PL SQL Packages, Procedures, Triggers, Types, Table Types and database objects in the design process to load Customer Details into Stage Tables.
• Prepare unit test plans for RICE objects.
• Bug fixing working extensively with Oracle for Service Requests.TAR resolution on demand & priority basis.
• Tracked & resolved application issues during testing phase through Oracle support, suggested workarounds and analyzed the patch requirements
• Process analysis and design. Maintaining the versions of code and documents using Subversion.
• Used FNDLOAD to move request sets, concurrent programs, lookups and value sets across instances.
• Liaised with business and functional owner during risk engineering and high-level review sessions to derive and execute action plans, meeting deadlines and standards.
• Developed queries and views for reporting.

Environment: Oracle Apps R12, GL, AR, TCA, CE, Alert Manager, Oracle 11g, SQL, PL/SQL, TOAD, UNIX, XML Publisher, Main Frames, SOAP UI Web Services.

Confidential, LOS ANGELES

Oracle Applications Developer

Responsibilities:

• Designing and developing Customer Workbench Form to enter and maintain the Customer Address as well as Contact Information of Customer, as well as creating a custom DFF on custom form.
• Designing and developing Sales Order Header Zoom Form to enter and maintain the Contact Details of the Ordered Person as well as Order Details.
• Involved in importing Customers from legacy system to Oracle base tables using SQL * Loader and API’s.
• By using SQL * Loader program the data from third party source was moved to base tables with the help of staging tables and also API’s.
• Experienced in moving data from legacy system to oracle base tables using XML Gateway.
• Expertise in using UTL FILE Package in moving data from legacy system to Oracle Base tables.
• Designing and Developing RICE Components according to the requirement.
• Worked on workflows in doing customizations in sending Message notifications.
• Designing and Developing of AP Selected Invoices Report using Reports6i and XML Publisher.
• Having a good knowledge on oracle e-business suit EBS.
• Extensively involved in developing Technical Design Documents (MD70) using Application Implementation Methodology (AIM)

Environment: Oracle Applications 11.5.10 (AR, OM, INV, AP, OKC, CSI), Windows, Unix, Window NT, Oracle 9i, Reports 6i, Forms 6i, Discoverer 10g, TOAD, SQL*Loader, PL/SQL, SQL* Plus and XML publisher.