Harendra (Haren) Gupta

  • QA and Testing Manager
  • Hartford, CT
  • Member Since Mar 30, 2023

Candidates About

 

Harendra (Haren) Gupta

 

Summary

·         15 years of focused experience in Quality Assurance and testing Stand-alone, Web based and Client-Server  and Data warehouse applications

·         10 years of experience as a QA Manager/ Program Test Manager

·         Implemented automation tool and managed automation team  in different organization

·         Proficient in establishing QA Methodology, Best Practices

·         Experienced in creating test strategy and test planning on Strategic and tactical projects

·         Design automation framework using QTP

·         Managed QA resource at Program/Project/Train level and managed 4-6 million QA budget

·         Proficient in Quality Assurance and Testing experienced in documentation of Test Plans, Test Strategy and Test Approach for Manual and automated testing tools such as Quick test professional, Win Runner, Load Runner and Mercury Quality Center, Test Director, MS Project, MS Word, MS Excel, MS Powerpoint

·         Managed resources in multiple global location ( USA, India, Australia, Luxemburg, UK)

·         Proficient in Functional Testing, Black Box Testing, System Testing, Build Verification Testing, Integration Testing, Security Testing, User Acceptance Testing and Regression Testing.

·         Extensively used automated test tool for GUI, Database and Regression Testing

·         Excellent understanding of SDLC, Waterfall Model, Agile Scrum, SAFe and V-model.

·         Formulation and Documentation of detailed Test Plans and executing Test Cases for functional, technical and integration scenarios

·         Extensively managed  Data warehouse and reporting project using Informatica, Hadoop, Abinitio, Crystal Report  Business Objects

·         Direct, Clear Communicator and efficient team player

·         Self-motivated and dedicated fast learner

·         Excellent management skills

·         Good problem solving and decision making skills

Honors and Awards

Received appreciation awards in 2013, 2014 at Travelers

Received 2011 Annual "Best Picture" OscarZ award at Zurich NA

Received 2010 Annual award for Best Mentor of the year at AppLabs

Award of Excellence for efforts and best team player at Bellsouth

 

Certification

 

SAFe Agilist (SA)

 

PROFESSIONAL EXPERIENCE

 

Employer: Cigna Healthcare Insurance, CT                                                                   Jan15- Till Date                                                            

QA and Testing Manager

Cigna Group Insurance provides affordable disability, life and accident products to individual customers through their workplace, association, or other affinity group. Offering managed medical, pharmacy and dental care services, including integrated indemnity and group life and health insurance, Cigna HealthCare also offers condition management, behavioral health benefits, assistance and work/life support programs, and a range of health and wellness coaching services.

 

Responsibilities:

·         Responsible for managing testing efforts on multiple Strategical program across IM area

·         Created Program level test strategy

·         Managed End-End Integration testing between 15 applications

·         Responsible for managing tactical and multiple testing at program/project level

·         Managed Automation team and implemented different in-house capabilities to again efficiency in the testing

·         Experienced managing vendor relationships

·         Managing testing activities at Release train level in SAFe Agile environment

·         Played a key role in implementing CI/ CD using Jenkins, uDeploy, FitNeese, Python

·         Managing automation effort and provide direction for process improvements

·         Coordinated with Enterprise Program Manager and business program managers on overall project planning

·         Managing all stages of testing throughout the SDLC and closely worked with Business Manager and lead during BAT testing

·         Generate status reports and executive dashboard for senior management for release and quality compliance readiness

 

Environment: - Mercury Quality Center 11.5 ALM, Unix, Mainframe, Windows 2007/XP, WebSphere Server, Jenkins, FitNesse, DBFit, uDeploy, Oracle, MS Project, QTP 11, SOAP UI, HP Service Test, Teradata, Informatica, DVO, Rally, GIT, Hadoop, Data Lake, Python

 

Employer: Travelers Insurance, CT                                                                               June12- Dec14

QA Test Manager

 

Travelers offers a broad range of insurance and risk management options to large businesses and organizations. Travelers offers wide variety of Property and casualty insurance. Travelers specializes in designing sophisticated programs that leverage our product breadth to meet even the most challenging requests. Risk is a common factor in everyday business. That's why Travelers offers a wide range of business insurance options to help mitigate risk and protect your company. Whether you have a small, mid-sized, large or even highly specialized business, our dedicated underwriting, claims and risk control services can match your unique coverage and compliance needs.

 

Responsibilities:

·         Responsible for managing multiple testing effort across business intelligence testing.

·         Created and provided valuable information on the project proposal

·         Responsible for managing tactical and multiple programs testing

·         Managed ETL Automation effort and automation resources

·         Experienced managing vendor relationships

·         Responsible for quality governance and process management

·         Implemented Defect Management Process, Change Control Management Process, Risk Management Process, Environment readiness plan

·         Managing all stages of testing throughout the SDLC

·         Managed testing effort with several vendor management company

·         Coordinated with IT Program Manager and business program managers on overall project planning

·         Implemented consistent QA best practices using standard tools and technique

·         Generate status reports and executive dashboard for senior management for release and quality compliance readiness

 

Environment: - Mercury Quality Center 11.0 ALM, Unix, Mainframe, Windows 2007/XP, WebSphere Server, Oracle, MS Project,  Rational ReqPro,,  QTP 9.5, SOAP UI, HP Service Test, Teradata, Abinitio, FitNesse

 

Employer: AppLabs (CSC Company)                                                                            Apr 10- June 12

Client: Zurich NA, IL                                                                                                                            

Program/Project Test Managers

 

Zurich Financial Services is an insurance-based financial services provider with a global network. Zurich is a leading commercial property-casualty insurance provider serving the global corporate, large corporate, middle market, small business, specialties and programs sectors.

               Zurich's commercial automobile and trucking claim service starts with a fast response to your auto claim through one of our dedicated auto and trucking claim centers.

 

Responsibilities:

·         Managed multiple testing effort as outsourcing partner to Zurich in Claims area

·         Managed all the testing activities for Agile Scrum  project for one of the largest efforts to rewrite Claims engine (WFM)

·         Participated in Sprint planning, Poker planning, Retrospective and daily scrum meeting

·         Coordinated with product owner, scrum master and other stakeholders

·         Created and provided valuable information on the project proposal

·         Single Point of contact and managed 50+ onsite and offshore resources in the Claims area

·         Implemented Defect Management Process, Change Control Management Process, Risk Management Process, Environment readiness plan and Quality governance process

·         Introduced and Implemented QC in Claims area.

·         Managed all stages of testing throughout the SDLC

·         Created Master integrated test strategy, project schedule for overall project

·         Managed testing effort with several vendor management company

·         Conducted entry and exit checkpoints between different test phase

·         Coordinated with IT Program Manager and business program managers on overall project planning

·         Managed testing effort on MDM, Claims rewrite project

·         Implemented consistent QA best practices using standard tools and technique

·         Conducted defect triage during QA and Integration testing with testing, development and BA team members

·         Coordinated during  System integration testing, Regression Testing ,Integration Testing, System Compatibility Testing, UAT on different application with several testing and BA teams

·         Maintained defect tracking and generated defect reports from Quality Center to manage the priorities

·         Generated different testing traceability metrics from Quality Center  and Requisite pro using MS Word, MS Excel

·         Generated status reports and executive dashboard for senior management for release and quality compliance readiness

·         Presented testing status/ overall project health with VP and AVP of Claims area

Environment: - Mercury Quality Center 10.0/ 11.0 ALM, Unix, Mainframe, Windows XP, WebSphere Server, Oracle, Pega PRPC, Pega BPM, MS Project, Requisite Pro, Pega  PMF, Pega TMF, RAD, Rational ReqPro, MDM, QTP 9.5, SOAP UI, HP Service Test

Client: JP Morgan Chase, CT                                                                                         Aug 09- Feb 10

Test Manager

 

J.P. Morgan Hedge Fund Services is a top tier provider of independent fund administration and comprehensive outsourcing solutions to hedge funds, fund of hedge funds (FOHFs), fund of mutual funds.

        The core functionality of this project is efficient Portfolio Management System (PMS) to capture the client holding and thus enable the necessary action for the Corporate Action Event. Other functionality were Maintenance of Shareholder Register of the Fund, Dedicated FOHF accounting platform and proprietary FOHF price capture and control solution, Full oversight of subscription and redemption order processing. The tool also has comprehensive Cash and Fx Accounting Module and interacts with External Legacy applications used in Treasury Systems and Finance groups.

 

Responsibilities:

·         Managed multiple testing activities on automated Fund Order Management system for Hedge Fund Services and Global Custody (GC) business

·         Coordinated with Program management and business program managers on overall project planning activities related to financial aspects, resources, etc. for presentation to the steering committee

·         Managed and coordinated with QA members with on-site and off-shore model

·         Implemented consistent QA best practices using standard tools and technique

·         Conducted defect resolution and defect triaging meetings

·         Maintained defect tracking and generated defect reports from Quality Center to manage the priorities

·         Implemented out defect management process

·         Reported defects found during functional and regression testing in Quality Center and follow up with the defect life cycle using Quality Center

·         Generated status reports and dashboard for senior management

·         Performed data base testing by write complex SQL

·         Validated reports generated out of Crystal Reports

·         Validated data integration in data warehouse tables after the ETL job runs

Environment:- Mercury Quality Center 10.0, Unix, Mainframe, TOAD, Windows XP, WebSphere Server, Oracle, Geneva, Milestone FORTE, MS Project, pControl, DB2, Informatica, Crystal Reports.

Client: MassMutual Financial Group, CT                                                                    Jan 08- July 09

Test Manager/QA Manager

 

MassMutual is a mutually owned financial protection, accumulation and income management company. MassMutual provides several deferred annuity products, some of which provide features (at an additional cost), that offer a level of protection for an investor and a wide range of variable annuities. MassMutual provide different retirement plan/services, investment (annuities), life insurance policies.

 

Responsibilities:

·         Established QA department by creating 3 years roadmap for Retirement Income area

·         Implemented consistent QA best practices using standard process, technique, test infrastructure (Hardware, test data, tools)

·         Identified and hired internal and external resources on the team

·         Planned and streamlined work efforts

·         Responsible for managing multiple testing activities in the retirement income group on various Strategic and tactical projects

·         Worked with third party vendor to conducted testing activities

·         Worked with Enterprise Director for resource forecasting and resource allocation on different projects

·         Conducted regular staff meeting with the testing team and  status call with project business partners

·         Managed team of 4-8 QA members with on-site and off-shore model

·         Managed vendor (Cognizant) offshore and on-site resource on different projects

·         Created test strategy and test plans for the upcoming project

·         Defined and developed templates for test strategy, test plans, test case, test results

·         Conducted defect resolution and defect triaging meetings

·         Designed automation test framework

·         Maintained defect tracking and generated defect reports from Quality Center to manage the priorities

·         Performed data base testing by write complex SQL

·         Updated and ran JCL job, validated output on Mainframe

·         Analyzed data using ISPF, to validate testing expected results on different mainframe screen

·         Worked with vendor management for staff augmentation

·         Conducted review on test strategy, test cases with developer’s, End user, BA’s and core testing team

·         Validated reports generated out of Cognos

·         Conducted functional testing on IVR application

·         Validated data integration in data warehouse tables after the ETL job runs

·         Maintained testing project plans within MS-Project and develop road map to accommodate multiple releases as and when required

·         Conducted training sessions for downstream systems on various QA process for QA Leads

·         Worked on Agile testing process

Environment: - Quick Test Professional 9.1, Mercury Quality Center 9.2/8.2, IBM Main frames,

TOAD, Windows XP, WebLogic Server, WebSphere Server, SQL, Siebel CRM , RPS, CSC Vantage

One systems, wmA, RPS, MS Visio, MS Project, DB2, Informatica, Cognos.

 

Client: CIGNA Healthcare, CT                                                                                            Sep 07- Dec07

QA Lead

Cigna provides health care products and services (medical, pharmacy, behavioral health, clinical information management, dental and vision benefits, and case and disease management); and group disability, life and accident insurance. In addition, CIGNA also provides life, accident, health and expatriate employee benefits insurance coverage. Cigna medical, pharmacy and dental care services, including integrated indemnity and group life and health insurance for an employee

 

Responsibilities:

·         Managed team of 4-6 QA members for Pricing Claims application

·         Managed Deloitte testing resource on the projects

·         Provided level of estimate across multiple projects

·         Suggested, Implemented and Mentor best QA practice methodology

·         Gain business knowledge across LOB’s to develop and implement project Quality Assurance Plans and designed several templates for test plans, test case, and test results documents

·         Equally allocated resource to ensure that all testers have been equal assigned to the project tasks.

·         Conducted regular status meeting to ensure the project milestone are achieved and to improve the testing efforts

·         Set priorities and made decisions by using the general guidelines and QA methodology to meet the project

·         Connected review meeting for test scripts with business group, development team and testing team

·         Maintained defect tracking and generated defect reports from Quality Center to manage the priorities

·         Prepared and presented weekly update to the senior management for project milestone, resource management and level of estimates

·         Coordinated in implementation of the project (SDLC) Software Development Lifecycle throughout the organization processes included Planning, Design, testing and implementation, phases

·         Defined and developed test requirement, test plans, test case

·         Created different ESCIF claim files to test against the claim engines and pricing application.

·         Validated third party vendor application based on Cigna’s requirements

·         Performed all phases of end-to-end testing which includes Functionality testing and Integration Testing

·         Conducted Automated functional and regression test using Quick test professional  9.1

 

Environment: - Quick Test Professional 9.1, Mercury Quality Center 8.2, Weblogic Server, IBM

Mainframe, TOAD, ESCIF, SQL, Trizetto Pricer Application

 

Client: Wells Fargo (Previously as Wachovia Bank) NC                                               Apr 07- Sep 07

QA Lead

Wachovia is a diversified financial services company that provides a broad range of retail banking and brokerage, asset and wealth management, and corporate and investment banking products and services.

Wachovia Securities offers many types Stocks, Bonds, Mutual Funds, Options, Annuities, Foreign exchange, trading. Foreign Exchange Global is the team that support and develop Foreign exchange and trading application