NAMRATA DONGRE

Cell: 732-***-****

Email: acu0qz@r.postjobfree.com

Work Authorization Status (US):Green Card

PROFESSIONAL SUMMARY

Software Tester with more than six years of experience in Banking, Financial and Retail & Health Care Industries with strong Business and Functional Knowledge.

Experience in all phases of software life cycle, including requirements analysis, planning, designing and execution of tests, defect tracking and bug reporting.

Expertise in writing and executing test plans, test scripts, test cases and test data in highly structured and loosely structured development environments.

Strong Experience in Web services testing using Selenium and SOAPUI for Functional and Regression Testing.

Experience working in Waterfall, Iterative and Agile Methodologies.

Good knowledge and experience of providing quality assurance in web based applications including GUI testing.

Experienced in black box testing of web based applications built on ASP.NET and Java.

Experience of using relational databases such as SQL Server and Oracle databases.

Very good at bug-reporting and bug-tracking using the test management tools HPALM /Quality Center, Jira and Bugzilla.

Performed Functionality Testing, System Testing, System Integration Testing, GUI testing and Regression testing supported, User Acceptance testing

Excellent communication skill, self-motivated, detail oriented, time bound, responsible team player and Ability to coordinate in a fast changing agile team environment.

SKILLS SUMMARY

Test plan, test cases creation, System & Integration test execution

Technical & Functional specification requirement analysis

Defect tracking, logging,reporting, retest and follow up till defect closure

Issue Identification & Documentation, Defect Management

Strong experience in Web services and UAT testing

TECHNICAL SUMMARY

Methodologies: Agile Scrum, Waterfall, Iterative

Platform: SAAS.

Test Management Tools : HP Quality Center/ ALM 12.02/11.X/10.X/9.X, Test Link,

Automated Testing Tools : UFT/ (QTP) Quick Test Pro, SOAP UI, Selenium

Defect Tracking Tools: Jira, Bugzilla, Clear Quest. HP ALM.

Database : MS SQL Server 2005 and 2008 R2,MongoDB,Oracle

Languages SQL, Visual Basic, HTML, XML,C,

Project Management Tools: MS Excel 2010, Word 2010, PowerPoint, Visio, Microsoft Project.

Operating Systems: Windows XP / Unix, IBM AIX, Windows Vista,Windows MS

Web Browsers : Internet Explorer, Firefox, Safari, Chrome

Client: Wells Fargo - Minneapolis, MN

Role: Business System Analyst

Feb 2016 –April 2016

I was involved in the initial planning phase of Castlight application implementation for Wells Fargo employees. Purpose of the Castlight application is to provide the information to the employees to compare the cost and quality of various Health care providers. It is a cloud based application, provides software services (SAAS) to Health insurance providers and employers for their employees. It is a market leader in this sector.

Castlight application integrates with Employer's (Any industry) Health Insurance system using Web Services . All the information transferred in XML format between Castlight an employer's health care system.

Project was designed to implement under Water Fall Methodology. As my role was a Business System Analyst, I was mainly involved in developing the Business Requirement and Test Planning. To create the Test Plan we use the Wells Fargo template.

Responsibility:

Developed test plans and requirement based on Castlight Functional Requirements / Low level design documents.

Created the Eligibility file for Castlight for data enrichment on the basis of their Health plans, HRA, HSA and FSA. This file I created in the format required for ETL process. So the Castlight would be able to extract the data from heterogeneous data sources like Peoplesoft and different Health partners

Performed testing on XML web services to fetch the data from Peoplesoft for Castlight.

Attended weekly meetings to update the development to team leads and Manager.

Identified the few scenarios where SOAP-UI needs to be used to test the integration with health provider and employer’s HR database. We also identified that, this application is going to make the asynchronous call based on the batch job processing. The integration tool Rally is used for this purpose.

Environment: Waterfall, People soft, ALM 12.02, Excel, word, Power Point, Visio. XML Web Services. ETL Data Warehouse testing tool.

Client: Wells Fargo - Roseville, MN

Role: System QA Analyst

August 2015 –Feb 2016

Working on various IRT web applications developed for Retirement and 401K plan which includes customer savings plan, retirement plan and Hogan plan. These plans are designed and developed for Wells Fargo customers and for various big corporate clients. Worked on Version-one to keep track of assigned Backlogs and updates the hours during the each sprint. Version One is a great tool to update to work status of the project developed under Agile.

As a Quality Analyst, my job was to test the backlogs created for the Web Enhancement, ACH payroll system and various plans for the Participants and clients. Small web enhancement includes both internet functionality and mobile usability.

Responsibilities:

Developed test plans and test cases based on Functional Requirements / Low level design documents.

Involved in Data warehouse testing while sourcing data from multiple sources.

Attended sprint planning meetings and everyday Scrum call and report day to day updates to the Scrum Manager.

Validated the data and perform regression testing in Production and performed End user Data Validation.

Extensively used ALM for test planning and test execution and defect login, reporting.

Detected Defects, Communicated to developers using Bug Reporting tool and Tracking Defects using ALM.

Involved in ACH payroll regression testing using QTP and generate VB test scripts to test the functionality of system which support the fund transfer from one account to another maintaining the customer's personal information through the process.

Uploaded test scenarios, test cases to Quality center and SharePoint. Documented and summarized test results and report findings.

Participate in Project Manager / Tech Leads walk through and defect report meeting periodically,

Performed Smoke testing before the production.

Discussed issues with Developer team located offshore everyday and update the status to onshore team.

Web based Application runs on Unix base operating system.

Environment: Agile, HP quality center ALM 12.02,Toast SQL(Toad), Unix and Sybase. Lotus . Snipit, Snag It, Share point, Version one.

Client: User Testing

Role: Freelancer QA Engineer

April 2015 -July 2015(Still works occasionally)

User Testing is a company which helps various clients (which includes Large and Medium scale corporations) to perform the Quality and user acceptance testing. I was registered with them as a free-lancer QA Engineer. I was involved in browser based testing as well as mobile testing for various applications. One of the applications was for the NFL (National Football League).

Responsibilities:

Involved in creating test plan for the various scenario testing

Performed the user acceptance testing and bug reporting

Perform various mobile app testing mainly on “Android” Platform. Involved in mobile payment application testing where I had to do purchase from various retail shops using the payment application from the android mobile phone.

Client: Prime Therapeutics - Eagan, MN

Role: QA Engineer

January 2014 -March 2015

IPS (Integrated Product Solutions) is an application for integrating medical and pharmacy health benefits and access to different types of member health savings accounts.

Responsibilities:

Performed Functional, Acceptance, Usability and Regression testing during different stages of the application development using agile methodology.

Attended Sprint Meetings.

Validated whether the IPS messaging is processed perfectly between Prime and the client (health Plan).

Validated the Report Layouts (Out of Balance report, Failed Medical Load error report, IPS Metrics report) and verified whether they are sent to the Client (specific health plan) correctly.

Experienced in simulating client environment using SOAP-Tithes testing was to validate the APIs and Web Services created to integrate with Health care provider database and employer’s database. This integration is based on the synchronous call.

Experienced in writing SQL queries to validate the Member information for the particular health plan and executing test cases.

Performed Test data construction, test execution (test lab) and Logged defects during Execution in HP quality center.

Performed end-to-end testing to ensure the validity of Business requirements.

Environment: Agile,HP quality center 10.0, SOAPUI and SQL, Version -One. Excel.

Client: BlueCross Blue Shield of IL

November 2012– December 2013

Quality Assurance (QA) Analyst

Overview

The project was designed and developed in accordance with Affordable Care Act using Waterfall methodology. I was responsible for testing the Cost Share Application to calculate the copay for eligible enrollees, and performing financial true up against the payment file provided by the government.

The inter plan reporting project was a mandate from the BlueCross Association. The team was responsible for delivering a plan specific enrollment report grouped by the area zip codes.

Responsibilities

Analyzed Affordable Care Act (ACA) Business Rules, Data Specifications, end to end Flow Diagrams, Use Cases, and designed testing process flow.

Reviewed requirement documents for accuracy, clarity, and requirement testability.

Performed Functional, Black Box, integration, System, and Regression testing.

Prepared Test data to enable the software to be quality checked through automation using Quick Test Pro (QTP).

Developed the Test Cases in Excel and attached to the corresponding QC

Re-opened the QC with issues, followed up with the Developers, retested, and closed them

Performed Security Testing at the Administration/User level by modifying/updating the Security tokens

Supported the User Acceptance Testing (UAT) and trained the end users based on the Use Cases

Attended Stand up Meetings to be up to date on the progress of the projects and provided the status updates.

Generated SQL queries to validate various reports, loads and extract processes.

Environment: HP ALM 11. QTP 11.0, IBM DB2, MS SQL, Web 2.0

Client: Ohio Valley Bank, Gallipolis, OH

March 2011 – October 2012

Role: QA Analyst

Overview:

Bank of Ohio Valley is the primary subsidiary of Bank of Ohio Valley Bank Corporation, a regional bank holding company. I worked as a QA Analyst with Ohio Valley Bank for development of an application for managing various Fixed Income & Interest Derivative products on web and also on mobile phones. Application is used to store the information about Interest rate derivative products including all derivatives containing an interest rate element in it.

This Application provided the 'Account Lists' (types of accounts), 'Account Summary' (balances, last deposits etc.), and 'Account Transactions' (Transaction Details) for the various accounts and the ability to transfer funds between the various accounts using 'Fund Transfers'. The application also allowed users to change the account options such as changing their 'User ID' and 'Password'. The application also allowed users to submit account-related queries to the bank including ordering checks, requesting copies of checks and statements etc.

Responsibilities

Responsible for implementing the QA process at all phases of Software Development Life Cycle (SDLC)

Attended Review meetings to discuss Use-Cases, Business Rules, Message Rules, Alternate flows and Exception paths.

Performed Smoke, GUI, Integration, Functional, Regression, Data Integrity, System Compatibility, installation and User Acceptance Testing.

Black box and White box testing was implemented as testing methodology.

Worked on the Regression Automated Testing and Data driven testing using Quick Test Pro/UFT.

Created Synchronization points to synchronize the Test script to the Application speed in Quick Test Pro.

Extensively used Test Management Tool Quality Center to manage and execute test scripts.

Experience in Selenium.

Used Quality Center for tracking the defects.

Used SQL queries to extract the data from the database to check the data integrity.

Involved in performing Sanity Testing of application for Post Deployment Production Testing.

Generated Test Data for Automation Scripts in Excel from QTP.

Involved in performing Load, Performance, Stress and Stability testing using Load Runner.

Attended Walkthroughs and review meetings with Business Analysts & Development team.

Environment: Quick Test Pro, Load Runner, Quality Center, SQL Server, HTML, Web Services, Java Script, VBScript, UNIX, MS Excel and Windows.

Client Name: Kohl’s, Wisconsin

August 2010 – February 2011

Project Description: POS Software System Enhancement

Role: QA Analyst

Kohl’s is retail department store who provides garments, jewelry and household items to their customers using high tech POS computer system. I worked on the Kohl’s Smart POS software system enhancement project. This is a windows based application which includes different modules such as credit card activity, payments, purchases, returns and exchanges. The POS application was implemented and tested with the user’s ability to scan UPC bar codes.

Responsibilities:

Worked in an Agile Methodology. Attended daily stand ups and sprint plan meetings every two weeks to review the user stories for Smart POS software.

Analyzed Business Requirement Document (BRD) prior to preparing the test cases for purchase module.

Used Quality Center for preparing the test plans and manual test scripts

Worked closely with Development team to discuss the design and testing aspects of the applications to design the Test plans

Wrote Test Cases for functionalities of purchase module based on the requirements.

Bugs were reported to Developers using QC

Interacted in Peer Review to verify the accuracy of the test cases against requirements.

Created a Traceability Matrix to map test cases with requirements to ensure complete test coverage of functionalities for customer look up.

Executed Smoke Testing of the application once deployed in testing environment as part of entrance Criteria of returns.

Participated in Component Testing for employee log-ins into the application with employee ID and Pin number.

Performed System Testing to review the system’s ability to create purchases or returns of scanned merchandise by using UPC code.

Engaged in UI Testing to test the usability, look and feel of the application based on the customer’s specifications of POS functionalities.

Responsible for weekly status meetings showing progress and future testing efforts. Performed Functional Testing for the merchandise look up module by UPC code to search in different store locations.

Wrote SQL queries to retrieve pricing for each item by category from system database.

Conducted Regression Testing after the defects were fixed to make sure other components of the application is still working properly.

Environment: Agile Model, Windows-7, Java, Oracle 10g, Quality Center-10.0, SQL Toad- 9.0

Client: True Position, Philadelphia PA

(Feb 09 - July10)

Role: QA Tester

Overview:

True Position is a leading solution provider custom Geo-Location and intelligence and interception. True Position was building a remote tracking system for commercial and personal usage. I was involved in the testing of their one of the Geo –Location solution.I was the part of the team who was driving the testing of their enhanced 9-1-1 calling solution. Application involves adding area code and location to tracing device. Tracking device was to link with satellite signals which can trace the mobile device.

Responsibilities:

Involved in Test Plan and Test Plan review meetings to provide assistance to the Test Lead.

Performed positive and negative testing using data driven test approach.

Wrote and implemented the Test Cases/Test Scenarios.

Executed the test cases in the execution phase and also involved in the creation of the Requirements Traceability Matrix.

Prepared and executed Test Cases to Test the functionality of the application.

Interact with the business analyst to understand the business requirements.

Analyzed, maintained test results and reported defects to the development team.

Participated in Regression testing.

Environment: Windows-6, Java, Mercury Quality Center-3,MS Excel,SQL,HTML,

Educational Qualification:

Master’s in Public Administration: Nagpur University, Maharashtra, India

Bachelor of Science:Nagpur University, Nagpur University, Maharashtra, India

Contact this candidate