• Review requirement and software specification documents. Identify conflicts, errors in the documentation and provide feedback to business analysts.• Prepare test plans, cases and set up a testing environment, acceptance testing, regression testing for Quality assurance.• Designed and implemented scalable, secure cloud architecture based on Amazon Web Services.• Implemented Page Objects, Data-Driven, Keyword Driven, Hybrid automation frameworks using Selenium.• Also responsible for converting automation scripts to the new framework using Selenium WebDriver, Java and TestNG/Junit.• Worked with AWS cloud machines to setup selenium GRID and also Jenkins server on HUB machine.• Performed data-driven testing by using JDBC and Groovy script as a data source in SOAP UI and configured SQL queries to fetch data from the Oracle database.• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to the staging area and finally transfer into data marts and performed an action in XML.• Used Jenkins as a continuous integration server to run automated test suites.• Automated web services and API’s using UFT.• Created test frameworks based on APPIUM, Cucumber, Ruby, and JavaScript.• Created test planning and participated in execution for API testing using POSTMAN tool.• Perform Data Analysis and mapping, Data management/data integration and co-ordination with Dev team.• Perform Smoke testing, Sanity testing, Functional testing, Cross-Browser testing, Cross-Device testing,Regression testing, Integration testing, Backend validation testing and End to end testing.• Raise defects and perform tracking using Rally.• Involved in the production support team for planning cycle after production implementation. Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.

Maintained Automated Scripts and troubleshoot their issues for each site release, feature and smallenhancement project.• Analyzed the Business Requirements Document (BRD), developed Test cases and Test scripts for theapplication under test.• Performed functional testing of SOAP & RESTful Web Services using SOAPUI Tool Used Java/Junit to runCucumber feature and scenarios and generating report daily basis.• Reported Defects in Defect tracking tool of Quality Center (Mercury & HP) by assigning Defects todevelopments that are encountered during testing phase based on application teams.• Participate in Sprint Planning and daily standup meetings as part of the agile team attended groomingsessions and Retrospectives.• Adept in developing Stored Procedures, User-defined Functions (UDFs), Triggers, Indexes, Indexed views,Transactions, and queries using T-SQL.• Created SSIS packages to import data from MS Access, Excel to SQL.• Conducted Bug Review meetings by reviewing and discussing all defects by their business severity and workedactively development and business team to perform the root cause analysis in order to find the resolution.• Performed QA role for agile development teams working on internal web applications.• Used SQL to perform data integrity test, validate stored procedures and functions.• Developed and executed test scripts using WinRunner.• Interacted with the management regarding Time Lines and participated in Bug review meetings.