PROFESSIONAL SUMMARY:

• 11+ years of experience in Information Technology with an emphasis on Software Testing/Quality Assurance
• Experience both in manual and in automation testing for Client Server, Web based and Web - Services applications.
• Good experience in writing simple to complex SQL Queries based on the requirement for Data Validation on different environments like INT, SYS, STG, UAT and Production.
• Experience in SQL queries using Select, Update, Insert, Delete, Union and in writing JOINS like Self, Inner and Outer joins.
• Good Experience in HP Testing Tool ‘Quality Center QC / ALM’, Rally, JIRA and Agile Manager for the management of Testing Process.
• Experience of application validations belonged to different domains viz., Healthcare, Insurance, Retail, Sales, Finance and Banking.
• Experience in analyzing Business Requirement Specification documents, writing Test Approaches / Test Strategies, developing Test Plans, Test Scenarios, Test Suites and Test Cases both positive and negative.
• Very good experience in participating different meetings like Requirement Review Meetings, Peer Reviews, Daily Stand Ups, Status Meetings, Scrum of Scrums, Defect Review Meetings and Triage Meetings.
• Thorough hands on experience with all levels of testing viz., Integration, Functional and System, System Integration, Interfaces, and Regression and UAT Testing.
• Experience in EDI-834s for the process of Enrollments both for On-Exchange and for Off-Exchange to upload the data into relevant tables for validations.
• Knowledge and experience in preparation and submission of EDI-834s for Pre-enrollment (Initial) and Post-enrollment (Maintenance) through the gateway.
• Working experience with NASCO for external Enrollments using 834s through Edifecs and its integration with company internal system for internal enrollments.
• Good knowledge and experience with HIPAA, HLT7, CFR and FDA standards maintained by the organization and their relevance to Software Applications
• Ability to write QTP Scripts using Object Repository in QTP/UFT and developed automated test scripts using VB Script.
• Strong Experience in SOA architecture and validated Web Services by providing required input data to submit XML request and get response using SOAP UI / ReadyAPI and MQ, besides IBM APIM and IBM Data Power
• Experience on Facets for Claims processing validations and verify the data in Oracle where the data is saved in FacINT, FacSYS and FacUSR.
• Experience in the validations of Claims both for Institutional and Professional including Health and Dental.
• Good Experience in Data Warehousing Applications for data validations including working withETL and Reporting using Tableau.
• Expertise in Test Process orientation, Test Scenario Identification, discussing with business team or with stakeholders on actual business requirements and functionality.
• Experience in Web Services (SOAP / REST) with IBM APIM and Data Power for the ClientID creation, test case creation and execution, Performance/Stress Testing with manual and automation validations
• Excellent analytical skills for reviewing/analyzing requirements/functional specifications and identifying missing, incomplete, inconsistent and contradictory requirements.
• Worked on testing Basic Flows, Alternative Flows (SIEBEL) which generate the exceptions and API testing.
• Very good experience in Test Data preparation by using different techniques like BVA Analysis and Equivalence Partitioning.
• Experience in Data Integration, Data Conversion, Data Migration and for design, develop and execution of test cases.
• Proficient in the preparation and execution of test cases in a traditional approach and also by using the techniques like innovative / explorative testing.
• Expertise in identifying the areas and conditions of testing and sorting out the test cases having the repetition for the purpose of regression testing and also for automation, keeping in view the upcoming version changes.
• Experience in Preparation of Test Data, Execution of Test Cases, logging Defects and submission of Defect Reports.
• Ability to thoroughly analyze system's functional requirements and break them down into test requirements and providing test conditions and test cases using functional analyses.
• Experience in working as an independent or as a team member in fast paced large scale projects with aggressive time lines.
• Good knowledge and experience in Software Development Life Cycle (SDLC) Software Testing Life Cycle (STLC), Test Cases Life Cycle, Defect Life Cycle and Test Automation Life Cycle.

TECHNICAL SKILLS:

Test Management Tools: HP Quality Center (QC) / Application Life-cycle Management (ALM), Rally, Agile Manager, JIRA

Test Automation Tools: HP Quick Test Professional QTP /UFT, SOAP UI, Ready API

Testing Methodologies: Integration Testing, Functionality Testing, System Testing, System Integration / Interface Testing, Back-end / DW Validations, UAT Testing Review and Verification of documents.

Methodologies: BVA Analysis and Equivalence Partitioning.

Scripting Languages: VB Scripting, Java, Groovy Scripting

Languages used for AUT: Java, .Net, C++, C#, COBOL, HTML, XML, Visual Basic

Data Bases: MS SQL Server, Oracle, IBM DB2, MS Access

DB Tools: IBM Data Studio, PL / SQL Developer, MS SQL Server Management Studio, TOAD and Advanced Query Tool (AQT)

ETL Tools: Informatica, DVO, SSIS

Database Languages: T-SQL, PL / SQL

Operating Systems: DOS, Windows, Mainframes and Unix

Test Environment: INT, SYS, USR, UAT, STG, RC, PROD

Software Development Life Cycle (SDLC): Waterfall Model, Iterative Model and Agile / Scrum Model

Others: MS Office, SharePoint, Active Directory, Outlook, Lotus Notes, Communicator, Lotus Same-time

PROFESSIONAL EXPERIENCE:

Confidential, Rochester, NY

Sr. QA Analyst / Web-Services Tester

Responsibilities:

• Performed the validations under Agile-Scrum and Waterfall Environments
• Participated in Daily Scrums, Grooming, Sprint Planning, Sprint Reviews and Sprint Retrospective meetings.
• Validated the Functionalities of the application by executing the Smoke, Functional, Integration, System, System Integration / Interfaces and UAT test cases
• Worked in developing Automated Test Scripts in VB Scripting for Functional Testing using QTP / UFT and by modifying the existing scripts for Regression Testing
• Tested Web Services using SOAP UI, ReadyAPI, and M.Q. for PCP or IPA auto assignments and also in getting Provider Demographics and Provider Risk Details
• Created the Client-IDs both in IBM APIM and Data Power to configure the Headers for the Projects of SOAP and REST Services
• Validated the Applications for their Data Integration with other applications and with the Web Services.
• Created the Test Cases in Agile Manager / JIRA for the WebServices validations.
• Developed and modified Automation Test Scripts in VB Scripting for Functional Testing using QTP / UFT
• Worked on data validations for ‘Null Check’, ‘Number Check’ and ‘Precision Check’ of the data for Data Warehouse and Data Marts
• Participated in Data Migrations for the validations of the data in step by step process of the data conversion to ensure that the data is migrated correctly from source to target
• Performed database testing and validated the data using the tables from DB2, SQL Server and Oracle databases
• Worked on Enrollment Services, where 834s are used, to verify the Enrollment details
• Worked in TST, SYS/QA, USR/UAT, STG and PRD Environments for validations of the database in System, Integration, Regression, SIT, End to End, Performance and Stress testing
• Tested Web Services using SOAPUI Pro/ Ready API, IBM MQ for PCP or IPA auto assignments for getting Provider Demographics and Provider Risk Details.
• Worked on Facets for Claims Service processing validations and on verifying the data in Oracle, saved in FacINT, FacSYS and FacUSR
• Performed validations in the Oracle databases like ODSINT, ODS SYS, ODSUSR, ODSPRD
• Raised the defects found in the application, and also participated in Defect Review meetings to resolve the issues.
• Worked in all the phases of Testing Life Cycle, Defect Life Cycle and Test Automation Life Cycle.
• Validated the Source data and verifying the Target data based on the crosswalk or mapping document.
• Prepared the Test Data and performed the execution of test cases for the validation of the data in data warehouse and data marts.

Environment: Agile and Waterfall, Quality Center 12.54 (ALM), Ready API 1.85/2.0, LoadUI, UFT11.5/12.0, Informatica 8.1, Informatica Power Center DVO 10.0, IBM DB2, Oracle, Windows XP, Windows10, Rally, JIRA, API, .Net, Java, Groovy, VBScripting, IBM APIM, IBM Data Power, IBM Mainframes, HTML, XML, YAML, Swagger and WSDL.

Confidential, Jacksonville, FL

Sr. Q.A. Analyst

Responsibilities:

• Participated in Requirement gathering meetings along with Business Analysts, System Architects, and Sr. Developers.
• Reviewed BRD, Use Cases, User Stories, Technical Design Documents, and prepared Test Plans/Test Cases.
• Participated in Daily Scrums, Grooming, Sprint Planning, Sprint Review and Sprint Retrospective meetings.
• Validated the Functionalities of the application by executing the Smoke, Functional test cases, Integration, System, System Integration / Interfaces and UAT test cases.
• Participated in Data conversion and Data Migration processes for getting an in-depth of the processes and implementation.
• Interacted with design team to decide on the various dimensions and facts to test the application.
• Worked on 834 Enrollment both for ‘On-Exchange’ and ‘Off-Exchange' and uploaded the data into relevant tables in CIP and Pre-CIP (DIS).
• Prepared and Submitted EDI-834s for the process of Enrollments as part of Enrollment automation system validation both for external and for internal processing.
• Preparation of EDI-834s for Pre-enrollment (Initial) and for Post-enrollment (Maintenance) and submission through the gateway for validation of the system.
• Validated the web-services for 834 Enrollments which are associated to Web-application for direct enrollment submissions.
• Participated in the meetings meant for maintaining the standards for FDA and HIPAA requirements.
• Worked in developing Automated Test Scripts in VB Scripting for Functional Testing using QTP / UFT and by modifying the existing scripts for Regression Testing.
• Tested Web Services using SOAP UI, ReadyAPI, and M.Q. for PCP or IPA auto assignments and also in getting Provider Demographics and Provider Risk Details.
• Developed and modified Automation Test Scripts in VB Scripting for Functional Testing using QTP / UFT
• Worked on data validations for ‘Null Check’, ‘Number Check’ and ‘Precision Check’ of the data for Data Warehouse and Data Marts.
• Participated in Data Migrations for the validations of the data in step by step process of the data conversion.
• Tested data migration to ensure that integrity of data was not compromised
• Worked on the analysis of large data sets and preparation of Data Quality Framework with the Team Members.
• Performed database testing and validated the data using the tables from DB2, SQL Server and Oracle databases.
• Worked in TEST (QA) Environment, STAGE Environment for validations of the database in System, Integration, Regression, SIT, End to End, and Content Management testing, also participated in UAT.
• Tested Web Services using SOAP UI, Ready API, MQ for PCP or IPA auto assignments for getting Provider Demographics and Provider Risk Details.
• Worked on Facets for Claims processing validations and on verifying the data in Oracle, saved in FacINT, FacSYS and FacUSR.
• Tested Claims both for Institutional and Professional including Health and Dental.
• Validated the initial load, daily load and future process files using mainframe screens.
• Participated in reviewing test cases and Traceability Matrix very closely ensuring compliance requirements are tested.
• Logged the defects found in the application, and also participated in Defect Review meetings to resolve the issues.
• Participated in the Test Processes and Identifying the Test Scenarios and preparation of Test Conditions.
• Worked on Test Cases both with positive and negative and Test Data Preparation using the Techniques like BVA and Equivalence partitioning.
• Worked in all the phases of Testing Life Cycle, Defect Life Cycle and Test Automation Life Cycle.
• Validated the Applications for their Data Integration with other applications and with the Web Services.
• Validated the Source data and verifying the Target data based on the crosswalk or mapping document.
• Prepared the Test Data and performed the execution of test cases for the validation of the data in data warehouse and data marts.

Environment: Agile and Waterfall, Quality Center 11 (ALM), SOAP UI Pro 4.0/4.5, UFT11.5/12.0, Informatica 8.1, Informatica Power Center DVO 10.0, IBM DB2, Oracle, Windows XP, Windows7/8/10, Rally, JIRA, Agile Manager, API, Ready API, .Net, Java, Groovy, SIEBEL, IBM Mainframes, HTML, XML and WSDL.

Confidential, Cranberry Twp, PA

QA. Analyst / ETL Tester

Responsibilities:

• Participated in daily scrum meetings to take part in day planning to outline a plan of action with mutual discussion of the team members.
• Reviewed User Stories with their acceptance criteria and prepared Test Strategy for each release and written Test plans and Test Cases.
• Participated in Sprint Planning, Sprint Grooming, Sprint Retros, Sprint Reviews for each Sprint.
• Performed all the processes of Testing Life Cycle, Test Cases Life Cycle, Defect Life Cycle and Test Automation Life Cycle.
• Worked for System Integration testing with the Active Directory and also with other existing applications and validated the functionality of the newly added features.
• Used Quality Center for writing test cases on 'User Stories' sprint by sprint of a release.
• Prepared Test Strategies for Release Candidate (RC) in which it’s like a beta testing before the version release.
• Performed the validations both in manual testing like Smoke, System, Regression, Content Management and Usability testing and in automation testing.
• Updated the issues to Lead or Product Owner to find out a solution for the impediments or road-blocks in performing the duties.
• Performed 'Functional' and 'Data driven' testing on various features using Agile / Scrum in Software Development process.
• Analyzed the data mapping and developed scenarios to verify the data migration from different data sources.
• Developed and executed integration and regression test cases and scripts for each specific product group
• Executed automated test scripts, by modifying them wherever necessary, using VB Script in Quick Test Pro and modified some of the existing scripts based on the changes to run the tests for regression.
• Performed the responsible tasks like testing ‘Initial loads’ and ‘daily loads’ of ETL jobs.
• Performed the tasks responsible for translating business requirements into quality assurance test cases.
• Participated in reviewing test cases and Traceability Matrix very closely ensuring compliance requirements are tested
• Worked in maintaining the standards of HIPAA, FDA and CFR in the Software Applications Quality standards.
• Worked on Web Services testing using SOAPUI / SOAP UI Pro and worked on Risk Analysis and prepared mitigation planning.
• Worked on Facets for Claims processing validations and on verifying the data for
• Institutional and Medical claims.
• Executed QTP/UFT existing Test Scripts with modifications for version changes, as part of Regression Testing.
• Participated and reviewed the Testing Process with team members and Test Areas / Scenarios Identification and worked on responsible tasks for on-time deliverables.
• Prepared Test Cases both positive and negative and Test Data Preparation using the Techniques like BVA and Equivalence partitioning.
• Used QC / ALM for raising defects, tracking defects, preparing defect-reports and Rally for task management and writing user stories, investigating for the software bugs and reporting to the developers using 'Defects Module'.
• Prepared Regression Test Plans, Requirements Traceability Metrics RTM, positive and negative test scenarios, detailed oriented Test Scripts, Test Kickoff documents, Test Scorecard for test progress status, Test Results, Release Check list, Lessons Learned documents and Regression Test Suite for future use.

Environment: Agile/Scrum, Quality Center 10, ALM, Quick Test Pro 10/11, SOAPUI 4.0, Informatica, UFT 11.5, SQL Server 2008 R2, Windows XP, Windows7, Rally, VBA, API, .Net, Java, VB Script, HTML and XML.

Confidential, Lisle, IL

ETL Tester

Responsibilities:

• Participated in requirement analysis and Gap analysis of Business System Design and Use cases to understand user requirements which forms the basis for the application.
• Designed and developed the Test plan, Test Scripts for the application and performed User Interface, Functionality, Navigation, and Security testing.
• Performed the validations for Smoke, System Integration, Regression, Usability testing, Content Management testing and also provided the test scenarios to UAT team.
• Executed QTP existing Test Scripts with modifications for version changes, as part of Regression Testing.
• Performed Web Services testing using SOAP UI related to eSupport Application (external) and other services integrated with the internal application.
• Involved in the validation of Service Request Module, New Hire Module and Products to test their integration to ensure interface validity and data processing.
• Worked on the Service Request Module, New Hire Module and Products to test their integration to ensure interface validity and data processing.
• Performed the data validations for ‘Null Check’, ‘Number Check’ and ‘Precision Check’ of the data for Data Warehouse and Data Marts.
• Data Validation is done using oracle SQL queries for System Integration and participated in UAT and also in Production Environment as part of maintenance issues.
• Performed the testing for the processes of the insurance claims (paper and electronic) data by validating it using SQL queries
• Participated in the review meetings for Test Process orientation and for Test Scenario Identification and for writing the Test Cases both of positive and negative.
• Worked on Test Data Preparation both on traditional and explorative ways, using the best techniques like BVA and Equivalence Partitioning.
• Performed the validations in all the phases of Testing Life Cycle and Test Cases Life Cycle
• Participated in the meetings for all the phases of Defect Life Cycle and Test Automation Life Cycle including the preparation of test metrics.
• Attended Test scenarios review, Defect review meetings and Daily status meetings.
• Developed user defined functions to support automated scripts and automated the Test Cases for the purpose of regression testing and Performed Automation testing by using Quick Test Pro.
• Reviewed the test scenarios, test cases and the Data Warehouse Test Results.
• Executed QTP existing Test Scripts with modifications for version changes, as part of Regression Testing.
• Reviewed test cases and Traceability Matrix very closely ensuring compliance requirements are tested.
• Created Test metrics and participated in status meetings and reported the progress to the manager.

Environment: C++, VB.Net, HTML, Web sphere, SQL Server2005/2008, UNIX, SOAP UI, Quality Center 10, Quick Test Pro 10, Windows XP, Oracle 11g and Toad.

Confidential, San Jose, CA

QA Analyst / ETL Tester

Responsibilities:

• Reviewed BRD, Use Cases, Technical Design Documents, and prepared Test Plans/Test Cases.
• Coordinating/leading onshore and offshore teams and knowing their daily status and reporting it to the Test Manager.
• Ensured appropriate coverage of the business process requirements (BPR's).
• Prepared test data and ensuring test environment system availability.
• Tested Confidential interactive forms and workflow of the Sales.
• Designing the process flows using MS-Visio Coordinated with development engineers and prepared test plans and endured functionality of all applications.
• Created test cases for incentive plans and automated the required test cases using Quick Test Pro.
• Wrote simple to complex SQL queries in order to validate data in migration as part of backend testing
• Worked on writing and execution of the SQL queries and validating the data as part of backend testing.
• Tested complex ETL mappings and reusable transformations for daily data loads.
• Participated in the step by step process of Test Processing orientation and Test Scenario Identification and identifying and preparing Test Cases
• Worked on Test Data Preparation in advance of receiving using test builds for the validations both in TEST and STAGE environments.
• Participated in requirement analysis, test scripts/cases, defect management, status reports using Quality Center.
• Analyzed and utilized the techniques like Boundary Value Analysis and Equivalence Partitioning for the Test Data Preparation and validations.
• Worked with programmers during test summary and status calls to resolve defects on priority bases.
• Designed the steps as per the Testing Life Cycle, executed and logged the Defects and tracked the defects from its raising to closing after getting fixed them by the developers as per severity and priority.

Environment: Quick Test Pro 9.5, Quality Center 9.0, Java, J2EE, Web Logic server, XML, SQL Server, VSS, Windows XP, IIS, Oracle 10g, Unix, HTML.

Confidential

Test Coordinator

Responsibilities:

• Coordinated, trained the project teams regarding proper test procedure, review techniques for testing, used Quality Center, used other test services, test automation, load and performance tests etc.
• Coordinating/leading onshore and offshore teams and knowing their daily status and reporting it to the Test Manager.
• Worked on ERP packages and for integration with other applications associated with it.
• Prepared test data and ensuring test environment system availability.
• Designing the process flows using MS-Visio Coordinated with development engineers and prepared test plans and endured functionality of all applications.
• Worked as the point of contact between project team, department and development team, for all test activities
• Supported on-shore, off-shore for Test Cases creation and Execution and verifying day to day statuses.
• Assists in the formulation of requirements with the aim of both functional and non-functional requirements regarding project definition
• Involved in writing and execution of the SQL queries and validating the data as part of backend testing.
• Participated in requirement analysis, test scripts/cases, defect management, status reports using Quality Center.

Environment: Quality Center 9.0, Java, XML, SQL Server, Windows XP, Oracle 10g, HTML.