QA Automation Engineer/SOA Tester

Swarna Kil

QA Automation Engineer/SOA Tester

Email: ******.*****@*****.***

Contact: 609-***-****

8+ years diversified experience in manual, ETL, ERP and automation in Selenium. Skilled in developing UI Automation tests using different automation tools while serving various domains such as Telecom, Finance, Healthcare, Banking, Insurance, Retail and e-commerce. In Depth knowledge in tools like SoapUI for Web services & Eclipse. Proficient in SDLC & STLC methodologies. Extensively worked for multiple projects in Scaled Agile Framework (SAFe), Agile-SCRUM & Traditional working models in a distributed and collaborative & non-collaborative environment

Professional Summary:

Proficient knowledge in White Box and Black Box testing for functionality and structural flow of an application

Strong knowledge in web automation which includes GUI Testing, Functionality Testing, Unit Testing, Integration Testing, Regression Testing, System Testing, Performance Testing, Load Testing and User Acceptance Testing.

Well versed in automation testing tools such as Quick Test Professional(QTP), Load Runner and Selenium (Selenium IDE, Selenium RC, Selenium Web Driver and Selenium Grid)

Experience in developing Test scenarios, Test cases, Test data, Test procedures, Test reports and documenting Manual and Automation Testing.

Extensively worked on GUI, Web Services, Mobile and Database testing.

Experience in SOA / Service/ API Testing & Service Virtualization using CA DevTest /iTKO LISA toolset.

Hands on experience on doing Web service performance testing using staging document in CA DevTest /iTKO LISA.

Experience with Cross-Browser and Compatibility Testing to test whether the web applications are working as desired in different browsers and environments

Experience in preparing and maintaining Automation Frameworks (Record/Playback, Keyword Driven, Data Driven, Hybrid Driven, and Page Objects).

Having experience on Mobile Automation (Android & IOS) using Appium (Selenium) and Perfecto

Experienced in SOA, SOAPUI/RESTFUL Web Services Testing. Validated request and response XML, SOAP and RESTFUL Web service calls

Experienced with projects that utilized web technologies like XML, HTML, CSS, and JavaScript and high-level languages such as Java

Worked on different transport like HTTP, HTTPS, REST & MQ.

Strong Knowledge in Core Java Concepts, OOPS (Object Oriented Programming System) concepts, Exception Handling, Collections Framework, Multi-threading, Conditional and Looping statements

Familiar with higher level programming language such as C++, C#, Python

Extensively worked on Oracle ERP financial and SCM modules (P2P, O2C). Have in depth knowledge in AP, AR, GL, iPro and FA.

Experience in working on databases such as Oracle, MSSQL Server, My SQL and JDBC connectors

Designed complex SQL queries, Functions, Views, Triggers, Packages and Stored Procedures.

In depth knowledge in developing database queries using SQL and PL/SQL to assist in testing effort

Extensively worked on GUI elements using various Selenium Locators like ID, Name, Link Text, Partial Link Text, XPath, CSS, and DOM in creating automation scripts.

Experienced in using Accessing Forms, tables, link, Keyboard Mouse Events, Uploading File using Selenium WebDriver

Implemented test automation for handling Popup windows and Alerts using WebDriver and Alert interface class.

Experience in testing and handling different frames (frames, iframes) of a HTML page with having different DOM’s for every iframe.

Proficient in handling the SSL certificate error using Desired capabilities in all the web Browsers.

Used AutoIt, Robot API tools in automation for Mouse movements, Keystrokes, Window control manipulations and print pop-ups which is not possible using selenium WebDriver.

Configured application framework using Excel spreadsheets and processed the spreadsheets using Apache POI.

Executed test scripts in headless browsers using HtmlUnitdriver and PhatomJS.

Good in taking Selenium Screenshots for bug reporting, analysis and exception debugging using Extent Reports reporting library with TestNG.

Expertise in Grouping of Test Cases, Test Methods and Test Suites for regression and functional testing using the TestNG (Groups, Parameter, Data Provider).

Automated and scheduled Build using continuous integration tool Jenkins Server at a particular time.

Conversant with Ant and Maven project build tools.

Effectively involved in Defects logging using Loggers, Appenders in Log4j.

Developed selenium synchronization using conditional and unconditional wait conditions.

Experienced in using Test Management and bug reporting tools such as QC, HP ALM/Quality Center, Rally, JIRA and Bugzilla to track test progress, execution and deliverables.

Developed Test Scripts to implement Test Cases, Test Scenarios, and features for BDD (Behavior Driven Development), TDD (Test Driven Development) using Cucumber.

Conversant using Configuration management tools like SVN, GIT.

Dynamic and assertive team player with a strong inclination to improve and optimize process development and implementation

Excellent analytical skills with good communication and self-organizing skills, assertive and a committed team player

Technical Skills:

Methodologies

Agile (Scrum, SAFe), V-Model and Waterfall

Software Testing

Functional, Database, Web based UI Testing, Web Services, Test Plans, Cases & Processes, Functional Requirements, Regression, Positive & Negative Testing, UI & Compatibility Testing, Data Interface & Migration Testing, Testing Automation

Functional Testing

Unit Testing, Smoke Testing, Sanity Testing, Integration Testing, White box testing, Black Box testing, Regression Testing, System Integration Testing (SIT) & User Acceptance Testing (UAT).

Nonfunctional testing

Performance Testing, Load Testing, Stress Testing, Security Testing, Compatibility Testing

Testing tools

Selenium (Selenium IDE, Selenium RC, Selenium Web Driver), iTKO LISA, DevTest, SoapUI, TestNG, JUnit, JMeter, Maven, ANT, Jenkins

Test Cases Management

JIRA, HP QC/ALM, Bugzilla, Rally

Languages

JAVA, C++, C#, Python, JavaScript, HTML, CSS, XML, JSON, XSD

Databases

MYSQL, Oracle, DB2, SQL Server, DB Visualizer

Testing Frameworks

BDD, TDD, Page Object Model and Hybrid, Gherkin, Cucumber

Protocols

LDAP, TCP/IP, HTTP, HTTPS, FTP, SMTP.

Web services

SOAP, SOAPUI, SOA, POSTMAN, REST and RESTFUL

Browsers

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

Operating Systems

UNIX, WINDOWS, Linux

MS Office Tools

Outlook, MS Word, MS Excel, MS PowerPoint, MS Project

Certifications:

Oracle Certified Associate

ISTQB certified Tester

Professional Experience:

Project:1

Humana, NY Aug 2015 – Present

SOA Tester

Humana Inc. is a for-profit American health insurance company based in Louisville, Kentucky. Humana had become the largest hospital operator in the country owning 77 hospitals.

This project involved in getting new insurance plans into Humana network, where users can shop plans and purchase different Health plans based on the requirement of individual or a family. The application UI offers and compares different plans available and generates quotes.

Responsibilities

Analyzed business requirements and functional documents, created to define the test environment, phases of testing, entrance and exit criteria into different phases of testing and resources required to conduct the effort

Performed agile testing, reviewed the stories and participated in Daily Scrum, Iteration Planning and Release Planning meeting

Analyzed Business requirement documents for creation and execution of Test Scripts, Test Cases and User Scenarios to provide optimal end-to-end test coverage

Over 10+ services developed in the ESB layer using SOAP/HTTP(S), REST & MQ protocols were successfully virtualized, where needed & applicable.

Validate services using SOAP UI and CA/ITKO DEVTEST (LISA) by testing XML request and response data

Involved in validating functional, Integration and Regression test suites using Selenium, Cucumber and the request and response of the Web Services (SOA) through SOAPUI

Created Virtual services (VSI, VSM) where needed to address environment bottlenecks

Requested WSDL's & XSD's from developers to understand the required and optional elements within a schema and developed the test scope and test data accordingly

Participated in testing & deploying the developed SOA applications to development, staging and production environments.

Extensively worked in Regression testing, Parallel Processing using Selenium Web driver in TestNG

Performed the build and maven dependencies using Maven build tool

Used XPath and DOM to work with dynamic and static objects in Selenium

Reviewed and analyzed the existing test scripts

Developed HTML TestNG reports for analyzing the output of test using Extent Reports API

Maintained user documentation with Selenium output screenshots for User acceptance testing (UAT)

Developed synchronization using implicit and explicit wait conditions

Incorporated the test data in Test scripts from Excel using Apache POI API

Created automation scripts using Selenium Hybrid and Data-driven development framework

Developed Back-end testing using complex queries to retrieve the user information to cross validate in UI and databases

Prepared PL/SQL scripts to verify the database updates, inserts and deletes of the records

Maintained the Java and selenium test source code and resources in the GIT source control repository tool

Analyzed test results, tracked the defects and generated reports using JIRA

Prepared the data to cover various scenarios and wrote SQL scripts to verify the database updating, insertion and deletion of the records

Maintained continuous test integration and automatic build by using Jenkins and mailed the build outputs to the team members

Developed scripts for Mobile UI Testing using Appium

Primarily responsible for Android and IOS mobile app functional validation, data validation and API

testing using an Advanced REST client, JSON validation.

Tested REST and SOAP Services using SOAPUI and validated responses against the database

Tested applications in different types of browsers (cross-browser testing) and versions, such as Internet Explorer, Firefox, Google Chrome to simulate production environment

Developed Test Scripts to implement TDD (Test Driven Development), BDD (Behavior Driven Development) using Cucumber

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

Participated QA weekly meetings and various other meetings and discusses enhancement and modification request issues and defects in the application

Environment: Java, Selenium Web driver, TestNG, Firebug, Firepath, CA/ITKO DEVTEST (LISA), MS Test Manager, XML, XSD, XPATH, DOM, JIRA, MQ, Cucumber, GIT, Agile, Internet Explorer, Chrome, Firefox, SQL, Jenkins, SoapUI, Gherkin, Eclipse, Maven, Oracle.

Project:2

Best Buy, Minneapolis, MN Jan 2014 – Feb 2015

SOA Tester/QA Engineer

The application is developed to improve on the secondary sales in the complex distribution structure. The intent is to capture real time bill level secondary sales and identify growth opportunities by running an analysis on the collected data.

The output of the analysis is in the form of recommendations from a Market Research Organization that does statistical analysis on the bill data in comparison with the market trends at the outlet level. The application enables the Sales team to drill down on most successful recommendation from the set received on different parameters like Base pack, RS, pack value, growth & outlet which have potential for increased sales in a particular outlet. Additionally, the recommendations can be published to the server very quickly and easily.

Responsibilities

Involved in Analysis of Business Requirements, Use Cases, Design Flowcharts and Software Requirements.

Setup the Automation framework using Selenium Web Driver to run test cases in multiple browsers and platforms.

Created automation scripts in SOAPUI using Groovy Script for web services testing.

Wrote and executed automated test cases using Selenium Web Driver to automate manual testing solutions.

Analyzed the Log files to verify the processes for debugging and or test data verification purposes.

Experience with TOAD for backend data validation

Handled the tasks of assisting SOA in developing test strategies and in gathering testing requirement

Developed and executed SQL queries to verify the proper insertion, deletion and updates into the database and investigate for solutions using data analysis practices and prepare analysis reports.

Performed Regression testing on new builds, every modification in the application using Selenium Web Driver.

Performed Compatibility testing of applications for dynamic and static content of browsers using HTML Ids and XPath in Selenium.

Performed defect reporting and bug tracking using JIRA and also followed up with development team to verify bug fixes, and update bug status.

Involved in creating automation test suites for progression & regression testing in SOAPUI. The messaging formats included SOAP over HTTP based clients with XML payload.

Involved in Unit testing, test case development and regression testing using Junit for web based application.

Coordinating with UAT for validation supporting Service Oriented Architecture (SOA).

Developed and executed SQL queries in the database to conduct Data integrity testing by checking the data tables on the server.

Prepared user documentation with screenshots for UAT (User Acceptance testing).

Interacted with development and product management teams for the quick resolution of reported bugs and various technical issues. Data validation and Database integrity testing done by executing SQL queries.

Performed quality assurance reviews on all System Development Life Cycle phases.

Worked with developers to communicate regarding issues in the application.

Providing and arranging the KT sessions to the new team members

Prepared UAT High level scenario's using URS requirements and Prepared Test data for the same

Escalate issues impeding test progress with appropriate members of the project team

Follow up with Development team on defect resolution. Updating daily status to Release Manager which includes issues, action items, defect status etc.

Environment: Java, Selenium Web Driver, Soap UI, TDD, Agile, HTML, XML, SQL, PL/ SQL, Oracle, Quality Centre, Windows XP, UNIX.

Project:3

PNC Bank, New York, NY June 2013 – Dec 2013

QA Automation Engineer

PNC offers a wide range of services for all our customers and their business are categorized in to Retail Banking,

Corporate and Institutional Banking, Wealth Management. The project was to provide a middleware layer based on SOA to provide access to all core systems of the bank and integrate with external parties to provide a single layer for all the data.

Responsibilities

Analyzed User stories, Business Requirements, Functional Requirements, System Requirements and participated in Sprint Planning, Review Sessions and Scrum Meetings.

Designed Data Driven framework for reading the data from excel sheets using Apache POI (Page Object

Index) library and TestNG data provider.

Worked with utilities like Firebug and Fire path for the identification of web elements using locators such as id, name, Xpath, CSS Selectors, Link Text, Partial Link Text and Tags.

Designed, coded and executed automated tests using Java/TestNG/XML/SQL based test frameworks.

Designed and executed the Automation Test Scripts using Selenium Web Driver and TestNG.

Worked on Selenium Grid for automation script in Java for cross platform testing.

Handled scripts to navigate to various iframes and to handle multiple windows and performed operations on the web elements.

Dealt with Ajax requests in Selenium Web driver using Synchronization.

Responsible for testing SOAP Web Services by understanding WSDL, driving the parameters from property files and scripting using groovy script.

Performed cross-browser Testing on various browsers like IE, Chrome and Firefox and ensured compatibility on different browsers using Java, TestNG and Jenkins.

Used Jenkins and Maven to regularly build the project from the remote repository to keep track of failed builds.

Used Tags, Data tables, Hooks, Annotations and manage code efficiently by reducing redundancy in cucumber.

Performed functional testing of Web Services using POSTMAN Tool.

Integrating Cucumber with Jenkins and thus generate reports according to the requirement.

Prepared project metrics and summary reports, defect tracking reports to report the entire status to the product owners and the stakeholders serving as a point of contact.

Environment: Selenium WebDriver, JIRA, Jenkins, Maven, SVN, SQL, Apache-POI, Oracle, Eclipse, Firebug, Firepath, SOAPUI, CSS

Project:4

Level 3 Communications, Broomfield, Colorado April 2011 - May 2013

Project Engineer/ERP functional Tester

Level 3 Communications is a multinational telecommunications and Internet service provider company headquartered in Broomfield, Colorado The company provides core transport, IP, voice, video and content delivery for most of the medium to large Internet carriers in North America, Latin America, Europe and selected cities in Asia. Upgrade project from 11i to R12.Have to do code retro fitment, configuration and testing the individual and integrated modules.

Responsibilities

Created Test cases from scratch by using Business Functional Requirement Specs, and also responsible for developing, reviewing, coordinating and delivering the Test Strategy and System Test Plan documents and also responsible for creating the test specifications, including test plans and testcases

Designed automation framework compatible with QTP and QC

Customization of Quality Center projects based on Application team requests.

Delivered the Automation Testing scripts as per scheduled dates with high quality.

Analyzing Test Report generated by automated test scripts. Presented test results to the developers and the management.

Involved in implementing error-handling mechanism for handling run-time errors while running Automation script.

Gained functional knowledge AP, iProcurement, AR and purchasing modules.

Communication with design and development teams (direct discussion or conference).

Automated more than thousand scripts in Oracle ERP.

Used VBScript file to load all the function libraries using Library functions in QTP utilities.

Creating and executing system and functional test scripts.

Involved actively in creation of Regression Testing suite of automated QTP scripts to do the Regression

Testing and Build Acceptance Testing. QA tested Customization of the Forms, Reports, Concurrent programs, customized PL/SQL code, nightly batch jobs/interfaces that bring the data from legacy systems to Oracle ERP Apps

Reported, tracked the bugs and Errors through the Quality Center (HP-QC). Participated in Bugs and enhancement review meetings. Assigning the Bugs and Enhancement request to the Submitters and follow up

Provide test summary documentation and analyze test results, identifying trends and/or root causes of problems.

Developed training materials, system maintenance and operating manuals for the QA environment and used the same to train the users.

Environment: Oracle Apps 11i, R12; Load Runner 8.x, HP QC 10/11, Toad, SQL, PLSQL

Project:5

LIC Life Insurance Corporation, India May 2009 – Feb 2011

QA Analyst

LIC is a major firm in India which deals with the insurance. IMS (Insurance Management System) is one of its

major tools and it was developed basically to provide the data about claims, renewal, issuance and cancellation

of health insurance policies. IMS can generate reports depending on various criteria.

Responsibilities

Understanding the Business requirements, Application and function specifications, Design documents

Documented Test Scenarios (positive and negative) and Test Cases based on the functional specifications

Responsible for Black Box Testing of the application

Checked the client side and server-side validations. Tested the functionality of the application

Involved in developing the tractability matrix in Excel sheet

Identified the Test Cases and documented them in Quality Center.

Performed GUI, Functional, Negative, Positive, Regression and User Acceptance Testing

Scripted Complex Test Cases using SQL queries for data validation and to verify the data integrity in the

database (Back end testing).

Conducted the System, Integration and Regression of the web application

Prepared test scenarios and executed to validate the Tables, fields, texts and images in the Application

Performed Backend testing by extensively using SQL queries to verify the integrity of the database

Involved in daily status calls and reporting

Worked with development team on defect reporting, fixes and resolution; update management on testing results, activities and planning using QC

Environment: HP Quality Center, SQL Server, Windows XP, Microsoft office, Test Plan, Functional testing

Contact this candidate