Qa Tester/data Base Analyst Resume
Houston, TX
SUMMARY:
- Over 7+ years experienced IT Professional with diverse experience in Software Quality Assurance.
- Strong understanding of the Software Development Life Cycle (SDLC) with Manual and Automation testing and methodologies like Waterfall and Agile .
- Tested software including Client/Server, Stand - alone and Web based applications.
- Experienced with QA methodology to ensure good Quality Control.
- Well versed in using Defect Tracking Tools including HP Quality Center and JIRA.
- Created Test schedules, Test Scenarios, Test Strategy, Test Plan, Test Cases, test summary report, defect tracking documents.
- Experience in testing through a full system development and testing life cycle.
- Strong knowledge on working E-commerce application, POS system, inventory tracking, credit card processing, e-wallet payment.
- Expertise in automating test cases with Selenium.
- Good knowledge of Data modeling.
- Good knowledge of automated testing tools such as QTP and Load Runner
- Experience with Retail Pricing Management.
- Experience in Manual, Regression, Functional and Configuration Testing.
- Expertise in writing basic to complex SQL queries to perform back end testing, batch job processing in SQL Server and Oracle database environment.
- Strong Experience in Smoke, Exploratory, Functional, Regression, Performance and User Acceptance testing for the highly structural and complex systems.
- Expertise in Test Case/Test Procedure Design, developing Requirement Traceability Matrix (RTM), Test Tool Usage, Test Case Execution, Defect Management and Defect Tracking, creating Test Scripts, reviewing Log files & Reports for delivering utmost Quality product
- Create and send issue reports to project team and management during test cycles.
- Involved in generating Test Scripts using Quick Test Pro (QTP) for different transactions to execute Functional Testing, Regression Testing and Acceptance Testing.
- Extensive experience in writing scripts using VB Script, Ruby, JavaScript, Java/Selenium to automate testing process
- Expertise in reviewing and analyzing Software Requirements Specification documents SRS, Business Requirement Documents BRD .
- Good experience in developing different type of framework like Keyword driven, Data driven and Hybrid framework. Excellent knowledge of SQL, capable of writing SQL queries.
- Created automated test scripts with Java. Also possess experience in using SOAPUI for testing web services developed using SOAPUI.
- Experience programming in Java, JavaScript, HTML, XML and SQL on Windows XP, Vista Operating Systems and UNIX environments.
- Remarkable communication and organizational skills with attention to business process details besides being a team player and self-starter.
- Experienced in load and performance testing tool JMeter.
- Expertise of testing the application developed using various mobile technologies including J2ME, Blackberry, Android, Technology etc.
- Experienced in testing client server and web based applications using HP tools like Quick Test Professional (QTP), Quality center (QC). Also possess good knowledge of UNIX/Linux shell commands to tail the logs, adding users, starting services from the shell, settings aliases to frequently used commands, creating users and settings file system permissions.
TECHNICAL SKILLS:
Automated Test Tools: Selenium WebDriver/IDE/GRID/RC, HP Quality Center/ALM, Junit, TestNG, JIRA, SOAPUI, QTP, Eclipse, JMeter, Cucumber, Firebug, Appium
Test Reporting Tools: HP Quality Center, Bugzilla, Visual Studio TFS, JIRA.
Languages/scripts: Java, JavaScript, Shell Script,C++, SQL, PL/SQLVB Script(UFT), .NET
Frame works: Junit, TestNG
Operating System: Windows/vista & server 2003, UNIX and Mac.
Databases: MS SQL Server 2000/2005, OLAP and OLTP, Oracle 9i/10g, MS Access 2000SQL, Oracle PL/SQL, SQL*Plus, TOAD, SQL*Loader, MYSQL
Methodologies: Agile, Waterfall
Packages: MS Office
PROFESSIONAL EXPERIENCE:
Confidential, Houston, TX
QA Tester/Data Base analyst
Responsibilities:
- Analyzed Functional Requirements and Software Specification Requirement Documents to develop Test Plan for projects involved and wrote Test Scripts.
- Responsible for automating test scripts in Selenium/Java to support of software test requirements
- Involved in setting up configuring the testing environment with Eclipse IDE, Testing, and Selenium WebDriver.
- Involved in designing and developing Testing Data driven automation framework in Eclipse IDE using JAVA and automated them using Selenium Web Driver.
- Developed the Performance Test Plan & Scope documents and Performance Test Cases.
- Created virtual users in Load Runner for Performance testing and analyzed the reports based on the different scenarios.
- Develop scenario based testing for the JMeter scripts
- Tested performance of web application and generated automation test scripts for different scenarios
- Involved in Data mapping specifications to create and execute detailed system test plans.
- Involved with Data Analysis Primarily Identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats .
- Provided Data Modeling design standards, solutions to various data marts and product teams.
- Used TestNG to run the tests and generate the reports.
- Used ANT to build and run the Selenium automation framework and sending the automation reports over mail.
- Configured the test suite to Jenkins to make it run on every successful deployment.
- Reviewed and validated SQLs, extracted Reports Data for SMEs and UAT reviews
- Created Data Model templates and sessions resolved Change Requests (CRs) and updated data models.
- Implemented cross browser testing using Selenium API for Firefox, chrome and IE.
- Responsible for maintaining complete VMware infrastructure for the customer.
- Worked with deployment team to create automation regression execution builds.
- Extensively worked on JMeter to create Thread Groups and test Web Application for various loads on key business scenarios
- Designed and implemented basic SQL queries for backend testing.
- Expertise in Selenium Automation using Selenium WebDriver, Selenium IDE, Java, TestNG.
- Supported automated functional testing, acceptance testing, system down testing, cross browser, cross platform web testing with Selenium Web Driver and Appium.
- Profound experience in Performance Testing using JMeter on REST APIs with both GUI and Non-Interactive modes and analyzing reports.
- Working on creating Rest Services using ASP.NET Web API and JAVA.
- Involved in doing performance testing of service using JMeter (Web: HTTP, HTTPS; WebServices: XML, SOAP
- Performed automated acceptance tests written in TDD (Test Driven Development) using cucumber.
- Involved in Automation Framework using Selenium, TestNG, Selenium server.
- Attended daily scrum meetings to evaluate the daily expected results for the team. and the reports is shared with each and every team member and the defects are raised in Visual studio.
- Prepared Traceability Matrix to show the test coverage requirement vs. Test scripts.
- Skilled in performing load, stress and performance testing using Apache JMeter
- Reported defects using QC and interacted with developers to resolve any defects/issues.
- Attended the daily Bug review meetings, weekly status meetings and walkthroughs and interacted with Business Analysts and Developers for resolving Defects.
Environment: JAVA, TestNG, Jmeter,Eclipse IDE, Firebug, HP Quality Center, Selenium WebDriver, Oracle, Toad, Junit, TestNG, Bugzilla, cucumber, soup UI
Confidential, Centennial, CO
QA Analyst.
Responsibilities:
- Created test cases, test scripts, and test procedures for UAT and implement compliance of quality standards for POS in the project.
- Performed System testing and Functionality Testing using Point-of-Sale (POS) on highest scale.
- Used QC for requirement and defect tracking.
- Involved in requirement gathering of the Data Warehouse, analyzing business requirements, Data Model Design, Data flow from various Sources.
- Tracked the defects, prepared status summary reports and reported defects through HP ALM.
- Wrote and executed test cases using HP ALM.
- Performed both manual and automated testing of the applications.
- Used HP Quality Center for test planning, test designing, test analysis, test execution, defect tracking and test evaluation.
- Performed User Acceptance during the Project
- Involved in creating and executing automation scripts using UFT (VB scripts, Descriptive programming) to perform the Regression testing
- Automated manually written test cases by using UFT .
- Performed data driven testing in UFT for both positive and negative data by using parameterized values from the built-in global and local action data tables.
- Created Function Library for common functionality of the application.
- Wrote SQL queries for validating the data mapping and data integrity.
- Developed test scripts in VB script for Data Driven tests. Executed the test scripts and analyzed the results.
- Wrote extensive SQL queries to communicate with the Oracle Backend for data accuracy, integrity and security checks.
- Supported Performance tester with the Performance and Load testing using Load Runner.
- Executed Test scripts from a custom QTP framework that required the updating of environment variables, configuration files, and data files.
- Created QTP object repositories for applications that would be used to design a new custom automation framework
- Handled exceptional situations in test scripts using Recovery Scenario Manager in Quick Test Pro (QTP).
- Developed test scripts and test cases using QTP/UFT, Quality Center, and Load Runner.
- Experienced in developing Data driven, Key word driven and Hybrid Framework using QTP/UFT.
- Managed and closely participated in the Project Management of Point-of-Sale (POS) Initiatives
- Checked front-end validations, front-end creation (images, forms and pages) and form validations on server side.
- Performed backend testing using SQL Queries, PL/SQL stored procedures and triggers to verify that data is inserted into appropriate tables.
- Analyzed and performed capacity testing of production database from time to time
- Interacted with developers to resolve application defects and for configuration management.
- Performed testing to monitor availability and errors for application client server, database and web server.
- Used the Load Runner online monitors to monitor the possible bottlenecks in the application.
- Performed Regression testing using HP UFT.
Environment: Quick Test Pro, HP Quality Center/ UFT, SQL Server 2014, MY SQLserver, Windows 10, JIRA, HP Load Runner.
Confidential, NH
Quality Analyst
Responsibilities:
- Developed and executed test cases test Scenarios and followed-up defects using HP ALM
- Developed automated test scripts for performing regression testing on the application using selenium.
- Developed test scripts in web driver for Data Driven tests. Executed the test scripts and analyzed the results.
- Provided support to POS group staff, as well as other corporate & park level personnel on all POS systems throughout the enterprise.
- Refined the requirements (use-cases) and Business Process Models to detailed level appropriate for technical analysis and system design.
- Followed up with reviewers, and approvers to promote document flow through the system
- Effectively logged and managed defects found during project system testing, and successfully interacted with the offshore development team to provide input for system fixes
- Performed Developed cases and scripts using selenium for Functionality, Security and Regression Testing.
- Created Text area Checkpoints to test the properties of the text in the application using selenium.
- Tested the properties of the tables using table checkpoints using selenium and created page checkpoints to test the properties and contents of the web page using selenium.
- Conducted Parameterization to data tables using selenium and created Multiple Actions using selenium.
- Created Scenarios to conduct the load test using LoadRunner.
- Performed Configuration Testing and conducted Back-end and Regression testing during the various phases of the application.
- Reviewed extensive SQL Queries with complex multi-table joins and nested queries.
Environment: Selenium, Load Runner, Agile, SQL, MY SQL server ALM.
Confidential, AL
Quality Analyst
Responsibilities:
- Prepared Test Plan and Test Cases according the business requirements.
- Prepared Unit Test Cases including Positive and Negative test cases.
- Participated in setting up testing environment.
- Design and development of QTP test scripts.
- Uploading and executing the scripts and analyzing the test results.
- Developed and executed automation scripts using QTP.
- Maintaining automation test scripts to meet software release deliverables, project testing requirements and other quality assurance consideration.
- Performed Developed Test cases and scripts using HP Quality Center, JIRA and Quick Test Pro for Functionality and Regression Testing.
- Performed Ecommerce Testing for modules such as Checkout, Payment page, Shipping page, valid store page, etc.
- Responsible for the implementation of the Agile and Software Development Best Practices for Product & Solutions Delivery (PSD).
- Involved in manual testing and Automated Testing.
- Performed back-end testing using SQL queries and PL/SQL statements on the Oracle database.
- Performed website testing for order fulfillment process.
- Used SQL statements to check data integrity and data validation.
- Created Text area Checkpoints to test the properties of the text in the application using Quick Test Pro.
- Involved in cross browser testing for Firefox, Mozilla, Chrome and IE.
- Conducted Back-end and Regression testing during the various phases of the application.
- Involved in debugging and reproducing issues.
- Involved reporting and tracking the defects using HP Quality Center and JIRA.
- Reported bugs using Defect module of HPQC.
- Conducted result analysis and interacted with developers to resolve bugs.
- Participated in the project meetings and attended the daily SCRUM meetings.
Environment: HP Quality Center, JIRA, UFT, SQL Server, Oracle, MS Excel, MS Word, Agile, Windows.
Confidential
Quality Analyst
Responsibilities:
- Good Knowledge of Customer Relational Management and making test cases under those criteria.
- Wrote comprehensive test plans and test scenarios for user acceptance, regression, functional, and stress and load testing.
- Performed data validation testing using Point-of-Sale (POS) system.
- Developed automated test scripts for performing regression testing on the application using Quick Test Pro (QTP).
- Used synchronization points, standard checkpoints, bitmap checkpoints, database checkpoints and text checkpoint in QTP scripts to optimize the script.
- Performed System testing and Functionality Testing using Point-of-Sale (POS) on highest scale.
- Used QC for requirement and defect tracking.
- Involved in requirement gathering of the Data Warehouse, analyzing business requirements, Data Model Design, Data flow from various Sources to Target.
- Wrote extensive SQL queries to communicate with the Oracle Backend for data accuracy, integrity and security checks.
- Supported Performance tester with the Performance and Load testing using Load Runner.
- Handled exceptional situations in test scripts using Recovery Scenario Manager in Quick Test Pro (QTP).
- Managed and closely participated in the Project Management of Point-of-Sale (POS) Initiatives.
- Developed test scripts in VB script for Data Driven tests. Executed the test scripts and analyzed the results.
- Executed the Performance testing and Throughput/Capacity Testing using Load Runner Controller.
- Executed SQL statements to check if the data integrity has been maintained.
- Performed negative and positive testing using SQL Queries.
- Conducted Data integrity and Data validation tests. Performed Sanity Testing and Smoke Testing.
- Performed Integration testing, System testing and Regression testing.
- Conducted database testing for the application by writing and executing SQL queries
- Participated in the management of testing project with the help of Quick Test Pro (QTP).
Environment: Quick Test Pro, Quality Center, Load Runner, Windows Vista, MS SQL Server.
