Sr. Qa Analyst Resume
Woodland Hills, CA
SUMMARY
- Over 7 years of Software Quality Assurance experience with good exposure to full software life cycle with manual testing.
- Good exposure in financial, retail and banking industry.
- Extensive experience in testing of different products developed in Java and .NET.
- Experience in testing Windows, UNIX, Web, and Client - Server environments.
- Experience in AGILE based development and as well as Software Development Life Cycle and Test Development Life Cycle, which includes Requirement analysis, test planning, execution, and defect tracking.
- Analyzed System Design Specification (SDS), Functional Requirements (FRD) and Use Cases for drafting Test Cases and Test scenarios.
- Experience in planning, coordinating and performing different tests like Integration Testing, Validation Testing, Functionality Testing, Regression Testing, GUI testing, and User Acceptance Testing.
- Expertise in database querying, data manipulation and population using SQL& PL/SQL in Oracle and SQL Server.
- Extensive knowledge and Experience in various RDBMS like Oracle and UDB.
- Extensively worked on backend testing and well versed with SQL, PL/SQL queries to run the data integrity tests.
- Extensive working knowledge in UNIX/Linux operating systems.
- Developed Traceability Matrix between requirements and test cases to ensure adequate test coverage manually.
- Experience in preparation and execution of regression test scripts and Test Data.
- Experience with automated testing tools like Quick Test Professional (QTP) and Mercury Diagnostics.
- Expertise in writing Automation scripts for QTP using VB Script.
- Experience using HP Quality Center, Test Director and Clear Quest.
- Developed SQL test scripts for functional and regression testing.
- Experience creating defects, following up until final resolution of the defects and closing them.
- Expertise in Manual Testing including Back-end and Front-end testing.
- Interacted with developers and business users for efficient testing process.
- Participated in Walkthroughs and Defect Report Meetings periodically.
- Expertise in documentation using MS Office Suite.
- Excellent written and verbal communication skills and a quick learner.
- Good Interpersonal skills with strong Analytical Skills.
- Strong analytical skills, logical, presentation skills with strong communications skills at different technical and managerial Levels.
TECHNICAL SKILLS
Languages: C, C++, J2SE and J2EE
Tools: QTP, Selenium, PEGA PRPC, HP ALM, Quality Center, Test Director.
Data base: Oracle, DB2, and Teradata
Scripting Languages: Java Script, XML, HTML.
Operating Systems: AIX, MVS/XA, Solaris.
Application Servers: Web sphere, Tomcat, web logic, Eclipse
Domain Knowledge: Banking, Retail and Finance.
PROFESSIONAL EXPERIENCE
Confidential, Woodland Hills, CA
Sr. QA Analyst
Responsibilities:
- Analyzed System requirements to develop the Master Test Plan. Mapping Test cases to requirements in order to ensure that all the functional requirements have been covered in the Test plan.
- Responsible for creating Test plans, designing test harnesses and test cases, and executing the test cases.
- Worked closely with BA in breaking the upgrade process into iterations of six and strategically choosing the coverage for each iteration.
- Defined the test criteria, project schedules and base lined the Test Plan with the help of project meetings and walkthroughs.
- Attended daily triage meeting to track and update the progress and to ensure overall health of the project.
- Validated flat files coming from downstream systems and mocked up feed files by using vi editor.
- Performed Back end testing by writing SQL statements like Join, Inner Joins, Outer joins and Self Joins used TOAD.
- Performed Backend/SQL Test for Insert, Update, and Functions.
- Done Proof of Concept for Automation projects in the current organization.
- Used QTP, Selenium tools to automate all the test cases.
- Involved in end-to-end testing (Big Bang) testing in both front-end application and in the mainframe.
- Research in design methods to create scenarios for adequate test coverage.
- Involved in the Production Validation of Release Projects. Communicated product quality assessment and metrics within the software development team.
- Devise checklist and templates and adopt Quality assurance procedures to meet milestones of high quality
- Involved in Scrum Process as a part of agile methodology.
- Managed and developed SQL queries for backend testing.
- Daily and weekly status reporting.
Environment: BIE2, Toad for DB2, Oracle, MVC, Ratabase, HP ALM, QTP, Selenium, .Net, Windows XP.
Confidential, Jacksonville, FL
Pega/ETL Tester
Responsibilities:
- Developing Test Plan with a Test Strategy for the System testing. Instrumental in creating design and framework for automation.
- Analyzed the business requirements of the application and also helped in developing detailed test plan and test cases and writing scripts manually.
- Defined the test criteria, project schedules and base lined the Test Plan with the help of project meetings and walkthroughs.
- Backend testing of the DB by writing PL/SQL queries to test the integrity of the application.
- Validated the reports generated by PRPC for SAAS analysts by doing ETL system validation.
- Verified logs after running ETL jobs.
- Connected remotely to UNIX servers using PUTTY and FTP files across different test environments by Command prompt.
- Involved in end-to-end testing in both frond end application and in the mainframe.
- Excellent working knowledge of designing and implementation of all QA test strategy plans and automated test solutions for client/server and Web applications.
- Research in design methods to create scenarios for adequate test coverage.
- Involved in QTP Framework design and implementation.
- Developed test automation scripts using QTP for Regression, Functional, and GUI testing.
- Performed database validation in the Mainframe to ensure the data entered through the front end reached the database.
- Worked on documenting Master QA Strategy (a new template per ESDM guidelines). Defining the QA tasks for data intensive projects. Customizing the scope of various QA activities
- Extensively involved in the automation of Regression Test Cases by scripting.
- Executed the regression test cases along with testing new enhancements by using QTP and analyzed results.
- Reviewed Error log files in UNIX box when order fails to load into SQL tables.
- Actively involved in Source Driven Testing, Target Driven Testing, Business Cycle Testing, Business
- Worked on different database like Oracle to check the data consistency.
Environment: PEGA PRPC V5.5, V6.2, QTP, Quality Center, Web Sphere, DB2, Informatica for ETL, AIX, Microsoft Visio 2007, Windows XP.
Confidential, Atlanta, GA
Sr. QA Engineer
Responsibilities:
- Analyzed System requirements to develop the Test Plan. Mapping Test cases to requirements in order to ensure that all the functional requirements have been covered in the Test plan.
- Performed Functional, Black Box, System, Integration, Smoke and Regression Testing.
- Creating Test Cases in Quality Center as per Functional Requirements.
- Prepared Test data to enable the software to be quality checked.
- Involved in the automation of test cases from the scratch and developed a full regression suite for the entire project.
- Extensively worked on QTP to automate regression test cases for production QA team.
- Performed System Testing, Interface Testing, and Integration Testing using QTP.
- Created user defined functions in compiled modules for modularity and reusability.
- Helped manual testing team to setup and run automation scripts in Quality Center.
- Reported software defects inQuality Centerand interacted with the developers to resolve technical issues.
- Generated SQL queries to validate various reports, loads and extract processes.
- Tested for content, comprehensiveness, layout and functionality and involved in positive and negative testing of the application.
- Working with Scrum Team and daily stand up to discuss about all possible tasks and technical issues with Business System Analyst and Developer
- Connected remotely to UNIX servers using PUTTY and FTP files across different test environments by using Hummingbird and Command prompt.
- Executed the UNIX shell scripts that invoked SQL loader to load data into tables.
- Used Quality Center for bug tracking and reporting.
- Developed UNIX Shell scripts to execute different SQL to test the sanctity and integrity of the tables.
- Extensive Backend testing by writing Complex SQL Queries.
- Responsible for conducting the defect review meetings with the development and business teams on a daily basis to report and discuss the validity of defects opened by the testing team.
Environment: Agile Model (Scrum Methodology), XML,TSO/ISPF, QMF, QTP, Toad for Teradata and Windows XP.
Confidential, Columbus, GA
Quality Analyst
Responsibilities:
- Worked as QA Creating Test Strategies, Test Plans, and Test Cases for all scenario types. (I.e. positive, negative testing, boundary) Managed the software QA team in planning and developing test cases for banking software.
- Ensured that test scripts are up to date with current business changes.
- Identify test coverage performed by the QA testing activities and results
- Interacted with developers, Business & Management Teams and End Users.
- Documenting and communicating Test Cases, Test Results, and Reports using Quality Center.
- Worked closely with leads and analysts from other QA business oriented groups to manage testing effort, log production problems, request and maintain test data.
- Identify any unresolved and undelivered defects encountered during system testing.
- Writing and analyzing ad hoc reports Writing SQL queries Identifying objectives goals and strategies for the company Facilitating requirements sessions among business.
- Extensive worked on writing Oracle Queries.
- Defined, presented, and documented Test Plans and strategies for application release.
- Responsible for designing and developing a proper QA standards and procedures and writing test strategies and test plans using Microsoft Excel, Word.
- Involved in different kinds of testing such as System, Integration, Functional, and User Acceptance testing in the different phases of development cycle.
- Developed SQL Queries using SQL Navigator on Oracle Database for performing back end testing.
- Provided UATDemo and Test Data to the Users and interact with them if they need any more information during the time ofUAT.
- Executed Unix Shell scripts to put messages in MQ queues.
- Reviewed Error log files in UNIX box when order fails to load into SQL tables.
- Written SQL Queries and executed them using TOAD
Environment: Mainframes, TSYS, MVS, DB2, Extra in Windows, MS Office, SOAP.
Confidential, New Brunswick, NJ
QA Testing Analyst
Responsibilities:
- Conducted Use Case Review sessions with business stakeholders.
- Executing test cases and reporting Manual-testing defects through Quality Center.
- Created Test plans and performed manual testing of the application to test the system for both the
- Functional and business requirements for positive and negative scenarios using Mercury Quality Center.
- Verified logs created in Unix box.
- Performed Manual Testing on different Modules of the Application by executing the Test Cases.
- Created test scenarios, test data according to the test cases.
- Executing of Manual Scripts. Defect logging and Bug Tracking through an interface with Mercury Quality Center.
- Organized the test cases in Mercury Quality Center for traceability and monitored test results, tracked defects and communicated them using Mercury Quality Center.
- Involved in manually testing various modules of the application to ensure application stability and functionality. Performed Backend database verification manually.
- Created Requirement Traceability Metrics. Created Script Status and Defect Status Reports.
- Linked the test cases and defects in Quality Center and generated reports.
- Administered the complete testing effort in Mercury Quality Center.
- Documented the errors using Mercury Quality Center and tracked them to completion by communicating and co-coordinating with the development as well as the support group.
- Conducted system and functional testing manually.
- Conducted extensive testing against formal requirements.
- Using different browsers in different platform conduct User Acceptance Test.
- Prepared UAT Test plan and coordinated UAT with stakeholders and business users.
- Involved in the Weekly Bug's Status Meetings along with QA and Development team.
- Manually manipulate data directly from Oracle database using SQL.
- Performed database testing to validate database-using TOAD.
- Reviewed data from Back End to Front End of the application using SQL statements.
Environment: Quality Center, UNIX, Java, XML, SQL, Oracle 9i using Toad, Perl, J2EE, Windows XP.
Confidential, Wilmington, DE
QA Analyst
Responsibilities:
- Analyzed System specifications and Developed Test plan and involved in modification of Test Plan.
- Involved in Writing, Test Specifications, Test Case Development and Writing Test Procedures based on Design Specifications Provided.
- Reviewed Business Requirements Documents and the Technical Specification Documents.
- Actively participated in creating requirements traceability matrix, and test plans.
- Used Test Director to track, analyze and document defects.
- Used Test Director to plan tests, manage test assets, create and run manual test.
- Created test plan and test cases for manual testing and Automated testing.
- Performed Defect Reporting and Tracking using Test Director.
- Performed Positive & Negative Testing.
- Participated in various meetings and discussed Enhancement and Modification Request issues.
Environment: Test Director, Web Sphere, UNIX, Java, XML, SQL, Oracle 9i, Perl, J2EE, Windows XP.
