Post Job Free

Resume

Sign in

Financial Services Quality Assurance

Location:
Glenview, IL
Posted:
April 05, 2024

Contact this candidate

Resume:

*

Profile Summary

Senior QA Lead with **.* years of overall experience in testing web based, IOT, ETL, Hardware and client-server applications for Banking, Financial Services, Insurance, Healthcare and Telecom domains with LOMA 281, 291 and ISTQB Certifications

• Exceptional experience in designing and creating Use Cases, writing, and executing test plans, test cases, and test scripts for manual and automated testing using HP Interactive tools.

• Extensive experience in build and release processes, Test Management, Report generation, Quality Assurance Life Cycle (QALC), and Software Development Life Cycle (SDLC), Defect Management from requirement analysis to system testing.

• Extensive knowledge working in agile/scrum as well as Waterfall Model.

• Involved in preparation of Requirement Traceability Matrix (RTM), Software Metrics, Test Case Execution Reports, Defect Reports, and Weekly Status Reports, also worked as a Quality Center Admin.

• Expert Level Experience in writing and executing SQL scripts for backend testing using T-SQL

• Well versed with full development cycle of a Data Warehouse, including requirements gathering, design, implementation, and maintenance.

• Experienced in Testing of the Complex Mainframe systems.

• Experienced in Functional, System, Integration, Regression, Workflow, stress and performance testing using HP Load Runner and Quality center software tools. Provided consulting services for Business Process Testing using Microsoft UFT, Quality Center, JIRA, Selenium and Quick Test Professional.

• Expert level experience in agile environment testing and team leading with leveraging the offshore teams.

• Training and mentorship of offshore and onsite resources in QTP/UFT, Load Runner, JIRA, Microsoft Azure ADO, HP ALM and HP Quality Center, TFS. Technology Proficiency

Technology Mainframe (JCL, Assembler, VSAM, COBOL) Tools Quick Test Professional QTP, UFT, Selenium, Load Runner, HP Quality Center, Microsoft Test Manager, Azure DevOps Server

(previously Microsoft TFS), JMeter, ClearQuest, Confluence. Database Oracle 10g, Oracle 11g, MS-SQL Server 2005/2008, MySQL, MS Access, T-SQL

Operating Systems MVS (OS/390), zOS, Windows, MSDOS, UNIX, Linux Others Microsoft Azure based ADO, SOAP UI for API testing, JIRA, TOAD, Visual Source Safe, Putty, Microsoft office share point 2007, MS Office 2000/XP, MS Visio, WordPerfect, Bugzilla. Methodologies Waterfall, Agile

Professional Experience

Month-

Year

Designation/

Role

Role Responsibilities

COFORGE

Domain/ Sub-Domain –

• Life Insurance

• Banking and Financial Services

• Telecom

Core Competency –

• Quality Assurance

• Functional Testing

• SQL, Database Testing

• Automation (QTP/UFT)

Education –

• B. Tech from COEP, PUNE

University in 2007

Certifications –

• ISTQB

• LOMA 281

• LOMA 291

DHANANJAY MORE

SENIOR QA LEAD

LOCATION: CHICAGO, IL

MOBILE#: +1-678-***-****

EMAIL:

ad4syr@r.postjobfree.com

2

Aug-

2018 -

Present

Sr. QA Lead • Test the complex Mainframe system like LifeComm with both z/OS batch and CICS

online components.

• Help in the design and documentation of

the Test Plan.

• Identify the items to be tested, the

features to be tested, the testing tasks to

be performed, the personnel responsible

for each task and the risks associated with

the Test Plan and document all of them.

• Use Microsoft Azure based

ADO/Confluence as a Test Management

Tool for creation and execution of the Test

Cases and mapping the test cases to the

business requirements and creating and

managing the defects until resolution.

Rapid IT, Inc/NTT Data

Oct-2015

to Aug-

2018

Sr. QA Lead • Test the Data flow end to end through the Interfaces of ALIS, DMFI and the extract

Reports using complex SQL queries and

also Test the complex Mainframe system

like LifeComm with both z/OS batch and

CICS online components.

• Help in the design and documentation of

the Test Plan.

• Identify the items to be tested, the

features to be tested, the testing tasks to

be performed, the personnel responsible

for each task and the risks associated with

the Test Plan and document all of them.

• Established Requirements Traceability

using the Traceability Matrix.

• Use Microsoft TFS as a Test Management

Tool for creation and execution of the

Test Cases and mapping the test cases to

the business requirements and creating

and managing the defects until resolution.

Tata Consultancy Services (TCS)

Sep-2007

to Sep-

2015

Sr. QA Lead • Design and Execution of the Test Plan, Test Cases and generating Reports and

mapping Business Requirements.

• Established Requirements Traceability

using the Traceability Matrix and

Performed Test Execution on HP QC.

• Conducted Joint application design (JAD)

sessions with multi cross functional teams

and created templates for Test Strategy,

Test Plan, Test Case, Defect Report,

Periodic and End of Project Reports.

• Maintained QA share point to disseminate

project manuals, test artifacts, status

reports, QA process check lists, defect

management process, communication

management documents, Production

Deployment Criteria.

3

Project Details

Name of the Project : Sammons Financial Group (TAX – LifeComm) Duration Aug 2018– Current Role Sr. QA Lead

Project Type Application Development Technology Mainframe (Assembler, JCL, VSAM, CICS) Project Description • The LifeComm Insurance Administration system is a complex Mainframe system with both z/OS batch and CICS online components.

• LifeComm handles the whole Policy Life cycle covering various aspect of policy life cycle from underwriting to policy maturity for Term, Whole Life, Universal Life Insurance and Annuity. My

Responsibilities

• Help in the design and documentation of the Test Plan and Design and create Use Cases.

• Identify the items to be tested, the features to be tested, the testing tasks to be performed, the personnel responsible for each task and the risks associated with the Test Plan and document all of them.

• Establish Requirements Traceability using the Traceability Matrix.

• Use Microsoft Azure based ADO/JIRA/Confluence as a Test Management Tool for creation and execution of the Functional, Integration and Workflow Test Cases and mapping the test cases to the business requirements and creating and managing the defects until resolution.

• Perform testing of Life Insurance policies using the CICS online components in the Mainframe system of LifeComm.

• Test the VSAM files in the CICS file control table (FCT) using the appropriate CICS commands.

• Test the Policies for Whole Life, UL Products using both batch and CICS online components of LifeComm system’s Mainframe.

• Perform the API testing for the LifeComm and CyberLife UI using SOAP UI.

• Help the Developer to debug the VSAM file operations in LifeComm's Mainframe by setting breakpoints, changing values, and checking results.

• Conduct Joint application design (JAD) sessions with multi cross functional teams.

• Attend the Daily Scrum Meetings, create User stories in Microsoft Azure based ADO/JIRA.

• Use Microsoft Azure based ADO/JIRA to create and store the Spike stories, Tech stories and Bug stories.

• During each Agile Sprint, create Test Cases in Confluence for each of the Sprints.

• Also track the Sprint Review and Sprint Retrospective in Confluence for each Sprint. Name of the Project : Tennessee Farmers Life Insurance Company (TFLIC) Duration Oct-2015 to Jul-2018 (3 years) Role Sr. QA Lead Project Type Application Development and

Data Migration

Technology Mainframe (Assembler, JCL, VSAM,

Expeditor), JAVA

Project Description • Tennessee Farmers Life Insurance Company (TFLIC) replaced its thirty-year-old Policy Administration System, LifeComm, a complex Mainframe system with both z/OS batch and CICS online components with ALIS, a modern Policy Administration System published by Sapiens. My

Responsibilities

• Test the Data flow end to end through the Interfaces of ALIS, DMFI and the extract Reports.

• Review and comprehend Project Documentation like the FDS and Interface Design Documents (IDD)

• Help in the design and documentation of the Test Plan and Design and create Use Cases.

• Identify the items to be tested, the features to be tested, the testing tasks to be performed, the personnel responsible for each task and the risks associated with the Test Plan and document all of them.

4

• Test the Life Insurance policies, agents using the CICS online components in the Mainframe system of LifeComm.

• Access the VSAM files from the CICS programs and perform functions like opening, closing, reading, writing, updating, and deleting records while executing the test cases.

• Established Requirements Traceability using the Traceability Matrix.

• Test the Life Policies for Term, Whole Life and UL Products using both batch and CICS online components of LifeComm system’s Mainframe as well as in the modern PAS ALIS.

• Help the Developer to debug the VSAM file operations in LifeComm's Mainframe by setting breakpoints, changing values, and checking results.

• Use Microsoft TFS as a Test Management Tool for creation and execution of the Test Cases and mapping the test cases to the business requirements and creating and managing the defects until resolution.

• Develop, document and revise system design procedures, test procedures, and quality standards.

• Use JIRA to create and store the Spike stories, Tech stories and Bug stories.

• During each Agile Sprint, create Test Cases in Confluence for each of the Sprint.

• Create complex SQL queries in SQL Server Management Studio to test the Interface Data.

• Use the Interface Design Document for designing the SQL queries for testing the data in ALIS.

• Use Mapping documents to design SQL queries for testing the data in DMFI warehouse and extract files and reports in the downstream systems.

• Create SQL scripts to test the Data Conversion and Migration which occurs between the ALIS and DMFI systems

• Perform the Defect Management in HP ALM by raising defects for all the failed test cases that were executed in the ALM tool.

• Perform the ETL testing for the data load from ALIS to DMFI and also from DMFI to extract files, reports and downstream systems.

• Work as Client acceptance and System tester with testing team members to implement the successful conversion of DB clients, following the agile software development methodology

• Escalate the testing issues to the Management and track all the defects to their closure.

• Support the taxation testing for the Life Insurance Products (taxable as well as non-taxable products) involving the cash value accumulation test (CVAT) and the guideline premium and corridor test (GPT).

• Create reports to verify converted data using SQL Scripts.

• Design the test cases for Performance testing and store them in HP ALM. Name of the Project : Healthlogic Solutions Corporation (Owned by Bank of America) Duration Sep-2010 to Sep-2015 (5 years) Role Sr. QA Lead Project Type Application Development and

Remediation

Technology JAVA

Project Description Bank of America acquired HealthLogic Systems Corporation, a Georgia-based healthcare technology company that has been an industry leader in developing technology solutions that enable healthcare providers and hospitals to automate their paper-intensive insurance claim and billing process resulting in faster, more efficient cash retrieval. The company offers a full suite of healthcare revenue cycle automation solutions that allow healthcare providers to move to a more integrated and automated processing environment, gain efficiencies and reduce costs all while maintaining HIPAA- compliance. HealthLogic already had longstanding relationships with a number of leading healthcare providers and large financial institutions, including Bank of America. The HealthLogic System Corporation needed a new design and solution to upgrade its current Electronic Remittance Archive and Controlled Release product offerings in Healthcare. 5

My

Responsibilities

• Worked as a subject matter expert for Healthcare domain and Participated in requirements gathering discussions.

• Design and Execution of the Test Plan, Test Cases and generating Reports and mapping Business Requirements with them. Design and create Use Cases.

• Established Requirements Traceability using the Traceability Matrix and Performed Test Execution.

• Improved the efficiency of the QA team and restored end-user and management confidence in testing process through Constant Communication, Requirement Review Meetings, Clear Estimations, Thorough Documentation, Clear Entry / Exit Criteria, Test Case Approvals, Check Lists, Defining Responsibilities, Approved Release Criteria, Status & Metrics at various levels – Project, Process & Product level.

• Conducted Joint application design (JAD) sessions with multi cross functional teams and created templates for Test Strategy, Test Plan, Test Case, Defect Report, Periodic and End of Project Reports.

• Maintained QA share point to disseminate project manuals, test artifacts, status reports, QA process check lists, defect management process, communication management documents, Production Deployment Criteria.

• Worked with product management to clarify and convert requirements into testable units.

• Worked effectively and collaboratively with the QA team, development teams, PM’s, and business users.

• Estimated required QA resources and worked with project managers to come up with the cost estimates for test efforts.

• Use Microsoft TFS as a Test Management Tool for Test Management – Management, Requirements, Test Plan, Test Lab, Defect and Dashboard.

• Established Requirements Traceability using the Traceability Matrix and Test and Defect coverage using Quality Center.

• Performed Smoke, End to End, Functional, GUI, Usability, Regression, Integration, Interface, System Testing.

• Translated exhaustive requirements specifications in to UAT Test Cases to recognize errors and gaps that could be present in requirements.

• Developed and implemented UAT Test Strategy and Test Plan.

• Perform the Defect Management in HP ALM by raising defects for all the failed test cases that were executed in the ALM tool.

• Performed Automation of regression scenarios using QTP 10/UFT and maintained Automation Repository: Automation Framework, Reusable Functions, Smoke, Regression Test Cases, Performance Scripts, Metrics and Lessons Learned.

• Participated in User Acceptance Testing, recognized reusable and repeatable tests with new versions of the application, automated them & achieved reduced test timings, accurate results. (Smoke, Regression, UAT).

• Generate performance metric reports and analyze them during the status meetings and JAD.

• Suggest recommendations for removing the bottlenecks in the Performance of the system and improving the efficiency of the system.

• Perform the API testing for the UI (SOAP, WSDL) using SOAP UI.

• Performed the Load Testing and Performance Testing using HP Load Runner and web service testing using REST.

• Performed the ETL testing for the data load from the Legacy system to Advanced Platform.

• Performed thorough Data Analysis, validation and backend testing with T-SQL.

• Tracked and reported on testing activities including test results, test case coverage, required resources, defect status and performance baselines and mile stones.

• Worked as Client acceptance and System tester with testing team members to implement the successful conversion of DB clients, following the agile software development.

• Participated in the go-no-go meetings and proposed suggestions with the metrics related to pre-agreed release criteria.

6

Name of the Project : Unified Prepaid Support System (UPSS) (Vodafone) Duration Sep-2009 to Sep-2010 (1 year) Role QA Lead Project Type Application Development and

Data Migration

Technology JAVA

Project Description Vodafone UPSS (Unified Prepaid Support System) project is basically the implementation of a Centralized Prepaid System across all Telecom Circles. Vodafone had different legacy retail systems across different Telecom circles. As part of this roll out it was brought down to a single Unified system.

My

Responsibilities

• Preparation of Test Plan and Test Strategy and Design and create Use Cases.

• Conduct the Joint application design (JAD) sessions with multi cross functional teams and created templates for Test Strategy, Test Plan, Test Case, Defect Reports etc.

• Preparation of Test Scenario and Test Cases.

• Functional QA on staging and production environments.

• Communication and co-ordination with the cross flow teams.

• Establish Requirements Traceability using the Traceability Matrix in the HP ALM.

• Perform Terminal IOT (Internet of Testing) and functional testing between existing Vodafone CDMA/GSM, implementation and new terminals for Vodafone customers.

• Implement IOT (Internet of Testing) test cases on mobile devices per cabled interoperability test specifications for CDMA as well as GSM.

• Use HP ALM as a Test Management Tool for creation and execution of the Test Cases and mapping the test cases to the business requirements and creating and managing the defects until resolution.

• Track the Progress, Quality and Resource utilization of each project on daily, weekly & monthly basis through status reports and metrics.

• Perform the Defect Management in HP ALM by raising defects for all the failed test cases that were executed in the ALM tool.

• Execute Test conditions and Mark-off results in Quality Center tool.

• Defect management, Coordinate with the development team to fix the defects.

• Retrieve, modify and execute the UNIX shell scripts.

• Perform the API testing of the UI and the Web services (SOAP, WSDL) using SOAP UI PRO.

• Perform the UAT/BAT Support.

• Post Production support during Normalization period.

• Perform the CRM testing to help organize, automate, and synchronize the customer interaction in UPSS.

• Ensuring that the Pre Roll Out activities are done well in advance of the roll out like Data Migration, MV creation etc.

• UAT Sanity Testing in production environment.

• Ensure that the code movement is done by all parties.

• Manage the Roll out activities.

7

Name of the Project : Cisco Systems Inc.

Duration Sep-2007 to Sep-2009 (2 years) Role QA Lead Project Type Application Development and

Data Migration

Technology Mainframe (Assembler, JCL, VSAM,

Expeditor)

Project Description The World Wide Inventory Point of Sale (WIPS) is an application used by Cisco Systems to capture Point of Sale (POS) and Inventory information, pertaining to its two-tier operation. The two-tier operation consists of Cisco's Distributors (Distis) and the Value Added Resellers (VARs). Cisco has the ability to bring its products at strategic locations (i.e. warehouses) so that can effectively “penetrate” the market. This objective is achieved with the help of Sales – Channels (Retail department of CISCO) Distribution develops medium to small resellers reducing Cisco’s need to maintain in-house expertise – outsource ordering and business operations management (> 50,000 resellers globally) architecture while selling products. The chain has following stakeholders

• Cisco (As Producer)

• Distributor

• Reseller

• End User (Customer who utilizes the product)

Cisco has total of 141 distributors globally. Ingram Micro, Comstor and TechData are top distributors operating globally.

My

Responsibilities

• Roles and responsibilities included functional testing, regression testing, Verification and validation of various products on different interfaces.

• Designed and created Use Cases and then Prepared high-level, low-level test cases based on design and requirement documents.

• Established Requirements Traceability using the Traceability Matrix.

• Conduct Joint application design (JAD) sessions with multi cross functional teams.

• Got trained on Hybris software and did hands on testing on the ecommerce site.

• Used HP ALM as a Test Management Tool for creation and execution of the Test Cases and mapping the test cases to the business requirements

• Executed test cases, logged defects and modified existing test cases according to application changes.

• Performed the Defect Management in HP ALM by raising defects for all the failed test cases that were executed in the ALM tool.

• Retrieved, modified, executed UNIX shell scripts and created cron jobs.

• Performed web services API testing using SOAP UI.

• Worked in agile methodology mixed with scrum.

• Involved in project meetings and discussions for setting targets and goals to be achieved in the QA process.

• Tracked and prioritized defects using Quality Center and analyzed the variation between expected and actual results.

• Analyzed defect status using Quality Center and interacted with developers to fix defects/bugs in the application.

• Supported the Customer Relationship Management (CRM) testing for checking every facet of interaction with DISTI customers of Cisco.

• Generate performance metric reports and analyze them during the status meetings and JAD sessions.

• Suggest recommendations for removing the bottlenecks in the Performance of the system and improving the efficiency of the system.

• Performed the Load Testing and Performance Testing using HP Load Runner.

• Training and mentorship of offshore and onsite resources in QTP, Load Runner and Quality Center.

8

Detailed IT Skills

Skill Name Exp. in Months Domain Exp. in Months Databases Exp. in Months Quality Assurance 198 Insurance 168 MS-SQL Server 120 SQL 198 Banking 60 Oracle 11g 120

Automation

(QTP/UFT)

60 Telecom 36 VSAM 120

Mainframe 120

Tools/ Platforms

QTP/UFT 60 Microsoft Azure

based ADO

12

HP Quality Center 198 Confluence 72

Microsoft Test

Manager

60 Ivanti 72

Azure DevOps

Server (Team

Foundation Server

TFS)

60 TOAD 72

JIRA 90 UNIX 60



Contact this candidate