SUMMARY

• Over 9+ years of experience in Information Technology wif expertise in Software Quality Assurance, Data Warehouse, Web and Client/Server Applications.
• Strong noledge of all phases of SDLC (Software Development Life Cycle).
• Experience to apply standard coding conventions and rules established by teh American Medical Association (AMA) and teh Center for Medicare and Medicaid Services (CMS) for assignment of diagnostic and procedural codes CPT, HCPCS, ICD - 9, and modifiers.
• Experience wif healthcare systems focus on claims adjudication, provider and eligibility.
• Experience in working wif verification and validation of EDI transactions.
• Good noledge of Healthcare Member Enrollment, Benefits and claims processing.
• Worked on various EDI ANSI ASC X12 transaction sets (837P/me, 835, ...
• Knowledge of benefit coverage for all lines of business Medicare, Medicaid and commercial HMO POS and PPO plans.
• Good noledge of Data Warehousing Concepts.
• Experience wif FACETS Membership, Claims and Provider Data Models.
• Good understanding of data mapping and transformations in Informatica.
• Worked on ETL (Extract, Transform and Load) transformations such as Joiner, Aggregator, Router, Sorter etc using Informatica.
• Experience and ability to deliver quality Manual and Automated unit-tested solutions
• Skilled in writing SQL queries in Sybase and Oracle database.
• Knowledge of MS Access, Oracle, and SQL Server databases multi server Production environment
• Proficient in defect tracking and managing defect lifecycle.
• Good understanding of EDI 4010 version and 5010 version.
• Working noledge of ICD-9 and ICD-10.
• Experienced on Web Applications testing and data cross reference.
• Experience in internal testing Web service applications using SOAP and CURL.
• Knowledge to Perform different types of testing including on different type Mobile apps (iOS/Microsoft/ Android) and Web-based system using both manual testing and automated testing.
• Working noledge on automation on virtual machines QTP Automation environments.
• Quick Learner and strong desire to master new technologies in teh QA arena.
• Extensive experience in testing and implanting Extraction, Transformation, and Loading (ETL) of data from multiple sources into Data warehouse using Informatica.
• Responsible for testing data migration from legacy system to .Net application. Testing was achieved on V- Cloud environment.
• Working experience to developed test cases in Quality Center.
• Maintaining automated test framework, plans, scripts and reporting.
• Experienced in performing different types of testing: Functional Testing, System Integration, Regression, Smoke, User Acceptance Testing and Performance Testing.
• Expertise in bugs tracking and reporting them using ClearQuest, BugZilla etc.
• Accomplished experience in writing and executing SQL queries.

TECHNICAL SKILLS

Testing Tools: Rational Clear Quest, Quality Center 8.0 & 9.2 9.5, Test Director Track Record, Win runner,BI ETL

Software: Informatica 8.6.1 Power center, Business Objects5.1x, 6.5, XI, Oracle SQL Version Control

Tools: PVCS, Rational Clear Case, Visual Source Safe

Databases: SQL Server 2000 and 7.0, Oracle 7.x/8.x, Access and Sybase

Languages: Java, VBScript, HTML, SQL, PL/SQL, XML.

Operating Systems: Windows ... UNIX.

PROFESSIONAL EXPERIENCE

Sr. EDI/QA Analyst

Confidential, Austin, TX

Responsibilities:

• Develop test plans, and perform system testing, integration testing and regression testing;
• Create, submit and validate all types of EDI transactions sets (270/ 271, 276/ 277, 834,837/835) for submission of Medicaid claims to TMHP;
• Perform Web based testing of business functionality;
• Participate in teh identification and reporting of risks and development of mitigation plans;
• Write and analyze ADHOC C reports and SQL queries, research data quality;
• Lead teh test team through testing up through UAT;
• Participate in every-day standup meeting as part of Agile methodology;
• Work closely wif business owners and SMEs to understand functional aspects of services and identification of system requirements for use case development and testing;
• Involved in testing Web Services using SOA, SOAP UI, REST and Custom Based Approach
• Used queries to validate teh user preferences data updated in backend databases using SOAP web service requests responses in XML format to/from legacy backend systems.
• Coordinate activities wif overall development team, administer teh testing problem management process including monitoring and reporting on problem resolutions;
• Provide level of effort, test environment requirements, resource/skills and test schedules for various projects;
• Identify needs and recommend changes to established policies and practices related to testing;
• Participate in gap analysis for ICD-10 and evaluate teh impacts on teh CMBHS system;
• Acquire in-depth noledge of teh following CMBHS and MMIS functional areas - provider list, prior authorization, and claims;
• Work as teh lead for YES Waiver/Medicaid and Substance Abuse Services Claims functional area related to Edits & Audits, and Front End, Back End.
• Maintained schedules and coordinated activities for teh CMBHS testing team.

Environment: Microsoft Management studio 2005/2008, Oracle 9i, MS Sql server 2005/2008, DB2/IMS tools, Visio, SQL Server, ER Studio, Magic, Ultra Edit, Win merge, foresight HIPAA validator 7.3, Attachmate - extra x-treme 5.1, Tumbleweed, .Net, Biztalk - 2002 and 2006, MQ Series, SOAP

Sr. QA Test Analyst

Confidential - Midlothian, TX

Responsibilities:

• Validated all HIPAA Transactions 837, 834 and 835 in both 4010 and 5010 versions by processing teh files per defined rules and custom logic.
• Involved in Claim processing from End to End and major work was involved wif 837 P/me claims processing systems and 834 benefit enrollment.
• Reviewed and analyzed teh functional requirements for teh 5010 conversion
• Created Base Files for 5010 Transactions using Felix and mocked up data to create Test files based on test scenarios and conditions.
• Involved in designing discussions, developing test plans, test schedules and test strategy documents.
• Created Test Cases according to 5010 Business requirements and documented teh test procedure and results.
• Performed regression testing to validate multiple component behaviors wif new version of 5010.
• Extensively used Informatica for ETL testing using various transformations like router, sorter, aggregator, expression depending upon teh logic embedded in teh mapping document.
• Involved in data validation for Web application by cross checking wif teh source of data.
• Performed functional testing along wif look and feel of teh application
• Demonstrated teh usability of teh web application to users for User Acceptance Testing (UAT)
• Used SQL statements for Back-end testing to ensure teh autantic retrieval of teh data from teh database.
• Reported teh defects using IBM Rational Clear Quest for all project handled and participated in bug resolution meetings when needed.

Environment: EDI X12N 4010, EDI X12N 5010, Facets 4.71, Informatica Powercenter 9.0.1, .Net, Windows XP, MS Outlook, IBM Rational Clear Quest. Sybase, Oracle, Toad

QA Test Analyst

Confidential - New York, NY

Responsibilities:

• Participated in business requirements reviews and software system (application) designs for testability.
• Developed High Level Test Cases based on teh Functional Design Specifications and Business Requirement Document (BRD).
• Developed detailed test cases in Quality Center.
• Executed test scripts/cases per requirements.
• Logged defects and followed teh life cycle of defects.
• Created and generated various test reports and defect reports.
• Involved in Data Quality/ETL testing efforts in accordance to a common test approach for ETL and data integration engagements.
• Involved in validating Data Extracts produced using Informatica
• Tested teh Informatica mappings and workflows by using Informatica Designer and workflow manger.
• Performed Smoke test, System test, Functional, Integration, End to End, User Acceptance testing and Regression testing activities in Test environment and Production support environment.
• Executed teh regression test cases along wif testing new enhancements by using QTP and analyzed results.
• Maintained Traceability Matrix to track teh requirements to teh test cases to ensure complete test coverage in teh Quality Center.
• Coordinated teh Onsite and Offshore teams to resolve issues.
• Involved in production support activities wif Installation and Configuration of Informatica Power Center 8.6

Environment: Oracle, ETL, Informatica, QC, Win Runner, SQL Developer, .Net, MS office 2007, Windows XP, UNIX.

QA Test Analyst

Confidential - Warren, MI

Responsibilities:

• Involved in creating test plan, schedule and test case based on teh analysis provided from business requirements and functional documents
• Prepared and executed test scripts for various modules like reports, extracts and other interface components.
• Worked wif third part vendor on testing specific components.
• Involved in development of test plan, test schedules, test cases based on high-level and detailed designs for individual components like reports, data extracts, secondary database and other components.
• Prepared teh 837P/me EDI Claims and validated these in Facets 4.4.1 claim adjudication process.
• Involved in testing HIPAA EDI Transactions and mainly focused on 276/277, 278, 270/271, 837 and 835
• Involved in writing and testing SQL queries to cross check teh data between Facets 4.41 and Legacy system.
• Validated teh processes and custom logic processing various ANSI X12(4010) EDI files.
• Involved in testing various healthcare applications and migration of plans from legacy system to FACETS application.
• Executed test cases and participated actively in System testing and Regression testing.
• Interacted wif Business teams and Developers to understand business requirements and bug fixes.
• Documented teh Daily Defect Status wif teh help of defect tracking tool.
• Responsible for defect tracking and management metrics, defects are logged and change requests are submitted using Rational clear quest.
• Participated in status meetings to report issues
• Communicated wif developers through all phases of testing to prioritize bug resolution.

Environment: Facets 4.41, Oracle, Rational clear Quest, MS Excel, MS windows, UNIX

QA Test Analyst

Confidential - Dallas, TX

Responsibilities:

• Documented Test plan, Test strategies, and involved in preparing Test data.
• Actively involved in developing test cases and coordinating functional and user acceptance testing.
• 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.
• Used SQL to extract data from Reporting database to cross check reports.
• Created Test cases and Test scripts for Unit testing, System Integration Testing, and Regression testing as per teh Business Requirements
• Created several Test Cases and Test Conditions for testing various Claims, Membership, Billing and Provider reports.
• Utilized Mercury Test Director for Defect Management and created reports for status meetings.
• Performed User Acceptance Testing (UAT) of teh application by creating and running demo versions of teh application wif teh prospective users.
• Created and maintained templates such as: Quality Strategy, Test Plans, Requirements Traceability Matrix, Testing Issues, Project Sign-off and Test Reports.
• Attended defect resolution meetings wif teh development teams & worked towards bug resolution Environment: SQL server 2005, SQL, Java, XML, MS Office.

QA Test Analyst

Confidential - Houston, TX

Responsibilities:

• Analyzed source data and reviewed teh requirements from teh business users.
• Study and analysis of teh mapping document indicating teh source tables, columns, data types, Transformations required, business rules to be applied, target tables, columns and data types
• Worked wif different sources such as relational databases (RDBMS), flat files for extraction using Source Qualifier and Joiner.
• Worked on various transformations like Router, Sorter, Aggregator, and Expression.
• Executed Workflows in teh Workflow Manager to run wif teh logic embedded in teh mappings using Power center Designer.
• Used Workflow Monitor for monitoring teh workflows and sessions and did debugging using work flow log and session's log.
• Performed backend database testing by writing SQL statements to verify teh data integrity.
• Reported bugs and tracked defects using IBM Rational Clear Quest.

Environment: Informatica Power center, Oracle, SQL, IBM Rational Clear Quest, Windows XP.