PROFESSIONAL SUMMARY:

• 8+ years of professional experience as a Quality Analyst, proficient in manual testing process with HP Interactive Tools (ALM, Quality Center)
• Experience in UI Testing, Functional Testing, Database Testing, System testing, Integration Testing, Responsive Design testing, Accessibility testing and manual testing of Web and Client/Server based applications
• Strong understanding of the Agile/Scrum and SDLC methodologies
• Experience in all phases of Software Testing Lifecycle with expertise in the Integration and Functional, User Interface, and Regression testing
• Expert in writing complex SQL queries for databases including Oracle and SQL Server
• Strong knowledge and expertise in data analysis and report generation using Excel VBA
• Expertise in using TOAD, PL/SQL Developer and strong knowledge in PL/SQL Packages, Stored Procedures/Functions and triggers
• Strong knowledge of RDBMS concepts, developed SQL queries in Oracle database to conduct DB testing
• Experience in Marketing, Finance, Telecom and Insurance domain
• Proficient in preparing Test Plans, Test Cases, Test Scenarios, Requirement Traceability Matrix and Automation Coding Standards
• Experience in generating automation (QTP) regression test scripts, maintenance and enhancement of those scripts
• Expertise in Unix Shell Scripting and testing in distributed UNIX Environment
• Experience in interacting with business analysts to understand and review business requirements, and product demonstration
• Experience in SOAP UI tool for Web Services for validating request and response XML
• Experience in JAWS and AMP for validating websites to meet ADA standards
• Excellent oral and written communication skills with strong problem - solving skills and a result oriented attitude
• Comprehensive insight of Software testing life cycle, and vital involvement in UAT (User Acceptance Testing) of web based and database applications
• Experience in creating step-by step technical and user manuals with illustrations

TECHNICAL SKILLS:

Requirement Management: ALM, MS-Excel

Project Management: ALM, Microsoft CRM

Database: Oracle PL/SQL, MySQL, MS-Access

Scripting Languages: VBScript, Excel VBA

Defect Management: ALM, JIRA and Bugzilla

Testing Tools: Quick Test Professional, SoapUI, JAWS, AMP

Other: Qlikview, Axiom

PROFESSIONAL EXPERIENCE:

Confidential, NY

Quality Assurance Engineer

Responsibilities:

• Formulated Test plan from Business Requirements and Functional Specifications documents
• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Microsoft CRM
• Developed test scenarios and test scripts based on the requirements and documented them in Excel spreadsheet
• Created the test plans and test cases for the application to be deployed on Web, mobile phones and tablets
• Developed traceability matrix between the requirement document and respective test cases to ensure all requirements were covered
• Responsible for review of test cases, test scenarios and test results
• Used Microsoft CRM to store Requirements, Test Cases, Test results and generating various reports and graphs for further analysis
• Performed different types of tests such as Functional testing, Accessibility testing, Responsive Design testing and E-mail testing
• Executed Test Cases in all Test Environments and documented the test queries and results for future reference
• Performed back-end testing using SQL queries to validate the data in the back-end SQL Server
• Created Excel VBA programs to perform data analysis
• Performed proof reading for emails and promotional offers
• Used JAWS, SSB Bart and Wave tools to validate whether the web pages, web applications, PDF’s, etc. meet the ADA and WCAG standards
• Performed Responsive design testing on real devices like phones, tablets, iPads and virtual devices using cross browser testing tool to ensure optimal functional excellence
• Performed Cross browser testing on different Operating Systems like Windows and Mac and on different browsers like Internet explorer, Firefox, Google Chrome and Safari
• Prepared QA metrics and status reports

Tools: Microsoft CRM, Bugzilla, JAWS, SSB BART, MS Office and JIRA

Confidential Jersey City, NJ

Quality Assurance Engineer

Responsibilities:

• Formulated Test plan from Business Requirements and Functional Specifications documents
• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in ALM 11.5
• Developed test scenarios and test scripts based on the requirements and documented them in Excel spreadsheet
• Developed traceability matrix between the requirement document and respective test cases to ensure all requirements were covered
• Responsible for review of test cases, test scenarios and test results
• Used ALM to store Requirements, Test Cases, Test results, Defects and generating various reports and graphs for further analysis
• Performed different types of tests such as system tests, Integration Tests and Regression Tests
• Executed Test Cases in all Test Environments and documented the test queries and results for future reference
• Analyzed source data for the attributes required for the reports
• Analyzed attributes for 14M report and defects are tracked
• Supporting documents for 14A has been analyzed through the Qlikview reports
• Involved in User Acceptance Testing (UAT) with end-users (RTB)
• Performed back-end testing using SQL queries to validate the data in the back-end SQL Server
• Created complex SQL queries for validating the data mapping and data integrity
• Analyzed stored procedures, functions, triggers and packages in PL/SQL
• Regularly holding sessions with Lines of Business (LOB) to review the test cases and execution of UAT test cases for CCAR
• Performed extensive validation for data attribute values between source and target data warehouses using SQL queries and Joins
• Created Excel VBA programs to perform data analysis
• Validated the execution of works flows from source to staging environment and staging to core (target)
• Worked extensively on validating staging and target tables for data integrity and data validity during the transformation of data into various data marts
• Validated the data between source and target for specific business and data rules using SQL queries, Joins, functions
• Maintained and provided accurate testing status reports during testing phases and maintained documentation of test results

Tools: Qlikview, ALM 11.5, Oracle PL/SQL, Toad, MS Office and Axiom

Confidential, Matawan, NJ

Quality Assurance Engineer

Responsibilities:

• Exclusively worked with subject matter experts/BA which significantly decreased process cycle time
• Formulated Test plan from Business Requirements and Functional Specifications documents
• Analyzed system requirements and functional requirement documents to prepare test cases and test data
• Prepared exit test criteria test cases for sprint completion
• Responsible for review of test cases, test scenarios and test results
• Developed detailed test scripts manually and using automation tool Quick Test Pro
• Incorporated the concept of checkpoints to verify that the expected information is displayed in the application by implementing various checkpoints such as Standard checkpoints, Image Checkpoints, Table Checkpoints, and Text checkpoints using Quick Test Pros
• Generating Automation regression test scripts, maintenance and enhancement of those scripts as per the Business Requirements/application change requests
• Used HP Quality Center to store Requirements, Test Cases, Test results and Defects
• Conducted/Attended Sprint review meetings and worked on backlogs in parallel with tasks for new sprints
• Analyzed production data to prepare test data
• Written complex SQL queries to save and retrieve data from Oracle DB
• Analyzed stored procedures, functions, triggers and packages in PL/SQL
• Performed different types of tests such as Integration Tests, Regression Tests and User Interface Tests
• Executed Test Cases in all Test Environments and documented the test queries and results for future reference
• Handled the application response for positive and negative sets of data with data driven testing using Quick Test Professional
• Executed jobs through scheduling tool APPWORX
• Developed scheduled jobs using Shell scripting to transfer data between the systems
• Worked in Agile environment that brings key performers working together in one location dedicated to one project until its completion

Tools: Quick Test Professional, Quality Center, Oracle PL/SQL, Toad, MS Office, Unix Shell Script, Rally and APPWORX

Confidential, Stamford, CT

Quality Assurance Engineer

Responsibilities:

• Communicated with Business Analyst and Project Manager to gather requirements
• Analyzed and reviewed System Requirements Document to gain overall understanding of the functionality of the application
• Developed the Test Plan and Test Strategy for the implementation of the project
• Wrote functional test cases for manual testing
• Responsible for review of test cases, test scenarios and test results
• Created and executed Manual and Automated test scripts using established requirements
• Created tests, test objects, check points, actions (reusable) in QTP
• Generating Automation regression test scripts, maintenance and enhancement of those scripts as per the Business Requirements/application change requests
• Performed Smoke Testing for the application, using QTP
• Performed Positive and Negative testing by inputting valid and invalid data
• Written advanced SQL queries to extract and manipulate the data in database
• Customized QTP Scripts with Parameterization, Check Points, Library Files, Regular expression etc
• Performed API/Web Services testing using test harnesses and SOAP UI tool
• Tested SOAP based web service which is used to transfer data between the systems using SOAP UI tool
• Performed Regression testing to ensure that changes made to software did not introduce any new bugs
• Logged defects in QC and assigned to respective developing team to work on and hence followed QC workflow for further communication
• Participated in Knowledge Transfer, Group Discussion, Training Session and Brainstorming
• Prepared the Test Report document which summarizes testing activities and results
• Reported and suggested new improvements for the testing efforts at the end of each sprint
• Participated in daily Scrum meetings to discuss the status of work done

Tools: .NET, Quality Center, QTP, SOAP UI, MS Office, SOA, XML, TOAD, PL/SQL, Shell Script and UNIX

Confidential

Quality Analyst/ Tester

Responsibilities:

• Design the Test Scenarios and Test cases for the application by exploring the existing Internet explorer version
• Documented the screen shots of the look and feel of the application
• Interacting with senior peers or subject matter experts to learn more about the data
• Used HP Quality Center to store Requirements, Test Cases, Test results and Defects
• Participated in KT meetings to have better understanding on what is business expectation
• Documented and reported various bugs during Manual Testing
• Participated in preparing Test Summary Document and provided QA sign off
• Organized the defect meetings with respective application teams during the testing
• Developed Reports and Graphs to present the results to the management
• Effectively communicate testing activities and findings in oral and written formats
• Handling and tracking all the issues and defects raised during UAT; ensuring their resolution and then provide the Sign off
• Daily monitoring and control of the project by close reviews

Tools: Java, Quality Center, UNIX, Shell Script, and MS Office

Confidential

QA Tester

Responsibilities:

• Interacted with business users to analyze the requirements
• Designed & Created Test Cases based on the Business requirements
• Created Requirement Traceability Matrix for various releases
• Exporting test cases to Test Director
• Developed and Performed execution of Test cases manually to verify the expected results
• Used Test director to state business requirements, test cases, test runs for every iterations and defects
• Analyzed production data to prepare test data
• Participated in KT meetings
• Frequently used Version Manager tool (VSS) to store test cases & test documents and updating them with the latest versions and additions
• Execute SQL Queries in TOAD to validate back end information
• Retesting the resolved defects/issues after the developers fix the defect
• Conducted Ad hoc testing for Priority tickets (Production Issues)
• Reported the bugs through email notifications to developers using Test Director

Tools: PeopleSoft, ERP, Test Director, MS Office, XML, TOAD, SOAP UI, PL/SQL, Shell Script and UNIX

Confidential

QA Tester

Responsibilities:

• Interacting with senior peers or subject matter experts to learn more about the data
• Design and execute the test cases on the application as per company standards
• Defects identified in testing environment were communicated to the developers using defect tracking tool Mercury Quality Center
• Written complex SQL (DDL, DML and DCL) queries, PL/SQL to perform back-end testing on database
• Extensively worked with Soap UI tool for Web Services testing
• Effectively communicate testing activities and findings in oral and written formats
• Conducted Black Box testing - Functional, Interface and Regression testing
• Defects tracking, review, analyze and compare results using Quality Center
• Identify, assess and intimate potential risks associated to testing scope, quality of the product and schedule
• Reported the bugs through email notifications to developers using Quality Center
• Retesting the resolved defects/issues after the developers fix the defect

Tools: Java, Quality Center, SOAP UI, MS Office, XML, PL/SQL, Unix, Shell Script, TOAD and Device Anywhere

Confidential

QA Tester

Responsibilities:

• Analyzed system requirements and functional requirement documents to prepare test cases and test data
• Designed & Created Test Cases based on the Business requirements
• Used HP Quality Center to state business requirements, test cases, test runs for every iterations and defects
• Developed Traceability Matrix of Business Requirements mapped to Test cases to ensure any Change Control in requirements leads to test case update
• Developed Reports and Graphs to present the results to the management
• Provide defect reporting by creating/customizing defect metrics and dashboard
• Participated in Status meetings with QA manager to update QA status
• Follow up with the technical team and resolve the technical issues in minimal turnaround time
• Tracking the new requirements and change of requirements

Tools: VB, Quality Center and MS Office