SUMMARY:

• Over 7+ years of Professional Experience in Software Quality Assurance and Testing in different environments and platforms including Data Warehousing, Client - Server and Legacy Mainframe applications.
• Extensive experience in reviewing Business Requirement Documents, Software Requirement Documents and preparing Test Cases, Test scripts and Execution.
• Experience in Black box testing with a complete QA cycle - from testing, defect logging and verification of fixed bugs.
• Extensive experience in Web services testing using SOAP UI & SOAP UI Pro.
• Experience in testing Business Report developed in Business Objects XIR2
• Experience on Web services to combine component based development and Internet standards and protocols that include HTTP, XML, SOAP and Web services Description language.
• Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
• Experience in Medicaid/Healthcare applications and worked in all HIPAA versions and transactions like 4010 and 5010 270, 276, 837, 834 and 835 transactions.
• Involved in testing the Claims application and HIPAA EDI Transactions. Also tested the integration between Claims application and other applications like Providers, Eligibility and Member Services application.
• Used QTP to update Automation Test scripts and executed for core features of the application.
• Excellent Communication, Analytical and Interpersonal skills.
• Worked with IT Operations to ensure test environment readiness.
• Experienced in working in Agile Scrum, Agile XP, Waterfall, RUP, RAD and SDLC methodology environments
• Extensive experience in Functional testing, Integration/System testing, Regression testing and User Acceptance testing.
• Expert in creating SQL queries against Oracle, MS SQL server and DB2.
• Worked on the MMIS (Medicaid Management Information Systems)
• Designed Claims Inquiry screen within the MMIS and executed Testing Scenarios, Cases & Conditions involving User Acceptance testing, Regression, Integration and System testing.
• Well versed in GUI application testing, Database testing and Front-end testing.
• Solid Back End Testing experience by writing and executing SQL Queries.
• Ability to interact with developers and product analysts regarding testing status and to maintain detailed QA documentation.
• Extensive background in QA methodologies.
• Strong Problem Analysis & Resolution skills and ability to work in Multi Platform Environments like Windows and UNIX.
• Experience in Installation and Implementing Mercury Interactive Test Suite.
• Has expertise in Test Case Design, Test Tool Usage, Testca Execution, and Defect Management.
• Experience in UNIX shell scripting and configuring cron-jobs for Informatica sessions scheduling.
• Experience in testing XML files and validating the data loaded to staging tables.
• Good experience in Cognos & Business Objects Reports testing.
• Experience in Performance Tuning of SQL and Stored Procedures.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
• Expert knowledge in UNIXshell scripting (Korn shell/Bourne shell).
• Have good knowledge of Web Servers, Database Servers, and Application Servers.
• Excellent analytical, programming, written and verbal communication skills.

TECHNICAL SKILLS:

Testing Tools: HP Quality Center /ALM, Test Director, QTP, Load Runner

Web Technologies: ASP, HTML, DHTML, JavaScript, VBScript, XML, SOA.SOAPUI

Methodologies: Rational Unified Process(RUP), Agile, SCRUM

Environment: Windows 98/2000/NT/XP, IBM Mainframes, UNIX, Linux.

Languages: SQL, PL/SQL

RDBMS: Oracle, Sybase, DB2, SQL Server, Teradata

ETL Tools: Informatica Power Center, Ab Initio, SSIS and DataStage

BI Tools: Business Objects XIR2/XIR3, Cognos and Hyperion

PROFESSIONAL EXPERIENCE:

Confidential,Montgomery, AL

QA Tester

Responsibilities:

• Developed Test Scenarios and Test Cases based on Test plan.
• Tested HIPAA EDI Transactions such as 837(I/P/D), 835, 834, 270, 271, 276, and 277 in various claims validation processes.
• Involved in applications analysis and testing which included claims processing as per EDI/ANSI-X12 transactions Standards.
• Performed Integration/System/Regression testing of enrollment and benefits with Diamond.
• Responsible for testing EOB in accordance to business rules for claims processing.
• Involved in testing Claims, Providers, & Contracts and worked with Claims attributes, Provider attributes, enabling EOB.
• Managing simultaneous projects with multiple clients, through full system development life cycle, ensuring delivery success using Agile/Scrum methodology and Team Foundation Server (TFS).
• Participated in JAD sessions to ensure appropriate scope management for MMIS.
• Used DTS to migrate the tables to the Data Warehouse. Handled Different DSS (Decision Support System) for various applications.
• Assisted tools for use in future HIPAA EDI 5010 migration and compliance.
• Utilized Quality Center to write and execute test cases.
• Responsible for gap analysis in changing old MMIS and Involved in testing new MMIS.
• Performed User Acceptance Testing (UAT), documented in details the defects using Quality Center.
• Involved in testing the Member Enrollment, Eligibility Enquiry, Eligibility Response, Claim status Enquiry, Claim Status Responses and conversion of Financial Claims.
• Worked on various HIPAA X12N Standards like 270/271, 278In/ 278Out, 834 while testing various level of EDI Transactions.
• Used DB2 client to write SQL's to validate the test data.
• Worked on Medicaid Recipient processing including specialized knowledge of Recipient processing, Portals, and Enrollment Subsystems of MMIS.
• Tested the Adjudication of Claims and Migration process.
• Wrote SQL queries and extracted data.
• Skilled in executing SQL queries to validate and update database and retrieve data for testing.
• Database integrity testing by executing SQL statements.
• Created and maintained SQL Scripts to perform back-end testing on the database.
• Used quality center for logging defects and defect Tracking.
• Involved in Integration Testing, Functional Testing, and UAT.
• Tested the functionality of the Extensions that meets the BRD requirements.
• Involved in validating XML Files.

Environment: Waterfall and Agile, MS Office Tools, IBM DB2,SOAP UI, ETL, Informatica, Windows XP, ALM, Web services, Mojo, Diamond and IBM Mainframes.

Confidential,Charlotte,NC

QA Tester

Responsibilities:

• Responsible for coordinating testing throughout both systems ODS and EDW which were two different teams.
• Promoted Unix/Informatica application releases from development to QA and to UAT environments
• Did end to end testing for SOA but delayed for system unavailability.
• Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
• Involved in testing the HIPAA EDI Transactions for eligibility (270, 271), claims (837, 835) and enrollment (834).
• Written test cases to test the application manually in Quality Center and automated using QTP.
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata
• Responsible for updating clients with provider information within MMIS on a weekly basis by running queries and exporting data in a defined file formats.
• Developed data quality test plans and manually executedETL and BI test cases.
• Responsible for testing EOB in claims module after claims processing.
• Involved in writing DB2 queries per the test requirements and for the fatal errors.
• Designed and kept track of Requirement Traceability Matrix
• Used SOAP UI for web service testing like validating the response of claim processing.
• Involved in Integrating and Functional System Testing for the entire Data Warehousing Application.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Used Quality Center for defect tracking.
• Tested web services by generating XML SOAP requests and validated the corresponding XML SOAP responses.
• Performed data quality analysis using advanced SQL skills.
• Tested slides for data flow and process flows using PowerPoint and Microsoft Visio
• Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance.
• Involved in HIPAA/EDI Medical Claims Analysis, Design, Implementation and Documentation.
• Worked as Onsite Coordinator for getting the work done from offshore team.
• Testing the reports and maintenance of daily, monthly and yearly.
• Involved in Writing Detailed Level Test Documentation for reports and Universe testing.
• Involved in data warehouse testing by checking ETL procedures/mappings
• Implemented and maintained tools required to support data warehouse testing.
• Performed the tests in both the FIT, QA and contingency/backup environments
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing
• Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing.
• Wrote SQL queries to perform database testing and to verify data integrity.
• Created different user defined functions for applying appropriate business rules

Environment: Informatica, Quality Center, SQL, PL/SQL, DB2, SOAP, SOAPUI, MMIS, Web Services, Agile, QTP, COBOL, UNIX, Korn Shell Scripting, Oracle 10G, DB2, TOAD

Confidential,Virginia Beach,VA

QA Tester

Responsibilities:

• 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).
• Tested the ANSI X12 Version 4010 /5010 EDI transactions (HIPAA) like (834, 837P, 837I, 835 remittances).
• Involved in forward mapping from ICD 9 to ICD10 and backward mapping from ICD10 to ICD9 using General equivalence Mappings (GEM).
• Involved in testing HIPAA Database, which incorporates all the HIPAA (Health Insurance Portability and Accountability Act) transaction sets.
• Automated Web Service tests using HP Service Test.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Involved in end-to-end testing of FACETS Enrollment Claim Processing and Subscriber/Member module.
• Write many SQL queries in order to retrieve data/check data from different tables.
• Wrote test cases in Quality Center derived from the BRD and generated a Traceability Matrix for testing purposes.
• Responsible for Manual testing of both web and stand-alone applications (Agile/Scrum development)- majority testing: System Testing, Function Testing, Integration Testing.
• Tested SOAP request and response using SOAP UI.
• Wrote Complex SQL queries to validate the ETL Mappings.
• Performed Load testing for XML request-response using SOAP UI.
• Created Traceability Matrix to ensure implementation of all functionalities, identify all test conditions and test data needs.
• Tested the HIPPA EDI 834, 270/271, 276/277, 837/835 transactions according to test scenarios and verify the data on different modules.
• Involved in System testing, Regression Testing and User Acceptance Testing (UAT) manually and Automation tool.
• Tested the validity of the data cleaning done by the ETL by writing SQL and PL/SQL Scripts
• Experiences working in ANSI x12 837-835 EDI Transaction.
• Validate the date from EDI transaction.
• Managed defect tracking process, which include prioritize bugs, assign bugs and verifying bugs using QC.
• Execute test scripts by using different test check points, break points.
• Handling/Tracking defect in the Quality center and export in to Excel by using filter.

Environment: Agile, MS Office Tools, SOAP UI, Windows XP, ETL, Informatica, Mercury Quality Center, we services, MS SQL and UNIX.

Confidential, Augusta, GA

QA Analyst

Responsibilities:

• Reviewed the Business Requirement documents and the Technical Specification documents
• Developed Test Plans, Test Cases and Test Scripts to define scope of overall quality assurance testing
• Performed web application security vulnerability testing.
• Used parameterization to test the application for different kinds of data.
• Uncovered multiple issues related to the data population in the backend database manually.
• Conducted GUI Testing manually.
• Performed legacy DB2 Testing to cross check new database entity relations.
• Work in the Agile-development environment with frequently changing requirements and features set.
• Performed Security Testing manually using Positive and Negative Testing to ensure appropriate user authentication
• Worked on Soap UI to execute and test Real-time Transactions
• Tested and detected bugs in the front end of the application
• Performed UAT, Usability, Cross-Platform and Regression Testing during different stages of the application development.
• Developed Test Cases and scheduled Test Runs in Quality Center.
• Participated in various meetings and discussed Enhancement and Project Change Requests
• Coordinated with offshore teams on a daily basis to get the status updates.
• Performed negative testing heavily to encounter invalid unexpected values
• Actively participated in project enhancement meetings

Environmen t: Quick Test Professional, Quality Center, Internet explorer, Windows NT/2000, DB2, MS Office 2000