Qa Engineer Resume
NJ
SUMMARY
- 7 years of experience in information technology with above 6 years of extensive experience in Testing Software Applications developed in Web and Client/Server environment using manual testing and also in automation tools.
- Prepared Test plans, Test cases, test data, Test procedures, Test reports and test results
- Extensive knowledge on test cases, test plan by accessing different FACETS Screens, running SQL queries for validating claims, subscriber and group.
- Hands on experience with EDI Transactions such as 270/271,276/277, 834,835 and 837
- Experience in mocking and preparing test data through UltraEdit, SpecBuilder and Edifect Xengine.
- Working through various facets applications such as claim, subscribers/member, provider, Payor, billing, and accounting.
- Worked in cancellation of enrollment and cancellation of dis enrollment through Trizetto Facets
- Experience in Trizetto Facets database
- Experience in McKesson Claim Editing RCCQ for Claim Xten
- Prepared and mocked data in various facets tables for acquiring the test data
- Worked through Test Methodologies and test Summaries for the application under test.
- Performed Smoke Testing, Functional Testing, Regression Testing, Back - end Testing, Ad-Hoc Testing, Sanity Testing
- End-End Testing and User Acceptance testing of the applications. Using Use case document to prepare test scripts.
- Have good knowledge on Data warehouse tools like Cognos and Informatica.
- Experience in testing Cognos Reports (validation and verification)
- Experience in ETL (Extraction, Transformation and Load) and mapping validation
- Extensive Testing experience using Mercury Interactive Testing Tools Quality Center/ALM, Quick Test Professional (QTP).
- Worked through Fazal System, Configuration Change system, Intake Automation as well as Interrogation system.
- Worked through Fazal System and its various enrollment processes such Fazal online Enrolment, OEC Enrolment and Agent or DM46 Enrolment as well as validation through Front End and Back End Testing.
- Using QTP, created VB test scripts in expert view.
- Skilled in writing Test Plans and Test Cases, designing Test Strategies and Methodologies, Creation and Maintenance of Automated Test Scripts.
- Experienced in the Bug Reporting, Bug Tracking and Analysis.
- Expert in Database Testing by creating and executing the SQL Queries.
- Extensively worked on relational database through Oracle, TOAD and Oracle SQL Developer
- Good understanding of the Software Development Life Cycle (SDLC)
- Experience with agile extensively in Scrum and water fall methodologies
TECHNICAL SKILLS
Operating Systems: Windows 2000, Windows 7, XP Professional, UNIX, Linux
Databases: Oracle9i/11i, MS SQL Server 2000, TOAD, DB2, SYBASE, TERADATA, PL/SQL Developer.
Scripting Languages: Perl, VB Script, TSL (Test Scripting Language), Shell Scripting
Web Technologies: ASP2.0, ASP.NET, JSP, HTML, DHTML, XML, and VB.NET
Testing Tools: Win Runner 7.0/7.5/8.2, LoadRunner 8.0/9.1/9.5, QTP 8.0, Test director, Quality Center/ALM, Rational Robot
Defect Tracking System: Quality Center/ALM, Rational Clear Quest, Bugzilla, PVCS Tracker, Test Track Pro.
Software Packages: Microsoft Office (Word, Access, Excel), Power point.
ETL and Report Tools: Cognos, Informatica, Crystal Reports.
PROFESSIONAL EXPERIENCE
Confidential, NJ
Sr. QA Analyst
Responsibilities:
- Analysis and research the rules of McKesson Claim Edit Rules of Configuration and Criteria Questionnaire(RCCQ)
- Working through creating test scenario's or test considerations according to the RCCQ and HNJ-CXT Facet Explanation Edit code for each rule.
- Writing test cases with covering Negative and positive test cases based on the RCCQ of McKesson Claim Edit
- Extensively writing the test cases covering the each line of business (Medicaid and DSNP), Provider( Par and Non Par)
- Place of services (Professional, inpatient and outpatient), Birthing center, delivery at home ), Bill Types, Rev Codes, Facet Explanation Edit codes and CPT’s of each rules.
- Adding the Facet Explanation Edit Code into the test cases based on the scenario type( current-current, current-history, history-current, deny-current, replace-current) according to the each rules
- Preparing test data according to the test cases
- Implementing the RCCQ to ClaimXten(CXT) through TZ Facet
- Verifying and Validating the each and every RCCQ into Facet Front End through Test (SIT) Environment
- Verifying the RCCQ are implemented to Facet correctly or not based on test cases
- Validating CPT's, modifiers, units, diagnosis codes, revenue codes, bills types, procedural codes are correctly implemented or not.
- Verifying and validating the McKesson’s Edit Code are firing correctly for each rule accordingly
- Validating McKesson RCCQ’s are exit or bypass the related rule correctly
- Verifying the claim correctly paying the benefit or not.
- Extensively working in Facet for claim validation in order to implementing the ClaimCheck to Claim Xten
- Validating the rules are correctly denying or auditing or overriding the claim as per scenario's and test cases
- Verifying the claim 100% covers the RCCQ as well as test scenarios in Facet Front End.
- Verifying the rules exits the claims or bypass the claims when it applies.
- Extensively performing smoke testing, functional testing, regression testing, UAT testing throughout the project.
- Performing validation a report in Excel and tracing the report to the data based on the scenario
- Preparing the defect log and retesting the defect in Facet when it fixes
- Documenting the Test Plan, Test Cases, Test Data, Test Result, Defect Log, and Daily or Weekly Status Reports.
- Working through Facet claim validation for claim Xten
- Working through ALM/Quality Center for requirements, test cases, execute test cases, tracking defects, opening or closing a defect
- Working through SOAPUI and QTP for performing automation testing
- Developing SQL Queries to perform database testing and data validation
- Following Agile methodology, specially SCRUM
Environment: Manual Testing, Facet 5.2, McKesson CXT 8.5, QTP, Quality Center/ALM, Java, HTML, Oracle SQL Developer, Cognos 8.4, SQL, Windows 2000/XP, MS Office Suite, DB2, Oracle 11g, SQL Server 2008, Toad
Confidential
Sr.QA Analyst
Responsibilities:
- Extensively work on FACETS claims processing system and worked on its different applications like enroll subscriber/member, Claim processing (Medical and Hospital), Provider and Billing.
- Extensively work on Facets for validating a claim through Benefit summery, Benefit grid and claim itself.
- Work in Edifecs to process X12 files as per requirements in Edifecs X-engine and tested for snip using (Transaction management/TM)
- Perform Functional, integration, and regression testing.
- Perform ETL testing for data Extract, Transforming and mapping Validation
- Analyze user points of view and the requirements, and develop test cases covering negative and positive scenario
- Develop test Data for different groups of test team
- Validate EDI 834 enrollment process according to HIPAA compliance
- Prepare status reports to track the test status progress and to check if there is any slippage in timelines.
- Work on HIPAA transaction such us 834 Transaction.
- Work with Ultra edits software to Unwrap the X12 file data and compare between two EDI file.
- Maintained test matrix and requirement traceability matrix
- +Wrote SQL queries for data Validation
- Extensively Worked on relational database through Oracle, TOAD, Oracle SQL Developer
- Used Quality center to developed test cases in Test plan module and executed test cases in Test Lab Module and logged the defect in defect Module
- Extensively worked on Documents such as Test plan, Test cases, Test data creation, test results and test reports.
- Worked on all phases of SDLC through Agile Methodology specially Scrum.
Environment: TRIZETTO Facets 5.01, Edifecs transaction Management, Para soft, XML,Soap UI, HIPAA EDI, HP Quality center 10.0, Microsoft visual studio 2010 shell, Ultra edit compare 8.5-0-1025, Microsoft SQL server 2008 R2( SQL server management studio),TOAD, Oracle, Oracle SQL Developer, Microsoft out Look, Microsoft Office communicator 2007 R2, share point, Web service, SOA
Confidential
Software QA Engineer
Responsibilities:
- Analyzed business requirements and developed test considerations to be tested.
- Reviewed BRD, FRD and design specification to create a Test Plan.
- Worked Extensively in Interrogation System for cancellation of enrollment, Reinstatement and cancellation of disenrollment in Trizetto Facets.
- Worked extensively in various facets tables through Oracle database (11g), TOAD, Teradata, Oracle SQL Developers to pull and retrieve the data for preparing test data.
- Worked extensively in enrollment, reenrollment, reinstatement and dis enrollment through Trizetto Facets database.
- Prepared and created test case and test data according to requirements and the Test Plan as well as Test Strategy.
- Worked extensively with Quality Center for requirements, preparing test cases, Executing, defect openings and closings and also reported defects by logging in QC.
- Worked extensively in fazal database, intake database and interrogation database for creating and executing SQL queries to validate reports and data as well as in database testing.
- Worked through Fazal System, Configuration Change system, Intake Automation as well as Interrogation system.
- Worked extensively PSR, BSR as well as ITPR based on various projects.
- Worked through Fazal System and its various enrollment processes such Fazal online Enrolment, OEC Enrolment and Agent or DM46 Enrolment.
- Created Batch ID, Subscriber ID for enrolling member manually
- Performed various Slick Jobs in various environments such as Fazal, Intake and Interrogation according the specified paths.
- Enrolled members in Fazal through Online Enrollment (OEC), DM46 file or manually.
- Validation the member details through Fazal Front End and Back End Testing.
- Worked through UltraEdit for mocking data and preparing test data.
- Worked through validating Cognos report
- Involved in testing relational database
- Performed high level documentation such as Test Results, Test Reports and Bug monitoring repots
- Updated the documents into SharePoint, QC as well as EQuIP (monitoring tool).
Environment: Manual Testing, QTP, Quality Center/ALM, Java, HTML, Oracle SQL Developer, Cognos 8.4, SQL, Windows 2000/XP, MS Office Suite, DB2, Oracle 11g, SQL Server 2008, Toad
Confidential
Software QA Engineer
Responsibilities:
- Analyzed business requirements and developed test scenarios
- Executed test cases by accessing different FACETS Screens, running SQL queries for validating claims, subscriber and group.
- Worked through different Facets Applications groups such as Claim processing application, subscriber/member, Product, Medical plan, group, billing, accounting, and provider.
- Developed manually keying a claims in the iFacets and electronic claims as well.
- Validation and verification a claim through different facets screens according to the Benefit grid and the BSBS.
- Prepared and created test case and test data according to requirements.
- Reviewed BRD, FRD and design specification to determine the Risk Analysis of the application and create a Test Plan.
- Worked extensively with Quality Center for requirements, preparing test cases, Executing, defect openings and closings and also reported defects by logging in QC.
- Extensively worked with SR(Service Request) and HCR( Healthcare Reform)
- Worked with EDI 837,835 and 834 transactions
- Validated ICD 9 and 10 for HIPAA compliance
- Worked through SpecBuilder and UltraEdit in order to preparing test data.
- Created and executed SQL queries to validate reports and data as well as in database testing.
- Followed agile test methodology through Scrum
Environment: Manual Testing, QTP, Quality Center/ALM, Java, HTML, PL/SQL Developer, Cognos 8.4,SQL, Windows 2000/XP, MS Office Suite, DB2, Oracle 11i, SQL Server
Confidential
Software QA Engineer
Responsibilities:
- Involved in Functional Testing, Integration testing, System testing, Regression testing and backend testing and UAT Testing.
- Interacted with Business Analyst and gathered all the requirements.
- Created Test Plan Document and Test cases.
- Created test cases for reports requirements and executed all the test cases.
- Loaded the data for claims tables and patient tables using the reference tables.
- Created test data for all the requirements.
- Created test cases for Cognos Report requirements and executed all the test cases with different user roles.
- Developed SQL queries for Reports and did testing on Cognos reports.
- Validated enrollment and benefits basic case scenarios, Hippa 5010 and 834 EDI compliance for the enrollment process.
- Validated the eligibility and benefits of 834 EDI transactions coded in HL7
- Created the xml files and verified the error logs into the database using the PL/SQL Developer.
- Used Quality Center for Created Requirement traceability matrix and verified all the requirements are covered or not.
- Used Quality Center for maintain the documents and defect tracking purpose
- Performed Regression testing using QTP.
- Involved in creating Checkpoints, Data Driven Test, Function Libraries, Batch Test and User defined Function for creating the VB test scripts.
- Performed testing on JAVA and web based Applications and Involved in different stages of SDLC.
- Performed Integration testing, System testing and User Acceptance Testing (UAT).
- Created the testdata for the flat files and verified the error logs.
- Involved in testing of the Verification and Validation and Production defects.
- Involved in 508 compliance testing.
- Extensively used MS Office tools (Word, Excel) in documenting and reporting errors with screenshots.
- Participation in kick-off, review, release readiness meetings and involved in multiple projects.
- Experience on Agile methodology and Waterfall Model.
Environment: Manual Testing, QTP, Quality Center/ALM, Java, HTML, DHTML, PL/SQL Developer, Cognos 8.4,SQL, Windows 2000/XP, MS Office Suite, DB2, Oracle 11i, SQL Server, Toad
Confidential
QA Engineer
Responsibilities:
- Involved in requirements gathering and analysis.
- Developed Test Plans and Test Cases.
- Involved in different phases of Project Life Cycle.
- Involved in developing the Quality Assurance Test strategy.
- Developed QA Test plans for Functional, Integration and System Testing.
- Developed Requirement Traceability Matrix
- Any defects are found to solve defects completely Participated in Regression testing.
- The analysis of Load on the Server is performed using Performance Monitor and various factors like Processor time; Memory Usage is monitored and analyzed.
- Worked with various teams to fix problems and duplicate online problems in the lab.
- Performed User Acceptance Testing. I involved in alpha Testing and also Beta Testing for testing the application.
- Involved in automating the test scripts for regression testing using Rational Robot.
- Generated data for regression testing using the in Rational Test Manager.
- Automated the regression test cases using Rational Robot.
- Reported software defects and enhancements to the development team using Rational Clear Quest.
- Concentrate on Debit card, Credit card &ATM processing.
- Followed up development team for defect resolution using Rational Clear Quest client effort. .
- Building and releasing changes into the QA, staging, and production environments.
- Developed SQL Queries to perform database testing.
- Backend Testing using SQL Navigator.
- Interacting with Development and QA Teams to ensure overall quality of the software.
- Developed various reports to communicate testing issues to the project manager.
Environment: Manual Testing, Rational Robot, Rational clear Quests, Rational Test Manager, SQL Server 2000,Windows XP Professional, HTML, C, C# .Net, ASP.Net, MS Office Suite.