PROFESSIONAL SUMMARY:

• Over 10 years of experience in the field of IT with focus on QA and strong knowledge of major domains like Healthcare, Reporting Services and BFSI.
• 7 years of experience on Healthcare domain. Good knowledge on Claims, Providers, Membership, Case Management, EDI transactions, Medicaid & Medicare plans
• 4+ years of extensive experience in End to End Encounter management system - NEMIS (Proprietary) and Extracts from FACETS to NEMIS
• 3 years of experience on Banking Domain and Reporting Services.
• Strong experience on business intelligence products.
• Proven Experience in Web service testing using REST API
• Hands on experience in SOA tools like SOAP UI 3.5.0, HP Service Test, POSTMAN
• Extensive experience in FACETS application on all the major modules -Enrollment, Providers, and Claims.
• Strong experinece with UNIX commands.
• Good experience on different EDI transactions like 834 for enrollment, 837 for claims.
• Worked on Pharmacy migration from Medco to OptumRx as the primary Pharmacy Benefit Manager (PBM).
• Worked on different vendor files like Pharmacy, Dental & Vision in loading and Submitting to state and validating the NCPDP responses.
• Experienced in Agile Methodologies.
• Developed Test Cases for Deployment Verification, ETL Data Validation, Report testing.
• Extensive experience on UHG Proprietary Mainframe claim processing engines - COMET, TOPS, Claims highway (CHWY) and have a good expertise on all the major modules.
• Good Knowledge in SQL and Database Management systems - Sybase, PL/SQL & Oracle.
• Experience in Functionality testing, Database Testing, GUI testing, Mainframe Testing, Ad-hoc testing, Regression testing, E2E testing and Automation testing using HP Unified Functional Testing (UFT/QTP), Mercury Quality Center/ALM and JIRA.
• Extensive experience in reviewing Business Requirement Documents, Software Requirement Documents and preparing Test Estimations, Test plan, Test Cases, Test scripts and Execution.
• Experience of different roles Onsite Coordinator, Independent Contributor, Leading the projects and SME (Subject Mater Expert)
• Worked on test case optimization using the in-house tool OATS(orthogonal array testing).
• Proven ability to meet agreed deadlines, co-ordinate work to defined testing methodologies within a structured environment.

• Working as Onsite Test Coordinator with Confidential
• Worked as Test Engineer with Confidential
• Worked as Test Engineer with Confidential

SKILL SET:

Domains: Health Care, Banking & Reporting Services

Operating Systems: Mainframes z/OS, UNIX, Windows 2K/XP/2007

Claim Processing Systems: FACETS, TOPS, COMET, UTR, STBK, CES/CDB, NDB

Web Apps: Web Services (Soap UI 3.0.1, Web service Utility 2.0)

Automation Tools: UFT, Selenium

Test Management Tools: Quality Center/Test Director, ALM

Languages: JAVA, C, HTML, SQL

RDBMS: Oracle, MS SQL Server, DB2, Sybase, Pl/Sql

Tools: TOAD, IBM DB2 Command Editor, SPUFI, Query Analyzer, Putty, Harvest, SVN.

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix, AZ

IT Quality Analyst/Onsite coordinator

• Lead team from onshore.
• Conduct daily status calls for tracking project to successful closure.
• Loaded the different vendor claims & provider files (vision, pharmacy, dental) and validated the database as per the requirement.
• Designed and implemented HIVE queries to validate data integrity.
• Proactively identify issues / risk and work with team for resolution.
• Involved in End to End encounter processing of various encounter file types such as 837 (I/P/D), NCPDP and Proprietary file types for submission to State health systems.
• Involved in loading Various Response files from state including but not limited to 835, 277, 999, NCPDP, State's Proprietary formats.
• Worked on Automation script for regression testing.
• Generated the 837 files and done validations as per the state requirements for both Medicaid and Medicare data.

Confidential

Test Engineer

 RESPONSIBILITIES:

• Worked on NDB to CSP feed successfully for the state as per the requirement.
• Processed the provider outbound file from FACETS to Auxdb and validated as per the requirements.
• Loaded the different vendor provider files (vision, pharmacy, dental) and validated the database as per the requirement.
• Created scenarios and executed test cases to test the outbound extract file from different vendors (OptumRx) which involves batch processing and validating the resultant data.
• Involved in testing of EDI transactions 834 daily/monthly inbound files loading.
• Worked on PRA (Provider paper remittance advice) which involves test case creation, test data preparation, PRA extract file validations on different scenarios like Up and Down adjustments.
• Worked on Enrollment (ID cards) generated the extract file as per the state requirement and validated.
• Worked on claims processing through EDI 837 transactions and validated the data in facets and in the backend.
• Worked on Enrollment processing of 834 file.
• Worked on OptumRx vendor file loading and validation as per the mapping.
• Performed database testing by passing the SQL queries to retrieve data from the Database.
• Reviewed before and after deployment sql scripts and encounter validations in the backend PL/SQL.
• Run through the insert/delete/update scripts as part of QA validations.
• Utilized the Excellent communication, presentation and interpersonal skills during the different phases of the project.
• Expertise in analyzing system and functional specifications, business Requirements.
• Involved in developing and maintaining Traceability Matrix.
• Expertise in problem solving and defect tracking using ALM.
• Participated in setting up testing environment.
• Conducted result analysis and interacted with developers to resolve bugs.
• Participated in the project meetings and walkthroughs.
• Was highly efficient in handling the team and in coordinating with offshore counterpart.

Confidential

Test Engineer

Responsibilites:

• Performing Integration Testing, Database Testing, Regression Testing, System Testing.
• Worked on members, claims modules.
• As part of claims highways worked on pharmacy claims, different exits (member, claim & provider)
• Done validations in DB2 as part of mainframes testing.
• Used OATS for test case optimization.
• Executed the automation test scripts for regression test bed.
• Responsible for reporting defects in Quality Center and verified fixed defects against new builds. Tracking and reporting also followed up with development team to verify defect fixes, and update defect status.
• Participating in the meetings with the business users in the requirement gathering phase.
• Participating in the releases to perform a post release testing on the applications, and coordinating the updates to the business users.

 Confidential

Test Engineer

Responsibilites:

• Analyzing the detail and formulating Test Plans and Test Scenarios for functional testing
• Created the reports by writing the sql and using reporting tool as per the business needs.
• Scheduled the reports for the stake meeting and publications on the board meetings.
• Generated the dashboards for the customers.
• Participating in the meetings with the business users in the requirement gathering phase
• Prepared and executed test cases as per schedule.
• Involved in database testing as part of reporting services.
• Created reports for different business requirements using our reporting tool.
• Involved in problem solving by checking already designed reports on-site.
• Worked at customer site to understand them the usage of tool and the maintenance support.
• Worked on banking domain, done validations on transfer module, beneficiary module.
• Performed validations on the microfinance Kiosk and created cards and activation of cards, money transfers.
• Performing Unit Testing, Integration Testing, Database Testing, Regression Testing, System Testing and User Acceptance Testing
• Defect Reporting & Defect Tracking using QC, Bugzilla.
• Worked in a distributed team environments in different locations