SUMMARY:

• Having 14 years of diversified Technical & Functional expertise in Oracle Applications R12/11i, with extensive exposure in Design, Development, Configuration, Implementations, Production Support and Upgrades in Financial, Supply Chain, and Manufacturing & HRMS/Payroll/Benefit Modules.
• Proficient in all phases of Oracle Applications R12/11i implementation with major focus in Financials (GL, AR, AP, CM, SLA, FAH), Oracle Supply Chain & Manufacturing Modules (INV, OM, Advance Pricing, Shipping, PO, WIP), Oracle HRMS & Payroll, AOL, and System Administration module.
• Extensive experience in design and development of Oracle application framework, Oracle SOA Suite 11g & 12c, Oracle BPEL Process manager, Oracle Reports, BI/XML Publisher Reports, Oracle Apps Forms, Interfaces, Conversions, Extensions, Workflow, Unix Shell Scripts, form Customizations, Custom.PLL, Forms Personalization and all other RICE objects to meet customer requirements in Fresh Implementation and Production Support projects of Oracle Applications.
• Extensive experience with PL/SQL & SQL.
• Experience working on SQL*Loader, SQL* Plus.
• Prepared the Technical Specification documents, Functional Specification documents, Test scripts, Data conversion documents, Report requirement, Configuration documents & Sysadmin setup documents
• Worked on Documentation using AIM methodology for Technical Design Documents (MD70), Functional Design Documents (MD50), Installation Documents (MD120), Business Requirements Setups (BR100), Conversion Mappings (CV40) and Conversion Test Plans (CV70).
• Experience in preparing Test Plan, Unit Testing, System Integration Testing and Documentation. Provided support all through SIT (System Integration Testing) and UAT (User Acceptance Testing).
• Experience in Order to Cash (O2C) and Procure to Pay (P2P) business flows.
• Proficiency in understanding client’s needs and generate, modify existing data in Oracle Applications according to the requirements and specifications.
• Confidential , Co - ordination and team skills. Well organized with excellent leadership skills and commitment to deliver on schedule.
• Experience in creating, managing and resolving TAR/SR (Technical Assistant Request or Service Request) with Oracle Support. Managed and monitored TAR’s for several P1 issues.
• Experience in Application System Administration activities like managing concurrent managers, application user setup, defining responsibilities, values set, flex fields, registering menus, forms, reports, concurrent programs, and printers, providing support to apps users for any technical issues.
• Worked with Offshore Technical team on Development, Testing and Migration of Objects.
• Experience in month end closing activities in Finance.
• Hands on experience in troubleshooting issues and resolving tickets on priority.
• Provided technical and functional support with day-to-day management of incident, problem, knowledge and change management for assigned applications and technologies.
• Experience in monitoring the system and track the issues, fix and escalate them as per the client policies.

TECHNICAL SKILLS:

ERP: Oracle Applications R12, 11i

EBusiness Suite Modules: AP, AR, GL, CM, SLA, FAH, FA, PO, SYSADMIN, INV, OM, PO, HRMS, Payroll/Benefit, OIC

RDBMS: Oracle 12c, 11g, 10g, 9i, 8i

LINUX, Sun: Solaris, Unix, Windows 9X/2K/XP

Languages: SQL, PL/SQL, C, C++, Java

Tools: & Utilities: Oracle application framework(OAF), Oracle SOA Suite 12c/11g, Oracle BPEL process manager, Forms 10g/6i, Reports 10g/6i, XML/BI Publisher, SQL*Plus, SQL*Loader, Oracle Workflow Builder, TOAD, SQL Developer, JDeveloper, MS Visio, Data Loader, WEBADI, DATALOAD, WINSCP, Putty, SecureCRT, SecureFX, Perforce, BMC Remedy, HP Quality center, Appworx, Sharepoint, Microsoft word, excel, PowerPoint

Documentation: AIM Documentation (MD070, MD120, MD050, BR100, CV60, CV40)

PROFESSIONAL EXPERIENCE:

Confidential, Collierville TN

Oracle Apps Techno Functional Consultant

Responsibilities:

• Worked on OAF form development, customization and personalization.
• Worked on Oracle SOA suite 12c/11g and developed web services.
• Deals in Oracle BPEL Process Manager Development.
• Worked on design, development, support and customization of RICEW in (GL, AP, OM, INV, PO, HRMS, Payroll and Benefits) modules.
• Worked on SQL and PLSQL.
• Worked on inbound and outbound interfaces.
• Worked on Vendor Prepayment OAF forms development and Workflow Approval process.
• Worked on Product Registration renewal Process development.
• Worked on design and development of HR Employee/Assignment/Address inbound import interface.
• Developed outbound interfaces for New Hire, W4, W2, Tax, Direct deposit & Payroll data.
• Worked on design and development of AP Vendor Prepayment OAF forms and Approval workflow.
• Worked on design and development of Product Load OAF Page and item import from Monsanto to Oracle EBS.
• Worked on design and development of Cigna HR and Benefit from Oracle HR to Cigna.
• Worked on design and development of custom prepay approval hierarchy setup form.
• Worked on oracle form personalization.
• Worked on various Oracle Report/ BI publisher reports development and customization.
• Provided support to issues related to WEBADI.
• Worked on performance tuning of existing custom interfaces.
• Worked on MD050 and MD070 documents.
• Deals in key flex filed and descriptive flex field.
• Support, enhancement and bug fixes of custom interfaces.
• Unit testing of the object developed.

Environment: Oracle Applications R12.1.3 (HRMS, Payroll, Benefit, INV, OM, PO, AP, AR, GL, AOL, SYS ADMIN ), Oracle Database 12c/11g, PL/SQL, SQL, Oracle Forms 10g, Oracle Reports 10g, BI Publisher, Toad, SQL Developer, BMC Remedy.

Confidential, Salt Lake City, UT

Oracle Apps Techno Functional Consultant

Responsibilities:

• Worked on support and enhancement of RICEW in OM, INV, and WIP modules.
• Worked on SQL and PLSQL.
• Worked on inbound and outbound interfaces.
• Worked on design and development of Inventory ONHAND custom conversion.
• Worked on design and development of WIP Work Order custom conversion.
• Worked on design and development of Copy Supplier Site custom conversion.
• Worked on design and development of custom integration (Inbound & Outbound) between mobile application and Oracle R12 by calling web services.
• Worked on custom form development for IR/MD.
• Worked on oracle form personalization.
• Deals in key flex filed and descriptive flex field.
• Support, enhancement and bug fixes of custom interfaces.
• Unit testing of the object developed.

Environment: Oracle Applications R12.1.3 ( INV, OM, PO, BOM, WIP, AP, AR, GL, AOL, SYS ADMIN ), Oracle Database 12c/11g, PL/SQL, SQL, Oracle Forms 10g, Oracle Reports 10g, BI Publisher, Toad, SQL Developer, BMC Remedy.

Confidential, Columbus, IN

Oracle Apps Techno Functional SME

Responsibilities:

• Worked on support and enhancement of RICEW in Financial (AR, AP, GL, and CM) modules.
• Worked on configuration in R12 EBS financial modules.
• Worked on root cause analysis of various production issues.
• Worked on SQL and PLSQL. Deals in inbound and outbound interfaces.
• Worked on Oracle Report/ BI publisher report support and fix.
• Worked on MD050 and MD070 documents.
• Deals in key flex filed and descriptive flex field.
• Deals in WEBADI & DATALOAD.
• Support and enhancement and bug fixes of custom interfaces.
• Worked with Oracle on production support issues related to financial modules.
• Worked with Oracle support to resolve the complex issues in production over the period end.

Oracle Applications R12.1.3 ( INV, OM, PO, AP, AR, GL, AOL, SYS ADMIN ), Oracle Database 11g, PL/SQL, SQL, Oracle Forms 10g, Oracle Reports 10g, BI Publisher, Toad, SQL Developer, BMC Remedy, APPWORX.

Confidential, Madison, WI

Oracle Apps Techno Functional Consultant

Responsibilities:

• Created functional design document (MD050) for custom Interfaces for GL and FAH.
• Created technical design document (MD070) for custom Interfaces for GL and FAH.
• Worked on GL Journal import interface.
• Worked on custom PL/SQL API package development and writing SQL scripts.
• Worked on Customization of BI publisher reports.
• Configuring Oracle R12 General Ledger in Oracle EBS.
• Worked on SLA & FAH configuration in R12 EBS.
• Created BR100 (Config document) document for Oracle EBS R12 GL, SLA & FAH.
• Configuring Key Flex field and Descriptive Flex field.
• Worked on the troubleshooting of functional and Technical issues.

Oracle Applications R12.1.3 (GL, FAH, SLA, AOL, SYS ADMIN ), Oracle Database 11g, PL/SQL, Oracle Forms 10g, Oracle Reports 10g, BI Publisher, SQL Developer, BMC Remedy.

Confidential, Dallas, TX

Oracle Apps Techno Functional Consultant

Responsibilities:

• Created CV200 mapping documents for Oracle Apps Data conversion for AR and Contract.
• Created functional design document (MD050) for AR customer conversion.
• Worked on WEBADI & DATALOAD.
• Created technical design document (MD070) for AR customer conversion.
• Written test cases for AR customer creation/updating interface testing.
• Worked on BI Publisher Reports and Oracle Reports.
• Worked on custom PL/SQL API package development and writing SQL scripts.
• Worked on functional and technical design document for custom forms GUI.
• Functional design document for Service contract inbound interface.
• Written test cases for service contract creation interface testing.
• Created legacy to EBS mapping documents for Customer and Contracts.
• Configuring Key Flex field and Descriptive Flex field.
• Resolved technical issues related to Reports (RDF & BI Publisher).

Oracle Applications R12.1.3 (AR, Service Contracts, TCA, AOL, SYS ADMIN ), Oracle Database 11g, PL/SQL, SQL, Oracle Forms 10g, Oracle Reports 10g, BI Publisher, SQL Developer.

Confidential

Oracle Apps Techno Functional Consultant

Responsibilities:

• Worked on AR invoice, AR Customer, AR receipt, GL Journal Inbound Interfaces development and support.
• Cash Management interfaces for various third party legacy systems to Oracle EBS12 for Westpac, ANZ & Commonwealth bank.
• Custom PL/SQL package development and writing SQL scripts.
• Oracle Reports and BI Publisher report development and enhancement.
• Updating Functional Design documents for any redesign/enhancements.
• Any issues/setting up Key Flex field and Descriptive Flex field.
• Any Technical issues related to Interface (Inbound & Outbound).
• Any Technical issues related to Reports (RDF & XML Publisher).
• FAH integration of underwriting systems EVOLVE, TRAVEL, AOPCICS & CTPCICS to General Ledger.
• Created various Data Load scripts across Oracle Apps modules which were re-used.
• Worked on various config issues during development and UAT and their resolution.
• Writing Test scripts and Test scenarios in Oracle Financials.
• Coordinated with clients and offshore team members to gather requirements and facilitate the development.
• Worked on various issues related to WEBADI.
• Worked on the workflow customization.
• Responsible for support & maintenance of AP, GL, SLA, AR, CM, AGIS, FAH and FA.
• Worked on resolving production support issues and work on development activities related to Oracle modules.
• Support and maintenance of various legacy interfaces to Oracle Apps.
• Supporting solving Day-to-Day End - User problems.
• Analysis of the Problem/Issue Reported on Remedy Toll and Suggesting Solutions.
• Reporting to PM on the status of the Remedy Tickets.
• Raising SR to Oracle for Critical Issue Solution.

Oracle Applications R12.1.3 & 11.5.10 (AR, AP, GL, FA, FAH, SLA, CM, AOL, SYS ADMIN ), Oracle Database 10g, SQL, PL/SQL, Oracle Forms 10g, Oracle Reports 10g, BI Publisher, Oracle Workflow, SQL Developer, BMC Remedy.

Confidential

Oracle Apps Techno Functional Consultant

Responsibilities:

• Extensively worked on migration of GL, SLA, AP & AR & CM, OM, and Advance pricing & Shipping custom interfaces during oracle financials upgrade.
• Extensively worked on migration of custom Oracle reports & BI publisher reports during oracle financials upgrade.
• Extensively worked on the Technical design documents (MD070) while upgrading from 11i to R12
• Extensively worked on the Functional design documents (MD050) while upgrading from 11i to R12
• Worked on the lock box interface to create receipts in AR.
• Performed testing for the migrated custom objects to make sure that they work fine in R12.
• Extensively worked on PLSQL code changes and Oracle report code changes. Also worked on custom database objects structural changes as required.
• Worked on oracle forms personalization.
• Worked on WEBADI & DATALOAD.
• Was involved in peer review of various objects.
• Writing Test scripts and Test scenarios.
• Writing PL/SQL packages, function & procedures.
• Involved in activities for Oracle System Administration module such as Registering the Users and assigning responsibilities, Menu, Function, Request Set, Request Group, Concurrent program in Oracle Apps.
• Creating new responsibilities and defining the required system profile options
• Creating value set and assigning its values.
• Worked on issues/setting up Key Flex field and Descriptive Flex field.
• Created various Data Load scripts across Oracle Apps modules which were re-used.
• Made changes to the configuration documents BR100. Worked on config in AP, GL, AGIS, AR, Order Management, Advance Pricing & Shipping modules in various Oracle apps instances
• Worked on Functional design documents for custom objects related to Order Management, Shipping & Advance pricing.

Oracle Applications R12.1.3 (AR, AP, GL, SLA, CM, AOL, SYS ADMIN ), Oracle Database 10g, SQL, PL/SQL, Oracle Forms 10g, Oracle Reports 10g, BI Publisher, Oracle Workflow

Confidential

Oracle Apps Financial Functional Consultant

Responsibilities:

• Configuring the Oracle Payables, General Ledger & FA modules in various Application instances.
• Worked on various Functional Design documents which include AP Invoice Interface, AR Invoice Interface, AR Receipt Interface, GL Journal Import Interface, HRMS Employee Interface, Supplier Conversion, Bank Branch Conversion and GL Daily Rates etc.
• Performed functional testing for existing modules to understand existing business process, created documents to understand functional requirements for interfaces.
• Created setup document BR.100 for AP, GL, SLA, CM, AGIS
• Working on custom SLA for multi period accounting in AP.
• Performed functional testing for existing modules to understand existing business process, created documents to understand functional requirements for interfaces.
• Involved in activities for Oracle System Administration module such as Registering the Users and assigning responsibilities, Menu, Function, Request Set, Request Group, Concurrent program in Oracle Apps.
• Creating new responsibilities and defining the required system profile options
• Creating value set and assigning its values.
• Worked on issues/setting up Key Flex field and Descriptive Flex field.
• Worked with technical team to resolve / provide technical issues.
• Worked as Financial team SPOC for all the issues with Technical Team.
• Created various Data Load scripts across Oracle Apps modules which were re-used.
• Deals in WEBADI.
• Testing/validation of OBIEE reports.

Oracle Applications R12.1.3 (AR, AP, GL, SLA, CM, AOL, SYS ADMIN ), Oracle Database 10g, SQL, PL/SQL, Oracle Forms 10g, Oracle Reports 10g, BI Publisher, SQL Developer.

Confidential

Oracle Apps EBS Techno Functional consultant

Responsibilities:

• Worked on design and development of Oracle Apps inbound interfaces, outbound interfaces which includes AP invoice interface, GL interface, AR invoice interface & AR lockbox.
• Oracle Apps forms customization using TEMPLATE.fmb & Customized standard forms through custom.pll. Also worked on forms personalization.
• Setting up the Oracle Payables, General Ledger, SLA, AGIS & FA modules in various Application instances.
• Worked on various Functional Design documents related to AP, AR, FAH, GL & SLA
• Worked on Technical design documents (MD070) for FAH objects.
• Worked on Oracle reports and RDF Oracle reports.
• Worked on ODI mapping and ETL data designing.
• Worked on OBIEE report testing and data validation with EBS and Datamart.
• Performed functional testing for existing modules to understand existing business process, created documents to understand functional requirements for interfaces.
• Prepared setup document BR.100 for Payables, GL, CM and FA modules.
• Performed functional testing for existing modules to understand existing business process, created documents to understand functional requirements for interfaces.
• Involved in activities for Oracle System Administration module such as Registering the Users and assigning responsibilities in Oracle Apps.
• Worked on Enabling and setting up Key Flex field and Descriptive Flex field.
• Worked with technical team to resolve / provide technical issues.
• Worked as Financial team SPOC for the defect Co-ordination daily meeting.
• Created various Data Load scripts across Oracle Apps modules which were re-used.
• Worked in iSetup module to generate BR100 documents.
• Worked on various config issues during development and UAT and their resolution.

Oracle Applications R12.1.3 (AR, AP, GL, SLA, FAH, CM, AOL, SYS ADMIN ), Oracle Database 10g, SQL, PL/SQL, Oracle Forms 10g, Oracle Reports 10g, BI Publisher, SQL Developer.

Confidential

Oracle Apps Techno-Functional Consultant

Responsibilities:

• Supporting Oracle Financials and HRMS 11i modules in production.
• Worked on Functional Design documents for AP, AR, GL & HRMS
• Worked on Technical Design documents for AP, AR, GL
• Worked on Oracle Reports & XML Publisher reports development and customization.
• Worked on Interface development and Interface customization which include AR customer interface and AR lock box and AR invoice interface.
• Created documents MD070 and MD050.
• Reviewed Business Process Documents.
• Form Customization and Development using template.fmb and custom.pll
• Extensively worked in development of Database Procedure, Function and Cursors etc.
• Performed Unit Testing and Integrated Component Testing.
• Involved in debugging and troubleshooting.
• Deals in Descriptive and Key Flex fields.
• Assigning the Profile Values at User, Responsibility, Application and Site level.
• Extensively worked on scripts in UNIX.
• Involved in Peer to Peer review.
• Worked on Test scripts and test cases.

Oracle Applications 11.5.10 (AR, AP, GL, HRMS, Payroll, AOL, SYS ADMIN ), Oracle Database 9i, SQL, PL/SQL, Oracle Forms 6i, Oracle Reports 6i, BI Publisher, SQL Developer.

Confidential

Oracle Apps Techno-Functional Consultant

Responsibilities:

• Worked on AR Customer Interface Functional Design and Technical Design documents.
• Created Functional and Technical design for AR Cash Receipts Interface for BIBIT and BACS.
• Creating new XML reports and modifying the existing reports in Oracle Reports6i
• Performed Unit Testing and Integrated Component Testing.
• Preparing MD070 for Reports, Conversions and Interfaces as per AIM Methodology.
• Worked on Oracle financials support.

Oracle Applications 11.5.10 (AR, AP, GL, HRMS, Payroll, AOL, SYS ADMIN ), Oracle Database 9i, SQL, PL/SQL, Oracle Forms 6i, Oracle Reports 6i, BI Publisher, SQL Developer.

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Defining value set and attached concurrent program in request group.
• Modify interface programs using PL/SQL subprograms
• Providing live production Support
• Modifications in Workflow packages and customize the workflow.
• Analyze and created MDs 70 Technical design document.
• Modifying existing customized Oracle RDF reports.
• Performed Unit Testing and Integrated Component Testing.

Oracle Applications 11.5.9 (AR, AP, GL, HRMS, Payroll, AOL, SYS ADMIN ), Oracle Database 9i, SQL, PL/SQL, Oracle Forms 6i, Oracle Reports 6i, XML Publisher, Oracle Workflow, Toad.

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Involved in Development and customization of 6i reports and created technical design document.
• Created new outbound & inbound Interfaces related to OM, AR & GL.
• Enhancements done to the existing Interface and RDF Oracle Reports
• Worked on various reports in AP AR, Inventory to add new parameters in reports.
• Customization of reports. Defining Executable, program & adding it to a standard Request group. Create new value set.
• Make unit test plan, technical specs to test data verified by functional consultant.

Oracle Applications 11.5.9 (AR, AP, GL, HRMS, Payroll, AOL, SYS ADMIN ), Oracle Database 9i, SQL, PL/SQL, Oracle Forms 6i, Oracle Reports 6i, XML Publisher, Oracle Workflow, Toad.

Confidential

Systems Analyst

Responsibilities:

• Worked on various enhancements involving registration of custom program in oracle application 11i.
• Defined concurrent program, defined executables, value set and attached concurrent program in request group.
• Developed interface programs using PL/SQL subprograms (Write packages, procedures and functions)
• Analyze and created MDs 70 Technical design document.
• Worked on Oracle reports development and enhancement.
• Make unit test plan technical specs to test data verified by functional consultant
• Performed Unit Testing and Integrated Component Testing.
• Documentation of coding guidelines and other technical aspects of Oracle Application implementation/Customization.

Oracle Applications 11.5.9 (AR, AP, GL, HRMS, Payroll, AOL, SYS ADMIN ), Oracle Database 9i, SQL, PL/SQL, Oracle Forms 6i, Oracle Reports 6i, XML Publisher, Oracle Workflow, Toad.

Confidential

Oracle Forms and Reports consultant

Responsibilities:

• Understanding User Requirements, Functional Specification provided by the client
• Assisted in Database Designing for HR Module.
• Creating Process Flow Diagrams for integration with other modules
• Forms Development using Oracle Forms 6i
• Report Development using Oracle Reports 6i
• Coding and Unit & system testing in accordance with the requirements.
• Enhancements in the application.

HRMS, Payroll, INV, Sales, Oracle Database 9i, SQL, PL/SQL, Oracle Forms 6i, Oracle Reports 6i, Toad.