manual aolng with automation

SHRUTI N

+1-224-***-**** *********@*****.***

Summary

7+ years of experience in IT in the field of Quality Assurance/Quality Control in the Client-Server and Web-based environments.

Expert in developing Java Selenium Web Driver test scripts and test Frameworks using TestNG/Junit, Maven build tools.

Proficient in automated testing in Behaviour Driven Development framework using Cucmber, Gherkin, Junit and Selenium WebDriver.

Extensive experience in using Selenium Web Driver APIs for writing TestNG test suites and test cases for testing functionality with the Selenium Server.

Proficient in creating automation scripts from scratch. Sound knowledge of developing different type of framework like Page Object Model, Module driven, Data driven, Behaviour Driven Development (BDD) and Hybrid framework.

Strong experience in cross browser, cross platform web testing with Selenium Grid and Web Driver.

Proficient in creating business based functional Test Scenarios, Test plans, Test cases, Test Scripts, Test Specifications and Traceability Matrix including both Manual and Automation testing of the applications.

Extensive experience in automation framework outlining and script coding.

Excellent grasp of basic SQL queries with Oracle and SQL Server databases.

Participated in full life cycle of multiple automation projects from conception to completion - Initiation, Assessment, planning, analysis, design, scripting, execution, reporting and maintenance.

Experience in writing features and scenarios using Gherkin scripting language.

Extensively worked on back-end/database testing (Oracle, SQL Server) and validating the application against the database.

Proficient in Web Services testing (testing XML requests and responses) using SOAPUI

Designed and implemented test data repository (combination of database, excel workbooks and text files) for efficient storage organization and retrieval of test data.

Extensive experience in all aspects of Software Test Life Cycle (STLC) such as developing Test Plans, Test Cases, Test scenarios, requirement traceability matrix, preparing test data etc.

Solid experience in defect management including defect reproducing, tracking and reporting using tools like HP ALM and Jira.

Solid experience in Agile methodologies and Scrum processes.

Excellent analytical, problem solving, communication and interpersonal skills.

skills

Operating Systems

Windows, Mac OS X, Unix

Web Automation Tool

Selenium using Java

In-built framework

Junit, TestNG

Custom framework

Page Object Model, Data-driven, Hybrid Model

Build Tool

Maven

Continuous Integration Tool

Jenkins

Acceptance Testing Tool

Cucumber

Web Testing Browsers

Chrome, Internet Explorer, Firefox, Safari

Database

Oracle, SQL Server

Other Skills

UI Automation,Git, SOAP-UI, REST,Jira, SQL, HTML, CSS,Gherkin, Eclipse, SQL Developer, SQL Server Management studio, SAP BO, MS Office, Service Now, Salesforce (Force.com platform, Process Builder, Approval, Workflow, Reports & Dashboards)

education

Bachelor of Science (BSc) in Electronics from Karnataka University, India

Master of Business Administration (MBA) from Bangalore University, India

Experience

Client: Allstate Insurance, Northbrook IL Feb 2015 – Till Date

Role: Senior Automation Engineer/ Selenium Tester

Allstate insurance is one of the largest personal lines insurer in United States. Allstate has a multi-line quoting system used to generate and provide quote to customers for different products such as Auto, Home, Renters, Condo, Boat etc. This project involved building and automating the functional and regression test suites for this highly transactional and complex quoting system using Selenium Webdriver. This assignment also involved automating user acceptance testing for MyAccount application using Cucumber following Behaviour Driven Development (BDD). MyAccount is a customer facing application to manage a customer’s allstate policies, pay bills, file a claim, view transaction details, statements etc.

Responsibilities:

Worked with Business Analysts and developers to understand and identify the business requirements for new developments and as well as enhancements

Analysed the requirements and manual test cases and defined automation scope by identifying potential candidates and functionalities for automation.

Performed automation feasibility using Selenium and demonstrated proof of concept for aligning business and technology stakeholder for Selenium regression suit automation.

Automated entire regression suite for Alliance quote application using Selenium Webdriver, Java and TestNG

Built the framework by configuring and using Selenium WebDriver, TestNG by following the data driven and page object model design pattern which reduced the significant effort in overall testing automation.

Involved in identifying automation test scenarios, set up the required reusable functions, repository, environment variables, test data and functions required for the automation scripts functionality.

Identified test data and organized in excel files scenario wise for test inputs at run time.

Created data provider methods to provide the test data for implementing data driven test suites.

Created page object repositories by creating classes for individual pages.

Used various element locator approaches to identify the elements in page object classes for implementing page factor and better re-use of identified web elements.

Identified and developed business and generic re-usable methods to be used across the test scripts to enable single point of maintenance.

Enhanced test cases using Java programming features and TestNG annotations.

Automated user acceptance testing suite for MyAccount application using Cucumber framework by following BDD (Behaviour Driven Development).

Worked with product owner in defining user acceptance test scenarios using Gherkin scripting language.

Implemented test runner and step definition packages to write test scripts for associated steps in the feature file.

Performed Defect Tracking & Management in JIRA.

Performed various Testing Techniques: Ad hoc, Functional Testing, Database Testing, UI Testing, Regression Testing, System Testing, Performance Testing, End-to-End Testing.

Designed Test cases for Functional Testing, Database Testing, Usability Testing, and System Testing.

Mentored and trained new team members.

Worked in a highly dynamic AGILE environment and participated in scrum and sprint meetings.

Environment: Java, Selenium WebDriver, Maven, Jerkins, TestNG, XML, XPath, HTML, Internet Explorer, Google Chrome, Mozilla Firefox, MS Excel, Jira, SQL, Oracle, Windows, Eclipse, Android, BDD, Cucumber

Client: SunTrust Mortgage, Richmond VA Dec 2013 – Jan 2015

Role: Automation Analyst

SunTrust is one of the nation’s largest and strongest financial holding companies. Sun Trust has a mobile (iOS & Android) and we application called Empower. This application is the loan origination tool for the retail mortgage. Tools allow end-to-end process of loan application, processing, underwriting and closure. Project involved automating both mobile and web applications. Mobile app provides borrower’s ability to view the status of the application and upload required documents. Empower has been built heavily on service oriented architecture by separating out the application layers as services. The automaton scope included automating the services testing using SOAP UI.

Responsibilities:

Created Maven project and mapped with Page Object Model pattern.

Created utility package with re-usable classes and methods.

Created TestNG suite along with testng.xml to drive test execution.

Created data driven framework to get the test data from excel workbook.

Loaded all the required dependencies into POM.xml along with build configuration.

Used Git repository as code management and version management tool.

Created separate test scripts but re-using the same project setup for mobile device/emulator.

Configured Jenkins with required plug-ins to run the Maven project using Jenkins.

Participated in planning and developing test strategies and plans for Functional and regression test automation.

Analyzed test results and prepared test/defect summary report for Sr. Management.

Actively involved with SCRUM and sprint meetings, managing backlog, removing obstacles to progress, prioritizing and review milestones and accomplishments.

Maintained knowledge base for recurring defects and resolutions and business comments for those defects.

Environment: SOAP UI, Java, Selenium WebDriver, Maven, Jerkins, TestNG, XML, XPath, HTML, Internet Explorer, Google Chrome, Mozilla Firefox, MS Excel, Jira, SQL, Oracle, Windows, Eclipse

Client: Gymboree Corporation, San Francisco, CA Apr 2013– Nov 2013

Role: QA Analyst/SAP BO Report Tester

Gymboree Corp., a specialty retailer offers apparel, accessories, and play programs for children. The company cooperates with many cash back websites and coupon provider websites (like Shopathome.com, Ebates.com). This project was building the integration with external vendors and testing the data feeds and extracts.

Responsibilities:

Developed Test Plans, test scripts and executed the test scripts.

Thorough out the project in various iterations/Sprints – conducted system testing, integration testing, functional testing and integration testing.

Developed complex SQL queries for querying data against different data bases for data verification process.

Prepared the Test Plan and Testing Strategies for Data Warehousing Application

Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings.

Extensively interacted with developers, business& management teams to understand the project business requirements and ETL design document specifications.

Participated in regular project status meetings and QA status meetings.

Extensively used and developed SQL scripts/queries in backend testing of Databases.

Written test cases to test the application in Quality Center.

Defects identified in testing environment are communicated to the developers using Quality Center – Defects module.

Prepared daily status reports with details of executed, passed, and failed test cases and defect status.

Tested a number of complex ETL mappings and reusable transformations for daily data loads.

Creating test cases for ETL mappings and design documents for production support

Setting up, monitoring and using Job Control System in Development/QA/Prod

Extensively worked with flat files and excel sheet data sources. Wrote scripts to test the flat files data in the databases.

Scheduling and automating jobs to be run in a batch process

Effectively communicate testing activities and findings in oral and written formats

Worked with ETL groups and business analyst for understating mappings for dimensions and facts

Extracted data from various sources like Oracle, flat files.

Worked on issues with migration of Data from development to QA-Test Environment

Extensively tested several Business Objects Reports – Crystal’s reports and Dashboards to validate the reports the data and cosmetics of the report.

Environment: Unix, Ab initio, SQL Server, Oracle, SAP Business Objects, Internet Explorer, Google Chrome, Mozilla Firefox, MS Excel, HP Quality Center, Windows

Client: Health Care Service Cooperation, Chicago, IL Jan 2012 – Mar 2013

Role: QA Analyst/ETL Testing

Health Care Service Corporation (HCSC) is the largest customer-owned health insurance company in the United States. HCSC offers a wide variety of health and life insurance products and related services, through its operating divisions and subsidiaries; including Blue Cross and Blue Shield of Illinois, Montana, New Mexico, Oklahoma, Texas, and Dearborn National. HCSC plans were among the first health coverage companies in their states, and they pioneered many of the benefits that are taken for granted today The Health Care Service Corporation (HCSC) is trying to build an application to maintain core Membership Administrative/Management System, encompassing several subsystems that together support all health insurance membership processes. RMAS is used to refer to applications which comprise the Individual Retail Marketplace for the Health Care Service Corporation and its subsidiaries. It consists of the applications VMS, VAS, VDE and RPP. The below modules are taken care by this applications for BCBS, New Business Underwriter Agent Rating Billing Correspondence Claim investigation Check Writer Membership Collections Interfaces and Modify claim payment reports to allow searching by patient information.

Responsibilities:

Attend the business requirements review meetings on the requirements and sign-off the requirements.

Analyze the base lined requirements and create the test cases and the traceability of requirements using Quality Center

Attend Design review meetings and update the test cases if required.

Create the test strategy document for every release and review it with the stake holders

Review the test cases and traceability with business.

Execute the test cases prepared in the test / integration environment and report the defects through Quality center.

Track the defects throughout the defect life cycle

Retest the defects and close through quality center once the defects are fixed.

Perform mock deploy and mock rollback testing in UAT environments.

Provide the deployment support by running Build Validation Tests and Production Validation tests after the release.

Perform regression testing, GUI validation, page navigations, content validation and functionality check with end to end scenario.

Perform database validation using complex SQL Queries.

Performed testing of ETL jobs for transformation, validation rules.

Wrote and modified required UNIX scripts and other SQL validation scripts, and writing scripts in SQL to validate the outputs.

Involved in writing Shell Scripts to load and extract information from files and tested the back-end for data integrity in UNIX.

Providing testing support for the production support issues and projects.

Conduct daily Defect review meetings.

Create the test reports and metrics and share it with the team.

Perform a QA Lead role for a project release.

Create and share weekly / daily status report with the team.

Environment: HTML, HP Quality Center, MS Excel, SQL, Oracle, Windows, Unix, Ab initio

Client: ExcelSoft, India Mar 2010–Dec 2011

Role: QA Tester

Excelsoft is a leading products and service provider in e-Learning domain that serves educational publishers, universities, government and corporate sector. SARAS is a key web based product of Excelsoft which provides virtual learning environment. The project involved major, minor enhancements to the products and defect fixes.

Responsibilities:

Reviewed the business requirements and use cases to understand the requirements with the inputs from business analysts in order to efficiently participate in the testing life cycle of the project.

Developed test plan consisting of scenarios based on the functional requirements

Prepared scripts (SQL etc) to create test data as required and populated test data to ensure that test environment is setup in order to ensure commencement of test execution.

Developed functional/non-functional/regression test cases based on the requirements.

Prepared the requirements traceability matrix to track business requirements and to ensure test coverage completeness.

Executes test cases, logged and tracked identified defects, and participated in defect triages.

Performed go live activities such as production verification as per the implementation plan in order to ensure application is running in production without any issues.

Anchored defect prevention activities and actioned defect prevention plan in order to ensure quality adherence.

Environment: Quality Center, MS Excel, Oracle, Windows, SQL

Contact this candidate