SUMMARY:

• Over 6+ years Sr. QA Analyst and Quality assurance of Testing Client/server application using Microsoft SQL Server and BI suite Development, UAT and Production Environment)
• Proficient experience in Manual and Automated Testing of GUI and functional aspects of the Client - Server and Web based Applications on multiple levels of SDLC and Testing Life Cycle (STLC)
• Knowledge in the ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).
• Extensive experience in writing SQL and PL/SQL scripts to validate the database systems and for backend database testing.
• Having expert level experience with Functional testing in Functional System Integration testing, User Acceptance Testing, End to End Test Management, Running Automation scripts in Regression Suites and Non - functional security testing areas. Hands on experience in Project change control mechanisms, Impact Analysis, Risk Analysis, Defect Management, End to End Testing and Production issues/defects ad-hoc and regression Testing & support Having expert level experience with Functional testing in Functional System Integration testing, User Acceptance Testing, End to End Test Management.
• Performed Testing Life Cycle during the various phases of the application. Involved in converting manual test cases into automated scripts using TSL on Mercury Win runner, QTP.
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, MS Excel, MS Access, MS Visio, technical assessment tools, MicroStrategy Data Warehouse Data Modeling and Design.
• Excellent experience on Teradata SQL queries, Teradata Indexes, Utilities such as Mload, Tpump, Fast load and Fast Export
• Ability to deliver comprehensive Business Intelligence through integration of BI suite of products (SSIS, SSAS, SSRS) including MS solutions like MS EXCEL 2007/2010, Microsoft Office
• Developed Test cases for manual testing and automated them using Win Runner, Silk, Load Runner, Silk performer and QTP.
• Strong in manual testing, Automated testing in Visual Basic & other protocol of automation tools Experience in testing applications under. Net, Windows.

EXPERIENCE:

Confidential, Buffalo, New York

Sr.QA Analyst

Responsibilities:

• Well-versed with leading industry tools like Jira, Version1, Caliber, MS Visio, MS Word, MS Excel and MS PowerPoint to develop various project deliverables
• Worked with 837, UB92, UB04, CMS 1500 claims and HIPAA 835, 270/271, 276/277, 278 transactions.
• Performed Requirement Analysis and developed UML Use Cases, Activity Diagrams using Rational Rose to understand the requirements.
• Worked closely on 834 transaction code for Benefit Enrollment and was involved in Validation of HIPAA for 837, 270/271, 276/277, 835, 834 EDI transactions.
• Performed testing for Medicare, Medicaid and X-Over claims for Medicaid Management Information System (MMIS)
• Experience with healthcare system, Medicaid and with prime focus on claims adjudication, provider, eligibility and prior authorization.
• Experience in Claims Processing, claim encounters and Claims Scrubbing in HMO, PPO, Medicaid and Medicare
• Process and data flow models for STD (Short Term Disability) (Long Term) and FMLA claims processes as well as interfaces to Human Resources.
• In-depth knowledge and experience in full SDLC with Agile/SCRUM and waterfall methodologies.
• Facilitate all agile ceremonies including daily stand-ups, weekly grooming, retrospective, and review and planning session.
• Performed workflow analysis toward automated disability claims process. Detailed comparison of two competing proposals, including HR interfaces. Facilitated requirements definition for new system.
• Introduced Agile to the product team and organized releases into SCRUM sprints, incorporated elements of XP
• Experience with Medicare, Medicaid and commercial insurances in HIPAA, ANSI, X12 formats including 270/271, 276,277, 278, 835, 837, 997.
• Utilized Microsoft Team Foundation Server TFS to manage the team's software development lifecycle including deriving product backlog items, assigning sprint work items to developers and conducting sprint review meetings
• Followed the Rational Unified Process (RUP), Agile methodology and Extreme Programming concepts for project development. Analyzed and incorporated User Stories in different release plans for the sprints in Scrum process.
• Ability to analyze engineering product support issues described within a bug-tracking system (JIRA) and provide guidance to other Client Services members in an advisory capacity, focusing on the quick resolution of the production issue and using this as a opportunity for other team members
• Involved in processing claims in FACETS and validating the full cycle process to make sure the checks are generated and 835's are generated.
• Re-engineering and capturing of EDI transactions with legacy systems Enrollment -834, Eligibility Transaction (270/271), Claims (837), Claim Status Request and Response (276/277), Remittance (835) .
• Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Used Facets 4.71 to receive, store and send HIPAA-standard transactions (835, 837, 270, 271, 276, 277) and to administer HIPAA privacy rights.
• Ability to analyze engineering product support issues described within a bug-tracking system (JIRA) and provide guidance to other Client Services members in an advisory capacity, focusing on the quick resolution of the production issue and using this as a opportunity for other team members
• Involved with all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle.

Confidential, NJ

QA Analyst

Responsibilities:

• Manual testing of both web and stand-alone applications (Agile/Scrum development)- majority testing: System Testing, Function Testing, Integration Testing.
• Utilize data-driven and compartmentalized test automation practices using Mercury Interactive Test Suite and Compuware Products.
• Prepared Test Plans, Test Scripts and Test Cases based on functional specifications and user requirements.
• Involved in preparing test cases, test scripts based on use cases and BRD documents under Agile environment.
• Involved in understanding the Requirements of the end Users/Business Analysts and Developed Test Strategies.
• Developed Test Plans, Test Cases and Test Scripts, Test data, Test Summary documents on SharePoint for project team.
• Managed, Documented and Controlled all the Test Cases, Test Scripts and Test Results using Microsoft Visual Studio Team Foundation Server TFS.
• Documented the UAT Plan for the project and worked with the UAT Team to ensure every acceptance criterion for the requirements has been included in the UAT task plan.
• Designed and created XML based schemas to map EDI transactions and tested the same in Pipeline environment.
• Analyzed HIPAA 5010 standards for 837P, I, D EDI X12 transactions, Remittance files (835,999,277,277CA), related to providers, payers, subscribers and other related entities. This task is done with the help of Companion Guide Transaction Information and mapping document from CMS per state.
• Validated the EDI 837 Interchange header for the claim Type for Institutional or professional, and validated the Group Segment loop for Member and provider information and Different SNIP validations to validate the HIPPA regulation.
• Performed analysis on the Affordable Care Act (ACA) law & corresponding Centers for Medicare and Medicaid Services (CMS) and Health Insurance Exchange (HIX) business requirements.
• Analyzed EDI ANSI X12 file mapping and reported in analysis spreadsheet. Performed validation of 837 (P, I, D) & 835 format files according to the EDIFECS engine.
• Tested the claims processing and Adjudication (EDI 837I, 837P, 837D& EDI 835).
• Responsible for the completion of projects within specified time and budget dealing with financials, project workflow, change management and dealing with vendor relationships.
• Tested HIPAA regulations in Facets HIPAA privacy module.
• Facilitated JAD session to find out the impacted area of functionality of Facets due to upgrade and cooperate with developer to come up with solution.
• Communicate with vendor to regarding new updates on Facets and solution to their existing system
• Used FACETS Analytics for fast and easy retrieval, display and grouping of information for performing queries and generating reports.
• Tested the changes for the front-end screens in FACETS related to following modules, test the FACETS batches (, Billing, Provider, etc).
• Testing ETL process (SSIS packages) used to load the raw data from source.
• Performed Back-end database testing by executing advanced SQL Queries to make sure that Enterprise Data Warehouse (EDW) is working fine.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Wrote extensive SQL queries to validate conversion of data from the source warehouse tables to target tables.
• Performed complex defect reports in various environments like UAT, SIT, and QA etc to ensure the proper delivery of the application into the production environment.
• Authored test plans, test cases for various test scenarios and helped testing team to better understand the test scripts.
• Executed Test Cases Manually, once the application is stable and documented the successful or unsuccessful completion of each test case in HP Quality Center (QC) for End-to-End Scenario based testing.

Confidential, Miami, FL

QA Analyst / Tester

Responsibilities:

• Used Quality Center for storing test cases and QTP scripts, also used Team Track for defect tracking and reporting purpose.
• Analyzed research on operational procedures and recommend changes for improvement with an emphasis on automation and efficiency.
• Performing quality assurance functions covering the full software development life cycle, including development and implementation of test plans, test infrastructure and project plans.
• Conducted overall quality assurance responsibilities including writing test plans, detailed test cases, test scripts, and test automation development, test execution, defect reporting and tracking, full documentation, and supervision.
• Wrote Test Plans in MS Word for Manual Testing, System Testing, Integration Testing, Performance Testing, Regression Testing & reviewed their consistency with the business requirements.
• Involved in User acceptance testing, System integration testing (SIT), Negative testing, Smoke testing, Unit testing, Functional testing, System testing and Regression testing.
• Tested Request and response XML’s based web services interfaces using SoapUI.
• Validated various transformations of SSIS data flow and control flow.
• Created Batch processes using BTEQ, UNIX and Teradata SQL to transfer, cleanup and summarize data.
• Developed test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on ETL mapping document.
• Wrote SQL queries for validation of ETL Reports from Source to Target system.
• Extensively used SSIS transformations such as lookup, merge, derived column, data conversion and aggregate etc.
• Preparation of various test documents for ETL process in Quality Center.
• Worked with SSIS system variable, passing variables between packages.
• Performed a wide range of QA duties in an Agile (Scrum) development environment.
• Established & monitored the processes for Change Management, issue tracking and Quality Management.
• Authored and executed Test cases for Integration/UAT and performed end-to-end testing.
• Execute test cases across multiple platforms and builds in an agile environment.
• Documented the Integration/UAT test plan and results and submitted for sign-off from Stakeholders.
• Reviewed and tested report defects in the concerned applications in both UAT and Production testing environments.
• Involved in Weekly Testing Status meetings with Testing Team and Weekly Rate Quote Task force meeting with Business Users and Developers.
• Analyzed user change requirements, and made necessary amendments to the test requirements.
• Review requirements and understand technical recommendations and constraints, and develop comprehensive and accurate functional specifications; Data Mapping, and process flows.
• Work with Compliance and Regulatory operations to follow and monitor different IT process bound by CMS Regulations.

Confidential, Conway, AR

Quality Analyst

Responsibilities:

• Prepared Test plans which includes an introduction, various test strategies, test schedules, QA teams role, test deliverables, etc.
• Expertise in performing Bug and Defect management using bug-tracking tools like JIRA and HP QC/ALM.
• Used JIRA to perform test management activities.
• Used JIRA tool to track and maintain different versions of the project documentation.
• Strong knowledge of working on JIRA and Tableau.
• Tested the enhanced FACETS, evaluated claims adjudication needs and created HIPAA-compliant business rule configurations.
• Tested the claims processing with EDI transactions (270, 271, 835, and 837) in HIPPA Environment.
• Performed Functional, Regression, and system testing of various Facets modules involved in claims processing, members and providers.
• Involved in testing HIPAA Transactions & Code Sets Standards like 834-Enrollment to a health plan, 837-Claim and 835 payment and Remittances.
• Involved in validation of ANSI X12 5010 for 837 and 835 claims used for Professional, Institutional and Rx Claims by Writing Test cases, Test Plans.
• Performed System testing and UAT testing of the Facets core application and custom modules as needed.
• Extensively written many SQL scripts against Facets tables (Sybase) & Application DB (SQL server) and validated the values with XML file.
• Writing, executing, documenting the results and Logging Written ETL test specifications including test source data preparation, writing test cases to test Data Completeness, Data Transformations, Data quality, Performance and scalability, Data aggregations− match aggregated data against staging tables and/or ODS, and Granularity of data is as per specifications.
• Reviewed the ETL source to target document/ source to target mapping document/ source to target dictionary.
• Performed different ETL testing techniques like system integration check, incremental testing, retesting.
• Created, designed and executed test cases, test plans and test harness in ETL.
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using SSIS and provided technical support and hands-on mentoring in the use of SSIS for testing.
• Performed data validation testing writing SQL queries. Tested ETL batch processes using UNIX shell scripting.
• Validated all data in Extract load table against, load Result, SSRS subscription exclusion report and Facets Table using SQL query.
• Involved in creating Test Plans for the different aspects of the project according to the business specifications in coordination with the system analyst and project owner.
• Responsible for coordination with UAT team and helping on Test data needs.
• Provided estimations on various Testing activities, impact analysis, requirement analysis, design, testing and implementation.