Skills

Please use this table to list the skills noted in the Required/Desired section of the requirement. In addition, please respond with the years of experience for each skill and the last time each skill was used. Add or delete rows as necessary.

Employment History

Confidential

QA Tester/Data Validation Analyst

Responsibilities:

• Understand the business and functional requirements and identified Test scenarios based on STM and involved in preparation for Test cases
• Executed the test cases and validated them
• Involved in Michigan Claim taxes quarterly Medical Report and MI Healthy kids claim/ encounters. The goal was to successfully extract Paid and Denied claims related data, create file and submit the Michigan Quarterly Encounters submission file
• Participated in the test environment set up and in ensuring that the facilities, test tools and scripts are in place to successful perform the required testing effort
• Created test scripts for and documented using Rational tool
• Developed automated test scripts using QTP to perform Functional and Regression testing
• Defined and executed test plans testing modifications, analyzing and verifying results accurately and in a timely manner
• Track defects in IBM Clear Quest
• Logged defects in the Bug report and tracked to Closure
• Understand BIDR and wrote SQL queries in TOAD for test case execution
• Run the job streams in Tivoli and monitor the job in Informatica Information Center
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables
• Responsible for software testing activities including creating Test Plans, Test Cases, Test Scripts and Test Strategies.
• Performed Manual Testing, Black Box and Grey Box Testing. Good experience in Web based testing
• Run the report in COGNOS and report it in CQ.
• Produce output that meets the expected standards for quality, thoroughness and timeliness
• Created and maintained SQL scripts/queries for Data migration, conversion, mapping, validation and data verification at the backend testing on the database Involved in SAS Reporting which generates daily, weekly, monthly and quarterly reports based on the Business Requirements.
• Run Informatica, SAS, TIVOLI, job for generates daily, weekly, monthly and quarterly reports
• Responsible for weekly, daily, monthly, status meeting, attended the bridge meetings showing progress and future testing efforts and team meetings also.
• Hands on experience on testing claim 270/271, 837, 997, 276,277, 835 to make sure application is transferring data accordingly.
• Involved in Functional, Integration, System, Regression and UAT testing.
• Reviewed and analyzed Business Requirements, Use Cases and High level and Low level Designs throughout the Software Development Life Cycle SDLC .
• Reviewed Functional Specifications and Unit Test Designs and attended for Formal Walk Through meetings.
• Participated in defect reviews with the developers, managers and business people and presented Defect reports in the defect reviews meetings.
• Participated in all daily Status calls with business users, developers, Release Management Calls, Test Case Review meetings and Sign-Off meetings.
• Interact with Users, Business Analysts, Developers, Project Manager, TL to understand detailed technical/business process

Environment: PL/SQL Developer, TOAD, SAS, Tivoli, web services, Informatica, Excel, SQL Server, 408/409/8860.MSP, IBM Clear Quest, Putty, MS office

Confidential

Quality Assurance Analyst

Responsibilities:

• Evaluated business requirements, understood system change requirements and participated in the analysis and design of project specifications with the project management team
• Designed and documented test plan, test strategies, test cases in Rational Quality Manager by applying gathered knowledge from business analysts
• Evaluated the requirement document in Rational Quality Manager and performed hands-on testing for complex test conditions, scenarios and scripts so HIPAA transactions in EDI formats are verified
• Wrote test cases with test steps and edited test cased properties under planning tab of Rational Quality Manager.
• Created different test suites under Execution tab in Rational Quality Manager to assemble collection of tests to be executed together
• Involved in creating UAT Test Strategy.
• Tested Web based application providing a creation photobooks
• Worked in ICD-10 gap analysis and verification of ICD-9 code test
• Worked on 4010 to 5010 translation
• Interacted with developers for defect fixes and documented the bug report and categorized them based on severity.
• Executed batch files in the Mainframe and matched the expected result with the actual result
• Experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries
• Executed tests by running test scripts, test cases and test suites under Execution tab of Rational Quality Manager.
• Worked closely with developers and SME to make sure the new application meets the business requirements
• Executed ETL jobs to test the ETL process. Tested base tables to verify if the correct data is loaded in the Data Warehouse
• Performed database Integrity Testing by executing SQL statements
• Created automation scripts in Rational Functional Tester RFT to validate functional changes to claims processing
• Created a Library of Functions in RFT and documented all User-Defined functions
• Performed data-driven testing to read test input data from an Excel File so as to test the application with different positive and negative data
• Analyzed testing environment for both front and backend testing
• Developed SQL scripts to test data loading process from and to different data sources
• Helped in integration testing of XML/EDI 834/835 for data exchange between different business users
• Extensively used Rational Clear Quest for defect reporting and tracking and prioritizing defects and enhancement requests after base lining the requirements
• Attended change request meetings to document changes and implemented procedures to test changes.

Environment: Rational Functional Tester, Rational Clear Quest, web services, Rational Quality Manager, Quality Center, Windows 2000/NT, Oracle 8, MS Office, Java, Agile.

Confidential

QA Tester

Responsibilities:

• Created Test Plan that defines the test environment, phases of testing, entrance and exit criteria into different phases of testing and resources required
• Imported all the test cases from the Test Case Template into Quality Center and further execution of test cases
• Hands on experience testing 837 Claims for Billing and Payment, 834 Claims for Benefits Enrollment and 835 Claims for Pre-adjudication
• Planned, designed and developed manual test scripts to meet business requirements of the different modules in Rational Test Manager
• Reviewed and analyzed Business Requirements Use Cases to validate Web-based functionalities business processes of Application Under Test AUT
• Used Traceability matrix template, developed Test Cases and Defect Reports to ensure the system modification will meet the specified business requirements
• Prepared test data, translated the user requirements and specifications into QA test requirements
• Created Functional Regression test folders in Rational Clear Quest
• Analyzed Test Results and Created Bug Report
• Developed and executed test cases for the application based on the requirements
• Attended weekly project status meeting to discuss the progress of test execution
• Grouped the test cases along with necessary attributes and design steps in a test suite using execution feature in Rational Test manager
• Worked on ETL Extract, Transform Loading of data from legacy system to the current system
• Involved in HIPAA/ EDI Medical Claim analysis, design, implementation and documentation.
• Validated the reports and files according to HIPAA X12 enforced standard
• Extensively used SQL scripts/ queries for data verification at the backend
• Performed back-end testing by using log files and database
• Created test scenarios for performance testing
• Assisted EDI team with testing of maps for HIPAA transaction 835 and 837

Environment: JSP, Servlets, JavaScript, Rational Clear Quest, web services, COGNOS, JDBC, SQL Server, Windows XP/NT, Rational Suite

Confidential

QA Analyst

Responsibilities:

• Studied the iConnect -2012 Strategy document and iConnect Implementation guide.
• Studied the TRS BRS documents i.e. IConnect E-order SSO, Order to Customer Sales Rep Order process and Order Flow etc.
• Documented the Test Plan, Test Cases, Test Scripts and Test Metrics
• Performed Smoke, Functional Integration Testing.
• Documented, tracked and verified Defects and fixes in assigned multiple Web-based applications
• Recorded Bugs and reported them through creating a Bug Report Document
• Tested the data entry screens and transaction screens in iConnect
• Involved in manually testing the functionality of the Plan Data Files and Sales Rep Template creation
• Maintained the Bug Tracking and Reporting system.
• Identified bugs/ defect during testing and retested the fix
• Performed regression testing on the original functionality in iConnect.

Environment:

web services, Rational Quality Manager, Quality Center, Windows 2000/NT, Oracle 8, MS Office