SUMMARY:

• Over all 6+ years of experience in the IT industry with emphasis on Quality Assurance/Software Testing with exposure of both Manual and Automated testing tools.
• Expertise in validating and testing of Client - Server and Web-Based Applications in various environments.
• Strong experience in Quality Assurance and Software Testing.
• Exposure to both Manual and Automated Testing of applications developed on Windows and UNIX platform.
• Extensively used HP ALM to plan tests, manage test assets, create and run manual and external scripts to check GUI and functional features of the AUT.
• Experienced in developing Test Plans, Test Cases based upon the business requirements.
• Extensive knowledge of SDLC methodologies.
• Performed HIPAA Analysis and Testing.
• Experience in testing CURAMV6 applications.
• Strong knowledge of HIPAA-ready claims and plan administration.
• Expertise in Oracle table data manipulation using SQL queries and UNIX commands/UNIX scripts.
• Extensive knowledge of database management systems such as SQL and PL/SQL querying tools.
• Strong Knowledge in Healthcare EDI transactions (837, 835, 820, 834, 277, 997, 999) and EDI testing process.
• Experienced in automating regression suite using QTP/UFT, descriptive programming & VBScript. 
• Involved in the Analysis, design, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications.
• Hands on experience in writing SQL queries and executing procedures to perform back end testing for the expected results.
• Expert in retrieving database information writing SQL Queries and transforming data to information as needed.
• Created and added tables to the SQL database when required.
• Performed Sanity, smoke testing as well as manually performed User Acceptance Testing (UAT).
• Experience using testing tools such as Quality Center ALM, Quick Test Pro and SOAP UI.
• Performed an End to End web services testing and XML validation using the SOAP
• Experience in Black Box, Positive, Negative, Data-driven, Unit, Integration, System, Front-End and Back-End Testing.
• Experienced in Regression and Functional Testing.
• Expertise in Bug tracking using bug-reporting tools such as Test Director and Quality center.
• Expertise in writing SQL Queries using SQL Server and DB2 in validating data into Data Warehouse/ETL applications.
• Created updated and maintained Test Matrix and Traceability Matrix and involved in Gap Analysis.
• Used Online Monitors and Graphs to analyze the results.
• To build a high level of trust and confidence with partners and clients in relation to their knowledge of the business issues at hand and of CURAM and the proposed solutions.
• Experienced in conducting Performance testing, Stress testing, Load testing.
• Used Quality Center for Bugs reporting and communicating to developers, product support and test team members.
• Ability to quickly understand and interpret business requirements.
• Good Documentation and Process Management skills with an ability to effectively understand the business requirements to develop a quality product.
• Excellent in communication, presentation, and interpersonal skills. Good team player with the ability to lead, manage and work independently in a time sensitive environment.

TECHNICAL SKILLS:

Testing Tools: Quick Test Pro, QC Alm, Load Runner, Selenium IDE

Bug Reporting Tools: Test Director, Quality Center/Alm,Jira

RDBMS: MS SQL Server, Oracle, MS Access, DB2, Toad

Languages: HTML, Visual Basic, SQL, PL/SQL, .Net

Operating Systems: Windows, Red Hat Linux, SolarisUNIX

Servers: IIS, Apache, Web sphere, web server, ATG

Other Tools: MS (Word, Excel, Power point, Outlook Visio, Project), SharePoint, FACETS

Web Browser: Internet Explorer, Netscape Navigator, Mozilla Firefox

PROFESSIONAL EXPERIENCE:

Confidential, Sterling, VA

Sr.QA Analyst

Responsibilities:

• Interact with the project team to gain an understanding of the business environment, technical analysis to identify, collect, and organize detailed information relating to testing requirements.
• Review business requirements, participate and validate requirement and specifications change of requests.
• Design testing scenarios and test cases to demonstrate conformance to all functional and non-functional requirements as defined in business or technical specifications
• Test case reviews and sign-off with development teams to implement QA testing process and get feedback from cross functional team.
• Performed sanity testing with acceptance test cases and execute test cases from ALM and defect tracking in JIRA.
• Daily testing team meetings with lead to identify gaps, defects and discussion with upcoming changes.
• Support business users during the execution of user acceptance testing by providing data and monitor defects and interact with team to sign process.
• Collaborate with project team members on development and customer issues; identify gaps and retest and regression testing.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Involved in key learning process after each release to implement process in future as a part of QA process Management. Perform problem analysis and resolution, defect researching, and resolution analysis of test results to resolve discrepancies escalate issues. .
• Meet timelines, milestones, and deliverables and provide timely weekly status updates Participate in milestone. SFDC Configurations/Customizations - User Interface, Page Layouts, Tabs, Custom Fields, Custom Objects, Validation Rules, Triggers.
• Report, provide testing project feedback and archive testing assets in order to verify completion of testing. Highly motivated, detailed oriented, ability to work independently as well as a team member with excellent technical, analytical and communication skills.
• Performed various kind of intended Black Box testing such as functional and Non Functional testing to validate the product for the project namely functional, integration, regression, smoke, Back end testing.
• Automated regression and functional testing for the retesting when defect fix was done using QTP.
• Updated the scripts with various methods like loops, conditional statements along with regular expression and error handling.
• Mentored juniors for their skill development also provide client support as per demand.

Environment : SalesForce.com, HP - Quality Center ALM, JIRA, Excel Connector, SQL Server, MS Office 2007, Windows XP, Jabber, VMware.

Confidential, Tampa, FL

Quality Analyst

Responsibilities:

• Analyzed system requirements and developed detailed Test Plan.
• Performed Manual Testing for the EDI transactions.
• Conducted GAP analysis and filling gap according to the format set by HIPAA.
• Involved in FACETS Implementation, involved end-to-end testing of FACETS Billing, Claim Processing and Subscriber/Member module.
• Elicit requirement to be able to generate the tools and info needed to process the ICD-10.
• Work on coordination of benefits (COB) in a claim processing.
• Executed the test cases for Java based CURAM applications and documented the results, reported the defects and track the status.
• Developed Test Script for Functionality, Security, and Regression testing.
• Ran the scripts on multiple environments (QA, UAT and Production) to ensure that requirements were still met.
• Performed GAP analysis for HIPAA 4010 to 5010.
• Performed testing on application Renewals to determine case is renewed and program determination given as per CURAM rules engine.
• Involved in Data Analysis, Data Validation, Data Modeling, Data Profiling, Data Verification, Data Mapping, Data Loading, and Data Warehousing/ETL testing
• Wrote Test scenarios and test cases for testing the migration of EDI4010 to 5010 and the processing of member enrollment and benefits, (834) batch jobs corresponding to the claims (837).
• Perform troubleshooting and resolve errors in 834 and 820 transactions for health insurance exchanges.
• Prepared Test Cases based on business requirements and business rules for HIPPA EDI Transaction 834, 835, 837.
• Assisted in working in establishing EDI system security by suggesting the solution and getting the solution implemented.
• Processed EDI 834 with various scenarios and validate the related tables from database using SQL query.
• Hands on experience in working on designing and reviewing the EDI system applications. 
• Perform compliance testing on 834 and 820 EDI transactions
• Application of EDI 834 transactions in reinstating members, new enrollment, and terminating member enrollment
• Tested all HIPAA transactions for HIPAA 5010 and validate the database.
• Analyzed HIPAA 4010 and 5010 standards for 837P EDI X12 transactions, related to providers for professionals.
• Perform Root Cause Analysis.
• Tested the HIPPA EDI 834, 835, 837 transactions according to test scenarios and verify the data on different modules.
• Perform middleware testing between Front- end application and MIS (Members information system) database using SOAP UI.
• Responsible for continuous process improvement of the reconciliation process
• Transforming Analyst Notes in Preparation for outreach team to contact consumer
• Accessed Health Insurance Casework system for Membership coverage 834 & 820Enrollment reconciliation process
• Worked on HIPAA Transactions and Code Sets Standards according to the test scenarios such as 834,835 transactions.
• 834 Membership enrollment data mapping with the use of workbook Performed Back-End testing to check database integrity by writing SQL queries.
• Set claim processing data for different Facets Modules.
• Tested HIPAA regulations in Facets HIPAA privacy module.
• Wrote test cases in HP ALM derived from the Design documents and generated a Traceability Matrix for testing purposes.
• Created Traceability Matrix to ensure implementation of all functionalities, identify all test conditions and test data needs.
• ICD 9- ICD-10 Conversion Analysis - Worked in the analysis of the ICD 9 - ICD-10 codes.
• Uploaded the diagnosis codes, procedure codes to the related tables in test environment to verify the changes related to ICD9 - ICD-10 changes.
• Tested the configuration of Claims, Enrollment and Customer Service Sub-Systems in Facets.
• Validated member’s benefits against the benefits matrix.
• Validated SOAP and REST services using SOAP UI pro.
• Good experience as SOAP web services tester.
• Analyzed and tested data on claims manually and writing queries on DB database for validating data.
• Worked within a team to resolve Relational Database problems.
• Extensively used SQL statements to query the Oracle Database for Data Validation and Data Integrity.
• Investigated software bugs and interacted with developers to resolve technical issues using HP ALM.
• Verified the data transformations and loaded from external data sources in Teradata, Oracle and SQL Server to the data warehouse and from the data warehouse to data mart using SSIS.
• Used ALM to record documenting information useful in debugging process, evaluating test data.
• Worked with Large DB2 and Oracle, SQL Server databases doing loading, validation and manipulation of data
• Prepared and maintained the Test Matrix, Requirements Traceability Matrix.
• Extensively worked on any requirement upgrade and/or change request while doing UAT.
• Worked with relational databases, and developed PL/SQL queries to interact with Databases.
• Worked closely with development team to ensure the application performance and stability and also ensure the application completes the whole end-to-end process.
• Actively participate weekly CURAM Product Development meeting.

Environment: Waterfall, MS Office Tools, IBM CURAM, Windows, ALM, Facets, Java, DB2, SOAPUI, MS SQL, UNIX.

Confidential, Buffalo, NY

QA Analyst

Responsibilities:

• Analyzed system requirements and developed detailed Test Plan.
• Performed Manual Testing as well as Automation Testing for the EDI transactions.
• Conducted GAP analysis and filling gap according to the format set by HIPAA.
• Developed Test Script for Functionality, Security, and Regression testing.
• Ran the scripts on multiple environments (QA, UAT and Production) to ensure that requirements were still met.
• Involved in Data Analysis, Data Validation, Data Modeling, Data Profiling, Data Verification, Data Mapping, Data Loading, and Data Warehousing/ETL testing
• Performed Back-End Testing to check database integrity by writing SQL queries.
• Set claim processing data for different Facets Module.
• Tested HIPAA regulations in Facets HIPAA privacy module.
• Tested the claims processing with EDI transactions (270, 271, 835, and 837) in HIPPA and HL7 Environment.
• Involved in creating documents and diagrams for Membership Enrollment according to the HIPAA 834 Compliance Standards for Membership Enrollment.
• Prepared Test Cases based on business requirements and business rules for HIPAA EDI Transaction 834, 276/277, 270/271, 837/835.
• Enrolled members through online screens and 834 Transactions to Facets. 
• Modified the 834 file and then checked if the eligibility enrollment is properly loaded onto Facets. 
• Wrote complex SQL queries in TOAD (Relational DB) to perform Back-End testing. Participated in data analysis for verification purposes using SQL queries, views and procedures
• Worked on Data mapping, logical data modeling and used SQL queries to filter data within the Oracle database tables.
• Wrote test cases in Quality Center derived from the Design documents and generated a Traceability Matrix for testing purposes.
• Generated and recorded test scripts that provided extensive application coverage using QTP/UFT.
• Prepared Test Scripts and test Plan for automated testing using QTP
• Good knowledge in data driven web services testing via soap using the source-testing tool SoapUI Pro.
• Developed and executed scripts to test data migration using PL/SQL and UNIX Shell Scripting
• Created Traceability Matrix to ensure implementation of all functionalities, identify all test conditions and test data needs.
• Used HP Quality Center to record documenting information useful in debugging process, evaluating test data.
• Designed, developed and implemented a concurrent processing scheme for check pointing and restart/recovery. This involved the partitioning of certain application dependent Mainframe DB2 tables.
• Prepared and maintained the Test Matrix, Requirements Traceability Matrix.
• Participated in release meetings and also participate in Retrospective session.
• Extensively worked on any requirement upgrade and/or change request while doing UAT.
• Worked closely with development team to ensure the application performance and stability and also ensure the application completes the whole end to end process.
• Participated in weekly status meeting with Development and Management Teams.

Environment: Oracle, Windows, HIPAA, FACETS, IIS, DB2, Quality Center, JAVA, HP QTP and MS-Suit.

Confidential, Pittsburgh, PA

QA Analyst

Responsibilities:

• Designed, updated and reviewed the Test Cases for members’ information, Providers according to HIPAA.
• Involved in FACETS Implementation, involved end-to-end testing of FACETS Billing, Claim Processing and Subscriber/Member module.
• Thoroughly analyzed the business requirement documents and create test cases according to it.
• Implemented Standardized and Unified process throughout the Software Development Life Cycle (SDLC).
• Actively participated in all the phases of the testing Life cycle (Planning, Designing, Development and Reporting and Results).
• Developed standardized FACETS testing, implementation and QA processes, and performed Integration testing, system testing.
• Processed claims in Facets and verified 835X12's are generated and sent to Provider.
• Involved in testing the EDI transactions 834, 837, 835. 270/271 & 276/277 conversions to Facets. 
• Developed Test Script for Functionality, Security, and Regression testing.
• Performed SOA / Web Service testing using Soap UI.
• Created Data for XML Requests in Soap UI.
• Used Complex SQL queries using joins and sub-queries to test the reports generated by the different modules as a part of back-end testing.
• Maintained strong relationships with developers which helped in better execution of test plan.
• Developed and maintained the test scripts, test data and test cases.
• Involved with other team members to set up testing tools, implementation and other testing environments.
• Performed various types of testing, such as functional, regression, user acceptance testing manually.
• Created the test scripts for both positive and negative testing.
• Defect Identification and created defect tracking reports till the close of the defect.
• Preparing Test Metrics using Quality Center.
• Attended various Functional Walkthroughs and writing high level testing scenarios.
• Designed, updated and reviewed the Test Cases for member’sinformation, Providers according to HIPAA.
• Developed and maintained the test scripts, test data and test cases.
• Worked with relational databases, and developed PL/SQL queries to interact with Databases.
• Performed legacy DB2 Testing to cross check new database entity relations
• Performed Manual Testing using Quality Center (QC) and User Acceptance Testing (UAT)
• Utilized JIRA to Track, Report, and Manage defects and bugs throughout the test cycle and attended Defect Status Meetings during testing cycle.
• Generated and recorded test scripts that provided extensive application coverage using QTP/UFT.
• Prepared Test Scripts and test Plan for automated testing using QTP
• Involved with other team members to set up testing tools, implementation and other testing environments.
• Performed various types of testing, such as functional, regression, user acceptance testing manually.
• Created the test scripts for both positive and negative testing.
• Defect Identification and created defect tracking reports till the close of the defect.
• Preparing Test Metrics using Quality Center.
• Attended various Functional Walkthroughs and writing high level testing scenarios.

Environment: HTML, Waterfall, SQL Server, Quality Center, QTP, MS Excel, Windows, UNIX.