SUMMARY:

• 14 years of extensive experience as a Sr.QA Analyst/Lead in Banking, Health Insurance, Mortgage, and Retails industry POS and Web, E - commers & ETL/DW applications to implement QA process.
• 14 years of diverse experience in Software Testing and Quality Assurance.
• Efficient in implementing QA Process, established standards, procedures, and methodologies.
• Strong Knowledge on the phases of Software Development Life Cycle. (SDLC) Methodology Waterfall and Agile.
• Identify the Test Requirements based on User Requirements and Program Specifications.
• Experienced in preparing Test Plans, Test Scripts, Test Cases and Test Data.
• Ability to identify tasks which require automation and automate test cases
• Expert in Data Conversion, Batch, integration, regression, functional & UAT tests.
• Experience in the areas of GUI, Functional, Integration, System, Front-end, Regression & Web Services testing for Client Server and web applications.
• Expertise in Risk Analysis, preparation of RTM & Prioritize Test case.
• Strong experience in interacting with business analysts and developers to analyze the user requirements, functional specifications and system specifications.
• Proactively studied various kinds of testing concepts and templates from various sources and effectively implemented them across the organization.
• Proficient in black box, Smoke testing.
• Experienced in distributed testing, multi-user testing and database testing.
• Strong skills in Batch & back-end testing using SQL queries on SQL Server 2000 and Oracle.
• Expertise in analysis of Problem severity, Defect tracking and Defects reporting system.
• Ability to work independent or as a team member, excellent written and verbal communication skills.
• Excellent interpersonal skills and ability to work in a cross-functional environment.
• Excellent problem solving and multitasking. Quick learner and able to work under pressure to meet deadlines.
• Expertise in Winrunner, QTP, Quality Center, ClearQuest, PVCS tracker, XML and SQL.
• Expertise in Data warehouse and ETL Applications

TECHNICAL SKILLS:

Platforms: Windows XP/10, Unix

Programming Languages: XML, HTML, SQL

Databases: Oracle, SQL Server 2008,MS Access

Automated Testing Tool: Quality Center / QTP

QA Tools: QTP/UFT

Browsers: IE, Chrome, Fire fox.

PROFESSIONAL EXPERIENCE:

Confidential

QA Lead

Responsibilities:

• Participated in Release and Sprint Planning & scrums.
• Defined user stories & tasks in VersionOne to track the project.
• Executes test cases and validated acceptance criteria
• Demoed user stories to PO and BO for acceptance
• Involved in user story reviews and refinement sessions
• Prepared SQL queries to validate UI data in the database
• Involved in defect reviews and triage with developers & POs
• Performed functional, Integration testing in each sprint
• Performed regression, system and UAT testing after each sprint
• Supported Prod validation on the deployment
• Prepared source data for Batch processing
• Validated batch data from source to target using SQL queries
• Validated business rules and mappings against target data

Environment: ASP .net, sql server, c#

Confidential

QA Lead

Responsibilities:

• Implemented QA process like Test Design, Test Development & Test Execution
• Analyzed requirements and created Test Scenarios & test conditions
• Developed test plan and conducted test plan meeting
• Developed Integration and System test cases using Quality Center 10.0.
• Created Traceability matrix and mapped requirements to Test cases.
• Conducted test case Walk-Through with business.
• Prepared mockup test data for input files.
• Worked on Data Marts to verify Historical data.
• Updated and created new data in Nexsure application and verified data in Data Warehouse database after Incremental ETL has triggered.
• Used advanced SQL queries to validate Data Warehouse database data against Nexsure Database data.
• Expert in ETL QA Process testing (source to staging to data warehouse and data marts).
• Expert in Web/API Services testing using SoapUI for SOAP, HTTP protocols.
• Tracked and reported defects into ALM and notified management with details
• Performed Functional, System, UAT testing, Database testing and Regression testing

Environment: Windows XP, Java, SQL Server, Quality Center 10.0, QTP 10.

Confidential

QA Analyst

Responsibilities:

• Implemented QA process like Test Design, Test Development & Test Execution
• Analyzed requirements and created Test Scenarios & test conditions
• Developed Integration and System test cases using Quality Center 9.2.
• Created Traceability matrix and mapped requirements to Test cases.
• Participated in Walk-Through for test cases.
• Prepared mockup test data for input files.
• Ran batches to process input files.
• Uploaded into HBS Deposit Application and processed files
• Imported data into Power Plus database
• Validated data in the database against input file.
• Performed UAT testing, Database testing and Regression testing
• Logged defects into ‘Clear Quest’
• Participated in defect tracking meetings for defect resolution

Environment: Windows XP, HTML, Quality Center 9.2 and Clear Quest

Confidential

QA Analyst

Responsibilities:

• Implemented QA process like Test Design, Test Development & Test Execution.
• Developed Test Strategy & Test Plans.
• Created Test plans for functional, integration and system testing
• Analyzed requirements and created Test Scenarios & test conditions
• Developed Integration and System test cases.
• Created Traceability matrix and mapped requirements to Test cases.
• Participated in Walk-Through for test plan and test cases.
• Prepared mockup test data.
• Performed Integration Testing, System testing, Database testing, UAT testing and Regression testing
• XML data file validations against DTD/XML Schema.
• Understand mappings rules or business logic.
• Verified Informatica transformations.
• Verified lookup & its conditions.
• Verified Source and Target used in the mapping.
• Verified Concatenating, Splitting or manipulated field conditions.
• Verified Record rejection condition
• Verified Whether the Filter condition used is proper.
• Verified all transformation conditions used in Mapping.
• Validated XML tags and counts against backend database.
• Validated XML data or contents against backend database
• Tracked and reported defects into Clear Quest and notified management with details

Environment: Windows XP, HTML, XML, Informatica and Clear Quest

Confidential

QA Analyst

Responsibilities:

• Participated in Sprint Planning bi-weekly
• Defined tasks and estimated timings for sprint.
• Attended daily Scrum Meetings.
• Used VersionOne project management tool to track tasks.
• Implemented QA process like Test Design, Test Development & Test Execution.
• Involved in both Manual and Automated testing.
• Developed Test Strategy & Test Plans.
• Created Test plans for functional, integration and system testing
• Analyzed requirements and created Test Scenarios & test conditions
• Developed Integration and System test cases using Quality Center.
• Created Traceability matrix and mapped requirements to Test cases.
• Participated in Walk-Through for test plan and test cases.
• Prepared mockup test data for batch processing.
• Executed test cases manually to verify the expected results.
• Performed Database Testing, Integration Testing, System testing, UAT Testing and Regression testing.
• Ran batches to load data into databases.
• Performed database validation according to the business logic.
• Compared flat file source data to the target database tables.
• Creating and executing SQL queries to validate test data using TOAD
• Tracked and reported defects into QC and notified management with details
• Recorded test cases using Quick Test Pro for Regression Testing
• Enhanced test scripts and debugged
• Analyzed root-cause for defects and documented.
• Involved in the entire SDLC of the projects from Initiation to Implementation

Environment: Java, SQLserver2005, Quality Center 9.0 and QTP 8.2

Confidential

QA Analyst

Responsibilities:

• Analyzed and understood client business requirements
• Developed Test plans for functional, integration and system testing.
• Developed Test Scenarios and Test Conditions.
• Developed Test scripts using Quality Center
• Created Traceability matrix and mapped requirements to Test scripts.
• Prepared Test Data.
• Validated transformation rules fields data in target table after the ETL process.
• Executed test cases manually.
• Performed Integration testing, System testing, Compatibility, Database UAT and Regression testing.
• Used ‘Test Cycle Control Sheet’ for testing progress.
• Recorded test cases (Manually tested and defect free) using Quick Test Pro for regression testing
• Enhanced test scripts and debugged scripts
• Scheduled and Participated in triage meetings for defect resolution.
• Coordinated offshore team in India.

Environment: Quality Center, Windows XP, HTML, TOAD and QTP 8.2

Confidential, Richfield, MN

QA Analyst

Responsibilities:

• Analyzed and understood client business requirements.
• Identified scenarios and test conditions.
• Prepared Tractability matrix and prioritized test cases.
• Developed Integration and System test scripts using Test Director.
• Performed Integration testing, System testing and Regression testing.
• Involved in web services testing.
• Modified Test cases/scripts according design docs changes.
• Tracked defects and logged into Clear Quest.

Environment: Test Director, Windows XP, Toad, J2EE and Clear Quest

Confidential

QA Analyst

Responsibilities:

• Analyzed and understood client business requirements
• Developed test scenarios, test conditions.
• Developed Integration and System test scripts using Test Director.
• Performed Integration, System, Compatibility and Regression testing.
• Modified Test scripts according design doc’s changes.
• Tracked defects and logged into Clear Quest.
• Gathered and recorded validation results during test execution phases.

Environment: Test Director, Windows XP, HTML, DHTML, Toad and Clear Quest.

Confidential

QA Analyst/Tester

Responsibilities:

• Developed test scenarios, scripts, test conditions, and expected results.
• Involved in functional testing for Allocation on line screens.
• Performed database testing, Integration testing System testing and Regression Testing.
• Prepared data mappings and test data for batches processes.
• Ran shell scripts in UNIX platform to Load data into Retek database.
• Used SQL statements extensively to retrieve data.
• Modified Test scripts according design doc’s changes.
• Tracked and reported defects & issues then logged into Clear Quest.
• Gathered and recorded validation results during test execution phases.

Environment: Test Director, J2EE, HTML, XML, Windows XP, Toad and Clear Quest