Vijay Kumar Phone: 614-***-****
Email: ********@*****.***
SUMMARY
15+ Years of Total IT Experience as Senior software QA analyst / tester with full system development lifecycle (SDLC) experience, including designing, developing and implementing test plans, test cases and test processes fueling swift corrective actions, significant cost savings and fault-free audits.
Proficient in manual and automated testing in client/server and web based applications for HealthCare, Insurance, Financial Banking and Retail companies
Quality Assurance expertise includes testing experience using Functional, Smoke, User Interface, Integration, Regression, Black Box, and Database testing.
Performed System level Load, Stress Testing, Performance and UAT testing in couple of projects
Proficient in writing Test Plan, Test Scenarios, Test Cases, Test Estimating, Traceability Matrix, Testing Status Report, Knowledge Transfer documents
Experienced in logging defects, tracking and provide root cause analysis on criticality of defects and performed defect review meeting
Good experience in UNIX and SQL databases
Strong knowledge and experience in backend testing to validate data against database like Oracle, SQL Server using SQL DML queries languages
Well-versed and experience in complete software development lifecycle of project using Waterfall, Agile ( Scrum), V-Model and RUP methodologies
Good knowledge of project activities and actively involved in Setting up Test Environ
High impact communication (verbal and writing skills) – good experience of working in client location and interaction with various stakeholders like senior leadership, test coordinators, vendors, development/infrastructure team, business analysts, upstream/downstream contacts
EDUCATION
MBA from IASE University India
Graduation from Osmania University India
Diploma in Computer – Client Server Technology from ICSS India
TECHNICAL SKILLS
Testing Tools : QTP, Quality Centre, Load Runner, Win Runner, Test Director, Soap UI ((Web Services Automation)
Bug Tracking Tools : JIRA, QC, BugZilla
Scripting Language : Java, VBScript, SQL, PL/SQL
Database : Oracle 10g, SQL Server 2008, DB2, MS Access
Web Technology : HTML, XML, CSS
Operating System : Windows, Linux, UNIX
SDLC Methodologies : Waterfall, Agile (Scrum), V-Model and RUP methodologies
Other Tools : MS-Office, MS-PowerPoint, and MS-Excel
EMPLOYMENT HISTORY
American Family insurance Madison WI July 2016 till March 2017
QA Lead Consultant
American Family Insurance is the right mix of American Family's auto, home, life, business, health, and farm & ranch insurance, as well as retirement products. This project involves Testing of filenet which is used by Guidewire policy Center, Claim Center and 14 other applications.
Responsibilities:
Analyzed Business Requirements document for developing Test Plan, Test Cases and providing the Test Estimations per session and prioritize the Test Cases
Implemented QA methodologies, strategies, and plans in all stages of SDLC
Involved in Updating Use cases and Preparation of Test scenarios
Performed negative and positive testing for the application
Played significant role in System testing, Work flow Integration testing (WIT), regression testing and involved in User Acceptance Testing (UAT) Sessions
Assigning, Validating, Monitoring the off shore team.
Performed GUI, Functionality, Security, Positive and Negative testing
Written test scenarios and detailed test cases
Participated in all the meetings to discuss Defects and like scenarios
Work in the Agile environment
Created and executed manual test cases using Quality Center. Documented the test cases and created the requirement traceability matrix to demonstrate the test coverage
Testing the work flow of Guidewire Policy Center
Documented and reported all found defects in Quality Center
Defect Tracking and Defect Report Generation are prepared using Quality Center 11
Interacted with Module lead, business analysts, team lead, Manager and users to analyze the business requirements and functional specifications documents.
Environment: HP Mercury Quality Center, JIRA, SOAP, Guidewire policy center, SQL, Visual Basic, MS Office, Agile.
Health Stream Inc. Nashville TN Sep 2015 June 2016
Sr.QA Lead
Health Stream provides Internet-based learning and research solutions for healthcare organizations. This project involves working with project stakeholders and cross functional Business SMEs to understand the business requirements and functional specification, develop the testing strategy and execute test cases in agile methodology ensuring the product meet the business requirements.
Responsibilities:
• Working on Agile methodology. Participated and Coordinated daily stand-up meetings for Agile.
Writing and executing User Stories.
• Preparing Test Strategy, Test Plan, Testing Estimates, and Timelines along with Team lead.
• Involved in implementation of Test Strategy
• Responsible for running test cases and posting defects
• Using Selenium Web Driver designed test cases and design Data driven Framework.
• Preparing and documenting the test conditions and test cases
• Responsible for Functionality testing and regression testing
• Writing high quality test cases for finding hidden defects using techniques boundary value analysis, looping, code statement coverage, equivalence partitioning and impact analysis coverage.
• Have Written Test cases both for Web based and Windows based applications
• Review of the test cases written for unit and integration level.
• Developed complex SQL queries during End-to-End testing stage.
• Responsible for running test cases and posting defects.
Environment and Tools: Agile, PL/SQL, API, Oracle11,.Net, ALM11.0, .NET, Mingel, SharePoint, Windows, Unix.
Volkswagen Credit Inc., Libertyville, IL Jan 2014 – Sep 2015
Sr.QA Analyst
A leader in the credit and funding of high technology vehicle products for industrial, commercial, and consumer markets.
Responsibilities:
Analyzed Software Requirements documents and Business Requirements documents to get a better understanding of the system on both a technical and business perspective.
Involved in Preparing the Test Strategy Document, Test Estimation, Test Scenarios, Test Cases, Test Environment, Test Execution, Test Execution Report, Traceability matrix for all modules
Developed test cases in excel and uploaded them into QC
Performed GUI, positive, negative, data driven, smoke, functional, integration, regression, end-to-end and fail over testing Conducted functional regression testing for each build using QTP
Conducted test case review meetings and documented, and periodically updated the QA test plan, process and procedures
Tested compatibility of application with Internet Explorer, Netscape Navigator
Developed QTP data driven testing frame work to improve the test coverage and test execution for positive and negative testing
Reviewed project artifacts, analyzed requirements, provided daily status report that includes testing metrics, test logs and test summary reports
Worked in an agile software development environment and attended daily scrum and sprint analysis meeting
Participated in Daily stand up, Weekly QA status meetings and coordinated with the Developers and Testers to resolve and close defects
Involved in Preparing the Status Reports Every Week, which includes Revision History, test case status, metrics, QA Issues and Defects
Interacted with developers to get an ETA on defects status on a daily basis
Participated in UAT Testing with the users
Involved in moving all the Test Cases for all modules and Reporting from Microsoft Excel in to Quality Center
Porting of Requirements, Test Conditions, execution of scripts, analysis of results and graphs, bugs /issues tracking and management done through Quality Center.
Environment: Manual, Quality Center, MQ Series, XML, Autosys, IE, VB.NET, ASP.NET, Oracle, MS Word, MS Excel and Windows 2000
State Auto Insurance, Columbus, OH Jun 2012 – Dec 2013
Lead QA Analyst
The State Auto Group is rated A (Excellent) by the A.M. Best Company and consists of State Automobile Mutual, State Auto Property & Casualty, State Auto Ohio, State Auto Wisconsin
Responsibilities:
Analyzed Use Cases and Business Specification Documents (BSD) on the following functionalities including Create/Report a Claim, Search Claim, Check status of Claim on-line by using Claims Transformation program.
Working with Software Configuration Management (SCM) team of Claim Center from Guidewire which provides flexible core systems that enable you to deliver insurance the way system suite spans the entire property/casualty (P/C) insurance lifecycle-underwriting, billing, claims, and reinsurance management.
Communicated defects to developers and log bugs encountered in Quality Center during test execution phase, create defect tickets, and followed-up with appropriate developers until all issues were resolved.
Performed functional, negative, regression and smoke tests on enhancements to the web application.
Mapped requirements with Test Cases in Quality Center and executed them reporting a pass or fail status.
Exported Test Requirements and Test Cases from Excel and Word to Quality Center.
Performed the backend testing to ensure data consistency on frontend by writing and executing enterprise level complex SQL statements against oracle database using TOAD
Managed, Documented and Controlled all the test cases, test scripts and test results using Quality Center
Provided QC generated test execution result status in MS Excel
Participated in Daily stand up, Weekly QA status meetings and coordinated with the Developers and Testers to resolve and close defects.
Environments: QTP, QC, DB2, Mainframes, SharePoint, MS-Excel, SQL, Guidewire Claim center,windows,SQL,.Net
CitiGroup, Columbus, OH Sep 2009 – Jul 2012
Lead QA Tester
Citi Group is comprised of diverse financial services globally Its clients are top corporations, financial institutions and governments in countries around the world dealing in Fund Accounting, ETF, Portfolio management,SunGard, Envoy, ETF, and Custody.
Responsibilities:
Understanding the requirements and business flow of the requirement document
Prepared and Executed test Plans, test Cases and test Procedures using BRD and FRD prepared
Wrote SQL queries to perform test cases validation against back-end Oracle and SQL Server database by retrieving the data from the tables
Performed smoke, functional, black box, integration, regression, compatibility and end-to-end testing
Tested application on multiple application servers like Web Logic Application server and Web Sphere application server.
Tested Mobile digital applications by validated the functionality test cases against the functional specifications
Quarrying the data from and validating from MF to Infocenter.
Performed GUI, positive, negative, data driven functional end to end and fail over testing.
Created and enhanced function test scripts using Quick Test Professional (QTP) to automate the application and test the End-to-End Functionality.
Ensured traceability of test cases back to project requirements and participated in walk through of test cases
Planned and reviewed the UAT test cases.
Conducted security penetration and tested the application.
Conducted UAT Testing.
Performed Regression and Navigation testing of the Mortgage application.
Reported the bugs, Email notifications to the developers using the QC.
Tested the connectivity between ETF and SunGard (InvestOne)
Reported and coordinated in retest of the defects.
Environments: Quality Center, SharePoint, POS, Oracle, ETL- Data Warehouse, Load Runner, .NET, SOAP, (Solaris), FIX protocol, Web Logic Application server, Web Sphere application server, Control M, Autosys, MS Word, MS Excel, Windows XP.
National City Bank, Zanesville OH Jan 2006 – Aug2009
QA Tester
Responsibilities:
Analyzed the functional requirements of the application and developed Test Strategy of the application and ensured the entry and exit criterion's.
Whitened and implementation of the test plan, test cases, test scripts and creating scenario for load testing.
Used Mercury Quality Center for Defect tracking.
Responsible for performing Functional Testing by creating Manual and Automated Scripts.
Manually tested the whole application before going for the Automated Testing by QTP
Performed Front End Functionality, GUI and Regression Testing of the web-based application.
Generated RTM reports (Requirements Traceability Matrix) and organized weekly status meetings for Test effort metrics
Performed Data Validation followed by the Manual Testing of back end.
Checked the data flow through the front and back-end and used SQL queries to extract the data from the database.
Followed the UAT strategies as per test plan.
Carried out GUI, Functionality, Integration and Regression testing
Extensively used SQL queries for validating the data.
Analyzed the testing progress by conducting walk through meetings with internal quality assurance groups and development groups.
Participated in various meetings and discussed Enhancement and Modification of Request issues.
Prepared required document to setup test environment.
Environment: Java Applets, JSP Servlets, POS, Oracle 8i, UNIX, Windows, Automated UI Testing, Microsoft Lab Management,Load Runner, Rational Robot, Quick Test Professional ( QTP ), IIS, Web logic, Star Team Professional and Visual Source Safe.