Qa Lead Resume
Richfield, MN
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