We provide IT Staff Augmentation Services!

Senior Qa Analyst Resume

St Louis, MO

SUMMARY:

  • 5+ years of experience in the field of Information Technology with emphasis on Software Quality Assurance and support activities.
  • My background includes working knowledge of the standard Software Testing Methodologies during the Application Development Life Cycle process.
  • Furthermore, I have done Black Box testing of stand - alone and Client/Server applications using regression, front end, back end, stress, performance and functional testing.
  • Knowledge of Software Development Life Cycle (SDLC) (Planning, Analysis, Design, Development, Testing, Integration, and Support) and Software Testing Life Cycle (STLC).
  • Expert in reviewing the Software Requirements Specifications, Functional Requirements Document and Business Requirement document.
  • Created test planning documents from User stories and Use cases
  • Experienced in creating and developing Test Plans, Test Scenarios Test Cases, Test Scripts and Test data
  • Ability to write and modify SQL statements for ETL and backend testing.
  • Hands-on experience in writing nested SQL and complex SQL queries using different types of joins such as inner join, outer join
  • Data Warehousing/ ETL Testing within the environment of Oracle, SQL Server
  • Reviewing and testing of data maps between various legacy systems and relational databases
  • Worked with Business Analysts and Functional Team members to translate Business requirements into ETL technical specifications
  • Exposure to Business Object testing in creating various reports for business users
  • Created various reports using Business Intelligence and tested them against the SAP environment
  • Performed testing on e-Commerce application
  • Proficient in gathering Test Data, Test Data Conditioning and identifying the test data needs
  • Hands-on experience in System testing, Integration testing, Regression testing, Data Driven testing, User Acceptance Test (UAT), End to End testing, White Box, Black Box, Sanity Testing, Load testing and Functionality Testing.
  • Proficient in using the following Automated Testing Tools: Quick Test Professional, Load Runner, Soap UI and Quality Center/Application Lifecycle Management for both Web based and client / server applications.
  • Familiar with industry standard methodologies like Agile/SCRUM, Water Fall etc.
  • Ability to work well in fast paced, dynamic team environment.
  • Hands-on experience in Agile Software Development, Scrum and Iterative Development methodology
  • Working knowledge of UML for Analysis & Design of the project
  • Created various reports such as Coverage Analysis, Test Execution Report, Test Closure report, Test Results Summary Report
  • Good communication, leadership and interpersonal skills.

AREAS OF INTEREST:

Quality Assurance, SQL, Testing tools and techniques

STRENGTH:

Explore Business Requirements, Analysis, Testing (Manual and using Automated tools), Fault Finding and Strong Communication skill

SOFTWARE SKILLS:

Testing Tools: Application Lifecycle Management 11, Quality Center 10.0, 9.x, Team Foundation Server (TFS), Microsoft Test Manager (MTM), Quick Test Professional (QTP) 10.0, 9.x, HP Load Runner 9.1/8.1, Soap UI, Bugzilla, TOAD/SQL Developer for Oracle, Selenium

Testing Strategy: Unit, Module, Integration, System, Acceptance Testing

Testing Techniques: Black Box, White Box

Programming Languages: C, C++, VB6.0, ASP, .Net, C#

Database: Access, MS SQL Server 2005/2008, Oracle 9i/10g/11g

Technical Concepts: OOD & Data Structure Concepts (Sorting & Searching)

Office Tools: MS office, MS Visio, MS Project

Operating System: Windows, Linux, Mac, iOS, Android

EXPERIENCE:

Confidential, St Louis, Mo

Senior QA Analyst

Responsibilities:

  • Worked with business analysts and business users to understand the business rules and know more about the application
  • Met with the marketing team to understand the Marketing strategies that they would employ on the e-commerce site
  • Worked in close contact with the Billing, Invoice and Distribution teams to gain a clear insight of how the various transactions will take place
  • Gained a deep knowledge of the delivery process involved in delivering goods
  • Based on the information provided, reviewed the user stories and use cases created by the business analysts to create various testing documents
  • Responsible for creating Test Plans, Test Scenarios and Test case document
  • Documented the test scenarios and test cases in Team Foundation Server and Microsoft Test Manager
  • Performed Functional, GUI, Performance, Security and Back-end testing of the application
  • Queried the database to verify the data stored in various tables and schemas
  • Made sure that data entered from the front end is updated in the back-end
  • Gathered test data from database and SAP to carry out testing
  • Verified billing and payment transactions as well as invoice information in SAP
  • Also tested the application on mobile and tablet devices using iOS and Android
  • Acted as an ecommerce consumer to make sure the system worked as desired
  • Co-ordinated UAT testing and helped business users set up their test environment to carry out their testing
  • Microsoft Team Foundation Server(MTM) and Team Foundation Server (TFS) were for defect logging, tracking and reporting
  • Held defect review meetings to discuss the defects found during testing with the application team and get them resolved

Environment: Application Lifecycle Management 11, Mainframe environment, MS Office 2010, Windows 7, SQL Server 2008, Team Foundation Server, Microsoft Test Manager, SAP portal, .Net 4.0 frameworkiOS, Android

Confidential

Senior QA Analyst

Responsibilities:

  • Work closely with business analysts to understand the business requirements and gain knowledge of the application
  • Work in close contact with the Business Object Developer to understand different reports and create test case document
  • Use statistical and mathematical skills to analyze data in various reports in order to perform testing on those reports
  • Create Master Test Plan and Test scenario documents
  • Work closely with existing client development teams to ensure all requirements and scenarios are covered for functional as well as backend testing.
  • Responsible for writing the Test Scenarios and Test Cases in ALM and Team Foundation Server (TFS)
  • Work in close contact with the Test Data Conditioning team to identify and acquire the test data needed for testing
  • Responsible for doing Smoke Testing of the application
  • Involved in Functional Testing of the application, Test Planning as well as Test execution
  • Involved in the review of data maps and creation of ETL SQL queries
  • Involved in data validation using complex SQL queries and backend testing
  • Perform backend testing of the application using SQL queries that contain nested queries, joins and functions
  • Verify front end data against the backend data using various SQL queries
  • Utilized Minus query to verify the source data against the target data
  • Make use of business objects to create meaningful reports that can be used by the business users for sales forecast, marketing and to create invoices
  • Perform testing in windows as well as web-based environment
  • Create various deliverables such as Test Plan, Test cases, Test Summary Reports.
  • Defect logging, tracking and resolution carried out during the testing using ALM and Microsoft Test Manager
  • Creating Test Closure report to capture the testing status at the end of each testing cycle

Environment: Application Lifecycle Management 11, Mainframe environment, MS Office 2010, Windows XP, Windows 7, SQL Server 2008, Team Foundation Server, Microsoft Test Manager, Business Objects, Cognos, SAP portal, Beyond Compare

Confidential

Senior QA Analyst

Responsibilities:

  • Review business requirement documents and meet with business analysts to understand the application
  • Do analysis of the requirements document and gain knowledge of the business rules
  • Create Test Plan documents and document the types of testing to be performed on the application
  • Involved in creation of Test Scenarios and Test cases in Team Foundation Server (TFS) and Microsoft Test Manager(MTM)
  • Create requirements traceability matrix(RTM)to link test cases to the requirements and vice versa
  • Perform Test data creation and mock test data as per the business rules
  • Query database to gather test data for testing
  • Carryout different types of testing such as Smoke, Functional, GUI, Performance, Security testing and Back end testing
  • Performed testing on Windows and Web application
  • Write complex SQL queries to retrieve data from the database for testing purposes
  • Do testing of the batch jobs and make sure that required test data files are created
  • Execute test cases from TFS and store the results in TFS
  • Defect logging and tracking using Team Foundation Server and Microsoft Test Manager
  • Escalate defects found during testing to the application team
  • Conduct defect review meeting with the application team to discuss status of the defects found during testing
  • Create Test Closure report once the testing is completed
  • Work in close contact with the Business Analysts, Developers and Project Managers in order to successfully carry out testing activities

Environment: Application Lifecycle Management 11, Mainframe environment, MS Office 2010, Windows 7, SQL Server 2008, Team Foundation Server, Microsoft Test Manager, SAP portal, .Net 4.0 framework

Confidential, St Louis, Mo

QA Analyst

Responsibilities:

  • Work closely with business analysts to understand the business requirements and translate them into an effective test case design.
  • Involved in the Ambiguity review of the BRD and FRD
  • Work closely with existing client development teams to ensure all requirements and scenarios are covered for testing
  • Actively involved in analyzing and testing the application.
  • Create Test Plan based on the various requirements for testing
  • Responsible for writing the Test Scenarios and Test Cases.
  • Work in close contact with the Test Data Conditioning team to identify and acquire the test data needed for testing
  • Responsible for doing Smoke Testing of the application
  • Performed Functional, GUI, Performance, Security and Cross Browser testing of the application
  • Involved in Functional Testing of the application, Test Planning as well as Test execution
  • Tested various graphs and grids and analyzed the data in the graph to make sure it matched
  • Performed complex calculations in order to verify data stored in various grids
  • Involved in data validation using complex SQL queries and backend testing
  • Perform backend testing of the application using SQL queries that contain nested queries, joins and functions
  • Verify front end data against the backend data using various SQL queries
  • Perform testing in windows as well as web-based environment
  • Perform testing using tools such as Quality Center/Application Lifecycle Management
  • Create various deliverables such as Test Plan, Test cases, Test Summary Reports
  • Carried out manual performance testing to make sure that application is loaded within the required time
  • Defect logging, tracking and resolution was carried out during the testing in QC/ALM
  • Responsible for creating Requirements Traceability Matrix and Test Results Summary Report using Excel as well as ALM
  • Assist the business users during UAT testing and co-ordinate UAT testing
  • Work closely with the Business Analysts, Project Manager, Developers and Business users and coordinate all the testing activities

Environment: Application Lifecycle Management 11, Mainframe environment, MS Office 2010, Windows XP, Windows 7, SQL Server 2008, Oracle 9.0, 10g, .Net 3.5 framework

Confidential, Amarillo, TX

QA Automation Tester

Responsibilities:

  • Analyzed System or Business requirements and identified the Test scenarios based on requirements and involved in preparation of Templates for Test cases.
  • Created Test Plans and Test Cases in concert with system engineers.
  • Developed Test Plans, Test Case design using Quality Center.
  • Wrote SQL statements to verify data in the database
  • Executed SQL to validate table data with Application out puts.
  • Used QTP for generating automated scripts, run scripts for testing through the life cycle of the project.
  • Created several test scripts using QTP, which include data-driven tests and batch tests.
  • Gathered the Test Input data. Test Input data includes Pre-condition, Test Input, and Test Result data.
  • Tested the application manually before automating using QTP.
  • Involved in performance testing, load testing and stress testing of the application.
  • Created, debugged and executed test scripts in VBScript for Regression Testing using QTP.
  • Performed Black box testing.
  • Performed Manual performance testing to identify various critical points in the application.
  • Responsible for delivering product builds, analyzing build results, modifying and optimizing build tools, and contributing to technical documentation.
  • Prioritized problems based on the effect of the application on the end user.
  • Developed Test Plan for functional and graphical user interface testing.
  • Created test cases for manual testing of the application functionality.
  • Performed manual and automated testing and used Quality Center to keep track of bugs and testing efforts.
  • Analyzed software bugs, interacted with the developers on getting the problems fixed, verified and closed the bugs as they got resolved.
  • Performed Backend testing by writing and executing SQL queries.

Environment: Quick Test Professional, Quality Center, Load Runner, VB.net 3.5, Oracle 9i, Active X, MS Office, Windows XP

Confidential, Wichita Falls, TX

Manual Tester

Responsibilities:

  • Created Test Plans and Test Cases based on requirements.
  • Developed Test Plans, Test Case design using Quality Center.
  • Used QTP to generate and run test scripts for testing.
  • Created several test scripts using QTP, which include data-driven tests and batch tests.
  • Gathered the Test Input data. Test Input data includes Pre-condition, Test Input, and Test Result data.
  • Created oracle queries to validate database table values.
  • Executed SQL statements to validate backend and front end values.
  • Tested the application manually before automating it using QTP.
  • Involved in performance testing, load testing and stress testing of the application.
  • Created, debugged and executed test scripts in VBScript for Regression Testing using QTP.
  • Performed Black box testing.
  • Performed Manual performance testing to identify various critical points in the application.
  • Prioritized problems based on the effect of the application on the end user.
  • Developed Test Plan for functional and graphical user interface testing.
  • Created test cases for manual testing of the application functionality.
  • Performed manual and automated testing and used Quality Center to keep track of bugs and testing efforts.
  • Performed Backend testing by writing and executing SQL queries.

Environment: Quality Center, Quick Test Professional, ASP.net 3.0, Oracle 9i, MS Office, Windows XP

Confidential

QA Analyst

Responsibilities:

  • Prepared Test cases to test the Database by retrieving the data from the tables using SQL Queries.
  • Involved in Black box, Manual as well as Automated Testing and prepared Test Suite for all the Test Cases.
  • Responsible for developing test plan, test cases for functional and GUI testing of the system.
  • Executed test cases manually to verify the expected functionality meets user controls by executing reports
  • Extensively tested the graphical user interface components.
  • Performed extensive load, stress and performance testing of the application.
  • Performed Cross Browser functionality testing.
  • Participated in Bug review meetings.
  • Analyzed the problems found during manual and automated testing.
  • Performed Load and Stress testing using Load Runner to check the performance of the application.
  • Assisted in documenting the user manual for end users.
  • Worked closely with Test analysts to ensure test environment and data readiness.
  • Responsible for ensuring that automated script repository is properly maintained and all test processes are fully documented.
  • Participated in design, use case reviews and quality inspections for each release.

Environment: Load Runner, Visual Studio.net 2.5, Oracle 9i, MS Office, Windows XP

Confidential

QA Tester

Responsibilities:

  • Analyzed requirements by interacting with developers and business analysts and involved in Batch process and Front End Application Testing.
  • Performed Functional, Integration, System and Navigational Testing for the different modules.
  • Performed user acceptance testing (UAT) to ensure that proper functionality is implemented.
  • Developed and executed SQL Queries to perform database testing
  • Involved in writing the SQL queries to test the test cases of how the data is retrieved, updated and deleted in the tables.
  • Attended QA weekly meetings and various other meetings to discuss issues and defects in the application.
  • Interacted with Developers for Bug Fixes and Problem resolution.
  • Documented and reported Defects manually

Environment: Visual Studio.net 2.0, SQL Server 2005, Active X, MS Office, Windows 2000

Hire Now