Post Job Free
Sign in

Selenium, QTP, Jira, Functional Testing, SQL data base testing

Location:
Jersey City, NJ
Posted:
May 30, 2018

Contact this candidate

Resume:

Satish Gubbala

Mobile: 201-***-**** Email: *********@*****.***

Professional Summary:

QA Analyst with 10 years of experience in IT industry, which includes thorough knowledge of System Development Lifecycle experience, Designing, and implementing Test plans, Test cases and test processes. My expertise spans around both manual and Automation testing with strong focus on Selenium framework.

Proficient on Automation tools like Selenium (WebDriver/IDE) & QTP for Testing Client Server & Web based Applications.

Hands - on experience in developing, executing and maintaining test script (manual and automated) using JAVA & Selenium WebDriver and QTP

Excellent working experience of Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC) and testing methodologies like Waterfall and Agile/Scrum.

Experience in creating Automation Frameworks using TestNG & JUnit with Selenium.

Extensive experience in working on Data Driven and Hybrid framework using Selenium Web Driver.

Strong knowledge on building hybrid automation frameworks using Page Object, Page Factory, Data Driven, UI Mapping in Selenium using TestNG/JUnit suites and Java libraries like Apache POI, Log4j etc.

Experienced in continuous integration using JENKINS to support tool likes GIT and execute Apache ANT and apache Maven

Extensive Experience in developing Test Plans and writing Test Cases based on Requirement Document.

Expertise in developing automation scripts in BDD format using Cucumber and proficient in writing Cucumber scenarios in GHERKIN format.

Extensive experience in using Firefox Add-ons like Selenium IDE, Firebug, FirePath, Selenium Builder.

Good experience in Defect Life Cycle Management tools like HP Quality Center (QC), QTest and JIRA

Good Knowledge in testing integrated software Web Services through SOAP UI and REST API

Extensive experience working in agile methodology, SDLC, stand-up meetings with Product owner, Scrum master, understanding and writing user stories along with Business Analysts.

Proficient in Automation tools like QTP. Created, maintained and executed VB scripts in Expert View.

Good experience in Ad Sales Commercials Planning, Ad Sales management, Revenue management, Stewardship, Commercial Operations, traffic and Billing

Managing Onsite and Offshore teams and developed Status Tracker Report to keep track of Onsite and Offshore assignments.

Provided weekly and monthly Status reports to Clients and Upper management.

Certifications:

HP Quality Center 9.2 Certification

HP QuickTest Pro 9.2 Certification

ISTQB Foundation Level Certification

Education

Bachelors Degree in Computer Applications (BCA) from Andhra University.

Master Degree in Business Administration (MBA) from Andhra University.

Competencies:

Functional Automation tools : Selenium IDE/RC/WebDriver, QTP, Junit and TestNG

Test Management Tools : Test Director, HP Quality Center ALM, Qtest and Jira

Languages : C, C++,Java and SQL

Continuous Integration Tools : Jenkin

Add-Ons : Fire Path, Firebug, Selenium Builder, Selenium IDE

IDE : Eclipse

Scripting Languages : VBScript

Operating Systems : Windows family, MAC,MS-DOS and UNIX

Version Control : GIT and GITHUB

Build Tools : Maven, Ant

Projects Summary:

A&E Networks, NY

June 2015 – till date

Senior Test Engineer

WideOrbit is the leading provider of advertising management technology for cable networks, local television stations and radio stations. WideOrbit provides following solutions - Ad Sales Management, Traffic, Commercial Operations, Revenue Management, Pricing & Planning and Inventory management.

GABRIEL is the first integrated ad sales, traffic, and billing system designed specifically for the national cable network industry.

JDA Commercial Proposal Optimizer (CPO) is the planning system. It helps media companies build the best proposals based on their advertisers' inputs while avoiding unnecessary discounts. JDA Commercial Proposal Optimizer optimize the proposal and prepare the best proposal.

PANDA is a Proposal and Deal Analysis tool. It is an A&E in-house product. It pulls sales and traffic information from Gabriel application. Its processed the data for Ad Sales BI application and various reporting purposes. It has Sales, Pricing and Inventory, Net ops and Administration modules for various levels of reporting. Presto is the major functionality which should be used to create and maintain the rate cards for Gabriel application

Roles and Responsibilities:

Create detailed, comprehensive and well-structured test plans and test cases

Conducted Smoke, integration testing, Regression Testing and supported User Acceptance testing

Participate in building automation framework design using Selenium Web Driver, JAVA, Junit, Jenkins, Maven and Eclipse and collaborating with Offshore team

Developed automation scripts using Selenium WebDriver, Eclipse, Junit and Java

Developed BDD tests using Cucumber by writing behaviors and step definitions

Wrote Selenium scripts to create reusable components

Used Firebug Tool to identify the Object’s id, Name, XPath, link in the application

Tested the application in cross browsers such as Internet Explorer, Mozilla Firefox, Safari and Google Chrome for browser compatibility testing

Configured Maven dependencies to execute automation suites

Connected JDBC API with selenium Web Driver to retrieve the database information

Used SOAP UI and SOAP UI Pro to test the SOAP services and REST API

Stored the flow details of Selenium Automation in a file using Log4j

Used Jenkins tool for continuous integration of the builds

Used Apache POI to read data from Excel sheet

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

Run the Automated Regression suite and analyzed results and file bugs

Tracking, reporting, reviewing and analyzing the defects using Jira

Served as a technical mentor to less experienced staff. Update the testing metrics and status reporting to senior management

Proficient in working with Onsite-Offshore Delivery model with direct client interaction

Conducted application Handover sessions to other QA members

Tools: Selenium Web Driver, Junit,SOAPUI,Cucumber,Maven,Jenkins and Eclipse IDE.

Conde Nast, NY

Jan 2012 – June 2015

Senior Test Engineer

Conde Nast is a worldwide magazine publishing company with 18 consumer magazines, including Architectural Digest, Bon Appétit, GQ, The New Yorker, vanity Fair and Vogue, as well as four business-to-business publications, 27 websites, and more than 50 apps for mobile and tablet devices. It is credited with creating the now widely used magazine marketing strategy emphasizing magazines focused on a particular class or interest, sometimes known as lifestyle magazines. Many Condé Nast magazines have their principal focus in fashion, although the company's publications also include travel, food, home, culture, and other interests. It also offers Marketing services and consumer-focused products such as apps and licensed merchandise.

Roles and Responsibilities:

Analyzed the functional specifications and created the Test Plans and Test cases

Conducted Black Box Testing which includes Smoke, System, Functional and Regression testing.

As part of compatibility testing, executed the application related test cases on different browsers like Internet Explorer and Mozilla Fire Fox on different Operating Systems

Involved in User Acceptance Testing (UAT) to test whether it meets the User Requirement Specifications.

Worked in an AGILE delivery model involving multiple scrum teams and daily stand-up meetings

Prepared Weekly and Monthly Status dashboards for Project Test Status updates.

Responsible for implementing page object model (POM) using Selenium WebDriver, Maven, TestNG and Java.

Designed and Developed automation scripts using Selenium Webdriver.

Expertise in using Apache POI api for interacting with excel work books

Used TestNG Annotations in Selenium WebDriver and executed a batch of tests as TestNG suite.

Conducted Data Driven Testing using Data Provider Annotation in TestNG to test the application with different sets of data.

Developed user-friendly and flashy XSLT reports using TestNG.

Used Jenkin as a Continuous Integration server to configure with GitHub and Maven.

Run the Automated Regression suite and analyzed results and file bugs

Performed cross platform and cross browser testing for application under test using Selenium

Involved in Mobile Apps testing

Involved in Web sites analytics testing with help of Charls tool and Firefox add on Omnibug

Interacted well with Developers, Off shore team and Managers to co-ordinate job tasks, deliverables to meet committed project deadlines.

Environments: Java 1.6, J2EE, Spring 3 Framework MVC/Hibernate, XML, Oracle, JSON, Solr, Teamsite, Movable Type, JavaScript, JQuery, Ajax, CSS

Tools: Selenium Web Driver, Selenium Grid2,TestNG Eclipse IDE.

IMS Health,UK

Dec 2010 - Jan 2012

Senior Test Engineer

The Data Customisation application facilitates the creation and management of IMS Health pharmacy data. The client’s customized data will be considered as “client specific reference data set”. Data customization application is a GUI application interface, which is used to customize the reference data, according to the user requirements, that can be published and used for reporting purpose. The Data Customisation application handles the major functionalities like Scope of Pharmacy data which comprises of Selection of data, Custom attributes, Renames for GRR(Global Reference Repository) data and Publishing of customization sets in XML format.

Roles and Responsibilities:

Prepared Test Cases and Test Scenarios based on Functional Specification Document, Use Cases.

Created the Requirement Traceability Matrix (RTM) and evaluated Test Coverage

Created and executed the smoke tests in the pre-production and "go live" environment.

Wrote and executed SQL queries to update and extract data from the back-end databases.

Actively participated in team meetings to discuss the progress of testing

Actively participated in Defect Triage meetings with QA team and developers to discuss and resolve outstanding defects.

Developed automation scripts using Selenium WebDriver, Eclipse, Junit and Java

Executed regression suite with Selenium WebDriver

Identified repeated actions and created utility functions

Used Firebug Tool to identify the Object’s id, Name, XPath, link in the application

Configured Maven dependencies to execute automation suites

Used Apache POI to read data from Excel sheet

Participated in regular walkthroughs and inspections

Develop and implement Quality Assurance metrics, capture and report.

Extensively used Quality center for designing the test cases, executing them and for defects.

Used Quality Center for tracking, reporting, reviewing and analyzing the defects.

Environments: Struts, EJB, Oracle 9i, Windows XP/NT

Tools: Selenium WebDriver, QC 9.0

Fidelity Investments, USA

April 2010- Nov 2010

Test Engineer

Insight OMS project aims at migrating the insight trading engine from legacy AS/400 system to Java Technology. This project will introduce new components into the system like Insight Desktop, OMT, ITE, EOD, XLA and Cancel/Adjust service etc. Insight desktop is a internal Equity trading product. Using this application Trade member can view the activities done by users as well as they can place the orders on the behalf of the customer. It has two types of lists i.e Boston and My lists. The activities done by CSP will be stored in my Lists and activities done by users will be stored in Boston List. Based on the business it has many modules. Enter order, Accept order, Holdings, Execution Status, Fund look up, Security Look up, Trader Look up etc. This will ease the trading capability and enhance the reporting ability at the user end.

Roles and Responsibilities:

Create detailed test plan, test cases and weekly reports, and report to management.

Performed Regression testing, Functional testing and supported User Acceptance testing

Active role in test plan reviews, test cases reviews and key resource for UAT phase and production roll-out.

Prepared and executed Test Scripts for Regression, Functional, and Data-Driven testing as per System Requirements using QTP with respect to functionalities.

Enhanced and modified automated scripts for several complex scenarios by adding programming logic and by premastering to achieve the test objectives.

Wrote Framework-related and Application-related common functions.

Performed Descriptive Programming

Used SQL Queries in VBScript for retrieving data from database for use in multiple testing scenarios.

Attended weekly walkthrough and inspection meetings, to verify the status of the testing effort.

Efficient in interacting with Project Stakeholders, business, development and management.

Environments: Java, AWT, Swing, DB2 and XML

Tools: QTP 9.5 and QC 9.0

ADESA, USA

April 2009 - April 2010

Test Engineer

Hyundai/Nissan RPM applications are the Store front applications. The purpose of these applications is remarketing the vehicles through Auctions. Post the vehicle to the RPM application is called Grounding. Grounding process starts when a lessee returns the vehicle back to the dealer. A dealer can ground the vehicle using the RPM site entering the VIN number of the vehicle, Final Mileage details etc. Based on business this application is divided into different modules i.e. Home, Notify me, My Auction Activity, Find vehicles, Activity Reports modules. The application is interfacing with demaon application. We can provide the CR using this application via Inspection Company.

Roles and Responsibilities:

Involved in all stages of SDLC including requirements gathering, analyzing requirements, and creating test cases, test data and analyzing test results.

Participated in walkthroughs and interacted with other development team members to better understand system functionality in order to improve testing quality

Participate in bug triage meetings with developers to drive towards root cause identification and resolution

Contacted KT session for entire team about new changes and business impacts.

Actively participated in team meetings to discuss the progress of testing

Used Quick Test Professional (QTP) for regression testing and running the automation suite.

Performed Smoke, Functional and Regression testing using QTP.

Responsible for Automation Scripts & library functions maintenance

Wrote Framework-related and Application-related common functions.

Effectively used QTP - VB Descriptive programming whenever it is required

Reviewing the Test Scripts and enhancing the scripts if required.

Defect Tracking and Reporting using Quality Center.

Interaction with onsite people for resolving technical and environment issues and requirement clarifications.

Environments: Struts, EJB, Oracle 9i, Windows XP/NT

Tools: QTP 9.5 and QC 9.0

UnitedHealth Group, USA

Mar 2008 - Mar 2009

Quality Analyst

The Intelligent DeskTop (IDT) is a call center application, it is a single application that allows CCP to access information. It’s a client server application interacts with multiple systems used by UnitedHealthCare. IDT is working in integration with the telephone and this allows access to prior call records, known as Issue History. IDT is automatically document key information as CCP move through various wizards. This functionality is referred to as auto-documentation.

IDT also provides the ability to send a request to other internal departments of UnitedHealthCare when it is necessary to resolve the caller's concerns. This process is referred to as routing issues.

Roles and Responsibilities:

Detailed study of the Software Project Requirement Specification (SPRF).

Responsible for designing automation scripts of new requirements using QuickTest Pro.

Enhancing and maintaining the existing scripts as per new requirements.

Responsible for Automation Regression for each release of the application

Created VB scripts, enhancing, and debugging the test case using QTP.

Responsible for walkthrough of Test Conditions and newly designed automation scripts

Responsible for maintaining the Quality Records in Share point.

Created the Requirement Traceability Matrix (RTM) and evaluated Test Coverage in Quality center.

Preparation of Test Plan, Test Scenario and Test Cases based on Functional Specification Document.

Perform Sanity Testing, Data Driven Testing & Ad-hoc Testing when required.

Defect Tracking and Reporting using Test Director.

Interaction with onsite people for resolving technical and environment issues and requirement clarifications.

Involved in Web Ex sessions for various project requirements.

Environments: VB. Net, Main Frames, DB2 and Windows XP

Tools: QTP 9.5 and QC 9.0



Contact this candidate