Sign in

Qa analyst

Wilmington, DE
October 30, 2019

Contact this candidate


Summary Ph: 302-***-****

Over six years of experience in Manual testing, automated testing and QA of client-server based and web based applications using Mercury Quality center 8.0/8.2/,9.0, Mercury Quick Test Professional 8.0/8.2/9.0/HP ALM

Expertise in Manual and Automated Testing of applications developed on Windows and UNIX Environment.

Extensive experience on preparing test plans, UAT test cases, test scripts and test data based on business requirements and functional requirements.

Good Experience in User Acceptance Testing, Functionality Testing, Integration Testing, System Testing, Regression Testing and Installation testing using White Box and Black Box testing methodologies and Business Function Testing, Performance Testing, Stress testing and Configuration Testing.

Expertise in Problem solving and Bug Tracking.

Good Experience in Back-end testing on UNIX Operating System.

Strong Experience on Oracle PL/SQL, SQL Queries like testing and developing the queries.

Extensive experience testing of different application which is built-up with various web technologies ASP, J2EE, XML, Web services and .NET Technologies.

Certified Professional in SQL.

Expertise in programming using Visual Basic, Oracle and SQL on different flavors of Windows.

Good experience in working with Agile environment.

Attended Daily Status calls in the morning and updated the testing covered.

Developed Test plans and Test Cases in interaction with development Engineers.

Strong in establishing QA Procedures / Standard Methods and Reviewing BRD, TRD & FRD and preparing Test Scenarios.

Very good in scheduling, planning for the releases, builds, and patches for the QA testing worked with multiple releases simultaneously in QA environment.

Good aptitude for learning and efficient in Problem Solving.

Oracle SQL Certification.

Technical Skills

Testing tools Quick Test Pro 8.0/8.2/9.2, Quality Center 8.0/9.0/9.2/ALM 11.0

Languages SQL, PL/SQL, Shell Script.

Operating Systems Solaris 9.0, RHEL 5, Windows 2003 R2.

IDE Visual Basic 6.0, Visual Interdev 6.0, and MS.VISIO.

Databases Oracle 10g / 9i, SQL Server 7.0/6.0, MS-Access00/97

Web Technologies HTML, DHTML, XML, JavaScript, VB Script

Web Sever Web Logic Server 8.2, Oracle IAS 10g, Apache Web Server

Professional Experience

JPMC Chase, Wilmington,DE March 2016-till now

QA Analyst

CCB Quality Organization provides quality assurance by reviewing the interactions between JPMC representatives and the customers throughout CCB operations(e.g Mortgage, Auto Finance, Card, and CCB). It’s a Reporting, Analysis and Development team within the CCB Quality Organization. As part of the team, I provided support by utilizing various technical skills in Excel, Access, VBA, SQl and SAS.


Working directly with various types of data, tools, and software.

Maintaining reporting tools and generating reports and presentations, modifying and developing new tools and reporting to support the need of the business.

Supported quality review, reconciliation reporting, process improvement, and regular business and management reporting.

Testing the Regulatory compliance scores and Policy Procedure scores for the reports created.

Built complex Quality Assurance reports across multiple systems and businesses.

Designed VBA applications as necessary to support the business.

Involved in translating data sets into meaningful reports using SQL.

Worked with peers and leadership to support key activities in the department.


VBA, Sql query, SAS Programming and analysis skills.

MS Office skills (Excel and Access)

JPMC Chase, Wilmington,DE

BCBS Project

QA/BA April, 2014 – March, 2016

In January 2013, the Basel Committee on Banking Supervision (BCBS) issued the Principles for effective risk data aggregation and risk reporting to strengthen banks’ risk data aggregation capabilities and internal risk reporting practices. The Principles include Overarching Governance and infrastructure, Risk data aggregation capabilities, Risk reporting practices, Supervisory review, tools and cooperation.

A Data Aggregation/Integration work stream project has been initiated to comply with the Regulatory and Basel requirements. This project will document and understand the current state of data aggregation and define technology requirements to ensure all required elements used in critical reporting are migrated to the ICDW environment.

Tasks involved in the Phase I of the BCBS program for the Data Aggregation and Data Integration Work stream include:

Analysis of current reporting inventory, reverse engineering & decomposition of critical reports to SOR attributes.

Outline framework for managing the Data Aggregation workstream project

Outline and develop framework for defining technology requirements related to SORs (system of record) and Attributes.

Working closely with SME leads to identify data aggregation requirements thru review of critical reports.

Establish tracking, monitoring and reporting mechanisms to outline progress check points.

Ensure that the BAU processes will be able to deliver against the BCBS principles in the aforesaid framework.

Expertise with Agile & waterfall methodology

Analyzed the requirements and converted them to system requirement specification.

I was involved in communicating with IT and get the information needed for the reports.

Going through the codes and files to understand the logic.

I have attended the meetings with SME and IT to gather information for the business logic.

I have documented the Business Requirement Documents referring to the DEM.

Any changes to the BRD’s is recorded by changing the versions to the documents.

I have updated the sharepoint with all the files and codes required for risk reports

Created UAT test cases and test scripts using detailed business requirements, functional documents, and processes

Ensure testing thoroughly and accurately documented following JPMC standards and utilizing prescribed testing application (ALM)

Manage defect tracking and reporting and ensure proper re-testing of all defects using testing application (ALM)

Involved in preparing Business Requirements

Executed SQL queries to see the data matches for the particular period of Year and month.

Raised defects in Quality center and retested once they are fixed.

Environment : Teradata SQL Assistant IDWPRD, Oracle SQL Developer, HP ALM Explorer 11.00, SAS code, BO, Putty, WinSCP, Oracle

Siemens, PA

Orders Module testing

QA Analyst May,2012 - 2014

Soarian Clinicals is an innovative, dynamic, patient record solution, that can help your hospital organization synchronize workflows across the health continuum. Soarian enables you to manage patient data from multiple patient workflows to give you a cross-patient perspective of your tasks and from single patient workflows to enable you to manage patient-specific data. Security settings, preference settings determines the individual workflows. The orders are transmitted through HL7 Transactions. Checking the Inbound and Outbound orders. Testing various web User Interfaces to check whether the order is showing correctly.


Performed UAT and Regression testing on the application on different builds and versions.

Performed high quality testing of software being developed and/or currently used at various inpatient (hospital)

and outpatient sites

Identified risks to product quality, raises to Project Manager and Test Lead when appropriate

- Analyzed escaped defects (Root Cause Analysis)

- Troubleshoot problems

- Follow testing methodologies

Contributed in Sprint Review meetings occurs every month.

Supported team members in order to meet team objective

Actively participated in all project activities

Executed all Service packs testing on various builds of the application

Performed testing in Agile environment of sprints with every two week cycle

Tested the scripts by using Mercury Quality Center 9.2/ALM

Raised the defects (Charms) in the Rational Clear Quest and Validated those after fixed by developers

Environment : Java 1.6, Java EE 5, C++, Web Services, XML, Spring, Websphere 7.0, SQL Server 2008, TIBCO iProcess Suite, IBM ClearCase, IBM Clear Quest, HP Quality Center

Independence Blue Cross, Philadelphia

Consortium Online and Batch Processing

QA Analyst April, 2011- April, 2012

The enterprise has committed to participation in Consortium Health Plans. The consortium includes variable interplan agreements that determine amounts of home and host interplan compensation. The agreements include per contract-per month charges. IBC needs to record and reconcile the financial activity for the Host Consortium PCPM reimbursements.

The primary business goals of this project is to load following ITS Plan Profile Database tables and create reports with host plan(362) data in order to record the financial activity to for Host PCPM reimbursements to the General Ledger Host PCPM receivable account


Attended the Project meetings with project manager, Team Lead to discuss the Business Documents

Analyzed Business Document with the Team.

Involved in writing high-level scenarios based on goals set forth from functional specifications

Involved in writing detail level test cases that would provide adequate coverage to the scenarios, identifying the data sets that would need to complete them

Executed the Test Scenarios and documented the defects raised

Evaluated the Results and Analyzed the test results

Raised Defects and created Defect Report

Responsible for logging defects in Defect Tracking tool, monitoring their status and tracking them to closure using Quality Center.

Created data sets to be used in test cases

After being granted access to the online program was able to write individual test scripts to load into HP Quality Center

Tested the online functionality of the Consortium Rate Online program with positive and negative data

Create a daily report of the testing, reporting any open or closed defects.

After receiving report files from the daily and monthly batch processed was able to test the batch functionality

Participated in all Status Calls, Test Case Review meetings and Sign-Off meetings with the project team

Environment: COBOL, COBOL with embedded SQL statements, COBOL CA-VIEW Reports,MVS,JCL,DB2,CICS based system, Java

Capital One,VA

QA Tester April 2010 – March 2011

Credit Card Processing –Capital One is one of the top credit card issuers in the US, the company offers plastic with a variety of annual percentage rates, credit limits, finance charges, and fees. Products range from platinum and gold cards for preferred customers to secured and unsecured cards for customers with poor or limited credit histories. Worked on testing the various functional modules of applications that are developed to provide credit card services, mortgage services, auto financing, credit insurance, and other consumer lending products.


Preparation of Test Cases, specifying description, input data and expected value.

Testing activities includes Functional, GUI and Regression testing.

Tested the functionality of the application with multiple data including positive and negative data for multiple times.

Involved in Test Cases review.

Evaluation of Test coverage and Test results.

Keeping control over versions of files & modification being made using VSS.

Responsible for logging defects in Defect Manager, monitoring their status and tracking them to closure using Quality Center.

Involved in Test Plan preparation.

Executed test cases and documented bugs found during the process of testing.

Analyzing the process of Application and preparing framework for Automation.

Involved in testing the application using QTP and manually.

Responsible for generation of automated scripts for the identified scenarios using QTP.

Coded QTP script using VB scripting as per Test Scenarios.

Running the existing scripts for each release.

Environment: Quick Test Professional, Quality Center, UNIX, Java, HTML, Oracle9i, Visual Basic

Allstate Insurance Co, Schaumburg, IL Jan 2009 – Mar 2010

QA Tester

Allstate Insurance is a largest service provider for auto insurance all over the nation, this insurance company provides insurance products that are comprehensive, innovative and competitively price. It also offers auto and homeowners policies that can be custom-designed to serve the distinct needs of the customers. In this assignment I was Involved in the entire testing cycle of MAI {Manage Auto Insurance} project. The MAI is a web based Project designed and developed for doing various online activities, like getting an insurance quote for an Auto or Property and also purchasing the same online. Customers can log on to the Allstate Web site and get a quote for any type of Auto or Property.


Reviewed the requirements of the MAI application and prepared Initial Analysis document in lieu of preparing the testing scope.

Reviewed and analyzed Business Requirements, Use Cases and High Level and Low Level Designs throughout the Software Development Life Cycle of the MAI project

Reviewed Functional Specifications and Unit Test Designs and attended for Formal Walk Through meetings

Prepared the Test Strategy /Test Approach and reviewed with stake holders including the project board to get their signoff.

Extensively involved in designing the test cases and test scripts by manually at Initial releases.

Designed and Developed the QA-Architecture in Quality Center 9.0/9.2

Extensively worked on all modules in Quality Center which includes {Requirements,Test Plan, Test Lab and Defects}

Developed Test Plan, Test Cases and Test Scripts in Mercury Quality Center 9.0 for testing the MAI Application.

Extensively involved in designing the frame work for automation of the MAI application.

Designed, Developed and executed the automation test scripts using Quick Test Pro for MAI Applications

Participated automation test scripts code reviews for each releases of the frame work depends on MAI release

Involved in designing the automation frame work for automation testing.

Actively participated in all phases of testing lifecycle.

Participated in all Status Calls, Release Management Calls, Test Case Review meetings and Sign-Off meetings.

Environment: Quality Center: 9.0,, Oracle, .NET, Java, UNIX, MS Office tools, Quick Test Pro 8.0/9.0/9.2, Windows 2000/xp, Java, J2EE, Oracle9.x, EJB, MQ Series, PL/SQL, Solaris9.x.

Contact this candidate