Test Cases

Trupti Chovatia

321-***-****, **************@*****.***

QUALITY ASSURANCE ANALYST

Quality Assurance professional with over 6 years of experience in developing and performing manual and automated testing for the entire software development life cycle (SDLC) with exceptional leadership skills that can motivate and actively influence process adherence and improvement. Possess in-depth knowledge of functional, regression, system, product, user acceptance, performance and browser compatibility testing. Resolves complex issues and business challenges through the use of analytical skills along with Quick Test Pro (UFT), Load Runner, and Quality Center (ALM) automated testing tools.

Summary:

Quality Assurance • Functional / User Interface / Regression /

Integration / Systems Testing, Manual / Automation Test

Methodologies • Enterprise Releases • System Updates

Test Defect Review / Evaluation / Resolution • Team Management

Support of MS SQL Servers 2014,2012,2008 R2/2008/2005/2000 in

Production, QA and Development Environments.

Expert in creating database tables, joins, indexes, stored procedures, views,

triggers, user defined data types and functions in MS SQL server […]

Proficient in installing, configuring, managing, upgrading and

migrating, Backup/Restore,Monitoring and troubleshooting SQL Server

2008 R2/2005.

Strong experience with T-SQL (DDL & amp; DML) in Implementing

& amp; Developing Stored

In Order to check the response time with single user on a system, used HTTP Watch, Fiddler testing tools

Changed the runtime settings and performed load rate calculation that includes setting up think time, pacing, selecting number of Vuser, number of iterations and number of transactions.

Expertise in developing Performance Test Plan, Test Cases, Test Scenarios, Test Scripts Use Case and Traceability Matrix.

Hands on experience in handling different protocols like web (HTTP/HTML), AJAX True Client, Web Services, SAP, Winsock, Citrix Protocols.

Skilled in debugging and adjusting scripts by running in VuGen with runtime settings logs set to display all messages.

According to the SLA (Service Level Agreement), created the scripts to meet load-testing requirements.

Hands on experience performing integration testing, stress testing on different protocols like web (HTTP/HTML), AJAX True Client.

Experienced in enhancing the Vugen scripts Correlation techniques, Parameterization and Synchronizations.

Exposure to various LoadRunner functions used by VUser generator for scripting.

Skilled in debugging and adjusting scripts by running in VuGen with Runtime Settings logs set to display all messages.

Proficient in plotting and implementing scenarios and loading Load Runner scripts into a controller.

Experienced in Handling in 1300 VUsers in Test.

Had Experience in Running Single User Test, Load Test, Capacity Test and Stress Test.

Performed result analysis using online monitors and graphs using Load Runner.

Measured Response times at sub transaction levels at web, App servers and database server levels by using Optimal Application expert, highly concentrated on Transactions per sec during testing.

Analyzed the test results TPS, Hits/second, Transaction response time, CPU utilization using Load Runner Analysis, various monitoring tools and prepared Test Reports.

Monitors and captures system metrics to indicate trends in performance growth & recurring problems.

Worked with bug report generation and defect tracking

Checked for Network Bottlenecks using Network Delay Time and VUser Graphs.

Have experience with different load testing tools and monitoring like LoadRunner, Quality Center, Performance Center, HP Openview, Wily Introscope, Splunk, and Perfmon.

Delivering the status reports like testing status, defect - tracking status, and weekly status reports to the Test Manager.

Excellent verbal, written and analytical skills with ability to work in a team as well as individually in fast paced, dynamic team environment.

Technical Skills:

Test Strategies System Integration, Regression, Functional, Smoke and Black Box.

Scripting Languages VB Script, Java Script.

Operating Systems Windows, UNIX, Linux, Solaris, AIX.

Testing Tools Load Runner, JIRA Bug Tracking Tool, Quality Center, QTP, Performance Center.

Workflow Tools MS-Word, MS-Excel, MS-PowerPoint, MS-Visio, MS-Outlook and IBM-Lotus Notes.

Operating Systems Windows 98, 2000, 2003 server, XP, UNIX, HP-UX 11.23, SOLARIS 10.x

Databases Oracle 8i, 9i, 10g, 11g, SQL Server 2000/2005/2008/2012/2014, DB2 8.x

Other Tools TOAD, SQL Loader.

Languages SQL, PL/SQL, C, C++, HTML, JAVA, XHTML, XML.

Perfomance:

Expertise in SQL Server Reporting Services (SSRS), SQL Server

Integration Services (ETL)

Ability to work in all stages of System Development Life Cycle (SDLC).

Proven ability to develop Dashboard, Ad-hoc and Parameterized

Reports, create complex (ex: drill down reports using different objects)

using SSRS.

Exceptional ability in Interacting with Business users to analyze the

business process and Transforming requirements into screens,

performing ETL, documenting and rolling out the Deliverables.

Strong Experience in Creating, Configuring, Deploying and Testing SSIS

Packages.

Worked extensively on Extraction, Transformation, loading data from

Oracle, DB2, Access, Excel, Flat Files and XML using DTS, SSIS.

AMPEL, SC Jun 2016 – Sep 2017

QA Analyst

American Pioneer Electronics Inc. (AMPEL) is one of the leading distributors in the Electronic Components Trading Industry, with branches around the globe. The main reason for the portal is to speed up the internal business processes and provide a wide range of services to the customers. This project contains 19 modules. It is integrated with Spider Search Engine for automatic search requests.

Roles & Responsibilities:

Actively involved in gathering and analyzing of business requirements along with developing testing strategy in various clients.

Developed Performance Testing Plan, Performance Testing Strategy based on the business specifications requirements and user requirements and prepared Close out Document and Executive level summary.

Manual tested the requirements using Fiddler to verify Response Time of the single user on the system.

Created Load Runner scripts with Web (HTTP/HTML) and Web Services protocols based on the user workflow.

Testscripts development in VuGen and modifying scripts with required Correlations, Parameterization, logic, think times, iterations, pacing, logging options and preferences.

Created the load test scenarios using Load Runner Controller from scratch, which includes Creating the VuGen Scripts and Assigning Vuser for each script.

Performance/ Load testing using HP ALM Performance center 12.1 & 12.5

Performance testing of customer end applications using Neoload 5.1

Monitoring and bottleneck analysis using Dynatrace and Wily Introscope

Good expertise in development of Scripts using various protocols like Web (HTTP/HTML ), Ajax TruClient, WebServices and Citrix protocols

Developed Web (HTTP/HTML) & Truclient scripts using HP Loadrunner 12.0 & 12.5

Had Performed Stress Test using 1300 virtual users.

Analyzed IBM Rational Performance Tester on-line graphs and reports to check where performance delays occurred, network or client delays, CPU performance, I/O delays, database locking, or other issues at the database server.

Used JMETER for testing web applications

Defined transactions to measure server Performance under load by creating rendezvous points to simulate heavy load on the server.

Testing AJAX web site application, implementing Selenium testing platform and using test scripts with Eclipse IDE.

Writing Selenium scripts, using JUnit and Selenium RC for automated testing.

Developed and maintained release acceptance tests using Selenium IDE, JUnit, and Eclipse IDE.

Analyzed the Transaction Summary Report and graphs generated in a Load Runner Analysis session.

Monitored different graphs like transaction response time and analyzed server performance status, hits per second, throughput, windows resources, database server resources.

Expert in finding performance bottlenecks both in client side and server side and making recommendations for Performance Profiling or Tuning.

Identified Performance issues using Load test results using LoadRunner Analysis and online monitors.

Experience in Monitoring Server Performance using Wily Introscope.

Used Splunk to monitor long running transactions.

Validated data by writing SQL Queries on different Environments.

Maintained defects in Rally and participated in defect triage meetings.

Interacted with developers during testing for identifying memory leaks, fixing bugs and for optimizing server settings at web, application and database levels.

Co-ordinated meeting for determining production readiness of applications and Involved in Project meetings and interacted to other team members to resolve the problems.

First Marblehead, Boston, MA Mar 2015 – May 2016

Sr. QA Analyst

The First Marblehead Education Resources (FMER) Web Front End initiative (Wife) is one of several projects to align technology with FMER business objectives. The Web Front End will be the primary mechanism by which consumers initiate loan requests with FMER. The Web Front End is intended to provide consumers with a web based facility in which they can apply for a loan, enter into a formal credit agreement, find information about the current status of their loans and know that their personal information is securely protected from unauthorized access. WFE is designed and developed using multi-tier architecture, JSF, Spring, Hibernate and JMS.

Roles & Responsibilities:

Identified the test cases to be automated and performed data driven testing and GUI Check Points using QTP.

Developed detailed test plans and summaries which include the software release, defined resources, dependencies, risks, strategy and test suites required for each test cycle

Performed SQL queries to update and verify test data stored in database for validation and supporting technical testing requirements

Performed manual end-to-end testing on new functionality and regression test sets

Performed debugging which included checking system log files on problematic issues before turning the defect over to development

Participate in project initiation meetings, understand and provide high level and detailed estimates for resource planning

Provided technical and usability support to customer support team on day to day basis

Environment: HTML, Java, J2EE, WebSphere, Oracle 10g, Windows, TOAD and SQL Developer, HP Quality Center, Quick Test Professional

PHCS, Waltham, MA Jan 2014 – Feb 2015

QA Analyst

The Web Provider Nomination is a web-based application that provides Customer (Carrier), Member (Consumer) and Internal PHCS user the ability to nominate a provider. This will also allow processing, maintenance, tracking, reporting, sending communications, as well as other Admin functions through PHCS website. The application will contain both Internet and Intranet components. The Provider Nomination has an n-tiered architecture based on Java and J2EE Framework technologies.

Roles & Responsibilities:

Participated in all aspects of STLC testing including Integration, Functional, GUI, Regression, User Acceptance (UAT), System Integration and Database (Back end) testing.

Analyzed Requirements and Functional specifications, designed the Test Approach and ensured clear definition of roles and responsibilities.

Involved in the development of the Test plan - Approach, scope, resource assignments & schedules and Testing Strategy.

Responsible for preparation of test scenarios and test cases from use cases and requirement documents.

Developed Requirements Traceability Matrix to map the test cases with the Requirements.

Prepared Test Plan and Test Cases in Quality Center based on the system/functional requirements.

Created & Executed Test Procedures manually before using the automated testing tool QTP.

Involved in back end testing by using SQL queries and scripts.

Supported UAT testing team in execution of scripts and data setup.

points and used correlation functionality.

Produced status reports and interacted with QA and development team members while revising the test documents to address new requirements.

GalaxE Solutions Inc, Somerset, NJ Oct 2013 - July 2014

Role: Performance Tester

Producing and maintaining test specifications and functional test cases by analyzing business requirements documents provided by the client.

Involved in developing Performance QA strategy and in writing and implementation of the test plan and various test cases.

Used HTTP Watch to do Manual Testing of the flow to check the response time with single user on the system.

Created Vuser scripts with VuGen and enhanced them with correlation, parameterization, check points, and user-defined functions as well as LoadRunner functions.

Created different Scenarios in Controller for different types of tests.

Calculated pacing by gathering requirements from previous release.

Performed capacity testing on the Enhancements by using the Schedule by Group in Controller.

Executed various tests like Single User Test, Load Test, Capacity Test.

Experienced in handling of Vusers more than 1000 in load tests.

Worked on Throughput, Hits per seconds, Network delays, latency, and capacity measurements and reliability tests on multi - layer architecture.

Scheduling the scenarios using the Load Runner's Controller and analyzing the results using Analyzer.

Performed smoke testing by checking the build release from the developers.

Performed Regression testing after logging defects.

Involved in database testing by writing SQL queries and using data base functions for automation.

Worked on Throughput, Hits per seconds, Network delays, latency, and capacity measurements and reliability tests of on multi - layer architecture.

Monitored Server Performance using Perfmon.

Used Hp Openview to monitor Resource Utilization on servers for the test run duration.

Involved in scalability and bottleneck testing of application.

Ability to diagnose Web/App server performance issues/troubleshooting using Load Runner Java Diagnostics/Deep Diagnostics.

Actively participated in Defect Review meetings daily and provided weekly management status reports and coordinated meetings between test team and development team to review defects.

Worked with developers, business and release managers in bug fix issues and in meeting project deadlines.

Environment: Java, Load Runner 11.5, Quality Center, Oracle, Windows 7, MS Office 2007, Agile, WebSphere, Toad, Oracle, SQL, HP Open View.

Baker & Taylor,New Jersey Nov 2011 - Dec 2012

Consultant - QA Software Engineer

Tested dynamic, database-driven applications with high-capacity web interfaces including functional, usability, browser compatibility, performance, installation, load and stress tests using QuickTest Pro (UFT) and manual processes.

Extensive experience with Windows NT and UNIX server environments; thorough knowledge of Internet standards (HTML, HTTP, CSS, CGI, etc.), web site design principles and software usability practices.

Tested web-based software applications on versions of IE and Netscape for OS compatibility.

Developed and executed test plans and test cases. Tracked defects using internal tracking software.

Baker and Taylor (continued)

Analyzed test results to provide assessments to management for project stability.

Demonstrated leadership skills as a mentor to the software quality assurance team members.

Conducted feedback/project meetings.

Professional experience:

DRS tactical systems, Melbourne, FL 05/10/07 till 09/25/2010

Associate engineering technician

Performed Software.

Test operator

Perform pilot production test for various mechanical and electrical partsrelated to

Defense-related Equipment.

Assemble circuit board related to electrical instruments with utmost

precision.

Reliance web world express, Surat, India 07/08/05 till 02/08/06

Customer care specialist

Solved various technical problems related to cellular phones.

Completed various cellular phone related network infrastructure projects

to enhance

Software quality.

Refurbished defective instrument.

Performed quality check on refurbished instrument to eliminate any

technical defects.

.

Education

Computer engineering

Government polytechnic for Girls university, Surat, Gujarat state, India.(2005)

(Honored with principles scholarship for completing school management project)

Environment: HTML, Java, J2EE, JBoss, Oracle 10g, PL/SQL Developer, UNIX, Mobile devices, Selenium, HP ALM.

Environment: HTML, Java, J2EE, WebSphere, Oracle 10g, Windows, TOAD and SQL Developer, HP Quality Center, Quick Test Professional..

Reliance Web World Express, India June 2005 – Feb 2006

Customer care specialist

Solved various technical problems related to cellular phones.

Completed various cellular phone related network infrastructure projects to enhance software quality.

Refurbished defective instrument.

Performed quality check on refurbished instrument to eliminate any technical defects.

Contact this candidate