SUMMARY

• Over 13+ years of IT experience including Analysis, Design, development, Conversion, Interfaces, implementation and upgradation of Oracle Applications R11i/11.0.x, SQL, PL/SQL, Oracle 10g/9i/8i, Forms6i and Reports 6i.
• 12+ years of experience in Project Implementation/Maintenance experience in Order to Cash Flow.
• 11+ years of experience in Finance systems analysis, solution design and deployment using Oracle applications.
• 12+ years of experience in Experience working with Oracle Financials release 11i and Release 12.
• 11+ years of experience in SQL, PL/SQL, TOAD, XML.
• Highly proficient in technical aspects of Oracle Applications namely Customizations, Interfaces or data Conversions.
• Expertise in Cross Functional Knowledge and Support process for Finance and Manufacturing Business Applications.
• Expertise in supporting the Quarter end and Month End closure process for Financial and Supply Chain modules
• Extensive experience in Form personalization.
• Work experience in OA Frameworks, SOA, Business Process Execution Language (BPEL)
• Expertise in integrations with Oracle Application Systems.
• Extensive experience in developing Interface/Conversion Programs to import data from various sources into Oracle Applications using PL/SQL, SQL*Loader, UTL file etc.
• Extensive Experience with AOL to develop Flex fields, Value sets, Forms, Reports, Concurrent programs and Menus into Oracle Applications.
• Proficiency in Oracle Applications Implementation Methodology (AIM).
• Extensive knowledge on workflow customization.
• Extensive experience in developing Oracle Forms, XML Publisher and Oracle Reports.
• Extensive experience customization of Forms and Reports.
• Extensive experience in PL/SQL Procedures, Functions, Packages and Database Triggers.
• Ability to interact effectively with clients, Understanding their requirements and providing optimum solution and support.

TECHNICAL SKILLS

ERP environment: Oracle Applications 11.5.8,11.5.9,11.5.10.2,R12

ERP Modules: Inventory, Order Management, Receivables, Payables, Cash Management, General Ledger, iProcurement, Purchasing, Install Base, Service Contracts, Oracle Pricing, Oracle Manufacturing, iExpense.

Front End tools: Forms 6i, Reports 6i, Remedy, Sabrix, Discoverer, Workflow 2.6,Kintana, XML Publisher

Databases: Oracle 8i/9i/10g/11g

Languages: SQL, PL/SQL, Java

PROFESSIONAL EXPERIENCE

Confidential - Sunnyvale CA

Oracle Apps Techno Functional Consultant

Responsibilities:

• Involved in analyzing the functional documents and solution design for Quote to Order Flow.
• Involved to prepare the MD-070/CV-060 documents (For Reports, Interfaces, Forms and Extensions).
• Define to-be solutions using Oracle 11i standard functionality and identify RICE requirements.
• Review the MD70 technical Solution Document with offshore for building the code.
• Responsible for the delivery of the solution, support and fix the issues from the development to the deployment of code in production.
• Supported Issues during UAT and QA testing.
• Involved in completed End-to-End testing right from Siebel Quote to Oracle Invoice.
• Involved in the design and development of the following.
• Conversion design - Extract the data from 11.5.9 and create .csv file using UTL File.
• Conversions from Oracle Applications 11.5.9 to R12: Item, Bom, Contact Conversion
• Interfaces between 11.5.9 and R12:Item,ECO
• Modified the Existing Custom Program Software Licensing, Custom.pll, header and the line zoom form to the Everest Requirements.

Environment: Oracle Apps 11.5.9Modules: OM, AR, BOM, Pricing

Confidential - Sunnyvale CA

Oracle Apps Techno Functional Consultant

Responsibilities:

• Provided secures Web communications and accelerates business applications across the distributed enterprise.
• Involved in the complete life cycle implementation of Blue Store project.
• Involved in developing the Order Import interface package to create sales order from blue store portal
• As part of blue store implementation involved in Functional design process and Technical design process and documentation of process.
• Involved in the Pricing Qualifiers and Modifiers setup.
• Involved in customization of Sales order Line Workflow process as part of eFulfillment process
• Involved in customizing the Sales order header workflow process to close the order header for every 8 hrs
• Developed XML Publisher reports, alerts, concurrent programs as part of enhancement requests and blue store project
• Involved in supporting the day to day production issues and analyzing the root cause of the issues.
• Developed programs to send out the notifications using UTL SMTP package.
• Involved in supporting the month-end and quarter-end period closing activities.
• Designed and developed programs for the enhancement requests.
• Extensive knowledge on OM Sales orders Drop ship process.
• Designed and developed the email address validation through personalization
• Extensively worked on INV, OM, PO, AP and AR modules.
• Involved in the implementation of iExpense AME module.
• Involved in Setup and development of Payment formats as part of APAC roll-out.
• Involved in code review process to ensure the Blue Coat coding standards are followed.

Environment: Oracle Apps 11.5.10.2 Modules: OM, AR, INV, BOM, WIP, PO, OM, AR, AP, iExpense

Confidential - Sunnyvale CA

Oracle Applications Techno Functional Consultant

Responsibilities:

• Implemented Oracle Applications Financial modules in 11.5.9 and upgrading the Applications to 11.5.10.
• Developed interface program to send the AR balances to Siebel
• Involved in fixing the bugs and testing the business process in upgradation project
• Developed Alert to send the notification to the AP team once the payment batch is formatted.
• Involved in fixing the production issues.

Environment: Oracle Apps 11.5.9, 11.5.10 Modules: AR, AP and GL

Confidential - Sunnyvale, CA

Oracle Applications Techno Functional Consultant

Responsibilities:

• Oracle Payments(Setting up new PPR via Payment Administrator)
• Receivables(Setting up Lockbox, Transmission formats, Banks, Supplier and Supplier Sites)
• Cash Management (Setting up Bank Transaction Codes, Bank Statement Mapping)
• Providing support to the Customer during User Acceptance Testing
• Training End Uses on the payments, receipt application and Reconciliation integration with oracle apps.
• Single point of contact for Product Support
• Product maintenance and bug fixes on Oracle
• Design, implement and support Product enhancements.

Environment: Oracle Apps 11i/R12 Modules: AR, AP, CM

Confidential - Liberty Lake, WA

Oracle Apps Technical Consultant

Responsibilities:

• Worked in Journal Import Interface converting of legacy data in to Oracle Applications involves using of PL/SQL package and Shell Script.
• SQL * Loader was used to load data into custom tables.
• Interfaced legacy system GL data using Journal Import.
• Involved in Building Customizations and Enhancement using Reports and Forms
• Customize Pick Slip and Open Purchase order reports.
• Responsible for developing a custom program to make all the Confidential products as ‘RoHS’ compliance
• Developed Custom Interface to import vendor’s information from legacy system to Oracle Application.
• Developed a new interface program for Item and BOM conversion.

Environment: Oracle Apps 11.5.8 Modules: OM, INV, BOM, AR, GL

Confidential - Winchester, VA

Oracle Apps Technical Consultant

Responsibilities:

• Worked on Order Management and Inventory modules in Mainframes (CICS) system.
• They wish to migrate from CICS to Oracle Applications 11.5.9.
• It’s a full cycle implementation of OM and INV modules in Oracle Applications 11.5.9
• Designed and developed Item Interfaces, BOM and AP interface programs.
• Worked on Invoice Report, Bill of Lading report, Pick Slip report and other custom reports.
• Responsible for Level 1 support for supporting the production system after the go-live date
• Worked on customizing the Order to Cash cycle and developed some custom forms for EDI transactions.
• Involved in preparing the test scripts and conducting CRP’s
• Created forms and reports using Oracle Forms and oracle Reports, Database triggers using PL/SQL..
• Worked with functional experts to implement their functional knowledge into working Procedures.
• Involved in complete life cycle of testing e.g., Unit Testing, Integration Testing, System Testing and User Acceptance Testing.

Environment: Oracle Apps 11.5.9 Modules: OM, INV

Confidential

Oracle Apps Developer

Responsibilities:

• Delivers products and services for data protection, storage and server management, high availability and application performance management.
• Veritas migrated Oracle ERP Applications from Release 11.0.3 to 11.5.9 as a re-implementation process.
• Developed Customer API using TCA architecture.
• This is a public API that can be called from any sources that require to perform customer related operations in Oracle ERP.
• Developed VERITAS VIP Update Customer Product Program that will be used to update pricing attribute 32 in purchase base (install base).
• This update is done to keep the InstallBase Pricing Attribute 32 in sync with the Current VIP Agreement Level
• Developed custom reports as per the enhancement requests.
• Involved in production support after the post go-live.

Environment: Oracle Apps 11.5.8 Modules: AR, OM, INV, Service Contracts, Install Base

Confidential

Oracle Apps Developer

Responsibilities:

• Worked on project involves Oracle Applications 11i implementation of Payroll and Human Resources Modules.
• Created Interface to extract Employee Data along with Payroll Deductions and create a Flat file which would be sent to Legacy System
• Developed Conversion Programs for the following entities Employee, Addresses, Phones, Contacts, Assignments, Element Entries.
• Developed a custom report to display all active employees and termination employees from previous period.
• Developed a custom report which will provide the information on employee gross earnings and hours worked.

Environment: Oracle Apps 11.5.8 Modules: HRMS, Payroll

Confidential

Oracle Developer

Responsibilities:

• Performed Data conversions for General Ledger, Accounts Receivables, Accounts Payables and Inventory into Oracle Applications
• Followed the upgrade process and interface development standards.
• Developed custom form and report in AR.
• Based on the value selected in the form the custom reports customer detailed/summary will be triggered.
• The custom Report will show the customer sum of balances and sales amount
• Creation of primary, foreign key, constraints and relationships with the existing tables.
• Creating stored procedures, Packages, Triggers in the database level and form level
• Creating Validations in the form module. Creating messages and alerts.
• Creating and using property classes, Object groups and libraries, and adding functionality.

Environment: Oracle 8i, Oracle Forms 6i and Reports 6i