SUMMARY:

• Over 8 years of experience in Quality Assurance and Software Testing of various business applications in Client/Server environments, Web - based applications, Data-Warehousing solutions, ETL and Business Intelligence solutions.
• Excellent working knowledge of System Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC) and Defect Life Cycle.
• Expertise in Writing, Executing and Maintaining Test Plans, Test Strategy, Test Procedures, Use Cases, Test cases.
• Have solid experience on database query tools such as TOAD, My SQL Server 2008, Oracle and SQL Plus.
• Expert level skills in testing the Enterprise Data Warehouses using Informatica Power Center, Data Stage, AB Initio and SSIS ETL tools.
• Extensive knowledge and experience in producing tables, reports, graphs and listings using various SAS procedures and handling large databases to perform complex data manipulations.
• Experience on UNIX commands and Shell Scripting.
• Knowledge of health information and health care services regulatory environment including Confidential, Confidential / Confidential, CCHIT, EDI and XML .
• Experienced in Functional testing, Performance testing, Load testing, Integration testing, System Testing, Regression testing, Black Box testing, Stress Testing, Smoke Testing, Recovery Testing and GUI Testing.
• Conducted Functionality, Security, Testing Manually.
• Proficient knowledge in various types of Software Testing such as Black box testing, System Testing, Positive Testing, Negative testing, Performance Testing, Smoke Testing, Regression Testing, Stress Testing, System Integration Technique, and Back end Testing.
• Strong experience in preparing documentation, preparing test environments, executing and analyzing the results.
• Experience in testing Business Report developed in Cognos and OBIEE
• Involved in preparation of Requirement Traceability Matrix (RTM), Defect Report, and Weekly Status Reports.
• Experienced in using the Oracle SQL Loader features for loading the data from Flat Files to Data Base tables for Bulk Loading.
• Proficiency in Defect management, including Defect creation, modification, tracking, and reporting using Industry standard Tools like Quality Center, Test Director, Clear Quest.
• Expert in writing complex SQL queries for back-end testing.
• Experienced in interacting with Clients, Business Analysts, UAT Users and Developers.
• Experience in Data Analysis, Data Cleansing (Scrubbing), Data Validation and Verification, Data Conversion, Data Migrations and Data Mining.
• Have experience working in Agile/Scrum Methodology.
• Excellent interpersonal, communication, documentation and presentation skills.

TECHNICAL SKILLS:

ETL Tools: Informatica, Data Stage, Ab Initio, SSIS.

Databases: Teradata, Oracle 11g/10g/9i, MS SQL Server /2008, DB2, Toad

OLAP/BI Tools: Micro Strategy OLAP Suite (8 & 7i), Cognos 8.x/7.0, OBIEE, SSRS

Languages: SQL, PL/SQL, UNIX Shell Script, Visual Basic, XML

Defect Tracking: HP QC 10/HP ALM, Bugzilla, Jira

Testing Tools: Quality Center ALM, Test Director 8.0/7.6/7.2, Rational Clear Quest, JIRA, Rally, Agile, SOAPUI

Job Schedulers: Control M, AutoSys

Web Technologies: SOAP UI 4.5, Web service, XML, HTML

Operating Systems: Mainframe, Windows, Sun Solaris, Linux, Unix, Office Tools

PROFESSIONAL EXPERIENCE:

Confidential, Denver, CO

Sr. QA Tester

Responsibilities:

• Involved in testing Confidential -5010 EDI Transactions and mainly focused on 270/271, 834, 835 and 837.
• Identified the scope of the system that will be modified by the ICD-10 project to accommodate ICD-10 code and /or downstream impacts steaming from ICD-10 codes.
• Identified the processes and system to enable to trade files with non ICD-10 complaint trading partner.
• Involved in FVT and SIT Testing to test the functionality of the system.
• Ensured comprehensiveness and traceability to all of the business requirements.
• Attended JAD sessions with the Subject Matter Experts and Business Analysts to understand the Business requirements for Member Modernization System.
• Intensively worked on Validation testing.
• Used QC for GUI tests and tested GUI Standards of this application. Conducted Usability Testing and Black Box Testing according to specifications.
• Involved in data migration from various source types such as Legacy, Mainframe etc
• Intensively worked on FVT(Functional verification/Validation testing).
• Used SDLC basis of planning approach Microsoft Project used for Planning, Control, Resource Planning and Status reporting.
• Involved in Processing claims and verifying claims whether it’s delivered to the system or not.
• Created Paper Claims in TSA (Test Scenario Application) by using ICD-10 codes.
• Supported integrated EDI batch processing.
• Tested interfaces and ANSI X12 / EDI Version 4010/5010 transactions for 270, 271, 276, 277, 278, 837P, 837I, 837D, 835, 834, TA1, 997 and 824 BRR
• Analyzed Requirements, Prepared Test Conditions, Test Cases and Test Scripts.
• Executed the test cases and raised a defect in where expected results didn’t match actual results.
• Responsible for Extracting and importing clinical data like prescription, adverse event records, laboratory records from Oracle database and other sources. ested Section 508 compliance, Confidential infrastructure EDI transactions for Claims 837P, 837I, 837D, 834, 835, 270/271,276/277 and 278.
• Attended the defect meetings and explained the submitted defects to Business Analysts, Developer and Developer-Lead.
• Attended daily status meeting in order to provide daily work status and issues blocking from progressing the work.
• Intensively worked on claims with different Trading Partners.
• Created test scenarios for claims with different snip levels of errors.
• Worked on the Trading Partner migration to production by submitting different claims with specific levels of errors.
• Export requirements, test cases from MS excel and Word to HP ALM.
• Creating Soap-UI projects as per the Business Specification documents.
• Performed manual front-end testing to check all functionalities of different modules.
• Supported the Business and the Technical team in the product development and delivery process and successfully managed cross- departmental relationships.
• Involved in User Acceptance Test results between users and development team and provided recommendations for change control requests (CCR).

Environment: SQL Server 2008, HP Quality Center 11, MS Excel, Business Objects, Oracle 11g, Informatica 9.0, Version one, Korn Shell Scripting, XML, Putty, JIRA, SSRS

Confidential, Philadelphia, PA

QA Analyst/Business Analyst

Responsibilities:

• Worked for Version document with SME. Primary Liaison between Business User and Development Team.
• Coordinated testing for contract set-up, enrollment and claims processing for four new managed care contracts for Confidential .
• Deep understanding the Business Flow of Investment Banking, and extensively involved in Portfolio management and analysis, Mutual Funds, Securities trading
• Deep understanding of Structured System Development Methodologies
• Assisted Project Manager and User managers to conduct Market Research and Feasibility Studies, and to develop Scope/Vision Documents.
• Analyzing, designing and developing systems in COBOL.
• Worked on UNIX environment in Test and UAT environment.
• Responsible for testing the product using SQL Queries/ UNIX command for the DB check and server startup/new builds.
• Assisted Project Manager in development and documentation of Project Plan.
• Closely worked with SMEs and Identified, researched, analyzed, and defined key issues of the Business flow.
• Responsible for attaining Confidential EDI validation from Confidential, Confidential and other payers of government carriers.
• Created use-case scenarios and storyboards in MS Word and MS PowerPoint for better visualization of the application and managed them using Rational Requisite Pro.
• Involved in the full Confidential compliance lifecycle from GAP analysis, mapping, implementation, and testing for processing of Confidential Claims.
• Verified in UNIX environment to make sure user home directories are created with correct access.
• Extensive working knowledge in Shell Scripting, UNIX, LINUX and Windows platforms.
• Worked on Documentum for Version Controlling, to maintain up to date changes in the Documents.
• Verifying Healthcare Eligibility, Claim, Benefit and Service using ANSI ASI X12 Standards.
• Monitored the compliance mapping of transactions to the EDI transactions standards ANSI -X12.
• 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.
• Analyzed and Documented Business Requirement Document (BRD), Functional Specification Documentation, and System Requirement Documentation, using UML methodologies
• Looked up ICD-9 codes to verify if a code has been changed and entered deposited and updated patients\' demographics using the Medisoft system and ePACES online system to verify a their Confidential status.
• Designed and developed Use Cases using UML and Business Process Modelling.
• Developed QA Test Plan, test conditions and test cases, as well as assisted with QA team in System Testing using Mercury Test Director.
• Analyzed modules and designed test scenarios and test scripts in UNIX environment.
• Experience in working on UNIX, Sun Solaris, Linux, Windows platform. Developed Shell scripts.
• Involved in creating reports for the end users using Crystal reports from the gathered requirements.
• Developed User Manual and Provided User Training.
• Conducted User Acceptance Testing

Environment: RUP, UAT, UNIX, Java, SharePoint, Sybase, Microsoft Word, Project, Excel, PowerPoint, GAD (Gap Analysis Document), HTML, XML, PowerBuilder, ASP. File Net, SQL, GIS Tools, MS Visio

Confidential, Nashville, TN

QA Analyst/Tester

Responsibilities:

• Designed and developed all use cases and UML models using Microsoft Visio.
• Implemented the entire Rational Unified Process (RUP) methodology of application development with its various workflows, artefacts and activities.
• Recommended changes for system design, methods, procedures, policies and workflows affecting Confidential / Confidential claims processing in compliance with government compliant processes like Confidential / EDI formats and accredited standards ANSI.
• Written Test plans, Test cases, executed Test cases for SQL/backend test and tracked defects in Quality Center based on the Business Requirements, Functional Requirements, Business Workflows, A&D documents and ICD documents.
• Maintained and kept track of stakeholders requests for enhancements and changes using Rational Clear Quest;
• Wrote Test Cases in Mercury Quality center that would test various Test scenarios.
• Used UML notations for Object Oriented Design and Documentation.
• 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
• Involved in SOAP and Restful web services using SOAP UI, axis client.
• Installed, configured SOAP UI to test web services using WSDL file given by Development team.
• Performed database validation in the Mainframe to ensure the data entered through the frond end reached the database.
• Interfaced with the development team utilizing ASP, JavaScript and Visual Basic and produced detailed user-interface prototypes and performed usability testing.
• Involved in User Interface Testing and Web Services Testing using SoapScope and MQ tools like IR360 for Multichannel Printing System including consumer document printing.
• Wrote Test plan and Test cases for the Integration testing and system testing.
• Did Integration Testing, GUI testing, Smoke and Sanity Testing, and Acceptance testing in the new builds for Basic Functionality Checking.
• Involved in batch processing of mainframe to update policies.
• Performed Web Services testing using Mind reef Soap Scope, Audit Viewer (to view message logs) and Appwatch (MQ) for Customer and Accounts related transaction projects
• Provide implementation assessment, strategy, and mentoring services for Rational Rose, UML and RUP.
• Analyzed and optimized the process, Prepared Business Requirement Document (BRD) and then converted the business requirements into Functional Requirements Specification and Technical Specification using Rational Requisite pro.
• Confidential EDI transactions such as 835, 837 (P, D, I) 276, 277, 278.
• Performed manual and automated test procedures for functional testing of Web services using SoapUI 2.5.
• Rational Clear Case 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.
• 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
• Published detailed guide describing data file content and structure for business partners; created quick reference guide for Confidential EDI ASC X12 834 transaction set for Confidential enrollment.
• Establish documentation for Agile methodology for implementation with a very water-fall-centric development team.
• Designed and implemented SQL queries for QA testing;
• Assisted the PM in setting realistic project expectations and in evaluating the impact of changes on the project, and conducted project related presentations;
• Prepared user manual and performed user acceptance testing;
• Played a key role in the planning and testing the system enhancements and conversions.

Environment: Load Runner, Toad, Windows NT /2000, SQL Server 2005, Sybase, MS Word, MS Excel, MS PowerPoint, Ms-Visio, XML, DB2, XMLSpy, Cognos BI, MS Project, IBM Mainframe, Primavera, PowerBuilder, Clear-Quest, Rational Test Manager, GIS Tools, SOAP UI 3.0

Confidential, MI

Sr. QA Analyst/Tester

Responsibilities:

• Testing various change orders of Confidential applications received from the System Engineer’s
• Regression Testing of Web applications and applications dealing with Confidential.
• Conducted weekly meetings for deciding the Policies and Procedures to be followed while constructing new sites.
• Conduct complex documentation and user needs analysis. Interface with team and staff to develop HL7 integration
• 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 Confidential .
• Developed the strategy for developing and implementing new EDI (HL7 and X12) interfaces and converting historical clinical and data.
• Involved in the full Confidential compliance lifecycle from GAP analysis, mapping, implementation, and testing for processing of Confidential 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.
• Creating Test Plan and Test cases using ALM.
• Worked on Rational Clear Quest for defect submission and tracking.
• Reviewed EDI companion guides for all payers to ensure compliance, edit integrity and maintain up-to-date list of payer contacts.
• Responsible for architecting integrated solutions, Facets.
• Conducted analysis of Confidential compliance and took part in discussions for designing the healthcare transactions to be 5010 compliant.
• Developed QA Test Plan from technical specifications and requirements for this project which deals mainly with three areas i.e. presentation tool, integrated genesis selling tool and catalog API different iterations and phases of the Software Development Life Cycle.
• Used Test Director and HP/Mercury Quality Center for updating the status of all the Test Cases & Test Scripts that are executed during testing process.
• Identify Member, Provider, Coverage, Confidential, and Confidential .
• 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.
• Provided superior client interaction to make sure all needs were met.
• Performed testing for Confidential, Confidential and X-Over claims for Confidential Management Information System (MMIS)
• Developed and implemented the MMIS Third Party Liability (TPL) Subsystem.
• Conducted business-impact assessment and the results were compared with the new 5010 standards to determine the current level of compliance and developed an action plan for approval by the project steering committee
• Developed plan for data feeds and data mappings for integration between various systems, including XML, to follow ICD 10 Code set and ANSI X12 5010 formats.
• Involved in gap analysis and implementation of Confidential 5010, ICD 10 and Claim Validations
• Conducted Gap Analysis, and Gathered User Requirements by Interviews, user meeting, JAD session, and Requirement Elicitation Sessions
• Utilized corporation developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions.
• All the test scenarios which have been satisfied with the functionality are moved to automation testing using Quick Test Professional.
• Developed and conducted statewide Confidential 5010 and ICD-10 awareness program for all IDS staff in Tenet.
• Backend testing of the DB by writing PL/SQL queries to test the integrity of the application and Oracle databases using TOAD.
• Involved in analyzing activities for a variety of major projects including Confidential Plan part D, Coordination of Benefits, New Client Implementations, Consumer driven and regularly scheduled system upgrades.
• Extensively interacted with the stakeholders and the IT Department in finalizing the requirements according to the CMS Compliances/Regulations and Confidential Regulations.
• Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge.
• Acted as a Business Analyst for the CDS implementation the backbone for data integration among myriad systems, including ERP, CRM, Portal, Workflow Engine, Payroll and related interface
• Prepared graphical depictions of Use Cases, Use Case Diagrams, State Diagrams, Activity Diagrams, Sequence Diagrams, Component Based Diagrams, and Collateral Diagrams and creation of technical design (UI screen) using Microsoft Visio.
• Analyzed trading partner specifications and created EDI mapping guidelines

Environment: Windows 2000/XP, HL7, Oracle, Microsoft Office SharePoint 2007, Cognos, Agile, Rational Requisite Pro, MS Office, SQL Server 2005, Cobol, DB2, JAVA, J2EE, MS Project, MS FrontPage 2003, MS Access, EDI

Confidential, Dayton, OH

QA TESTER

Responsibilities:

• Interacted with business heads to finalize the Business Requirements for the application.
• Performed the requirement analysis and documented the requxirements using Rational Requisite Pro.
• Used the requirement attributes (priority, effort, and risk) as the basis for negotiating the inclusion of the requirement, to manage the scope of the system efficiently.
• Involved in creating sample mappings for the conversion of EDI X12 transactions code sets version 4010 to 5010 and translation of ICD 9 codes into ICD 10 codes.
• Involved with the coders in evaluation of CPT and ICD-9 codes to ensure that the diagnosis meets medical necessity for the specific CPT code.
• Extensively involved in the automation of Regression Test Cases by scripting.
• Produced Gap Analysis documents for Confidential 5010 and ICD-10.
• In depth knowledge of Confidential / Confidential Claims processes from Admin/Provider/Payer side which were later part of the training program to vendors.
• Involved in the full Confidential compliance lifecycle from GAP analysis, mapping, implementation, and testing for processing of Confidential 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.
• Gathered requirements for making changes to the existing Electronic Medical Records(EMR), Electronic Health Records(EHR) and Ambulatory Services for the existing Epic Interfaces.
• Create and maintain requirements, test cases and defects in Mercury Quality Center
• Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives.
• Represent Operations Team as Client Liaison for Confidential Part D Plan.
• Provided clear and concise documentation regarding requirements management plans, Functional Requirements, supplemental Requirements, Test Plans and Test Cases.
• Conducted Joint Application Development (JAD) sessions with IT groups. Identified the Key Changes, and participated in Stakeholder Management to communicate effectively with them
• Implemented Data Modeling standards, including element-naming conventions.
• Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
• Understand the As Is system and develop the To Be system concept and also prepare the System Process Maps.
• Developed extensive experience in eligibility and benefits calculation for state, federal and local services such as Confidential and Confidential .
• Analyzed the changes made to different EDI ANSI X12 transactions (837 I and P, 278, 270 and 271) under 5010.
• Analyzed the business and functional requirements of the application and developed detailed test plans, test cases in Test Director.
• Defined the test criteria and project schedules, and baseline the Test Plan with the help of project meetings, walkthroughs.
• Performed Requirement Gathering & Analysis by actively soliciting, analysing and negotiating customer requirements and prepared the requirements specification document for the application using MS Word.
• Review requirements and understand technical recommendations and constraints, and develop comprehensive and accurate functional specifications; Data Mapping, and process flows.
• Created and managed project templates, Use Case project templates, requirement types and traceability relationships in Requisite Pro.
• Followed the UML based methods using Microsoft Visio to create: Use Cases Diagrams, Activity Diagrams, State Chart Diagrams, Sequence Diagrams and Collaboration Diagrams.

Environment: Flat files, My SQL Server 2008, Oracle 10g, SQL, AGILE, Business Objects HP Quality Center 10, Autosys, Mainframe, Toad, Unix Shell Scripting, Windows XP/2000, Putty