Test Cases Quality Assurance

HARMANDEEP GROVER

206-***-****/*************@*****.***

SUMMARY

Six (6) years of experience in the field of quality assurance, business analysis, business process design, project management, streamlining, object oriented analysis, system analysis and design software verification and validation

Proficient in system, functional, regression testing of client/server and Web based applications, with working knowledge and business experience in Telematics, retail-point of sale, healthcare and commercial insurance diverse domains (Guidewire), Mobile testing

Extensive knowledge in all phases of Software Development Life Cycle (SDLC)

Expertise in Manual Testing/mobile application testing for ios, Android (Mobile) applications, client server applications and cloud applications.

Experienced in software testing including development of test cases and test scripts and User Acceptance Testing (UAT)

Strong analytical and QA/testing skills, capacity for work and diagnostic ability

Experience in Agile and Waterfall models of SDLC

Experience in Software Testing and Web services API Testing,

In-depth knowledge of all QA phases which include manual, functional, system, integration and end-to-end testing

Test designing experience with respect to the core business requirements, demonstrating their application into use cases and test cases

Knowledge in preparing test plans, test cases and test scripts

Proficient in testing the GUI,MQ and functional aspects of client-server and Web based applications at all stages of the SDLC and Testing Lifecycle (STLC)

Well versed with ISO’s insurance rating rules and standards

Knowledge of insurance factors and Algorithm check through Rivvt tool

Provided UAT support and production support for commercial insurance business

EDUCATION

Bachelors in Business and Technology, Eastern Washington University, Bellevue, WA

SKILLS

Operating System Windows XP/Vista/7/8, Macintosh OSX

Software Test Tools HP Quality Center (v 10, 11), HP Quick, Test Pro (v8.2), JIRA, Bugzilla, and

Microsoft, Test Management, TFS2010, SOAP UI, RESTFUL

Business Tools SharePoint, Outlook, Excel, Visio, Word, PowerPoint

Web Browsers Microsoft IE (7, 8, 9, 10), Mozilla Firefox, Google Chrome

Insurance Tools Automated Quote System (AQS), Guidewire-Policy Center, APPS, Rapid Sure,

HV Access Express (AE), ISO, RIVVT

Telematics Tools Admin portal, My Subaru customer Web portal, My Subaru Mobile App, Aria,

Subarunet

EXPERIENCE

Apr ’17 – Nov ’17 Sr. Quality Analyst, Subaru of America, Cherry Hill, NJ

Telematics, Subaru StarLink

Subaru of America, Inc. (SOA) is the U.S. sales and marketing subsidiary of the Subaru Corporation of Japan and is responsible for the distribution, marketing, sales and service of Subaru vehicles in the United States. Subaru implements the Gen-2 Telematics projects for its new vehicles being released in 2018 and involves Starlink subscriptions for new customers on their Mobile App, Customer web portal and Subarunet dealer Portal. MySubaru mobile App StarLink subscription includes safety, remote and concierge services. I worked with the billing subscription part of the project for retail, finance, lease, showroom, dealer demos and the Subaru Service Loaner programs.

Involved in the starting phase of SDLC and test inception/planning

Managed the testing efforts for various state plans for Subaru

Performed manual testing for Subaru web site across multiple browsers (IE, Firefox, Safari and Chrome).and mobile devices (Android, iOS).

Tested release candidate’s updates and MySubaru app updates on multiple operating systems and devices.

Facilitated test planning/management for Subaru subscription plans on a larger scale

Worked on retail, finance and lease plans

Created traceability Matrix for large scale data for several states

Defined test strategies to verify the billing and subscription activities for Telematics

Derived the scope of testing by identifying the data flow from the Aria billing system and Chase paymentech

Verified Aria/Chase pre-built that connects to processing payments/collections and attempts at enrollment on a re-occurring basis and throughout dunning

Verified Vertex O-Series to calculate taxes for all chargeable transactions in Aria

Developed functional, acceptance and system test cases based on business requirements

Created and executed manual software test plans, cases and scripts to uncover, identify and document software problems and their causes

Documented software defects using the bug tracking system JIRA and reported defects involving program functionality, output, online screen and content to software developers

Worked with the offshore/onshore team’s execution approach

Involved in project coordination and implemented Test methodology

Designed and performed large scale load volumes and end-to-end testing using large data files

Delivered thorough QA testing reports that determined the product quality and release readiness

Took a proactive approach to improving test coverage and quality control efficiency

Environment: Oracle AIM Methodology, EBS application, Java, MS-office, MS-Visio, SharePoint, Service-Now, JIRA

Nov ’15 - Apr ’17 Sr. Quality Analyst, Philadelphia Insurance, PA

APPS Mitigation

This project is on the APPS (Access Phly Processing System). APPS is currently a billing and claims system. The objective of the APPS mitigation project is to mitigate the billing activities, build database (Helper DB) to hold coverage information and to enhance APPS functionality such that it would act as a billing and claims system for the existing policies and only claims systems for new/renewed policies. This project involved basic test planning, test designing and test execution for the multiple lines of business into Philadelphia commercial insurance that was managed by a leading IT consultant, NTT DATA.

Involved into the starting phase of SDLC and test inception/planning

Worked on the commercial automobile/general liability and commercial property’s LOB’S

Created trace books to map large scales of requirements and planning testing based

Defined test strategies to verify the billing activities and financial information that are not present in APPS. Also, I built strategies to verify policy shell service which would load new/renewed policy minimal information and coverage verification service which loads coverage information in a newly built HelperDB to handle claims and endorsements

As this project happens to be on a monthly release, built core regression suites to ensure the suites were enhanced at the end of each release. The objective of this core regression suite was to build automated regression suites

Derived the scopes of testing by identifying the data flow from the rating systems and GuideWire data hub. Verified the test coverage of requirements, HelperDB, Stored procedures/Jobs and initiated ideas of SOAP UI, RESTFUL tests to handle negative scenarios in building new services.

Responsible for preparing Web Services Testing Test Plan.

Verified Web services API request, response data validations in RESTFUL, SOAP protocols.

Responsible for creating Test Environment for Web Services testing.

Built complex SQL queries (Microsoft SQL Server) to derive test data and verified newly built HelperDB, which is the place holder for policy coverage’s

Worked on the test planning for the stabilization phase, to hook APPS QA with other integration teams QA/SIT regions and tested the integration points

Developed functional, acceptance and system test cases based on the business requirements

Generated test scenarios, executed tests cases and reported the test results

Documented the defects in HP ALM and assigned to the development team

Managed exports of Excel based test planning for the HP ALM suite

Worked with the offshore-onshore team execution approach

Involved in project coordination and implemented Test Methodology

Designed and performed large-scale load volumes end-to-end testing using large data files

Environment: Quality Center 9.0/10.0, Quick Test Professional 9.5, SQL Server 2005, MS OFFICE, Visio, Windows XP, MTM, TFS, ALM, Guidewire-PolicyCenter, Rapid Rating System, UFT/QTP

Feb ’12 - Nov ’15 Sr. Quality Analyst, Nationwide Insurance Company, Harleysville, PA

Commercial Lines Transformation/Guidewire Integration

Harleysville Insurance Co is a leading commercial insurance provider with roots in the state of Pennsylvania. Currently it was acquired and merged with Nationwide Insurance. This project was an integration of selected commercial lines business for the state of PA. Guidewire was integrated with Nationwide and its partner’s internal applications. Requirements were identified with formation of business approved use cases and further testing was charted based on that.

Nationwide mobile application allows the users to get real time streaming quotes and manage

accounts. The application was developed for Android and IOS platforms.

The main functionality of the applications are to write and buy a policy . Addition to that, the user is also able to access all of the accounts, receive real time account alerts.

Involved into the starting phase of SDLC and test inception/planning

Created time milestone charts and devised sprints to get into scrum-agile way of test efforts

Created trace books to map multiple initial requirements and planned testings based on the information

Worked on Commercial Crime and Fidelity line of business that covers the standard crime policy and government crime policy

Worked on liability insurance line of business that covers general liability, professional liability and workers compensation policy

Created test plans and regression test cases for these insurance lines of business

Worked with the offshore-onshore team’s execution approach

Filed output batch jobs which was done the next day of initial functional tests as part of combined regression test over UFT/QTP

The Guidewire policy center was integrated with Harleysville’s internal quoting tool, and access express

Fundamental changes were initiated to customize the policy center with Nationwide’s business interest

External validations like VIN check, MSB valuations and API map integration were a major phase for this assignment

Several features in terms of policy renewals, submission, BOP coverages were developed and designed together as part of related Sprints

Commercial automobile and business owner’s policy were the lines used for this assignment

Worked on C8 product codes which includes fidelity inland marine, auto and workers, compensation line of business that covers the standard inland marine, auto and workers compensation policy

Worked on C3 product codes which includes commercial property, general liability and workers compensation line of business that covers the standard commercial property, general liability and the workers compensation policy

Managed export of Excel based test planning to Microsoft test management suites

Developed functional, acceptance and system test cases based on the business requirements

Used SQL queries to verify the data from the Oracle database

Environment: MTM, TFS2010, MS Excel, IE-8/9/10/11, Windows XP/7/8, MS Access, Automated Quote System, Guidewire-PolicyCenter, Access Express, Connect5

Contact this candidate