Sr. Qa Analyst Resume
Charlotte, NC
SUMMARY
- Over 7 years of professional experience in Information Technology with extensive skills in Software Testing, Integration Testing, Functional Testing, Regression Testing, System Testing, Software Design, Development, and Quality Analysis.
- Extensive experience in the entire application Software Development Life Cycle(SDLC), which includes Requirements, Design, Development, System Testing, Configuration, Installation, Release Authorization, and Maintenance Phases.
- Over 4 yr’s experience in the field of Health Care, Banking & Financial Domain.
- Experience in analyzing Business Requirements and Specifications. Worked with Development and Business Analysts to define, write and execute test cases.
- Experience in Testing Methodology and Test Plan Formulation.
- Complete understanding of QA methodologies. Expertise and experience in performing different kinds of testing like black box testing, functional testing, GUI testing, integration testing, Back - end Testing, System Testing, regression testing and bug tracking system.
- Experience in testing Web, Client/Server and Stand-alone Windows applications.
- Extensive experience in writing Test plans, Test cases/scenarios, Test procedures and analyzing test results for manual and automated tests.
- Extensive experience in manual testing in various environments and using automated testing tools of HP (formerly Mercury interactive) Quick Test Professional (QTP), Win Runner and Quality Center.
- Expertise in problem solving and Bug Reports using Quality Center.
- Strong experience in client interaction and understanding business application and data relations from Product development group.
- Experience in Manual and Automated testing, test schedule planning, test case design, Documentation and Execution. Editing and playback the scripts after fixing the bug.
- Good exposure to RDBMS, SQL and PL/SQL, writing SQL scripts for backend/database testing.
- Extensively involved in Back-end Testing and manual testing using SQL and PL/SQL statements for data manipulation
- Good communication, analytical skills and flexible to learn advancements in the IT industry. Capable of performing multi-tasking and meets deadlines.
- Have a very good knowledge on CA or iTKO Lisa VSE.
TECHNICAL SKILLS
Testing Tools: Quick test professional 11.0, Win Runner7.0, Quality Center ALM
Databases: Oracle 8i/9i, SQL Server 2000/05
Languages: C, VB Script, SQL, PL/SQL, HTML
Reporting Tools: Crystal Reports 9.0/10.0
GUI: Window Forms, Web Forms
Operating System: MS-WINDOWS XP/ 7/2003/2008/2008 R2, UNIX
Hardware: IBM, Dell Compatibles
Packages: MS Word, MS Excel, MS Power point
PROFESSIONAL EXPERIENCE
Confidential, Charlotte, NC
Sr. QA Analyst
Responsibilities:
- Analyzed User requirements and documented test requirements, Test Plans, Test Cases using Quality Center.
- Followed Agile Methodology in Project Life Cycle. Participated in stand up meetings and weekly status meetings.
- Managed and conducted System testing, Integration testing and Functional testing.
- Tested the Real Time and Scheduled reports based on the requirements specified by business analyst.
- Extensively used the AutoSys jobs for the entire project.
- Extensively used XML’s for all types of messages to load data in to CDW for verifying ETL logic.
- Automated the test cases for the data loads using QTP.
- Created the store procedures for exporting the results in to Excel sheet’s to data comparison.
- Responsible for designing Framework and executing automation scripts using QTP.
- Managed and conducted System testing, Integration testing, Functional testing, UAT and Regression testing.
- Extensively used the XMLSPY for PXsd data mapping validation.
- Testing (that includes unit, integrated, regression, and UAT) a new ETL mapping validation which uses data stage under the Scrum (Agile) Methodology.
- Loaded data to different databases using SQL scripts and maintained a repository for data loading scripts.
- Execute batch processing and verify the jobs status and data in database tables.
- Managed and conducted System testing, Integration testing and Functional testing.
- Created the Xml’s for all the HL7 messages types to load the data in to the CDW tables.
- Prepared status summary reports with details of executed, passed and failed test cases
- Worked closely with the business analyst, Pharmacist and Clinical validation for validating the requirements.
- Validation of the reports using SQL queries
- Test data creation is one of the daily tasks to better validate the reports to cover more number of different scenarios.
- Responsible for designing Framework and executing automation scripts using QTP.
- Created QTP scripts to validate the Layout of the report in the regression, by standardizing the input file.
- Participated in business requirements reviews and software system (application) designs for testability.
- Written SQL Queries and executed them using IBM®DataStudio and AQT.
- Attended application walk-through and reviewed Requirements to understand the scope of the project and Attended project meetings as needed and Coordinated with the Developers to resolve the issues/defects
- Uploaded Requirements and Excel Test Cases into Mercury Quality Center. Executed Test scripts from Test Lab manually.
- Involved in System Testing, Regression Testing and Integration Testing
- Worked as a part of team in creating test database and generation of the test data based on different scenarios.
- Created XML Framework for generating xml files from the data sources.
- Created QTP scripts to create and load XML files for bulk loading of Test Database
- Worked on research for finding suitable tool for parsing HL7 Message and loading into database.
- Created Store Procedures to validate the field to field mapping validation.
- Initiated the process for Creating test cases in quality center using reusable modules
- Involved in analyzing functional requirements documents for multiple projects.
- Attended daily meetings, status meetings and defect tracking meetings
- Interacted with developers, Business & Management Teams and End Users.
Environment: Quality Center11.0, Quick Test Pro (QTP11.0), AQT, IBM®DataStudio 2.2.1.1, Business Objects, DB2, ETL, Data warehousing, UNIX Sun Solaris, Java, ASP, XML/SOAP UI Web Services.
Confidential
Sr.QA Analyst
Responsibilities:
- Involved in different phases of Software Development Life Cycle (SDLC).
- Developed & Implemented Test cases, Test scripts, and Test approach documents based on Business & Functional Requirement documents.
- Developed QTP Scripts using VB Script and Descriptive programming.
- Involved in Customization of Defect Module as per the requirement.
- Extensively involved in conducting the System integration testing, Regression Testing, Backend Testing and GUI Testing.
- Extensively Used QTP to develop the Regression Test Suite.
- Extensively involved in the installation and configuring QC and Quick Test Pro.
- Installed QTP and QC on Client machines installing using exe file and Silent installation.
- Installed QTP11.0 patches on the Client machines.
- Creating new projects and copying the existing Projects in the Quality center.
- Assigning (read/write) permission users to the projects in the quality center.
- Creating users in the Quality center.
- Also used Rational Quality Manager to write test cases for creating test cases, executing test cases for an AEGIS project
- Extensively used Quality Center for Bug Tracking, Test case development
- Performed Data Driven Testing using QTP to test the application with different sets of data.
- Extensively used Share point for the project tracking and assigning the tasks for the team.
- Extensively used SQL Query Analyzer, PL/SQL Developer to do the Backend Testing by writing the SQL Queries.
- Created Entities in the defect module and enhanced the code in the Quality Center11.0 as per the requirement.
- Created and maintained a Requirement Traceability Matrix (RTM) for the applications under test and Customized the RTM as per the Team’s Needs.
- Actively participated in Design Reviews and Weekly Status Meetings.
- Responsible for Coordination with business analysts & developers to discuss issues in interpreting the requirements.
- Responsible for providing Testing Efforts, Estimates & Timely status.
- Coordinated with business team and facilitated for successful completion of UAT.
- Prepared the System Test Plans and Test Cases for all the Production & Change Management releases.
- Tested Data transmission from SQL Database to Excel, Text & CSV Files and also tested various kinds of Reports based on external vendor requirements.
- Tested Security Module Role Based security for Access Control.
- Involved in developing and generating the Crystal reports for Test cases, Requirements, Execution Summary report.
Environment: Quick Test Professional 11.0, Quality Center ALM, Sprinter, Windows XP, Windows7 &Oracle 11g, SQL 2000/05, HTML, MS-Office 2003/07,10,Toad, Business Objects Crystal Reports, VB Script, Share point, Sprinter.
Confidential
QA Analyst
Responsibilities:
- Involved in different phases of Software Development Life Cycle (SDLC).
- Developed & Implemented Test cases, Test scripts, and Test approach documents based on Business & Functional Requirement documents.
- Extensively involved in conducting the System integration testing, Regression Testing, Backend Testing and GUI Testing.
- Extensively Used QTP to develop the Regression Test Suite.
- Extensively used Quality Center for Bug Tracking, Test case development
- Performed Data Driven Testing using QTP to test the application with different sets of data.
- Extensively used SQL Query Analyzer, PL/SQL Developer to do the Backend Testing by writing the SQL Queries (Select Statements and JOINS)
- Created and maintained a Requirement Traceability Matrix (RTM) for the applications under test and Customized the RTM as per the Team’s Needs.
- Actively participated in Design Reviews and Weekly Status Meetings.
- Responsible for Coordination with business analysts & developers to discuss issues in interpreting the requirements.
- Responsible for providing Testing Efforts, Estimates & Timely status.
- Coordinated with business team and facilitated for successful completion of UAT.
- Prepared the System Test Plans and Test Cases for all the Production & Change Management releases.
- Tested Data transmission from SQL Database to Excel, Text & CSV Files and also tested various kinds of Reports based on external vendor requirements.
- Tested Security Module Role Based security for Access Control.
- Extensively used Configuration management using VSS(Visual Source Safe)
Environment: Quick Test Professional 9.2, Quality Center 9.2, Windows XP, Oracle 9/10, SQL 2000/05, HTML, C#.Net, ASP.Net, MS-Office 2003/07, VSS(Visual Source Safe)