Test Cases Project

Asavari Pawgi

Actimize QA Consultant

Contact +1-646-***-****

Email: ************@*****.***

PROFESSIONAL SUMMARY:

6.5 years of professional experience in Surveillance and Compliance Functional Testing, ETL testing, Defect Management, Software Testing Life Cycle, Test Plan, Test Strategy

STRENGTH

Extensive experience in data centric testing, data workflow validation, ETL mapping validation.

Hands on experience in executing automated scripts using QTP

Experienced in NICE – ACTIMIZE for trade surveillance models validations for Equities, FI and Derivatives.

Experienced in validation of Trade Surveillance models designed for Dodd Frank compliance.

Demonstrated experience in Anti Money Laundering and Compliance application testing

Strong experience in different testing Methodologies like Waterfall model, V model & Agile model

Skilled in System Integration Testing (SIT), Interface Testing, System Testing, Regression

HP Quality Centre 9.2,10.0/HP ALM 12.0 used for Test Management.

Skilled in generating various graphs and reports from ALM application

Strong hands in preparing Test Plan, Test Scheduling, and Test Estimations.

Managing a project release, task allocations within the team, sharing daily updates with project stakeholders

Ability to work efficiently and effectively under stressful, high pressure and tight deadlines

Driving Defect Triage calls and managing the entire Defect Life Cycle.

Managing Test Closure activities like Test Summary Report, Test Closure Report, Knowledge Management, Lesson Learnt documents.

EDUCATION & CERTIFICATIONS

Masters in Software Engineering (MS)

Bachelors in Information Technology ( BSc)

WORK EXPERIENCE

Employer: 3EDGEUSA GROUP LLC, NJ

Client: Sumitomo Mitsui Banking Corporation

Period: Sept’16 – Till Now

Role : Actimize QA Consultant

Independently working on Anti-Money Laundering project with responsibilities as requirement analysis, test planning, test management, defect reporting and management. Co-ordination with Development team, BA and SME to understand the business requirements in detail.

Design of Test Scenarios and Test Cases based on signed off FRS.

Performing Test Execution and broadcasting daily status reports.

Defect management using ALM. Logging defects and tracking it to closure

Create following deliverables:

Test Plan, Test Scenarios, Test cases, Defect Summary report, Status Summary report, Test Summary Report etc.

Employer: Wipro Ltd

Client: Credit Suisse

Project: Trade Surveillance

Role: Lead QA Analyst

Duration: Jan 2015-Sept 2016

Tools Used: ACTIMIZE, QC, ALM, Ctrl-M, PL/SQL Developer, Putty (UNIX)

Project Description: 1. Trade Surveillance solutions which enable the firm to more closely monitor a broad range of products to identify non-compliance issues and record activities.

Roles & Responsibilities

Trade Surveillance:

Contribute in understand the business requirements of the Actimize model along with BA team

Work closely with business analyst team to design the functional requirements and prepare Functional Requirement Document (FRD)

Design test strategy and test plan in accordance with the project scope and requirements.

Prepare QA effort and resource estimates in accordance with the timelines and budget defined by the project management

Prepare test scenarios to cover all the functional requirements and non-functional requirements

Prepare test cases for ETL validation by designing complex SQL queries using joins and subqueries

Prepare test cases for Actimize Risk Control Manager (RCM) usability testing and validating Trade

Surveillance model detection

Run required ETL jobs through Control-M, Informatica. Analyse the data loaded for accuracy and prepare test data

Test execution/Defect Management and Test Closure according to defined best practices, standards and procedures and work with on shore/Off Shore Team

Perform defect root cause analysis (RCA), interact with related teams, and track defects to closure

Coordinate with Project Managers, Development Team, Business Analysts, and End-Users for better quality

Testing.

Assist Automation team in building automation scripts.

Drive project status calls and provide accurate and timely project updates to stakeholders.

Maintaining risk and mitigation plans and communicating to the stakeholders

Review project status and acquire sign-offs from IT Project Manager.

Preparation of RACI metrics and sharing it with various stakeholders.

Preparation of EPD and Lesson Learnt documents after every release serving

Organize and/or facilitate new team members with required functional and procedural training.

Planning the resources for the Cross skilling

Conducting Knowledge Management sessions across the team (onsite as well as offshore)

Design and maintain following deliverables:

Test Strategy, Test Estimates, Test plan, Test case design, status reports (Daily, Weekly, and Monthly etc.),Defect summary report, Test Summary Report

Client: Credit Suisse

Project: LCDB (Legal Compliance database)

Role: Senior QA Analyst

Duration: Dec 2013 –Dec 2014

Tools Used: ACTIMIZE, QC, ALM, Ctrl-M, PL/SQL Developer, Putty (UNIX)

Project Description: Legal Compliance Database is a central data repository for majority CS internal systems.

Legal Compliance Database (LCDB)

Work with BA, PM team to understand business and functional requirement of the ETL changes.

Understand the impact to downstream applications and prepare test scenarios accordingly

Prepare test scenarios as per the scope of functional requirements to be covered

Prepare test cases to validate the ETL changes using complex joins and subqueries

Communicate with various downstream application teams to provide the data extracts and to explain the impacts of the changes in their respective data feeds

Communicate with Data Anonymization team to acquire data masking of necessary data feeds before consuming the data for testing

Perform ETL validation to cover all the test scenarios designed.

Report bugs identified during ETL validation and track those to the closure with appropriate interaction with relevant teams

Prepare daily status report, weekly status report

Contribute in weekly status call with various project stakeholders to provide the status update

Prepare Lessons Learnt and other related closure documents after QA sign-off

Contribute in conducting training session for new team members

Contribute in preparation of Knowledge Transfer documents

Execute test case and keep track of defects.

Create test data to be used for execution.

Support Performance testing and provide suggestions when required.

Contribute to implementing and configuring test management tools

Participate in knowledge sharing session internal and cross-teams.

Create and maintain following deliverables:

Test Strategy, Test Estimates, Test plan, Test case design, status reports (Daily, Weekly, and Monthly etc.), and Defect summary report

Client: Credit Suisse

Project: PA Trade

Role: Senior QA Analyst

Duration: Aug 2012- Dec 2013

Tools Used: ACTIMIZE, QC, ALM, Ctrl-M, PL/SQL Developer, Putty (UNIX)

Project Description: PA Trade is a internal tool to manage employee’s personal trade transaction process and monitor it.

PA Trade

Leading team of 3 members

Work with BA team to understand functional requirements and design the scope document accordingly

Design test cases for data feed file using UNIX commands

Design test cases for ETL validation (staging to temp) using complex SQL queries

Design test cases for GUI field mapping validation

Report bugs and track to closure

Test Closure documents, status reporting

Create test data to be used for execution.

Work with project managers, business analysts, development teams as well as business community to contribute to the process of gathering and reviewing business requirements

Review project documents and provide QA comments and sign off

Execute test case and keep track of defects.

Support Performance testing and provide suggestions when required.

Contribute to implementing and configuring test management tools

Participate in knowledge sharing session internal and cross-teams.

Create and maintain following deliverables:

Test Strategy, Test Estimates, Test plan, Test case design, status reports (Daily, Weekly, and Monthly etc.), Defect summary report, Test Summary report etc.

Client: Northwestern Mutual

Project: The Network Connection, Business Planning Analysis.

Role: QA Engineer.

Duration: July 2010- July 2012

Tools Used: QC, ALM, Ctrl-M, PL/SQL Developer

Project Description: 1) TNC (The Network Connection) - Online database used to manage client and recruit information.

2) BPA (Business Planning Analysis) -Application that helps organization to plan its financial needs. Major areas supported are Business Continuation, key employee identification, managing business expenses etc.

Roles and Responsibilities

Understanding the FRD and logging issues as a part of FRD verification process.

Effort Estimation for a release.

Co-ordination with Development team, BA and SME to understand the business requirements in detail.

Design of Test Scenarios and Test Cases based on signed off FRS.

Performing Test Execution and broadcasting daily status reports.

Defect management using ALM. Logging defects and tracking it to closure

Create following deliverables:

Test Plan, Test Scenarios, Test cases, Defect Summary report, Status Summary report, Test Summary Report

Contact this candidate