Senior Quality Analyst Resume
NJ
SUMMARY
- Software QA tester with full system development lifecycle experience (SDLC), including designing, developing and implementing test plans, test cases and test processes (STLC).
- Proven experience through testing software for heavy amounts of data in different departments of business such as Health Care, Banking domains as well as Retail applications.
- Proven experience in System Testing, Integration Testing, UAT Testing, Positive and negative, Functional Testing and Regression Testing, as well as black Box, white Box and Gray Box testing.
- Scripted SQL Queries deeply, queried database using Queries and Stored Procedures for concise Back - End Testing
- Thorough knowledge of Agile Scrum Methodology and Waterfall Methodology with good relations to product owners and stakeholders.
- Extreme exposure to Sprint Grooming and Sprint Planning meetings to create the Sprint Back log that had user’s stories, and gave clear completion estimates.
- Proven extensive knowledge of Verification and Validation through the testing phase of SDLC Life Cycle and STLC which works hand in hand with Bug Life Cycle.
- Hands on experience with Defect Tracking as well as test management using market popular tools HP ALM and JIRA.
- Thorough experience in Peer Reviews of Test cases, Bugs Reports and maintained clean Requirement Review checklist.
- Created particular Test Plans, Test Cases and Test Data and executed and organized User Acceptance Testing (UAT).
- Real hands on experience in using SOAP UI for testing web services developed using SOAPUI using the Groovy language.
- Regular results proven using REST for API testing and verification as well as validation purposes.
- Thorough hands-on experience in performing manual, automated test execution and analyzing the execution report through Jenkins Continuous Integration and Continuous Deployment.
- Experience in using SQL Queries to make sure that data was entered properly in the right tables when the data was entered from front end screen.
- Experience in Back-End Testing with SQL Queries in MySQL, SQL Server and Oracle Database and cross-referencing the GUI.
- Involved in Performance tuning of the databases
- Extensive work in ETL testing using SQL, UNIX, PL/SQL.
- Strong SQL query skills using an enterprise wide RDBMS (Oracle, MS SQL Server & MS Access) and familiar with concepts of SQL queries ranging from DML, DDL and TCL
- Extensively tested data validation, load processes (ETL) using Toad and SQL Developer.
- Meets deadlines and supplements timeliness with clean and effort reducing automation code.
- Proven leadership qualities with emphasis on individual and team effort backed with excellent written and oral communication skills.
- Always had the team player personality and self-discipline in working in group environment, able to adapt working independently and driving a team of professionals as well.
TECHNICAL SKILLS
Platforms: Windows, Mac OS, iOS, Android
Testing Tools: Maven, Cucumber, Junit, Soap UI, Selenium WebDriver, Postman
Languages: JAVA, SQL, XML, HTML, CSS, XPath, Groovy, Gherkin
Databases: Oracle, SQL Server, MySQL
Test Management: QC, ALM, JIRA, Bugzilla, Team Foundation ServerContinuous IntegrationJenkins
Other: GIT, Firebug, Firepath
PROFESSIONAL EXPERIENCE:
Confidential, NJ
Senior Quality Analyst
Responsibilities:
- Analyzed the system requirements and developed detailed test plans and test cases and provided the documentation. Collaborated with product management teams in an agile environment to develop a comprehensive set of tests for web-based applications.
- Writing the test cases and test Scenarios based on the acceptance criteria mentioned in the user stories.
- Good Experience in Agile methodology with SCRUM Process for the product development.
- Prepared the functional test cases using test design techniques data validation concepts Equivalence partitioning, boundary value analysis.
- Created and maintained Test Matrix and Requirement Traceability Matrix and performed gap Analysis.
- Heavy influence in the Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC) using agile methodologies and waterfall methodologies.
- Hands on experience with Functional testing, Integration testing, Regression testing, and Security testing.
- Planned, created and implemented test cases for highly complex API Web Services.
- Implemented SOAP UI tool to test SOAP based architecture application to test SOAP services and RESTAPI.
- Involved in testing of services using SOAP/REST services using SOAP UI, Groovy Script.
- Performed data driven testing by using JDBC and Groovy script as a data source in SOAP UI and configured SQL queries to fetch data from the Oracle database.
- Deep knowledge and hands on experience with back-end database testing using SQL queries to validate complex content-including Inner Joins, Outer Joins, unions etc.
- Wrote SQL, PL/SQL, stored procedures & triggers, cursors for testing business rules and transformations.
- Thorough experience in Defect Life Cycle by Defect Reporting and Defect tracking process using JIRA.
- Used SQL queries to retrieve data from tables and to perform back end testing thru TOAD.
- Wrote SQL, PL/SQL, stored procedures & triggers, cursors for testing business rules and transformations.
- Coordinated with various team for handling defects calls and resolving the testing and bug issues.
- Functional experience using Postman to manually run API Tests and also verify WebServices.
- Good analytical and communication skills and proven ability to work solely independently with little to none supervision and perform as proven player of a team.
- Speaks clear and concise English and able to work fluidly in a problem-solving environment.
Environment: AGILE, Java, Eclipse, Jenkins, SQL, Oracle, SoapUI, Git, HP ALM.
Confidential, MA
Sr. Quality Analyst
Responsibilities:
- Analyzed Business Requirements and Functional Specifications and developed Test Plan, detailed Test Scenarios, Test Strategies and Test cases.
- Involved in creating Test Plan and Test Cases according to the Business Requirements.
- Created, prepared and conducted quality assurance review meetings, developed checks list and other QA documentation like test strategy Document and Defect Reports.
- Planned and coordinated testing efforts for defining the Scope of Regression.
- Performed Debugging and Maintenance of the scripts as and when required.
- Interacted with developers to discuss exiting software defects and re-tested the fixed issues.
- Used SQL Queries to validate the data on daily basis
- Queried Teradata Database and validated the data using Sql Assistant
- Running SQL Query's in TOAD for counting the no of rows from the tables
- Writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle.
- Used XML files in Sending/receiving XML requests using SOAP UI.
- Conducted test on Web services transactions like automatic bill payment, batch payments sent over HTTP or HTTPS by inspecting every XML request and response using SOAP UI.
- Performed data driven testing by using JDBC as a data source in SOAP UI and configured SQL queries to fetch data from the Oracle database.
- Actively attend meetings with fellow testers and other groups to evaluate the progress of the application.
- Followed Agile methodology, participated in daily SCRUM meetings and testing each SPRINT deliverables.
- Involved Preparation of Traceability Matrix and mapping the Test Cases with the requirements and Test Metrics in Quality Center.
- Used Jira for User Story management, planning, scheduling, running tests, defect tracking and managing the defects and executing the test cases
- Performed Back-End Testing by developing complex SQL Queries.
- Executed manual and automated test cases and logged defect in ALM and Jira.
- Prepared test cases by understanding the business requirements, Data Mapping documents and technical specifications.
Environment: Java, Jira, XPath, CSS, Oracle, SQL and SOAP UI
Confidential, Winston-Salem,NC
Quality Analyst
Responsibilities:
- Evaluated Business Requirement Document (BRD), Software Requirement Specification (SRS).
- Developed transparent Test plan and verified test strategy with the team members.
- Designed and created Test Scenarios, Test Cases, and Test steps for different client needs covering both Positive and Negative testing requirements.
- Performed regular Smoke, Black Box, Functional, Integrations and alpha-UAT Test.
- Involved and assisted in the project from the Requirement gathering phase till the completion of alpha-UAT.
- Analyzed user stories then developed the Test Cases according to requirements, reported bugs through HP ALM Test management tool.
- Deep and strong understanding Oracle database and cross-verified the reports using SQL queries.
- Implemented Database Checkpoints for Back-end Testing
- Used SQL for Querying the SQL 2008 database for data validation and data conditioning
- Produced variance reports, Excel graphs, charts, presentations in PowerPoint
- Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
- Designed, implemented and maintained code needed for data extraction, transformation and loading.
- Prepared test cases by understanding the business requirements, Data Mapping documents and technical specifications.
- Distinctively wrote SQL queries and performed Back-End Testing for data validation to check the data integrity during migration from back-end to front end.
- Performed testing on Web Services using WSDL and SOAPUI to check the communication between different services.
- Performed Database testing to check the contents, number of rows and columns of the result set that was based on a SQL query created on the database.
- Involved in testing the application utilizing the Scrum (Agile) methodology.
- Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
- Responsible for different Data mapping activities from Source systems to SQL.
- Involved in testing data transmission between SQL and Oracle database as part of General Ledger update module.
- Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.
- Utilized JIRA Test Management Tool as a request tracking system for tracking the Defects and generating reports.
- Analyzed the application functionality to determined test cases for test automation development.
- Analyzed the automated - manual test case execution and provided high level report to the Lead.
Environment: Agile, Selenium IDE, JIRA, Microsoft Office Excel, Eclipse, Manual Testing.
Confidential
Quality Analyst
Responsibilities:
- Played the role of QA Analyst to analyze business requirements, understanding design specifications to understand application functionality.
- Prepare detailed test cases, test scenarios, and schedules based on Requirements and Design documents and executed according to the test plan.
- Executed and maintained manual test cases. Performed Functional, System, and Regression Testing.
- Automated using Selenium IDE.
- Prepared detailed status reports and update the status to the business and technical teams during weekly review meetings.
- Involved in manually testing of various modules of the application to ensure application stability and functionality.
- Conversant with analyzing requirements and defining high level and low level test requirements and detail test cases.
- Performed System, Regression, Functional and User Acceptance testing.
- Conducted functionality, interface and integration testing during the various phases of the project.
- Involved in the project Kickoff meetings, Verification and Walk through meetings with team.
- Performed Defect tracking in Rally. Designed scripts in Test Plan, and performed execution of those test scripts. Generated daily execution reports.
- Assisted developers with reproducing defects and providing additional information as needed.
Environment: Selenium IDE, HTML, Java Script, Eclipse, Oracle, Windows, MS Word