Quality Assurance Engineer Resume
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.