SUMMARY

• Over 7 years of professional experience as a Functional consultant in Oracle Technologies.
• Expertise in designing, developing, implementing and upgrading of Oracle Applications R 12/11.5.10/11.5.9/11.5.8.
• Extensive experience in Implementation, Migration, Customization and Production Support of Financial modules AP, i - Expense, i-Procurement, PO, AR, FA, TCA (HZ), OM, INV, Application Object Library (AOL), System Administration modules of Oracle Applications.
• Implemented complete life cycle in Release 12.
• Extensive experience with the Application Implementation Methodology (AIM)
• Proficient in developing Test strategies, Test procedures and Test cases for both Manual and Automated Testing using tools as Win Runner, Quick Test Pro (QTP), Load Runner, Quality Center (QC) and Test Director. Prepared defect reports, execution logs and maintaining test cases in Test Director.
• Expert in writing Test Scripts, Test Scenarios, Test Plans, Testing estimations by reviewing functional documents for all levels of Testing.
• Expert in GUI, Load, Regression, Integration, System, Functional, Performance, Configuration, Stress, Acceptance and Unit, Black box, White box testing.
• Extensively worked with business requirements derived Testing methodologies using use case, sequence and component diagrams.
• Designed, developed and updated test procedures for applications to meet with Life Cycle guidelines and company ISO standards and also specialized in software process improvements as per the Capability Maturity Model (CMM).
• Expertise in TSL (Test Script Language) for the automation of Functional and GUI tests using Win Runner. Backend testing in SQL Server, Oracle, DB2 using SQL queries and PL/SQL procedures.
• Performed Load Tests using LoadRunner with various virtual users like Web (HTTP/HTML), Java, and VB etc. Configured LoadRunner for monitoring Application Server, Data Base Server, Network Delay, and Transaction Break down on UNIX/Windows Platforms.
• Highly motivated, organized and detail oriented individual with excellent communication skills.
• Involved in working with users, identifying functional and technical gaps, estimating work to fulfill business requirements, designing custom solutions, programming, scheduling, documentation, and production support.
• Good technical, interpersonal and communication skills.
• Admirable interpersonal abilities and an efficient team player
• A quick, goal oriented and enthusiastic learner and self starter

TECHNICAL SKILLS

ERP: Oracle Apps 11i (11.5.x) / 11.0.3 / 10.7

Modules: AP, AR, OM, INV, GL, AOL, PO, SYSTEM

Software Skills: SQL, PL/SQL, C, C++, UNIX Shell Scripts

Operating systems: UNIX, SUNSOLARIS, WINDOWS 98/NT/2K/XP

RDBMS: Oracle 9i/8i, Microsoft Access 2000/XP

Tools: and Packages: Oracle Forms 6i/4.5, Reports 6i/2.5, Oracle Discoverer 4i/3iSQL*Loader, Toad, Microsoft Office tools, SQL NavigatorSQL*Plus, Oracle Workflow 2.6, Visual Basic 6.0, ETL

Documentation: AIM (MD60, MD70)

PROFESSIONAL EXPERIENCE

Confidential, San Diego, CA

Oracle e-Business Suite Test Consultant

Responsibilities:

• Involved in developing and designing a complete strategy to test the embarq.com portal from the design phase till completion.
• Involved in performing Performance Testing and fine-tuning the entire embarq.com portal and other back-end applications interacting with Embarq.com.
• Involved in developing Test Plans and Test cases for the entire functionality of the portal.
• Involved in coding customized scripts to measure the performance of the various functionalities of the portal using Mercury Interactive Load Runner 8.0/8.1 Tool.
• Responsible for migration of Load Runner from Version 8.0 to 8.1.
• Worked on Quick Test Pro (QTP) to automate the Order to Cash, Procure to Pay, i-Procurement to PO and i-Expense to AP processes.
• Analyzed Throughput Graph, Hits/Second graph, Transactions per second graph and Rendezvous graphs using LR Analysis tool.
• Understanding the existing business processes including Purchasing, i-Expense, i-Procurement, Order Management, Shipping, Advance Pricing
• Conducting CRP1, CRP2 UAT1 and UAT2 and helping the user for going through all the test cases.
• Written TE 040 System Test Scripts for i-Expense, i-Procurement, OM, PO and Advance Pricing Modules.
• Worked on Mercury Quality Center/Test Director for defect tracking and resolution recording.
• Used Load Runner, Win Runner and QTP for automated tests.
• Created DNS Test Scripts for all FTP jobs as a part of upgrade project introduces Multi-tier Environment and change the hard coded server names to DNS names.
• Performed Standard Functionality testing in i-Expense, i-Procurement, GL, PO, AP, HRMS and OM.
• Was involved in Standard Functionality testing in Phase I and Phase II for 3 instances.
• Responsible for extrapolating the performance data from Oracle e-Business suite module and other Monitoring tools and identify Bottlenecks in the system & propose steps to resolve them.
• Acted as a Single point of contact between the Business Team & Technical Team members.
• Responsible in delivering the complete Project Plan with total supporting data which included the Status Reports, Issues Log, Performance Testing Matrix, Detailed Testing Reports, Fine tuning Recommendation Report to both Executive Management & Senior Management.
• Managing QA Environment including the QA staff and QA Labs.
• Responsible in mentoring QA team members in creating customized LR Scripts and execution.

Environment: Automated testing, Load Runner 8.0, Test Director 7.0, QTP, Oracle 8i, Oracle e-Business suite 12.1

Confidential, San Diego, CA

Order to Cash and Procure to Pay Test Consultant

Responsibilities:

• Involved in making the detailed Project Test Plan regarding the scope and focus of the testing (TE 10).
• Written standard test scripts for Oracle Financials, HRMS and Manufacturing Modules.
• Written TE 020 Unit Test Scripts for Payment Methods in AP and interface with Parts Operating Unit.
• Written TE 040 System Test Scripts for i-Expense, i-Procurement, AP and OM Modules.
• Testing the Localization requirements for India, China and UK (Tax and Reporting)
• Performed Standard Functionality testing in GL, i-Expense, i-Procurement, PO, AP, HRMS and OM.
• Was involved in Standard Functionality testing in Phase I and Phase II for 3 instances.
• Tested Multi-Org Setups as a result of the new Parts Operating Unit that is being introduced as part of the upgrade to 11.5.10.
• Involved in Unit Testing and System Testing.
• Documented and communicated test results to the Test Management and Business Management Team
• Worked closely with Developers team for different issues

Environment: Automated testing, Load Runner 8.0, Test Director 7.0, QTP, Oracle 8i, Oracle e-Business suite 12.0.3/11.5.9

Confidential, Santa Clara, CA

Functional Test Consultant

Responsibilities:

• Conducted several meetings with BSA and Business teams for business overview
• Identified the key business process areas and operational dependencies along with the help of BSA Team
• Analyzed business requirements and performed fit-gap analysis to map user requirements to 11i functionality / transactions utilizing Oracle’s AIM Methodology
• Conducted extensive business workshops to understand RD-50 and prepare document CV-20 for data conversions
• Conducted CRP (Conference Room Pilot), integration testing and performed extensive UAT
• Involved in preparation of training material and training setup
• Conducted business workshops/trainings to explain OM, i-Expense, i-Procurement and INV modules, workflows and review end-user and super-user feedback for improvements
• Written TE 040 System Test Scripts for i-Expense, i-Procurement, OM, PO and Advance Pricing Modules.
• Worked on Mercury Quality Center/Test Director for defect tracking and resolution recording.
• Used Load Runner, Win Runner and QTP for automated tests.
• Provided support in raising TARS, applying patches and problem-solving
• Performed debugging of the applications and helped team members in troubleshooting and debugging
• Provided Post-Production support remotely

Confidential

Functional Test Consultant

Responsibilities:

• Designed and configured solutions for various functional requirements involving Purchasing, Inventory, Order Entry/OM and BOM
• Involved in GAP analysis and designed solutions to work around identified gaps
• Analyzing business requirements and mapping to Apps
• Worked closely with the Customer Service, Manufacturing and the IT (Local and Global) Teams to perform data analysis, business requirements, specifications and support for all modules
• Acted as a liaison between business users, IT and support teams
• Performed business process analysis and design for Purchasing, Inventory and BOM modules
• Conducted training of both Super Users and End Users
• Created desk procedures and other documentation
• Mock conversion, conference room piloting and testing

Environment: Oracle Applications11.5.10 (INV, GL, AP, AR, PO, OM, Pricing, Reports-6i, Forms-6i, Vertex Tax Engine, SQL*LOADER, HP mercury Tool)

Confidential

Functional Test Consultant

Responsibilities:

• Tested the Pick Releases Process customization - Integrated Oracle WMS to an external warehouse system.
• Tested the Importing of Invoices from legacy system into Oracle Payables using Auto Invoice Interface
• Tested the Approval Process in PO Workflow.
• Tested the Migration of data from legacy systems into the temporary tables in Account Payables (AP). Developed custom reports using Discoverer 4i
• Tested the OM/Shipping reports, which includes the Sales Order Acknowledgment Report, Packing Slip Report and Commercial Invoice Report.
• Tested the reports on Discoverer 4i to 10g.
• Conducted UAT and CRP and assisted the business users in testing activities.

Environment: Oracle Applications 11i, BOM, Vertex Taxware, WIP, MRP, INV, AP, OM, Advance Pricing, Shipping, GL, PO, SQL*Loader, SQL*PLUS and Reports 6i, UNIX, PL/SQL Developer.