PROFILE SUMMARY:

• 14 plus years of software testing experience in Manual, Functional, Automation, Webservices, Database, PBM, ETL, Data Warehouse and BI Reports testing in various domains like HealthCare, P&C Insurance and Life Sciences (Medical Devices).
• Attending sprint planning meetings, reviewing user stories and understanding the business logics.
• Working closely with product owners, developers, integration team and coordinate with different system teams.
• Creating detailed, comprehensive and well - structured test plans and test cases.
• Estimating, prioritizing, planning and coordinating testing activities.
• Design, develop and execute automation scripts using open source tools.
• Identify, record and track bugs.
• Perform thorough regression testing when bugs are resolved.
• Strong knowledge of software QA methodologies, tools and processes.
• Hands-on experience with both white box and black box testing.
• Hands-on experience with automated testing tools.
• Solid knowledge of SQL and scripting.
• Experience working in an Agile/Scrum development process.
• Experience working in web service testing.
• Developing and applying testing processes for new and existing products to meet Requirements needs.

PROFESSIONAL WORK EXPERIENCE:

Confidential, Addison, TX

QA Analyst/Webservices/HP ALM/UFT/ETL/DWH/BI Test Analyst

Responsibilities:

• Playing a QA Tester role in Agile Team having multiple HealthCare provider-based systems integrated with each other and consist of 8 developers, 1 product owner and 1 scrum master
• Participate in Daily Scrum stand up meetings and provide the status on the tasks worked on yesterday and the tasks planned to work for today along with any impediments
• Participate in Backlog Grooming sessions conducted by Product Owner and provide the story points required for QA on each user story that has been discussed
• Participate in Sprint Planning meetings where the user stories are pulled from backlog and update the story points wherever it is necessary
• Participate in Sprint Retrospective meetings and discuss about Start Doing and Stop Doing based on the previous sprint experience
• Review Acceptance Criteria on User Stories in Agile Scrum model and raise the concerns on gaps to the Product Owner and the respective module or system Developers
• Perform Requirement Analysis on BRD in waterfall model and sending clarifications or feedback to BA
• Provide QA estimates from Requirement Analysis phase to Test Closure phase
• Create Test Plan document
• Create Test Scenarios in Microsoft Excel and review with the stakeholders
• Develop Test Cases in Test Plan module of HP ALM
• Execute Test Cases in Test Lab module of HP ALM
• Create QA Sub Tasks in JIRA on the assigned user stories pulled into current sprint
• Log defects in JIRA and associate to the respective user story
• Schedule Defect Review meeting based on a daily or weekly basis
• Validate various interface messages like Patient Demographics Creation and Update, Appointment Scheduler, Charge Interface, Transcriptions etc.,
• Identify gaps in the design and instruct developers to correct it
• Develop SQL queries in Sybase Central, to verify the data in Legacy Systems
• Develop SQL queries in SQL Developer, to verify the TIBCO Interface
• Develop SQL queries in Microsoft SQL server, to verify the data in Allscripts TouchWorks
• Execute ETL workflows using Informatica Power Center Workflow Manager module
• Monitor ETL workflows status using Informatica Power Center Workflow Monitor module
• Develop SQL queries in Source and Target databases using STTM documents
• Automate ETL regression testing using QuerySurge Automation tool
• Develop QueryPairs in QuerySurge Automation tool and schedule to run periodically
• Develop regression test suite in SOAP UI using XML API message, to validate TIBCO interface changes
• Develop and Maintain Automation scripts in HP UFT using VB scripting language
• Integrate HP UFT and HP ALM, such a way Automation test scripts can be initiated via HP ALM Test Plan module
• Maintain the framework like Business Components, Datatables and Object Repository
• Validate BI reports developed and generated using MicroStrategy Web and QLIKView
• Validate HealthCare Provider Package Bill consist of HCFA, Transcription and State Report
• Validate various provider bill types like HCFA Original, HCFA Rebill DropNow, HCFA Rebill NextBatch, Injury Invoice Original, Injury Invoice Rebill DropNow, Injury Invoice Rebill NextBatch, Reprint DropNow, Reconsideration DropNow, Reconsideration NextBatch, Mediation DropNow, Mediation NextBatch, Situational Letters, EDI and Non-Injury Invoice
• Validate Check-In and Check-Out process in Front Desk user-based application for Occupational Medicine line of business
• Validate Documentation and Charge Submission process in Provider based EHR application like Allscripts TouchWorks

Environment: Internet Explorer 6.0, Windows 2000/XP, JIRA, Confluence, SQL Developer, SQL Server.

Defect Tracking Tool: JIRA, Track Record and HP ALM

ETL Tool: Informatica Power Center

BI Reporting Tool: QLIK View, Micro Strategy Web

Automation Tool : HP UFT and Query Surge

Confidential, Deerfield, IL

QA Consultant/ETL Test Analyst

Responsibilities:

• Requirement Analysis on BRD and sending clarifications or feedback to BA
• Preparing Test Plan/Test Strategy document based on the project complexity and getting the feedback and approval from various stake holders
• Preparing Test Scenarios/Test Cases, initiating walkthrough meetings and finally getting sign off to get ready for Test Execution
• Preparing and maintaining Execution Tracker to share the Test Execution status to all the stake holders on a daily or weekly basis
• Sending Closure Memo to PM, upon successfully completion of Test Execution
• Hands on experience in creating Patients in PBM system and enrolling the patients with Client ID, Group ID and Plan ID
• Hands on experience in submitting Medicare Part D claims and Commercial claims, this can be achieved based on the Plan ID enrolled for each patient
• Hands on experience in submitting various types of claims in various templates say Paid (B1), Re-bill (B3), Reversal (B2), Re-adjudication (BZ), Troop Eligible and Non-Troop eligible (N1) claims etc.
• Hands on experience in running Readjudication process in UNIX and the instructions provided in support document
• Expertise in validating ETL process in DataStage Designer
• Expertise in executing ETL process using CRONtab in UNIX
• Expertise in monitoring ETL process in DataStage Director
• Performed database testing in terms of validating the data flow from Adjudication systems to Post Adjudication systems
• Hands on experience in validating PDE Reconciliation file, which is shared with the CMS using Confidential
• Involved in the production support for the production deployments for both enhancement and defect fix projects
• Expertise in Onsite/Offshore model
• Hands on experience in TOAD/SQL Developer
• Providing test estimation based on the functional requirements
• Performed Data Migration testing from Confidential servers to Confidential servers.
• Created dummy clients using SOAP UI to verify RTA and BFR.
• Hands on experience in modifying and running the test scripts already existed for requirement changes using QTP 9.5.
• Expertise in test execution and reporting the defects using JIRA.

Environment: Java, HTML, QuickTestPro (QTP), XML, DataStage, Internet Explorer 6.0, Windows 2000/XP, TestPartner, JIRA.

Confidential, Seattle, WA

Senior Quality Analyst

Responsibilities:

• Participated in Kick off meetings and Walk through meetings with Development, Business and other QA Teams.
• Developed detailed Master Test Plan, Impact analysis document and prepared effort estimations.
• Worked closely with project manager in the Planning, Test Strategy and Test Approach.
• Successfully handled various P&C Insurance projects like Auto Rate Redesign, Home Rate Redesign, Customer Billing Output, Earthquake Transition, EDI Lien holders and Dwelling Fire Rate Change 2010.
• Handled various P&C Insurance Modules like Policy, Billing, Document Solutions, Claims, and WIP etc.
• Creating Module level Testing schedules and resource planning.
• Worked on PeopleSoft Applications (HCM 9.1) for maintaining the data of Users, Suppliers and Administrators.
• Created and executed test cases for GUI testing, Integration testing, and System testing.
• Expertise in performing batch testing by executing batch jobs for Billing, Output in UNIX.
• Preparation of Execution Tracker, which will be helpful in sending the daily status report and weekly status report of Test Cases Execution.
• Preparation of Test Summary Report, which will finalize the decision as Confidential or NO Confidential of the product to LIVE.
• Developed the test scripts using Rational Functional Tester to verify the performance based requirements for a web application.
• Expertise in executing test cases in Mainframes via CICS and TSO
• Expertise in executing SQL queries in DB2 to extract production data for retesting production defect fixes in test environment
• Expertise in Test Management using Quality Center, RQM, Execution and reporting the results.
• Ran SQL queries in DB2 for extracting the production policies.
• Conducted boot camp training related to the project to the new ELT’s (Entry Level Trainees).
• Developed PMS Video Files using SNAG IT tool, which has been marked as a training material for Mainframes Application across the vertical.
• Hands on experience in modifying and running the test scripts already existed for requirement changes using QTP 9.5.
• Hands on experience in raising defects using Quality Center.

Environment: Internet Explorer 6.0, Windows 2000/XP, Mainframes, QTP, RFT.

Defect Tracking Tool: Quality Center 9.5.

Confidential, Detroit, MI

Senior QA Engineer

Responsibilities:

• Validation of user dumps extracted with the LDAP directory.
• Performing Fail Over testing to validate LDAP Server 2 when LDAP Server 1 is down.
• Creating/Modifying/Deleting the user/supplier/admin data and verify the data by running commands in UNIX.
• Ran SQL queries in DB2 and TOAD for extracting the user/supplier/admin data.
• Handled a team of 6 members.
• Creating module level testing schedules.
• Prepared Complex Test Scenarios.
• Involved in all Phases of SDLC.
• Writing Test Cases and preparing Test Data for complex Test Scenarios.
• Performed Sanity testing for new builds.

Environment: C, UNIX, Windows 95/98/NT, LDAP, TOAD.

Defect Tracking Tool: Quality Center 9.2

Confidential, Cincinnati, OH

Independent Verification and Validation Engineer

Responsibilities:

• Participated in the requirements, analysis and planning phases to review the project requirements.
• Chalked out the detailed test approach for conducting the test, developments of data sets, and data verification.
• Participated in peer reviews and walkthroughs on the Preliminary Test Approach, which contains high-level test conditions for verifying the software solution.
• Development of Test Plans, and execution of Test Cases.
• Handling entire process of testing artifacts for Verification and Validation with respect to the FDA standards 21 CFR Part 11.
• Concluded the development of System test plan documents for the most important functionalities in SDS like PRU Graphical User Interface, Automated Response Monitor (ARM), Non-Invasive Blood Pressure (NIBP), SpO2 and Barcode.
• Developed NIBP Software Simulator, HL7 Extract Tool using VC++ for 100% verification of NIBP Module Functionality.
• Performed Volume testing, Stress testing and Load testing to verify the 100% functionality of class 3 medical device.
• Design Verification Matrix (DVM) for requirements verified for feasibility studies.
• Created and executed test scripts using RFT and RPT for validating the web based application.
• Expertise in extracting the data using HL7 tool and validating the HL7 messages.
• Involved in all Phases of SDLC
• Actively involved in developing software verification for feasibility.
• Hands on experience with FTP in uploading and downloading the files.
• Volunteered for Clinical Trials happened at Confidential Inc.
• Worked in close coordination with developers and business analysts in performance and failure analysis.
• Worked on DOORS for the traceability matrix of all the work products.

Environment: C++, QNX, Linux, Windows 95/98/NT, RFT, RPT, HP Load Runner

Defect Tracking Tool: Seapine Test Track Pro

Confidential

Quality Analyst

Responsibilities:

• Creating module level testing schedules.
• Prepared Complex Test Scenarios.
• Involved in all Phases of SDLC.
• Writing Test Cases and preparing Test Data for complex Test Scenarios.
• Performed Sanity testing for new builds.
• Executed the development of System test plan documents for Universal Dock Unit and Remote Control Unit.
• Developed Super Stick simulator and Remote Simulator using ‘Laboratory Virtual Instrumentation Engineering Workbench’ (Lab VIEW) tool for Verification and Validation of Universal Dock Unit.
• Used ‘Code Warrior’ Tool (IDE) for testing Super Stick Interface and Manager Module by integrating with all interface modules.

Environment: C, UNIX, Windows 95/98/NT

Confidential

Graduate Apprentice Trainee

Responsibilities:

• Involved in entire QA Life Cycle, which includes Designing, Developing and Execution of the entire QA Process and documentation of Test Plans, Test Cases, Test Procedures and Test Scripts.
• Writing detailed test plans and performing functional tests manually as well as with Rational Completed the development of test plan as per the Software Requirement Specification (SRS) document.
• Involved in:
• Generating the test conditions on Gen 6 Load Box.
• Observing the results on PTM screen and analyzed the waveforms on Tektronix 2000 Oscilloscope.
• Participating in regression testing of Confidential 6 Confidential ECU.
• Putting in place a. MOT file form the compiled code and flashed. MOT file into the module.
• Concluded writing of:
• Observation reports and interacting with On-Site engineers for successful execution.
• Test scripts and compiled the code for a White box-testing environment.

Environment: C, Visual Studio, Windows 95/98/NT