VARSHA BHAVSAR

908-***-****

Email: acn1ne@r.postjobfree.com

EDUCATION

ESSEX COUNTY COLLEGE

• Associates program for Health Information Technology (HIT) – Technical/Software Support Staff

• Electronic Health Records (EHR, PHR, ICD 9, CPT, JACHO, HIPPA)

• Completed online course- SAP Business Warehouse, Business Intelligence, Business Objects

GUJARAT UNIVERSITY

• Bachelor’s Degree, 1985

WORK EXPERIENCE

BRISTOL-MYERS SQUIBB PLAINSBORO, NJ

SYSTEM VALIDATION & UAT TESTER FEBRUARY 2014 TO PRESENT

Work with project SMART and OPS SMART involved main sources as APLD, IMS-Claims, Rule 867,

Medivo, Nav-Cancer, EMR to validate active BP ID, BPA ID, all External IDs like, NPI, IMS

number, Wk number, AOA number, AMA number of prescribers with exact full name, exact

addresses, fuzzy full name, fuzzy addresses, exact zip code for Individual & Organizations.

ENVIRONMENt: MS Office, ETL Informatica,data warehouse, .Net, Java, Quality Center 11.0, SQL Server, Windows XP, Windows

2003, UML, HTML, Web Services, Internet Explorer, Mozilla Firefox.

RESPONSIBILITIES:

• Understand the requirement, Plan, create a test cases and execute test cases for maintaining a

database, manipulate data and retrieve a data

• Pulled data for testing different rules covering matched, Unmatched, Exceptions in positive, negative

scenario by using SQL server, Create data sheets for all different rules, convert datasheets into text

files to upload on Secure File Transfer server

• Convert text files into XLS files to match and validate data for CAT (Customer Administration Tool),

MDM Data Director Application Informatica, BI Prod and BI Test (SAP Business Objects for

Production and Testing)

• Creating scripts from requirements and pulling test data for positive and negative testing scenarios

to cover all rules and satisfy all testing conditions in accordance with the company’s computer

systems validation policies with in project.

• To participate in the UAT testing execute all UAT scripts to ensure operational quality, system

integrity and verify system process meet user needs, including all user acceptance testing activities.

• Performed execution of test cases manually to verify actual result meets the expected results using

QC ALM.

• Good documentation practices for validated systems create all required pre and post testing

documents, Log and report result of testing.

• Create Requirement Traceability Matrix report document prior to execute test cases and map the

results of testing functionalities for software requirement on each step of testing

• Update Requirement Traceability Matrix upon full testing cycle completed and post on server

• Track and investigate issues, log and report defects as find.

• Knowledge of the 21 CFR Part 203 and Part 11desirable relationship to validation of systems that

support regulated pharmaceutical industry.

• Work with other members of the Customer Data Operations Team, IT, QA to ensure a quality

product is deployed.

NEW YORK LIFE INSURANCE CO SLEEPY HOLLOW, NY

TEST SPECIALIST SEPTEMBER 2012 TO FEBRUARY 2014

ENVIRONMENT: MS Office, .Net, Java, IBM Rational Quality Center ALM, QTP, Lotus 8.5,JIRA, Share Point,

Oracle, Windows XP, Windows 2003, UML, HTML, Web Services, Internet Explorer, Mozilla Firefox,

Safari, Chrome

RESPONSIBILITIES:

• Analyzed business requirements, functional specifications to provide inputs to develop Test Plan and

Test Cases.

• Developed the testing strategies and test plan for cross-platform testing.

• Work with Agile Scrum methodology with Software Development Life Cycle

• Test case review, Test Plan, Test data identification and creation. Test Case execution find defects,

Login to ALM, Track and retest pass closed defects/fail resend to assigned professional

Documentation of all activities and Report to lead.

• Work with Agile Scrum methodology with Software Development Life Cycle

• Test case review, Test data identification and creation. Test Case Development/Preparation, creation,

updates and Execution of Positive testing and Negative testing

• Worked on data migration process and validated ETL ( Extract Transfer Load) based on mapping documents

• Performed execution of test cases manually to verify actual result meets the expected results using QC ALM.

• Logging defects in Problem Log Book-Lotus Notes retest once they are fixed and move to Closed, sign off status using QC

ALM.

• Create Requirement Traceability Matrix report document prior to execute test cases and Update

Requirement Traceability Matrix upon full testing cycle completed

• Worked with business analysts and developers to resolve issues, Worked closely with development

team, and off shore team.

• Used TOAD to Inspect and Verify Back end Database Tables for error logs and update the reports.

• Attend daily scrum meetings, weekly meeting with development team, reporting project status and

setting goals to complete.

• Report daily activities to lead and prepare weekly reports of work and submit to Lead.

UPS TIMONIUM MD

QA ANALYST JANUARY 2012 TO AUGUST 2012

ENVIRONMENT: MS Office, ETL data warehouse, .Net, Java, Quality Center 11.0, Oracle, Windows XP,

Windows 2003, UML, HTML, Web Services, Internet Explorer, Mozilla Firefox.

RESPONSIBILITIES:

• Worked on waterfall methodology with Software Development Life Cycle phase

• Analyzed business requirements, functional specifications to provide inputs to develop Test Plan and Test Cases.

• Test Case Development/Preparation, creation, updates and Execution.

• Test data identification and creation. ETL ( Extract Transformation and Load)testing

• Understanding of data to be reported and Understanding and review of data model

• Understanding and review of source to target mappings (transformations)

• Data Quality Assessment of Source data

• Packages testing and Verify Data completeness

• Verification of transformation rules

• Comparison of sample data between source and target

• Checking of referential integrities and relations (primary key foreign key)

• Data Quality checks on target warehouse and Performance tests

• Internal test case review and Internal review rework.

• External test case review and external review rework.

• TCAMS test cases input, perform regression testing.

• Test Data Development, Platform/Browser Testing.

• Coordinated with the other teams and Developers team involved in the testing.

• Worked with business analysts and developers to resolve issues.

• Logging defects and Change Control Requests in Quality Center 11.0

• Participate in Team planning by attending daily scrum meetings, weekly meetings.

• Reporting project status and setting goals to complete the assignment including Requirement Traceability Matrix creation

and update Requirement Traceability Matrix status.

• Support in deployment activities and Implement quality of product.

PHARMERICA

RAHWAY NJ

QA ANALYST FEBRUARY 2009 TO DECEMBER 2011

ENVIRONMENT: MS Office, .Net, Java, Quick Test Pro, Load Runner, Quality Center, Oracle, SQL Server, My

SQL, VB.NET, Windows XP, Windows 2003, UML, HTML, Web Services, Internet Explorer, Mozilla

Firefox.

RESPONSIBILITIES:

• Analyzed business requirements, functional specifications to provide inputs to develop Test Plan and

Test Cases.

• Developed the testing strategies for cross-platform testing.

• Performed Functional, GUI, Regression, System Integration and content testing for the

Applications.

• Generated test scenarios, test cases and test data. Executed tests, created status reports keeping under

roof of HIPAA and JACHO

• Worked with business analysts and developers to resolve issues.

• Worked closely with development team in creating automated scripts for the application using Quick

Test Professional.

• Logging defects and Change Control Requests in Quality Center

• Sign off on testing as phases are completed with release management.

• Installing new builds in test environments and managing the test environments.

• Executing End of day procedures and Regression Tests during testing phases.

• Executing manually and planning for automation of various modules in the application.

• Participated in various Team planning and retrospective meetings with Business Analysts to discuss on

Enhancement and Modification requests.

• Developed Integration, System, Regression and Post Implementation Test cases to cover all over

Quality and Assurance Testing.

• Used Data driver wizard to create data driven tests, for testing the application with multiple sets of

data.

• Did extensive Regression testing on the new builds and executed the scripts

• Investigating bugs and interacting with developers to resolve technical issues and use Quality Center

to log and track defects.

• Responsible for interacting with developers to fix the problems especially pertaining to database,

which are not populated to the online screen when customer enters his quote.

• Performed Acceptance testing, documentation of testing process and trained the end users

• Used TOAD to Inspect and Verify Back end Database Tables updates by writing SQL Queries

• Attend daily scrum meetings, reporting project status and setting goals to complete

HBCS MORTGAGE CORPORATION E DISON

NJ

QA ANALYST J ULY 2007 TO NOVEMBER

2008

ENVIRONMENT: Quality Center, TSYS, QTP, SUN IDM 8.1, UNIX, VBScript, HTML, Oracle, MS Windows

NT/XP/2000

RESPONSIBILITIES:

• Conducted System Integration Test including Physical Configuration Audit (PCA), Functional

Configuration Audit and Thread Test.

• Reviewed the Test Plan maintained by the team.

• Participated in preparing the Functional and System Requirement Document.

• Performed System Integration Testing.

• Also testing for Loan/Lease origination component, APR, banking and credit card issues with

accounting department

• Written the Detailed Test Cases to cover all the steps to perform the procedure.

• Performed execution of test cases manually to verify actual result meets the expected results.

• Prepared System Anomaly Reports (SARS) for the defects identified during testing.

• Coordinated with the other teams involved in the testing.

• Participated in the Daily Scrums meeting.

• Retested the SARS to ensure that the defects are fixed.

• Prepared the SAR Document in detail with all the information required.

• Prepared Daily Status Report to make sure that test case coverage has been done accordingly.

• Interacted with the developers regarding priority of defects and update the status of defects once they

are fixed.

• Performed Sun IDM identity management to verify client’s identity in lifecycle on business level.

Auditing systems, which are integrated to perform the procedure.

• Used Stubs and Drivers to perform the testing.

Contact this candidate