Summary

More than * years extensive experience as Software Quality Assurance (QA) Tester in Health care, Mortgage, Insurance and Finance Domains with complete understanding of SDLC and STLC. Strong experience in defining test methodology, designing and executing test plan, test strategy, test Scenario, user story, use case, test case/script, bug reporting and documentation. Ample experience working under Agile/Scrum and waterfall methodologies environment. Strong experience in conducting Unit, System, Functional, User Acceptance, Black Box, White Box, Regression and Integration testing. Extensive experience in writing SQL Syntax to validate and verify both backend database and front end testing. Practical experience in using different testing tools that includes ETL (Informatica Power Center), SOAPUI, Really 1.3.1, Firebug, Selenium, JIRA, QTP with VBScript and XML validation Stylus Studio. Ability to rapidly learn new concepts together and highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills and Leadership Qualities.

Computer skills

AUTOMATION TOOLS

SOAPUI, QTP

TEST MANAGEMENT TOOLS

Quality Center, Test Director

REQUIREMENT MGMT TOOLS

Quality Center, Rational Requisite Pro, Clear Case

BUG TRACKING TOOLS

Team Track, Rational Clear Quest, Quality Center, JIRA

PROJECT METHODOLOGIES

SDLC, Agile, Waterfall and STLC

SCRIPTING

XML, HTML, VBScript, JavaScript

LANGUAGES

XML, HTML, SQL, UNIX command

WORK FLOW TOOLS

MS – Visio, MS – Project, MS – PowerPoint, MS – Word, MS – Excel

DATABASES

Oracle, MS SQL Server, DB2, Teradata, Sybase

REPORTING

Business Objects, Crystal Reports, BI

OPERATING SYSTEMS

Windows, UNIX

EXPERIENSE

Data warehouse / ETL Tester VCP, VA Jan 2014 – Present

Virginia Care Partners (VCP), a physician-led healthcare provider wanted to develop a clinical data repository (CDR) system to allow the physicians and other staffs to perform data mining for internal research, billing and prescription purposes. The project also involved in designing a streamlined process for Claims Processing and Payments.

Responsibilities

Work on informatica power center 9.0 to connect multiple repositories and folders, view and edit sources, targets, transformations, mapping and display the status, to view workbooks that contains large mappings or a lot of objects during ETL Testing, to view instance and target data while run Debugger to debug a mapping.

Reviewed the Business Requirement Documents and the Functional Specification.

Prepared Test Plan from the Business Requirements and Functional Specification.

Analyzed the objectives and scope of each stage of testing process from the Test plan.

Interacted with business analysts to gather the requirements for business and performance testing.

Participated in the Manual vs. Automated testing decision-making process.

Responsible for testing the Navigation Flow, Functionality Testing, System Testing and User Acceptance Testing.

Interacted with users and vendors for full life cycle of project.

Prepared test data and helped load test data into the test database environment.

Responsible for gathering requirements, design and develop data warehousing ETL solutions and delivery reports

Worked with ETL group for understating mappings for dimensions and facts

Involved in writing Test scenarios, Generic tests cases, detail Positive and negative test cases for ETL also Preparing ETL and SQL routines/code for performing ETL testing (system and integration testing) and Documenting the test results

Prepared Test Data and executed Test Cases from Quality Center.

Stimulate financial calculations for a given formula for a given period.

Worked on parameterizations, calling/copying, Check points heavily.

Developed several ETL applications to Extract, Transform and Load data into tables as part of Data Warehouse testing using various tools like Informatica, etc.

Extensively performed manual testing using Quality Center.

Involved in testing data mapping and conversion in a server based data warehouse.

Automated the Backend testing for reusability by writing Unix Shell Scripts.

Analyzed the functional requirement documents, system requirement documents and business requirement documents.

Assisted in developing test plans for testing the functionality, GUI, and security.

Performed manual testing, considering the base line of developed test plan and test cases considering both positive and negative scenarios.

Performed Integration, Functional, GUI and UAT testing

Used JIRA bug tracking tool to report application bugs and enhancements request and discussed with developers to resolve technical issues

Tested for data in the database by writing SQL queries for SQL Server before testing the module

Performed functional testing for new release enhancements.

Participated actively in the team meetings with the developers for bug reviews.

Environment: SQL, Quality Center, Windows 2000/NT/98/95, Microsoft office 93 and 97, Informatica power center 9.0, UNIX, Java, MS SQL Server, XML and QTP.

ETL/ Software Tester, BrightStare Care, VA January, 2011 – December 2013

Managed the project efficiently to produce ICD-9 (CM) codes files into their corresponding ICD 10 (CM and PCS) codes mapped files EDIFECS mapping tool was used to map these files. Key challenge was the coordination with MMIS claims team to identify/extract the exact claim file layout and the data for business rules that are built in the MMIS system for an exact map with the ICD 10. This process was necessary to make sure that loading of the mapped ICD 10 files into the MMIS system is successful.

Responsibilities:

Developed Test scenarios, Test Scripts and Test cases based on Requirements, DSD’s and GAP documents.

Automated test scenarios for GUI, Functionality and performed data driven testing on the application inserting different data in excel sheet using QTP

Involved in coordinating with SME to discuss different scenarios at the time of scripting Test Cases.

Participated in building automation test scripts based on BPT module of ALM/Quality Center

Involved in requirement gathering for ICD9 to ICD10.

Requirements validation for ICD 9 and ICD 10

Responsible for Architecture workgroup Testing for ICD 9 and ICD 10

Responsible for developing test scenarios on ICD10

Involved in the testing of web portal of New MMIS system

Automated test scenarios for GUI, Functionality and performed data driven testing on the application inserting different data in excel sheet using ALM/Quality Center.

Assisted team leads in developed the test plans in compliance of QACC Master Plan, test planning document and control management document for varies patient registration patient accounting financial software applications as well as HIPAA for federally mandated HIPAA 5010/ICD 10 compliance.

Conducted Functionality testing during various phases of the application using ALM/Quality Center.

Gathered and validated inventory of applications, interfaces, and reports that will need to be modified to comply with ICD-10 requirements.

Created and maintained IT ICD 10 project plan using Microsoft Project and reported status for different IT work threads each week.

Participated in provider outreach program for ICD 10 program

Worked with different teams such as HIPAA 5010 to identify any project dependencies or initiatives competing against ICD 10 schedules.

Involved in creating of Test Accounts in mainframe application according to the Business Requirements in utilization for testing.

Developed strategies with Quality Assurance group to implement Test Cases in ALM/Quality Center.

Bug Reporting and Tracking using ALM/Quality Center.

Used ALM/Quality Center documentation management and defect tracking.

Created different Providers using Enrollment Process through Online Portal to create test data.

Extensively involved in managing defects using Clear Quest and interacted with DEV team in resolving critical and high defects.

Extensively involved in UAT support for their execution and Defect Triage.

Environment: Facets, QTP, ALM/Quality Center, SQL, SQL Server, MMIS, HIPAA, UAT, Clear Quest, Manual Testing, Windows, MS Office, MS Access, SQL Server.

Jr. Software Tester/QA Tester Capital One Bank, VA December 2008 to December 2010

The project was regarding upgrade of their existing Web application designed to enable account holders to access and pay bills online using their personal checking, savings or money market accounts. Involves validation of ATM and Branch data files and Testing Tools JIRA defect tracking system. The users would also have the functionality to transfer money from one account to the other, enroll for Bill Payment. It also gives transaction summary for a certain time period.

Responsibilities

Reviewed the Business Requirement Documents and the Functional Specification.

Prepared Test Plan from the Business Requirements and Functional Specification.

Developed Test cases for Deployment Verification, ETL Data Validation, Cube Testing and Report testing.

Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation.

Tested to verify that all data were synchronized after the data is troubleshoot and also used SQL to verify/validate my Test cases .

Verified, updated and validated cardholder data information, account information and authorization of transaction data in green screens of Mainframe application.

Involved in extensive DATA validation using SQL queries and back-end testing

Involved in Front to Back testing for all European and Asia pacific regions

Wrote complex SQL, PL/SQL Testing scripts for Backend Testing of the data warehouse application.

Created high level use case diagrams, process composition diagrams and data modeling

Reviewed Informatica mappings and Test cases before delivering to Client.

Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.

Involved in creating of Test Accounts in Mainframe application according to the Business Requirements in utilization for testing

Experienced in writing complex SQL queries for extracting data from multiple tables.

Testing has been done based on Change Requests and Defect Requests.

Preparation of System Test Results after Test case execution.

Performed Smoke, Functional, Regression, System and User Acceptance Testing (UAT) in Web and Mainframe application.

Performed Functional, Regression, Data Integrity, System, Compatibility testing

Extensively executed T-SQL queries in order to view successful transactions of data and for validating data in SQL Server Database.

Extensively used Informatica power center for extraction, transformation and loading process.

TOAD is used to perform manual test in regular basis. UNIX and Oracle are using in this project to write Shell Scripts and SQL queries.

Wrote SQL queries to validate source data versus data in the data warehouse including identification of duplicate records.

Experienced in writing Test cases, test scripts, test plans and execution of Test cases reporting and documenting the test results using Mercury Quality Center

Generating Cognos report and validate the data using SQL queries in teradata and Oracle data bases

Prepared Test status reports for each stage and logged any unresolved issues into Issues log.

Involved with ETL test data creation for all the ETL mapping rules.

Preparing and supporting the QA and UAT test environments.

Tested different detail, summary reports and on demand reports and Communicated discrepancies determined in testing to impacted areas and monitored resolution.

Environment: SQL, PL/SQL, UNIX, putty, XML Files, Mainframe, INFORMATICA, AUTOSYS, Mercury Quality Center 9.5, COBOL, ORACLE 10G.

EDUCATION

MSC INFORMATION SYSTEM Strayer University, USA

Contact this candidate