Java, Selenium, BDD, Jenkins, GIT, ALM, Database

SANDHYA VEMURI

Phone: +1-424-***-**** / E-Mail: ********.***@*****.*** / Current Location: Plano, Texas

Looking for positions in Software Automation Testing / Quality Assurance Management with a leading organization.

CAREER RECITAL

Working as Sr. System Analyst for Southwest Airlines through Cognizant Technology Solutions since Jan’18.

Worked as Applications Developer for WellsFargo through Advantage Resourcing from Oct’17 to Dec’17.

Worked as QA Automation Lead for Optum Insight (UHG) through Insight Global from Nov’16 to April’17.

Worked as Project Lead – QA for Oracle India Pvt. Ltd., from June’15 to June’16.

Worked as Senior Member Technical for Broadridge Financial Solutions Pvt. Ltd., from Nov’10 to June’15.

Worked as Senior Software Engineer for ValueMomentum Software Services Pvt. Ltd., from Aug’08 to Oct’10.

Current work authorization - GC EAD, USA. No sponsorship is required.

TECHNICAL SKILL SET

Testing Tools : QTP, WATIR, SELENIUM, OATS & Manual Testing

Configuration Management Tool : VSS, Share Point, GIT, ALM

Defect Tracking Tool : Share Point 2.0, Workbench, Bug DB (Internal applications), JIRA, Rally

Continuous Integration / Build Tool : Jenkins / Maven

Operating Systems : Windows, Unix, Linux

Programming Languages : Java, C#

Scripting Languages : VB Script, Ruby

DBMS : SQL Server, Sybase SQL, Oracle

IDEs : Eclipse (TestNG), IntelliJ (JBehave), JDeveloper, Visual Studio

Application Packages : MS Office, Open Office

Web Development Tool : HTML, XML

Bigdata Technologies : Hadoop (HDFS, MapReduce, PIG, SQOOP, Hive, HBase)

Software testing expertise:

Skilled at SELENIUM WebDriver, Ruby WATIR, QTP and OATS

Very well equipped in Designing / Optimizing Test Automation Framework from the scratch

Adept at developing, debugging, enhancing, executing & Reviewing Test scripts and writing Test cases

Active participation in the development of Test Plan, review of Test cases and Automation Test scripts

Expertise in conducting Smoke, Functional testing, Integration testing and proceeding with Defect tracking

Re testing and Regression testing on the modified build and performing System testing

Good at Database testing and WebServices testing using SOAP UI and REST Client and API testing too

Dealt with Distributed Topology Environment (DTE) and Advanced Development Environment (ADE) Commands

Contribution to the Corporate Training Program and Technical Documentation

Leading teams ensuring timely completion of the project, Preparation Monthly, Weekly & Daily status reports

Participation in Mobile Application Testing Training, Validation using simulators and emulators

Proficient in Manual-Automation Testing, Software Development Life Cycle (SDLC), Testing Life Cycle (STLC)

Exposure towards Insurance Domain (Property & Liability insurance), Financial Domain (Brokerage Services)

Healthcare Domain (Enterprise Computer Assisted Coding), Oracle Fusion Middleware

Highlights:

At Southwest Airlines,

Initiated module wise test execution through Jenkins using Meta Filters

Integrated ALM with Jenkins i.e., ALM test sets get updated for stories executed in Jenkins

Started using Centralized Repository & GIT Branching Structure

At UHG-Optum,

Initiated Test Automation for our team with a common Framework, existing across the Org.

Primary point of contact for eCAC-Test Automation.

Developed Automation test scripts in C#, Visual Studio, Selenium WebDriver. Involved in API Test Automation.

Extensively used ALM, Rally and Agile methodology.

At Oracle,

Lead Test Automation using OATS tool for Oracle Fusion Middleware.

Developed a generic script to create a user defined consolidated html report for Automation.

Expertise in Patching Systems and Set up Environment for QA.

At Broadridge Financial Solutions,

Identified the loopholes of existing Automation Process and suggested best practices for Gloss Project.

Lead end to end Backend Test (DATABASE Testing) Automation of Gloss.

Mentored, trained multiple testers on test automation development.

Evaluated SELENIUM WebDriver and automated Gloss TE application.

Designed-Generic Test Automation Framework that can be applied for any web application automation.

Independently developed several automation utilities for XML, Excel, CSV file comparisons across the Org.

At ValueMomentum Software Services,

Primary Point of Contact for NGM PL & CL Automation at Offshore.

Prepared Documentation for Automation Framework Approach.

Successfully completed a course study in QTP 10.0 and Contributed to corporate training on QTP.

Member of Interview panel for Technical rounds in QA.

Projects

Title : WIN

Organization : Southwest Airlines (Cognizant Technology Solutions)

Duration : Since Jan’18

Tools : Java, SELENIUM WebDriver with BDD Framework, JBehave, IntelliJ, Oracle Database, GIT, Jenkins, ALM

Team Size : 4

Responsibilities : Lead WIN Automation Project developed in Java using Selenium BDD framework.

Title : Cornerstone

Organization : WellsFargo (Advantage Resourcing)

Duration : Oct’17-Dec’17

Tools : Java, SELENIUM WebDriver, SQL Server, ALM

Team Size : 20

Synopsis : It is an application designed to provide a Robust, Flexible, and Dependable Customer Due Diligence System that accommodates multiple lines of business access global locations and satisfies multiple Regulatory Jurisdictions.

Responsibilities : Automation Testing using Selenium Java.

Title : eCAC

Organization : United Health Group (Optum Insight)

Duration : Nov’16-April’17

Tools : C#, Visual Studio, SQL Server, ALM, Rally, Ranorex, SELENIUM WebDriver

Team Size : 8

Synopsis : eCAC (Enterprise Computer-Assisted Coding) offers a seamless, integrated solution for all coding and clinical documentation improvement needs. It helps hospitals improve coding quality, specificity and productivity, which is critical to ICD-10 success and timely and accurate reimbursement.

Responsibilities :

Performed Manual, Automation and API testing on eCAC Silverlight and Web Interfaces

Used Services and Database validations for Automation tests

Created Manual tests in ALM, Application Lifecycle Management

Developed Test Automation scripts in C#, Visual Studio

Tracked and Reported Defects in Rally

Implemented Agile standards – Scrum teams, Sprint timelines, PI plan, Sprint plan, Sprint review, Scrum calls

Title : ApplCore QA

Organization : Oracle India Pvt. Ltd.

Duration : June’15-June’16

Tools : Linux, Oracle, SQL Developer, SELENIUM Java, Quality Center, Oracle OpenScript

Team Size : 10

Synopsis : Application Core is well integrated and efficiently used middle-ware infrastructure, based on common apps usage patterns and guidelines. Design techniques, patterns, frameworks are reused to maintain consistency and efficiency in Fusion App Development including UI and back-end. This infrastructure is specific to common functionality and is used across all fusion product families.

Responsibilities :

Lead the entire Automation Project

Designed Test Automation Framework through Oracle Open Script (OATS)

Applied Patches on Oracle Cloud Environments and Set up QA Environments

Performed Sanity, Functional and Regression Testing in Local and Fusion App Integration Environments

Validated and Reported Bugs using BugDB

Triggered BATS execution on Remote Server through Quality Center

Code Reviewed and Fixed the issues in MATS, SELENIUM Scripts

Title : GLOSS

Organization : Broadridge Financial Solutions India Pvt. Ltd.

Duration : Nov’10-June’15

Tools : Sybase SQL, UNIX, Ruby WATIR, SELENIUM Java

Workbench (Broadridge Internal tool), GIT, Jenkins, Maven

Team Size : 5

Synopsis : Gloss, Global Settlement System, is the software system used by institutional brokers to facilitate the settlement of trades they do on behalf of their clients. It is “back-office” system which receives the trade details from front-office, ideally as a feed as and when the trade happens. There is also a facility to feed the trades manually into the system. Gloss is not used for trading activities. Trading happens outside of Gloss and details of trade are input into Gloss system. Gloss facilitates the settlement process and it mirrors the trade settlements happened at the depository.

Responsibilities :

Analysed the business scenarios provided by product experts

Reviewed Regression Test Plans and Provided Estimates

Automated the Test Plans i.e., Developed / Debugged / Enhanced / Executed / Reviewed Automation scripts

Regression Testing was automated through Backend (Core Functionality) and Frontend (TE, web application)

Developed Backend Automation (Database Testing) scripts using

oRuby WATIR

oDeveloped user defined DB Views, Stored Procedures, SQL Queries for CRUD operations

oInvolved in extensive

Data Validation

Data Mapping

Data Integrity

ACID properties validation

oTelnet Connectivity to interact with Unix Servers

Designed Frontend Test Automation Framework from the scratch for using

oSELENIUM WebDriver

oTestNG Framework

oTest Script development in Eclipse IDE using JAVA

oScheduling, Execution through Jenkins

oScripts are made compatible to run on Cross Browsers (IE, Firefox, Chrome)

Result Analysis, Defect Tracking-Reporting, Regular Onsite Coordination, Trained new comers on automation

Involved in cross team Automation activities that used QTP

Designed generic automation framework for Web Application

Title : NGM (Commercial Lines / Personal Lines)

Organization : ValueMomentum Software Services Pvt. Ltd.

Duration : Aug’08-Oct’10

Tools : QTP 10.0 & 9.5, VSS and SharePoint (through CITRIX)

Team Size : 8

Synopsis : NGM, a flagship carrier of The Main Street America Group offers complete line of personal and commercial insurance products and services. NGM CL mainly deals with Automobile, Workers Compensation, Business Owners Policy and Umbrella insurance. NGM PL deals with Personal Auto and Homeowners Policies covering multiple states.

Responsibilities :

Functioned as a Primary Point of Contact for Automation Team, Responsible for regular onsite coordination

Prepared and updated the execution plan into share point for each build release

Conducted smoke test and proceeded with functional testing using valid inputs under different scenarios

Implemented Functional Test Automation using Quick Test Professional involving different Frameworks i.e. Data Driven Frame Work, Key word Framework, Hybrid Framework

Created, Debugged, Executed and Maintained test scripts. Conducted Regression Testing and Analysed Results

Tracked Defects & Reported into Share Point

Involved in Peer Automation Code Review, Raised Comments on the same and ensured they are rectified

Tested the application in different environments like QA2 environment, Staging environment, Development environment and Production environment

Prepared Test data, Automation Templates, Test metrics, monthly, weekly & daily status reports

Followed up with Helpdesk for any network/application issues

Accessed the remote system using CITRIX

EDIFICATIONS

Bachelor of Technology (ECE) from Sri Indu College of Engineering and Technology, JNTU, Hyderabad, India.

Intermediate from Sri Chaitanya College of Engineering and Technology, Visakhapatnam, India.

SSC from Govt. Girls High School, Rajahmundry, India.

CERTIFICATIONS

M16 HP QTP Software.

ISTQB Foundation Level.

INS 21 - Property and Liability Insurance Principles.

New York Institute of Finance courses (Internal to Broadridge in tie-up with NYIF).

Contact this candidate