We provide IT Staff Augmentation Services!

Quality Analyst Resume

San Jose, CA

EXPERIENCE SUMMARY

  • Over 8 years of IT experience as Quality Analyst & Software Engineerwith Development and Testing experience using Manual, Mercury(HP) Automation Tools
  • Years of experience in testing of Data Warehousing Solutions, Oracle Applications 10.7/11i/R12 finance Modules and Web based Applications
  • Very good understanding of Oracle Apps Modules iStore, iReceivable, iProcurement, iExpense, PO, Pricing, Inventory, OM, AR, AP, GL ,Service Contracts, HRMS,
  • 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.
  • Delivered three successful quarterly releases as QA lead. Worked on multiple releases at the same time and delivered quality work not affecting any of the releases.
  • Worked on implementation projects, up gradation projects, support projects, custom solutions/enhancement projects and conversion projects.
  • Extensive experience in Order to Cash Cycle(Order Management, Accounts Receivables, Cash Management, General Ledger) and Trading Community Architecture.
  • Working experience in Procure to Pay cycle (Purchasing, Account Payables, Fixed Assets), Advance Collections.
  • Experience in Business Intelligence Solutions (Hyperion) Testing for Oracle ERP Financials Intelligence.
  • 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.
  • Closely worked with Cross Flow Teams and Used different types of communication tool like WebEx, VoIP.
  • 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.
  • 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:

ERP: Oracle Apps 10.7/11i/R12 (iProc, iExpences, PO, OM, AR, AP, GL, INV, HRMS)
Automation Tools: Win Runner, Load Runner, QTP
Bug tracking tools: Test Director, BugZilla, JIRA and Quality Center
Operating Systems: Windows NT/2000/XP/Vista, Linux and UNIX.
RDBMS: My SQL, SQL Server 2000, 2005, DB2 and Oracle 8i, 9i, 10g.
Languages: C, C++, Java, J2EE, SQL, PL/SQL, .Net, VB 6.0
Scripting languages: VBScript, JavaScript, TSL and Perl.
Web Development: HTML, XML, MS FrontPage.
Tools: Toad, SQL Developer, SQL, WebEx, VoIP, Forms 6i, Reports 6i
Version Control: VSS, PVCS

Education:

Masters in Computer Applications.

Work Experience:

Client: Confidential San Jose, CA Sep'07 to till date
Quarterly Release Q4FY09
Oracle ERP QA Lead
Project: AR Credit Project
This Data Warehousing project catered to the needs of Credit managers who wanted to get information about the Payment metrics of Customers, Sales, Receivables, Disputed items etc.

  • Identified data sources in Account Receivables (AR) module of Oracle applications and developing ETL programs to load data into Global Data Warehouse
  • Part of the group responsible for collection of requirements from the end-user and performing gap analysis
  • Reviewed Technical design documents and identify the Scenarios
  • Tested outbound interfaces between Global Data Warehouse and Hyperion Essbase cubes.
  • Tested Performance of Data Warehouse applications
  • Verified Data reconciliation between the OLTP and Data Warehousing systems
  • Developed ad-hoc complex queries for immediate business needs
  • Hands on experience in dealing with UAT.
  • Monitor requirements, test cases execution and defect tracking using Quality center.

Environment: Oracle Applications 11.5.10, HPUX, Hyperion, TOAD, SQL/PL SQL, Discoverer 10g

Project Name: Confidential
Confidential is Global Credit Organization (GCO) initiative. To effective business growth and efficient processes in Credit management system Cisco Systems, Inc. integrate eCredit from Cortera and Oracle ERP
Responsibilities

  • Reviewed the BRD, BSD, Functional specification, Technical Design Documents.
  • Involved in writing Quote to Cash Test Plans based on Business Specifications, Developed Test Cases in accordance with the provided use cases.
  • Prepare testing documents to communicate about the status and progress of the testing efforts with the management team members
  • Monitor requirements, test cases execution and defect tracking using Quality center.
  • Planned, coordinated between onsite-offsite coordination and monitored project levels of performance and activities to ensure project completion on time.
  • Hands on experience in dealing with UAT Involved in identifying the Critical Business Process, baselines and SLAs forPerformance testingthe applications.
  • Identify the new scenarios(regression)to automate and automated them using QTP and executed during test cycles
  • Executed automated regression test suite for OM, AR using QTP.
  • Prepared Daily execution plan, daily status report and communicate across the flows and Conducted status meetings.
  • Participating in Defect review meetings to help developers to understand the problem and setting the severity levels
  • Tested Credit check process (ERP), Credit allocation (ERP and E-credit) through different scenarios.
  • Tested AR, OM reports like CFS Hold Report, Credit exposure report, AR backlog report, Aging buckets reports.
  • Responsible for periodic updating of Test Plans and Test Cases as per Requirement Specifications
  • Responsible for reporting the defective test results on daily basis to the release management team.
  • Performed End-to-End system testing manually and closely worked with developers, system engineers to nail down the technical problems.
  • Communicated with other groups like Functional, design to meet business expectations and regular maintenance of software.
  • Communicated the issues to the developers and retested them upon receiving new builds

Quarterly Release Q3FY09
ERP QA Lead
Project Names: Price list Creation (PLC), SAJO, Synergy, CSCC Adoption
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.
  • Involved in the execution of End to End test flow for (Q2C) and drop shipment orders
  • Executed Automated OM, AR regression scenario Suite using QTP for Synergy and report the results
  • Worked in creation of billing events for Service Contracts
  • Experience in OM, AR core functionality Cash application, receipt , Sales adjustments and Collections
  • Tested Pricing Scenarios for Pricelist Creations Project
  • Used Quality center as the defect-tracking and test case mapping.
  • Tested different Quotes up to Invoice and GL postings
  • Providing test data for Cross flow Testing Teams and coordination between onsite offshore teams.
  • Involved in testing of Large Quotes grouping logic in invoicing
  • Attended 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

Quarterly Release Q1FY09
ERP QA Lead
Project: Customer Account Foundation (CAF)
Responsibilities

  • Developed the Test cases, test scenarios using the functional documents as per Business.
  • Involved in the Application, System, Integration, and Regression testing using QTP of various modules.
  • 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.
  • 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, Qoute to Cash Functionalities and Sales Adjustments.
  • Identify regression scenarios for automation and create automated scripts using QTP
  • Executed automated QTP test scenarios using QTP and reported the result.
  • 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.

Quarterly Release Q3FY08
ERP Senior QA Consultant
Credit Line Management (CLM)
The key benefit introduced by Credit Line Management is that it will modify the credit check process to evaluate customer credit limits at an overall “economic customer” level, resulting in fewer credit holds. CLM will improve management of customer exposure, periodic reviews, and credit risk data, as well as decrease order cycle time, increase productivity, and improve customer satisfaction.
Responsibilities:

  • Reviewed the BRD, Functional specification, Technical Design Documents.
  • 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 - OM, AR, INV, AOL, TCA, Developer 2000, SQL, PL/SQL, TOAD, Quality Center, QTP, E credit by Cortera

Client: Confidential Jun'05-Sep'07
Project: Upgradation of Oracle Applications from 11.5.9 to 11.5.10
Role: QA Consultant
As part of future acquisitions and mergers and security enhancements, Confidential has upgrade Oracle Applications from 11.5.9 to 11.5.10. This involves the impact analysis of existing customizations and interfaces and the retrofitting of the customizations on the upgraded versions of workflow objects and the redevelopment of application.
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
  • Executed and monitored load tests and reported errors to application team
  • 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 iProcurement
  • 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.

Project: Implementation of iProcurement, iExpenses and Purchasing Modules
New York Stock Exchange (Confidential) implemented the Oracle Financial Modules to satisfy their Business Requirements. As part of the project we have implemented iPocurement, Internet Expenses, Purchasing and Payables modules
Responsibilities:

  • Reviewed the BRD, Functional specifications in Procure to Pay modules.
  • Involved in writing Test plans, Test cases and responsible for executing the Test Scripts.
  • Analyzed Business Requirements and developed Performance Strategy for benchmarking new application.
  • Involved in identifying and mining the data as per the requirements.
  • Analyzed various graphs and reports to interpret load test results.
  • Customized the script by using Loadrunner built-in functions and custom ‘C' coding
  • Developing various necessary documentation including load test plan, load test final report, daily test status reports, technical qualifying document and summary report.
  • Tested and supported interfaces, to validate and import the invoices from External Vendors to Oracle Payables
  • Tested and supported the P2P customizations like desktop receiving, confirm receipts workflow, requisition approval workflow to add special approvers in the approval hierarchy
  • Analyzed Business Requirements and developed Performance Strategy for benchmarking new application.
  • Extensively used Loadrunner monitors to identify the bottlenecks in Network, Database and Application Servers
  • Involved in identifying and mining the data as per the requirements
  • Tested Workflow customization, Requester initiated Change Order Workflow customization, Purchase Order Workflow customization to mail PO to suppliers, Invoice Approval Workflow customization to send the invoice approval notification to requester of the PO that was matched to Invoice etc
  • Tested Catalog Authoring Capability for Buyers, Suppliers and Catalog Administrators in iProcurement

Environment: Oracle Applications 11i, AP, iProcurement, iExpenses, PO, OM, Service Contracts, Developer 2000, SQL, PL/SQL, TOAD, TEST DIRECTOR

Client: Confidential Oct'03-Jun'05
Project: Email-Fax Integrated System
(Confidential, HYDERABAD)
Software Engineer

Responsibilities:

  • Involved in reviewing Requirements and wrote Test Plan, Test Cases and Test Scenarios.
  • Worked with Autodesk Business Tool Team in enhancements and archiving process
  • Providing a comprehensive scalable solution which can be easily scaled up to a multi-channel blended environment
  • Incorporating flexible routing rules to ensure that the right agent receives the inquiry
  • Providing an inbound email management solution, which increases the speed and accuracy of email responses
  • Involved in execution of test plans, test cases and test scripts based on business requirements of the Application.
  • Performed Unit, Functional and Regression testing on PowerBuilder , the database updates, queries, inserts and administration functions
  • UsedSQL Queriesto verify the data from the Oracle database-using TOAD.
  • Developed automated Win Runner scripts for application using totally Data-Driven Automated Testing Methodology.
  • Troubleshooting of the problems originating in the productions environment and resolved the production problems
  • Generated the automated scripts to test application functionality.
  • Performed End-to-End testing manually
  • Attended project meetings, release meetings, and QA status meetings.
  • Involved in user meetings, preparation of system documentation, knowledge transfer and end user training.
  • Environment: Windows 2000/NT, .NET, COM, Oracle 9i, PowerBuilder, MS Exchange Server
Confidential, Hyderabad Jan'03-Oct'03
Software Engineer
The scope of the project is derived from discussions with the Confidential and Technology teams. The project will consist of replacing the existing trading systems, viz., Longview, Predator and IEMS with Charles River for the Equities Trading desk in New York and Hartford
Responsibilities:
  • Identifying Test Cases and generating Test Scripts in Win Runner as per Test Procedure Specifications.
  • Customizing the generated Test Scripts
  • Performing SQL queries to verify GUI front-end results and to extract and manipulate data to satisfy test cases/requirements
  • Participated in defect life cycle and bug was reported to the development team.
  • Responsible for Update of existing Test cases against the Change requirements document
  • Performing Regression Testing using the Test Suites and analyzing the Playback Results.
  • Reviewing the requirements and design documents for assuring Quality Management System.
Environment: Windows 2000/NT, PowerBuilder, .NET, SQL Server Client: Aventis Pharmacy,

Confidential, Hyderabad, India. Jan'02-Dec'02
Software Engineer

Responsibilities:

  • Test cases and test scripts are developed in Win Runner as per test procedure specifications.
  • Reviewing the requirements and design documents for assuring Quality Management System.
  • Performed functional and regression testing using the test suites and analyzing the playback tool.
  • Performed Black box testing to test all the functionalities of the application
  • Preparation of test data files, Preparing Test Plans, Executing Test Cases and gathering the Test Execution Results Involved in regression testing and integration testing.

Environment: .Net, SQL server 2000, Windows2000

Hire Now