We provide IT Staff Augmentation Services!

Sr. Qa Analyst Resume

Chicago, IL

SUMMARY:

  • Over 8+ years Sr. QA Analyst and Quality assurance of Testing Client/server application using Microsoft SQL Server and BI suite Development, UAT and Production Environment)
  • Proficient experience in Manual and Automated Testing of GUI and functional aspects of the Client - Server and Web based Applications on multiple levels of SDLC and Testing Life Cycle (STLC)
  • Knowledge in the ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).
  • Knowledge of 837, 835, 277, 270, 271, NCPDP, 5010 and ICD-10.
  • Strong knowledge of Business Intelligence and Data Warehousing (SQL Server, SSIS, SSAS,SSRS)
  • Expert in Test management using HP Quality Centre, MS TFS, MS Testing Center.
  • Extensive experience in writing SQL and PL/SQL scripts to validate the database systems and for backend database testing.
  • Having expert level experience with Functional testing in Functional System Integration testing, User Acceptance Testing, End to End Test Management, Running Automation scripts in Regression Suites and Non - functional security testing areas. Hands on experience in Project change control mechanisms, Impact Analysis, Risk Analysis, Defect Management, End to End Testing and Production issues/defects ad-hoc and regression Testing & support Having expert level experience with Functional testing in Functional System Integration testing, User Acceptance Testing, End to End Test Management, Running Automation scripts in Regression Suites and Non - functional security testing areas. Hands on experience in Project change control mechanisms, Impact Analysis, Risk Analysis, Defect Management, End to End Testing and Production issues/defects ad-hoc and regression Testing & support .
  • Performed Testing Life Cycle during the various phases of the application. Involved in converting manual test cases into automated scripts using TSL on Mercury Win runner, QTP.
  • Expertise in broad range of technologies, including business process tools such as Microsoft Project, MS Excel, MS Access, MS Visio, technical assessment tools, MicroStrategy Data Warehouse Data Modeling and Design.
  • Experience in Performance tuning of the existing Cognos Reports
  • Excellent experience on Teradata SQL queries, Teradata Indexes, Utilities such as Mload, Tpump, Fast load and Fast Export
  • Ability to deliver comprehensive Business Intelligence through integration of BI suite of products (SSIS, SSAS, SSRS) including MS solutions like MS EXCEL 2007/2010, Microsoft Office
  • Extensively worked on the ETL mappings, analysis and documentation of OLAP
  • Familiar with HIPAA EDI transactions such as 835, 837 (P, D, I) 276, 277, 278 etc
  • Developed Test cases for manual testing and automated them using Win Runner, Silk, Load Runner, Silk performer and QTP.
  • Extensively uploaded test cases from MS Excel, MS Word to Test Director & Quality Center.
  • Experienced in Bug Tracking System and Process.
  • Strong in manual testing, Automated testing in Visual Basic & other protocol of automation tools Experience in testing applications under. Net, Windows.

SOFTWARE SKILLS

Operating Environments: AIX, CLIENT/SERVER, DOS/VSE, OS/400, UNIX, VM, WINDOWS 95, WINDOWS 98, WINDOWS NT / 2000, TSO/ISPF, Vollie

Databases: ACCESS, DB2 6000, MySQL, IMS, SAS, VSAM, Encase, Safeback, Datacom DB, TOAD, IBM DB2, TeraData

Programming Languages: COBOL, SQL, DL/I, APL, JCL, Dreamweaver, Flash 5, Gentran Server 5.0, Java, Coldfusion

Middleware/TP Monitors: CICS, FTP

Project Management Tools: Microsoft Project, Yourdon Methodologies

Reporting Tools: SSRS,Crystal Report Microsoft Integration Services (SSIS

Query and Analytic Tools: CognosRepor Impromptu, MicroStrategy PowerPlay, TM/1 Perspectives, Kenan

Product Evaluations: HBO Star Line of Products for Healthcare ADT, Order Entry, Materiels Management, Lab and Clinicals, NCR Medical records system, Gentran Server 5.0, Mercator, Oracle 7, Sybase, DB2/6000, GTE Financials, TM/1 Perspectives, Kenan, Oracle Express, Oracle IRI, Arbor Essbase, EZCap, Veritas UHA, XML, X12, HL7, OCR applications - Filenet, Trizetto Products ClaimFacts/GroupFacts, FACETS, EPIC medical records, patient admitting, order entry, billing, eScription products, EPI

EXPERIENCE:

Confidential, Chicago, IL

Sr. QA Analyst

Responsibilities:

  • Performed impact analysis on applications for deadliness of ICD-10 conversion.
  • Responsible for decomposition of the requirements based on the functional specifications, design, development, coding, testing, debugging and documentation of applications to satisfy requirements.
  • Involved in FACETS Implementation, involved end to end testing of FACETS Billing, Claim Processing and Subscriber/Member module.
  • Involved in the testing of claims module and claims adjudication process of FACETS.
  • Set claim processing data for different Facets Module.
  • Responsible for GAP analysis of ICD9-ICD10.
  • Assisted EDI team with the testing of maps for HIPAA transactions 835 and 837.
  • Performing Functional and GUI testing on Facets.
  • Follow up for fixes and verification, defect tracking and reporting using Team Foundation server (TFS)
  • Develop and maintain sales reporting using in MS Excel queries, Visual Basic, SQL in Teradata, and MS Access. Produce performance reports and implement changes for improved reporting.
  • Wrote Structured Query Language (SQL) statement against Claims, Claim Status and updating Personal Information modules by Joins, Unions and Aggregate Functions
  • XML and SQL Server package configuration to make package dynamic using SSIS package Configuration Wizard and deploy packages to production Server
  • Exposed to using ICD-09/ICD-10 coding standards in Medicare and Medicaid domains of the healthcare systems.
  • Prepared test matrices based through defect status in Quality Center.
  • Created tabular, matrix, chart, drilldown reports, parametric, cascaded reports and dashboards and scorecards reports according to business requirement in SSRS.
  • Designed Cognos Transformer cube models using reports modeled according to user needs.
  • Executed test cases manually as well as using Automation tool Quick Test Pro.
  • Logged defects in Quality Center and interacted with the developers to resolve technical issues.
  • Used Quick Test Pro for creating inquiries from E-Leads, Online Application and Internal Referral form.
  • Performed Version Control, Planning, Tracking the projects in Visual Studio
  • Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access.
  • Involved in HIPAA/EDI Medical Claims Analysis, Design, Implementation and Documentation.
  • Involved in providing education about the ICD-10 codes and 5010 standards, its requirements, complexity and accuracy to Physicians and Nurses of the hospital. Figured out the requirement of training in various departments of the hospital based on their daily work
  • Build ad-hoc reports using SQL Server Reporting Services (SSRS), Excel.
  • Logged the defects using Quality Center and TFS and used Agile/Scrum methodology .
  • Involved in writing extensive SQL Queries for back end testing oracle database.
  • Designed and implemented HIPAA 835 Payment Advice Transaction, 837 Health Care Claim Transaction.

Environment: EDIX12N 5010, EDIX12N 4010, ICD 10 FACETS, UNIX shell Scripting, Teradata Cognos Report Studio SSRS,S

Confidential, Durham, NC

Sr. QA Analyst

Responsibilities:

  • Prepared Test plans and Test Cases based on requirements using Excel sheets
  • Tested the claims processing and Adjudication (EDI 837I, 837P, 837D& EDI 835).
  • Worked into Health Care Industry with exposure to Electronic Medical and Health Records (EMR & EHR)/Automated Health Care Systems, ICD-10 conversion, HIPAA and other HIT standards.
  • Used Rational Clear Quest to track required changes and Rational Clear Case to maintain different versions of the project documentation.
  • Manually tested the web application to ensure the flow of the application functionality
  • Conduct QA testing of ETL data transformation and data warehouse for reporting solutions.
  • Worked on Defect logging and re-testing defects using Team Link and Reporting Jobs scheduling and running after test data set-up.
  • Manage the team responsible for administrating the standard suite of test tools. Including Issue/DefectTracking and Script Management through HP Quality Center.
  • Involved in validating SSIS and SSRS packages according to functional requirements.
  • Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for Reporting purposes.
  • Expertise in broad range of technologies, including business process tools such as Microsoft Project, Primavera, MS Access, MS Visio, technical assessment tools, Data Warehousing concepts and web design and development.
  • Performed all TRACK database tasks, including setting up team members, ensuring that data was entered correctly, and tracking the progress of all defects uncovered during testing.
  • Managing simultaneous projects with multiple clients, through full system development life cycle, ensuring delivery success using Agile/Scrum methodology and Team Foundation Server (TFS).
  • Created detailed product bug reports including steps to reproduce and other relevant information to streamline the process of correcting defects.
  • Played key role in defining test automation procedure and standards, creating Win Runner and QuickTestProfessional scripts for all the modules, which reduced the regression cycle drastically and improved the testing efforts for daily builds.
  • Validated several SSIS and SSRS packages to verify that they are working according to BRS.
  • Wrote complex SQL scripts in DB2 for testing data quality and validation.
  • Involved in the full HIPAA compliance lifecycle from GAP analysis, mapping, implementation, and testing for processing of Medicaid Claims. Worked on EDI transactions: 270, 271, 834, 835, and 837 (P.I.D) to identify key data set elements for designated record set. Interacted with Claims, Payments and Enrollment hence analyzing and documenting related business processes.
  • Completed the documentation of Claims Scenario’s for the source system
  • Designed, developed and tested data mart prototype (SQL 2005), ETL process (SSIS) and OLAP cube (SSAS)
  • Extensively worked in designing the Testing approach for the ETL process in the Credit Data Provisioning Enterprise Data Warehouse (CDP).
  • Conducted Performance testing using QTP.
  • Designed and Administered Teradata Scripts, Tables, Indices and Database Objects
  • Used SQL to test various reports and ETL load jobs in development, QA and production environment
  • Provided solution to users who raised tickets and educated new users with basic Cognos reporting.
  • Involved in all facets of project cycle including architecture, documentation and testing.
  • Participated in testing various interfaces (Inbound and Outbound) of Facets.
  • Used gap analysis framework to identify AS-IS processes of claims transactions of HIPAA X12 4010/4010A standard and TO-BE processes (ICD-10-CM and ICD-10-PCS compliance requirements) of 5010 standard
  • Used Rational clear quest for defect management
  • Prepared Test plans which includes an introduction, various test strategies, test schedules, QA teams role, test deliverables, etc.
  • Developed and conducted statewide HIPAA 5010 and ICD-10 awareness program for all IDS staff in Tenet.
  • Clarified QA team issues and reviewed test plans and test scripts developed by QA team to make sure that all requirements will be covered in scripts and tested properly.
  • Prepared and executed test cases for Navigational test, Functionality testing and GUI testing using Test Director.
  • Executed the test cases and test scenarios using HP Quality center (QC).
  • Created data sources in Cognos portal and published packages and accessed by Report Studio, Analysis Studio, Query Studio and Event Studio.
  • Use HP Quality Center to house all test documentation and report/track all issues and defects (Defect Management).

Environment: Quick Test Pro, Mercury Quality Center,EDI, HP Quality Center,SSRS, SSIS, ETL Testing, Team Server Foundation (TFS), Bug / defect testing, SQL Testing,, XML, Sybase, Teradata, SQL, PL/SQL, Cognos Report Studio IBM Rational Functional Tester,UML,Rational Rose,Requisite Pro, Clear Case, Rational Clear Quest. MS Office, Quality Center, QTP, Crystal Report, Quick Test. SIS SQL Server 2008, HIPAA tool Kit, XML, Windows, Visual Studio, Toad Quality Center. Team Foundation server (TFS)Agile,XP,UNIX,EPIC

Confidential, CA

QA Analyst /Tester

Responsibilities:

  • Involved in decision making of converting manual test cases into automated test scripts and analyzing their life time and time required to update the scripts.
  • Throughout the project, was involved in giving clarifications on domain and product functionality for the team.
  • Worked in Facets Reconfiguration Data Element Definition and Usage (Working) with values and completed configuring FACETS Applications like Related Entity, Parent Group, Group, Subgroup, and Member/Subscriber using IVSTech Data Toolset.
  • Responsible for Manual testing of both web and stand-alone applications (Agile/Scrum development)- majority testing: System Testing, Function Testing, Integration Testing.
  • Utilize data-driven and compartmentalized test automation practices using Mercury Interactive Test Suite and Compuware Products.
  • Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
  • Served as the primary test resource on Agile based development team.
  • Worked with Inbuilt Transformations in SSIS (ETL) like Persistent Lookups to enhance performance for lookups and more utilization of I/O resources.
  • Tested the application by writing SQL Queries and creating pivot views as to perform back-endtesting.
  • Track and prepare the report of testing activities like test testing results, test case coverage, required resources, defects discovered and their status, performance baselines etc.
  • Write SQL queries to validate that actual test results match with expected results.
  • Developed Test cases for manual testing and automated them using Win Runner, Silk, Load Runner, Silk performer and QTP.
  • Used Rational Clear Quest and Clear Case for Change Management and Configuration Management.
  • Created Test Plans, Test Cases, and Test Scripts for some of the modules.
  • Created macros to analyze Facets application log and extract cumulative timings per transaction.
  • Utilized MS Debugger to analyze Facets client performance at desktop level.
  • Work in the Agile-development environment with frequently changing requirements and features set.
  • Created Microsoft Team Foundation Server (TFS) to queries to help testers locate existing to defects and track defects currently In the defect lifecycle.
  • Worked for Test management using HP Quality Centre, MS TFS, MS Testing Center.
  • Created, developed and executed test cases and test scripts manually and using automation tools.
  • Managed test plans and defects in Clear Quest and updated the comments and resolutions after successful execution of test plans in UAT and Integration environments.
  • Queried Team Foundation Server to locate software defects.
  • Layout and implement SDLC Process improvements across all IT teams in the organization.
  • Developed SQL scripts and wrote stored procedures to validate the flow of data from Legacy source to target application database and ability to perform data validation (of ETL processes, schema and DDL check, data flow from data warehouse to application databases, data marts, return marts, referential data, repositories).
  • Installed & Configured Cognos Office Connection and Developed Templates for Cognos, Office Word, Excel and PowerPoint.
  • Requirement analysis in support of Data Warehousing efforts.
  • Used QTP Checkpoints (GUI, Database and Bitmap) for comparing behavior of Application from previous builds.
  • Responsible for creating test scenarios, scripting test cases using testing tool and defect management for Policy Management Systems, Payables/Receivables and Claims processing.
  • Wrote Test Plans in MS Word for Manual Testing, System Testing, Integration Testing, Performance Testing, Regression Testing & reviewed their consistency with the business requirements.
  • Responsible writing Test Plans, Test Cases and Test Scripts using manual and automated testing tools from Rational and Mercury Interactive such as test Director, Winrunner.
  • Designed and development of test cases based on functional requirements for Institutional and Professional claims for EDI and HIPAA Transactions 837/835, 834, 276/277, 270/271 testing.
  • Authored test plans, test cases for various test scenarios and helped testing team to better understand the test scripts.
  • Executed Test Cases Manually, once the application is stable and documented the successful or unsuccessful completion of each test case in HP Quality Center (QC) for End-to-End Scenario based testing.
  • Used Test Director and Mercury Quality Center for updating the status of all the Test Cases & Test Scripts that are executed during testing process.
  • Established traceability matrix using Rational Requisite Pro to trace completeness of requirements in different SDLC stages.
  • Preparing Weekly action report & QA feed back to QA team & Manager.

Environment: SQL, PL/SQL, Autosys, HP Quality center, Flat Files, VSAM Files, HP ALM, QC (Quality Center), Microsoft Team Foundation Server, Microsoft Share point and Testing center, Quick Test Pro, Business Objects XIR3, Cognos BI UNIX, Shell Scripting, Mercury Quality Center, Oracle 10g, SQL Plus, ETL, Teradata, MS Access, Pivot Tables, SOAP, XML, SQL, Visio 2002 sp2, Windows XP Pro.

Confidential, Carbondale, IL

QA Analyst / Tester

Responsibilities:

  • Internal & External review of Test plan and Test cases.
  • Build setup on Test environment and installation Testing.
  • Used Quality Center for storing test cases and QTP scripts, also used Team Track for defect tracking and reporting purpose.
  • Analyzed research on operational procedures and recommend changes for improvement with an emphasis on automation and efficiency.
  • Performing quality assurance functions covering the full software development life cycle, including development and implementation of test plans, test infrastructure and project plans.
  • Conducted overall quality assurance responsibilities including writing test plans, detailed test cases, test scripts, and test automation development, test execution, defect reporting and tracking, full documentation, and supervision.
  • Wrote Test Plans in MS Word for Manual Testing, System Testing, Integration Testing, Performance Testing, Regression Testing & reviewed their consistency with the business requirements.
  • Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
  • Performed White Box, Black Box, and Usability Testing
  • Wrote Test Cases in MS Excel for user registration, access to training material, and activity log-in, reviewed the test cases and finalized
  • Coordinated and ensured environment setup and availability of infrastructure required for testing.
  • Reviewed colleagues’ test cases for testing the development of online resume, uploading users’ documents such as application and resume, browsing through jobs, selecting and applying for the jobs
  • Documented the outcomes of all the testing in MS Word and MS PowerPoint
  • Developed automated Test Scripts in Win Runner using Test Script Language (TSL) for Functional Testing, Regression Testing, Data Driven Testing, Usability Testing, and Verifying Specific content through using Checkpoints

Environment: Mercury Tools Win Runner Test Director MS Office, MS Visio, MS project, Load Runner Quick Test Pro Quality Center ), NT/00, SQL, SQL Server, XML

Confidential, New York, NY

Quality Assurance Analyst

Responsibilities:

  • Designed and developed the High Level & Detailed Test Plan using standards.
  • Conducted the Functional, System, Integration, Regression, Performance, UAT and Smoke Tests of the client server.
  • Extensive experience in manual testing and creation and maintenance of Test Plan Documents and Test Case Specification Documents
  • Strong communication and analytical skills
  • Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
  • Involved in ETL process testing using Informatica ETL tool.
  • An expert at drafting test cases and test scenarios for UAT phase
  • Manual Functionality Tests of Web pages including HTML Code Check, Browser Compatibility Tests, Browser Page Testing, Transaction Testing, Application Testing and Internationalization.
  • Proven skills in creating test cases and executing the test scripts for the GUI, Functional, Integration and Manual testing using Mercury tools.
  • Experience in creating and developing Test Plan, Test Cases, Test Scripts, and Test Reports, Defect Reports for both Manual and Automation tests.
  • Experience in formulating Test plans, designing manual Test Cases and Test Scripts to support Quality-oriented deliverables.
  • Developing Test Cases from Use Cases, reviewing Test Plans to ensure Use Cases accurately reflect Functional and User Interface testing, and implementing Manual Testing using Test Director and Bugzilla
  • Managed defects and functionality changes using Clear Quest.
  • Generated test scripts for Load and Performance testing to see system behavior under load using Load Runner.
  • Worked closely with software developers, engineers in fixing the defects.

Environment: Quality Center, Load Runner, Clear Quest, SQL Server, UNIX, PL/SQL, QTP, HTML

Confidential, KY

Quality Analyst

Responsibilities:

  • Prepared Test plans which includes an introduction, various test strategies, test schedules, QA teams role, test deliverables, etc.
  • Responsible for writing Test cases to cover overall quality assurance using Test Director
  • Performed initial manual testing of the application as part of sanity testing
  • Performed various tests such as positive, negative to check business functionality manually
  • Performed Black Box testing and conducted Functionality and Regression testing on various phases of the Management software
  • Developed & executed several Optimized queries in SQL on this data.
  • Responsible for Deployment of the report to report server using SSRS and used Report Subscription (Data Driven and Standard) to publish reports.
  • The tests also included GUI testing: Testing for validation and display of screens
  • Created dummy accounts on our system and verified the account generation process and date integrity
  • Used SQL queries to test the integrity of data by querying the database
  • Initiated defects and assigned to Development teams with appropriate severity levels.
  • Actively participated to setup the test environment for the application(s) needs to be deployed on test environment.
  • Used Quality Center to maintain Test Cases.
  • Recorded the Test cases using Quick Test Professional (QTP) for web based application and performed regression testing of the application for every release.
  • Prioritized and reported defects using Quality Center to present documents and reports in weekly team meetings.
  • Generated test scripts for Load and Performance testing to see how the system behaves under load using Load Runner.
  • Participated in Software Quality Analysis, Manual Testing and Defect Tracking Tools.
  • Designed and developed test cases by putting the application through manual testing and automated testing
  • Represented the end user by conducting User Acceptance Testing (UAT) and System testing
  • Involved in writing Use Cases, UAT Plans and UAT cases from Business Requirements
  • Performed Integration, Regression, UAT and Database testing

Environment: Win runner, Test Director, Windows 2000 Professional, SQL

Hire Now