SUMMARY:

• 8+ years of professional experience in Software Quality Assurance and working on different platforms including Client/Server based, Data warehouse Testing, Healthcare Domains.
• Extensive experience in writing Technical Documents including the Test Plan, Technical Design documents, Test case and Test Execution.
• Support multiple based and backend data validation for health insurance applications like Facets, CMS, MMIS.
• Followed the Agile methodology, analyzed and incorporated User Stories in different release plans for the sprints in Scrum process.
• Support the business and the technical teams in the product development and delivery process and successfully managed cross - departmental relationships throughout the project life cycle.
• Worked closely with architects to prepare Technical designed documents.
• Developed test case and test case scenario using Quality Center, RQM.
• Executing of test cases and doing Ad Hoc Testing, Iteration, Regression Testing, System Testing, Smoke Testing, User Acceptance testing, logging defects and tracking to resolution.
• Excellent skills in overall Defect Management and Problem Solving including tracking, logging and reporting bugs / defects using QC/CQ /JIRA/PIVOTTRACKER.
• Solid backend testing experience in writing and executing SQL queries for data warehouse testing.
• RAPS/EDS CMS file validation for EDI transaction 837 (I/P/DME), 277CA, MAOO2
• Trizetto FACETS system implementation, Member Enrollment and TPL, Inbound/Outbound Interfaces and Extensions, Load and extraction programs and proprietary format files and Reports development.

SKILLS:

• Windows 7/XP,Powerporing
• Communication Skill,Client Server Apps
• Frontend/Backend Validation
• MS Office 2007/2010/2003/200
• Test Scenario,Test Script
• Agile Sprint,Bug Defect life cycle
• Requirement Traceability Matrix
• Oracle Sql/ Microsoft Sql Server/TFS/SSIS
• RQM,X12,SDLC,STLC
• JAVA,.NET, TABLEAU 9.2.2
• Automation Selenium Webdriver

TECHNICAL SKILLS:

Applications: MMIS, FACETS, HEALTH CARE DOMIN, NWCS, CMS, RAPS, EDS

MMIS Subject Areas: MEMBER, TPL, CLAIMS, PREMIUM

Methodologies: Agile sprint, V Model, Water Fall

Phases: Project Design, Test Planning, Test scenario, Test Script, Defect Tracking Meeting, UAT

Tools: and Standards: RQM, QCALAM, JIRA, CLEARQUEST, Toad, Sql Developers

Processes: Software Development Life Cycle (SDLC). Software Test Life Cycle (STLC)

PROFESSIONAL EXPERIENCE:

Confidential

Quality Assurance Engineer

Responsibilities:

• Manages test for in between process before CMS submission,
• Uploads the RAPS/EDS input file into DB, validate, Create Submission for EDI 837 with help of Adeptia.
• Prepares the test execution plans, Test Execution Summary reports, Test Plans and Project Analysis Presentations
• Validate the Inbound 837 file from client, Generate the outbound 837 file, sent to CMS, validated corresponding response file 277CA/MAO2.
• Prepares the Weekly Status report including defect status report; perform data and validation testing by writing SQL scripts
• Handles preparation and peer review of Test Cases and Test data to validate functionalities
• Detects bugs and classify them based on the severity
• Validate the Tableau reports, generate the reports design dashboard and publush.
• Conducts the Defect Triage calls to evaluate the progress, performance of the applications, Defects resolution in efficient and timely manner
• Get the latest code from TFS and update the QA DB and validate.
• Debug the ssis package and set up the ssis configutation file .

Skills Used: SQL Server 2014, Microsoft Outlook 2010, DotNet, Microsoft Office packages 2007,PivatolTracker, RAPS,CMS,FERAS, RAPS Error,SSIS,TFS

Confidential, Cypress, CA

QA Engineer

Responsibilities:

• Prepared the Test Plan and Test Strategy documents and presented these to the project stake holder and project management teams.
• Prepared the test execution plans, Test Execution Summary reports, Test Plans and Project Analysis Presentations.
• Prepared the Weekly Status report including defect status report; perform data and validation testing by writing SQL scripts.
• Handled preparation and peer review of Test Cases and Test data to validate functionalities.
• Detect bugs and classify them based on the severity.
• Analyzed the test results and graphs by generating different reports in Quality Center reflecting the stability of the application.
• Conducted the Defect Triage calls to evaluate the progress, performance of the applications, and Defects resolution in efficient and timely manner.

Skills Used: SQL Developer 2008, Microsoft Outlook 2010, Java Application, Microsoft Office packages 2007, QC-ALM SharePoint, 3RDD

Confidential, El Segundo, CA

QA Engineer

Responsibilities:

• Designed the required test strategy in line with the scope and Organization Standards.
• Executed test cases and performed Ad Hoc Testing, Iteration, System Testing, SmokeTesting, logging defects and tracking to resolution.
• Estimated the test effort and team in terms of size, skills and schedule.
• Developed SQL queries for querying data against different data base for data verification process.
• Worked on all the modules, including Provider, Member, Claims, Plan Management, and all the other sub modules of the project from the initial days.
• Liaised with developers and QA team for a defect triage and defect follow up.
• Reviewed test cases and scripts along with the test data and conducted peer reviews.

Skills Used: SQL Developer 2008, Agile, Microsoft Outlook 2010, Java Application, Microsoft Office packages 2007, RQM/CQ, SharePoint, Version One, MMIS

Confidential, Gaithersburg, MD

QA Engineer

Responsibilities:

• Worked with other development teams to teach them the correct usage of Agile and created document templates that acted as the baseline for other projects.
• Executed test cases and performed Ad Hoc Testing, Iteration, Regression Testing, System Testing, Smoke Testing, User Acceptance testing, logging defects and tracking to resolution.
• Analyzed and incorporated User Stories in different release plans for the sprints in Scrum process.
• Analyzed, executed and tracked the defects using HP Quality Center.
• Involved in mockup data in order to perform and validate functionality / business rules.
• Maintained the Requirement Traceability Matrix; ran the Store procedure/Package and validated.
• Wrote various complex SQL queries, join, and store procedures for backend testing.
• Worked directly with the development and functional team areas to resolve defects.

Skills Used: SQL Developer 2008, Microsoft Outlook 2007, Microsoft Office packages 2007, QualityCenter, SharePoint, Reqtrace Web, MMIS, Agile.

Confidential, Boston, MA

Quality Analyst

Responsibilities:

• Assisted developer in debugging efforts by conducting root cause analysis; used QualityCenter to store all test results and track defects.
• Worked actively with developer to identify high risk features, database configuration.
• Created Requirement Traceability Matrix to map between the requirements and test cases.
• Wrote various complex SQL queries, join, and store procedures for backend testing.
• Designed test cases and test scenarios for member enrollment process, 834 EDI transactions.

Skills Used: MS Office Tools, UML, MS Visio, Windows XP, Oracle, SQL, MS Project 2003, Siebel, Oracle DB, Toad, HP Quality Center, FACETS, Agile Sprint

Confidential, Milford Mill, MD

Quality Analyst

Responsibilities:

• Created Functional Specifications Documents from the Business Requirements Documents; updated and/or reworked previous documentation to get them in sync and up to date.
• Participated and provided input in enterprise architecture design and development.
• Performed review of the mandates sent by CMS for Medicare Part D to figure out the updates needed to meet the new mandates released on a quarterly basis.
• Made recommendations for the transformation roadmap and provided support during the transition phase.
• Participated in creating risk mitigation plan and planning different approaches for minimizing the risk and its consequences.
• Logged defects in JIRA to maintain test requirements and communicated bugs with developers.
• Performed Backend testing extensively by writing SQL validation queries in Oracle Toad against the database.
• Validated records, structure of tables, Indexes, Triggers in tables after migration from Facets 4.31 to Facets 4.81 database.
• Involved in manually testing the application from the back-end using TOAD writing and executing SQL scripts and from the front end using FACETS to carry out data validation.

Skills Used: MS Office Tools, UML, MS Visio, Windows XP, Oracle, SQL, TOAD, MS Project 2003, Siebel, HP Quality Center, TOAD, FACETS 4.81.

Confidential, Schenectady, NY

Quality Analyst

Responsibilities:

• Analyzed and incorporated User Stories in different release plans for the sprints in Scrum process.
• Participated in functional/technical design meetings; created detailed test plans bases on analysis of requirements and design documents.
• Executed systems and data quality testing to ensure all development deliverables were production ready; used quality center to track the defect and manage the test case/testresults.
• Performed System, Regression, Integration and Performance testing.
• Wrote and executed SQL scripts to test various reports and ETL load jobs.
• Worked with the business owner to identify key data elements that will be monitored on an on-going basis to ensure a high level of data quality within the DW.

Skills Used: MS Office Tools, UML, MS Visio, Windows XP, Oracle, TOAD, MS Project 2003, Siebel,HP Quality Center, Rational Rose, BD2, FACETS 4.41

Confidential, Simi Valley, CA

Quality Analyst

Responsibilities:

• Reviewed and developed QA Test Plan, test conditions and test cases based on the technical specification documents requirement documents.
• Measured the success/failure/demand for new or existing features.
• Designed the Test Plan for all the phases of Testing followed by the Project Plan followed by V model.
• Involved in business requirement analysis through Business Requirement Specifications and business blue print documents.

Skills Used: Siebel Oracles RAC 10.2.03, Toad, Java, Quality Center 9.0, Commercial Insurance Application NWCS.