SUMMARY

• Over 8 years of work experience as Quality Analyst with expertise in understanding and gathering business requirements and translating those requirements to system requirement specifications
• Experience in Manual and Automated testing, involved in System testing, Functional testing, Regression testing and Database testing
• Extensive working experience in Healthcare and Insurance Domains
• Hands on experience of industry standard methodologies of SDLC (waterfall, Agile and Iterative)
• Comprehensive experience in Gap Analysis, Cost/Benefit Analysis, Testing, and Project Planning/Scheduling
• Experience in writing queries/scripts for data analysis and QA report testing/client acceptance testing
• Hands on experience in developing fully professional Project Plan, Test, Risk Mitigation Plans, Requirement Traceability Matrix, and Business Requirement documents
• Experience in conducting walkthroughs for requirements gathering, analysis, test plan.
• Designed and Developed Automation test scripts in Java implementing test in selenium Web - Driver
• Implemented data driven testing and Keyword driven testing using Selenium
• Performed the software testing including User Acceptance, Sanity, Regression, and Integration testing
• Experience in testing database applications of RDBMS in Oracle, My-SQL and SQL Server by executing SQL Queries
• Experience in writing and executing SQL queries to perform Data Validation and Back-end testing of databases to check the integrity of data
• Good Knowledge in API testing (Rest API).
• Excellent project management and time management skills and strong work ethics and ability to learn new concepts
• Excellent communication, presentation, and interpersonal skills with demonstrated experience in efficient interaction with customers and senior management
• Excellent oral and written communication skills with a demonstrated capability for dealing with all levels of client management personnel and staff
• Comprehensive knowledge of Test plans, Test cases and test scripts from the Requirements Document

TECHNICAL SKILLS

Defect Management Tool: JIRA

Programming Languages: SQL, PL/SQL, Java, Python, HTML

Project Management: Microsoft Project, Microsoft Word

Automation tools: Selenium WebDriver and TESTNG

Databases: MYSQL and SQL Server

Web Technology: Microsoft FrontPage, HTML, CSS, XML, Salesforce

Build Tools: Ant, Maven

PROFESSIONAL EXPERIENCE

Confidential, CA

Automation QA

Responsibilities:

• Participated in requirement gathering from end Users, Responsible for writing functional Specifications and design documents.
• Defects were Tracked, Reviewed and Analyzed
• Worked closely with development and project management teams for effective defect management and verify resolved bugs and track enhancements made to product
• Involved in execution of Test Plans, Test Cases & Test Scripts by reviewing the business requirements
• Developed Test cases manually and generated automation scripts using open-source tools like Selenium Web Driver (Java), TestNG
• Performed Functional testing, System testing, data validation testing, end-to-end testing of the web portal application
• Written automation scripts for Regression test cases and executed using TestNG and Selenium (Java). Maintained detailed test logs and report test results
• Analyzed Defect Reports and worked closely with Application Developers for resolving the bugs
• Participated in daily Scrum planning meetings with project stakeholders to discuss current project cycle, review and prioritize new defects, enhancements and features, and review deadlines
• Created Automation test scripts using Selenium for the Client and Internal Project. (Page Object Model Framework(Java) using TestNG for the Salesforce Application)
• Manually tested the functionality of an internal application, raising defects and retesting.
• Facilitated our team to create an automation testing framework for the regression suite.
• Involved in all the processes of SDLC from analyzing the requirements to deployment.
• Created and maintained all test plans and requirement traceability matrix.

Environment: SOSQL, Selenium Web Driver, TestNG, Maven, Salesforce.

Confidential

Quality Analyst

Responsibilities:

• Actively Participated in requirement gathering from end Users, Responsible for writing functional Specifications and design documents
• Analyzed business requirements, system requirements, and data mapping requirement specifications interacting with client, developers, and QA team
• Developed Selenium tests using TestNG framework
• Developed Automation scripts for new enhancements using Selenium WebDriver
• Implemented Data-Driven test to verify the same functionality with multiple sets of data
• Defect testing and exploratory testing/Ad-hoc testing was performed after each build
• Performed UI testing, Database testing after reviewing the story cards and database diagram
• Defects were Tracked, Reviewed and Analyzed using JIRA
• Worked closely with development and project management teams for effective defect management and verify resolved bugs and track enhancements made to product
• Reported the bugs, Email notifications to the developers using JIRA
• Provided back-end testing for data validation using SQL on Oracle
• Executed SQL Queries on database tables to verify the database
• Worked with developer to reproduce the bugs and to resolve usability issues during UAT
• Created Regression Document to track and report testing activities during each phase of testing, including testing results, test case coverage, required resources, logged defects and their status, performance baselines
• Created automated regression test using Selenium WebDriver
• Participated in Stand-up meeting, walkthrough meeting, weekly automation meeting with all other QA, weekly assessment meetings with business analysts and developers
• Prepared documentations on Components involved in the project and Best Practices
• Been responsible for maintaining the regression suite and execution of regression suite for every iteration
• Involved in DB testing, Batch testing and Frontend testing
• Involved in Functional, Regression, System testing and User Acceptance Testing
• Taken Domain training for the new hires
• Worked as offshore team lead to coordinate the project deliverables
• Reduced production defect backlogs to maintain metrics
• Preparing reports and test results after each iteration cycle for management and further test planning
• Identified the queries which were taking too long and optimized those queries to improve performance
• Involved in project acceptance testing and production release procedures throughout SDLC
• Have a complete working knowledge and have been involved in all project phases from requirement gathering through deployment. (Requirement gathering, design, build, test, deploy)
• Responsible for entering bugs into bug management system and performing Re-tests after the bugs were fixed
• Created Traceability matrix to keep track of changes in requirement to that of the testing efforts
• Running various queries against databases to verify the population for the Actuarial Valuation
• Attending kick-off meetings; conducting windows & web application testing to execute test case in the system
• Validating the integration test cases in Live Production Environment, testing the batch jobs against DB2 Database
• Closely worked with operation team to update the SOP and supporting them to close the workflow on time
• Well versed with all SDLC process
• Experience in conducting User Acceptance Testing (UAT)

Environment: CICS, Batch JCL, DB2 Mainframe, SQL, Lotus Database, Selenium Web Driver, TestNG, Maven