SUMMARY:

• Test Specialist Around 6 + years of Automation & Manual Testing experience in HealthCare & Banking Domain as Quality Assurance/Testing and Analysis with emphasis on GUI testing, System Testing, Functional Testing, Regression Testing and User Acceptance Testing of Web, Client/Server applications. Results oriented and a problem solver as well as solid work ethic and an effective team member.
• Extensively Worked on Various Automation Tools such as Confidential (RFT) Selenium(Java based automation tool).
• Extensively worked on Regression Testing using RFT( Confidential ), Defect Tracking tool RTM(Rational Test Manager)
• Experience in coding Java on various automation tools such as RFT, Selenium
• Experience in developing Test Plans, Test Case and Test Scenarios based on application and specification
• Extensively involved in Manual testing and Automation testing
• Extensively involved in GUI testing, Web applications testing, Functional testing, Integration testing, Regression testing, System testing and Performance testing.
• Good exposure to defect life cycle and testing life cycle.
• Exposure to various Testing Methodologies like Agile, Water Fall - Model
• Solid Back End Testing experience by writing and executing SQL Queries.
• Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software.
• Extensive experience in writing SQL scripts to validate the databases systems and for backend database testing.
• Proficient in using Automation tools such as selenium IDE, WebDriver, Jira, QTP and Confidential
• Experience in Writing the test cases using Element locators, WebDriver methods, Java programming features and TestNG Annotations
• Experience in Data driven Testing, Cross Browser testing and Parallel Test execution using SeleniumWebDriver, TestNG and selenium Grid.
• Experience in Functional Testing, Integration Testing, System Testing and Regression Testing having executed on both Client/Server and web based applications.
• Performance Testing on Hp Load Runner.
• Expert in using the Bug tracking with Test Management Tools like Quality Center.
• Experience in Quality Center / HP ALM Administration including hands on server deployment, Major version upgrades, Patch installations, Utilities using Site Admin API and Quality Center API.
• Prepared QA status summary reports for each assignment and performed manual data testing.
• Experience with Black box testing, white box testing, Unit, Integration, Regression, Sanity, System test, Functional testing, GUI applications testing and Database Testing.
• Expertise in working in Agile (Scrum), Waterfall, Spiral methodologies.
• Expertise in creating Test Plan documents and developing test strategy documents and preparing the Traceability Matrices.
• Expertise in designing the test scenarios and scripting the test cases in order to test the application.
• Creation of test data and Automation of test cases for system and analyzing bug tracking reports.
• Expertise Shell Scripting experience on UNIX, Linux and Windows environment.
• Performed Data Centric testing to validate the data that is loaded in to the data warehouse is correct as per the defined business rules.
• Expertise in developing, documenting, and executing test cases manually as well as generating automated scripts using Selenium.
• Worked in AGILE-SCRUM Methodology and used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
• Extensively strong on databases including Oracle, MS SQL Server, and Teradata.
• Strong in testing Stored Procedures, Functions, Triggers and packages utilizing PL/SQ.
• Good experience in Data Modeling using Star Schema and Snow Flake Schema and well versed with UNIX shell wrappers, KSH and Oracle PL/SQL programming.
• Experience in testing and writing complex SQL, T-SQL and PL/SQL statements to validate the database systems and for backend database testing.
• Authorized to work in the US for any employer

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis, MN

Database Tester/ QA Analyst

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center 9.0.
• Implemented Automation using Selenium Web Driver jars, JAVA, TestNG
• Extensively Automated Regression and Functional Test Suites by developing over 50 test cases, 6 Test Suites using Selenium WebDriver, JAVA
• Created Test Cases using Element Locators and Selenium WebDriver methods
• Developed Keyword Driven, Data Driven Framework & Hybrid Driven Framework to retrieve test actions from Excel Files using POI and TestNG
• Created different String methods for example compare the test data and web Elements value, Count of the value appeared on the page.
• Developed test cases, test reports, test scenarios and make sure every defect is logged.
• Executed SQL Queries to check the data table updates after test execution
• Strong Experience in Automating Web Application Testing Using Selenium Web Driver with TestNG framework
• Used Jmeter to test on websites of doubling for performance and api tests
• Well Versed with Handling Elements in Selenium WebDriver
• Writing Test Cases using ElementLocators,Webdriver methods, java coding and TestNG Annotations
• Executing Selenium Test Cases and Reporting Defects
• Experience in Data driven Testing, Cross browser testing and parallel test exec using selenium Webdriver,TestNG and Selenium Grid
• Execution of test scripts using Selenium WebDriver using JUnit frame work.
• Setup Selenium GRID to run Selenium scripts on different browsers
• Responsible for project scheduling and Tracking, Preparation of Test plans, Defect reporting, Defect resolution and Test Design Executions
• Generated Install and Update documents for and Quality Center.
• Created test data for testing specific Membership functionality.
• Involved in Identifying Testable Requirements, Designing the Test Cases.
• Involved in generating Traceability Matrix Report through Q.C after successfully mapping Test Cases with Requirements.
• Executed SQL queries within UNIX shell scripts in the UNIX environment.
• Logged defects by following Bug Life Cycle (BLC) in HP Quality Center (QC) and Jira.
• Performed Web Services testing and Validated XML request/response data using SOAP UI.
• Extraction of test data from tables and loading of data into SQL tables.
• Written several complex SQL queries for validating Cognos Reports.
• Responsible for Data mapping testing by writing complex SQL Queries using WINSQL.
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Validating the data passed to downstream systems Involved in Teradata SQL Development, Unit Testing and Performance Tuning.
• Worked with data validation, constraints, source to target row counts.
• Developed automated Test Scripts using.
• Utilized HP Quality Center (QC) for capturing Requirements, Test Case development, Test Execution from Test Lab module, and logging & tracking Defects throughout Bug Life Cycle (BLC).
• Was involved in design part for Extracting data from different source systems into the target database using IBM Data stage Server 8.1.
• Wrote and ran Unix Scripts for batch jobs.
• Tested PL/SQL procedures that were developed to load the data from temporary tables in staging to target tables in the data warehouse.
• Performed regression testing against the various builds of the application and executed manually in RQM to perform through testing.
• Used data conversion to protect the data and prevent data loss.
• Strong in writing sql queries and makes table queries to profile and analyze the data in MS Access.
• Created macros to automate the process of refreshing the data in MS Access.
• Provided technical support and coaching to team members about functionality of MS Access.
• Involved in testing data mapping and conversion in a server based data warehouse.
• Involved in testing the UI applications.
• Involved in Security testing for different LDAP roles.
• Used Microsoft excel and Word 2003 to document the test status reports and the Test Data.Used Quality Center to track and report system defects.
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.

Environment: Selenium, Java, SQL, PL/SQL, SQL Server 2008, HP Quality Center (QC), XML, XSLT, XML, Jenkins, ANT, SOAP, Eclipse, JDK 1.6, Selenium WebDriver, TestNG UML, Design Patterns, JavaScript

Confidential

Jr. Quality Analyst

• Gathering requirements and Creating Automation test plan
• Setting up suitable environment for Regression testing and upgrading the test environment
• Implemented Enterprise Automation Framework which is a Hybrid framework (Keyword Driven + Data Driven)
• Designing and creating Automation test script
• Designing, Creating and executing scenarios for Regression Testing
• Worked on Performance Testing using RPT(Rational Performance Tester).
• Analyzing the Regression test results and reporting the results.

Confidential

Rational Test Manager

• Online shopping Portal caters to the specific needs of the Brokers of WellPoint Inc. Brokers will be able to calculate the premiums, co-pay and co-insurance of the members depending on the formulary used by the members. This will help the brokers to guide the members to register for the health insurance plans.
• Major functionalities in this shopping portal include:
• Calculate the Out of pocket amount, plan paid amount of various drugs when registered for different plans provided by WellPoint Inc and provide the members with a quote.
• Brokers will be able to register the members and subscribe them for a plan.
• Brokers will be able to update the member’s details and reset their passwords if their member portal credentials get locked out.
• Acquiring thorough knowledge about the architecture of the application
• Environment Setup which includes installing RFT 8.1.1.1, IE8, java 1.6 configuring the system based on the installation guide and Release Notes
• Upgraded the environment
• Implemented Enterprise Automation Framework which is a Hybrid framework (Keyword Driven + Data Driven)
• Development & debugging of scripts using RFT