Qa Analyst Resume
St Louis, MO
EXPERIENCE SUMMARY:
- 4+ years of diverse experience in the field of Information Technology with emphasis on Software Testing, Quality Assurance, and Business Analysis.
- My background includes working of standard Software Testing Methodologies during the Application Development Life Cycle process.
- As a solution, oriented and seasoned professional with proven expertise in Agile driven STLC, Business Requirement Analysis and Software Development Life Cycle (SDLC) (Planning, Analysis, Design, Development, Testing, Integration, Support).
- Expertise in documenting the Business Requirement Document(BRD), Technical Requirement Document(TRD), generating the UAT Plan, maintaining the Traceability Matrix and assisting in Post Implementation activities.
- Expertise in performing Black - Box Testing, White-Box Testing, Automation, User Acceptance Testing (UAT), Frontend (UI) Testing, Back End Testing (Database), Stress Testing, Performance Testing, Functional Testing, and API Testing.
- Expert in reviewing Software Requirements Document, Functional Requirements Document, and Business Requirement Document.
- Experience in performance of Build Validation and Verification, Positive and Negative, Boundary Values Analysis, Equivalent Classes partitioning, Smoke, Sanity, Ad-hoc (Exploratory), Cross - Browser Testing.
- Expertise in testing BI/ETL project, E-Commerce, Travel domain, Healthcare EHR System.
- Experienced in Manual Testing of Web based application and Windows Client-Server application.
- Experienced in creating and developing Test Plans, Test Scenario, Test Cases, Test Script, and Test Data.
- Experienced in writing SQL queries using different types of joins such as inner join, outer join to perform Backend Testing.
- Ability to write and modify Complex SQL queries to identify ETL Processes.
- Experience in Data warehousing/ ETL Testing within the environment of Teradata EDW, Oracle.
- Experience in creating various reports using Business Intelligence tool and tested them against SAP environment.
- Experience in validating the Functional and Non-Functional requirement for ambiguity, scope creep, details, and testability.
- Hand-on experience in using Data Visualization, Reporting Tool QlikView and testing the dashboards created in QlikView /Qliksense.
- Experience in test management and defect tracking tools like Quality Center, JIRA, TFS.
- Familiar with industry standard methodologies like Agile, Water fall etc.
- Hand-on experience in Agile Software development, Scrum, and Iterative Development Methodology.
- Experience in testing of the application on Mobile and Tablet devices and on multi OS platform.
- Working knowledge of UML for Analysis and Design of the project.
- Experienced in creating various reports such as Coverage Analysis, Test Execution Report, Test Closure report, Test Result Summary Report.
- Experience in working with Stakeholders on defining and managing the Requirements, Change Request, Test Process, Estimates, Deliverables, Defects, and Execution Status Report.
- Experience in coordinating with developers, tester working at onsite, offshore, and remote location.
- Ability to prioritize and schedule multiple tasks on a day-to-day basis.
- Possess excellent communications skills and team oriented with proven leadership capabilities. A motivated self-starter with exceptional engineering and analytical skills with proven ability to integrate out of the box thinking & problem-solving analysis to improve processes, systems, and methodologies.
SOFTWARE SKILLS:
Testing Tools: QTP (Quick Test professional)/UFT v11.5, v11.53, v12.0, HP Quality Center/ALM 11, HP Sprinter 11.50, Jira, SOAPUI, Test Foundation Server(TFS), Microsoft Test Manager(MTM), HP LoadRunner9.1/8.1, Bugzilla
Testing Strategy: Unit, Module, Integration, System, Acceptance Testing
Testing Techniques: Black Box, White Box
BI Tools: QlikView 11,12, Qliksense
Programming Languages: C, C++, JAVA, VB6.0
Scripting Language: JavaScript, VBScript
Web Technologies: HTML, CSS, XML, PHP
Database: MS Access, MS SQL Server 2005/2008, Oracle 9i/10g/11g, Teradata
Technical Concepts: OOD & Data Structure Concepts (Sorting & Searching)
Office Tools: Word, Excel, PowerPoint, MS Visio
Operating System: Windows, Linux, Mac, iOS, Android
PROFESSIONAL EXPERIENCE:
Confidential, ST. Louis, MO
QA ANALYST
JOB RESPONSIBILITIES:
- Work in close contact with Business Analysts, QlikView Developer, and ETL Developer to understand the business data, technology, and reporting model.
- Transformed Business and System Requirement into Test Scenario and Test Cases.
- Experienced in designing Test Cases covering all test conditions and eliminating redundancy and duplication.
- Developed high-level documents, Test Plan, Test Scenario, and Test case to perform testing.
- Used HP Quality Center/ALM and JIRA for writing the test case and defect/bug management.
- Designed and executed test cases for QlikView and Qliksense applications in CSR, Commercial, and Finance BU.
- Performed Data Validation testing for various tables/views using complex SQL queries.
- Performed manual testing for the comparison of SAP BO reports with QlikView reports.
- Involved in Performance and Regression testing for the new Qlik reports and Qliksense application.
- Performed Smoke, Functional, and System Integration Testing of the application.
- Validated data model of QlikView with existing SAP BO using PL/SQL query in the Teradata EDW.
- Involved in the cross-browser testing of dashboards developed in QlikView/Qliksense.
- Verified the QlikView report data against the data in the database using SQL queries.
- Performed PL/SQL query to trigger the database.
- Verified the mapping of columns across various tables/views in Informatica PowerCenter.
- Verified the count of source data and target data in Informatica and recorded the time.
- Utilized Minus query to verify the source data against the target data.
- Wrote Complex SQL queries using Joins and Nested queries in Teradata SQL Assistant to verify data in database and reports.
- Performed analysis of the test results and reported it to the developer in case of the mismatch between the source and target systems.
- Involved in the review of data map and creation of ETL SQL queries.
- Perform end to end testing starting with verifying data from application through the model and then all the way to the reports.
- Make use of business objects to create meaningful reports Using QlikView that can be used by the business users for sales forecast, marketing, and other business use.
- Defect logging, tracking, and resolution carried out during the testing using ALM and JIRA.
- Attend daily standup and weekly review meeting to discuss issues and defect with Stakeholders.
- Create various deliverables such as Test Plan, Test cases, Requirements Traceability Matrix and Test Summary Reports.
ENVIORMENT: Quality Center/ALM 11, JIRA Enterprise Edition, Teradata EDW, Informatica, QlikView 12/Qliksense, SAP BO, SAP HANA, Teradata SQL Assistant, Oracle, SQL Developer, DataStage, MS Office, Unix, Windows 10
Confidential
QA ENGINEER
JOB RESPONSIBILITIES:
- Work with Scrum development team to improve the quality of the features delivered by coding and maintaining effective automated tests of those features by working with other software developers and consultants to ensure that features are designed in a way that facilitates automated testing. By analyzing designs and crafting test cases that can effectively reveal deficiencies in the code.
- Created Test Plan, Test Scenario and Test cases for the online travel portal using the Business and Functional Requirement document.
- Involved in performing Functional, GUI, Performance, Security, Cross Browser, and Backend testing of the website.
- Actively involved in analyzing and testing the website.
- Worked in close contact with the Billing and Invoice teams to gain a clear insight of how the various transaction will take place.
- Performed Content Management System(CMS) testing to validate whether the data /link/ image is displayed correctly.
- Executed SQL statement to validate table data with application output and to verify data in the database.
- Involved in Performance testing, Load testing and Stress testing of the website.
- Created, debugged, and executed test script in VBScript for Regression Testing using QTP.
- Created Test Plan, Test Cases for both manual and automated testing using QL/ALM.
- Performed manual performance testing to identify the various critical point on the website.
- Responsible for execution of manual and automated testing use cases and log the test results.
- Tested the web application with both positive and negative test data to monitor the functioning.
- Performed testing on web services using SOAPUI.
- Using QTP generated test scripts, run the script for testing through the life cycle of the project.
- Created several test scripts and object repository using QTP which can be used further in life cycle of project.
- Queried the database to verify the data stored in various tables and schemas.
- Responsible for logging the defect and tracking the defect using QC/ALM and JIRA.
- Created the Requirement Traceability Matrix(RTM) in MS Excel to map and trace user requirement with the test case.
- Review the work of other engineers in a collegial fashion to ensure the work product is of high quality and consistent with our standards.
- Performed testing on mobile and tablet devices in Android and IOS operating system.
- Analyzed the bugs, interacted with the developers on getting the problems fixed, verified, and closed the bugs as got resolved.
- Serve as a leading member of a Scrum team and participate in all planning, stand-up and retrospective meeting.
ENVIORMENT: Quick Test Professional (QTP v11)/ UFT, Quality Center/ALM 11, JIRA 6.3.3, PHP 5.5.11, XML, MySQL 5.6.18, MS SQL Server 2008, MS Office 2010, Windows 7
Confidential
QA ENGINEER
JOB RESPONSIBILITIES:
- Worked in Agile methodology, with an ability to accommodate and test the newly proposed change at any point of the time during the release.
- Interacted with business analyst and developers to analyze and understand the rules and know more about the application.
- Based on the information provided reviewed the requirement document, user stories and use cases to create various testing document.
- Prepared detailed Test Plan, Test Case document for both positive and negative scenarios in accordance with the Requirement document.
- Responsible for performing Black-Box Testing.
- Performed Functional, GUI, Performance, Security, Back-end testing of the application.
- Performed extensive Cross Browser, Load, Stress, and Performance testing on the application
- Performed regression testing using automation tool QTP.
- Created test script in VBScript for testing the application in different stages of application life cycle using QTP.
- Responsible for writing the Test scenario and Test cases in ALM and Team Foundation Server(TFS).
- Prepared Test cases to test the Database by retrieving the data from the tables using SQL Queries.
- Queried the database to verify the data stored in various tables.
- Made sure that the data entered from the front end is updated in the back end too.
- Verified the billing and payment transaction as well as invoice information.
- Responsible for testing the application on mobile and tablet devices using iOS and Android.
- Responsible for execution of manual and automated testing and document the test result.
- Analyzed the problem found during manual and automated testing.
- Performed User Acceptance Testing (UAT) to ensure that proper functionality is implemented.
- Responsible for creating Requirements Traceability Matrix and Test Results Summary Report using Excel.
- Defect logging, tracking, and resolution carried out during the testing using QC/ALM and Microsoft Test Manager.
- Held defect review meeting to discuss the defect found during the testing with the application team and get them resolved.
ENVIORMENT: Quick Test Professional (QTP v11), Quality Center/ALM 11, ASP .Net, Microsoft SQL Server 2008, HP LoadRunner, Test Foundation Server(TFS), Microsoft Test Manager(MTM) MS Office 2010, Windows 7
Confidential
QA TESTER
JOB RESPONSIBILITIES:
- Worked in an Agile/Scrum environment with frequently changing requirements and features.
- Work closely with business analyst and development team to understand the business requirement and translated them into an effective test cases design and ensure all requirement and scenarios are covered for testing.
- Involved in the ambiguity review of the BRD and FRD.
- Performed Functional Testing of the application within the Agile development environment.
- Developed Test Plan, Test Case for new and modified application using HP Quality Center.
- Created Test Case for manual testing of the application functionality.
- Performed Functional, GUI, Regression, Smoke, Security, UAT and Ad-hoc testing of the application.
- Used QTP for generating automated scripts, run scripts for testing through the lifecycle of the project.
- Created, debugged, and executed test script in VBScript for Regression Testing using QTP.
- Involved in Performance, Load, and Stress Testing of the application.
- Wrote SQL statement to verify data in the database.
- Executed SQL queries to validate table data with the application outputs.
- Tested the application manually before automating using QTP.
- Performed manual performance testing to verify various critical points in the application.
- Performed manual and automated testing and used Quality Center/JIRA to keep track of bugs and testing effort.
- Responsible for creating Requirements Traceability Matrix and Test Result Summary Report using Excel as well as Quality Center.
- Analyzed software bugs, interacted with the developer in getting the problem fixed, verified, and closed the bugs as they got resolved.
- Assist the business user during UAT and coordinate UAT Testing.
- Attended QA weekly meeting and various other meeting to discuss issues and defects in the application.
- Worked closely with the user and program developers to ensure application development meet the user expectation.
ENVIORMENT: Quick Test Professional (QTP v11)/ UFT, Quality Center, JIRA 5, XML, C#, MS SQL Server 2008, MS Office 2010, Windows 7
Confidential
INTERN QA TESTER
JOB RESPONSIBILITIES:
- Analyzed requirements by interacting with developers and business analysts and involved in Front End and Backend 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.
- Created test cases for manual testing of the application functionality.
- 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 other meetings to discuss issues and defects in the application.
- Interacted with Developers for Bug Fixes and Problem resolution.
- Documented and reported Defects manually using MS Excel.
Environment: Java SE 7, NetBeans 7.2, JDK 7, Oracle 9i, MS Office, Windows 7
