SUMMARY

• Over 8 years of experience in the Software Testing with diversified skills in Manual and automated testing of Client/Server and Web - centric applications on UNIX and Windows, seeking for a Software Design Engineer in Test (SDET)/Automation Tester/ETL Tester position.
• Good working knowledge of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC) and Quality Assurance Process and Methodologies and worked on Finance, Insurance and HealthCare & Retail domains.
• Experienced in Waterfall, V-model, and Agile with SCRUM lifecycles.
• Good Understanding on calculating capacity, analyzing User Stories and acceptance criteria in agile methodology.
• Experience in designing Test Plans, Test case design, Test script development, Test environment setup, Test data setup, Defect management, Test log, summary reports and Traceability Matrix.
• Extensive experience in Sanity testing, Feature testing, Functional testing, Integration testing, System testing, Compatibility testing, Retesting, regression testing, performance testing, load testing, stress testing, User acceptance testing in mobile and web based applications.
• Experience of working extensively in Agile Testing Environment (Agile /scrum model) and good expertise in attending Scrum calls, Sprint Planning, Reviews and retrospective meetings.
• Proven ability in designing and creating automation frameworks using Java, Selenium WebDriver, IDE, RC, Selenium Grid, Junit, TestNG, Maven, ANT,
• Expertise in using continuous integration tools like Hudson, Jenkins.
• Experience in working with Test Driven development (TDD/BDD) by writing gherkins language in cucumber tool.
• Experience in creating page objects by using Page Object Model, developing reusable library functions in java.
• Experience of Creating, Modifying and Maintaining new and existing Automation Framework Models (Hybrid, Keyword and Data Driven Frameworks).
• Experience in working with Unit Test Frameworks like TestNG, JUnit. Used Apache POI to read data from external sources like Excel Spread Sheets to feed locators into the test script and to configure the Test Framework. Experienced using various TestNG Annotations like BeforeSuite, AfterSuite, AfterMethod, AfterTest and configured Parallel Processing using TestNG xml.
• Work experience in integrating Automation scripts (Selenium WebDriver API) on Continuous Integration tools like Jenkins for nightly batch run of the Script.
• Excellent knowledge in Core JAVA, JDBC and Web Services.
• Worked with eclipse, Log 4J, ANT and Maven.
• Experience in using version control software like SVN, Git/Git Hub.
• Automated Mobile application using Selenium Webdriver and Appium.
• Experienced using Web-debugging tool like FirePath and Firebug for finding elements locator.
• Experience in testing Web Services-SOA architecture, RPCs, XML transactions, SOAP, HTTP, WSDL, and REST using various industry standard tools like SOAP UI.
• Experienced in Defect Management Tracking, Establishing Test Standards, Guidelines, Procedures, Test Execution, Documenting and Analyzing Test Results. Depth knowledge of Defect management tools and Bug Reporting Tools including Rally, Jira and Quality Center (ALM).
• Experience programming in object oriented programing using Java, JavaScript
• Experience writing good quality object-oriented code for testing purposes
• Expertise in HTML, CSS, HTTP, JavaScript, XML, AJAX, Angular and Jquery.
• Experienced in writing SQL verification scripts to test the result of deployment for correct business logic for Back-end testing.
• Extensive experience in Extraction, Transformation and Loading of data from multiple sources into data staging, warehouse and other system integration projects.
• Good Expertise on ETL testing using Informatica and validating the Source files, Staging, transformations and Target tables.
• Performed Count Validation, Dimensional Analysis, Statistical Analysis and Data Quality Validation in Data Migration.
• Extensive SQL querying on Staging, Data warehouse and DataMarts.
• Good experience in BI tools like Cognos and SAP Business Objects for testing reports and validated Universe dimensions
• Good analytical and communication skills and ability to work independently with minimal supervision and perform as part of a team.
• Highly motivated team player with analytical, organizational and technical skills, unique ability to adapt quickly to challenges and changing environment.
• Proficient in the tasks of bug tracking and reporting using Quality Center/Test Director, JIRA and Bugzilla.
• Good analytical and communication skills and ability to work independently with minimal supervision and also perform as part of a team.
• Highly motivated team player with analytical, organizational and technical skills, unique ability to adapt quickly to challenges and changing environment.
• Hands on experience for defect tracking & defect management from the discovery of defects, submitting the defects with elaboration so that developers are able to recreate & provide the fix faster, retesting of the fixed defects & tracking the defect status in defect tracking tools till it is closed.

TECHNICAL SKILLS

Methodologies: Agile (Scrum),Waterfall,SDLC and STLC

Software Testing: Functional, Database, Security, Performance, Desktop Applications and Web based UI Testing, Windows and Web Services.

Technical Leadership: Estimations, Project Planning and Project Scheduling, Project Execution, Task Assignment, Tracking and Status Reporting, Risk tracking and Management, Team Coordination and working with various Cross Functional Teams, Impact Analysis, Change Management, Agile, Waterfall and Prototype Models

Testing tools: Selenium (Selenium IDE, Selenium RC, Selenium Web Driver),Cucumber,TestNG,JUnit,UFT/QTP, APPIUM, SOAPUI and Gherkin

Test Build & Integration Tools: Maven, ANT, SVN, GIT, Jenkins, and TFS.

Programming Languages: JAVA, C,C++

Databases: MYSQL, Oracle, SQL Server.

Testing Frameworks: Data-Driven, Keyword-Driven, Hybrid, Test Modularity, Business Process Testing (BPT), Behavior Driven Development (BDD) and Page Object Model.

Other tools: Jira, Rally, Bugzilla, Quality Center, Auto IT, Eclipse, FireBug and FirePath.

Mobile Test Frameworks and services: Appium, AWS Device Farm

Automation tools: Cucumber, JUnit, TestNG

Web serivces: SOAP and RESTful webservices testing

Browsers: Internet Explorer, Mozilla Firefox, Google Chrome, Safari, Opera

Markup Languages: HTML,CSS, XML, XPath, CSS Selector

Operating Systems: UNIX, WINDOWS,Linux, OS Yosemite

MS Office Tools: Outlook, MS Word, MS Excel, MS PowerPoint, MS Access

PROFESSIONAL EXPERIENCE

QA Automation Test Engineer

Confidential, NY

Responsibilities:

• Testing of new features by creating test specifications, test cases, and working closely with development and business teams.
• Performed Functional Testing, Regression Testing, User Acceptance Testing (UAT), and Integration Testing using Black Box Testing methodologies.
• Reviewed and updated Requirements Traceability Matrices (RTM) that satisfy all required project's test conditions.
• Define, develop, and execute automation test scripts using Java that leverage black and white box testing across functional.
• Implemented Test driven development (TDD/BDD) framework using cucumber tool with Gherkin Language
• Created Features in cucumber and started automating the User stories before the development ends
• Tested compatibility of application for dynamic and static content under various cross browsers using HTML IDs and XPath in Selenium.
• Developed automated scripts using Selenium WebDriver, Java, Junit in Eclipse IDE to perform functional and regression testing for web based applications.
• Automated Database validations using open source API like Apache poi and used jxl and poi library for fetching the data from Excel
• Written automated scripts with XPath to identify web elements such that most of the browsers can be used.
• Implemented Maven Build tool by configuring the POM file with all required Jars and maintained the POM file
• Implemented well formatted Logs by using API’s Like Log4j and Reports using TestNG, ANT etc.
• Executed scripts on multiple browsers simultaneously using Selenium Grid.
• Worked closely with the product owner and scrum master to design testing Cucumber
• Implemented Page Object Model (POM) by creating objects for each page.
• Automated internal Mobile application module using Appium and Webdriver by setting the Emulator and tested on various browsers
• Tested REST and SOAP Services by using SOAP UI tools and Rest Clients and validated the responses against the database.
• Very good with Angular JS as filters, root scope, custom activities, single page applications and templates.
• Automated Angular JS application module using protractor by writing java scripts and used jasmine as unit testing framework.
• Responsible for preparation of Test cycle/progress reports, analysis of defect metrics& implement improvement actions for next iterations.
• Involved in Defect Management, Defect Review and Defect Status Reporting.
• Identifying, logging, tracking and escalating bugs using JIRA/Rally.
• Performed backend testing using SQL queries to retrieve and verify information in the database.
• Developed SQL queries to simulate data validation reports and to stage test data for ongoing testing.
• Used SQL to test Data Warehousing and Data Cleansing for the arrangement of customer data.
• Tested several Informatica mappings to validate the business conditions and tested the source and target databases for conformance to specifications
• Writing complex SQL queries for data validation for verifying the ETL Mapping Rules
• Maintained QA/Test environments and assisted in build and deploy activities.
• Communicate testing status to QA lead, project managers, and teams who are involved in User Acceptance Testing.
• Interacted with the development team to validate the scope of fixing the bugs.

Environment: Java, Selenium Web driver, TestNG, Maven, Appium, Apache POI, Eclipse, XPATH, PL/SQL, HTML, Protractor, Angular JS, SQL, SVN, Jenkins, UNIX, Rally, Informatica.

Sr. Automation Tester

Confidential, NJ

Responsibilities:

• Analyzed the system requirements and developed detailed test plans and test cases and provided the documentation. Collaborated with product management teams in an agile environment to develop a comprehensive set of tests for web-based applications.
• Studied and analyzed the Functional Requirements Specifications and System Design Specifications and interacted with developers for changes in requirements if any.
• Developing Test plan of the application as per technical specifications.
• Involved in writing Unit and Regression Test cases for the Product.
• Involved in setting up the automation framework using Selenium Web Driver, TestNG.
• Used XPath and DOM to work with dynamic and static objects in Selenium.
• Configured Selenium WebDriver, TestNG and created selenium automation scripts in java.
• Developed Automation framework both Data driven and Hybrid using Selenium WebDriver in Java and performing unit testing by using TestNG.
• Creating and maintaining various databases usingSQLServer 2005/2000.
• Prepared manual test cases for service appointment creation, modification and deletion
• Involved in scripting the Test cases for ACH payments, ACH Templates.
• Created automated test scripts for validating the nightly product builds and regression testing.
• Maintained Defects using Defect Tracking System in Quality Center.
• Participated in various meetings and discussed Enhancement and Modification Request issues.
• Performed all test assignments to ensure the application meets business requirements and client expectations.
• Interacted with developers & various members of project team to discuss and resolve defects and to determine their priorities.
• Summarize test results in formula test analysis reports according to the documentation standards.3

Environment: Java, J2EE, JSF, Selenium WebDriver, TestNG, SQL, Quality Center, Jenkins, SVN, Windows XP, MS Access and MS Excel.

Automation Tester

Confidential, Bentonville AR

Responsibilities:

• Produce test documentation such as Test Plan and worked closely with QA project manager and monitored team progress.
• Reviewed the requirements and use case diagrams to write Test Cases/ Test plan that would test various scenarios.
• Used Keyword driven, Page Object Model, Data Driven using CSV, CSS Selectors as a part of Framework.
• Helped Automation engineers in writing the code and solved technical issues
• Experience in parallel testing using SeleniumWebDriver.
• Worked on Agile (Scrum) project methodology.
• Perform Selenium automation usingSelenium Web Driver and Selenium IDE
• Test the web modules flow and improve the script performance using Selenium find elements.
• Tested Service Oriented Architecture application using Soap UI.
• Performed Integration and Regression tests to check compatibility of new functionality with the existing functionalities of the application.
• Extensively used SeleniumAPIs such as Take Screenshot for Capturing Failed test cases, Select for selecting multiple values from list, Action for various key and mouse event, By with different Locators(Xpath, CSS, id, Link text).
• Wrote SQL queries extensively, queried database and generated test reports.
• Performed Defect Tracking & Management in Rally.
• Involved in Unit Testing the code and provided the feedback to the developers

Environment: JIRA, Selenium WebDriver, DB2, Windows XP, MS Access and MS Excel, Query

Software design Engineer in Test (SDET)

Confidential, NY

Responsibilities:

• Actively involved with SCRUM and sprint meetings, managing product backlog, removing obstacles to progress, re-allocating resources where necessary, prioritizing and review milestones and s.
• Configured Selenium WebDriver, Junit, Ant tool and created selenium automation scripts in java prior to agile release.
• Responsible for implementation of Hybrid Test Automation Framework build using Selenium WebDriver, Junit and Ant technologies under Java platform utilizing industry leading harness design patterns and approaches.
• Created and executed the test scripts with Java, Selenium WebDriver, and Junit.
• Worked on distributed test automation execution on different environment as part of Continuous Integration Process using Selenium Grid and Jenkins.
• Used automated scripts and performed functionality testing during the various phases of the application development using Selenium.
• Extensively used Selenium IDE to record, playback and debug individual test cases
• Implemented Regression and Smoke tests execution as separate step of deployment process by using WebDriver.
• Performed Data-Driven testing by developing Java based library to read test data from Excel & Properties files.
• Extensively used Selenium (XPath and CSS locators) to test the web application.
• Used SOAP UI tool to test SOA based architecture application to test SOAP services and REST API.
• Used Page Object Model, UI Mapping, Selenium Manager, Data Driven using CSV, CSS Selectors as a part of Framework.
• Performed SOA / web services testing using SoapUI; wrote adaptors to test / invoke web services.
• Reviewed database test cases according to assigned Requirements to validate reports by retrieving data with complex SQL queries from oracle database.
• Defect Triaging and Release sign off for Continuous Delivery cycles.
• Writing complex SQL queries and update transaction and properties for accounts on stages for UI testing, Integration testing with different data points etc.
• Used Git/GitHub for code repositories and Ant for the dependencies.
• Participated in daily, weekly meetings and technical reviews. Prepared reports showing the testing efforts.

Environment: Selenium Web Driver, Junit, Ant, Jenkins, Soap UI, Rest, Cucumber, HTML, XML, XPath, CSS, Firebug, GIT,SQL,Oracle,Windows.

Sr.QA Analyst/ETL Tester

Confidential, DE

Responsibilities:

• Functional and Technical understanding of the insurance domain to validate the data obtained.
• Updated mapping tables related to assigned functional areas as directed by the Business Analysts
• Imported and Exported data from different sources using Oracle and SQL Server tools such as SQL*Loader, DTS and SSIS
• Responsible for fixing hundreds of critical defects addressed during data conversion.
• Developed stored procedures to validate the data obtained.
• Developed Packages, procedures, functions and triggers in the database to explicitly handle various feeds.
• Created and modified tables, views and indexes, PL/SQL stored procedures, functions and triggers according to business requirement
• Created business reports by joining multiple tables from multiples database using complex SQL queries
• Worked with SQL Queries using joins to facilitate the use of huge tables for processing several records in the database.
• Responsible for debugging, troubleshooting, and tuning PL/SQL stored procedures and functions and Complex SQL.
• Executed SQL conversion pre-validation and post-validation scripts to avoid data loss
• Developed reports using Oracle reports 9i for the summary of customer report.
• Developed user documentation for all the application modules.
• Created Test script for Prodfix, UAT and Production and developed Unit Test Plans Documentation
• Availability on apart-time basis to support Oracle MDM engagements at all stages of the project lifecycle - from proposal through to completion
• Supporting design and construction of MDM integration to other systems/applications
• Participated in a weekly meeting with Managers and Project Lead to discuss issues and the progress of ongoing projects

Environment: Oracle 10g/9i, SQL, SSIS, SSRS, SQL*Loader, UNIX, PL/SQL developer, SQL Server 2008 R2, SQL*Plus, iSQL*PLUS, SQL Developer, SQL Query Analyzer, DTS, IBM - Cognos, TOAD 9.5, MS Office, XML, Windows Server 2003, Mercury Quality Center 9.2

Java Developer/Test Engineer

Confidential

Responsibilities:

• Developed web based application using JSP, HTML, AJAX, JavaScript.
• Used Eclipse IDE for Java coding.
• Implemented the MVC model for the web application using Struts framework.
• Involved in the front-end coding using Struts concepts like Action classes, Tiles framework, DynaActionForm Beans.
• Used Struts Tiles to design the layout of the pages.
• Client-side validations are performed by the JavaScript developed in the Struts framework.
• Involved in programming several JSP tags using Struts Tag lib component, to modularize and stream line web page.
• Created XML files to enable users to access the system.
• Created the stored procedures for inserting and updating the data in the database.
• Developed and implemented the business logic component in middle tier using JDBC andEJBframework including stateless session classes and Entity bean classes.
• Tested and debugged rigorously using JUnit.
• Built the application using ANT.
• Deployed the application on WebLogic Server.
• Involved in the performance tuning sessions and suggested few performance improvement techniques such as caching.
• Used SQL queries to perform the back-end testing on Oracle.
• Conducted regression testing after every new build.
• Worked with users on User Acceptance Testing.
• Involved in tracking and reporting defects using QC and was also responsible for communicating the status to the development team.
• Used HP Quality Center to report defects and test results.

Environment: Java, JDK, EJB, JSP, Struts, Eclipse, Web Logic, Junit, Firebug, SQL, QTP, Junit, Firebug, SQL, HP Quality Center, Oracle10g and Windows.