SUMMARY:

• QA Analyst with 7 1/2 years of combined experience in manual testing and automation testing using Selenium with Java on Web based, Client/Server, GUI, Windows and Big Data Warehouse applications with strong understanding of business scenarios.
• In depth understanding of Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC) in Agile and Waterfall environments to ensure Quality Control.
• Strong knowledge in writing Test scenarios, Test cases, Test data, Test procedures, Test reports and Test Matrices by mapping them with the requirements for generating a Requirement Traceability Matrix (RTM).
• Experience in testing Data Warehouse projects ETL validation testing using IBM tools such as Informatica, DataStage.
• Hands on experience in testing ETL operations including data extraction, data cleansing, data transformations, data loading.
• Experience in writing SQL Queries for migrating the data from DB2, Netezza to Oracle database.
• Performed data validation for millions of data by writing SQL queries and extract data from the tables.
• Proficient in dealing with open source tools like Selenium IDE, Selenium WebDriver, Selenium Grid and Selenium RC, Eclipse, Cucumber, Java, Junit, TestNG, Maven, LoadRunner.
• Expertise in working with Manual and Automated testing tools such as: SOAP UI, IBM RIT, Clear Quest, ALM.
• Experience in performing various testing methods like UAT, Installation, Smoke Testing, Sanity Testing, Regression Testing, Integration Testing, Black Box Testing, Gray Box Testing, Incident Recovery.
• Expert in Bug Tracking and Reporting with the Test Director/ HP Quality Center. Well experienced in using Test Management tools such as RALLY, JIRA, Bugzilla, qTest, bug reporting tools to track the test progress, execution and deliverables. Hands on experience in using Configuration management tools like SVN, also the build and project management tools like Maven.
• Excellent in using various Spying tools like Firebug and Firepath element as a Firefox add - on for addressing web elements using Locator’s ID, Class name, CSS Selector, Xpath, etc.
• Proficient in authoring requirements Artifacts, Business Requirement Document (BRD), System Requirements Specification Document (SRS), Use-cases, Functional Requirements Document (FRD), Technical Requirements Document (TRD), and Change Requests Planning (CRP).
• Proven ability in designing and creating automation frameworks using Java, Junit/TestNG, Selenium WebDriver/IDE/Grid, ANT/Maven and Jenkins.
• Expertise in using Apache POI for data driven frameworks, to load data into required test scripts from external sources like excel sheets.
• Effective in using JIRA Project Management software for user story documentation, assignments, reporting and defect tracking, and using rational tools RFT, RTC -- to create user stories in the project level within agile lifecycle.
• Proficient in mobile testing using Appium on real and virtual devices to execute the mobile automation test scripts.
• Handled special mouse events and keyboard actions like mouse hover, drag and drop, context click using Selenium Actions builder. Worked on handling the Pop-ups Screens, Multiple windows with Selenium.
• Expertise in implementing Maven as a build management tool to manage the required dependencies, plugins and for uniform build systems. Experience working with logging frameworks such as Log4j and Extent loggers, to capture the flow of test cases of an application.
• Performed User Acceptance Testing (UAT) using Gherkin Language to write the acceptance criteria’s such as feature file, Scenarios, outline and performed the step decisions and runner classes using Cucumber.
• Experienced in performing Backend testing by writing SQL queries and running PL/SQL scripts in TOAD. Worked in writing Joins, Sub-queries for complex queries involving multiple tables.
• Experienced in working/coordinating the QA efforts with offshore resources as well as preparing and reporting Daily, Weekly and Monthly reports as per the current project standards and processes.
• Flexible and versatile to adapt to new concepts of any environment, very co-operative team player with good inter-personal communication skills, extremely dedicated, Pro-active and willing to assume responsibility with good problem solving and documentation skills.

TECHINCAL SKILLS:

Programming Languages: Java, CSS, HTML, jQuery, Gherkins, XML

Testing Tools: Selenium IDE/WebDriver/GRID, QTP, JUNIT, TestNG, Firebug, xpath, Maven, JSON, Jenkins, SOAPUI, IBM Infosphere DataStage, qTest, SAS, Control-M, Cucumber, Protractor

Bug Tracking Tools: Quality Center (QC), Bugzilla, JIRA, GitHub, Mercury/HP, Rational Clear Quest, Rally, Firebug, LoadRunner

Web Services: SOAP, REST API, WSDL, SOAPUI

Operating System: Windows, MAC, DOS, Linux/ Unix

Database: Oracle, SQL, DB2, Netezza

Web Servers: Apache Tomcat, Web Sphere, Web Logic, IIS

Version Control: SVN, GIT, CVS, TFS

Scripting Languages: C#, Java Script, Shell Script, VB Script, Groovy Script, Gherkin

Browsers: IE, Firefox, Chrome, Safari.

Framework: Keyboard Driven, Data Driven, Hybrid Driven, Page Object Model (POM), BDD

PROFESSIONAL EXPERIENCE:

Sr. Automation Engineer & ETL Tester

Confidential, Plano, TX

Responsibilities:

• Involved in gathering requirements for the scope designed to perform data validation testing for data migration purpose.
• Worked in Agile environment as part of Sprint planning and define the testing scope.
• Involved in preparing the Test plans, Requirements Traceability Matrix (RTM) and defining the approach to perform Data Validation.
• AML-Anti Money Laundering data migration project validating the Members, Accounts and transactions in their Confidential Account and outside accounts.
• Created test scenarios and reviewed with development team to add any other critical scenarios for validation.
• Analyze the mapping documents and create testcases for the test scenarios designed.
• Prepared and executed the test cases manually to perform Integration testing, compared and analyzed actual with expected results and reported all mismatches in the values to the developers.
• Mapped requirements to the test cases by defining the planned start and end dates for execution.
• Involved in extensive DATA validation using SQL queries after running the Control-M jobs to load data from Source to Target database.
• For validating millions of records used MINUS queries to filter the data that has not migrated to the target database.
• Performed verification of UNIX logs using Putty while performing the testing.
• Extensively used IBM DataStage to monitor the scheduled job runs.
• Created SQL views to aggregate data before moving to targeted database from live legacy database to simulate results.
• Developed and executed SQL queries to validate the data migrated from DB2, Netezza MSSQL to Oracle database.
• Involved in featuring the Control-M sequences and designing the extract, transform and load jobs in Datastage and schedule timely runs daily.
• Used qTest Test Case management tool with the requirements, test cases and perform execution, also created defects based on the validation and assigned to developers by failing the test runs and link to the defects.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters to extract only the additional data added during that period.
• Verified the CDC logic for each table once the delta loads are done and execute the testcases in qTest.
• Validated the Count of records loaded and column wise data in History, Initial load and Daily loads.
• Worked with Data Extraction, Transformation and Loading (ETL) tools and performed testing to validate the records migrated from source to target database.
• Used TestNG and Maven repositories in creating the Selenium framework with page factory classes.
• Extensively used Protractor to develop automated test scripts for testing the UI applications developed on Angular JS and Node JS.
• Configured Selenium WebDriver, Maven tool and created Selenium automation scripts in Java using TestNG prior to agile release.
• Created test scenarios and test cases in BDD framework with Gherkin Language by creating feature file with given, when and then commands.
• Performed End-to-End, Smoke, Regression testing by creating test suite using Selenium WebDriver.
• Created POM framework to perform automation using Selenium for web application after validating the backend data.
• Tested compatibility of application for dynamic and static content under various cross browsers using HTML IDs and XPath in Selenium.
• Performed Data Driven Testing using BDD tools by writing the code in feature file and scenario files.
• Used Cucumber for Regression and functional testing using Selenium as primary tool.

Environment: Selenium, Java, Cucumber, Protractor, Gherkin, TestNG, Maven, Angular JS, Node JS, SQL, DataStage, qTest, RTC, Control-M, Oracle, SAS Enterprise, Eclipse IDE, POI, Chrome, IE, Windows, Linux.

Sr. Automation Engineer

Confidential, Orlando, FL

Responsibilities:

• Involved in the Requirements Gathering phase and reviewed the Business Requirement Specification (BRS), documentation and participated in the preparation of Test Cases based on the automation scope.
• Responsible for implementation of the test automation framework using Page Object Model (POM) with Page Factory and page classes from scratch to represent web pages using Selenium automation tools.
• Created test strategies, testing plans and prepared detailed test cases for the applications using Selenium WebDriver, TestNG and Maven.
• Worked in Agile methodology, as part of sprint planning review the test stories, planned the test sessions and attended daily stand up meetings.
• Developed, enhanced and maintained a large and complex suite of both GUI and API based Automated Regression tests.
• Prepared test data for testing the application in various test phases.
• Parameterized Unique and dynamic content in the application scripts for real time emulation. Data was queried from Data base and input data for data driven tests were kept in Excel Reader by using Apache POI repository.
• Used Log4j API for providing logging information and Maven for Project Management and configuring dependencies needed for building testing and running code.
• Created SQL views to aggregate data before moving to targeted database from legacy database to simulate results.
• Experienced on writing SQL Queries to extract data from various source tables to perform database testing using SQL developer and TOAD.
• Worked with SQL queries for data verifications in Oracle database.
• Involved in SOAP & REST based Web Services testing using SOAP UI testing tool.
• Tested the GET and POST request responses for web services interfaces by implementing Groovy Script with SOAPUI test tool.
• Used Extent Reports, reporting library to send the Automation reports in the form of Email. Captured the Screenshots of the script and displayed in the Reports.
• Using Selenium Grid in Jenkins (Linux Server) Continuous Integration with Windows Server, configuration for batch process run of the Scripts.
• Used IBM Info Sphere DataStage to perform tuning the test data by writing extensive SQL queries for data validation and extraction process.
• Performed the Mobile testing for mobile app of client, identify the mobile Platform like IOS, Android by using Appium.
• Created XML based test suite and integrated with Jenkins Server to execute automation scripts on a regular basis by scheduling Jenkins jobs in different test environments with different test configurations.
• Created Requirement Traceability Matrix and Bug Tracking tool with certain changes in HP Quality Center (QC).

Environment: Selenium WebDriver/Grid, Maven, TestNG, Java, Web Services, SOAPUI, Eclipse IDE, Appium, Log4j, Apache POI, Jenkins, SQL, TFS, HP Quality Center, Chrome, IE, Windows, Linux.

Senior Automation Tester

Confidential, Austin, TX

Responsibilities:

• Performed agile testing, review the stories and participated in Daily Scrum, Iteration Planning and Release Planning meeting and used Rally Tool.
• Experienced in working with Scaled Agile Framework (SAFe) to help the businesses address the challenges of development by delivering the enterprise class software and systems in shortest lead time.
• Involved in the design and development of test plan from the Business and Functional requirements which includes test objectives, test strategies, test environments etc.
• Performed Data Driven Testing using Selenium WebDriver, TestNG functions and JDBC Connections that returns the data from scripts using property and XML files.
• Contributed in creating test cases for Automation Framework with GUI that uses Java, Selenium WebDriver and TestNG, on modules like online login, valid username and password, transactions.
• Configured Selenium WebDriver, TestNG and Maven tool and created Selenium automation scripts in Java.
• Used Cucumber for the regression testing and Functional Testing with Selenium as the primary tool for the Test Scenarios, Test Cases and Test conditions identified.
• Extensively used DataStage to perform Administrative tasks (clear log, locks) schedule and monitor the jobs.
• Used Apache POI to retrieve test data from Excel files.
• Integrated the test suites to Jenkins to execute them automatically after every successful deployment. Jenkins Continuous Integration server is used to run these automated test suites.
• Performed API Testing using SOAP UI Tool. Expertise in System Integration Testing and Grey Box Testing approaches.
• Involved in developing the automation scripts for Mobile Native Applications (IOS, Android) using Appium Java.
• Experienced in writing the Test Scripts using JavaScript, AJAX calls based on the Web Application Service.
• Prepared user documentation with screenshots for UAT (User Acceptance Testing).
• Involved in SOAP & REST based web services testing using SOAP UI testing tool.
• Performed Backend testing and validated the Data by writing and executing SQL queries to validate the data is populated in appropriate tables and verify the correctness manually with the front-end values. Also performed data validation testing by writing the SQL queries.
• Used JIRA as the test management tool for writing the user stories according to the business requirements and execute them with JIRA X-RAY.
• Used ANT/TestNG to build and run the Selenium WebDriver automation framework. Once the script completes, framework is used to send the automated reports over email.
• Performed Back-end testing by writing the SQL Queries with Join commands.
• Experienced in using GIT for source control of the test automation scripts.
• Co-ordinate with Developers, users and various members of the team daily to discuss and resolve defects as well as their priorities.
• Prepared status summary reports with information about the executed, passed and failed Test Cases and involved in weekly testing and task review meetings.

Environment: Selenium WebDriver, Cucumber, Java, Eclipse, TestNG, Maven, SOAPUI, Jenkins, Firebug, Firepath, Xpath, HTML, CSS, Agile, SQL, SQL Server, Linux and Windows.

Senior Automation Test Engineer

Confidential, San Antonio, TX

Responsibilities:

• Involved in understanding and reviewing the requirements, creating the use cases by documenting all the requirements with each use case number and link the test cases with requirements.
• Followed Agile methodology such as Scaled Agile Framework SAFe was part of sprint planning and attended daily stand up meetings.
• Integrated Automation Scripts (Selenium WebDriver API) in Continuous Integration tools (Jenkins) for batch process run of the Script.
• Contributed in Test Planning by writing the Test Scenarios, and other various quality-tracking docs.
• Used TestNG Annotations in Selenium WebDriver in Python and executed a batch of tests as testing suite.
• Performed Integration Testing, Black Box Testing, White Box, Sanity, Smoke Testing and Product Testing.
• Used automated scripts like JavaScript and performed functionality and regression testing during the various phases of the application development using TestNG framework.
• Using Selenium WebDriver API’s for writing the Junit test suites and test cases for testing the functionality with the Selenium Server.
• Created Requirement Traceability Matrix with certain changes in HP Quality Center.
• Implemented properties files to read the configurations and XPath of the elements in the application for better readability of the code.
• Used JIRA for Bug Tracking, Bug Fixing and Bug Reporting.
• Used Maven, SVN, Selenium RC, Java and Selenium Grid for nightly automation scripts.
• Performed various Cross Browser and Parallel testing on different platforms using Selenium Grid. Executed the test cases using TestNG parameters, data providers, groups and parallel test suites.
• Used JavaScript with AJAX calls to run the web services of an application with a strong understanding of CSS, HTML.
• Logged and tracked to verify the resolutions of software and its specification defects. Performed testing on Web Services using WSDL and SOAPUI to check the communication between different services.
• Found hidden elements using Xpath, CSS and Window classes.
• Writing Test Hive queries to test development algorithms in Hadoop cluster
• Developed SQL queries to test the data after executing the transactions like upload processing and check processing in the Batches.
• Execution of cluster batch jobs & Hadoop workflows to generate test data in Hive & HBase tables
• Created synchronization points in the application to deal with the timing problems.
• Analyzed the user stories based on detail acceptance criteria for the corresponding Sprint.
• Developed Automation Scripts, Execution and Analysis Test Results using a Hybrid Framework Selenium.

Environment: Selenium RC, WebDriver, Grid, Quality Center, GitHub, Maven, Windows, Agile Methodology, MS Office Tools, Java, Oracle, SQL, Hadoop, Hive, HBase, HTML, XML, UNIX, Xpath, SOAP UI, WSDL, JIRA.

Automation Tester

Confidential, Irvine, CA

Responsibilities:

• Participated in program walkthroughs to understand the User Requirements & have analyzed the Business Requirements Document.
• Intensively participated in the Health Connect Testing with various applications including specialties and with Claims intake track of the Project.
• Created the test strategy document that defines the test environment, phase of testing, entrance and exit criteria into divergent phases of testing and resources required to conduct the effort.
• Developed the Selenium Test Scripts for identifying the test scripts for identified test cases by using Data Driven, Keyboard Driven and Hybrid Framework.
• Setup the automation framework using Selenium Grid to run the test cases in multiple browsers and platforms.
• Created 837P and 837I claims in KPHC Resolute module through IP and OP encounters.
• Involved in preparing the Test plan based on BRD and User Stories.
• Handled special mouse events and selected the options from the drop-down menu using Selenium Actions Builder, mouse hover and synchronizations.
• Designed Test Suite, Test Cases and Test Scenarios for functional modules. Implemented Page Object Model (POM) by creating objects for each page.
• Developed Test Scripts, Test Data as per the business requirements requested by the user and automated them using Selenium and Java.
• Automated the test cases written to perform Regression Testing using Java, Selenium WebDriver 2.0 and Eclipse IDE by integrating TestNG.
• Used ANT for building the WebDriver project by integrating it with Continuous Integration tools Jenkins for running the tests automatically.
• Implemented properties files to read configurations and XPath of elements in the application for better readability of the code.
• Used Bugzilla to document the issues found during the automation process.
• Written and executed SQL queries and Joins, Groups by Clause, having clause etc. to validate data.
• Along with front-end validation performed the back-end log analysis in UNIX environments to make sure the interfaces yield the correct response to the requests.

Environment: Selenium Grid, WebDriver, 2.0, Java, SQL, Eclipse, UNIX, ANT, TestNG, Xpath, Jenkins, Bugzilla, Web Services.

Selenium QA Tester

Confidential, Watertown, MA

Responsibilities:

• Interacted with the Client, Product Owner and Development Team to understand the User Stories and Acceptance Criteria and gathered the Functional and Non-functional requirements for project release.
• Involved in the Requirements Gathering phase and reviewed the Business Requirement Specification (BRS), documentation and participated in the preparation of Test Cases based on Product Backlogs.
• Developing Test plans and Test Scripts by using the Data Driven Framework.
• Implemented automation scripts for Cucumber BDD framework to test the key Business Processes Scenarios.
• Performed Web Services testing using SOAP UI Tool.
• Test execution in SIT and UAT environments and managing the test scripts and test results in JIRA.
• Generating Test and Defect metrics for client manager and release management.
• Developed new Automation Test cases using Selenium WebDriver and TestNG.
• Arrange meetings and work with Dev team and Business Analysts for defect triage.
• Performed functional and regression testing using Selenium 2.0 with Java sing Page Object Model in Junit/TestNG framework and using Continuous Integration Jenkins to ensure the web application is automatically tested with the test scripts.
• Used HP ALM for test case management, defect tracking and defect reporting.
• Created flow charts based on BRD to meet the Business Requirements.
• Involved in four successful releases of the applications and played a critical role in each success.
• Allocating the work among the testing team both at onsite and offshore and responsible for handling the issues at offshore.
• Performed Database verifications using SQL queries to validate the test data.

Environment: Selenium, WebDriver, TestNG, Java, ALM, Cucumber, SOAP UI, JIRA, SQL, Windows, Firebug, Web Services.

QA Tester

Confidential

Responsibilities:

• Actively involved in writing test plans, test scenarios and test matrix.
• Involved in both Waterfall and Agile methodologies.
• Designed and executed test plan based on the functional requirements.
• Prepared and executed the test cases manually for different modules according to the Technical Specification, and Functional Design with all Use Case or User Story documents.
• Contributed in creating test cases for Automation Framework with GUI that uses Java, Selenium WebDriver and TestNG, on modules like online login, valid username and password, transactions.
• Configured Selenium WebDriver and Maven tool and created Selenium automation scripts.
• Identified the test cases to be automated and performed the data driven testing and GUI Check points using QTP enhanced the overall functionality of the application.
• Developed an enhanced Automated Test Scripts for Functional and Regression Testing.
• Reviewed Test Data, Test execution reports and sent the scripts for UAT.
• Extensively used SQL queries to check the data flow through the Front-end and Back-end to extract the data from the database.
• Tested functionality, GUI and system requirements of the application under test.
• Conducted data integrity testing using SQL commands.

Environment: QTP- Quick Test Professional, Firebug, Java/J2EE, Junit, JavaScript, jQuery, HTML, XML.

QA Test Engineer

Confidential

Responsibilities:

• Involved in Planning, Designing, Developing and Executing the Test Scenarios for Manual and Automated Test cases.
• Reviewed System Requirement Specification, Technical Specifications and functional design documents to achieve better understanding of the project.
• Developed automation test scripts using VB Script in QTP.
• Assessed and analyzed user stories by participating in the Sprint planning sessions, Review Sessions & Scrum Meetings and developed Test Scenarios, Test cases, Test data, Test procedures, Test reports.
• Tested user interface and navigation controls of the application using Quick Test Pro.
• Worked with data types, variable and variable declaration, naming convention, constants and assigning values to the variables in VB Scripting under QTP Testing tool.
• Reported bugs through Bugzilla and performing Regression Testing to resolve the Bug fixes.
• Involved in creating the Requirement Traceability Matrix (RTM) to analyze the changes and identify the areas of application to identify the change in application and provide high-level view of the Test cases scenario to the client.
• Attended the project review meetings, daily status calls and walkthroughs with the project managers and leads.

Environment: Junit, Eclipse, VB Script, QTP, RTM, Bugzilla, Quality Center, ANT.