SUMMARY:

• Over Six Years of IT Experienced in Prepared documentation such as business requirements and functional specifications based on business needs and used the information to develop detailed comprehensive test strategies to verify system changes to meet the needs of the client.
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
• Experienced in developing Test Plans and Test Cases for different types of software testing.
• Experienced in Software Development Life Cycle (SDLC) and Project Life Cycle working as QA in Healthcare domain with prime focus on Claims adjudication, billing, provider, eligibility and prior authorization for Medicare, Medicaid and Blue Programs.
• Hands - on experience with end to end Claims Processing which includes submission, Processing, pricing, benefits, remittance, finalization, adjustments etc.
• Experienced in various types of testing including Sanity Testing, Smoke Testing, Functionality Testing, Performance Testing, Volume Testing, Unit Testing, Integrated Testing, System Testing, Positive and Negative Testing, Security Testing and Regression Testing of, Web Based and Client-Server applications
• Excellent Exposure to SOA, SOAP, WSDL, Web Services, XML and developing Use Case diagrams (UML)
• Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL)
• Experience in Database Testing using SQL Queries with multiple Databases Oracle, DB2, SQL Server and My SQL.
• Hand on experience in test and defect management tools such as Quality Center, TFS, Microsoft Test Manager MTM, Team Foundation Server TFS and JIRA.
• Performed Back End Testing by executing SQL queries.
• Excellent Working Knowledge of HIPPA, Claims Processing, FACETS.
• Involved in maintaining Test Matrix and Traceability Matrix and performed Gap Analysis
• Good understanding of Data warehousing, ETL in SSIS to perform Source to Target testing.
• Participated in design walkthroughs and verified QC Test Scripts and results.
• Tracked and reported on test execution.
• Good Documentation and Process Management skills with an ability to effectively understand the business requirements to develop a quality product.

TECHNICAL SKILLS:

SDLC: Waterfall, Agile, Spiral, RUP.

Bug Reporting Tools: ALM Quality Center, TFS, MTM, Rational Clear Quest

Languages: C#, HTML, JavaScript, Java

Web Reporting Tools: Cognos, SSIS, SSRS (SQL Server Reporting Services) etc.

Testing Tools: Selenium, UFT/QTP, Win Runner, SOAP UI

RDBMS: SQL Server, Oracle, TOAD.

Business Applications: Microsoft Office Suite - MS Word, Excel, PowerPoint, Outlook.

Operating Systems: UNIX, Windows

PROFESSIONAL EXPERIENCE:

Sr. ETL QA Analyst

Confidential, Tampa, FL

Responsibilities:

• Responsible for testing the Navigation Flow, Functionality Testing, System Testing and User Acceptance Testing.
• Created ETL design documents, Unit test results documents, Quality Assurance test cases and participated in QA testing
• Designed and developed several data stage jobs to extract data from Epic Clarity source system (Oracle) and load to highly normalized EDW (DB2) (built using IBM Atomic Warehouse Model AWM) with intermediate steps landing data as-is from source, staging the data in a format that is similar to AWM model.
• Responsible for testing all new and existing ETL Date warehouse components.
• Developed mappings in Informatica to load the data from various sources into the Date warehouse
• Data migration - Includes migration of data from legacy environment to Oracle System.
• Involved in writing Test scenarios, Generic tests cases, detail Positive and negative test cases for ETL also Preparing ETL and SQL routines/code for performing ETL testing (system and integration testing) and Documenting the test results .
• Prepared test data and helped load test data into the test database environment.
• Conducted the defect report in ALM/Quality Center.
• Executed test cases and reported defects using Microsoft Visual Studio test manager
• Worked with developers to resolve Issues and Production Incidents using ALM/Quality Center
• Created and tested different reports like Cross Tab, Parameterized Reports, Tabular, Freeform Reports and Ad-Hoc Reports using Business Objects Reporting tool for Claims, Members, and Providers and Billing modules
• Principles in an agile or test driven methodology environment.
• Wrote test cases in ALM/Quality Center
• Created and maintained SQL Scripts to perform back-end testing on the Oracle database.
• Reviewed extensive SQL Queries with complex multi-table joins and nested queries.
• Responsible for gathering requirements, design and develop data warehousing ETL solutions and delivery reports
• Worked on ETL based solution to automate QA testing process for regression and iterative tests that will be performed in all iterations of Data Mart and data warehouse enhancements.
• Perform static, functional, technical integration, end-to-end and User Acceptance Testing
• Involved in reviewing complex SQL queries, views, functions and stored procedures and spotting issues before/during code migration.
• Created several Test Cases and Test Conditions for testing various Claims, Membership, Billing and Provider reports
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping
• Involved in Web Services Testing using SOAP UI with rest to create and execute automated functional, regression, compliance, and load tests.
• Tested various versions of handheld devices to perform cross platform and browser compatibility testing.
• Performed backend testing for data validation using SQL Queries.
• Extensively used SOAP UI for functional testing of web services.
• Performed rigorous manual testing such Functional Testing, Smoke testing, Integration testing, UAT Testing, Backend Testing, Regression Testing, End to End Testing and System Testing
• Analyze and make specific recommendations on improvements that can be integrated into business processes
• Participate in reviews throughout the development life cycle
• Created and maintained SQL Scripts to perform back-end testing on the Oracle database.
• Performed Database testing using SQL queries
• Involved in validating functional, Integration and Regression test suites using Selenium, Cucumber and the request and response of the Web Services (SOA) through SOAP UI.
• Facilitate User Acceptance Testing by providing the necessary support to the business users
• Worked on parameterizations, calling/copying, Check points heavily.
• Used SOAP UI tool to test SOA based architecture application to test SOAP services.
• Assisted in developing test plans for testing the functionality, GUI, and security.
• Performed manual testing, considering the base line of developed test plan and test cases considering both positive and negative scenarios
• Conducted and participated in walkthroughs to generate consensus, maintaining quality and resolve issues among different stakeholders in the SDLC.
• Test scenario identification and alignment to service oriented architecture implemented within organization
• Created different pricing rules and verified whether the adjudication system is using the rules while adjudicating the Claims

Environment: s: Web Services (SOAP UI), Java, J2EE, HTML, Oracle, MS SQL Server, Informatica, SSIS, SSRS, ETL, HTML, XML, DB2, MS, ALM Quality Center.

Senior Automation QA Analyst

Confidential, Wilmington, DE

Responsibilities:

• Worked with clients to better understand their needs and present solutions using structured SDLC approach.
• Tested application under the agile, scrum and sprint development and process.
• Managed various testing activities throughout the Software Testing Lifecycle (STLC) for multiple projects.
• Used Hybrid Framework of Selenium to get data from Excel.
• Worked throughout the SDLC, which included requirements, specifications, design, analysis and testing utilizing RUP methodology.
• Performed on Agile to emphasize face-to-face communication over written documents.
• Track all issues in an issue management system - JIRA for internal applications, or an agreed upon application for manage issues or enhancements.
• Able to work in Selenium IDE and Selenium Web Driver and execute the test cases using Selenium Web Driver.
• Used Atlassian JIRA for defect tracking and service requests.
• Performing Regression test using automated testing tool UFT/QTP and Selenium.
• Integrated the selenium smoke test into Jenkins for continuous integration
• Worked on distributed test automation execution on different environment as part of Continuous Integration Process using Selenium WebDriver and Jenkins.
• Provided constant guidance to team members in understanding the Agile process
• Attended Change Request Meetings to ensure products and changes are fully documented for further Test changes.
• Performed Regression Testing, Functional, UAT and Ad-hoc testing.
• Arranged weekly team meeting to assign testing tasks and acquisition of status reports from individual team members.
• Extensively utilized ALM Quality Center and JIRA for test management and defect tracking
• Led manual testing effort of application that's part of Wholesale Banking through all stages of SDLC
• Used Custom Reports, Built In reports and System Reports, Trend Reports function within ALM Quality Center to track and report issue related activities.
• Develop and maintain test automation utilizing Ranorex and Selenium testing frameworks
• Regression testing was performed after each build release of the application and updated the Scripts by executing the Regression suites built using Selenium and approve for regression suit.
• Worked with developers to resolve Issues and Production Incidents using ALM Quality Center
• Performed Back End Testing by executing SQL queries on Window and UNIX platform
• Created Test Plans and Scenario which describes the features and functions to be tested.
• Effectively involve in logging bugs, reviewing solved bugs and analyzing test result using ALM Quality Center
• Developed and Implemented automation using Selenium WebDriver and Java.
• Prepared Test Cases based on Business Requirements and required documents.
• Produced various test reports such as Test Execution Status, Test Execution Summary/Progress, Defect Status, Defect Summary, Defect Inject Rate on daily and weekly basis and submitted
• Created/executed test cases for verification of Client Billing through Excel. Program integrated with Excel to create invoices for each client. These excel invoices required testing of VBA macros for calculations and formatting rules.
• Detected, reported and tracked defects using ALM Quality Center.
• Used SQL queries to validate the data between the backend and the front end
• Created test plans, conditions, scripts, and test data; performed product testing, user acceptance, remote user testing, usability standards validation, and performance testing; and resolved system defects.
• Conducted the defect report in ALM Quality Center.
• Interacted with the developers to report and using ALM Quality Center.

Environment: UFT/QTP, Oracle, Selenium, XML, SOAP UI, API, Black Box, Grey Box, Selenium, SQL Server, PL/SQL, Web Services, ALM/Quality Center, MS Office Etc.

QA Analyst & ETL Tester

Confidential, Tampa, Florida

Responsibilities:

• Analyzed Business Requirements and Developed Test Plans, Test Cases and generated Test Scripts for both Positive and Negative testing.
• Performed Code Walkthrough and Quality reviews of software applications.
• Extensively used ALM Quality Center for Test planning, Test execution, defect tracking and Reporting.
• Set the traceability between test requirements and test cases through coverage.
• Validated the data flow from Source to Target tables by verifying the mappings and transformations in ETL Tool, Informatica.
• Worked on SQL Tools like TOAD and SQL Server Management Studio to run the SQL
• Used SQL queries to do backend testing to perform data validation, data migration/data conversion validation.
• Run various jobs in ETL Tool, Informatica using UNIX operating system
• Worked with ETL group for understating mappings for dimensions and facts.
• Documented Defects found during test on the Microsoft Team Foundation Server (MTFS) and communicated recorded problems to the responsible development personnel.
• Written SQL queries to validate data against the Business Object Reports.
• Ensure that QA tasks are linked to Sprint Backlog items in TFS and ensure that test cases are linked to QA tasks
• Done the Restful API testing Using SOAP UI tool creating customers and Validate in Back end and front end systems.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Used Microsoft Test Manager (MTM) for design and developing Test cases as per the requirement.
• Involved in writing Test scenarios, Generic tests cases, detail Positive and negative test cases for ETL also Preparing ETL and/code for performing ETL testing (system and integration testing) and Documenting the test results.
• Involved in reviewing complex SQL queries, views, functions and stored procedures and spotting issues before/during code migration.
• Created defect reports and test summary reports from Microsoft Test Manager (MTM).
• Performed Data Driven Testing to test the application with different sets of data from the test database.
• Used SOAP UI for XML based Web Methods testing
• Performed backend database testing by writing SQL and PL SQL scripts to verify data integrity
• Extracted data from various heterogeneous sources like Oracle, Teradata and Flat Files.
• Updated the test cases using TFS which acted as repository.
• Participated in defect triage, data migration checkpoint meetings.
• Performing Multiple rounds of Test Execution using SOAP UI across various releases of services
• Detected, reported and tracked defects using ALM/Quality Center.
• Developed automated test process.
• Used to create scripts for regression testing.
• Prepared test data for automation of regression test cases.
• Working with the business and development teams in resolving issues
• Prepared weekly summary sheet to give the status of assigned task in weekly project team

Environment: s: MTM, TFS, Oracle, SQL, Java, JavaScript, Data Warehouse, ETL, Informatica, SSIS, Mainframe, ALM Quality Center, XML, UNIX, Web logic, Share Point, UNIX, POS Registers.

QA Tester

Confidential, Atlanta, GA

Responsibilities:

• Worked with clients to better understand their needs and present solutions using structured SDLC approach.
• Managed various testing activities throughout the Software Testing Lifecycle (STLC) for multiple projects.
• Responsible for testing all new and existing ETL Data Warehouse components.
• Attended Change Request Meetings to ensure products and changes are fully documented for further Test changes.
• Extensively worked in testing reporting tool, Cognos by writing test cases and executing them in full software development life cycle.
• Developed mappings in Informatica to load the data from various sources into the Data Warehouse
• Developed highly efficient and reusable Business Process Testing Components (BPT), function libraries using HP Quick Test Pro and ALM Quality Center for BPT.
• Performed various types of testing such as Functional, Regression, SIT, UAT, Backend etc.
• Created Test Plans and Scenario which describes the features and functions to be tested.
• Worked with ETL group for understating mappings for dimensions and facts
• Generating Cognos report and validate the data using SQL queries in Teradata and Oracle data bases
• Tested for data in the database by writing SQL queries for SQL Server before testing the module
• Mapped the test cases to the Requirements in ALM/Quality Center and executed the test cases in ALM/Quality Center in Test Environment.
• Prepared Test Cases based on Business Requirements and required documents.
• Actively participated in the weekly Project Status Meetings.
• Involved in writing Test scenarios, Generic tests cases, detail Positive and negative test cases for ETL also Preparing ETL and SQL routines/code for performing ETL testing (system and integration testing) and Documenting the test results
• Assigned test cases to responsible testers through by creating various Test Sets in Test Lab module.
• Produced various test reports such as Test Execution Status, Test Execution Summary/Progress, Defect Status, Defect Summary, Defect Inject Rate on daily and weekly basis and submitted
• Performed Grey Box, Black box testing and User Acceptance Testing.
• Performed Data Validation of the data flow from the front-end to the back-end by executing SQL scripts.
• Performed Data Profiling of current state of data in the Data Warehouse by doing Data Analysis using advanced SQL Queries and Microsoft Excel, finding Gaps in Data and formulating solutions for the same
• Used SQL queries to validate the data between the backend and the front end
• Executed test cases and reported defects using ALM/Quality Center
• Wrote SQL statements by inserting, deleting, updating data to/from the database to test new entry, update, and delete operations.
• Arranged meetings with the Project Teams to discuss the test approach used for the Data Conversion and ETL modules
• Tracked defects using ALM/Quality Center.
• Used ALM/Quality Center to record documenting information useful in debugging process, evaluating test data.
• Worked with the components of Data Warehousing like components model, ETL tools.
• Gathered business requirements from users and created designs for enhancements and to remedy defects.

Environment: Java, Cognos, Oracle, ETL, Informatica, Data warehousing, SQL Server, PL/SQL, XML, ALM Quality Center, Etc.