SONAM AGARWAL

Contact #: 401-***-****

Email: admfy5@r.postjobfree.com

Work Authorization: H1B

OBJECTIVE

To obtain a challenging position and strive for excellence with dedication, proactive approach, positive attitude and passion towards the work that will fully utilize my logical and reasoning abilities in the best possible way for the fulfillment of personal and organizational goals

PROFESSIONAL SUMMARY

8 years of experience in Quality Control into various Testing Methodologies/Models. Extended expertise in Agile/Scrum Methodology, ETL/DWH Testing, POS Testing, End to End Testing, Manual Testing, Functional Testing and System/Integration Testing.

Currently working on COVID project from CVS Health and purpose is to make the project successful by administering the vaccine to maximum number of people as early as possible.

Background of testing projects for various domains – HealthCare domain, POS, Credit Cards, Retail Banking, Investment Banking, Life Insurance Applications, Mobile Application.

Extensive experience in ETL/ Data warehouse backend testing and reports testing using Informatica power center 9.6.1.

Good knowledge on Data Warehouse concepts like Star/Snow-flake schemas, different types of Slowly Changing dimension.

Expertise in executing sessions/workflows using Workflow manager, monitoring the jobs and Analyzing session logs to identify failures/issues using Informatica Monitor.

Expertise in writing Oracle sql queries using different kind of joins, Analytical functions like Rank/Dense Rank.

Experience working on Control-M and WinSCP.

Specialized in Agile tools ARD and Rally.

Experience in HP ALM(Quality Centre) tool for adding/maintaining test cases and logging defects in QC.

Expertise in bug Tracking platforms such as TFS, JIRA and other in-house tools.

Performed the UAT certifications of Abu Dhabi Islamic Bank for POS testing at Abu Dhabi, UAE (Client office).

Excellent understanding of Business & QA processes, STLC & SDLC with emphasis on Black Box, Functional, GUI, System, Regression testing.

Experience in developing Test Plan, Requirements Traceability Matrix, end-user training manuals, Test Cases and Mock-ups.

Expertise in identifying scenarios for regression test.

Expertise in writing Oracle SQL queries using different kind of joins, Analytical functions like Rank/Dense Rank.

Coordinate QA activities with geographically dispersed technical teams and ensuring that the required level of the product quality is achieved, and Testing is performed in accordance with the test plan and processes.

Coordinated with Business, business analysts, developers, and technical support to provide baseline in acceptance criteria and requirement specifications.

PROJECT UNDERTAKEN

Title: RxConnect

Client: CVS Health, Lincoln, RI

Duration: Oct 2019 to till date

Domain : Retail Health Care

Description: RxConnect is an online transactional software system, enabling a pharmacy to fulfil the needs of prescription filling and drug dispensing activities. This system permits distribution of the prescription filling activities, enabling the pharmacy to complete the process in a shorter period of time.

All the pharmacies stores are connected through a centralized database which contains the data about Patients, Prescribers, Drugs and other entities. There are hundreds of batches that load the data in to the system and also generate several reports for business users.

Roles and Responsibilities:

Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings and executed them.

Monitored test execution and recorded test results.

Verifying the data in target database by ETL process

Developed and executed Sql Queries in Oracle database.

Managed End to End testing for COVID. Coordinated Go/No Go meetings at the end of testing

Reported defects found during testing into Rally.

Involved in smoke testing to ensure that code delivered is stable and ready to be tested.

Extensively interacted with developers, business& management teams to understand the business requirements and ETL design document specifications.

Supported other test team members and associated IT and Business resources as appropriate to the implementation of testing related activities.

Worked on issues with migration of Data from development to QA-Test Environment

Title: Prime 4

Company: TSYS International, NOIDA, INDIA

Duration: Sept 2013 – Jan 2016

Domain : Banking- Credit card

Client: ADIB, ICICI, SAMPAT, RAKH, SBH, BAHIO

Description: PRIME by TSYS is the highly parameterized solution for credit card related process both for Issuer and Acquirer banks. The whole product provides solution for all required services involved in processing of credit cards from card creation to online authorization of transaction at the time of making authorization to payment settlement like encoding, embossing, statements, transactions posting, interest, services, reward, collection, dispute, workflows etc. with multilingual, multi-institutional, multi country and multi-currency support.

Online system works at Issuer and Acquirer end, right from the swiping of card till receipt generation.

Roles and Responsibilities:

Developed and executed the test scripts.

Running the jobs/Workflows for ETL process

Developed and executed Sql Queries in Oracle database.

Verifying the data in target database by ETL process

Verified column mapping between source and target

Prepared test data for functional & Integration testing

Interactions with BA & Dev teams to resolve the issues.

Reporting daily testing status.

Identified Test cases for Regression testing

Designed scripts using QTP for regression testing.

Defect Analyzing and Reporting in QC

Status reporting, project tracking, documentation, and reporting.

Involved in daily status reporting for Agile Team.

Provided accurate estimates for work and communicate progress effectively and in a timely fashion

Title: ProLaw

Company: HELM360, NOIDA, INDIA

Role: Manual Tester

Duration: Feb 2013 – Aug 2013

Domain : Finance

Client: Thomson Reuters

Description: The ProLaw software suite is designed to automate the practice and manage the business of law. Comprehensive features simplify, streamline and coordinate the work of attorneys and staff in small and mid-size law firms, corporate legal departments and government agencies. Built from the ground-up on a single database, ProLaw combines case and matter management as well as time entry, billing and accounting capabilities within a single integrated solution.

Roles and Responsibilities:

Developed and executed the test scripts.

Developed and executed Sql Queries in Oracle database.

Prepared test data for functional & Integration testing

Interactions with BA & Dev teams to resolve the issues.

Reporting daily testing status.

Identified Test cases for Regression testing

Designed scripts using QTP for regression testing.

Defect Analyzing and Reporting in QC

Status reporting, project tracking, documentation and reporting.

Involved in daily status reporting for Agile Team.

Provided accurate estimates for work and communicate progress effectively and in a timely fashion

Title: Lifespeed(An Ebix product)

Company: Ebix Software, NOIDA, INDIA

Role: Manual Tester

Duration: March 2010 – Feb 2013

Domain : Life Insurance

Clients: MetLife, Fidelity, ING, CBIZ, BANNER, AMERICAN GENERAL, First Protective, 3mark/Peleton,WFG Canada

Description: LifeSpeed is an Policy Management system. This Platform is a standards-driven, rules-based, technology platform that automates order-entry and compliance oversight of life insurance. Our platform offers your firm complete control over your life business while ensuring that virtually every policy is processed in good order. The platform provides an easy-to-use, online life insurance application process that is error-checked and validated against detailed product rules – in real time – at the point of sale. The application package is then transmitted via the Internet to the insurance carrier where the contract is physically issued.

Roles and Responsibilities:

Developed, Reviewed and Executed Test Scripts.

Test case up gradation with the newer builds.

Preliminary discussion of the project with the core team as a walkthrough

Secondary discussion of the project with BA’s

Prepared the estimates and scheduled them for the deliverables

Guided the developers for requirement gathering, helpful in Unit Testing too.

Participated in various meetings and discussed Enhancement and Modification Request issues (Change Requests)

Established testing guidelines

Logged the defects in iTrack (Internal Tool) for Defect tracking

Reported the Testing Status to the Project Lead

Worked on Production Support

CERTIFICATION

ISTQB Certification.

Declaration

I do hereby declare that the information and particulars furnished above are true to the best of my knowledge.

NorthAttleboro, MA Sonam Agarwal

Contact this candidate