Mahjabeen Tailor

Email:aduyhk@r.postjobfree.com

Contact:571-***-****

Professional Summary

·More than 9 years of experience in software quality testing in healthcare, mortgage, and customer management applications.

·Expertise in designing, testing documents such as test plans that design specifications, test case specifications and test procedures. Involved with functional testing, integrated testing, system testing like regression testing, performance testing on client/server-based applications. Involved in writing the test plans, test cases and developing and executing test scripts.

·Experience in healthcare domain in testing the major core modules such as Claims Processing system, Provider, Member system.

·Experience in DDE submission of claims and 837 EDI HIPAA files.

·Expertise with MS office tools like MS words, MS Excel and MS access. Experience in database testing with SQL commands on database using TOAD. Developed test plans, use cases based on business requirements document and system requirement specification.

·Experience in testing database applications of RDBMS in Oracle, My-SQL and SQL Server.

·Experience working on Azure portal for loading and verifying the Json files for healthcare Project like Electronic medical Records(EMRI),National Language Processing(NLP) and ACA

·Experience in in logging and tracking Defects using defect-tracking tools like Quality Center, ALM & Jira.

·Experience in Back-end testing using SQL queries on the various databases. Usage of Automation testing tools of HP Products like ALM and Quality Center.

·Experience with v-model designing, involved in the Integration, Test, Verification stage.

·Proficiency in Defect Management.

·Usage of Trackers/Bug Reporters like JIRA, Quality Center.

·Conversant with all phases of Software Development Life Cycle (SDLC) including Requirement gathering, Analysis, Design, Development, Implementation, Testing, Software quality standards, configuration management, change management, Quality procedures and effectively interpret Requirement Documents to create test plan and test scripts.

·Participated in sprint planning, sprit review, daily scrum meetings and scrum of scrum meetings as part of agile process.

·Experience in Web application testing in Financial and Retail/E-Commerce.

·Performed Use-Case analysis using UML. Worked on the Flowchart and process diagram along with sequence diagram using Microsoft Visio.

·Excellence in preparing test scripts, test plans functionality testing, security, regression, back end, and configuration testing, parameterization, multiple actions.

·Work Independently, Creative, highly motivated, and hard working with good interpersonal skills.

·Ability to interact with end users, also quick learner and team player with good communication skills.

EDUCATION

·Bachelor of Engineering in Computer Science, Vishveshwariya Institute of Engineering and Technology.

CERTIFICATION

·Certified Scrum Master

TECHNICAL SKILLS

·SQA, SDLC, Water-fall/Agile/Scrum Methodology Concepts

·Test Case, Plans & Scripts

·Defects & Bugs Discovery/Reporting

·System & Unit Testing

·Tracking, Logging & Reporting

·Issue Identification & Documentation

·Manual & Automation Test Runs

·SQL & PL/SQL

·HTML

·Quality Center w/ QTP

·UNIX / LINUX

·SOAP UI

·Selenium

·Cucumber Framework

PROFESSIONAL EXPERIENCE

February 2021 – Current

Advantasure

Sr. QA Tester

Description: The primary goal of the EMRI project is to enhance the Blue Cross Blue Shield MMR portal to remove the current paper process and replace it with a fully digital process that is directly facing the provider. In additional the project will have the ability to ingest fully digital member medical records into MRR and also handle question and answer communications from the coders directly to the providers.

Worked on Product based Project “National Language Processing”(NLP) which provides the medical coders ability to Start a medical record review and perform various actions like Completing,saving the reviews.Worked on loading the chart files and verifying when the MRI process runs the files are sent to the vendor and verify the chart results files are saved in the Azure storage containers.Worked on end to end testing for the MRI process which involved extensive backend testing using sql queries for verifying the data flow through all the various tables and verifying data received from and received successfully via Api testing using Swagger Api testing tool.

Worked on the ACA Claims disable linking Project which involved end to end testing of application when the claims linking is disabled in the system and archived in the tables.Performed end to end testing using complex backend sql queries and data setup for the medical record reviews which involved verifying the claims links are disabled when any diagnosis code is added for a specific medical record review.Worked on 837 claims files for claim types(P,D,I) and 835 claim files are Electronic Remittance ERA which provide information about the healthcare services that are being paid for and also information about deductibles, co pay amounts, co insurers.

Responsibilities:

·Analyzed business requirements and functionality to develop test plans, test cases and test scripts.

·Responsible for Data mapping testing by writing complex SQL Queries using Microsoft SQL server studio.

·Back end / front end testing using SQL queries with Microsoft SQL server studio.

·Used to design Test Documents, including Test Plans, Test Requirements, Test Cases and Test Procedures for functional testing.

·Worked on API testing using Swagger tool.

·Involved in end to end integration testing of ACA claims disable functionality

·Verified the data flow in the tables using extensive complex SQL queries

·Verified loading and validating the JSON files in the Azure portal storage containers

·Verified and validated the data saved in the COSMOS database

·Used Zephyr as a test case management tool for writing and execution of test cases.

·Assisted in gathering the business requirements, ETL Analysis, ETL test and design of the flow and the logic for the Data warehouse project.

·Loading 837 and 835 and verifying the different types of claims like Professional,Dental and Institutional claims and their claim payment life cycle.

·Developed ETL test cases for various lines of businesses based on ETL mapping document.

·Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using SSIS ETL Tool and Internal ETL Tool

·Involved in interface testing by using extensive SQL queries and backend testing

·Worked in Agile and scrum methodology

October 2020 – February 2021

FreddieMac

Sr. QA Tester

Description: Working as a senior software tester fort testing, the Trade Capture application which is used by the Single Family Securitization group to support the creation, pricing, tracking and disclosure and settlement of Freddie Mac mortgage backed re-securitizations. Trade Capture is used by the Single Family Securitization by the Single Family Securitization Marketing and Modeling business areas to capture deal level trade information and set up structuring class level characteristics. Exchange and reporting capabilities are built in as well.

Responsibilities:

·Analyzed business requirements and functionality to develop test plans and testcases.

·Used HP-ALM as a testcase management tool

·Worked in Agile and scrum methodology

·Documented test scripts, test cases, test results and logging defects using HP-ALM.

·Involve in Functional and Regression testing.

·Good experience in writing SQL in order to data validation in migration as part of backend testing.

·Worked on issues with migration from development to testing.

·Worked on testing of client server and web-based applications

·Environment: Manual testing, HP ALM, JIRA, Java, Selenium, WebDiver, Oracle database, TOAD, SQL.

·Backend testing of the DB by writing SQL queries to test the integrity of the application and Oracle databases.

·Expertise in writing SQL Statements in database to make sure whether the data is populated in the database according to business rules.

·Expertise in Automation of test scripts using Selenium, cucumber BDD and API testing using SOAP UI

·Involved in writing testcases in feature files using GHERKIN language

·Involved in running and fixing the automation scripts during regression testing.

February 2019 - February 2020

Client Network Services

Sr.QA Engineer

Description: Working as a senior software tester in the Illinois Medicaid Management Information System which is a mechanized claims processing and information retrieval system that state Medicaid programs must have to be eligible for federal funding. The application deals with all the major core subsystems and had the opportunity to work on them. Worked on all the major subsystems like Claims, Provider, Prior Authorization, Benefits and Administration and Eligibility and Enrollment.

Responsibilities:

·Analyzed business requirements and functionality to develop test plans and testcases.

·Used JIRA as a test management tool

·Involved in testing of major subsystems such as Provider, Claims Processing system, Eligibility and Enrollment subsystems and Prior Authorization sub systems.

·Involved in testing of claim edit testing using EDI 837 HIPAA files for various claim invoice types

·Involved in testing of claims by the Direct data Entry (DDE) submission of claims for claims types (P, D, I).

·Tested various Beneficiary, Validation and Provider edits for invoice type (P, D, I).

·Involved in interface testing by creating interface files using record/data formats by using SOA and WinSCP tools for validating the data received from third parties is valid by running the interfaces and validating the inbound and outbound files.

·Performed web services/XML testing using SOAP and REST services tool for testing the third-party information used in testing the TPL subsystem to match member records containing TPL coverage for the Medicaid beneficiaries.

·Involved in creating interface files and testing the third party inbound/outbound files.

·Validated the log files generated by various inbound/outbound interface jobs

·Worked in Agile and scrum methodology

·Documented test scripts, test cases and test results.

·Involve in Functional and Regression testing.

·Performed regression testing for the various modules of the application.

·Supported other teams when needed worked on UTAH and Arizona Projects on the Provider sub system.

·Tested each application against the QA test plan and communicated findings with the team

·Developed Positive and Negative scenarios for the requirements

·Used defect tracking tool Clear quest for logging the issues.

·Experience in backend testing using SQL queries for verification and validation of data.

·Provided KT sessions to the new resources.

March 2018 –October 2018

Eagle technologies, Arlington, VA

Sr. QA Engineer

Description: The office of Head Start (OHS) manages grant funding and oversees agencies providing Head Start services. OHS administers grant funding, federal policy direction, training and technical assistance (T/TA) system to assist grantees in providing comprehensive services to eligible young children and their families.

Head Start Enterprise System (HSES) is the primary data management system of the Office of the Head Start (OHS). It is designed to serve as a consolidated and comprehensive repository for reliable information about OHS grantees and program operations. The EHS application had a health care module with details of the infants and toddler’s health claims and insurance details. The system supports Head Start and Early Head Start programs at the central office and regional offices, grantees and their delegates

Responsibilities:

·Documented the business requirements, developed test plans, test cases created for the database verification.

·Backend testing of the DB by writing SQL queries to test the integrity of the application and PostgreSQL databases.

·Validated member eligibility and eligibility inquiry in the facets application to the legacy application in order to confirm the migration is successful or not.

·Experience with COB (coordination of benefits) application with in facets, facets, testing of claims status for selected subscribers.

·Test data entry into FACETS4.7 applications in the test environment for creating groups, subscribers and family members.

·Claims validation in Facets application which includes claims pending status, member status etc.

·Involved in writing test cases using HP ALM tool.

·Expertise in writing SQL Statements for the data verification purpose.

· Involved in investigating the errors by tracking the root cause for the error.

·Prepared and Execution of test scripts using Selenium using JUnit.

·Experience in working with Selenium Web Driver.

·Experience in writing CSS Selectors, XPath expressions to identify web elements.

·Written Complex SQL Queries to perform manual testing.

·Raised defects in Jira.

·Tested the positive and negative flow of the claims system.

·Performed functional testing to edit, enter and process claims for a member as well as dependent.

·Also involved in system integration testing to validate the feed to downstream systems such as provider and finance portal

·Involved in backend testing using Sql queries to test the claims system and verify the data is saved correctly for the member and dependent.

·Involved in testing of the provider system, system, broker system, system, member system and finance system.

·Involved in functional testing of provider, broker and member portals.

·Good experience in writing SQL in order to data validation in migration as part of backend testing.

·Worked on testing of client server and web-based applications

·Environment: Manual testing, HP ALM, JIRA, Java, Selenium, Spring STS, Webdriver, Postgre, pgAdmin, SQL

March 2017– March 2018

Fannie Mae, Herndon, VA

Sr. QA Tester

Description: The Central Credit Pricing application comprises of two sub applications named Pricing Utility and MBS Committing, to serve bankers who are interested in doing business with Fannie Mae for cash liquidity on Mortgage Backed Securities. The Pricing Utility Module is purely for internal users of Fannie Mae to use to update different products (mortgage-backed securities), lender (banks) details, and Guarantee pricing for a lender and issuing months.

The other module of CCP, Pricing Execution Mortgage Backed Securities (PE-MBS) Committing, is another execution option for lenders (banks) to pool loans for Mortgage Backed Securities. Those lenders that meet Fannie Mae's MBS pooling, trade management, servicing and security settlement standards can re-quest approval to pool loans and swap them for MBS through this application. A lender representative can login into this application, and request for contract while filling up of all the details and taking commitment to deliver loans for their specified amount and issue month. Once a lender requests for contract, the MBS Committing application interacts with the Pricing Utility application to get the pricing i.e. guarantee fee at which lender’s pool of loans swap with MBS.

Responsibilities:

·Documented the business requirements, developed test plans, test cases created for the database verification.

·Designed and executed various Test scripts for Regression and hardening tests.

·Backend testing of the DB by writing SQL queries to test the integrity of the application and Oracle databases.

·Expertise in writing SQL Statements in database to make sure whether the data is populated in the database according to business rules.

·Expertise in Automation of test scripts using Selenium, cucumber BDD and API testing using SOAP UI

·Involved in writing testcases in feature files using GHERKIN language

·Involved in investigating the errors by tracking the root cause for the error.

·Collected evidence for each step of the process to ensure that any errors are captured in time and resolved immediately.

·Prepared and Execution of test scripts using Selenium using TestNG.

·Performed functional, compatibility testing on different browsers like Firefox, IE & Chrome.

·Experience in working with Selenium Web Driver.

·Experience in writing CSS Selectors, Xpath expressions to identify web elements.

·Written Complex SQL Queries. To do manual testing in my feature on the SDM tool for every re-lease and check the configurations.

·Wrote SQL and PL/SQL scripts to validate the database systems and for backend database testing.

·Raised defects in HP Quality Center defect tracking system.

·Involved in testing REST based Webservices/API

·Designed Traceability Matrix to match the test scripts with the Functional design document.

·Good experience in writing SQL in order to data validation in migration as part of backend testing.

·Worked on issues with migration from development to testing.

·Worked on testing of client server and web-based applications

·Environment: Manual testing, SOAP UI, HP ALM, JIRA, Java, Selenium, Webdriver, Oracle database, TOAD, SQL.

May 2015 – Feb 2017

Hamilton bank -Baltimore, MD

Sr.QA Tester

Description: I was part of testing the application, which has a banker facing the front end. It has a database, which stores the information of the modified loans under standard proprietary model and tested the batch processes that generated interfaces, outbound and reports. I was part of system testing the application that performs functional testing of the business requirements and technical specifications for different programs.

Based on the requirements we wrote positive and negative scenarios and used Quality center for writing and executing test cases. We did a lot of backend testing using ORACLE platform and tool used was TOAD.

Responsibilities:

·Analyzed business requirements and functionality to develop test plans, test cases and test scripts.

·I was involved in automation of the test scripts using SELENIUM web driver and TestNG.

·Responsible for Data mapping testing by writing complex SQL Queries using TOAD.

·Back end / front end testing using SQL queries with Toad.

·Used QC/ALM to design Test Documents, including Test Plans, Test Requirements, Test Cases and Test Procedures for functional testing.

·Written SQL Queries and executed them using TOAD and SQL Editor.

·Involved in writing and executing test cases using selenium and cucumber framework

·Involved in various technical, integration and functional testing.

·Used QTP for regression testing like running the test scripts.

·Created User-defined functions, functional library and maintained the initialization scripts to set-up the work environment.

·I was involved in batch processing testing that generated out bounds in XML format.

·We used Quality center for RTM-mapping all over test cases to requirements.

·I used SQL queries to test the update in SQL server tables.

·Verify the data integrity, use TOAD to verify the DB attributes.

·Generated test execution/defect reports from quality center and participated in weekly/daily test execution status review meetings.

·Analyze project related documents such as functional requirements, design documents, and user stories, work with appropriate business and technology leads to determine the acceptable range for test results and applications performance.

·Responsible for Test execution-(Functional/Regression test suites and attending calls with client and work closely with other stakeholders like BA, Dev team.

·Environment: Manual testing, ETL testing, web services, Java, JavaScript, Oracle database server, QTP for running scripts in regression testing, Selenium.

Oct 2013 – Apr 2015

Health Spring -Silver Spring, MD

QA Tester

Description: One of the country's largest Medicare Advantage coordinated care plans. Worked as a QA Tester to Implement Facets and integration of Legacy systems and different extensions.

Responsibilities:

·Documented the business requirements, developed test plans, test cases created for the database backend testing and to test database functionality.

·Designed and executed various Test scripts for Regression tests.

·Experience in Automation testing using selenium and cucumber framework.

·Assisted in gathering the business requirements, ETL Analysis, ETL test and design of the flow and the logic for the Data warehouse project.

·Developed ETL test cases for various lines of businesses based on ETL mapping document.

·Backend testing of the DB by writing SQL queries and PL/SQL scripts to test the integrity of the application and Oracle databases.

·Expertise in writing SQL Statements in database to make sure whether the data is populated in Data Mart/Data warehouse According to Business Rules.

·Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using SSIS ETL Tool and Internal ETL Tool.

·Involved in investigating the errors by tracking the root cause for the error.

·Collected evidence for each step of the process to ensure that any errors are captured in time and resolved immediately.

·Prepared and Execution of test scripts using Selenium using TestNG.

·Performed functional, compatibility testing on different browsers like Firefox, IE & Chrome.

·Experience in working with Selenium Web Driver.

·Experience in writing CSS Selectors, Xpath expressions to identify web elements.

·Written Complex SQL Queries. To do manual testing in my feature on the SDM tool for every release and check the configurations.

·Wrote SQL and PL/SQL scripts to validate the database systems and for backend database testing.

·Raised defects in HP Quality Center defect tracking system.

·Involved in Mobile Testing and Web Soap based Web services

·Designed Traceability Matrix to match the test scripts with the Functional design document.

·Good experience in writing SQL in order to data validation in migration as part of backend testing worked with ETL group for understating mappings for dimensions and facts.

·Worked on issues with migration from development to testing.

·Tested the entire compliance reports generated using SSRS BI tool by validating the data in the report against the database according to the requirement specifications using SQL.

·Assisted with Mobile Apps testing and creation.

·Experience in software testing of client server and web-based application, Mobile applications, Mobile devices and Mobile platforms.

·Environment: Quality Center 12.1, UAT, ASP.Net, HL7, ETL, SQL Server, MS Office, SOAP UI 3.x, Oracle, XML, WSDL, XSLT

Mar 2012 – Sep 2013

Delhaize America, Salisbury, NC

QA Tester

Description: Food Lion operates its retailing business exclusively in the United States. Project responsibility mainly focused on testing the web application over some modules like released new pin pad, Hand held, and POS. I was designated to conduct functional tests where I had to review the requirement documents and technical software documents to fully understand the system.

Responsibilities:

·Responsible for review of requirements from Business Functional Specifications and conducted code as well as application design walkthroughs with Business, dev team and test team members respectively to create Application Design Document.

·Created Test related documents such as Test Plan, Test Scenario, and Test Cases throughout the STLC.

·Worked in Agile, scrum, and sprint environment in order to change the requirements and features set.

·Involved in writing various test cases and test scripts.

·Worked as a QA Tester and responsible for analyzing and understanding the requirements.

·Participated in Requirements walkthrough meeting.

·Tested against the documentation for Verification of transactions at POS. End to End testing for daily operations at POS which involve store opening and closing procedure testing, Tax table verification, New hire confirmation.

·Also, for Credit card, Debit card and Gift card authorization validation at POS and backend.

·Performed the execution of the test cases and tested the application features likes payment options, coupons, Wic, eWic, etc.

·Managed automated and manual test cases in HP Quality Center.

·Worked closely with the development team to get the QA activities done effectively.

·Logged the defects and properly handled the issue resolution.

·Extensive use of SQL to query the Oracle database.

·Involved in database testing by writing SQL queries.

·Performed Functionality and Regression Testing of application using Quality Center.

·Report project status, concerns and issues to QA Manager and QA Lead.

·Worked with the team lead to define data requirements and to identify Checkpoints during the Interface Testing.

·Defect tracking and reporting using Quality Center.

·Responsible for providing the daily testing status.

·Responsible for weekly status meetings showing progress and future testing efforts to the QA Manager. Performed rigorous manual testing such Functional Testing, Smoke testing, Integration testing, UAT Testing, Backend Testing, Regression Testing, End to End Testing and System Testing.

·Executed planned testcases manually in Mobile devices and browsers to verify UI functionality, system down behavior, browser compatibility testing, Workflow, Log validation and perform ad-hoc testing.

·Experience testing mobile apps as well as browser-based web apps on real devices.

·Environment: SQL. PL/SQL, POS, QTP, Visual Studio, Quality Center/ALM,

Jun 2010 – Feb 2012

ERS Smart Milwaukee, WI

QA Tester

Description: This S/W is designed for automation of Hospitals. This S/W provides an easy interface for getting the details of patients and doctors. Every activity in the hospital such as new patients’ registrations, room bed allocations, appointments, schedules of doctors, bill generations are automated. Coordination between several departments is done efficiently by using this solution. This S/W can be portable for any hospital. Many reports were designed for all activities. Mainly for Emergency Patient that means Casualty.

Responsibilities:

·Analyzed business requirements, Functional Specifications and Use Cases, prepared Test Strategy and Test plan.

·Implemented Waterfall/Agile Methodology by analyzing requirement specifications.

·Provide all data validation through SQL queries to perform Back-end testing.

·Developed automation test scripts using Selenium Web driver and Java.

·Created automated scenarios, using Keyword Driven Selenium framework for regression testing.

·Performed Continuous integration automation using Jenkins.

·Developed Maven targets to execute automation testing.

·Interacted with designers and developers to understand the application functionality and navigational flow.

·Prepared Test cases to meet the requirements and its traceability matrix.

·Performed Positive and Negative, security testing to make sure application is according to requirements.

·Implemented Core Java and Object-Oriented Concepts (Inheritance, Polymorphism, Exception handling, Multi-Threading and Collections).

·Used finder mechanisms like CSS, XPath expression, HTML id and name to find the Web elements.

·Validated data and performed backend/database testing using SQL queries, Joins and Functions.

·Performed User Acceptance Testing in the final phase of software development process to check the functionality of the software.

·Used Selenium Screenshots for bug reporting, analysis and executing debugging.

·Documented and tracked test scripts, test results and reported test defects.

·Conducted daily defect review meetings and prepared test results reports.

·Provide daily and weekly status reports on all work performed.

·Worked closely with the Designers and developers to get the immediate resolution to the defects.

·This project involved doing Black box testing including functional, Exploratory, GUI, System testing, Integration, Compatibility testing, across platforms on Windows, Mac, Linux.

·Environment: Java, JSP, SQL, Oracle, XML, Selenium WebDriver, Fire Bug, Eclipse, Maven, XPath Checker, SVN, Apache POI.

Contact this candidate