Sr. Qa Analyst Resume
Washington, DC
SUMMARY:
- Over 7 years of Software Testing, Development and Quality assurance of Client/Server and Web based applications using Win Runner, Load Runner, Test Director, Quality Center, Quick Test pro and Manual testing.
- 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)
- Experience in writing automated scripts, designing Test procedures, Manual Test cases
- And preparing Quality feed back to QA team & manager
- Proficient in Testing methodologies, Test Matrices and Trace matrix
- Extensive experience in Functional testing,, Integration testing, Regression testing, GUI testing, Back-end testing, Browser Compatibility testing, Ad-hoc testing, Black Box Testing, White Box Testing, System Testing, Build Verification Testing, User Acceptance Testing.
- Medical Claims experience in Process Documentation, Analysis and Implementation in 835/837/834/270/271/277/997 (X12 Standards) processes of Medical Claims Industry from the Provider/Payer side
- 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.
- Experienced in analyzing Functional Requirement Specifications (FRS) and conversant with System Design Specifications (SDS).
- 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.
- Experience designing and developing SQL statements and queries for Oracle Sybase and SQL Server 2000 database.
- Extensively used L oad Runner for Performance and Load Testing. The Avg. CPU usage, Response Time, and TPS are analyzed for each scenario
- Extensively used Test Director & Quality Center to write Test Cases and for reporting. All the Scripts are maintained using Test Director & Quality Center.
- Extensively uploaded test cases from MS Excel, MS Word to Test Director & Quality Center.
- Experienced in Bug Tracking System and Process.
- Well conversant with scripting languages like Java Script, VB Script, HTML, DHTML, and XML.
- Strong in manual testing, Automated testing in Visual Basic & other protocol of automation tools Experience in testing applications under. Net, Windows.
PROFESSIONAL EXPERIENCE:
Confidential, Washington DC
Sr. QA Analyst
Responsibilities:
- Drive the completion and complete alignment of system design from business requirements and architectural design.
- Track, drive and coordinate program development activities, per requirements and design, with Business owners, IT PMO, and IT Development teams across US and EMEA.
- Document and analyze business requirements, functional requirements, system capabilities, and detailed design.
- Tested HIPAA Gateway Application Interface for all inbound and outbound messages (Healthcare Eligibility 270 and 271, Healthcare Claim Status request 276 and 277, Healthcare Claim 837 and 835)
- Involved in claims submission and payment (remittance) retrievals by using ASCX12N 820 for the In- bound premium payments; ASC x12N 834 for the Inbound Enrollment and Maintenance; ASCX12 276/277 for the claims status enquiry and response; and ASC X12 835 for the Health care Claim Payments
- Assisted JAD sessions to identify the business flows and determine whether any current or proposed systems are impacted by the EDI X12 Transaction, Code set and Identifier aspects of HIPAA.
- Ensure consistent and effective communication among all parties.
- Proactively identify and resolve issues by working with all portfolio teams
- Create and publish periodic executive reports.
- Defined the test criteria, project schedules and base lined the Test Plan with the help of project meetings and walkthroughs.
- Created the SQL scripts for demonstrating the prototypes and for verifying the result sets
- Work experience on 820, 834, 835 and 277CA transactions for both versions (4010A1 and 5010)
- 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.
- Written smoke test cases in Quality Center and modified them when they are automated.
- Prepared and executed test cases for Navigational test, Functionality testing and GUI testing using Test Director.
- Utilized corporation developed Agile SDLC methodology. Used Scrum Work Pro and Microsoft Office software to perform required job functions.
- Created requirements analysis and design phase artifacts using, Rational Software Modeler and MS Visio to create DFDs, ER diagrams, Use Case, Activity/State chart, Sequence, Collaboration and Deployment Diagrams.
- Managed Scope and change throughout the SDLC process of the product.
- Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
- Conducted Black Box Testing on the application and validated the dataflow in the application.
- Tested security test and audit test for this particular system. Performed Black Box, functional testing, end to end testing for world points system
- Involved in creating logical and physical model of the database using MS Visio, MS SQL Server 2008.
- Manually tested the whole application before going for the automated testing.
- Involved in testing the conversion of the application into web application using XML web services.
- UAT testing performed along with call center managers to make sure that application meets their requirements.
Environment: Java, Business Object, Quick Test Pro 8.2, Mercury Quality Center, J2EE, UNIX, XML, Sybase, SQL, PL/SQL, Oracle9i, MS Vision. MS Office, Quality Center 9.0, QTP, Crystal Report, Quick Test.
Confidential, Detroit, MI
QA Analyst
Responsibilities:
- Prepared Test Plans for each release, written Test Cases and executed them as part of Functional Testing. Prepared Test Reports and Deliverables and submitted for version releases.
- Throughout the project, was involved in giving clarifications on domain and product functionality for the team.
- Involved in the full HIPAA compliance lifecycle from GAP analysis, mapping, implementation, and testing for processing of Medicaid Claims.
- Regular interaction with the core developers helped us in fixing the defects in less time.
- Design, development, implementation and roll-out of Microstrategy Business Intelligence applications
- Performed Black Box testing and conducted Functionality and Regression testing on various phases of the Management software
- Created automated Load test scripts using Load Runner.
- Conducted GUI and functionality testing using QTP.
- Conducted data driven testing using QTP to conduct backend testing.
- Performed White Box testing by using Expediter tool and updated some of the PROCs, JCLs and SAS programs in the Test region. Submitted batch JCLs in order to create output datasets for verification.
- Interacted with the business users in knowing the business views and gathered the reporting requirements to design the universes and business objects.
- Involved in full life cycle of Business Objects reporting Application.
- Involved in Data Modeling of both Logical Design and Physical design of data warehouse and data marts in Star Schema and Snow Flake Schema methodology.
- Designed and Developed the Business Objects Universes which suit the standard, analytical and ad-hoc reporting requirements of the Business Objects users.
- 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.
- Assisted EDI team with the testing of maps for HIPAA transactions 834,835 and 837.
- Configured the Data mapping between Oracle and SQL Server 2005.
- Automated confidence tests that run on new builds on regular basis.
- Involved in setting up different configuration environment for compatibility testing and manual testing.
- Upgraded the existing Test Scripts and created new scripts for client application to be able to work for new versions and patches, which improved product quality.
- Created test scripts for all the test cases in PL/SQL.
- Evaluated testing results for each potential release build using Test Director, Quality Center and Bugzilla reports, listing summarized bug information in priority sequence, recommended viability of release for production.
- Created Use-Case diagrams and State diagrams using MS Visio.
- Preparing Weekly action report & QA feed back to QA team & Manager.
Environment: Web Logic, Java, Quick Test Pro 8.2, MS Visio, MS Office, Mercury Quality Center 9.0, Load Runner 8.2, Sun Java, MSJVM, Oracle 8i/9i/10g, SQL Server 2000, DB2, MS-Project 2000/2003.
Confidential, Chicago, IL
QA Tester/QA Analyst
Responsibilities:
- Worked closely with the loan officers (SMEs) to obtain a detailed knowledge of the loan life cycle process, risk analysis etc;
- Implemented the HIPAA privacy and security regulations to enhance the capabilities of the systems to process new products.
- Interacted constantly between legal and marketing departments with the PM regarding various compliances which need to be in place before anything can be finalized;
- Gathered the business requirements;
- Reviewed the Requirements documents for 5010 ANSI X12 Transactions and created the Test plan and test cases for 837I/P/D,835,276/277,270/271,834,820 HIPAA EDI Transactions for Iteration Testing, Integration Testing and System Testing.
- Performed requirement analysis and gap analysis;
- Documented the business requirements for the developers,
- Designed and developed Use Cases and UML models using Microsoft Visio.
- Developed Test cases for manual testing and automated them using Win Runner, Silk, Load Runner, Silk performer and QTP.
- Involved in testing HIPAA EDI Transactions (837I/P/D, 270/271, 276/277, 835,834, 820) for 5010
- Maintained and kept track of stakeholders requests for enhancements and changes using Rational Clear Quest;
- Manually verified the validity of the failed test cases. Performed Positive, Negative and Black box testing on the application
- Worked on project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
- Translated Business processes into Informatica Mappings for building Data marts.
- Created customized report using OLAP Tools such as Crystal Report for business use
- Wrote Test Cases in Mercury Quality center that would test various Test scenarios.
- Used UML notations for Object Oriented Design and Documentation.
- Interfaced with the development team utilizing ASP, JavaScript and Visual Basic and produced detailed user-interface prototypes and performed usability testing.
- Manually tested and GTS modules using Quality Center.
- Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
- Identified/documented data sources and transformation rules required to populate and maintain data warehouse Designed D content.
- Was responsible for indexing of the tables in that data warehouse.
- Lead Business Intelligence reports development efforts by working closely with Microstrategy, Teradata, and ETL teams
- Provide implementation assessment, strategy, and mentoring services for Rational Rose, UML and RUP.
- Served as a resource for analytical services utilizing SQL Server, TOAD/Oracle, and SQL Developer.
- Developed and maintained the project plan using MS Project
- Rational ClearCase was used to manage all the changes and change requests in the projects. Worked with QA team with the aid of ClearQuest for the bug tracking and Mercury Test Director for Test Case Management.
- Designed and implemented SQL queries for QA testing;
Environment Load Runner, Windows NT /2000, SQL Server 2005, Sybase, MS Word, MS Excel, MS PowerPoint, Ms-Visio, Cognos BI, MS Project, PowerBuilder, Clear-Quest, Rational Test Manager, GIS Tools, Lotus Notes R6 client, HTML, XML, Notes SAS.
Confidential, Harrisburg, PA
QA Analyst
Responsibilities:
- Reviewed requirements together with QA Manager, Vice President of Human Resources & Business Analyst
- Facilitated four-hour long round table discussion with most HR directors, managers and analysts along with QA manager to get their input ad-hoc UAT in the project
- Transactions focused on were 270,271, 834, 835, and 837
- Converted various SQL statements into stored procedures thereby reducing the Number of database accesses.
- Prepared Use cases and Activity flow diagrams and Work flow diagrams, considering the scope of the project with MS VISIO 2003.
- Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
- Reviewed Technical Specs together with the team of two developers
- Worked on EDI transactions: 270, 271, 834, 835, and 837 (P.I.D) to identify key data set elements for designated record set
- 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
- 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
- Used SQL to test various reports and ETL load jobs in development, QA and production environment
- 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
- Prepared PowerPoint slides of all the outcomes with the focus on defects and presented to the team of Business Analyst, VP of Human Resources, and the Developers
- At the end of the project period, a few defects with open status were sent back to the developers through VP and BA
Environment Mercury Tools (Win Runner 7.0, Test Director 7.0/7.5, MS Office, MS Visio, MS project, Load Runner 6.5/7.0, Quick Test Pro 6.5, Quality Center 9.0), NT/00, SQL, SQL Server, XML
Confidential, Nashville, TN
Quality Analyst
Responsibilities:
- Involved in gathering Business Level Requirements and reviewed manual testing methods
- Prepared Test plans which includes an introduction, various test strategies, test schedules, QA teams role, test deliverables, etc.
- Extensively interacted with the stakeholders and the IT Department in finalizing the requirements according to the CMS Compliances/Regulations and HIPAA Regulations.
- Managed and developed EDI specifications, for data feeds and mappings for integration between various systems, to follow ANSI X12 4010 formats including 270Eligibility/Benefit Inquiry, 271 Eligibility/Benefit Information, 276 Claim Status Request, 277 Claim Status Response, 810 Invoice, 820 Payment Order/Remittance Advice, 834 Benefit Enrollment, 835 Remittance Advice and 837 Claims and Encounter, to meet and exceed HIPAA requirements set forth by the federal government
- 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.
- 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
- Designed and developed Project document templates based on SDLC methodology
- Created and enhanced TSL scripts using Win Runner
- Created various checkpoints in the script using Win Runner
- Created reports using Mercury Interactive Test Director
- Application and network performance testing analysis
- Experience with Medicare, Medicaid, and commercial insurances in HIPAA ANSI X12 formats including 270/271, 276/277, 834, 835, 837
- Developed Shell Scripts to automate loading processes
- Writing shell scripts to run batch processes and to run Oracle background\Processes
- Used SQL queries to test the integrity of data by querying the database
- Interacted with the development team to assure that all the defects are addressed in time
- Participated in the team meetings to discuss the issues arising out of testing
Environment - Win runner, Test Director, Windows 2000 Professional, SQL