Oracle Scm Tester Resume
Santa Clarita, CA
SUMMARY
- Over 7 years of IT experience asQuality Analyst & Functional Consultant with Business Analysis and Testing experience usingManual and Mercury (HP) Automation Tools
- 7 Years of experience in testing of Oracle e - Business Suite Release 12 and 11i versions of Supply Chain, Oracle Process Manufacturing and Financials Applications
- Experience with Oracle Apps Modules i-Procurement, BOM, WIP, OM, INV and PO
- Extensive knowledge and experience in all stages of the Software Development Life Cycle (SDLC) including Agile/Scrum approaches
- Have good experience in Software Testing Life Cycle STLC and its phases like Functional, Regression, System, Integration, Performance, E2E, BAT and User Acceptance Testing.
- Hands on Experience in developing Automation framework and coding VBScript using QTP to perform functional regression testing.
- Worked on implementation projects, upgrade projects, support projects, custom solutions/enhancement projects and conversion projects.
- Extensive experience in Quote to Cash Cycle (Order Management, Accounts Receivables, Cash Management, Inventory, General Ledger), Supply Chain management (SCM) and Trading Community Architecture (TCA)
- Working experience in Procure to pay cycle (i-Procurement, Purchasing, Account Payables, Fixed Assets), Advance Collections.
- Proficient in Manual Testing and in usage of Automation Tools such as Mercury Interactive (HP) QTP, Win Runner, Load Runner, Test Director, Quality Center.
- Conducting JAD sessions with Development teams and Business Analyst to communicate and clarify new Requirements and Projects reviews.
- Performed End-to-End system testing manually and closely worked with Cross Flow Teams
- Involved in different kinds of meetings with the developers, team members to discuss about the Test entry criteria, Test exit criteria, status of testing and statuses of the defects.
- Hands On Experience in Onsite offshore coordination, offshore onsite coordination and Customer coordination
- Experience in SQL queries to perform Backend testing and data mining.
- Worked extensively in testing of Reports/Concurrent Programs, Forms in Oracle Applications.
- Able to work under self-direction with minimal supervision and guidance, prioritizing own work and coordinating with other team members and business users.
- Capable of quickly learning new technologies and adapting to a new environment.
- Excellent interpersonal skills, ability to interact with people at all levels, good communication and presentation skills.
TECHNICAL SKILLS
Oracle ERP: Oracle Apps 11i/R12 (i-Procurement, BOM, WIP, OM, INV and PO)
Automation Tools: Win Runner, QTP, Load Runner
Bug tracking tools: Test Director, Bug Zilla, JIRA and Quality Center
Operating Systems: Windows NT/2000/XP/Vista, Linux and UNIX.
PROFESSIONAL EXPERIENCE
Confidential, Santa Clarita, CA
Oracle SCM Tester
Responsibilities:
- Worked on the testing of the entire SCM process flows - OM, INV, PO, BOM, AP, AP and GL
- Handled the Order to Cash and Procure to Pay process flow.
- Worked as an Onsite Test Lead to co-ordinate the testing with the Offshore team based on India.
- Worked on the Requirement Traceability Matrix.
- Wrote test scripts on the OM, INV, PO, BOM, AP, AP and GL modules
- Tested the XML Gateway for B2B transactions.
- Tested the Credit Checking process in OM module including the setup of Credit Check rules, Credit Usage rules, defining the credit checks at different points in the Order Cycle.
- Tested the TCA - setups of the Parties, Accounts, Contacts, Contact Points, Party and Account Relationships, etc.
- Tested the Localizations for Europe, India and Latin America.
- Tested the interface of Oracle OM with D&B Credit Checking process to determine the customers credit score.
- Worked on the testing and simulation of the Multi Org, PO, Service Contracts, Install Base.
- Worked on writing the test scripts for the Financials Modules - Testing the Auto Invoice Process, Auto Lock Box Process, Revenue Recognition rules, Transaction Types, etc.
- Used Testing tools of JIRA, Quality Center, Load Runner and QTP
- Tested the Service Contracts Module - Setup the QA Checklist, Contract Statuses, Contract Approval Rules, Usage Based Billing, Billing Schedules, Auto Renewal of contracts.
- Develop Use Cases and System Flow diagrams detailing the system impacts.
- Review and provide input to Detailed Design documents and Test Plans.
- Comply with the specified Delivery Methodology and documentation requirements
- Interacted with the database administrator, developers, system administrator and end users to interpret business requirements and develop concise solutions.
- Performed requirements analysis, participating in end-user meetings and review sessions to gather functional design specifications.
- Conducted Business Process Improvement - As-Is / To-Be Business Process Analysis & Modeling, Problems, Impacts, Solutions and Benefits Identification, Gap Analysis, Best Practice Research.
Environment: PL/SQL, SQL, Oracle Financials Applications R12 (12.1.3), AR, AP, i-Procurement, GL, Fixed Assets, Cash Management, Sub Ledger Accounting, E-Business Tax, AGIS
Confidential, Santa Monica, CA
Oracle SCM Tester
Responsibilities:
- Involved in the creation of Test plan, Test cases and Test procedures for manual testing.
- Performed Smoke, Regression, Integration, System testing and end-to-end testing of the application.
- Identified the scenarios for from BRD and FSD’s for PLC and CSCC Adoption Projects.
- Tested the end to end flows for Order to Cash and Procure to Pay.
- Involved in the execution of End to End test flow for (Q2C) and drop shipment orders
- Tested Pricing Scenarios for Pricelist Creations Project
- Used Quality center for test case mapping.
- Used JIRA for defect tracking
- Used Load Runner for Load Testing
- Tested the entire flow OM, INV, PO, BOM, WIP, AR, AP GL, i-Procurement modules
- Tested different Quotes up to Invoice and GL postings
- Providing test data for cross flow Testing Teams and coordination between onsite offshore teams.
- Facilitated weekly meeting with team leaders, managers and developers to discuss the issues found during the creation of the test case/scripts.
- Prepare testing documents, reports to communicate about the status and progress of the testing efforts with the management team members.
- Reviewed the testing progress and issues to be resolved by conducting walkthroughs
- Worked on the SCM modules (OM, INV, PO, BOM, WIP, AR, AP GL, i-Procurement)
- Worked on the OM Console in Order Management.
- Worked on weekly releases (Tuesday and Thursdays) did Analysis solution finding, Testing and getting approval for Task assigned to me on the above modules.
- Worked extensively on the TCA Model - Setting up Parties, Accounts, Contacts, Contact Points, Party Relationships, Account Relationships, Reciprocal and Non Reciprocal relationships.
- Worked on integrating the TCA with D&B for credit worthiness checking.
- Tested the Localizations of Europe, India, Middle East and Latin America.
- Tested the XML Gateway for B2B transactions.
- Tested the setup of Oracle e-Business Tax module to integrate with Vertex
- Tested the setups of the INV Module - Master Org, Child Orgs, Sub Inventories, Catalogs, Categories, Defining of the Item Master, setting up the Min Max and Reorder Point Planning, ABC Analysis and Cycle Counting, etc.
Confidential, Malta, New York
Oracle Functional Tester
Responsibilities:
- Developed the Test cases, test scenarios using the functional documents as per Business.
- Involved in the Application, System, Integration testing of various modules - AR, AP, GL, i-Procurement, e-Business Tax, Sub Ledger Accounting, OM, INV, Service Contracts
- Prepare testing documents to communicate about the status and progress of the testing efforts with the management team members.
- Identify the automated regression scenarios and using QTP automated them.
- Used Testing tools of JIRA, Quality Center, Load Runner and QTP
- Creation and modification of test scripts using QTP and dry run them during test cycles.
- Extensively tested Trading Community Architecture (TCA), Credit check Process
- Tested different Types of Orders, Pricing, Invoice Adjustments like Credit-rebill, Debit, Credit for Active and inactive Customers Accounts.
- Validated data using Toad and SQL queries on different data base and servers
- Communicated with other groups like Functional, design to meet business expectations and regular maintenance of software
- Tested customer creation, Quote to Cash Functionalities and Sales Adjustments.
- Identify regression scenarios for automation and create automated scripts using QTP
- Executed different scenarios during Smoke testing and making sure the transactions are executed properly.
- Record and successful execution OM, AR and GL Test Scripts as per the design and Testing of database updating for every transaction.
- Defect Tracking in Quality Center and keep track of the bugs for re-test and close operations.
Confidential, Chicago, IL
Oracle Functional Tester
Responsibilities:
- Reviewed the BRD, Functional specification, Technical Design Documents for modules of AR, AP, GL, e-Business Tax, Sub Ledger Accounting, OM, INV, Service Contracts
- Developed the test script and test cases using Functional specification, BRD documents.
- Tested functionality of new Economic Customer forms and Reports.
- Tested Credit check process through different scenarios.
- Identified the critical regression test scenarios to be automated, created automated test scripts using QTP
- Automated the credit check process scenario using QTP
- Extensively tested reports, which include Credit, expose report, Backlog AR report, Aging Reports and Credit Limit Change Revision Report etc.
- Conducted Functional and Regression testing during the various phases of the application.
- Performed complete execution of Order to Cash process in different instance, cross verify the configuration and set up.
- Involved in Functional, Integration Testing and reporting defects in Quality Center.
- Participated with development team to drill down requirements, customizations
- Communicated the issues to the developers and retested them upon receiving new builds.
- Tested the upgraded Reports, taking into account the significant data model changes with the new applications release.
- Prepared daily execution plan for all test cycles and reporting metrics in daily meetings.
Environment: Windows XP, Oracle Applications 11i - AR, AP, GL, e-Business Tax, Sub Ledger Accounting, OM, INV, Service Contracts, Developer 2000, SQL, PL/SQL, TOAD, Quality Center, QTP, E credit by Cortera
Confidential, New York, NY
QA Consultant
Responsibilities:
- Analysis of upgrade patches on the existing customizations and interfaces
- Review of Technical Design Documents (MD070) as per Oracle AIM methodology
- Involved in the creation of Test plan, Test cases and Test procedures for manual testing
- Conducted meeting with team leaders, managers and developers to discuss the issues found during the creation of the test case/scripts
- Performed Smoke, Regression, Integration, System, Performance and end-to-end testing of the application.
- Analyzed Business Requirements and developed Performance Strategy for benchmarking new application
- Functional testingof the test cases in load test environment
- Planned, coordinated and monitored project levels of performance and activities to ensure project completion on time
- Test data and test accounts creation.
- Automating test cases using QTP.
- Validate the data in the reports generated, against the database by writing SQL statements.
- Involved in identifying and mining the data as per the requirements
- Tested requisition Approval Workflow/Requester initiated change order workflow, PO Approval Workflow, Invoice Approval Workflow
- Tested Catalog Authoring Capability for Buyers, Suppliers and Catalog Administrators in i-Procurement
- Worked on different approval types, creating and maintaining favorite’s lists.
- Tested Different AP Reports like Supplier Payment History Report, Invoice History Report, Open Items Revaluation
- Prepare testing documents to communicate about the status and progress of the testing efforts with the management team members.
- Submitted weekly status reports stating the issues on the current build.
- Reviewed the testing progress and issues to be resolved by conducting walkthroughs.
Confidential, Los Angeles, CA
Oracle e-Business Suite Functional Tester
Responsibilities:
- As a Functional Test Consultant Tested the Supply Chain Modules: OM, INV, PO, BOM, WIP, AR, AP and GL
- Performed tests for all the Configurations and Setups for OM, INV, PO, BOM, WIP, AR, AP and GL modules
- Tested the integration of Vertex Tax Software with AR and AP Modules.
- Analyzed systems design specifications and developed Test Plan, Test Cases to perform overall QA testing.
- Used Test Director to track and report system defects and bugs, involved in writing modification request for the bugs in the application and helped developers to track the problem and resolve the technical issues.
- Performed Functionality, Integration, GUI, Regression, Usability, System and Testing of installation.
- Actively involved in automating test cases using Quick Test Pro.
- Executed performance tests using Mercury Interactive Load Runner Scripts, wrote custom functions and programs to support the load testing efforts.
- Extensively performed Manual Testing process to ensure the quality of the software.
- Participated in QA reviews and audits during various phases.
- Assessed the testing progress and issues to be resolved by conducting walkthroughs.
- Worked closely with project manager in project planning and execution of test plans and test cases.
- Documenting and communicating test results using Test Director
Environment: Oracle Applications11.5.5/11.5.7 (OM, INV, PO, BOM, WIP, AR, AP and GL, HP mercury Tool)