SUMMARY

• Over 9 yrs. of extensive experience in Oracle Applications implementation, upgrading, supporting and involved in a few full cycle implementations of several releases 11i/11.x/R12.
• Performing functional work wifin the Financial, Manufacturing, and Self - Service modules of Oracle Applications (Oracle Financials/Oracle E-Business Suite (EBS) for Enterprise Resource Planning (ERP).
• 4 Full Life Cycle Implementation of Release 12 Financials.
• 2 full life cycle implementation of Oracle 11i Financials including General Ledger, Accounts Receivable, Accounts Payable, Inventory, Purchase Order including hands on Configuration of these applications.
• Experience in supporting/upgrading the Oracle E-Business Suite, Release 11i for General Ledger, Accounts Receivable, Accounts Payable and Purchase Order.
• Providing application requirements gathering, designing, development, functional and technical documentation, and debugging.
• Performing business process mapping, Gap analysis and user training.
• Knowledge in intercompany transaction using R12 Confidential module and Global Implementation, Support experience of Confidential module.
• Able to interact TEMPeffectively wif other members of the Business Engineering, Quality Assurance, Users and other teams involved wif the System Development Life cycle.
• Knowledge of financial accounting and financial business processes, not limited to, but including: basic financial accounting process through period closing; revenue and Expense cash/accrual concepts; adjustments and financial statements.
• Good Understanding of Average and Standard costing.
• Competent in understanding the functionality of oracle 11i and R12 Functional Modules and their interaction in overall accounting structure of the organization.
• Strong problem solving and analytical skills wif good written and verbal Communication skills.
• Knowledge in Oracle tax engine eBTax setups and eBTax integration wif Vertex and Sabrix.
• Extensive knowledge in using Oracle AIM of project implementation methodologies particularly technical specifications of Interfaces (MD70),functional specification document (MD 50),Application Setup Documents (BR.100) deliverables and Test Cases (TE.20) for GL, Confidential, Confidential, PO modules.

PROFESSIONAL EXPERIENCE

Oracle EBS Analyst

Confidential, Ohio

Responsibilities:

• Oracle EBS R12.2. Upgrade: Test the core modules GL, Confidential . Confidential, OLFM, Confidential, INV and me Expenses for both standard and customized functionality.
• Lead demonstration of both standard and customized functionality in finance modules GL, Confidential . Confidential, Cost Management, Confidential, me Procurement and me Expenses.
• Gatheird business requirements and defined business processes, participated in setups, and test scenarios for Oracle Financial modules.
• Involved in Validation, Training and Testing of R12 Financials System relating to P2P (Procure to Pay) process involving the modules like Confidential, PO, GL, Confidential ..
• Worked on R12 sub-ledger accounting (SLA) setups.
• Responsible for the documentation (BR.030 -Business Requirements Mapping, BR.100 - Application Setup and TE.040 -System Test Script).
• Developed end-end test scenarios and test scripts of GL, Confidential, Confidential, OLFM, Confidential and me Expenses for UAT.

Environment:

• Oracle E-Business Suite 11.5.10.2 (11i), R12.2, Rational Clear Case, Oracle BI Discoverer
• MS Visio, Jira, SQL, PL/SQL., Sharepoint

Oracle Applications Functional Lead Analyst

Confidential

Responsibilities:

• Coordinated and documented detailed gap analysis between client requirements and Oracle R12 functionality.
• Responsible for End-to-end upgrade of R12.1.3 GL, Confidential, Confidential,, Confidential, OM, Confidential, Cost Management, PO,me Procurement, me Expense and payments from Blue Print to production as a Financial Functional Lead/Subject Matter Expert
• Prepared detailed designs for the ability to change costing method from Standard to Average, wifout the need for re-implementing the Oracle Applications.
• Configured Tax Regimes, Tax Rules in EBS Tax.
• Performed Functional analysis and did Secondary Ledger setup.
• Supported the client base in Confidential through User Acceptance Testing and Close process.
• Conducted scoping and requirements gathering sessions for Order to Cash business processes at various plant locations.
• Conducted CRP workshops and UAT sessions for Corporate Finance.
• Configured Ledger Sets (GL) and Sub-ledger Accounting (SLA) for Payables, Cost Management Module.
• Designed Oracle R12 Confidential solution in a multi-ledger, and multi-currency environment.
• Worked on Planning and Replenishment Inventory management tools like Cycle Counting, Physical Inventory ABC Analysis, and Max-Min Planning as part Inventory Optimization.
• Developed Custom Aging report and other reports based on client requirements.
• As per the company requirements, created and implementedBI Publisherreports for different products likePO, APandGL.
• Created Business Process Test Scripts from end to end event of Business Operations for all possible Business Scenarios for the Conference Room Pilot (CRP).
• Worked as a functional team member for Oracle Payables & General Ledger module. Developed implementation plan, testing scenarios and contributed to production cutover plan.
• Worked on Self Service and Form personalizations.
• Involved in Post Production Support for Oracle Financials Modules

Environment:

• Oracle E-Business Suite R12, 11.5.10.2 (11i), Rational Clear Case, Rational Clear Quest
• TOAD 9.0, SQL, PL/SQL, Windows NT, Oracle Forms, Oracle Reports, AIX UNIX.

Oracle Applications Sr Analyst

Confidential, Los Angeles, CA

Responsibilities:

• Gatheird business requirements and defined business processes, participated in setups, and test scenarios for Oracle Financial modules.
• Incorporated all the business scenarios in CRP demonstration documents for R12.
• Demonstrated the CRP to the client for R12 Upgrade project.
• Business Requirements Mapping for General Ledger, Accounts Payable, Accounts receivable and Cost management modules.
• Conducted CRP, EP demonstration sessions, gather requirements (AIM methodology), prepared Procure to Pay ( Confidential, PO, Confidential, OLFM, OM and GL) Business process flowcharts.
• Configured Confidential to create invoices in Confidential and Confidential for intercompany transactions.
• Created FSG reports and templates comprising row sets, column sets and content sets for reporting purposes.
• Performed analysis and preliminary design for iProcurement implementation.
• Involved in integrating Punchouts to external shopping catalogs in iProcurement.
• Worked on enhancements to me Procurement functionality like Automatic Creation of Blanket release, standard PO against Contract Agreement from Approved requisition.
• Involved in Validation, Training and Testing of R12 Financials System relating to O2C (Order to Cash) and P2P (Procure to Pay) processes involving the modules like OM, Confidential, Confidential, PO,GL, Confidential .
• Worked on eBTax integration wif Vertex.
• Design and testing the custom payment form template for printing payment checks
• Worked on B2B Integration for Auto lock Box.
• Writing Shell scripts to call stored procedures and packages to load data files using external tables
• Done documentation RD-050, BR-100 & MD-050 Using Country Specific localization.
• DevelopedPL/SQLPackages, Procedures, Functions for validating the invoices from the legacy system and imported into Oracle Application using the Payables Open Interface Import Program.
• Created automated functional regression test scripts using QTP and scheduled, organized and executed the test scripts in QC.
• Involved in Functional Design and Application Integration Testing of Interface Programs for Importing Invoices using Payables Invoice Import program.
• System Administration functionality performed including end user set up, responsibility definition and menu definition.
• Documented Processes and User Training Manuals for Maintenance Purposes.
• Involved in Post Production Support for Oracle Financials Modules

Environment: Oracle E-business Suite R12,11.5.10, TOAD, SQL, PL/SQL,QTP,QC

Oracle Application Analyst

Confidential, Houston, TX

Responsibilities:

• Documented testing scripts and testing condition to conduct regression testing on Confidential modules.
• Manage test case scenarios, results and reports for technical/data integrity testing, and functional (front-end) user testing wif the use of Test Director.
• Involved in all phases of testing such as System testing, Regression, Integration, Performance, Data Validation and User Acceptance Testing.
• Prepared GAP analysis and Functional Design documents for Confidential and me Procurement
• Developed expense report templates, expense report processes in Confidential .
• Configured key profile options and setups to invoke manager approval workflow process
• Analyzed user/business requirements and developed System Test Plan.
• Involved in the implementation of Supplier Open Invoices and Open Purchase Orders data conversion.
• Provided extensive help to client to do data clean up. Developed conversion programs for master data using Oracle PL/SQL and Standard APIs
• WrotePL/SQL packagesfor different validations, for processing data in order to create Valid POs and Receipts and for populating the PO interface tablesand called the Seeded import programs to populate the base tables.
• Customized existing custom Oracle reports to replace plain text output to PDF format using BI Publisher(XML Publisher).
• Worked on BI Publisher bursting to send PDF reports via email.
• Setup configuration done in CRP, EP, Conversion, Applications & Integration and UAT instances as per Confidential and Confidential configuration documentation.
• Tested various customized forms and reports to validate client business rule application.
• Analyze and map system requirements as part of the testing cycle for implementing Oracle 11i
• Develop methodologies for more TEMPeffective testing, tracking and coordination of functional testing of integrated business processes.
• Developed metrics and reporting methodologies for compiling and analyzing test results.
• Developed design documents and unit test plans for various customizations. Also created various user references manuals for users.
• Configured user responsibilities, request groups, menus and menu exceptions.

Environment: Oracle-E-Business suite 11.5.10, SQL, PL/SQL

Oracle Application Analyst

Confidential, Miami, FL

Responsibilities:

• Documented testing scripts and testing condition to conduct regression testing on Confidential modules.
• Manage test case scenarios, results and reports for technical/data integrity testing, and functional (front-end) user testing wif the use of Test Director.
• Configured setups of iExpense & iProcurement.
• Involved in all phases of testing such as System testing, Regression, Integration, Performance, Data Validation and User Acceptance Testing.
• Analyzed user/business requirements and developed System Test Plan.
• Involved in creation of Test Cases as per the business and technical requirements.
• Involved in testing converted Data from 10.7 to 11i version of Oracle Applications.
• Setup configuration done in CRP, EP, Conversion, Applications & Integration and UAT instances as per Confidential configuration documentation.
• Tested various customized forms and reports to validate client business rule application.
• Analyzed existing system, mapping requirements wif Applications and customized system to meet client requirements.
• Follow ups of TAR and Application of Patches as and when required.
• Tested multiple modules to validate business process and to ensure the quality of custom code.
• Analyze and map system requirements as part of the testing cycle for implementing Oracle 11i
• Develop methodologies for more TEMPeffective testing, tracking and coordination of functional testing of integrated business processes.
• Assist in the development test scenarios
• Developed metrics and reporting methodologies for compiling and analyzing test results.
• Developed design documents and unit test plans for various customizations.
• Also created various user references manuals for users.
• Configured user responsibilities, request groups, menus and menu exceptions.

Oracle Apps Tester

Confidential

Responsibilities:

• Develop methodologies for more TEMPeffective testing, tracking and coordination of functional testing of integrated business processes.
• Assist in the development test scenarios
• Develop metrics and reporting methodologies for compiling and analyzing test results.
• Performed different kinds of testing like End-to-End, Regression, Backend, Integration and Data integrity testing.
• Performed manual testing and Black box testing on the application.
• Involved in creating test plan and test cases and test scenarios.
• Involved in data integrity tests using SQL statements.
• Initiated and completed data migration projects testing and analysis.