We provide IT Staff Augmentation Services!

Qa Analyst Resume

SUMMARY:

  • 8+ years of experience in software quality assurance (QA) and software testing.
  • Experience in different types of testing including manual, automation, mobile testing, System testing including Regression Testing, Functional Testing, Performance and Integration testing of Client Server and Web based application in diversified industry sectors of Health care, Retail, Insurance and Financial domains.
  • Involved in all the phases of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
  • Highly proficient in working with Manual Testing and automated testing with tools like Quick Test Professional, Quality Center.
  • Experienced in test planning, developing test scenarios, test cases, Requirement Traceability Matrix, defect tracking, reporting & test automation.
  • Created Test Data based on testing scope using Microsoft Excel. In - depth knowledge of all QA Phases that include Manual, Functional, System, Integration, End-to-End testing
  • Involved in Writing, Updating and maintaining the Test documents for various stages of Testing for reference and auditing purpose.
  • Experience in documenting business rules and traceability of business rules.
  • Developed test cases in Excel sheets and imported it into QC/ALM.
  • Ran tests through test labs and reporting test results and defect summary. Also generated dashboard reports for management purpose.
  • Experience in using different bug tracking tools like Quality Centre (QC)/ALM, IBM Rational Quality Manager, Bugzilla, Jira Defect tracking tool, Test Director
  • Web performance and Load testing using LoadRunner; QC/ALM in Client/Server, Windows, and Web based applications.
  • Worked on Mobile testing using Iphone, Andriod and IPAD
  • Assisted in the implementation of QA processes to ensure correctness of data flowing through each stage of ETL process.
  • Debugging and Scheduling ETL Jobs/Mappings and monitoring error logs.
  • Validating the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the transformation rules.
  • Modified reports and did regression testing to validate the changes.
  • Wrote SQL queries to validate data stored in target database.
  • Worked on Mainframe files
  • Have worked with Stakeholders, Business Analysts, Application developers, Business team, and End users to design test cases/plans on various projects.
  • Have experience working in Agile and Waterfall methodologies.
  • Extensively worked on data validation, manipulation and updating the tables using SQL during testing of different databases such as ORACLE 11g and SQL Server.
  • Excellent knowledge in cross browser testing and SQL database testing.
  • Testing of ETLs to validate data movement from source databases to target databases
  • Good working knowledge of Unix/Linux Environment.
  • Understanding of software architecture technologies HTML, XML, SOA, SOAP and Web Services.
  • Used XML Spy to view XML Schemas and WSDL files
  • Responsible for Validating the XML file based on the XSD .
  • Participated in preparation of the XSD for each version, updated the XML file based on the XSD
  • Hands on experience with VB, PERL, Shell scripting languages .
  • Ability to handle multiple tasks independently as well as collaboratively with team members offshore in testing complex projects.

TECHNICAL SKILLS:

Functional Testing Tools: UFT/QTP, TestComplete, SoapUI

Non - Functional Testing Tools: Load runner

Test/Defect Management: Quality Center/TD,ALM, RMT, Bugzilla, Rally, Serena Dimensions, and JIRA

Databases: Oracle 11g/10g/9i, MS Access, TOAD, Microsoft SQL Server

Programming Languages: VB Scripting, C, C++, SQL, PL/SQL, Core Java

Markup Languages: HTML, DHTML, XML

ETL Tool: Informatica Power Center 7.1

Reporting Tool: Cognos

Operating Systems: Unix, Windows,Linux

Web Server: Tomcat, Apache web server, Websphere, Microsoft IIS

Scripting: PERL,Python

Browsers: IE, Chrome, Firefox

Mobile devices: Iphone, Andriod, IPAD

PROFESSIONAL EXPERIENCE:

Confidential

QA Analyst

Responsibilities:

  • Analyzed the Business requirements and the specifications and Developed Testing Strategy for entire application and developed various Test Cases.
  • Performed Manual Testing on the entire application in different environments like SIT, UAT, PFIX and PROD
  • Participated in all phases of Software Testing Life Cycle (STLC)
  • Worked on UI, Mobile testing for the entire application.
  • Responsible for doing Mobile Testing using mobile lab device connect
  • Worked on testing application on several devices like Android based, Iphone 7 or later and IPAD
  • Heavily involved in UI testing and written test cases for GUI validation for both positive and negative scenarios on different browsers like Chrome and Firefox.
  • Worked with developers in testing the application during code migration.
  • Went through condition matrix sheet, wire frames, training materials, release notes, FSD, Mobile user guide for references in developing test cases
  • Worked on Hogan database for retrieving the data.
  • Performed end to end testing of production updates for mobile devices accessing platform applications
  • Did test application in several environments like SIT, UAT, PROD.
  • Performed System Testing, Database verification testing and Regression testing and Smoke Test execution after every new build.
  • Tested extensive backend testing using SQL, SQL Queries to retrieve the data from the database and checked data integrity and Data Validation.
  • Held ownership of bug reporting and tracking till closure in HP ALM.
  • Involved in defect review calls every day with Dev and different teams accountable for the defect.
  • Worked with offshore and on-site teams across the globe

Environment: HP ALM, Hogan Main Frames, Windows 7, Chrome, Mozilla firefox, Share point Portal, Microsoft Office, Internet Explorer, Mobile Testing, Oracle

Confidential

QA Analyst

Responsibilities:

  • Analyzing the requirements and conducting requirement understanding walk-through calls with developers, client and stake holders.
  • Responsible for functional testing (prepared test cases/scripts) for the application and was also responsible for performing Regression testing.
  • Held ownership of bug reporting and tracking till closure in HP ALM.
  • Heavily involved in UI testing and written test cases for GUI validation for both positive and negative scenarios.
  • Responsible for creating Test Environment for Web Services testing.
  • Responsible to verify Web Services API request, response data validations in SOAP protocol using SOAP UI
  • Validated Web Services request and response XML using SOAP UI
  • Tested Confidential mobile application that can initiate wire transfers on Android, IOS platform mobile devices.
  • Performed end to end testing of production updates for mobile devices accessing platform applications
  • Did test application in several environments like SIT, UAT, PROD.
  • Ran regression testing after several PROD fixes
  • Performed System Testing, Database verification testing and Regression testing and Smoke Test execution after every new build.
  • Coordination with offshore and on-site teams across the globe

Environment: HP ALM, Hogan Main Frames, Windows 7, Share point Portal, Microsoft Office, Internet Explorer, SOAP UI, Oracle

Confidential

QA Analyst

Responsibilities:

  • Attended Requirements and Design meetings, Walkthrough Meetings to go through the Business processes of the projects before preparing test plans.
  • Actively participated in creating RTM template and test plans.
  • Analyzing user requirements and defining testing specifications
  • Developing test validations of various regular and infrastructure projects using HP ALM
  • Manually testing using ALM for scripting and defect tracking.
  • Actively distributed work among team members and tracked testing progress
  • Reported weekly status to high managements teams by pulling the test results reports from Dashboard.
  • Prepare Training documents for new resources.
  • Trained multiple users and resource in order to maintain balance by providing backups.
  • Performed functional testing, regression testing, smoke testing, system integration testing and user acceptance testing.
  • Scripting complex projects and verifying with business analysts and system analyst to understand the missing requirements.
  • Tested extensive backend testing using SQL, SQL Queries to retrieve the data from the database and checked data integrity and Data Validation.
  • Documenting bugs identified during various testing processes and recommending solutions and modifications to resolve bugs.
  • Successfully managed and delivered multiple complex projects simultaneously with promised time, cost and quality goals.
  • Successfully managed cross functional and globally distributed teams.

Environment: ALM, Hogan Main Frames, Windows XP, Share point Portal, Microsoft Office, Internet Explorer, Citrix APP, Quartz Application

Confidential, Columbus, OH

QA Analyst

Responsibilities:

  • Analyzed the Business requirements and the specifications and Developed Testing Strategy for entire application and developed various Test Cases.
  • Performed Manual Testing on the entire application. Conducted positive and negative testing.
  • Worked with Business Analyst and developers in understanding the requirement that is in the form of Use cases.
  • Prepared Test plans, Test Scenarios and Test Scripts as per functional, Business requirements
  • Communicating with Clients to prepare integration test plans
  • Executed Smoke, Functional, Regression, Integration and UAT Tests in Test and Integration Environments
  • Generated Oracle SQL scripts to validate large scale data against the XML Source
  • Involved in System testing, Integration testing, Functionality testing, Regression, End-End testing, User Acceptance testing
  • Executed Test Cases with a set of test data to verify the data validations.
  • Designing UAT Test Cases, with the help of the use cases diagrams as inputs for creating the Test Cases.
  • Debugged the code/server issues related to deployments and worked with Admin to fix the deployment issues
  • Performed Test Environment Server Restarts, Server Configurations and Server Stats using Putty through UNIX Commands
  • Used VI Editor to Modify Configurations and Property Files on the Test Servers
  • Used SVN to check-in and check-out Automation Test Scripts
  • Created and Validated the XML files based on the defined XSD’s with the help of XML SPY
  • Developed a good command over the XSD’s which helped in creating XML files and XML messages for Test Needs
  • Used Quality Center/ALM and Rally for Test Script executions and Defect Tracking
  • Prepared Test Data for the Team to satisfy the Test Needs
  • Verified RESTFUL web-services using Fire-Fox Rest Client and other HTTP Clients
  • Consolidate the weekly status of issues and report them to the lead and the manager.

Environment: XML, Java, UNIX, SQL Server, SQL, Windows, LINUX, UFT, SOAP-UI, Quality Center/ALM

Confidential, Bloomington, IL

QA Tester

Responsibilities:

  • Involved in Business analysis and requirements gathering.
  • Written the SQL scripts to validate ETLs developed by Informatica.
  • Assisted in the implementation of QA processes to ensure correctness of data flowing through each stage of ETL process.
  • Debugging and Scheduling ETL Jobs/Mappings and monitoring error logs.
  • Validating the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the transformation rules.
  • Created Source to Target mapping document from Mainframe logic
  • Load new or modified data into back-end Oracle database.
  • Extensively used Informatica power center for extraction, transformation and loading process.
  • Performed backend database testing by writing SQL and PL/SQL scripts to verify data integrity
  • Worked with ETL group for understating for data loading for both dimensions and facts.
  • Validated Informatica ETL mappings and transformations like joiner, update strategy and lookup.
  • Experienced with Informatica Power Center workflow manager and workflow monitor.
  • Experience in preparing the traceability matrix, test scenarios and test cases.
  • Experienced in writing complex SQL queries for testing data in oracle targets.
  • Experienced in executing test scripts using QTP for regression testing.
  • Validate the back end data needed for the Web service according to the business rules.
  • Prepared test data to validate ETL rules wherever necessary.
  • Accessed source files from UNIX environment.
  • Written several complex queries for validating informatica Reports.
  • Write SQL queries to validate Drilldown and Cross-Tab reports.
  • Validated reports cosmetic like color, size in Informatica reports.
  • Experience in data analysis and data testing and verified fields present in the reports are as agreed in the ETL specifications
  • Reviewed the test cases written based on the Change Request document.
  • Preparation of System Test Results after Test case execution.
  • Designing and Executing Test Cases in ALM
  • Reviewed Informatica mappings and test cases before delivering to Client.

Environment: UFT/Quick Test Professional, QC/ALM, Oracle, SQL, Windows SQL Server, SOAP-UI, Informatica Power Center 7.1, UNIX

Confidential, Farmington Hills, MI

QA Engineer

Responsibilities:

  • Created test plans by analyzing the Business Requirements and System Requirements of the application
  • Worked closely with Application Architects, Business Analysts, and Project Managers to discuss and collect business requirements
  • Participated in design sessions and application walk through
  • Executed automated test scripts for regression testing based on the requirement documents using Quick Test Professional.
  • Involved actively creating database of manual and automated tests, building and running test cycles and tracking and reporting defects using the Quality Center tool
  • Inserted Check Points to Check for the broken Links, Text, and standard properties of an object using QTP
  • Performed database testing
  • Uploaded all the Test plans and Test Scripts in the Quality Center. Extensively used Quality Center for Bugs reporting, reviewing and Defect Tracking.
  • Experienced in writing of UNIX Shell Scripting to analyze log files and reports.
  • Verified and reviewed the files in the specific directory in UNIX.
  • Performed manual testing claims and data integrity testing by executing SQL statements
  • Involved in UAT Testing
  • Checked the data flow from the front-end to backend and vice versa using SQL queries
  • Utilized process-based test management system Quality Center for organizing test requirement's documents, test plans and test lab.
  • Created Test data through front end and back end to test the functionality and to execute in Integration environment.
  • Logged defects using Quality Center Defect Management Tool.

Environment: QTP, Quality Center, SQL, VB Script, MS Office,, XML, Sybase, Toad, UNIX

Confidential, Charlotte, NC

QA Engineer (Manual Testing)

Responsibilities:

  • Reviewed web-based application and identify critical functionalities.
  • Gathering, Understanding and Documenting Requirements
  • Develop and execute Test Plans and Test Cases from requirements and specifications documents.
  • Manually created, developed and executed Test Cases
  • Responsible for documenting Test Plans, Test Cases as per Business Requirements for each release.
  • Created test plans to detail the testing scope, requirements (high level), strategies and all required resources.
  • Perform Functional, Regression, Integration, User Acceptance Testing, and End to End Testing
  • Document and report all found defect in Quality Center.
  • Provide all data validation through SQL queries.
  • Responsible for preparing User Manuals.
  • Preparing Test Scenarios & Test Cases and performing Manual Testing of the application.
  • Performed GUI, System and Regression Testing of the application

Environment: s: WinXP, MS Outlook, My SQL, MS Excel, Internet Explorer, Fire FoX, Google chrome, MS SharePoint, Quality Center, Bugzilla

Hire Now