PROFESSIONAL SUMMARY:

• Overall 6 years of experience in Information & Technilogy including 5+ years of expereince as a Quality Assurance Professional working in all phases of project development a nd test life cycle; Developing Test Strategy, Test Cases, Test Plans and Automation Test scripts using Selenium and Java. Diversified experience in Automation and Manual testing serving various domains such as Banking, Finance, eCommerce & Retail.
• 2 years of experience working as a SQL Server developer with expertise in SQL Server Import Export, Bulk Insert & BCP, extracting & transforming data using Data Transformation Services (DTS) & SQL Server Integration Services (SSIS) in MS SQL Server 2005/2008/2012.
• Good working knowledge in SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS)
• Experience in different phases of Software Testing and Software Development Life Cycle (SDLC) including Agile Methodology/SCRUM, Waterfall and TDD.
• Good Experience in automating API’S testing using HttpClient. Also used plugins like Postman, Advanced REST Client
• Expereinced working on Mobile testing including installing and testing apps like Confidential Wallet, Confidential LoanView.
• Experience in working with open source tools such as Selenium (Selenium IDE, Selenium RC, Selenium Web Driver, and Selenium Grid), SoapUI, Cucumber, JUnit, JIRA and Eclipse.
• Designed and Implemented different automation frameworks like Page Object Model Framework, Test NG Framework, Keyword Driven Framework, Data Driven Framework, and Hybrid Framework on a number of projects.
• Expereinced working on various Mobile Operating Systems including iOs, Android. Worked in
• Strong experience in SQL Server 2012/2008R2/2008/2005 in a 24x7 environment.
• Experienced in handling Selenium for List Box, Drop Down Menu, Multiple Elements, Auto Suggestions, Mouse Actions, Frames, Synchronization and all types of Pop Ups.
• Performed automation testing of Ajax based webpages with dynamic Ids and Synchronization using Selenium Actions.
• Good Knowledge in implementing encryption using third party certificates.
• Expertise in writing SQL queries & retrieve data from Databases.
• Experienced in writing Selenium WebDriver automation scripts in Java for cross browsing testing using Selenium TestNG parameters and groups.
• Conversant in using Maven build tools to manage framework dependency jar files and customizing Selenium API to suit in - testing environment.
• Hands-on automation Regression testing and system testing using Maven build tools in Selenium.
• Proficient in developing Test scenarios, Test cases, Test data, Test procedures, Test reports and documenting Manual and Automation Tests.
• Performed application framework using excel spreadsheets and processed the spread sheets using Apache POI.
• Expertise in using finder mechanisms like CSS, XPath expression, HTML id and name to find the Web Elements. Experience in using Selenium Web driver, Eclipse TestNG test frameworks in creating test scripts, test suites and HTML reports.
• Worked extensively in testing Soap and Restful web services using SoapUI and validated the response using assertions.
• Experienced in Parallel Execution of Multiple Tests at a time in different environments.
• Experience in Web based testing including GUI Testing, Regression Testing, Integration Testing, System Testing, Performance Testing, Stress Testing, Functional Testing and Unit Testing.
• Selenium Screenshots are used for bug reporting, analysis and exception debugging.
• Experience in Black Box Testing and White Box Testing Techniques - Boundary Value Analysis and Equivalence Portioning.
• Performed back-end testing by executing complex SQL queries on Oracle and MS SQL Server.
• Expertise in Java and OOPS concepts required for Selenium frameworks.
• Experienced in using Test Management tools such as Rally, JIRA and Bugzilla bug reporting tools to track test progress, execution and deliverables.
• Hands on experience in using build and project management tolls like Ant, MAVEN and Configuration management tools like SVN, GIT.
• Performed Continuous integration automation using Jenkins.
• Performed duties as an individual contributor and can manage multiple projects and tasks simultaneously.
• Highly motivated, self-starter able to work independently and collaboratively within a diverse technical team.
• Worked in creation, preparation, and conduct of quality assurance reviews and contributed to the development and execution of test plans and test scripts.
• Responsible for developing, maintaining and compliance of quality assurance testing strategies, policies, procedures, standards, templates and governance.
• Hands on experience in system security, managing user logins, granting access roles & creating service account.
• Experience in Database Maintenance plans, scheduling of jobs, alerts & notifications using Database Mail.
• Working experience with third party tools like spot light & fog light, Idera for monitoring & lite speed for backing up large databases.
• Expertise in maintaining project specific processes & work ethics.
• Ability & enthusiasm to learn new tools/technologies quickly.
• Energetic & self-motivated Team Player with excellent verbal & written communication skills & self initiative & ability to think outside the box.
• Good interpersonal skills & committed for result oriented & hard working with a quest & zeal to learn new technologies & undertake challenging tasks.

TECHNICAL SKILLS:

Automation Tools/APIs: Selenium IDE, Selenium Web Driver, Selenium RC, Selenium Grid, Cucumber, TestNG, JUnit, Rally, Auto It and, Log4j, SoapUI.

Artifacts: Test Plan, Test Case, Test Data, RTM, Test Summary &, Bug report

Bug Management Tools: Quality Center, JIRA, ALM, Version One, Rally

Database/Database tools: Oracle, SQL Server, MySQL, Toad, SQL

Development methodology: Agile/ Scrum, Waterfall, Jenkins, Hudson, SVN, Cucumber

Framework: Keyword Driven, Data Driven, Hybrid Testing Frame work, Page Object Model.

Mobile testing: Appium

Programming Languages: Java, Java Script, HTML, XPath, CSS, Soap, WSDL, Restful, PL/SQL, Excel Macros

Operating Systems/Tools: Windows 07. XP, UNIX. VMware

PROFESSIONAL EXPEREINCE:

Confidential, Atlanta, GA

Automation Test Engineer

Responsibilities:

• Actively involved with AGILE-SCRUM and sprint meetings, managing product backlog, removing obstacles to progress, re-allocating resources where necessary, prioritizing and review milestones and accomplishments.
• Participated in daily, weekly meetings and technical reviews. Prepared reports showing the testing efforts.
• Configured Selenium WebDriver, TestNG, Maven tool and created Selenium automation scripts in java using TestNG prior to agile release.
• Extensively worked on Selenium web Driver with the preferred Languages Java.
• Responsible for implementation of Hybrid Test Automation Framework build using Selenium WebDriver, TestNG and Maven technologies under Java platform.
• Testing the mobile application Confidential LoanView by installing it on different devices including Android & iOs.
• Automated Test cases in TDD (Test Driven Development) and BDD (Behavior Driven Development)
• Involved in creation of automation framework in Selenium WebDriver using Behavior Driven approach like Cucumber.
• Tested application on various LTE, CDMA, Blackberry and iPhones.
• Created and executed the test scripts with Java, Selenium WebDriver, and TestNG.
• Used WSDL to setup project in SOAPUI, compiled the WSDL using SOAPUI, Created multiple Test Cases to test scenarios.
• 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, using Selenium WebDriver provided more flexibility in automating 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 & 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 SOAP UI, 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.
• Functional and Cross Browser testing of Defined Browser Stack of the site experience 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.

Environment: Java, Selenium WebDriver, TestNG, Maven, Jenkins, Soap UI, Rest, Cucumber, HTML, XML, XPath, Firebug, SQL, Oracle, Windows

Confidential, Seattle WA

Automation Tester

Responsibilities:

• Analysed business requirements & participated in requirement sessions to understand & identify missing, ambiguous, inconsistent requirements
• Extensively involved in all stages of testing life cycle, Test Driven Development (TDD) methodologies, Software Development Life cycle (SDLC) using Agile methodology.
• Installed and tested client applications on all the Android smart Phones and Tablets
• Worked on DMV & dynamic management functions for finding out long running queries.
• Automated test scripts for GUI and functionality for mobile applications
• Implemented Replication - Transactional & Snapshot methods.
• Tested mobile applications including Confidential Wallet for payments processing on various android versions
• Helped identify key functional gaps & offered valuable suggestions.
• Work proactively with members of an Agile Software Development and Quality Assurance team to find and fix defects in our product architecture.
• Testing and maintenance of mobile sites on Android and IOS in all phases, developer’s environment through Alpha & Beta, UAT.
• Developed Selenium Web Driver automation scripts for checkout process.
• Automated Smoke & Functional test cases using Selenium Webdriver & Java (Eclipse IDE).
• Proactive participant in weekly AGILE team meetings and updated team lead and manager on status of testing.
• Implemented Hybrid Framework (Data Driven, and Keyword Driven Frameworks) using Selenium WebDriver.
• Performed Black Box and White Box testing using Selenium.
• Tested dynamic client-side JavaScript code for building web forms, page navigation & form validations.
• Generated GET/PUT/UPDATE request & response in RESTFUL web services.
• Used Firebug, Firepath Tool to identify the Object’s id, Name, XPath, link in the application.
• Created & implemented Selenium Automation Hybrid Framework.
• Manage re-architecture of Jenkins and integration with Confluence for release management and documentation assets. Re architected a Maven based system reducing build times.
• Implemented a Continuous Delivery pipeline with Jenkins and GitHub and AWS AMI’s.
• Worked and built projects in Maven.
• Involved in SOAP & REST based web services testing using Postman web services testing tool
• Parallel, Cross-Browser Testing using Selenium Grid & TestNG
• Performed Back end testing using SQL queries to validate and verify that data is uploaded correctly into the database tables.
• Used Selenium IDE to record, edit & debug test.
• Monitor MySQL Database Backup on AWS cloud S3 (CLI)
• Log Analysis, Maintaining documents of production server error log's reports
• Working in highly dynamic environment using AGILE methodology
• Used WSDL to setup project in SOAPUI, compiled the WSDL using SOAPUI, Created multiple Test Cases to test scenarios.
• Create and Manipulate shell scripts on Production server for backup on AWS
• Performed functional testing and regression testing using Selenium and JUnit.
• Worked on SQL & documenting the testing process.
• Developed Test Scripts for Automation of the web-based application in Selenium- JUnit.
• Recorded & executed Test scripts manually using Selenium Webdriver.
• Used migration tool for reviewing web pages & compared pages as a reviewer.
• Exhibited strong aptitude in implementing Quality Assurance Standards & Testing Methodologies using Use Case documents, functional specifications & requirements
• Executed the Selenium test scripts for each build for Functional & Regression Testing
• Extensively involved in Functional testing, System testing, Database testing & Compatibility testing of applications.
• Designed & generated test scenarios, test cases & test data. Successfully executed tests & created defect reports using Rally.
• Created Test Metrics & Status Reports to measure Test Executions.
• Quick Set-up execution & reporting of findings for smoke test for each Build
• Extensive experience on working with SQL & documenting the testing process.

Environment: Selenium Web driver, Angula.JS, HTML, CSS, TestNG, Agile, SOAP UI PRO, SOAP, Web Services, XML, WSDL, Rally, Jenkins, Maven, AWS, JUnit, Excel, SQL, Windows, UNIX

Confidential, Atlanta, GA

Automation Engineer

Responsibilities:

• Analyzing user requirements, functional specifications & developing test cases.
• Work with business analysts & business team to understand the functionality & identify the test requirements, responsible for content management.
• The projects followed AGILE methodology, where developer, user & tester worked together to create stories (individual features of a project), document requirements by interviews & analysis.
• Developed Selenium Web Driver automation scripts for E-commerce checkout process.
• Building Selenium framework to test an web application end to end using Selenium Web Driver
• Involved in SOAP & REST based web services testing using SOAPUIPRO Web services testing tool
• Created & implemented Selenium Automation Hybrid Framework.
• Highly Dynamic Environment with Sprint Teams using AGILE methodology
• Extensively worked with Selenium IDE, Grid and RC for Web UI testing.
• Tested the various Service Oriented Architectures (SOAs) spanning across various departments using SOAP and WSDL using SOAP UI Pro.
• Prepare test requirement documents, test strategies, test scenarios, test cases, test conditions, & test data for testing applications
• Used AGILE methodology for testing the application
• Used Firebug Tool to identify the Object’s id, Name, XPath, link in the application.
• Developed numerous queries using SQL for back end testing.
• Recorded defects & test management using JIRA.
• Performed Back end testing using SQL queries to make sure that data entered has been uploaded correctly into the database tables.
• Recorded & executed Test scripts manually using Selenium Webdriver.
• Recognizing the Object using X path
• Automating manual test cases, controlling framework from excel file, using batch execution of multiple test classes.
• Parameter zing the test data, X paths from configuration file
• Test cases estimation, Test cases creation & execution of test cases
• Used Selenium Web Driver to manage script creation for regression testing.
• Involving testing of Functionality & Integration Testing.
• Used SOAPUI for WSDL Validation. Used different Assertions for validating responses Test case management using Quality Center.
• Conducted Testing using for E-Commerce applications & generated summary reports for Transactions time, Resource monitoring & Applications health check for different kinds of user profiles.
• Parallel, Cross-Browser Testing using Selenium Grid and TestNG
• Functional testing of web based application with following types of testing - Regression Testing, Retesting, Smoke Testing, system testing.
• Performed load testing using HP Load Runner; used Virtual User Generator (VuGen) for script development, enhanced the scripts by inserting transaction points, parameterize & inserting auto/manual correlation.
• Extensively involved in Performance tuning of Web servers such as web sphere.
• Analyzed the results using Loadrunner Analysis & various monitor tools (Transaction's per second, Hits/second, & Transaction response time).
• Involved in Black Box Testing, GUI Testing, Unit Testing, Regression Testing, White Box Testing.
• Maintaining tight time schedules for High Priority Emergency Fixes testing & delivery for escalated, critical Clientele defects.
• Co-ordinate with Developers/ Business Analyst for issue resolution.
• Testing & Support while Deployment.

Environment: Selenium Web driver, TestNG, Agile, SOAP UI PRO, SOAP, Web Services, XML, WSDL, Restful Bugzilla, Quality Center, JIRA, Java, IBM WebSphere Application Server, Schema, XSD, Oracle 11g, TestNG, Excel, SQL, Windows, UNIX

Confidential, Minneapolis, MN

SQL Server Developer

Responsibilities:

• Installed MS SQL Server 2005 & 2008, upgrading with latest service packs & security patches.
• Managing Databases in multiple servers in Production, Development, Staging & Testing environments.
• Performed installation of SQL Server 2005 version on Windows 2003 servers on Enterprise systems of clustered & stand alone HP servers in enterprise Data Centers to Patch applications.
• Installed & administered 2 node cluster Active - Passive on Microsoft Windows Server 2003 R2 Enterprise Edition SP2 on SAN environment.
• Worked on SQL 2008 data Compression.
• Using Policy based management of SQL Server 2008, created & implemented some polices which reduced the incident volume to 30%.
• Worked extensively with database design team & development team for database design & implementation.
• Implemented a live data mirroring without any witness for all store databases.
• Worked on enhanced security features for Data encryption.
• Expert in implementing the DDL triggers, Created DDL triggers to prevent accidental table drop & also to restrict access for unauthorized user.
• Used Data Partitioning, File & file group backups & restore in SQL Server 2005.
• Performing Backup/Restore to/from Tape & Disk.
• Created custom log-shipping to manage Disaster Recovery & Production support restores.
• Worked in Huge Replication Environment.
• Scheduling the DBCC commands to run daily & weekly basis.
• Developed automated tasks for daily, weekly & monthly database maintenance such as database backup, database integrity verification & indexing using Control-M agent & SQL Server Agent.
• Performing DB Security, creating users, roles, & assigning permission to them.
• Used Online Indexing & online Restoring in SQL 2005.
• Used Performance Monitor/SQL Profiler to analyze long running / slow queries & tuned to optimize system application & performance.
• Worked on Maintaining & Deployment Services of Reports using SQL Server Reporting Services.
• Evaluated data storage considerations to store databases & transaction logs.
• Involved in Source Data Analysis, analyzing & designing mappings for data extraction.
• Responsible in Designing & Developing SSIS Packages to load the Data from various Databases & Files.
• Worked on different third party tools like Fog Light & Spotlight.
• Review T-SQL code to verify it to meet the standards for both performance & error handling according to DBA standards.
• Created Log on trigger to validate users connecting through different applications.
• Supporting 24/7 Production Environment.

Environment: MS SQL Server 2005/2008 Enterprise Edition, SQL Server Integrated Services (SSIS), SQL Server Reporting Services (SSRS), DTS, SQL Agent, SQL Profiler, Database Tuning Advisor, Database Mail, Notification Services, T- SQL, Windows 2003 server.