SUMMARY:
9+ years of diversified experience in complete SDLC life cycle with analysis, design, testing and maintenance of business applicationexperience in Manual, Automated and Performance testing utilizing Mercury Interactive tools on web based and Client/Server applications.
Good knowledge of STLC methodologies and complete project life cycle. Experience in using Automation testing Tools Quick Test Professional (QTP), Win Runner Load Runner Extensive experience in bug tracking and test management tools like Bug Zilla, Mercury Quality Center, Rational Clear Quest, Performance Center Strong in analyzing the requirements and developing Test Plans and Test Cases. Strong skills in performing Functionality, GUI, System, database. Usability, Unit, Regression, Integration, Data Driven, Load, Stress and performance testing. Proficient in preparing Test Plan, Test Cases, and Test Scripts, design and execution of various test scripts using QTP Successfully implemented Automation Frameworks (Data driven, Keyword driven & Modular) for QTP 8.2, 9.0 and 9.5. Experienced in understanding data modeling concepts, TOAD, SQL, creating XML data and working knowledge of XML. Strong Skills in using testing methodologies and Functionality Testing, Integration Testing, System Testing, Business Function Testing, Performance Testing, Stress testing and Configuration Testing. Extensively involved in Back end Database testing using ORACLE, DB2, PL/SQL AND MS SQL. Design, development, implementation of automated functional testing strategy with HP suite (Quick Test Pro, Load Runner, Quality Center), Rational Suite (Test Manager, Clear Quest, Clear Case). Comprehensive understanding of Quality Center Defect Module, which supports the entire defect lifecycle—from initial problem detection through fixing the defect and verifying the fix. Experience in working on different domains like: Insurance, Banking, Healthcare and Finance. Strong experience in Database/Backend testing using MS SQL Server, Oracle, Toad and SQL queries. Extensive experience in developing VB Script and maintaining Test Scripts for Automation Testing using Descriptive programming in VB Script (methods used were CreateObject(), WaitProperty(), Description.Create(),ChildObjects,FileSystemObject(),QCUtil.Connection(), Arrays() Proficient in quick test in customization and creating various checkpoints, synchronization points, parameterization (data-driven test) Extensive knowledge of QA methodology, standards and procedures such as creating Test Strategy, test plans, test cases, test script generation for regression and user acceptance testing. Specialized in analyzing the functional specifications and writing detailed test plans, test cases, execution of test scenarios, analyzing the actual results against the expected results. Excellent knowledge in Load/stress testing and expertise with Load Runner, VUGen, Controller and Analyzer. Experience in working with Java/J2EE, .Net, VBScript, XML, Visual Basic, Oracle, SQL and VSS ability to prioritize tasks well and work on multiple test projects at the same time. Extensively used Virtual Source Safe (VSS) for integrity and maintenance of all kinds testing related docs. Experienced in testing applications developed specifically on the Mainframe with TSO2
Technology Background
QTP 9x/10.0/11.0,Load Runner 9x/11.0, Performance Center 11, Bug Zilla, Quality Center and Rational Clear Quest, Bug Zilla, Quality Center and Rational Clear Quest, Oracle 8i/9i, DB2,ODBC,MS-SQL Server 2000/2005, DB2, MS-Access, MS Office, MS Project, Toad for Oracle 9i, SOA, VModel, Waterfall Model, Agile Model, Windows 95/98/00/NT/XP/Win7, MS-DOS, Java, SQL, PL/SQL, VB Script, .NET, HTML,J2EE,VBScript, , Visual Source Safe
Educational Qualification : Master of Computer Application
PROFESSIONAL EXPERIENCE:
Quality Assurance Analyst
Confidential,Philadelphia,
(Public Company; 5001-10,000 employees; LNC; Financial Services industry) Nov 2009—Present
Lincoln Financial Planners will be using the online reporting solutions to view and manage the client\'s portfolios. There are internal applications Inforce, IPS, CRM, Portfolio Manager, Hub 2.0, ForeSight, I wrote automation script and performance script for all the above applications.
Responsibilities:
Develop and design test Structured Automation Frameworks in collaboration with the Testing team and Development teams in QTP & Quality Center workflow. Develop Functional/Regression automated testing solutions using QTP, traditional QTP framework, and/or Data Driven techniques, descriptive programming Used Automation of regression testing QTP by creating verification points e.g., objects data, object properties, window and image verification, database verifications for testing functional, acceptance and limit validations. Also inserting synchronization points. Responsible for inserting checkpoints to verify the functionality of page, text string, XML and table objects. Created batch scripts to automate the execution of the recorded scripts. Evaluate, plan, design, develop, and maintain test scripts using a Framework for new applications and/or enhancements to existing applications. Wrote automation code in order to verify data displayed matches in two different environments, used descriptive programing using the method Description.Create(), ChildObjects Developing the VB Scripting and fully Descriptive Programming within Quick Test Pro. Programming with VBScript to write Reusable functions, and setting up the startup files for the Loading the libraries and configuration in QTP. Manually performed Back-End testing by writing SQL queries and validating the database using Complex SQL Joins and Functions. Converted manual Test cases and scripts into automation using Quick Test Pro. Continually updated Traceability for all the artifacts through Trace Matrix and set up process to capture of standard Test Reporting Metrics. Created Load test scripts using VU-GEN and enhanced them using C, Ajax TrueClient Extensive Parameterization of the VuGen scripts to ensure the real time load conditions. Configured and ran scenarios in Controller using scripts created in VU-GEN. Analyzed Performance Bottlenecks using LoadRunner Monitors and Graphs. Performed load testing (HP - Load runner, Load generator, Load controller and Load Analysis tools) executed scheduled tests and analyzed the test results. Used Performance Center to run the load test. Communicate test progress, test results, defects/issues and other relevant information to project stakeholders and management. Weekly Status meeting with Development and Management teams to discuss bugs and other issues.
Environment: QTP 9.5/10.0, LoadRunner 9.5, Quality Center 9.2/10.0,VBScript, ASP.net, C#, C, C++, HTML, JAVA, J2EE, JavaScript, XML, Ajax, IIS, SQL Server 2005, Oracle 10g , Win Server 2003, Visual studio 2008, MS - VSS, TOAD, Support Process tracking tool, HP Performance Center 11, Ajax TrueClient
Confidential,San Francisco, CA May 09 to Till Oct 09
Project Name: Health Benefit Service
Sr. Web Automation Engineer
The Health Savings Account (HSA) Platform Transformation project is a multi-phase project to position WF Health Benefit Services (HBS) to be a leader in the Health Savings Account (HSA) industry.
A HSA account is a special account owned by an individual used to pay for current and future medical expenses. HSA accounts have been in existence since December 2003 and participants must have a “High Deductible Health Plan” (HDHP) to be eligible to establish and contribute to an HSA account. It is the sole responsibility of the individual to confirm whether or not he or she is eligible to have a HSA account, not the financial institutions.
Responsibilities:
Analyzed requirement specs and design specs, creation of Test Plans, Test Cases and scenarios using Quality Center and took responsibility for complete feature/component testing. Developed test cases for data driven scenarios in Quality center using Dummy Data. Created Reusable and component specific functions using VBS file in QTP. Responsible for data validation by executing SQL queries on database by using ADO connections with Access database. Performed data driven testing on QTP Scripts to invoke data from Excel data files Involved in parameterized the fixed values in checkpoint statement, create data tables for the parameters and write functions for the parameters to read new row from the table after every iteration Executed Batch test using Test Batch Runner in QTP and Quality Center. Performed both manual and automated tests to conduct functional and regression tests on the application. Automated the same using QTP Wrote Reusable action for MainFrame screen to get data and compare with DB Conducted Functionality and Regression testing during the various phases of the application using VB Script Created Function Library using vbs file and Object Repository to check the application functionality. Used Checkpoints and Synchronization points to check the attributes of the application Responsible for executing the test cases and reporting the bug in Quality Center. Used QTP Features like Data Driven Testing, Object Identification, and Recovery manager. Used Descriptive Programming to handle dynamic Objects. Performed Load testing- created vugen script, correlation, parameterization, controller, analyze the result
Environment : Quality Center 9.0, Windows XP Professional, Clear quest, QTP 9.5, J2EE, JDBC, Servlets, XML, Web logic, Oracle,Load Runner 9.5
Confidential,Falmouth, ME Jan’ 2009 to April 09
Project Name: Commerce Integration
QA Automation Engineer
TDBanknorth is one of the 15 largest commercial banks in the United States providing a full range of financial products and services with locations from Maine to Florida. TDBanknorth and TD Bank are trade names of TD Bank.
Vector Exceptions is an Internal Bank Application. The functionality of the Vector Exceptions Application is to verify and process bank cheque transactions. The various modules of the Application are BOFD(Bank of First Deposit), Decision By Account, Decision By Item, Fraud Review, Decision By Account, Decision By Item, Fraud Review, History Reports, Routing Numbers, Referred Items, Security, Upload/Download, User Statistics and Work Status.
Responsibilities
Used Descriptive Programming in VBScript used Description. Create (), Create Object, Child Objects ()) to develop the Automation scripts, Performed Data driven testing using data tables in QTP Created Pop-up, Object State Exception handling functions to handle unexpected events and errors that occur during a test run. Involved in SOA system testing such as Web services, mid-tier services and GUI aspects, Response time, Number of transactions passed/failed, Load size, Memory utilization, wait time Mainframe Process Test Case Development, Defect Management using Mercury Test Director. Wrote Reusable actions and test script using vbscript as per the scripts Reviewed use case documents, Used Mercury Quality Center for web-based system for automated software quality management and testing across a wide range of application environments. Automated the Test cases using QTP for Regression testing. Designed and Developed Test Cases for automated testing using QTP, Quality Center. Involved in Database Testing using SQL queries, Data validity testing, Data Integrality testing, Performance related to data base, Testing of Procedure, triggers, transactions (begin commit rollback) and functions Installed TE add in and Used TSO to write actions using VBSCRPT on QTP to get data from the mainframe screen and compare with the database Used various QTP check point including database check point Built Object Repository (.tsr), Function Libraries and Recovery Scenarios. Developed Virtual user scripts using Load Runner VUGen to perform the load, volume, stress and capacity testing, and reported bugs using Rational Clear Quest. Created scenarios using Load Runner Controller and executed them. Customization and Environment set up for Quality center and maintaining all scripts under the Quality Center and used the Quality Center as central repository to maintain the different releases test cases. Environment: QTP 9.5, Quality Centre 9.2, VB Script, Mainframe, TSSO, .Net, Windows XP, Oracle 9i, SQL-PL/SQL, Toad, Test Director, Load Runner 9.2
Confidential,California March 2008 – Dec 2008
QA Analyst
Description
STAR Financial Bank, an Indiana-based community bank, is known for its quality service culture, personalized banking solutions, and innovative use of technology. Additionally, two wholly owned subsidiaries, STAR Wealth Management and STAR Insurance Agency, offer licensed professional services in financial planning, trust and asset management, and insurance. STAR Financial Bank has grown to more than $1.4 billion in assets with more than 40 banking centers in central and northeast Indiana. The project I was involved with was Wealth Management and Financial Planning, Client Suitability Checking sub-module.
Responsibilities:
Utilized Mercury QuickTest Pro to design, code, and maintain large data-driven scripts to perform new order processing and existing order modification. Relied heavily on the programming capabilities of the VBScript. Created Standard, Text check points in Test scripts. Wrote Reusable actions as per the scripts Reviewed use case documents, Automated the Test cases using QTP for Regression testing. Performed load testing (HP - Load runner, Load generator, Load controller and Load Analysis tools) on various application by initially evaluating the system, develop test assets (use cases, test cases and test scripts), executed scheduled tests and analyzed the test results. Involved in Database Testing using SQL queries, Data validity testing, Data Integrity testing, Performance related to data base,Testing of Procedure,triggers,transactions (begin commit rollback) and functions Used SQL statements in Database Test using QTP output database check point Used Test Director to Add Requirements, Write Test Cases, Execute the test cases, Defect logging and Defect Tracking. Used Checkpoints to see the proper functioning of AUT and Parameterized Tests using Quickest Professional. Built Object Repository (.tsr), Reusable Actions (Useful for multi screens), Function Libraries and Recovery Scenarios, Maintaining “Review Log” for developed test scripts Analyze the Scope of Testing/ Validations to be inserted in the Automation scripts from SME. Environment : Windows NT, Linux Oracle, Web Logic, Java, J2ee, JSP, SQL, PL/SQL, eclipse, VB , VSS, QTP 8.2 , QC 8.0 ,Oracle 9i, Test Director, Load runner
Confidential,Mumbai, India Jun 2007 –Feb 2008
QA Automation Engineer
Responsibilities: Backend Database testing by writing and executing SQL queries to validate the data in the database Used Descriptive Programming in VBScript to develop the Automation scripts. Gathered Test Input data. Test Input data includes Pre-condition, Test Input, Test Result Performed Data driven testing using data tables in QTP Automated the Test cases using QTP for Regression testing. Performed database testing by writing queries in Oracle Used QTP output database check point Developing, authoring and updating test plans and test cases. Automated the manual test scripts using Win Runner. Inserted transactions to emulate the behavior of the browser under heavy load conditions. Performed Functional Testing, Regression Testing, Volume, and Stress testing Used Load Runner for Load and Performance Testing Created Load Scenarios, Scheduled the Virtual Users and Parameterized V-user scripts to generate realistic load on the Server. Used Test Director (Test management Tool) as Test Repository for Test plans, Mapping business requirements to Test sets, Analyzing Test Coverage with the help ofcoverage analysis matrix, Reporting new defects during the testing process by adding a defect record Environment: Windows 2003, UNIX, Win Runner, SQL, PL/SQL, ASP.Net, Java scripting, UNIX, Oracle 9i, QTP 8.0, Windows NT, C, C++/, SQL Server, XML, .NET Framework, ASP .Net, VB Script, HTML, DHTML, Load Runner, Oracle 8i , SQL and Test Director, QC 8.0