We provide IT Staff Augmentation Services!

Qa Analyst Resume Profile

Professional Summary:

  • Over 7 years of experience in Testing Methodologies and Quality Assurance in Banking, Healthcare, Insurance Financial domain.
  • Strong experience in Quality Assurance and Software Testing.
  • Exposure to both Manual and Automated Testing of applications developed on Windows and UNIX platform.
  • Expertise in using Mercury Interactive Automated Testing tools Win Runner, LoadRunner, QTP, and Quality Center.
  • Experienced in developing Test Plans, Test Cases based upon the business requirements.
  • Expert in performing various types of testing manually.
  • Extensive knowledge of SDLC methodologies.
  • Experienced in testing Client/Server and Web-Based Applications.
  • Experience in Black Box, Positive, Negative, Data-driven, Unit, Integration, System, Front-End and Back-End Testing.
  • Also experienced in Regression and Functional Testing.
  • Proficiency in interacting with Oracle, SQL Server and DB2 databases using SQL.
  • Used Test Director/MQC for Bugs reporting and communicating to developers, product support and test team members.
  • Experience testing various functional reports using tools such as Business Objects, SQL reporting services, etc.
  • Conducted Parameterization to data tables, system performance tuning, heavy data-driven testing created object repositories in QTP.
  • Expertise in Oracle table data manipulation using SQL queries and UNIX commands/UNIX scripts.
  • Participated in design Walkthroughs and Inspection meetings to review Test scripts and results.
  • Ability to quickly understand and interpret business requirements.
  • Good Documentation and Process Management skills with an ability to effectively understand the business requirements to develop a quality product.
  • Excellent in communication, presentation, and interpersonal skills. Good team player with the ability to lead, manage and work independently in a time sensitive environment.

Technical Skills:

  • Test Management : HP Application Lifecycle Management, HP Quality
  • Center
  • Regression Testing Tools : Mercury HP Quick Test Professional, HP Functional Testing,
  • Defect tracking tools : Quality Center, Clear-Quest, JIRA
  • Other Tools : MS office: Word, Excel, Power-Point, Access, Outlook,
  • SharePoint, MS Project and Visio
  • Database : SQL, SQL-Navigator, Oracle,
  • Operating systems : Windows: 7, Vista, XP, Unix, HP-Unix, Linux

Professional Expertise:

Confidential

Sr. QA Analyst

Responsibilities:

  • Created Test cases from scratch by using Business Functional Requirement Specs, HLD and Wire Frames.
  • Daily kick-off meeting with QA team to discuss issues and daily tasks.
  • Daily Coordination with Business Analyst and Development team to keep update with business and functional requirement changes. Teams are located in Chicago, Atlanta, Dallas, Seattle, and India.
  • Created tracking sheet to trace QA testing efforts.
  • Produced test scripts in extremely detail level to assure that all the requirements are covered by every possible scenario.
  • Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
  • Conducted Black Box Testing on the application and validated the dataflow in the application.
  • Tested security test and audit test for this particular system. Performed Black Box, functional testing, end to end testing for world points system.
  • Manually tested the whole application before going for the automated testing.
  • Involved in testing the conversion of the application into web application using XML web services.
  • UAT testing performed along with call center managers to make sure that application meets their requirements.
  • Establish Test/Development to Production Export/Import EDI Transport from AS/400 to UNIX and assist in transition from legacy system s .
  • Experience in writing extensive SQL Queries on AS/400.
  • Was responsible for indexing of the tables in that data warehouse.
  • Used Test Director and Mercury Quality Center for updating the status of all the Test Cases Test Scripts that are executed during testing process.
  • Translated Business processes into Informatica Mappings for building Data marts
  • Extensively involved in the automation of Regression Test Cases by scripting.
  • Used Query Analyzer, Execution Plan to optimize SQL Queries
  • Responsible for Developing the test modules in the Quality Center for the new requirements
  • Performed End to End testing to assure the user friendly workflow.
  • Designed, developed and tested data mart prototype SQL 2005 , ETL process SSIS and OLAP cube SSAS
  • Executed Regression and IST sceneries in the Quality Center
  • Transferred data ETL to Data ware house Environment using SSIS and SSAS.
  • Interacted with developers and discussed technical problems, reported bugs and supported development team.
  • Used IBM Clear Quest to track the defects.

Environment: Oracle9i/Microsoft SQL, SSIS, SSAS, MS Office, BEA Web Logic server 8.1 SP4, MS Projects, Win2000, fire fox, Clear Quest, Quality Center 9.0

Confidential

QA Analyst

Responsibilities:

  • Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
  • Analyzing the ETL process created in Informatica, developed SQL queries and tables which replicated the ETL, and compared the SQL results with the Informatica tables.
  • Created test cases to test the liability,comprehensive,collision coverages.
  • Wrote test cases to handle creation of Quote.
  • Random Testing to check for Screen correctness for the functionality.
  • Performed GUI and functionality testing.
  • Performed system testing.
  • Used Data warehousing for Data Profiling to examine the data available in an existing database.
  • Configured the Data mapping between Oracle and SQL Server 2005.
  • Migrated Data from MS Excel to SQL Server Reporting Service Using DTS and SQL loader utilities.
  • Defined the test criteria, project schedules and base lined the Test Plan with the help of project meetings and walkthroughs.
  • Backend testing of the DB by writing PL/SQL queries to test the integrity of the application.
  • Responsible to import the data from Crystal reports by using Business Objects Live office into Microsoft Excel and Word.
  • Worked with SQL queries using MS Access for data manipulations.
  • Perform GUI, Integration, white box, middle ware and web service testing.
  • Involved in Black Box Testing, Performance Testing, Functional Testing and Integration Testing.
  • Involved in end to end testing from Quick Quote to the policy activation in both frond end application and in the mainframe.
  • Assisted in test environments scenarios to facilitate upgrade process on AS/400.
  • Provided AS/400 technical support including connectivity and configuration.
  • Research in design methods to create scenarios for adequate test coverage.
  • Performed database validation in the Mainframe to ensure the data entered through the frond end reached the database.
  • Regression testing was performed after each new build of the application.
  • Created and Documented test cases and test data for Business Users.
  • Also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
  • Extensively involved in System testing, User Acceptance Testing
  • Kept all testing requirements, test cases in Test Director and executed all test cases from Test Director.
  • Documented the entire testing process, test cases and test results.

Environment: C , Asp.Net, Oracle, SQL Server, manual Testing, MS Office Suite, MS Project, Test Director, Windows2000

Confidential

Quality Assurance Analyst

Responsibilities:

  • Development and execution of Test Cases in HPQC
  • Analyzed specifications and business requirements and wrote a test plan for the Insurance application.
  • Tested portal applications and also role based navigations, translations, single sign-on with other systems.
  • Completed completing testing lifecycles on Portal applications with SAP R/3, BW, Siebel and Oracle Systems.
  • Tested Java web services, Siebel web services using manually and soapUI tool.
  • Developed test cases after analyzing the requirement / specification documents.
  • Performed Manual and Automated testing
  • Involved in Automation Infrastructure Development in QuickTest.
  • Designed Tests for keyword driven methodology for selected areas.
  • Written SQL Queries to perform database validations.
  • Conducted Functionality, and Regression testing during the various phases of the application
  • Bug Reporting and Tracking the status in HP QC
  • Performed Functionality testing, GUI testing and Compatibility testing
  • Performed System Testing before the system went into the production.

Environment: SAP Portals, SAP R/3, SAP BW ETL Testing , Siebel, soapUI, Oracle 9i, HPQC and Windows NT 4.0.

Confidential

QA Analyst

Responsibilities:

  • Prepared system Test Plan and scenarios for Test Scripts.
  • Performed Black Box Testing based on the functional requirements and product specifications of the application. .
  • Identified as well as documented data sources and transformation rules required to populate and maintain data warehouse content.
  • Design and develop the data load process using Informatica, PowerCenter and XML Style sheets and ACORD XML.
  • Lead Business Intelligence reports development efforts by working closely with Microstrategy, Teradata, and ETL teams
  • Used different ad-hoc analysis, the Reports assist in defining strategy for each customer category. Informatica was used for ETL process and Business Objects 6.5.1 XI R2 are used for Reporting duties.
  • Reported tracked defects with reference to severity and types using Defect / Issue Logs.
  • Interacted with developers and discussed technical problems, reported bugs and supported the development team.
  • Designed testing approach for ETL process in the Credit Data Provisioning Enterprise Data Warehouse CDP .Ensure consistent and effective communication among all parties.
  • Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SQL Server Reporting Services SSRS .
  • Develop test plans in conjunction with team leads and business personnel and perform unit, integration, regression testing.
  • Created the SQL scripts for demonstrating the prototypes and for verifying the result sets
  • Analyzed the business and functional requirements of the application and developed detailed test plans, test cases in Test Director.
  • Defined the test criteria and project schedules, and baseline the Test Plan with the help of project meetings, walkthroughs.
  • Enhanced test cases using GUI checkpoints, Database Checkpoints, Text checkpoints and Bitmap checkpoints
  • Worked on Functionality, System, Integration, Interface, Data Driven, Performance, Load, Regression, Black Box and End-to-End testing.
  • Developed the Test plans for quality assurance based on functional requirements.
  • Performed database testing using SQL.
  • Performed User Acceptance Testing.
  • Interacting with the development and testing teams to improve overall quality of the software.
  • Developed the test harness and automated regression tests in WinRunner for functional and regression testing
  • Create test plans and test sets. Schedule batch tests, log and track defects using Test Director
  • Prepare and document test results.
  • Review compliance with existing policies and procedures.
  • Design and test security requirements for all new functionality or changes to existing functionality.

Environment:VB.net, Informatica, Test Director 7.5, Windows 2000, Windows NT, SQL, ETL, Microsoft Visual SourceSafe 6.0, MS Project, MS Office, Sun Solaris 8, Oracle 9i

Confidential

QA Analysis

Role Responsibilities:

  • Reviewed Business Requirements Documents and the Technical Specification.
  • Conducted the Functional, System, Integration, Regression, performance, UAT and Smoke Tests of the CDS Application.
  • Involved in Planning, Coordinating, Developing Test Plans, Test Procedures, Test cases and Test Matrices based on the Requirements and Design Documents.
  • Develop test scripts using Automated Testing tools like Winrunner for Functional testing and Regression Testing.
  • Extensively used Test Director for reporting categorized the bugs based on severity.
  • Developed SQL Scripts for Backend Testing to ensure that the data is updated as per the transactions and Business Rules.
  • Wrote SQL queries to validate input data submitted through GUI with the actual data in the Database.
  • Analyzed Test results to meet the end user needs. Tested the application manually by executing test cases prior to automation.
  • Performed back end testing using SQL queries. Performed Functionality and Security testing of the User authentication.
  • Used Test Director to create and maintain the Test cases and the Test scripts for both.
  • System Testing and Regression Testing.
  • Developed Test plan for System, Detail over all Test Plans using the Business
  • Specifications. Conducted the system integrated testing of the application manually for different Modules.

Environment: Win runner 7.x, Test Director 7.x/8.x ,Oracle9i/Oracle 8i, Windows NT, Windows 2000, SQL ,PL/SQL ,TOAD, TSL Scripts

Confidential

QA Analysis

Role Responsibilities:

  • Reviewed Business Requirements Documents and the Technical Specification.
  • Conducted the Functional, System, Integration, Regression, performance, UAT and Smoke Tests of the CDS Application.
  • Involved in Planning, Coordinating, Developing Test Plans, Test Procedures, Test cases and Test Matrices based on the Requirements and Design Documents.
  • Develop test scripts using Automated Testing tools like Winrunner for Functional testing and Regression Testing.
  • Extensively used Test Director for reporting categorized the bugs based on severity.
  • Developed SQL Scripts for Backend Testing to ensure that the data is updated as per the transactions and Business Rules.
  • Wrote SQL queries to validate input data submitted through GUI with the actual data in the Database.
  • Analyzed Test results to meet the end user needs. Tested the application manually by executing test cases prior to automation.
  • Performed back end testing using SQL queries. Performed Functionality and Security testing of the User authentication.
  • Used Test Director to create and maintain the Test cases and the Test scripts for both.
  • System Testing and Regression Testing.
  • Developed Test plan for System, Detail over all Test Plans using the Business
  • Specifications. Conducted the system integrated testing of the application manually for different Modules.

Environment: Win runner 7.x, Test Director 7.x/8.x ,Oracle9i/Oracle 8i, Windows NT, Windows 2000, SQL ,PL/SQL ,TOAD, TSL Scripts

Confidential

Responsibilities:

  • Formulating detailed Test Plan using Rational Test Manager, after analyzing business rationale and software requirement artifacts.
  • Administration of all the Rational Products
  • Interacted with the users to ensure meaningful development of the scripts and simulated real time business scenarios.
  • Performed Unit and Integration testing and participated with Developers during execution of tests.
  • Performed automated testing of the application.
  • Used Rational Robot for GUI tests and tested GUI Standards of this application.
  • Created extensive Data Driven Test scripts for reading data from Data Pool.
  • Wrote scripts in SQA Basic for backend testing.
  • Enhanced test scripts using the SQA Basic to achieve the test objectives.
  • Performed the Back-End integration testing to ensure data consistency on front-end by writing and executing SQL statements on the Database
  • Reviewed manual testing methods and developed and executed automated scripts using Rational Robot to perform regression testing.
  • Performed website scan using Rational Site Check.
  • Involved in Configuration testing.
  • Review results using Rational Log Viewer
  • Used Rational Clear Quest for version control, tracking defects, enhancement requests, assign work activities, and assess the real status of project throughout the life cycle.

ENVIRONMENT: Rational Team Test, IBM Web Sphere Application Server, Domino Server

Confidential

Role: QA Tester

Responsibilities:

  • Prepared Test Cases and Test Plan for the different modules of the application.
  • Analyzed the user/business requirements, functional specifications and User Case documents.
  • Developed Test Plans that include test cases, test scenarios, expected results and prioritized tests in Agile Methodology.
  • Developed scripts and Involved in the Manual Testing of the Application for online payment.
  • Performed Functional and Regression Testing of the application.
  • Included User-defined Functions and Libraries to increase efficiency.
  • Designed the data for interpreting the positive/negative scenarios.
  • Involved in the creation and enhancement of test scripts using TSL.
  • Used parameterization to make script data independent.
  • Extensive use of SQL queries to perform Data Integrity Testing.
  • Used JIRA to report bugs.

Environment: Test Director, JIRA, VB Script, C , PL SQL, Oracle 8i/9i, Windows 2000, HTML

Hire Now