Senior Qa Analyst/test Lead Resume
San Antonio, TX
SUMMARY
- Around 8 years of diverse experience in teh field of Information technology with emphasis on Software Quality Assurance.
- Expertise in Software Quality Assurance and Testing (Manual and Automation), Test Plan Formulation, Functionality, GUI, Performance and Regression Testing in Web Based and Client/Server Applications in different environments and different Browsers.
- Worked in multiple domains like Retail, Telecommunications and Banking.
- Hands On experience in testing Data Ware Housing applications developed in Data Stage, Informatica and BI Reports using Business Objects and Micro strategy.
- Demonstrated excellence in writing System Specification documents, creating and executing Test Plans, Test Cases and Test Scripts.
- Created, maintained, and executed manual and automated test scripts for black box, functional, regression, system, security, load and stress testing.
- Tested and executed projects in Multi - Platform Environments like Windows, UNIX and Linux.
- Proficient in writing SQL Queries, Shell Scripts to validate teh application data.
- Experience in all phases of Software Development Life Cycle (SDLC), Testing life cycle and Bug life cycle.
- Experience in different SDLC methodologies like Waterfall, V-model and Agile (scrum).
- Experience includes teh testing of Internet, Client/Server and WEB based applications using automated test tools like Quick Test Pro (QTP).
- Customized QTP script (VB script) according to teh changing GUI / functional requirements of teh application. Inserted Standard, Bitmap, Database checkpoints for GUI, Functional, Data Driven, Keyword Driven and Regression testing using QTP.
- Extensively used Quality Centre (Test Director) for test management and as Bug Tracking System for reporting defects.
- Actively participated in Project Planning, Review and Status meetings.
- Proven Strong Analytical, Logical skills and ability to work on multiple projects
- Proficient in Relational Databases like Oracle, SQL Server and DB2.
- Extensively used CA Clarity PPM for Time Tracking.
- Ability to quickly master in new concepts, applications.
- Comfortable working with JAVA, .Net, C, C++, SQL Server, UNIX, Perl, Shell scripting, VB Script, HTML, XML.
- Strong functional background, excellent communication and interpersonal skills, good Team player, Self-Starter and worked in onsite-offshore model.
TECHNICAL SKILLS
Test Management Tools: Test Director 7.2/7.6/8.0/9.0/9.1,Quality Centre (9.2/10.0/11.0).
Testing Tools: Quick Test Professional 8.0/8.2/9.0/9.1/10.0/11.0 (QTP).
Programming Languages: Java, HTML, XML, SQL Server 2000/2005/2008, C, C++,C#, .Net, VB.
ETL Tools: Informatica 7.1/8.x, Data Stage, Ab Initio.
Scripting Languages: Shell Script, TSL, VB Script, Perl.
Databases: Oracle8i/9i/10g, SQL Server 2000/2005/2008, My SQL, MS-Access, DB2, Sybase, Teradata and TOAD
Web Testing: Browser-Side Test, Page-Layout, Hyperlink, Integrated calculative Data test, Data Validity and Cross-Browser Compatibility testing.
Database Testing: Transaction Testing (front end to back end testing), Data Mapping/ Data Conversion, Stress, Volume, Performance, Load Testing and Data & File Validation
Methodologies: SDLC, Waterfall, V-model, Agile (Scrum).
Operating Systems: MSDOS, UNIX, Windows 95 / 98 / XP / NT/ Vista/7, Mac OS X and Linux.
Version Control Tools: Visual Source Safe, CVS and Clear Case.
Utilities: MS Office Suite, MS Visual Studio 2003/2005/2008/2010.
WORK EXPERIENCE
Confidential, San Antonio, TX
Senior QA Analyst/Test Lead
Environment: Quality Center, QTP, VB Script, Shell scripting, Windows, Oracle, ASP.NET, C, XML, MS Office Suite, SQL Server.
Responsibilities:
- Reviewed Business Requirement Document (BRD), Functional Specification Document (FSD) and Design Document Specifications (DDS).
- Actively involved in Requirement Analysis, Business Analysis, Use-Case Analysis.
- Involved and developed comprehensive Test Strategy, Test Plans, Test Case and Test Scripts and documented them in Quality Center (QC).
- Involved in preparation of test data using Excel Sheet for End-to-End Scenario based testing in .NET environment.
- Designed teh Test Cases and participated in review Inspections.
- Executed teh test cases and test scenarios using Quality center (QC).
- Performed Smoke testing of teh application from end-to end for testing different functionality and database mapping issues.
- Extensively performed Functional, Integration, User Acceptance and Regression Testing on teh web-based application.
- Created, maintained and executed regression test scripts for HPO based on teh Business requirements.
- Used QTP to automate teh testing process by recording teh scripts and perform testing with various user data by parameterization to reduce teh future duplication of efforts.
- Inserted Standard, Bitmap, Database checkpoints (DB) for GUI, Functional, Data Driven and Regression testing using Quick Test Pro (QTP).
- Created Objects in Object Repository, data-driven tests and synchronization points in Quick Test Pro (QTP) to halp solve key problems.
- Logged and tracked teh defects using Quality Center defect tracking system (Defect Management).
- Attend daily standup meetings using Agile Methodology and report teh status to SCRUM master.
- Participated in review meetings and took teh initiative to meet teh QA testing targets.
- Performed production installation and validation.
Confidential, AR
Senior QA Analyst
Environment: UNIX, Windows, HP Quality Center, QTP, SQL Server, Shell Scripting, VB Scripting, DB2.
Responsibilities:
- Participated in Requirement review meetings and analyzed teh Business Requirements.
- Created test plan and test cases based on requirements and teh use cases provided.
- Uploaded test cases to teh Test Plan Module in Quality Center from test case template.
- Created test sets in Test Lab Module and executed teh test cases against teh application.
- Involved in Smoke Testing, Functional Testing, Regression Testing, System Testing.
- Logged teh defects in Quality Center and assigned them to corresponding developers.
- Generated reports (defects and test case execution) on daily basis to track teh progress of teh project.
- Integrating teh QTP scripts with HP Quality Center and executing teh same from Test Lab from Quality Center.
- Created teh necessary test data to execute teh automated scripts as external data sheets and imported teh data sheets into teh test scripts
- Used Parameterization for using various data to test teh application using QTP.
- Extensively used VB script for functions and file system objects
- Involved in Creating Reusable Actions and called them into external Actions
- Involved in create user Defined Functions and function Libraries using VB Script and load them as Resource Files.
- Maintained shared object repository and updating with new objects encountered.
- Used built in and user defined environmental variables to get teh counter values and store intermediate values from output values.
- Extensively worked on debugging, modifying and enhancing teh automation scripts in order to optimize for better performance.
- Created Recovery Files using Recovery Scenario Manager, associated teh recovery scenarios to tests to instruct QTP with specified trigger action on unexpected event/popup.
- Inserted Check Points and synchronization point to identify teh specified Object in Application.
- Participated in grouping teh Regression Test Cases into Automatable Test Scenarios based on teh business flow of teh application.
- Developed SQL queries to pull data from DB2 and Informix databases.
- Integrated teh data from different databases as per teh business logic and provided to end users.
- Developed shell scripts for running teh batch jobs.
- Prepared presentations with teh generated graphs (summary and progress) to support Team lead and Manager in status meetings.
- Reviewed teh defects with concerned developers and Team leads.
Confidential, Bentonville, AR
ETL Tester
Environment: Data Stage, UNIX,Quality Center, SQL Server, DB2, Micro Strategy, Query-man, TOAD, Shell Scripting.
Responsibilities:
- Actively participated in Business requirement documents and Functional requirement documents review before preparing test cases and test scenarios.
- Involved in Requirement review meetings and analyzed teh Business Requirements.
- Prepared Test Cases for teh mappings developed through teh ETL tool Data Stage and executed those Test Cases.
- Executed ETL scripts to load data from input files to teh target database.
- Performed Verification, Validation and Transformations on teh Input data before loading into target database like Operational Data Store ODS /Data Ware House DWH .
- Analyzed session logs and workflow logs in case of aborted/failed sessions to identify root cause.
- Validated all newly created Dimension and Fact tables after teh ETL process.
- Verification of teh layout format per teh design mock-up, style sheets, prompts and filters attributes and metrics on teh report.
- Understand each report & teh linkages of every field displayed in teh report with teh star schema and trace its origin back to teh source System.
- Written complex SQL queries to validate data with associated business rules.
- Developed shell scripts to run batch jobs.
- Prepared and executed Test Cases in QC (Quality Center)
- Verified and mapped each requirement with teh corresponding test case.
- Tracked Defects using HPQC and involved in defect triage meetings along with development team.
- Generated reports for Requirement coverage, Test coverage and defects.
- Involved in collecting QA metrics and provided necessary reports to teh management.
Confidential, Dallas, TX
QA Analyst
Responsibilities:
- Analyze teh Business Requirements, Functional Requirements and specifications.
- Attend daily standup meetings using Agile Methodology and report teh status to SCRUM master.
- Involved in performing Integration testing, System testing and Regression testing, post prod testing of teh application.
- Involved in Software Configuration Management Process, Version control to build teh files from development to test, pre prod and production environment.
- Responsible for writing test plans, test scripts, test cases, and executing test cases.
- Writing SQL queries and statements to test database for retrieving information, editing data and inserting data.
- Participated in meetings with developers to discuss enhancements and modifications.
- Responsible to build .Net applications and release process.
- Involved deploying code to production environment
- Interacting with development and testing team to improve overall quality of teh application
- Responsible to follow up teh production issues with offshore team.
- Generating reports regarding Requirement coverage, Test coverage and defects.
- Involved in collecting project QA metrics and providing necessary reports to teh management.
- Responsible to develop and run teh QTP Regression Test scripts on every prod releases.
Environment: Visual Studio 2005/2008, TFS, VB 6.0, ASP.Net, Visual Source Safe, TFS, Dashboard, SQL Server2000/ 2005/2008, Windows XP/7, QTP 9.2.
Confidential
QA Analyst
Responsibilities:
- Involved in preparing test plan and test case templates for manual testing.
- Participated in Requirement review meetings and analyzed teh Business Requirements.
- Developed Test cases based on requirements and teh use cases provided
- Understanding teh Project Related Documents.
- Creating and Executing Test Cases in HPQC
- Participated in grouping teh Regression Test Cases into Automatable Test Scenarios based on teh business flow of teh application.
- Used Parameterization for using various data to test teh application using QTP.
- Developed SQL queries to pull data from DB2 and Informix databases.
- Tracing teh Requirements with teh test cases.
- Defect tracking using HPQC and prepared reports for defects.
- Integrating teh QTP scripts with HP Quality Center and executing teh same from Test Lab from Quality Center.
Environment: UNIX, C, Pro* C, Oracle 9i, SQL, HP Quality Center, QTP, shell scripting.
Confidential
Tester
Responsibilities:
- Attended requirements and design meetings, review and analysis of requirements and design documentation.
- Actively participated in creating requirements traceability matrices, and test plans.
- Created, developed and executed test cases and test scripts manually and using automation tools.
- Functional and regression testing of Java/J2EE applications is done using Quick Test Pro (QTP).
- Created Objects in Object Repository, data-driven tests and synchronization points in Quick Test Pro (QTP) to halp solve key problems.
- Recorded Load Runner vuser scripts implementing parameterization both manually and by data driven wizards in Virtual User Generator.
- Used Load Runner to check teh source of performance delay: network or client delays, CPU performance, I/O delays, or issues with database server.
- Designed scenarios and used Load Runner Controller to monitor all vusers in a scenario from a single workstation.
- Team participation in implementation of patches and other code fixes with Production Support, Change Management and IT Operations.
- Supported version management to meet teh needs of teh business and applications supported using VSS. All while staying within teh guideline of Sprint’s change management system.
- Provided support for Unit and UAT testing as required for teh application or any other assigned application.
- Use Mercury Test Director to house all test documentation and report/track all issues and defects (Defect Management).
- Provided clear concise feedback to Development team on recurring errors both on an individual and team basis with aim of long-term reduction of defects found in final release.
- Provided back end testing for database auditing (DB) and data validation using SQL scripts.
Environment: Windows NT, WebLogic, Java, J2EE, JSP, SQL, PL/SQL, eclipse, VB Script, VSS, Quick Test Professional(QTP), Load Runner, Test Director/Quality Center.