Praveen Konala

Sr QA manual tester / Lead

Profile

  • 12 years of Professional experience in Software Testing and technically proficient in Client server, Web based and Mainframe applications using various tools such as HP/ALM, Quality Center/Test Director.
  • Experience in complete Software development life cycle from analysis, specifications and design. Testing and maintenance of Insurance (Guidewire and others applications), Banking and E-Commerce applications, using Client Server Architecture, Internet and distributed computing systems.

Summary

  • Extensively used Mercury Interactive testing suite Tools like HP ALM, Quality Center and Test Director for various Web, Client Server and Legacy systems applications.
  • 8 years of experience in software quality assurance (SQA) methods, techniques, and tools.
  • 5 plus years of experience in P& C Insu, collaborating and testing in agile based test environment.
  • Experiences in Quality Management Processes, SDLC, STLC and exposure to Waterfall and Agile testing methodologies.
  • Worked on Guidewire application for close to 2 years.
  • Extensive experience on SQA tools - ALM Quality Center and Quick Test Pro.
  • Experienced in leading/coordinating onsite offshore teams.
  • Experienced in test planning, scheduling, monitoring.
  • Experience in review/analyze requirements and create Traceability metrics, test scenarios, test cases.
  • Experienced in regression suite maintenance, optimization, test data and test environment management.
  • Ability to plan, organize, and execute work tasks with strong problem solving and analytical skills.
  • Conducting walkthrough sessions with development and testing team through Build and Test phase.
  • Proficient in all aspects of Web Based Application Testing, Client –server app testing.
  • Extensively involved in different phases of testing includes Integration, Regression, System, User Acceptance Testing, Functional.
  • Experience in writing test plans, defining test cases, designing test strategies, developing and maintaining QTP scripts, analyzing errors and to maintain test data for automation.
  • Functional testing experience for a wide range of technical platforms and applications.
  • Logical and systematic approaches to test plan development and execution for functional testing needs for IT business applications including production support.
  • Functional testing experience for a wide range of technical platforms and applications.
  • Customer focused with excellent oral and written communication skills; ability to adjust to change, strong team and customer oriented interpersonal skills with a demonstrated ability to function as a consultant to customers on SQA matters.
  • Co-coordinated testing efforts to high-level management and isolated root causes to resolve the issues.
  • Good knowledge of Software Development Lifecycle & Testing Methodologies.
  • Experience with working on Mainframe and testing the Web Application to Mainframe Interfaces, worked on migration projects.
  • Experience in writing SQL queries against database including joints, unions etc.
  • Effective Team player, quick learner, self-starter, excellent oral and written skills.

Technical skills

  • Testing Tools: HP ALM, Test Director, Quality Center, QTP, LISA TIKLO, Jira, Clear Quest
  • Platforms: IBM Mainframe, and other IBM PC Compatibles, Windows
  • Database: DB2, Oracle, SQL Server
  • Domain Knowledge: Insurance, Healthcare, Banking
  • OthersPMSC, JCL, Control-M, Excel, Word, Visio, SQL, SPUFI, Microsoft project, Microsoft , SharePoint, Image write and Pinnacle document generator.

Trainings & Workshops

  • Software Development Life Cycle & Testing Fundamentals
  • Mercury Tools – Quality Center, Quick Test Pro & Load Runner

Educational Details

  • Bachelors in Computer application- from INDIA
  • Master’s in Public and Personal Management-from INDIA

Professional Experience

Compusoft – Farmington Hills-MI/Raleigh-NC Feb2017–Till date

Role: QA Lead

Description:Working on multi-line provider of business property &Auto insurance, personallines insurance (including auto, homeowner), agribusiness insurance, and surety bonds. Their products are distributed through a network of independent agents.

Responsibilities:

  • Working on Personal lines-Auto project, exposure and business knowledge on personal lines.
  • Using the dynamic GUI maps and testing all the dynamic links in the web page, Created GUI map files, generated the test scripts using context sensitive mode.
  • Actively involved in various meetings to discuss Enhancements and Modifications of the existing scripts.
  • Working as individual contributor and lead the testing efforts as needed, Coordinate with multiple teams (Off shore ) and train as necessary.
  • Created Use Case, Test Case and data mapping documents for the movement of data from Policy center as well as Billing system to the Operational Data Source (ODS) and from ODS to various down streams.
  • Perform Validation testing on the application navigation for various scenarios and reported the errors, conducted Functionality and Regression testing of the application.
  • Investigate software bugs and interacted with developers to resolve technical issues using HP ALM.
  • Compare and analyze the expected results to the actual results and documented the reports accordingly.
  • Prepare several SQL queries for validating, error tracking and balancing the data on both source and target table on production environments.
  • Develop test cases/test data for Pre-Production testing.
  • Test the application with real time data in production environment with various real time scenarios.
  • Test the application in 24X7 in Production environment. Handle production tickets and log the defects in HP ALM and track them.
  • Use Clear Case source control (version control) software for updating and modification the scripts and GUI’s have created views and used snapshot views in most of the scenarios.
  • Worked on Mainframe in checking the web based application quote matching with Mainframes or not.

Environment: HP ALM, SQL, Windows 7 ,SharePoint, SOUP UI, Mainframe, Java.

Wells Fargo Bank, Raleigh, NC Aug 2015 – Dec 2016

Sr.QA Analyst

Project: Global Expansion for Wholesale customers

Description: The principal purpose of the Global Expansion initiative is to establish Wells Fargo as the choice provider of international banking services for commercial customers in the middle market segment. By targeting strategic global markets – both developed and emerging – Wells Fargo will expand its global “branch” footprint and provide their customers with a consistent and competitive range of products and services, including credit products, foreign exchange, trade services and treasury management capabilities. Electronic Window references information from many source systems and puts the information from the multiple sources into a common context that the end user can easily understand (a transaction is a transaction, regardless of source). EW houses Previous-Day information, including Balances, Transactions, and Line of Credit Balances.

Responsibilities:

  • Gathered business requirements and created Traceability metrics wrote test scenarios and test cases.
  • Worked within the waterfall software lifecycle model from concepts to design and delivering through to formal release and maintenance.
  • Scheduled and performed testing services for SQA clients as needed including test script development, functional testing services, results reporting, documentation and training to application end users in UAT.
  • Validated EOD Transactions and balances on new GE Canada application. Compared the Intraday with the nightly run batch cycle previous day statements on the mainframe, to make sure all transactions have matching.
  • Involved in writing comprehensive test plans based on business requirements and technical specifications.
  • Worked as individual contributor and lead the testing efforts as needed. Coordinate with multiple teams (Off shore) and train as necessary within tight release schedules, for both short term and long term projects.
  • Created test cases and test procedures based on Functional Requirement.
  • Developed detailed Test plans, Test cases, Test execution scenarios, executed automated scripts using and generated status reports for work activities as needed by management.
  • Experience in writing SQL queries against database including joints, unions etc.
  • Prepared test data for test cases based on test plan and requirement document.
  • Manage all activities in the test plan to ensure test objectives are met.
  • Communicate defects to developers and other stakeholders.
  • Involved in 24/7 production support.
  • Prepared status reports for management.
  • Defects were tracked, reviewed, analyzed and compared using HP ALM.
  • Extensively used ALM for reporting/tracking bugs and for document control.
  • Environment: Java, XML, Internet Explorer, SharePoint, SQL, Windows 7, Mainframe, HP ALM and BMC Remedy/PAC2000 tool.

American Family Insurance, Madison, WIAug 2014 – Aug 2015

QA Lead

Project:Guidewire- Personal Lines and Commercial lines rating migration

Description: American Family Insurance has given its customers peace of mind by making their insurance experience easy and convenient for more than 80yrs. It understands customers' unique needs by offering just the right mix of American Family's auto, home, life, umbrella, business, health, and farm & ranch insurance, as well as retirement products. Located throughout our 19 operating states, American Family's independent contractor agents serve as local, expert and trusted advisors to our customers.

Responsibilities:

  • Gathered business requirements and created Traceability metrics wrote test scenarios and test cases.
  • Test Planning, scheduling, monitoring, and onsite offshore coordination.
  • Participated in daily Scrum meetings to update team with work that was completed last 24 hours, work planned for next 24 hours and any impediments that is blocking the work. Worked closely with the Policy business team to review policies required for testing.
  • Worked as individual contributor and lead the testing efforts as needed, Coordinate with multiple teams (Off shore ) and train as necessary within tight release schedules, for both short term or long term projects.
  • Scheduled and performed testing services for SQA clients as needed including, functional testing services, system Integration testing, reporting, documentation and training to application end users in UAT.
  • Tested Property and Auto products using Guidewire Application.
  • Created Auto policies for PP Vehicle and Motor Home and Misc vehicle.
  • Worked on Policy Submissions, Changes, Cancellations, Reinstate, Rewrites, Renewals and Conversion.
  • Obtained technical knowledge from the client and shared with the team.
  • Shared FRD/Requirement documents and works on Test plan document.
  • Review the test scenarios/test cases with the client team and provide sign off.
  • Communicated work time lines, progress, delays etc., back and forth from the team to the client and vice-versa.
  • Held defect review meetings with concerned development team and support team.
  • Collected test metrics, participated in test execution.
  • Performed the smoke test on any deployment build and given a go ahead for the off shore team to continue the testing.
  • Provided test execution guidelines to off shore team.
  • Provided test execution guide lines.
  • Worked with different integrations including Vehicle Service, Policy Services and Document & Forms Services.
  • Created and executed test cases based on the high-level design documents.
  • Performed Sprint level testing and primary responsibilities included functional, System, Regression Testing.
  • Executed and verified the test cases and test scenarios to cover overall QA testing cycle involving Acceptance, Functionality, Regression and End to End testing on application.
  • Tested web services using SOAP UI to test the Xml requests and the responses.
  • Worked on Rating and Output forms.
  • Worked with BAs and SMEs to identify and analyze functional gaps in the requirements.
  • Interacted with development team for defect prioritization and resolution using Defect Tracking Tool.
  • Tracked and prepared reports for testing activities like test testing results, test case coverage, required resources, defects discovered and their status.
  • Participating daily scrum stand.
  • Worked with UAT Coordinator for defining end user scenarios.
  • Involved in complete testing Software Development life cycle of the project.
  • Developed test cases, test procedures and test scripts.
  • Involved in testing policies for multiple states.
  • Documented, Logged and assigned defects in Jira defect tracking tool.
  • Executed SQL queries using SPUFI including joints, unions etc
  • Attended the Walkthroughs with the Technical Analysts and Developers.
  • Worked closely with development staff to resolve the defects and Testability issues.
  • Environment: Java, Windows7, Mainframes, SPUFI, SQL Server 2008, Jira, SOAP UI, Xml, MS Office.

NJM Insurance, Trenton, NJJan 2014 – Aug 2014

Sr.QA Analyst

Project: Personal lines migration to Guidewire

Description: PBC- Policy, Billing and Claim center is a Guidewire’s suite that New Jersey Manufactures Insurance is working with to develop convenient and interactive web applications for users to provide Auto and Home Owners policies for their customers. This project is being built using agile methodology.

Responsibilities:

  • Test Planning, scheduling, monitoring, and onsite offshore coordination
  • Participated in daily Scrum meetings to update team with work that was completed last 24 hours, work planned for next 24 hours and any impediments that is blocking the work.
  • Worked closely with the Policy business team to review policies required for testing.
  • Tested Property and Auto products using Guidewire Application.
  • Created Auto policies for PP Vehicle and Motor Home and misc vehicle.
  • Worked on Policy Submissions, Changes, Cancellations, Reinstate, Rewrites, Renewals and Conversion.
  • Worked with different integrations including Vehicle Service, Policy Services and Document & Forms Services.
  • Created and executed test cases based on the high-level design documents.
  • Worked on creating new policies for Personal lines and checking that the policy meets all criteria like Contact, policy Coverage’s, Customer roles, policy types, etc.
  • Responsible for developing test cases as per the business requirements.
  • Performed Sprint level testing and primary responsibilities included functional, System, Regression Testing.
  • Executed and verified the test cases and test scenarios to cover overall QA testing cycle involving Acceptance, Functionality, Regression and End to End testing on application.
  • Tested web services using SOAP UI to test the Xml requests and the responses.
  • Worked with BAs and SMEs to identify and analyze functional gaps in the requirements.
  • Worked with legacy teams to make sure that the integration is working as expected.
  • Interacted with development team for defect prioritization and resolution using Defect Tracking Tool.
  • Tracked and prepared reports for testing activities like test testing results, test case coverage, required resources, defects discovered and their status.
  • Participating daily scrum stand-up, defect call and project status meeting.
  • Logged Defects using HP ALM.
  • Worked with UAT Coordinator for defining end user scenarios.
  • Participated in standardizing testing templates.
  • Performed/participated in Test Case review.
  • Performed Functional and Integration testing and updated the results accordingly.
  • Performed SIT (System Integration Testing) of Policy Center with other systems like Billing Center, Documents/Forms, Claims center.
  • Identified defects and logged defects in Jira.
  • Attended Review/Retrospective meeting for all the sprints
  • Environment: Guidewire Policy Center 7.0.2, Billing Center, Soap UI, Windows7, SQL. Server 2008 R2, Jira, HP ALM 11.0., MS Office.

Cypress P&C Insurance, Jacksonville, FL Mar 2012 – Dec 2013

QA Lead

Project: Personal lines migration to STG

Description: Cypress Property and Causality has been providing Policyholders and Agents with a long-term, stable market of products and services to meet the needs of home and business owners alike for well over a decade. Headquartered in Jacksonville, Cypress serves clients in both Florida and Texas.

STG PAS and BAS application is web based application for Agents, Underwriters and CSR’s. This application specializes in the delivery of quality personal lines and commercial line products and services to Cypress customers.

Responsibilities:

  • Create Test Plan, Create Traceability metrics, Test data preparation, offshore coordination.
  • Work allocation, test data management, environment management.
  • Review requirements, Test scenarios, test cases.
  • Generate Test status reports, defect reports and weekly reports.
  • Actively involved in various meetings to discuss enhancements and modifications of the existing scripts.
  • Conduct test case review meetings, defect triage meetings and discuss open defects.
  • Performed Validation testing on the application navigation for various scenarios and reported the errors, conducted Functionality and Regression testing of the application
  • Investigated software bugs and interacted with developers to resolve technical issues using Quality Center.
  • Tested the application with real time data in production environment with various real time scenarios.
  • Experience in Postproduction Testing after deploying the code to production environment.
  • Tested the application in 24X7 in Production environment. Handled production tickets and logged the defects in quality center and tracked.
  • Review the test scenarios/test cases with the client team and provide sign off.
  • Communicated work time lines, progress, delays etc., back and forth from the team to the client and vice-versa.
  • Held defect review meetings with concerned development team and support team.
  • Collected test metrics, participated in test execution.
  • Performed the smoke test on any deployment build and given a go ahead for the off-shore team to continue the testing.
  • Provided test execution guidelines to off shore team.
  • Prepared several SQL queries for validating and balancing policy premiums on both mainframe and DEC pages in test and production environment.Experience in writing SQL queries against database including joints, union etc.
  • Read, understand and analyse the Business Requirement Specifications or Service Centre Tickets submitted by the business stakeholders.
  • Done extensive testing in Module testing, System Integration Testing and User Acceptance testing for different releases.
  • As part of UAT, gave training to the Actual Users of the application and gave clarifications for the different functional queries about the Policy Admin system and Billing Application System.
  • Involved in output forms testing for all lines of business.
  • Involved in various meetings to discuss modifications of the existing test scripts.
  • Performed data Validation for the Policy Admin system and Billing Application System.
  • Reviewed test scenarios and reported the Functional and Business gaps.
  • Responsible for Regression testing after deploying new changes into the application.
  • Logged and assigned defects in Jira defect tracking tool.
  • Involved in complete defect life cycle.
  • Tested the application with real time policies/data in different test environment with various real time scenarios.
  • Pulled daily, weekly and Monthly reports for management.
  • Conduct walkthrough sessions with development and testing team through Build and Test phase.
  • Involved in Post production testing after deploying the code to production environment.
  • Excellent verbal, written, inter-personal and problem solving skills, hard-working with an ambitious and positive attitude.
  • Environment: Java, Mainframe, SQL, Internet Explorer, SharePoint, SQL Server, Windows 7, Jira, AcroSoft, Pinnacle.

Wells Fargo Bank, Minneapolis, MN Mar 2010 – Feb 2012