Sr. Qa Analyst Resume
Cleveland, OH
SUMMARY
- Over 7 years of experience in software industry with emphasis on Quality Assurance of both Client - Server and Web based Applications in Manual Testing and Automation Testing.
- Extensive experience in testing Java, ASP .NET, VB based applications in both Windows and UNIX environments.
- Strong Back-End Database (Oracle, SQL Server) testing skills using SQL & Toad.
- Experienced in Agile and Waterfall testing.
- Involved in the ETL processes where in the organization were using Informatica.
- Experience in analyzing Functional Specifications, Use Cases and Business Requirements to prepare test plans, test procedures that follow different QA Methodologies.
- Involved in maintaining existing Test Plans, Test Cases based on the enhancements and Change Requests.
- Proficient in Functional Testing, System Testing, Integration Testing, Smoke Testing, GUI Testing, End-to-End Testing, Positive Testing, Negative Testing, Cross Browser Testing and User Acceptance Testing.
- Experience in using test management tools such as Quality Center during entire testing phase.
- Extensively used Microsoft Office for documentation.
- Performed Regression Testing using automation tools such as Quick Test Professional.
- Proficient in developing, enhancing and executing automated testing VB scripts for Quick Test Professional.
- Actively participated in all phases of the Manual testing cycle including reviews and project status meetings.
- Strong ability in analyzing business requirements (BRD) and interacting with the Business users.
- Excellent analytical skills coupled with effective technical writing and verbal communication.
TECHNICAL SKILLS
Operating Systems: MS DOS, UNIX, Windows NT/ 2000/ XP and Linux
Languages: C, C++, COBOL, JCL, JAVA, SQL, PL/SQL, T-SQL, Shell Scripting
RDBMS: Oracle 7.x/ 8i/ 9i, MS SQL Server and DB2
Web Technologies: HTML, ASP .NET, Java Script, J2EE, Java Servlets, JSP
Application servers: Web logic, Web sphere and IIS
GUI Tools: Oracle Developer 2000 and Visual Basic 5.0/ 6.0
Testing Tools: QTP, Quality Center, Rational Suite (Requisite Pro, Rose, Robot, Test Manager, Clear Quest, Clear Case)
PROFESSIONAL EXPERIENCE
Confidential, Cleveland, OH
Sr. QA Analyst
Responsibilities:
- Gathered and analyzed Business, Functional Requirements, System Specifications and Design documents.
- Developed Test Plans, Test Cases, Test Scripts, Test Scenarios, and Traceability Matrix.
- Involved in creation of the Test Scripts according to the test plan and Use cases.
- Coordinate meetings with project and development teams to communicate project issues.
- Responsible for doing functional, regression, System integration, Component Integration and UAT testing.
- Uploaded the test scripts into Quality Center.
- Tested the GUI of the application comparing to the standards.
- Created and maintained the Traceability Matrix and Test Matrix and helped the QA Testing teams.
- Performed back-end testing extensively using SQL & TOAD. Wrote and Executed SQL Quires for Oracle database testing.
- Extensive Experience in testing Extraction, Transformation and Loading (ETL) mechanism-using Informatica.
- Working experience in creating SQL queries that involved complex operations joins and sub queries.
- Created several SQL queries on the fly for some specific requirements for trouble shooting day-to-day production issues to identify root cause.
- Followed the Agile testing and Scrum methodology for the integration and regression testing approach.
- Participated in daily scrum meetings for the testing part along with the developers.
- Attended regular project meetings and follows up with team members as required focusing on business and operational issues or technical issues.
- Executed the manual and QTP Automation regression scripts.
- Developed and modified the QTP automation scripts according to the requirements and releases.
- Executed the test scripts in quality center and responsible for reporting the defects by using Quality center defect tracker.
- Attended the status meetings and reporting the issues and also collecting status from all other team members.
- Worked with group projects as well as individual projects and sending the status report to manager each and every week.
Environment: s: Quick Test Pro 9.2, Quality Center 10.0, Oracle 9i,DB2, SQL, TOAD, ASP .NET, Visual Studio, Visual Basic, Rational Suite, Informatica, Webserver IIS 6.0, IE, HTML, XML, UNIX, Windows 2003/ XP.
Confidential, Houston, TX
Sr QA Analyst
Responsibilities:
- Worked actively with Business Analyst to nail down the requirements for all the releases and enhancements
- Partnered with Business Analyst and Developers in building traceability across Requirements, Design Specifications, Test Scenarios and Test Cases
- Developed Test Plans, Test Scenarios and Detailed Test Cases based on the Use Case Documents, Business Requirements and Functions Specifications
- Planned and documents the test approach and strategy for critical Business Scenarios in End to End fashion
- Created End to End System test cases based in Business Process identified with the help of business users
- Planned Integration testing across different systems to verify and validate the application and its modules
- Conducted Functional, Integration, System, UAT and Regression testing for the applications under test
- Identified Test data requirements based on Business Requirements, Use Case Document and Test Scenarios
- Masked test data form Production and pre production database to test environment to conduct various testing
- Identified, classified, reviewed and resolved defects in consultation with developers and other team members using Quality Center, maintained all the defects matrix
- Manually performed Back-End testing by creating SQL queries on Oracle and MS SQL database
- Performed End-to-end and UAT testing of the applications partnered with Users, Dev and BA teams
- Partnered with Test Environment support team in building Test Environment and loading test data for all testing
- Coordinated and worked with different teams environment, to achieve project quality goals
- Created reports and release notes for software releases and enhancements updated with testing details
- Wrote complex SQL queries to perform the backend testing of the Oracle database using PL/SQL
- Enhanced Scripts by Putting Check Points like standard checkpoints, Text Checkpoint, output values by putting Text Area output value Check point, passing values between actions if the scripts needs.
- Involved in writing scripts, which involved some advanced programming of scripts using QTP.
- Used object spy to know the properties of the object, which helped me in writing my QTP scripts
- Used the Smart Identification in QTP in order to identify the dynamic objects
- Validated data files and data extractions from Relational Database systems Source to Stand alone target systems
- Created Risk Assessment documents with list of defects identified in testing and associated production risk
- Represented QA in release status meetings with different groups including Product Management, Dev and DBA
- Responded to inquiries from users and technical support regarding functions and operations of the application
- Trained and supported users, assisted users to isolate possible problems in software after implementation
Environment: Quality Center, Quick Test Pro, DB2, Oracle, Rational Suite, SQL, PL/SQL, SQL Server, Java, J2EE, Webserver IIS 6.0, IE, HTML, XML, UNIX
Confidential, Franklin, TN
Sr QA Analyst
Responsibilities:
- Gathered and analyzed Business, Functional Requirements, System specifications and Design documents.
- Created System Test Plan, Test Scripts and Status Report Templates which were used in multiple projects.
- Prepared test coverage matrix and the traceability matrix in Quality center.
- Drafted test cases to cover all areas of the test coverage matrix.
- Reviewed all business requirements, use cases, process flows, data definitions and business rules for test case preparation and execution.
- Reported variances using defect tracking tool Quality Center and give input to the Test completion report.
- Conducted walkthroughs and presentation of the Test requirement group and test cases to development and business team.
- Participated in walkthroughs in the Requirements, Detailed Design, and Construction phases as determined by the project team.
- Responsible for reporting, updating and maintaining the Quality Centre for all the defects found during Functional and regression testing as well as following up on the bug life cycle.
- Extensively used Descriptive Programming to develop Scripts from Scratch.
- Verified and Validated the Data using SQL queries in QTP.
- Developed test scripts using DDT (Data Driven Testing) with QTP.
- Performed parameterization techniques to use different set of customer data on a script to generate expected reports.
Environment: Mainframe, Quality Center, Quick Test Pro, Java, Java script, VB Script, SQL, Oracle, MS. Excel, HTML, Lotus Notes, Windows NT/XP.
Confidential, Raleigh, NC
Sr. QA Tester
Responsibilities:
- Developed detailed Test Plans and Test Cases in Test Director and executed them
- Participated in Business Analysis, Requirement Analysis and Data Analysis
- Test Cases were designed based on Use Cases and Requirements in Test Director
- Maintained requirements in Test Director and requirements are traced to Test Cases in Test Director
- Performed GUI, Functional, System-Integration and Regression testing
- Extensively used SQL for data integrity testing at the backend
- Investigated Software defects and interacted with Analysts to resolve technical issues
- Involved in analysis and study of functional specifications for the enhancement of existing functionality
- Conducted Smoke Testing on new versions
- Maintained and Troubleshooter Network and its problems in the testing environment
- Responsible for System Testing, Regression Testing and Acceptance Testing
- Recommending continuous process improvement, maintain QA standards and artifacts
Environment: Windows 2000, Mercury Interactive Tools 6.0/ 6.5 (Test Director), Mainframes Java, Java script, ASP, HTML, SQL Server 2000, MS Word, Ms Excel, MS Project.
Confidential, Charlotte, NC
QA Tester
Responsibilities:
- Created end to end test cases for the project
- Involved in creation of Test Plan, Test Cases and Test Specification
- Performed Functionality Testing
- Participated in Manual and Automated Testing
- Manually tested access levels and privileges of personnel handling adjustment
- Created and performed Compatibility Testing procedure
- Created different Test scenarios to validate the customer class role type decisions
- Performed Back end testing using PL/SQL
- Created ODBC Vuser scripts in LoadRunner to measure database performance
- Used correlated queries to resolve dependent queries in database Vuser scripts
Environment: WinRunner, Test Director, Java, JavaScript, JSP, HTML, DHTML, Oracle, MS Office, SQL, Windows NT and UNIX.
