OBJECTIVE:

• Over 8 Years of Experience in Information Technology Industry seeking a Challenging position in - order to utilize my Experience and Professional & Technical Skills in Software Development Industry as a Software Tester, Quali- ty Assurance Analyst, using widespread Knowledge of Information Systems Technology.

SUMMARY

• Excellent skills in writing Test Plans and Test Cases.
• Experience in testing Client/Server, Web-based Applications, and Mainframe.
• Expertise in Bug reporting tools such as Quality Center/ALM.
• Configured Test Bed environment by integrating specific Hardware, software and Operating the Test Execution.
• Extensive knowledge of deriving and writing Test Plans and Test Scripts based on Use Case and Use case realization.
• Proficient in manual and automated testing of applications on Windows and Unix environment.
• Very good experience in Back-End Testing using SQL on Windows platform to validate the consistency of data. knowledge of Adobe Experience Manager and AEM Core components (Example: Sling, OSGI, JCR, Dispatcher)
• Worked in QA environments and loaded builds in a Linux/ Unix environment
• Worked under Waterfall and Agile development methodology.
• Maintained Test Matrix and Requirement Traceability Matrix.
• Proficient knowledge in various types of Software Testing such as Unit testing, Integrated testing, System Testing, Black box testing, Positive Testing, Negative testing, Performance Testing, Volume Testing, Back end Testing and Regression Testing.
• Experience in testing complex reports generated by Cognos, Business Objects including dashboards, summary reports, master detailed, drill down and score cards.
• Experience with EDI transactions such as EDI 834 (Benefit Enrollment and Maintenance), 276/277 (Health Care Claim Status Request and Response), 278(Health Care Service Review Information), 835 (Health Care Claim Payment/Advice), 837P (Health Care Claim: Professional), 837I (Health Care Claim: Institutions), ICD9/ICD10.
• Worked extensively with inbound and outbound 837/835 claim processing systems.
• Performed BI testing using reporting tools Cognos Dashboards and Business Objects.
• Excellent communication and writing skills with the ability to adapt to new and dynamic environments.
• Good team leader, Player and can work alone with minimal or no supervision.
• Experience working with off-shore team. Ability to multi-task, prioritize and work with time constraints while paying attention to details.
• Good problem solving, judgment, and decision-making skill.
• Collected different carrier data using TEMS Software.

TECHNICAL SKILLS

Methodologies: SDLC, Waterfall, Agile

Project Management: Microsoft Project, Microsoft Office Excel, Power Point, and Visio, Version one

Testing Tools: ALM/Quality Center, QTP and Microsoft Visio, REST, SOAP UI

Operating Systems: Windows, Linux, Unix

Web Technology: CSS, HTML, XML, SQL,UNIX

Tests: UAT, Regression, Functional, Black box, White Box, Unit, Smoke testing

PROFESSIONAL EXPERIENCE

Confidential

Sr. Quality Assurance Analyst (ETL)

Responsibilities:

• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing. Worked with business team to test the reports developed in Cognos.
• Validated X12 and XML files for various EDI transactions 837/ 835, 270/271, 276/277 and performed compliance testing on 837 I and P, 834 and 820 EDI transactions.
• Tested claims benefits, payment, pricing for both institutional and professional claim types.
• Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic
• Processed claims in FACETS and verified 835X12's are generated and sent to Provider.
• Worked with providers and Medicare or Medicaid entities to validate EDI transaction sets or Internet portals
• Experience in Hadoop / Big Data Testing using Hive and Python Scripts.
• Assisted QA Lead and 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
• Processed 837P, 837I & 837D transactions, verified those 837 transactions converted correctly to XML file format & XC keyword file format and verified the claims data loaded to FACETS for further processing.
• Designed and prioritized Test scenarios/ Test Cases that will provide efficient coverage for requirement consistence with acceptable level of risk
• Manage the technical delivery of custom development, integrations, and data migration elements of an AEM implementation
• Tested the ETL process that loaded the data into target database after performing all the transformations as per the business requirements
• Tested and verified data warehouse ETL packages built on the SSIS platform by writing SQL queries in Management Studio supporting health care industry clients
• Work with the application team to design and develop an effective Hadoop solution. Be actively engaged and responsible in the development process
• Experience implementing Adobe AEM/CQ5 and other WCM platforms in large scale environments
• Tested all the ETL processes built for fetching various source data into Data warehouse
• Performed data validations on the loaded data by comparing against source data through complex SQL queries
• Tested the ETL Ab Initio graphs and other ETL Processes (Data Warehouse Testing)
• Facilitate UAT Testing by providing necessary support to the Business users.
• UAT analysis, consulted with client on updates, issues and solutions and go live support
• Tested the portal application to make sure the claims, members are loading to FACETS
• Involved in testing FACETS Member, Provider, Claims Processing, Utilization Management, Accumulators, Contracts and Benefits
• Tested different master detail, summary reports, ad-hoc reports and on demand reports using Cognos Report Studio.
• Written several complex SQL queries for validating Cognos Reports.
• Tested Cognos reports to check whether they are generated as per the company standards.
• Worked with business team to test the reports developed in Cognos
• Tested Complex Reports in Cognos BI Report Studio.
• Performed compatibility testing of native mobile application on different devices and platforms.
• Performed Regression Testing to verify any modification in a module adversely affects the existing mobile application.

Confidential, Hartford, CT

ETL/QA Tester

Responsibilities:

• Reviewed Business Requirements with Business Analyst, Project Manager and Lead Developer to learn the functionality of the application.
• Performed regular verification sessions and walk-through sessions to check the proper functioning of the application
• Retrieval and Member refresh and copy script for Mainframe systems. Created scripts and performed Data Driven and Keyword Driven Testing.
• Involved in FACETS Implementation, involved end-to-end testing of FACETS Billing, Claim Processing and Subscriber/Member module.
• Tested the HIPPA EDI 834, 270/271, 837/835 transactions according to test scenarios and verify the data on different modules.
• Set claim processing data for different Facets Modules.
• Tested regulations in Facets HIPAA privacy module.
• Involved in preparing Test Plan and Test Cases based on business requirements.
• Created and generated test scripts for different test scenarios covering all aspects of project functionality
• Checked the data flow through the front end to backend and used SQL Queries to extract the data from database. UAT testing for HIPAA projects including legacy testing and HIPAA requirements and compliance mandates
• Managed the testing and verification of HIPAA standard transactions, and EDI messages (837)
• Validated the date from EDI transaction.
• Creating Test Plan, Test Cases, and Test data after analyzing the BRD and Playbooks.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
• Logging of defects in HP ALM to maintain Test requirements and to communicate the bugs with the Developers.
• Performing Backend testing extensively by writing SQL validation queries against the database.
• Tested Data Mapping from Source to Target and Reports data validation for Business Intelligence application using Cognos.
• Created Relationship and column discovery in Informatica’s Developer Tool, Informatica Analyst Tool (IDQ)
• Involved in testing the Cognos reports by writing complex SQL queries. Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing) Written several complex SQL queries for validating Cognos Reports.
• Worked with Business Analyst in UAT testing and involved in testing in Production region.
• Coordinated User Acceptance Testing with the UAT group to ensure the correct business logic.
• Assisted the business partner in preparing UAT plan/scripts and assured project manager has taken steps for alignment of Operational Quality Checklist.
• Analyzing the Source- Stage- Target Mapping documents and writing SQL's to conduct data validation testing.
• Performed data mining in the test environment to look for test data.
• Generated cognos reports and validated.
• Analyzed/mapped/linked data with the data repository and used SQL queries to extract and process relevant data

Confidential - Portland, OR

QA Tester/Analyst

Responsibilities:

• Worked in agile environment. Created Test Plans, Test scenario and developed Test cases.
• Managed, Documented and Controlled all the Test Cases, Test Scripts and Test Results using HP ALM/ Quality Center and in a status update report using MS Excel.
• Performed in testing different facets’ claims, customer service, enrollment and workflow configuration.
• Tested in multiple Facet UAT environments
• Performed Back End testing using SQL queries to verify the integrity of database.
• Intensively involved in project testing efforts by doing Integration Testing, Regression Testing.
• Used JIRA to track and provided each requirement and defect status.
• Worked with Facets data models for Claims, Membership Eligibility etc.
• Prepared Test Cases based on business requirements and business rules for HIPAA EDI Transaction 834, 276/277, 270/271, 837/835.
• Extensively used SQL in order to retrieve data from the databases by writing Stored Procedures, views, triggers etc.
• Logged the errors, reported defects, determined repair priorities and tracked the defects until resolution using ALM.
• Identified the bugs and kept track of the defect report using HP ALM/Quality Center and analyzed the root cause for defects.
• Tested several Informatica Mappings to validate the business conditions. Written positive and negative test cases for Cognos reports based on report specifications.
• Responsible for creating UAT & Regression Test cases in the test plan module of ALM/Quality Center.
• Verified Claim / Encounter 837 (I/P/D) requirements, error correction and file resubmission.
• Defined Functional Test Cases, documented, Executed test script in Facets system
• Developed standardized FACETS testing, implementation and QA processes.
• Performed the Web Services Testing by sending the Request and Response XML in SOAPUI RESTFUL.
• Used SQL queries to test the integrity of data by querying the database.
• Logged defects in ALM/Quality Center and interacted with the developers to resolve technical issues.
• Participated in various kinds of testing like (UAT) User Acceptance Testing, Functional Integration, System, Regression and Black Box.
• Wrote Structured Query Language (SQL) statement against Claims, Claim Status and updating Personal Information modules by Joins, Unions and Aggregate Functions.
• Performed functional integration testing, negative testing, smoke testing, system testing, and regression testing to validate correct data flow into the enterprise data warehouse.
• Maintained Test Matrix and Requirements Traceability Matrix.
• Involved in writing extensive SQL Queries for back end testing oracle database.