SUMMARY

• Over 5 years of experience in IT industry with an emphasis on Software Quality Assurance, GUI, System and Integration Testing, Functional/Regression Testing, Data Migration, Interface, Data Upload, Data Integrity/End to End testing of Web and Client/Server based applications
• Extensive experience working in various domains like Wealth management and Retail banking
• Experienced in the creation of use cases and the development and maintenance of test specifications, test cases, test scripts and test data
• Proficient in both Manual and Automated Testing Tools such as QTP, Win Runner.
• Extensive knowledge of SDLC (Software Development Life Cycle) methodologies.
• Experience in working with agile methodologies and active participant of SCRUM meetings.
• Experienced in various types of testing including Sanity Testing, Smoke Testing, Functionality Testing, Performance Testing, Volume Testing, Unit Testing, Integrated Testing, System Testing, Ad Hoc Testing, Positive and Negative Testing, Security Testing, Stress Testing, Load Testing and Regression Testing of Standalone, Web Based and Client - Server applications
• Involved in maintaining Test Matrix and Traceability Matrix and performed Gap Analysis
• Performed User Acceptance Testing (UAT) Manually.
• Expertise in automating functional test cases, test data in XML standards and writing Test scripts using Automation tools
• Have good exposure to modern Agile methodologies such as SCRUM, TDD (Test Driven Development)
• Participated in design review meetings with production team of Business Analysts, SMEs, PMs and developers in order to understand the critical business functions of the project applications
• Attended requirements and design meetings, review and analysis of requirements and design documentation.
• Working knowledge of creating different types of test reports through Quality Center such as Test Execution Status/Summary, Defect Status/Summary, Defect Injection rate etc..
• Participated in design walkthroughs and verified Quality Center Test Scripts and results.
• Effective Time Management Skills and consistent ability to meet client deadline.
• Excellent analytical, problem solving, presentation, and interpersonal skills with ability to grasp things quickly.
• Good team player with excellent communication skills, vendor experience and ability to lead, manage, coordinate and work independently in a time sensitive environment.

TECHNICAL SKILLS

Project Methodologies: RUP, Waterfall, Agile, SCRUM, V

Languages: C#, C, C++, VBasic, SQL, ASP.Net, Java, PL/SQL

Web Technologies: HTML, XML, JavaScript, VBScript

Defect Tracking Tools: Test Director, Quality Center, Serena Team Track, Clear Quest, Bugzilla, TFS

Operating Systems: UNIX, Windows, Mainframe

RDBMS: MS SQL Server, Oracle, DB2

Query Tools: TOAD, MS SQL Server Mgmt Studio, My SQL

Business Applications: Microsoft Office Suite - MS Word, Excel, PowerPoint, Outlook, MS VisioTesting Tools: Quick Test Professional (QTP), Win Runner

WORK EXPERIENCE

Confidential, Chicago IL

Sr. SQA Analyst

Responsibilities:

• Formulated detailed Test Plan, Test Cases and Testing Procedures, which included Test Cases/Scripts, capturing Test Results and capturing and resolving Test Anomalies.
• Performed configuration/ compatibility and user interface testing.
• Use agile systems and strategies to provide quick and feasible solutions, based on agile system, to the organization
• Conducted file format testing with new and existing customers. Research request received from commercial customer service for ACH related issue.
• Verified and reviewed outgoing ACH/ EFT transmissions for completeness and accuracy.
• Performed test case assignments in Test Lab modules of QUALITY CENTER.
• Conducted GUI/Usability Testing and Black Box Testing according to specifications.
• Managing the Change Requests and verifying in the QUALITY CENTER and assigning them to respective Dev team members
• Automate existing functional regression/smoke test cases using QTP
• Lead Defect triage meetings and coordinated defects to the developers and the business.
• Involved in writing complex SQL queries to check the data integrity
• Created test cases to perform different types of testing such as positive/negative, functional/regression, interface, black box, screen navigational testing, smoke/sanity testing, exploratory testing or Backend testing
• Wrote complex SQL queries for database validation
• Performed negative and positive testing.
• Wrote complex SQL scripts for Backend testing and Frontend Data validations
• Used various aggregate functions through SQL queries in order to validate the data load in order to perform Backend Testing.
• Used various SQL features such as Group By, Joins to retrieve the expected results from different tables and compare the same against front end results.
• Used XML (API) for transferring the data from the client to the server
• Performed Usability and Integration testing.
• Automated the Back-End testing for reusability by writing Unix Shell Scripts.
• Created and maintained SQL Scripts and Unix Shell scripts to perform back-end testing on the oracle database.
• Investigated software bugs and interacted with Dev team to resolve bug issues using QUALITY CENTER
• Effectively involve in logging bugs, reviewing solved bugs and analyzing test result using QUALITY CENTER
• Documented bugs found out during the process of testing.
• Created and maintained SQL Scripts and Unix Shell scripts to perform back-end testing on the oracle database
• Developed test scripts for the test cases in QTP for functional and regression testing.
• Worked with business users, business analysts and SMEs to understand different critical business processes.
• Identified, analyzed, and documented defects, errors, and inconsistencies in the application using QUALITY CENTER.
• Created and Maintained Test Matrix and Requirement Traceability Matrix.

Environment: QUALITY CENTER, Manual Testing, QTP, Oracle, Toad, API, C#, XML, .Net, etc.

Confidential, Boston, MA

QA Analyst

Responsibilities:

• Analyzed Business Requirement Document and Technical Specifications Document to identify
• Performed manual and functional testing on various parts of the application and used Quality Center for offshore defect tracking and QC for onsite defect tracking
• Responsible for Manual Testing and Automation Testing.
• Analyzed existing trade lifecycle from client initiation to post-trade compliance including coordination with broker-dealers and DTCC
• Performed manual testing to conduct backend testing using UNIX shell scripts and SQL Queries
• Worked with different modules of Quality Center such as Requirements, Test Plan, Test Lab, Defects and Dashboard module.
• Prepared various test reports from Quality Center such as Test Execution Status, Test Execution Summary, Defect Summary/Details report.
• Used SQL queries to validate the data between the backend and the front end
• Created test cases for various modules in MS Excel and exported them to Quality Center for Test Case Management.
• Reviewed extensive SQL Queries with complex multi-table joins and nested queries.
• Involved in reviewing complex SQL queries, views, functions and stored procedures and spotting issues before/during code migration.
• Conducted system health tests and regression tests after every new build.
• Experience in performing end-to-end User Acceptance Testing (UAT).
• Set-up, co-ordinate & conduct system & UAT testing with Business Analysts and end-field users after the applications were all set.
• Conducted reviews with clients and User Acceptance Testing teams
• Used SQL queries to validate the data between the backend and the front end
• Performed rigorous manual testing such Functional Testing, Smoke testing, Integration testing, UAT Testing, Backend Testing, Regression Testing, End to End Testing and System Testing
• Performed Database testing using SQL queries
• Executed the Test Scripts in Quality Center.
• Defects are logged using Quality Center and follow up with Business and Developers to discuss about the issues.
• Actively participated in Walkthroughs and Daily status report meetings.

Environment: C#, .NET, Java, Windows, Manual Testing, UNIX, SQL Server, Quality Center, XML, HTTP.

Confidential, Columbus, Ohio

Software Quality Assurance Analyst

Responsibilities:

• Developed Test Plans, Test Cases to test the Screens and workflows for Quality Assurance.
• Created and managed system testing schedule.
• Provided test team status reports on weekly basis to the project manager.
• Reviewed extensive SQL Queries with complex multi-table joins and nested queries.
• Involved in reviewing complex SQL queries, views, functions and stored procedures and spotting issues before/during code migration.
• Created and maintained SQL Scripts to perform back-end testing on the oracle database.
• Performed Database testing using SQL queries
• Conducted GUI, Backend, Data Driven and Security Testing.
• Conducted regression testing on new builds/versions.
• Validated XML request and response with different sets of test data to perform web services payment validation.
• Performed Black box testing and User Acceptance Testing.
• Wrote complex SQL queries for database validation using TOAD also tested stored procedures and triggers
• Wrote and modified required SQL validation scripts, and writing scripts in SQL to validate the outputs.
• Involved in creating output values using QTP.
• Performed backend testing using SQL queries to validate the data flow and data load in order to perform Backend Testing.
• Written several complex SQL queries for validating Cognos Reports.
• Tested whether the reports developed in Cognos are as per company standards.
• Involved in system & API testing for different modules
• Performed Back End Testing by executing SQL queries on Window and UNIX platform.
• Performed Regression Testing, Functional, UAT and Ad-hoc testing.
• Arranged weekly team meeting to assign testing tasks and acquisition of status reports from individual team members.
• Used Custom Reports, Built In reports and System Reports, Trend Reports function within Quality Center to track and report issue related activities.
• Worked with developers to resolve Issues and Production Incidents using Quality Center
• Developed and executed test cases test Scenarios and followed-up defects using Quality Center
• Conducted Bug review meeting to discuss resolution of issues
• Developed Test scenarios, Test Scripts and Test cases based on Requirements.
• Involved in coordinating with developers and business owners.
• Performed rigorous manual testing such smoke testing, Integration testing, Regression Testing, End to End Testing and System Testing.
• Performed backend testing using SQL queries to validate data.

Environment: Quality Center, Windows, Manual Testing, Oracle, Cognos, XML, Java, API, Html, QTP, SQL, UNIX, Toad, MS Office

Confidential, Cranston, RI

SQA Analyst

Responsibilities:

• Developed Test Plans, Test Cases to test the Screens and workflows for Quality Assurance.
• Expert in writing test scripts manually.
• Comprehensive knowledge about agile systems and its application in business enterprises work frame
• Identify the client/organizational needs and provide suitable agile system based solutions
• Tested application under the agile, scrum and sprint development and process.
• Ability to work using cross functional using agile Methodology.
• Worked with the business users in order to understand and document test scenarios related to critical business process/features/workflows regarding the web application.
• Reviewed extensive SQL Queries with complex multi-table joins and nested queries
• Created and managed system testing schedule.
• Running smoke tests and daily health checks in QA environment to ensure services are up and running
• Provided test team status reports on weekly basis to the project manager
• Reviewed extensive SQL Queries with complex multi-table joins and nested queries.
• Involved in reviewing complex SQL queries, views, functions and stored procedures and spotting issues before/during code migration.
• Conducted regression testing on new builds/versions.
• Tested various ad-hoc and canned reports as a part of crystal reports testing.
• Conducted bug review meeting to discuss resolution of issues

Environment: Winrunner, Manual Testing Methods, Crystal report, Regression Testing, System Testing, Java, J2EE, MS SQL Server, Share Point