Quality Assurance Analyst

Skills

Employment History:

Confidential

QA Analyst

Responsibilities:

• Perform Back-end testing using SQL queries to Conversion/validate the data in the back-end Oracle Database using SQL Developer tool.
• Reviewed requirements, use cases and technical specifications for ECFMG/EFDO System, suggested required changes to the requirements during Scrum meetings as needed
• Worked on iterative and incremental process development sprints which lasts for two weeks
• Participated in Agile Scrum meeting for iterative and incremental work known as Sprints
• Performed iterative testing with frequently changing requirements and features set in the Agile development environment
• Project strictly followed the SDLC and STLC lifecycle model closely in order to prevent any possibility of failures to the project.
• Actively participated in scrum meetings, reviews and developed test scenarios
• Tested web applications in Waterfall and Agile development processes
• Developed Test Plans, Test Scenarios and Detailed Test Cases based on the Use Case Documents, Business Requirements and Functions Specifications
• Created Test Cases for all the releases including Applicant Manager, Messaging, Setup and Reports in JIRA and test data to test application critical release requirements, enhancements and defects
• Tested Applicant Manager module that displays applicant's application information where applicants can be searched on by 30 different criteria including First Name, Last Name, AAMC ID, Email address
• Tested the Messaging module where applicants can be communicated using the bulk e-mail feature, this feature is very useful when combined with the filter/sort feature to send E-Mail to selected groups of applicants based on common criteria
• Tested the Setup module that is used to set up user profile including access permissions, workgroups and status of the application
• Developed and documented analyses of business needs and review and comment on testability of the standards set forth by the business team
• SQL query knowledge by using MS SQL Server to create and run queries in order to conduct data validation testing.
• Experience in test automation of web applications, including ability to code in java
• Extensively used automated test tools like QTP for Functional and Regression Testing
• Worked on Integration testing Track-E project which is a end to end testing using of all the application like PDWS Legacy, PDWS Re-engineering, Web Tools PO , MyERAS and ECFMG.
• Worked on VB Script and Automation Infrastructure Development using Descriptive Programming
• Worked on QTP integrated environment with the use of Step Generator, Synchronization, Actions and Recovery Scenarios
• Used Check Points, Output Values, Regular Expressions, Object Repository Administration extensively in QTP
• Used Parameterization in QTP extensively to perform Data-Driven testing
• Used VBScript heavily for writing the automation test scripts
• Created and executed data driven test scripts in QTP
• Created User Defined Functions and Procedures in QTP using VBScript
• Tested Reports module where reports can be generated according to the selected criteria
• Conducted brainstorming session to understand production critical defects, perform root cause analysis, identify test data and plan regression-testing activity
• Communicated through business logic to recommend fixes for the database performance and tuning optimizations to programmers.
• Updated the Test Cases in JIRA and logged the defects in Version One
• Validated Web services using XML request and response data communicating on SoapUI, WSDL and captured message services across Servers
• Created web parts, document libraries, lists, manage metadata, set up alerts, and form work flows using Microsoft SharePoint
• Created XML Manifest to Auto Upload the documents for an applicant with the use of MFT server
• Tested applications against Accessibility testing with the use of SortSite
• Executed Smoke and Regression testing test scripts for all releases
• Assigned proper Severity and Priority levels to defects identified during all phases of the testing.
• Created ECFMG/EFDO Expected results by querying production database, and executed the same SQL queries on the test databases to compare the actual against expected during the system testing and user acceptance testing
• Performed End-to-end and UAT testing of the applications partnered with Users, Dev and BA teams
• Maintained and utilized all scripting procedures, languages to automate and expedite project tasks.
• Helping and consulting with other team members in resolving unusual and complicated problems related to new development, production support and testing
• Conducted internal and external reviews as well as formal walkthroughs, and participated in status meetings

Environment: Visual Basic, Version One, QTP 11, SQL Server 2008, JIRA, .Net, VB, VBScript, SharePoint, SVN, Java, SortSite, QTP, Windows 2000, Oracle 11g, UNIX, XML,MS Project, Visio, Windows.

Confidential

QA Analyst

Responsibilities:

• Involved in analyzing and understanding the Business Requirements and Master Test plan
• Developed Use Case diagrams, business flow diagrams, Activity/State diagrams and Sequence diagrams so that developers and other stake holders can understand the business process
• Created test artifacts based on SDLC formats and strictly followed STLC processes and procedures including Agile
• Involved in creating, executing and updating Test Cases as per application monthly requirements and enhancements for Smoke, Regression, System and User Acceptance Testing
• Created test cases in the Quality center, and tracked the progress of testing by generating the reports
• Participated in Agile Scrum meetings and released biweekly sprints for MI state projects
• Identified the bugs/defects and communicated them to the developers using the JIRA
• Performed Functional, Regression, Smoke and Integration Testing Manually and also automation using QTP scripts
• Created extensively reusable test cases, design steps for quarterly releases regression testing. As part of the regression testing, executed the entire Campgrounds Reservation process including Call Center, Web and Field applications
• Created Data for all kinds of campgrounds including Retail, Rental items in the BackOffice
• Strong Hands-on Experience in Penetration Testing, Vulnerability Testing and Security Testing for Security Analysis
• Developed and documented analyses of business needs and review and comment on testability of the standards set forth by the business team
• Checked the Web Applications vulnerability to SQL injections, XSS Cross Site Scripting and CSRF Cross Site Request Forgery with the use of HP Web Inspect
• Tested Web Services applications vulnerability with the use of Accunetix tool
• Expertise in 508 Compliance testing. Tested applications with the use of Total Validator Tool
• Involved in writing automation scripts for .Net, PowerBuilder and Flex applications using QTP
• Used object spy to find the properties of the object, which helped in writing QTP scripts for Java based applications
• Communicated through business logic to recommend fixes for the database performance and tuning optimizations to programmers.
• Used the Smart Identification in QTP to identify the dynamic objects
• Enhanced Scripts by Putting Check Points like standard checkpoints, Text Checkpoint, output values by putting Text Area output value Check point, passing values between actions when needed
• Maintained and utilized all scripting procedures, languages to automate and expedite project tasks.
• Expertise in Check Out and Commit of the Applications to the SVN
• Tested the applications performance with the use of OpenLoad
• Performed Backend and Database validations using complex SQL queries including JOINs and UNIONs
• Experience in defect management Tracking, Establishing test standards, Guide line procedures, Test Execution, Documenting and analyzing test results
• Participated actively in weekly status meeting and communicated effectively QA status to project management team

Environment: Quality Center, QTP, JIRA, Power Builder, Flex, .Net, VBScript, ColdFusion, SVN, OpenLoad, Java, Total Validator, SharePoint Windows 2000, Oracle 11g, SQL Server 2008, TOAD, UNIX, XML, Visio, Windows and Web Methods.

Confidential

Sr. QA Analyst

Responsibilities:

• Perform Back-end testing using SQL queries to Conversion/validate the data in the back-end Oracle Database using SQL Developer tool.
• Reviewed requirements, use cases and technical specifications for ECRM/COPS Eclipse Customer Relationship Management/Centralized Offer Palette suggested required changes to the requirements.
• Created Test Plan, Test Scenarios, and Test Cases for all the quarterly releases.
• Created test data to test application critical release requirements, enhancements and defects.
• Conducted brainstorming session to understand production critical defects, perform root cause analysis, identify test data and test plan for regression-testing activity for ECRM/COP integrated with IVR system.
• Created test cases for System testing and User Acceptance Testing UAT covering the business process flow
• Prepared RTM requirement traceability matrix and maintained the repository for all modifications and updated appropriate test cases throughout the software testing life cycle
• Worked with Database administrators to mock the production data for Regression and UAT for ECRM/COP integration with IVR system
• Project strictly followed the SDLC and STLC lifecycle model closely in order to prevent any possibility of failures to the project.
• Stored all the test cases and other testing related documents in Quality Center
• Maintained Selenium Regression Automation Test Scripts in the Quality Center for ECRM/COP integration with IVR system.
• Tested the application against Security Vulnerabilities.
• SQL query knowledge by using MS SQL Server to create and run queries in order to conduct data validation testing.
• Executed Smoke testing and Regression testing using Selenium, Automation test scripts for all releases. Performed the Backend testing using SQL queries and performed the data verification
• Analyzed the performance of the application using LoadRunner with different virtual user loads with the help of various graphs
• Maintained and utilized all scripting procedures, languages to automate and expedite project tasks.
• Developed and documented analyses of business needs and review and comment on testability of the standards set forth by the business team
• Created Expected results by querying production database, and executed the same SQL queries on the test databases to compare the actual verses expected during the system testing and user acceptance testing
• Communicated through business logic to recommend fixes for the database performance and tuning optimizations to programmers.
• Tested the application for 508 compliance using JAWS tool
• Maintained the release notes and the versions in Microsoft SharePoint
• Created and shared the documents, sent links in the email, Created alerts, created URLS for the documents using Microsoft SharePoint
• Created test cases in the Quality center, and tracked the progress of testing by generating the reports
• Interacted with developers and business analysts to resolve discrepancies between system specifications and user requirements - involved in the complete testing life cycle
• Logged, Tracked and Closed Defects using Quality Center
• Verified Autosys UNIX jobs functionality as a part of release requirements and regression.
• Participated actively in weekly status meeting and communicated status to project management team and stakeholders
• Automated GUI and backend tests using Selenium JAVA
• Tested web applications and open-source web technologies developed in Java

Environment: Quality Center, Selenium , Java, Fiddler, Acunetix, Rational Clear Quest, Rational Requisite Pro, DOORS, SharePoint, Windows 2000, Oracle 11g, SQL Server 2008, TOAD, UNIX, XML, Visio, JAWS, LoadRunner , Windows and Web Methods.