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