SUMMARY

• 7+ years of experience in Software Quality Assurance Analyst and knowledge of Facets in Healthcare domain.
• Strong working exposure in AGILE, SCRUM and Waterfall SDLC methodologies.
• Proficient in analyzing and creating User Stories and Story Boards.
• Knowledge on HIPAA Compliance EDI Transaction Sets 834, 837 and Good understanding of the EDI transaction sets 834, 837.
• Excellent analytical skills for understanding the business requirements, business rules, business process and detailed design of the application.
• Experienced on Web Services to combine component - based development and internet standards and protocols that include HTTP, XML, SOAP and Web Services description language
• Strong data analysis skills including SAS and SQL queries statement.
• Extensive experience in Backend Testing on distributed databases using SQL queries.
• Developed and executed overall UAT testing process including coordination between UAT, business, and technology.
• Created/ Tuned PL/SQL Procedures, SQL queries for Data Validation for ETL Process.
• Experience in conducting GAP analysis, User Acceptance Testing (UAT). Successful as a team player to work in conjunction with other DBA’s, testers, developers and other team members in validation and testing complex scenarios and projects and in the maintenance of Quality Standards in Projects.
• Knowledge of existing automation frameworks like Page Object Model, Data Driven Framework and Hybrid Framework.
• Analyzed the FACETS Requirements and conducted gap analysis.
• Extensive experience in writing Business requirements documents, test strategy, test plans, test cases, test execution, Risk assessment, and test matrix for upper management, test environment setup, bug reports, & traceability matrix for web based application.
• Familiarity with numerous data warehousing concepts like pivoting, data slicing/dicing, data cleaning/scrubbing, metadata, data mart, fact table, dimension table, star schema, snowflake schema, fact less fact table, etc.
• Worked closely on 834 transaction code for Benefit Enrollment and was involved in Validation of HIPAA.
• Healthcare system implementation including enterprise Electronic Medical Records EMR software.
• Used Facets support systems to enable inbound/outbound HIPAA EDI transaction in support of HIPAA 834, 835, 837 270/271 transactions.
• In depth knowledge of Medicare/Medicaid Claims processes.
• Maintaining knowledge of Medicare and Medicaid rules and regulations pertaining to the Facets and evaluating the impact of proposed changes in rules and regulations.
• Strong understanding of project life cycle and SDLC methodologies Waterfall and Agile.
• Prepare daily, weekly and release wise automation execution status report of Merlin teller application and communicate to Client and senior management.

TECHNICAL SKILLS

Testing Tool: HP UFT/Quick Test Professional

MS Word: Excel, ALM, SQL, SharePoint

Bug Reporting Tools: Test Director, Quality Center/ALM, JIRA

Statistical Software: SAS, SPSS, Advanced Excel with Pivot tables and V-Lookup

Databases: Oracle, MS Access, MS SQL Server

Operating Systems: UNIX, Windows

Scripting Language: VBScript, Basics of JAVA for Selenium, Basics of Python Programming, JavaScript

Other: MS Office Suite- Word, MS Visio, MS Project, SDLC, Eclipse, Maven, Confluence

PROFESSIONAL EXPERIENCE

Confidential - Bloomfield, CT

Facets/ QA Tester

Responsibilities:

• Worked as a business user acceptance data validation analyst for Confidential Pharmacy to ensure Claims and Cost share set up for different clients and members are accurate, thus supporting the organization’s customer centric goal of delivering the highest quality.
• Ensured compliance of customer EDI x12 and EDIFACT requirements.
• Used SSIS for extraction, loading and transformation (ETL) of data.
• Worked with Rally - AGILE Scrum Master Requirement Management tool in a fast-paced environment to test the User Stories developed by the Business Users.
• Develop Scripts for the new enhancements using existing Keyword Driven Framework.
• Identified software defects and interacted with developers to resolve them and provided full support to the Test team using Quality center/ALM.
• Proposed multiple ETL design pattern to load parent child dimension, custom SCD 2 load, historical data and ongoing data load.
• Worked with DBAs to recreate a best fit physical data model from the logical data model.
• Write SQL queries, analyze the data, and perform data migration processes.
• Reviewed Software and Functional Specification documents for Test Planning.
• Duties as Sections SME included reporting, automated testing, manual testing, remediation and work with in-house development team on projects to ensure Sections compliancy from the beginning of the life cycle until deployment.
• Preparation of automation Scripts from existing test cases by implementing Modular Framework (Driver - Reusable/Function driven framework).
• Tested the HIPPA EDI, 834, 270/271, 276/277, 837/835 transactions according to test scenarios and verify the data on different modules.
• Performed Black Box testing and conducted Functionality and Regression testing on various phases of the Management software.
• Participates in release planning, sprint planning, daily scrum and retrospective in an Agile Scrum environment.
• Generates defect reports, attends defect meeting and follow-ups on log defects.
• Participated in the Quality business calls to understand on the data validation for Transactional testing and End to End testing.
• Performed Web Services testing and Validated XML request/response data using SOAP UI.
• Developed and implemented EDI applications to process Health Care transactions as per the HIPAA implementation.
• Closely worked with business to perform UAT validations using SDLC methodology
• Prepared and executed different SQL Queries against the Oracle and Sybase Database.
• Validating the data from different sources application and document.
• Formulated detailed Test Plan using Quality Center/ALM after analyzing business rationale and software requirements
• Used Quality Center/ALM to create and maintain test requirements

Confidential, Quincy MA

Facets Tester

Responsibilities:

• Developed Test Cases/Conditions for manual testing of the Applications and Reports.
• Create User Story, Test Steps and Test Execution for Performing Testing and analyze.
• Involved in performing functional, application, integration, system, and regression Testing
• Gathered requirements from the users and analyzed the requirements.
• Performed statistical analysis of data and reported on a periodic basis.
• Tested EDI X12 transactions 837 (Claim for Institutional, Professional and Dental Claims), 835 (Claim Payment), 276-277 (Claim status), 834 (Enrollment), 270/271 (Member eligibility).
• Develop and automate Web Services API testing using SoapUI. Inspected and worked on HTTP web services application and on SOAP APIs.
• Designed and Developed ETL Mappings to extract data from SQL, Flat files, and Oracle to load the data into the target database.
• Development of source Data profiling and analysis - review of data content and metadata.
• Arranged walkthroughs and interviews with the Subject Matter Experts (SMEs) and other stakeholders to keep track of user requirements and thus modifying business goals when necessary Also recorded the requirements in a format that could be easily understood by both the business and the technical groups.
• Prepared and executed different SQL Queries against the Oracle and Sybase Database.
• Gathered requirements from the users and analyzed the requirements.
• Transferred data into meaningful, professional and easy to understand formats like BI reports and dashboards for various audiences using MS Power BI and Excel.
• Worked with DBAs to recreate a best fit physical data model from the logical data model.
• Participated in Agile SDLC using the Scrum process.
• Developed data quality test plans, visualized, executed and communicated ETL and BI test cases in Tableau.
• Worked on generating ad hoc reports, tables and graphs for presentations and data modeling using SAS Web Report Studio.
• Assisted Project Manager in developing Test Plan and communicated with Project managers and supervisors to provide the best test strategy as per Agile Testing Life Cycle
• Conducted Back-End Testing Using SQL Commands.
• Involved in testing Web services/ APIs and XML with SOAP UI.
• Write SQL queries, analyze the data, and perform data migration processes
• Responsible for Performing Integration Testing, UAT testing.
• Extracted raw data from an Oracle database and used SAS/Access to read it and run statistical analysis using SAS/Stat.
• Performed Test execution and wrote and executed Test scenarios /Test Scripts
• Logged the errors, reported defects, determined repair priorities and tracked the defects until resolution using JIRA.
• Executed Test cases for Claims and Customer Service Workflow by manually.
• Extensively participate in weekly status meeting with Test Team to discuss the current and future issues for testing plan as well as testing procedures

Confidential

QA Analyst

Responsibilities:

• As a functional QA Tester identified approaches and conducted detailed analysis to satisfy county business requirements based on their policies and procedure manuals for programs such as SNAP, TANF, Cash Assistance and Medicaid.
• Extensively used ETL Processes to load data from various source systems such as SQL Server, Flat Files and XML Files into target system by applying business logic on transformation mapping for inserting and updating records when loaded.
• Conducted Load testing to generate the load on the server by creating Database User scripts
• Responsible for coordinating and performing System Integration, functional and data-related testing.
• Developed, executed and documented highly complex test plans and test cases for business-related application running on multi-tiered platforms.
• Developed an implementation guide for EDI x12 transactions such as 834,835,837,270 and 271 in the current claims processing system in accordance with HIPAA regulation.
• Worked closely with Child Care Administration Department to gain knowledge of procedures and laws.
• Involved in implementing the new eligibility systems (COTS System) and identifying the GAP on gathered requirement documents and heavily involved with the third-party integrator.
• Executed test cases manually to verify the expected results.
• Created automation frameworks (hybrid, keyword, and data-driven).
• Extracted data from existing data stores, Developing and executing departmental reports for performance and response purposes by using oracle SQL, SAS, procedures, packages, functions, database triggers.
• Created UAT Plan, UAT cases and UAT scripts along with different test scenarios and creation of expected test results traceable to SRS.
• Involved in Configuration testing.
• Updated defects report to expedite the system test process time.
• Participated in Agile SDLC using the Scrum process.
• Gather requirements of various interfaces like Wage Match, New Hires, Death Match, State Hospital admit and discharge, SNAP TANF and Medicaid Benefit Issuance.
• Tested, wrote, and reported on VA Web Portal and other web based projects for Sections compliance as SME on project while working with vendors to remediate coding and projects for Sections compliancy.
• Wrote several complex SQL queries for validating and verifying the data in Oracle.
• Involved in processing claims and validated the full payment cycle process until it generates EDI 835’s and EOP’s.
• Involved in the impact analysis, scope lockdown, and requirements gathering phases of the company’s transition and development phase management of transition of HIPAA.
• Functional Specification, Data Warehouse Process Flow (SQL queries) using MS Office (Word, Excel, Visio) and dashboards.
• Performed the data driven test by pumping different sets of data.

Confidential - Dublin, OH

QA Analyst

Responsibilities:

• Prepared Test Plans for each release, written Test Cases and executed them as part of Functional Testing.
• Analyzed and test configuration changes in FACETS
• Performed Black Box testing and conducted Functionality and Regression testing on various phases of the Management software.
• Support UAT testing and created defect guidelines documents for users using MTM.
• Performed User Acceptance Testing (UAT) & Regression testing.
• Gained Knowledge of EDI transaction code sets including 270 /271, 276/277, 834, 835, 837.
• Reviewed Software and Functional Specification documents for Test Planning.
• Worked with medical Payment/billing system which kept track of various payment and bills issued to authorized medical care providers.
• Involved in testing of Facets Implementation, Tested end to end testing of FACETS Membership and benefits module.
• Responsible on creating user stories in an Agile Scrum framework in scratch.
• Work in the Agile testing environment with frequently changing requirements and features set.
• Executed SQL queries to validate the backend data using SQL Developer.
• Generated the test defects report and reported it to the development team for Bug fixing through Microsoft Test manager (MTM)
• Performed Testing on Web Services, SOAP and Rest API Testing using data transfer and SoapUI.
• Developed and executed test cases for XML/SOAP services using SOAPUI tool.
• Involved in setting up different configuration environment for compatibility testing and manual testing.
• Upgraded the existing Test Scripts and created new scripts for client application to be able to work for new versions and patches, which improved product quality.
• Worked effectively on Member/Subscriber Benefit in Facets and functionality of new features, new enrollment, enhancements and Data validation in Facet
• Created SQL Queries using Oracle, SQL Server and DB2 in validating data into Data Warehouse applications.
• Involve in preparing Trace Matrix to design test cases