Sr Qa Analyst Resume
Columbus, OH
SUMMARY
- Over 7+ years of hands - on experience in Quality Assurance with manual and automation testing with client-server and web based applications.
- Over 4+ years of experience on Selenium WebDriver using Java.
- Developed test cases using Python scripting on Selenium WebDriver.
- Excellent experience in software testing and experienced with all faces of software testing life cycle.
- Troubleshoot and provide failure analysis of issues identifies from the automation suite.
- Familiar with both Linux and Windows Operating System.
- Ability to create clear and concise bug reports with actionable steps to reproduce.
- Ability to organize and captive functional complexity in a comprehensive test plan.
- A strong core-competency of gathering and documenting Business Requirements, leading User Acceptance Testing.
- Good experience in Software Testing includes Effort estimation, Test Planning, Test Design & Execution.
- Conversant in Test data planning, Test Execution and Reporting.
- Well-acquainted with different Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC) and Defect Life Cycle.
- Excellent knowledge in Software Testing Levels, Bug Life Cycle and Testing Types.
- Good knowledge on Mainframe Automation.
- Extensive knowledge on Mainframe tools and technique as well as unit regression testing.
- Working experience with automation tools- QTP, Selenium WebDriver, Selenium Grid, and SOAP UI.
- Hands on experience in Jenkins.
- Experience in working with different Java APIs for developing test scripts for test automation.
- Hands on experience on various Testing Methodologies such as Incremental/ Iterative, Agile Methodologies.
- Good work experience in System Testing, Integration Testing, Ad hoc testing, Compatibility testing and Regression Testing.
- Good Knowledge on Data warehouse software (Red prairie).
- Solid understanding of E2E architecture and different environments like Dev, QA, UAT with source stage and target level.
- Strong experience in testing Backend application servers in SOA.
- Good Knowledge on Database testing using SQL, PL/SQL queries.
- Good Experience in testing of web applications including Database testing.
- Knowledge on Web services testing on SOAP and REST.
- Experience in testing web based applications built on Java, .Net.
- Hands on experience on various framework like Data driven, Keyword driver and Hybrid driven on platforms like Junit and TestNG.
- Experience in working with SVN and GIT control management systems.
- Experience in Bug tracking Tools - TFS, Quality Centre, Jira and Bugzilla.
- Capable of working independently or as part of a team with a good understanding of team dynamics.
- Experience in working in different SDLC such as Waterfall, RUP, and Agile.
- Knowledge in Rally software for Business agility and Portfolio agility.
- Experience in working in Scrum and participate in Sprint meeting.
- Strong interpersonal and excellent communication skills.
TECHNICAL SKILLS
Programming languages: Java, Python, C, SQL, Perl, XML, VB Script, COBOL, HTML
Operating Systems: MS Windows 7 to 10, Linux
Testing tools: HP ALM, QTP, Selenium IDE, Selenium WebDriver, JIRA, Bugzilla, QC, SoapUI, Toad (DB tool), Wireshark, Maven, ANT Build tools
Frameworks: SOAP, RESTful API, Junit, TestNG
Databases: Oracle 9i/10/11g, MySQL, SQL Server 2007/2008/2009/2010/2012
Other Utilities: MS Excel, MS Power point, MS Visio, MS Word, MS Visual Studio.
PROFESSIONAL EXPERIENCE
Confidential, Columbus, OH
Sr QA analyst
Responsibilities:
- Analysing and review business requirement and system requirements.
- Prepared the test plan, test strategy and test case documents with the help of BRD, FRS, HLD, LLD and other supporting documents.
- Maintain the Traceability Matrix between Requirements, Design components, Test cases and defects.
- Actively participated in Sprint meetings for the duration of 4 week sprint cycles.
- Report red flag issues to the management.
- Identifying data required for execution and risk involved.
- Logged defects using HP ALM/Quality Center, linked defects with requirements and generated Defect Reports in QC.
- Responsible for handling critical tickets for HP ALM/QC Issues
- Used Selenium IDE to locate the Objects and used the locator in scripts. Specifying assert and verify commands.
- Executed web based testing using Selenium Grid.
- Designing automation framework and develop test scripts to automate regression testing process in Selenium WebDriver with Java programming language.
- Create automation Test Scripts in Selenium Web Driver and involve in Automation Infrastructure Development.
- Executed automated Selenium Scripts by Java and reproduced failures manually.
- Worked with other members of the QA and Development teams and managed efforts with offshore team in improving the processes, methods, effectiveness and efficiency.
- Wrote Maven build scripts to automate the compilation and execution of TestNG test cases/suites.
- Created Indexes, Aggregate Function, Tables, Views, SQL joins and other SQL code to implement business rules.
- Written SQL Queries to define identify and validate the code written for the data movement into the database tables, fine-tuned the queries for better performance.
- Performed database testing validations on MySQL databases.
- Handle responsibilities of analysing test results and troubleshooting environment issues.
- Responsible for verifying database interaction defects as well as conduct performance and capacity testing.
- Find, report and follow up on defects found using automation using our defect tracking tool
- Executing automation scripts for Sanity testing and sending results to stake holders.
- Conducted continuous integration testing using tool on Jenkins.
- Conducted few automated tests using on iOS applications.
- Involved in preparing the Data-driven frameworks in QTP for system and UAT environments and performed data comparison and functional comparison.
- Validated some of the WSDLs using SOAP UI.
- Retesting the resolved defects/issues after the developers fix the defects.
- Reported bugs and tracked defects using Rational Clear Quest.
- Involved in preparing test data/ Test script for UAT and participated in UAT signoff
- Participated in walkthrough and defect report meetings periodically.
- Documented and reported various bugs during the Testing process.
- Setting up the calls to discuss blockage and find out the path forward
- Updating product catalogue and transaction table on production issues
- Performing defect tracking, analysing defect, performing RCA on production defects
- Validating fixes before deploying on production.
- Updated the status of the testing to the QA manager, and accomplished tasked for the assigned work to the Project Management team regularly.
Environment: Agile, MS Windows XP, Eclipse IDE, Selenium WebDriver, Selenium IDE, Selenium Grid, Maven build scripts, TestNG test framework, Jenkins, HP ALM/ HP Quality Centre, MySQL database, Rational Clear Quest, Bugzilla 4.4.4, SOA, SOAP UI, Appium (Mobile automation testing)
Confidential, Detroit, MI
QA Team Lead
Responsibilities:
- Attended the Requirements reviews, Design reviews, Code reviews to understand the overall process flow and Source to Target mappings.
- Worked in Agile SDLC. (Scrum methodology).
- Actively participated in Sprint meetings for the duration of 2 week sprint cycles.
- Tracked the defects using test cases using Quality Center and generated defect, test case summary reports.
- Worked in Linux operating system environment.
- Involved in extensive Data validation, Data load by writing SQL queries on source, target databases to ensure the right flow of data from the MySQL databases.
- Segregated the test cases for manual tests and evaluated the test cases required for the regression testing.
- Conducted various Automation testing, Integration testing, Validation testing and Regression Testing using Selenium WebDriver.
- Conducted automation testing using Python Scripting.
- Utilize PyUnit, the Python unit test framework, for all Python applications.
- Defined entry / exit criteria and provided continual risk assessments to senior management.
- Involved in ETL process testing using Cognos ETL tool.
- Verified the session logs to identify the errors occurred during the ETL process.
- Performed data validation, constraints check, record counts, and source to target mapping, random sampling and error processing.
- Preventing occurrences of multiple runs for incremental load by flagging processed dates.
- Proactive in detecting the bugs, reporting the bugs by using JIRA, QC.
- Partially worked on Business Intelligent tools Tableau for data validations.
- Integrated process into build system which auto-generates REST API documentation from source code improving API documentation quality and availability while reducing maintenance costs.
- Worked with offshore team, assigned/divided the tasks and managed the day to day activities.
- Prepared Vendor specific documentations to help facilitate the vendor UAT test plan and involved in vendor testing.
- Participated in daily and weekly status meetings with the management team and walkthroughs.
- Performing defect tracking, analyzing defect, performing RCA on production defects
- Validating fixes before deploying on production.
- Updated the status of the testing to the QA manager, and accomplished tasked for the assigned work to the Project Management team regularly.
Environment: Agile SDLC, Linux, Selenium WebDriver (Python Scripting), JIRA, HP Quality Center, REST API testing, ETL (Cognos) tool, BI tool (Tableau 7.0.8)
Confidential, Pataskala, OH
Functional QA Analyst
Responsibilities:
- Understanding the requirements and involved estimations.
- Involved in Reviewing Requirements with Product Management Group or with BA.
- Involved in preparation of test scenarios.
- Preparation of test cases and test data.
- Involved in Test Case Reviews, attended daily calls and Status Calls with Onsite team Test case Execution.
- Used HP ALM planning and security purpose of test cases.
- Re-testing & Regression testing on the entire application to ensure that nothing is affected by after the Defects have been fixed.
- Executed web automation tests browsers on Windows operating systems.
- Involved in preparation of automation scripts using Selenium web driver.
- Executed SQL statements to check if the data integrity has been maintained.
- Retrieving & Verifying the data present in the Oracle database using SQL queries.
- Retrieving data from the databases required for test execution.
- Submitting test summary report.
- Used the JIRA tool for bug tracking.
- Implemented documents using MS office suites.
- Identify, document and track defects and improvements identified during testing.
- Participate in Walkthrough sessions, demos and Sprint retrospective calls with onsite people.
Environment: Waterfall SDLC, Windows XP, Selenium WebDriver, Oracle database, SQL, TOAD tool, JIRA, MS office suites: MS Visio, MS Power Point, MS Excel, MS Word.
Confidential, Boston, MA
QA Tester
Responsibilities:
- Detailed study of Business Requirements, software requirement specification (SRS), Product catalog Document.
- Creation of detailed test cases RVMs (Relationship Validity Matrix) based on the requirements for PCE and BPA.
- Performed few Test Scripts in QTP.
- Uploading and execution of the test cases from Quality Center.
- Executed SQL queries, joins and stored procedures on Oracle 9i.
- Raising defects in Quality Center (QC) and following up for their effective resolution.
- Efficiently SVN (Source Version Control) usage experience on real time projects
- Retrieving required information from using databases required for the test execution using TOAD.
- Creating test plans, developing test scenarios for COBOL, CICS and Batch Programs, and creating QA metrics and reports.
- Responsible for verifying database interaction defects as well as conduct performance and capacity testing.
- Testing with Batch programs are compiled and executed using JCL.
- Responsible for End-to-End Product testing, Defect Tracking, offshore-onsite coordination, managing the client relationship and handling the client queries on the business process flow.
Environment: Waterfall SDLC, Windows XP, RVM, HP Quick Test Professional, HP Quality Center, Oracle 9i, TOAD tool, SVN, COBOL, CICS, JCL
Confidential
QA analyst
Responsibilities:
- Worked in a transitioning to SDLC.
- Involved in Test Strategy Specifications & Traceability Matrix as per functional specifications.
- Written test cases, test plans, test specifications, test data and error documentation.
- Data Driven Testing using parameterization in Quick Test Professional (QTP) to test the application with different sets of data.
- Involved in writing test scripts in VB Scripting.
- Involved in Sanity, System, Functional and Regression testing.
- Preparing the regression scenarios of the previously releases to till date.
- Preparing and maintaining test data sets for testing databases using SQL queries.
- Worked on SQL Server 2008.
- Worked with Tableau in order to present the data according to the requirements.
- Detected the defects through Quality Center.
- Reporting, bug tracking and fixed the bugs through a bug tracking tool JIRA.
- Review of Test log and updating on daily basis.
- Working together with external interfaces and with design and development team.
- Attending daily status call, Release Jeopardy call and client meetings.
- Providing the Test Sign-off for the tested Releases.
- Worked closely with the Business team, Development Team.
- Impact Analysis of CR’s to Release schedule.
- Involved in internal SQA activities.
Environment: Windows XP, HP Quick Test Professional, HP Quality Center, SQL Server 2008, BI tool (Tableau 4.1.9), JIRA
Confidential
QA analyst
Responsibilities:
- Worked closely with the business team and the stakeholders ensuring the requirements.
- Worked on SVN environment.
- Involved in Integration, Regression and OR interlocking testing of various modules. Acted as an individual lead for CRs Testing Lifecycle.
- Effective Defect tracking in QC and Analysis.
- Used JIRA tool for bug tracking.
- Involved in Regression Testing, UI Testing, Functionality Testing, System Testing, Validation Testing and Data flow testing between Application & Database.
- Performed regress manual testing.
Environment: Waterfall SDLC, Windows XP, SVN, HP Quality Centre, JIRA.
