Quality Analyst/tester Resume
Charlotte, NC
SUMMARY:
- More than 7+ years of extensive and diversified experience in Information Technology with emphasis on Development Quality Assurance, GUI, Manual and Automation Testing, Web, and Client/Server based and distributed multi - tier commercial applications.
- Strong knowledge of Health Care Insurance, EDI HIPAA transaction types and worked on EDI Transaction sets including 837, 270, 271, 834, 835, 276, 277, FACETS, ITS (Interplant Teleprocessing Services), QNXT, Medicare Part A, B, C, D and Medicaid systems.
- Exposure of Trizetto Facets and NASCO claims processing system. Good understanding of ICD-9 and impacts related to ICD-10.
- Expertise includes manual and automated testing, QA methodologies, System Audits, Risk management, Change & version management, Requirement and Release management.
- Participated in all phases of the SDLC from analysis, design, and development through testing.
- Experience in writing System Test Plans, defining Test Scenarios and Test Cases, developing and maintaining Test Scripts based on business and functional requirements
- Automating manual scripts by using Automation tools such as Win Runner, Quick Test Pro (QTP) and Selenium.
- Experience with Mercury Test Tools such as Quality Center powered by Test Director and Quick Test Professional (QTP) familiarity with POS terminals such as Hypercom and VeriFone.
- Use Mercury Quality Center for test management and bug reporting.
- Extensive Experience in Black Box and White box Testing.
- Reviewing of Business Requirement Analysis, and System Specifications Analysis.
- Writing positive and negative Scenarios and Test Cases for System & Web testing.
- Hands on experience testing Commercial Websites and business applications.
- Developed Test cases for manual testing and automated them using Win Runner, Silk, Load Runner, Silk performer and QTP.
- Database querying and data manipulation using SQL and PL/SQL and involved in back-end testing as well as front-end testing.
- Proficient in back-end database testing on different database systems including Oracle, SQL Server, MS-Access.
- Strong analytical and problem solving, interpersonal and communication skills, self-starter, quick learner and able to adopt new technologies as needed in rapidly changing IT environment.
TECHNICAL SKILLS:
Operating Systems: Windows 95 / 98 / NT / 2000/XP, UNIX
Testing Tools: Mercury Interactive Win Runner 7.5/8.2, Load Runner 7.8/8.1,Quick Test Pro 6.5/8.0/8.2/9.0/9.2, Test Director 7/7.6/ 8.2
Programming: C, C#, ASP.NET, VB.NET, Core Java
Test Reporting Tools: Mercury Quality Center 9/10.0, Test Director
Web Technologies: HTML, XML, DHTML, ADO.NET, CSS, VB script
Database Tools: SQL Server 2008/2005/2000, Oracle 9i/10g, MS Access 2000s
Networking: FTP, TCP/IP, HTTP/HTTPS
Healthcare Systems: Facets, QNXT, My Health Bank Finance, NASCO.
Tools: MS-Office, MS-Visio, MS Project,PowerPoint, Dream viewer.
PROFESSIONAL EXPERIENCE:
Confidential,Charlotte,NC
Quality Analyst/Tester
Responsibilities:- Involved in analyzing Business requirements and Use Cases and development of Test Plans, Test Cases & Test Scripts.
- Coordinated with automation team for allocation of task and work done.
- Performed extensive Data Integrity testing by executing SQL Statements.
- Identified and reviewed the Manual Test Cases to be automated.
- Created Automation Scripts Winrunner, and Rational Robot tools.
- Performed Load Testing to evaluate the performance of the server using Load Runner tool.
- Defined Functional Test Cases, documented, Executed test script in Facets system.
- Developed SQL scripts to perform Backend Testing.
- Conducted GUI and functionality testing using QTP.
- Conducted data driven testing using QTP to conduct backend testing.
- Performed Smoke, Functional, Integration, Interface, Regression, Load and System testing.
- Involved in the execution of the Limited Regression and Full Regression scripts.
- Worked on the claim routing and claim processing Scenario in legacy and FACETS
- Implemented to execute automation test suites during nightly run.
- Maintained and managed QA Documentation and Automation Scripts in Clear Case tool.
- Tracked the Regression status of the Team members in the Quality Centre to ensure that QC reflects the latest status of the EM and ICE
- Involved in creating the configuration files for setting up the environment with different databases such as Oracle, MS SQL Server, Sybase and DB2.
- Participated in review meetings and daily status meetings during the testing process.
- Coordinated with PM/Business Analysts for QA Sign off for Test Cases/Test Plan
Environment: ASP Net, Visual Basic 6.0, Windows, Oracle, QTP 9.5, Mercury Quality Center 10.0, MS Office, Internet Explorer
Confidential,New York
QA Tester
Responsibilities:- Elicit requirement to be able to generate the tools and info needed to process the ICD-10 information by 2013 (Claims Processing, Training etc.)
- Mapping of ICD-10 codes to procedure and diagnostic codes in Facets.
- Reviewing all codes and appropriately applying them.
- Conduct meeting with the stakeholders and assess their accurate involvement with ICD-10.
- Develop and coordinate implementation timelines with Trading Partners including readiness assessment and coordinated testing.
- Documented defects in JIRA General Access (JRA) and helped DIA team & developers to identify the performance issues and modules to be fixed.
- Identify processes and systems to enable to trade files with non ICD-10 complaint trading partner.
- Help in preparing the ICD-10 context diagram.
- Analyzed the ICD conversion information provided by the CMS and gained understanding of ICD-9 versus new ICD-10 codes sets.
- Prepared Test Cases based on business requirements and business rules for HIPAA EDI Transaction 270/271, 837/835, 834.
- Manually performed User Acceptance Testing of FACETS implementation.
- Work as a Data analyst to set Facets data in Claims Processing, Members/Subscribers, Groups, Billing for different testing efforts.
- Developed data quality test plans and manually executed ETL and BI test cases.
- Performed Backend testing on Membership Enrollment of Facets functionality.
- Performed manual testing to conduct backend testing using UNIX shell scripts and SQL Queries
- Multiple 837 map set developed for each client (clearinghouse, internal, and external trading partners), as well unique mappings were needed in each map to accommodate various conditions dealing with Provider, Subscriber, PAY-TO and BILL-TO Provider information needed to identify multiple conditions dealing with batch Wrote and executed complex SQL queries to retrieve data from Facets-Membership Enrollment modules.
- Responsible in handling Defect Tracking and Mapping reporting through Quality Center.
- Enhanced the Test Scripts by adding Check Points in QTP / UFT.
- Involved in the development of test plans and created test cases and test scripts needed to validate the requirement.
- Analyzed and logged defects in Quality Center and interacted with the developers to resolve technical issues.
- Used QTP Checkpoints (GUI, Database and Bitmap) for comparing behavior of Application from previous builds.
- Help the developers to understand the requirements in order to design the software modifications needed to support the requirements.
- Review Implementation Plan and testing types, techniques and environmental needs.
- Defect Management & triage, provide expertise to resolve defects that raise business issues.
- Reviewed existing QTP Test Scripts, and modified as required for new changes.
- Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS)
- Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
- Verified Informatica sessions, worklets and workflows in QA repository.
- Worked with Teradata, Mainframes (DB2, Copy book, Sequential files), SQL Server and Oracle.
- Actively involved in documentation of UAT (User Acceptance Test), Functional Test, Integration Test Scenarios and Bug Log.
- Extensively used SQL statements to query the Oracle Database for Data Validation and Data Integrity.
- Actively participated in weekly status meeting with Team members, Team managers, Business analysts & Technical team and also generated Weekly Status Reports to the Team manager.
- Tracking Software defects collected from different sources and categorized severity in HP Quality center.
Environment: MS SQL Server 2005,, Flat Files, DB2, SQL Profiler, ETL, Claim Test Pro (CTP), SSRS, TOAD, MS Office, Facets, XML, Windows Server 2003, Quality Center, Agile Scrum, Test Plan, Test Cases, Test Scripts
Confidential,Nashville, TN
QA Tester
Responsibilities:- Tested and delivered Inbound/Outbound Facets interfaces
- Manually entered additional test claims data for those scenarios where a specific claim is not found in Production
- Provided the test summary report to the QA lead and coordinated with the fellow QA lead to plane test execution by using JIRA.
- Involved in Facets Implementation, end-to-end testing of FACETS Enrollment Claim Processing and Subscriber/Member module
- Data mocking for different Claim file formats.
- Conducted HIPAA Gateway Testing.
- Participated in developing and implementing End-End testing.
- Tested the GUI / User Interface of the Web applications.
- Performed Functional testing on Facets, Customer service and Subscriber application under Facets
- Participation in requirement / Use Case analysis, risk analysis and configuration management.
- Transactions focused on were 270,271,276,278,834, 835, and 837.
- Validated the reports and files according to HIPAA X12 enforced standards.
- Automated Claims & Members screens in Facets using QTP.
- Used Quality center for test cases, defect logging and defect tracing.
- Involved in testing HIPAA EDI Transactions and mainly focused on PA and Eligibility Transactions.
- Prepared Test Cases based on business requirements and business rules for HIPAA EDI Transaction 270/271, 834,837/835.
- Created test data for 837I, 837D, 837P to have Segments/loops information with different combination of Submitter, Receiver, Billing Provider, Pay-To-Provider, Subscriber, Payer, Patient, Claim Information, Physicians, Referring Provider, Service Line Info, Adjudication Information
- Tested the subscriber and Member enrollment in association with class, plan and product.
- Tested the Registration process of common practitioner in Facets and validated the fields (Medicare or Medicaid billing number, License and DEA number).
- Identifying Test Scenarios, prepare Test Specification document and Test cases in MTM
- Performed Manual Testing using Quality Center (QC) and User Acceptance Testing (UAT)
- Created data structures by using SQL in Teradata & TOAD.
- Developed SQLs for Extracting data from database and built data structures, reports
- Designed and developed various Ad hoc, Daily, Weekly, Monthly and year-end reports for the Business Analyst using SQL, Ms Excel, Ms Access and Teradata
- Performed UAT Testing Manually in coordination with UAT group to ensure correct business logic.
- Tested and validated the database tables using SQL queries and performed Data Validation and Data Integration
- Responsible to work on Healthcare Management Information System which includes two divisions: HIPAA compliance and Maintenance units division and Claim processing division.
- Monitored workflow of the Resolution/Adjustment Unit, delegate tasks accordingly, and ensure that quality, quantity, and efficiency standards are met or exceeded.
- Worked under HIPAA compliance standards.
- Created and maintained SQL Queries for back-end testing.
- Performed SOA / Web Service testing using SoapUI.
- Created Data for XML Requests in SoapUI.
- Analyzed business rules to generate consolidated (fact/summary) data identified by dimensions using Informatica ETL (Power Center) tool.
- Maintained stored definitions, transformation rules and targets definitions using Informatica repository manager.
- Scheduled sessions and Batch process based on demand, run on time, run only once using Informatica server manager.
- Designed and developed user defined functions of QTP with well-versed VB scripting.
- Used descriptive programming in scripting dynamic objects and reusable actions in defining scenario flows in Quick Test Professional (QTP).
- Maintained Test Matrix which gives overview of the Testing Effort.
- Tested Claims intake/Logged claims/Failed claims data from Pulse tables to Oracle Financials.
- Monitoring the defect life cycle, generating customized graphs and reports for the client, using Quality Center.
- Used Quality Center to record documenting information useful in debugging process, evaluating test data.
- Used Quality Center for reporting and tracking bug and generating reports.
- Extensively used SQL statements to query the Oracle Database for Data Validation and Data Integrity.
Environment: ICD, Agile, FACETS, Mercury Quality Center, ANSI X12,MTM, JavaScript, HTML, XML, HIPAA, EDI, UML, MS Office, Windows XP/,Java/J2EE,.
