BERNADSHAW DHANAPAL

Having 15+ years of experience and am seeking a challenging position in the field of Software Quality Engineering and to use my skills to the utmost benefit of the Organization.

New MEDS, 05/01/19 to Present, Conduent Inc, USA, Mississippi Medicaid Project consists of an intranet-based system which provides a web-based interface to the case workers (Division of Medicaid staff) to perform eligibility determination for a potential beneficiary based on various criteria. Eligibility System will be central repository of Medicaid eligibility data for the state of Mississippi. The system determines Medicaid eligibility for the Medicaid program applicants in a uniform, accurate, efficient, and timely manner. This environment supports printing of reports, notices and letters and data exchange with external systems., MS SQL Server, Jenkins, maven, SQL Server, Hibernate, Windows, ODBC Proxy, SQL Database, VM, Cognos, Accompa, 5, Team Lead, Involved in requirement gathering (JAD) sessions and Prepared General System Design document (GSD), Facilitate test case design and adherence to test design standard and support end users to execute the UAT test cases and defect fixes., Participating in daily status meetings with Customer, Project Manager, DM, Development and QA teams to discuss QA status, Project status and ongoing change of requirements., Analyze test results, identify Defects and track using Accompa., Execution of tests and verification of results to ensure the application is meeting 99% target product quality., Create crosswalk documents for the services., Participating in BA activities – Requirement gathering, creating low level design documents., Understanding/analyzing user stories and requirements for the consumer web portal and creating test scenarios and test cases as per the requirements, validating the data as per the requirements., Performing analytics testing on reports with PHI data in production., Participating in Smoke testing, System testing, Integration testing, Functional testing, End-to-end testing, and Regression testing for Medicaid program., Validation of Reports for all the eligibility programs like Magi, ABD, and Medicaid., Testing source data extraction, business transformation logic and target table loading for the Initial Data Load requirements., Writing SQL queries for various scenarios like count test, primary key test, duplicate test, attribute test, default check, technical data quality, business data quality for BI reports., Closely work with customer and clarify their queries on the System., Create, design, and execute test plans, test harnesses and test cases., Identify, troubleshoot, and provide solutions for potential issues, test flat file data transfers from source and Target., Verification of drilling (drill down, drill through), sorting and export functions of the reports., Testing of different data sets (different regions, periods of time) and usability testing., Reviewing Test Scripts written by the Team for the Coverage of Functionality., Assisting the Team with the Execution of Test Scripts., Managing Defect Reviews. Colorado Business Intelligence and Data Management (CO BIDM), 06/01/17 to 04/01/19, IBM Watson Health formerly called as Truven Health Analytics, USA, Business Intelligence and Data Management System (BIDM) is a data analytics program run jointly by the federal and state governments to analysis the data in MMIS system. The goal of the program is to provide CO state data analytics teams like Audit and compliance, LTSS, TPL, Program Integrity (PI) team to analyses the data and find the fraud claims which is claimed by providers or clients and recover the same. Each state sets its own guidelines, subject to federal rules and guidelines. Certain services must be covered by the states to receive federal funds. For this program we are in process of Implementation of tools such as Informatica and Advantage suite for ETL process, Cognos for reports, OnBase for Investigative Case Management, Tableau for dash boards., Java, Cognos, Informatica, SAS, OnBase, Tableau, MoveIT, Advantage Suite, Rally, SharePoint, SQL Developer, Oracle, Windows 10, IBM i2, 5, Team Lead, Developing test cases based on requirements and functional specifications provided by Data Management team., Involved in Implementation ICM (Investigative Case Management) tool for the state of Colorado., Performed operation support activity., Resolving product support tickets related to ICM – provisioning users in the tool., Assigning or removing the users from user groups., Bug fixing and promoting the code to production environment., Facilitate test case design and adherence to test design standard and support end users (HCPF) to execute the UAT test cases and defect fixes., Consolidating data from 20 different sources including MMIS, EDI and pre-generated reports to the Datawarehouse and running ETL scripts to analytics data is validated., Performing analytics testing on ETL and reports with PHI data in production., Participating in Smoke testing, System testing, Integration testing, Functional testing, End-to-end testing, and Regression testing for the Audits and Compliance, LTSS, and TPL functional areas., Total number of test cases for creation and execution - approximately 450 test cases., Validation of Reports for all the functional areas like Audits and Compliance, LTSS, and TPL., Total number of test cases for creation and execution - approximately 50 test cases., Testing over 40 different claim types and running analytics for over 30,000 claims to generate valuable reports for the state of Colorado., Participating in daily and Status Meetings with Customer (HCPF), Project Manager, DM, Development and QA teams to discuss QA status, Project status and ongoing change of requirements., Analyze test results, identify Defects and track using Rally., Execution of tests and verification of results to ensure the application is meeting 99% target product quality., Need to make sure there is Zero critical and High severity defects., Need to make sure 100% all the test cases are executed, and which is not failed for no critical or High severity defects., Testing source data extraction, business transformation logic and target table loading., Writing SQL queries for various scenarios like count test, primary key test, duplicate test, attribute test, default check, technical data quality, business data quality for BI reports., Test ETL software and data warehouse components like ODS layer, Reporting layer and Advantage Suite layer., Closely work with customer (HCPF users’ groups like Audits and Compliance, LTSS, and TPL) and clarify their queries on the ICM tool., Create, design, and execute test plans, test harnesses and test cases., Identify, troubleshoot, and provide solutions for potential issues, test flat file data transfers from source and Target., Source Tables like Flat files from DXC data, Staging tables, Fact Tables, ODS layer, and Reporting layer tables., Target Tables like Staging tables, Fact Tables, ODS layer, and Reporting layer tables., Verification of drilling (drill down, drill through), sorting and export functions of the reports., Testing of different data sets (different regions, periods of time) and usability testing., Identify quality improvement opportunities to improve software testing and code coverage., Providing supportive documents for the CMS Artifact requirements based on the MMIS functional areas (Provider, Member, TPL, Claims, and Financial Management). New York MMIS, 03/01/15 to 05/01/17, Conduent Inc, USA, Medicaid is a health insurance program financed and run jointly by the federal and state governments for low-income people of all ages who do not have the money or insurance to pay for health care. The goal of the program is to provide medical and other health care services to eligible individuals so that they can remain as self-sufficient as possible. Medicaid is a state administered program. Each state sets its own guidelines, subject to federal rules and guidelines. Certain services must be covered by the states to receive federal funds. Other services are optional and are elected by states., Java, JSP, Oracle 10g, IE 7.0/8.0, Windows XP, 15, Team Lead, Involved in Cognos report testing and understanding/analyzing report specification document, identifying/preparing the test scenarios and test case, Building/reviewing the SQL queries as per the requirements, validating the report components and data as per the specifications., Involved in understanding/analyzing ETL mapping specifications/transformation business rule documents for file to file, file to DB, DB to file and DB to DB, identifying/preparing the test scenarios and test case, Building/reviewing the SQL queries as per the requirements, validating the data as per the requirements., Reviewing Test Scripts written by the Team for the Coverage of Functionality., Assisting the Team with the Execution of Test Scripts., Managing Defect Reviews., Providing Knowledge transfer on Important Functional Areas like CLAIMS, MEMBER, PROVIDER., Working on MMIS Enterprise Portal HEALTH CARE Database testing., Writing DB Queries to verify data correctness while testing Interfaces., Building Queries to Verify Reports Generated across various Modules., Monitoring messages on the HUB queue while Interfaces testing., Developed Test Cases, Test Scripts for UAT tests., Created Test Cases in RMT and mapped Test Cases to Requirements in Req Pro., Analyzing the exact requirements by using Design Specification Documents., Mapping the Test Scenarios to corresponding Requirements (Use Cases) in Traceability matrix., Execute batch processing and verify the jobs status and data in database tables., Identifying and preparing the test data required for the Test Case execution by analyzing the database specifications and writing SQL queries., Execution of Test Cases (Functional, Integration, System, Non-Functional, User Interface, Database Test Cases) Test w.r.t Test Cases using Rational Manual Tester tool., Logging the defect in Clear Quest tool., Involving in Defect management cycle., Prepared status summary reports with details of executed, passed and failed test cases., Interacting with clients through calls for discussing functionality issues and Status of Test Case Execution., Giving Presentations for Use Cases within the team., Incorporating the client comments in functional and system scripts., Participated in regular project status meetings related to testing. NH PE and ND MMIS, 06/01/12 to 03/01/15, XEROX Inc, USA, Medicaid is a health insurance program financed and run jointly by the federal and state governments for low-income people of all ages who do not have the money or insurance to pay for health care. The goal of the program is to provide medical and other health care services to eligible individuals so that they can remain as self-sufficient as possible. Medicaid is a state administered program. Each state sets its own guidelines, subject to federal rules and guidelines. Certain services must be covered by the states to receive federal funds. Other services are optional and are elected by states., Java, JSP, Oracle 10g, IE 7.0/8.0, Windows XP, 20, Team member, Prepared and Executed Test Cases as per System Requirements., Participated in identifying the required Test scenarios for Provider, Member, Claims Front End, Claims Back End, Claims Pricing, Edits audits, Provider modules., Prepared and Executed Test Cases as per System Requirements for Provider, Member, Claims Front End, Claims Back End, Claims Pricing, Edits audits, Provider modules., Performed various black box testing Methodologies Like functional testing, Compatibility Testing, Database Testing, Usability Testing and Regression testing., Performed Functional Testing, System Integration Testing, BI (Congo’s Reports) and Xpression/Letters testing. Maintaining Daily status reports and sharing to the client., Defect Reporting and Tracking using CQ and RMT., Extensively performed Manual Testing process to ensure the quality of the software., Building/reviewing the complex SQL queries as per the requirements for report testing., Identifying the preconditions, running precondition jobs to perform data setup, generating Reports via On-demand/Schedule., Validating the report components like layouts, Business labels, logo, Header, alignments, data sorting, page and section breakings and report data as per specifications., Prepared and Executed Test Cases as per System Requirements., Prepared End to End scenarios for claims. Library management system, 05/01/10 to 04/01/12, The idea of providing online automation finds its major use in the case of members of a City Library wherein they might have to go there to find to their disappointment that the book that they are looking for isn't available. The system automates all the basic tasks like keeping record of all the book issues, returns and fining etc., Dot Net, Oracle 10g, JIRA, 6, Team Member, Involved in designing Test case and Test scenario., Reviewing Test cases developed by others., Involved in End to End Testing and Regression testing., Preparing the Daily defect report., Active communicator with developers over the progress of the product., Preparing and sending of Deliverables Such Daily Status Reports, Regression Reports., Responsible for client interaction in the absence of TL. BUSINESS TO BUSINESS PORTAL(B2B), 05/01/10 to 04/01/12, A B2B Portal serves two parties - the buyer and the seller. These are also known as leads. The main function of this website is to enable visitors to find the leads they want in the shortest possible time. A buyer may be looking for seller leads, and a seller may be looking for buyers leads. By using the search function, one can easily locate the right type of leads on a B2B Portal., Dot Net, Oracle 10g, JIRA, 6, Team Member, Involved in designing Test case and Test scenario., Reviewing Test cases developed by others., Involved in End to End Testing and Regression testing., Preparing the Daily defect report., Active communicator with developers over the progress of the product., Preparing and sending of Deliverables Such Daily Status Reports, Regression Reports., Responsible for client interaction in the absence of TL. HUMAN RESOURCE MANAGEMENT SYSTEM(HRMS), 02/01/08 to 01/01/09, Karnataka State Government, The HRMS is a web application for the employer to get an accurate picture of the sanctioned posts, filled up posts and vacant posts; it will save time in making the estimates for the annual Budget and to improve productivity and efficiency. Computerized Database helps in drawing up pay bills, supplementary bills and all salary-related exercises in quick-time; It also helps assessment for promotion, deputation for training, deployment for Special and time-bound tasks/projects., Dot Net, Oracle 10g, JIRA, 15, Team Member, Setting up testing environment., Involved in designing Test case and Test scenario., Involved in Functional and Regression testing., Executed and Logged defects in Excel sheets., Interacted with Client and Development Team for issue clarification., Member in the testing process, Test assigning, Downloading and uploading the files from test server. Checking the test in progress and reviewing the reports and bugs.

Title: Sr. Test Lead