Qa Analyst Resume
Oakland, CA
SUMMARY
- 6+ years of experience in the field of Quality Assurance testing client/server and Web - based applications.
- Working knowledge in Health care Domain. EMR systemandEDI transactionsforclaim process, ICD 9 to ICD 10conversion and HIPAA Conversion .
- Good knowledge on Software Quality Assurance, SDLC Testing Methodologies (Agile and Waterfall), Automated & Manual software testing, Performance and Scalability testing.
- Proficient in Black Box, Positive, Negative, Functional, Data-driven, Unit, Regression, System Integration, Sanity, Smoke and Performance Testing.
- Expertise in ETL BACKEND TESTING.
- Integrated experience with business requirements, business rules, functional specification documents and other relevant documentation for UAT planning, design and execution.
- Working experience in Data Analysis, Data Migration, Data Cleansing, Transformation,Integration, Data Import, and Data Export through the use of multiple ETL tool such as Informatica Power Center
- Experience in analyzing business processes and workflows, Assisted in developing Test Plans.
- Prepared Test Cases and Test Scripts for manual/automated testing, Requirements Traceability Matrix.
- Experience in testing data warehouse using extraction, transformation and loading (ETL) tools.
- Working knowledge in designing test cases using Boundary value analysis, Equivalence partitioning and Error guessing techniques.
- Hands on experience in using Quality Center (Test Plan, Test Lab, Defect modules)
- Good Experience in creating, modifying and enhancing both Manual Test Scripts and scripts created by Test Automation tools - Quick Test Professional and Selenium IDE.
- Good working knowledge of using SOAPUI Pro for testing web services.
- Experience in SOA testing using SOAP UI.
- Develop and automate Web Services API testing using Soap UI frameworks
- Expertise in reporting bugs using Bug tracking tools such as, JIRA and HP, ALM Quality Center.
- Performed Back-end testing by extensively using SQL queries to match the data in GUI front end with the data in the back end.
- Expertise in estimating and deriving schedules for development / test execution
- Good knowledge of UNIX/LINUX commands.
- Always open to new ideas with a strong desire to expand knowledge of systems and processes.
- Strong problem-solving and analytical skills whether working with the team or independently.
- Fast learner, good time management, mentoring and task prioritization skills.
- Good communication skills, interpersonal skills and result oriented.
TECHNICAL SKILLS
Software Testing Tools: HP Quality Center, Soap UI, QTP, Selenium, Jira
Database: SQL Server 2008,My SQL and Oracle
Documentation Tools: MS Office, MS Project
ETL tools: Informatica
Operating Systems: LINUX/UNIX
SDLC: Waterfall and Agile.
PROFESSIONAL EXPERIENCE
Confidential, Oakland CA
Responsibilities:
- Responsible for gathering, analyzing and digesting the requirements and the critical areas of the application to setup and execute baseline tests.
- Participate in Agile SDLC using the Scrum process.
- Executed test scripts to verify the expected results based on the system requirements maintained in Quality Center.
- Involved in data setup for all the test cases used for ETL testing.
- Responsible to report bugs using Quality Center and MS Excel.
- In depth knowledge of Health Insurance process, Claims, HIPAA& its approved transaction codes.
- Used an extensive working knowledge of Facets.
- Analyzing the Facets Requirements and thus conducting gap analysis.
- Determined user requirements and goals by conducting meetings with client.
- Drafted test strategies, test cases and test plan based on functional specifications.
- Developed test cases for manual testing.
- Operated project testing efforts by performingSystem Integration testing, Regression testing and by helping UAT team inUser Acceptance testing.
- Executed ETL Scripts and scheduled batch job and generated control reports using Business objects.
- Establish test data for testing the application.
- Analyzed and worked with HIPAA specific EDI transactions for Claims, member enrollment, billing transactions. Worked specifically with 837, 835, 834,and 270/271.
- Verifying the ETL data in target database and Running the Jobs/Workflows for ETL process.
- Extensively involved in writing Test scripts using Rational Manual Tester to perform Manual and Automation testing on the AUT under the different Programming Environment.
- Involved in FACETS Implementation Testing, involved end to end testing of FACETS Billing, Claim Processing and Subscriber/Member module.
- Checked the schema of Oracle database manually or using TOAD after every upgrade.
- Designed, scheduled and executed test plans within the predefined timeframe.
- Conduct the testing (system and regression) of all applications to ensure application integrity both AS/400 based systems and web-based applications. Entails: Managing/executing the testing effort, logging detailed accounts of errors/defects in the systems, and coordinating with the Application Development and Operations teams to diagnose and troubleshoot any errors/defects.
- Created SQL Statements and UNIX Shell scripts to perform ETL testing on the oracle database
- Performed Test Execution & wrote & Executed Test Scenarios/Test Scripts.
- ExecutedSystem integration Test, Regression Test, User Acceptance Testing (UAT).
- ETLTestingand designing of the flow and the logic for the Data warehouse project.
- Developed design specification writing Test Reports & documenting test results.
ENVIRONMENT: EDI, Facets, Power Point, ETL, Agile methodology, MS Office, TOAD, Oracle and Quality Center, Informatica.
Confidential, Baltimore, MD
QA Analyst
Responsibilities:
- Partnered with back-office business units of operations and accounting to understand their needs and requirements
- Extensively used MS Project tools to develop plans, assign resources to tasks, track progress, manage budgets and analyze workloads
- Assist with creation and maintenance all necessary documentation and training materials for Epic Ambulatory application
- Performed analysis, design, development and maintenance of the Epic Ambulatory applications and other clinical information systems..
- Responsible for creation and maintenance of QTP-based automation keyword-driven framework for testing of ETL processes.
- Used Mercury Quality Center to enter and Report defects for Rate Quote Remediation (Upgraded to Facets 431).
- Recommend tactic to implement HIPAA 4010 ( EDI X12 837,834,278,270) in the new System
- Conducted user interviews, gathered requirements, and analyzed the requirements.
- Conduct various Testing like Functional Testing (GUI), System Testing, Backend Testing, Integration Testing and Regression Testing.
- Worked with the business team to collect the business requirements, security and service level requirements and documented them.
- Analyzed set behavior and contribution to business performance, critical business metrics & tracking underlying business trends using Business Objects.
- Working with different IT & Business groups to understand and determine the Impacts to the Data Warehouse and/or Data Marts for different projects
- In a team environment, plannedtestingstrategy for end to end flow through thesystemto link the front end functionality to the back end.
- Creation of QTP scripts for Attachmate Terminal emulator to support ETL processes on mainframe environment
- Responsible for verifying business requirements, ETL Analysis, ETL test and design of the flow and the logic for the Data warehouse using Informatica and Shell Scripting
- Participated in the logical and physical design sessions and developed design documents.
- Performed collection, coding, and assessment and reporting of adverse event data using ARIS.
- Worked on Electronic health record system as a CRM web based application.
- Working Experience in Electronic Submissions in standard format E2B.
Environment: HIPPA, Quality Center, Facets, ARIS, Informatica
Confidential, San Jose, CA
QA Tester
Responsibilities:
- Analyzed Business and Functional specifications and interacted with Business analyst for formulation of test Plan, test cases and test scripts for the Functional, Regression and Smoke testing.
- Developed Test Plans and Test Cases from the functional requirement document and scheduled the test case execution.
- The project was based on Agile Scrum SDLC Methodology.
- Performed both manual as well as automated testing.
- Carried out data extraction loading and transformation ETL.
- Strong experience in conducting Functional Testing, Regression Testing, User Acceptance Testing (UAT), and System Integration testing (SIT).
- Executed Test Cases manually and verified actual results against expected results.
- Involved in testing Inbound/Outbound response transactions, such as the 271, 277, and 278 against original request transaction (270, 276, and 278)
- Involved in Smoke, Functional, Regression, System testing, Integration and Security during testing phases.
- Involved in testing claim (270/271, 837, 276, 277) to make sure application is transferring data accordingly.
- Created the Automation Test Plan and extensively used QTP for creating scripts for functional and regression testing of various features of the application.
- Created the test bed and gathered test data to facilitate the creation and implementation of a Data Driven test automation framework.
- Wrote numerous library files and reusable actions and parameterized them for running the scripts repeatedly for different data values using QTP
- Actively participated in validating the data manipulating and updating the table using SQL for Database Integrity Testing.
- Tested web service usingSOAPUIvia request-response XML using different scenario.
- Validated SOAPresponse andSOAPfaults using assertions.
- Used the JIRA defect tracking system, to report and analyze defects during the entire testing process.
- Communicated testing progress to Business and Project Management team; setup meetings with project managers and other senior members on the project to prioritize testing strategies and Exit Criteria for various testing cycles.
Environment: Windows 8, UNIX, MS-SQL Server, QTP and JIRA,SOAP UI.
Confidential, Raleigh, NC
QA Analyst
Responsibilities:
- Attended review meetings and walkthroughs to discuss the status of the work.
- Prepared Test Cases and detailed test procedures using Quality Center for testing the application under test.
- Performed manual and automation testing.
- Verified and Validated the Automated Test scripts using Selenium
- Proficient in using ICD 9/CPT codes.
- Actively worked on Data analysis and Report analysis with respect to ICD-10 impact
- Exported Test Requirements and Test Cases from Excel and Word to Quality Center.
- Created test scenarios for System testing and Regression testing.
- System Integration testing for Facets core modules with external systems.
- Good experience in testing application during code changes, code updates,.
- Conducted End to End and Black box testing.
- Experience with documenting Claims processing lifecycle and got good exposure of X12 834 transactions for HIPAA 4010.
- Tracked to resolution all UAT environment and data test issues before code is released for test.
- Tested Subscribers/Providers and claims in Facets.
- Tested the EDI 834 interfaces, Developed test cases and test scripts for all 834, 835, 276, 277, Institutional and Professional HIPPA Transactions.
- Tested the Members, Claims, Providers and Services in Facets.
- Involved in logging and tracking defects in JIRA with proper severity and priority.
- Used SQL Queries to verify the data from the Oracle database.
- Worked on tracing the requirements with test cases using HP Quality Center.
- Logged the defects in JIRA and retested the application after the defects are fixed.
- Tested Web page presentation manually for different browser compatibility.
- Identified required test data to execute test cases
- Attended meetings to discuss on status of defects and projects.
- Interacted with developers regarding priority of bugs and update the status of bugs once they are fixed.
- Executed test cases before and after bug fixes for each build for User acceptance.
Environment: Quality Center 11.0, JIRA, Selenium, Facets, HIPPA, My SQL, Series, XML.
Confidential, Miami, FL
QA Analyst
Responsibilities:
- Used Quality Center for version enhancement requests, assigning work activities and accessing the status of project throughout the lifecycle.
- Analyzed Business Requirement Specifications and Test Cases in Quality Center for the Functional, Integration, end-to-end and smoke testing.
- Worked on EDI transactions 835, 837I/P following the HIPAA compliance EDI standard format of X12.
- Performed evaluation of migration paths for legacy BASIC applications and data to a relational database/GUI client-server environment.
- Converted script from Test Manager to Test Factory.
- Worked on legacy conversion data base systems on claims processing.
- Involved in Medicaid Claim Processing system (MMIS).
- Worked on Rational Clear Quest Repositories for defining and logging the testing defects.
- Involved in HIPAA implementation to ensure security and to protect the confidentiality of health information.
- Executed positive and negative test cases.
- Worked on HIPAA Claims/encounters, eligibility verification, enrollment, and related transactions according to American National Standards Institute ANSI X12N.
- Used JIRA as bug tracking and participated in Bug reporting and reviews.
Environment: Quality Center, JIRA, EDI Manual Testing, HIPAA, J2EE, Oracle, UNIX, Windows XP.