SUMMARY

• Over 7 years of excellent IT experience in requirement gathering, data analysis, design, development, Testing and Implementation of Data Warehouses using ETL & Business Intelligence solutions, UNIX, OLAP for multiple domain.
• Expertise in understanding Business/Functional/technical requirements and compliance rules.
• Experienced in writing test plans, test cases and test scenarios.
• Complete exposure to all stages of SDLC process with strong skills in writing various test plans, developing, maintaining test cases and test scenarios.
• Excellent Understanding in relational Data modelling, Dimensional data modelling, logical/Physical Design, ER Diagrams, analyzing data sources.
• Experience of insurance policies like HMO and PPO and proven experience with HIPPA EDI transaction codes such as 837 claims (Institutional, Professional, Dental), 270/271(inquire/response health care benefits), 276/277(Claim status), 834(Benefits enrollment), 835(Payment/remittance advice),
• Worked with SOAPUI for testing Web Services
• Performed Web Services testing and Validated XML request/response data using SOAPUI.
• Profound knowledge of web services testing using Service Oriented Architecture tools SOAP UI.
• Expertise on variousElectronic Data Interchange (EDI)transactions.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting
• Experience in testing complex reports generated by Cognos, Business Objects including dashboards, summary reports, master detailed, drill down and score cards.
• Used QTP framework functionality in various phases.
• Extensive experience in using SQL, PL/SQL Procedures/Functions, Triggers and Packages for testing purposes.
• Experienced in functional, integration, regression, compatibility, security, back end, acceptance testing (UAT), and GUI Testing.
• Advanced user in using Test management tools like Confidential Quality Center,.
• Prepared and loaded test data in different environments for different testing needs.
• Ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently within time frame.
• A good team player with excellent written and verbal communication skills.
• Excellent problem solving skills with a strong technical background and good interpersonal skills. .

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9,8.5.1 (Designer, Workflow Manager, Workflow Monitor,) Abinitio GDE

OLAP Tools: IBM Cognos v9, SAP Business Objects 2010/2008/XIR2, Microstrategy 8.0

Data Modeling: Microsoft Visio, Rational Rose (UML), ER Studio

Operating Systems: Windows NT/2000/2003/XP, UNIX, Solaris and MSDOS

Databases: Oracle 11g/10g/9i/8i, SQL Server2008/2005, DB2, MS Access, Teradata V2R5.

Testing Tools: Rational ClearQuest, Test Director, JIRA, Confidential Quality Center(ALM)

Languages: XML, SQL, PL/SQL

PROFESSIONAL EXPERIENCE

Confidential, Durham, NC

Sr. QA Analyst

Responsibilities:

• Involved in Regression, Functional, Integration, System Testing and User Acceptance Testing.
• Participated in analysis of Business and functional requirements.
• Interacted with Business users to determine User requirements and goals.
• Entered new bugs and maintained the current status of those bugs.
• Responsible for communicating Defect Status Reports to business in project meetings.
• Participated and Organized weekly meetings and walkthroughs to improve the testing efforts.
• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfil data and reporting requirements including identifying the tables and columns from which data is extracted.
• Hands on experience in Automation testing using QTP.
• Performed Web Services testing and Validated XML request/response data using SOAPUI.
• Extensively worked in ANSI x12 EDI Transaction and validate the date from EDI transaction.
• Responsible for creating the Requirements Traceability Matrix.
• Developed Test Strategy, Test plans, and Test scenarios using MS Word and MS Excel.
• Developed Test Cases and Test Scripts for System and UAT Testing.
• Tested HIPAA Transactions and Code Sets Standards such as 837/835, 270/271, 276/277 transactions.
• Extensively worked with EDI transactions such as 835, 837 following the HIPAA compliance EDI standard format of X12.
• Performed Positive and Negative Testing for many scenarios and applications.
• Testing the source and target databases for conformance to specifications.
• Conditional testing of constraints based on the business rules.
• Conducted regression testing on the application under test and Debugging the SQL - Statements and stored procedures.
• Tested the Oracle SQL testing programs and tested the Oracle Applications and Portals like Executive Dashboard, lookup built on Oracle.
• Performed manual and automated test procedures for functional testing of Web services using SOAP UI.
• Conducted review sessions on test case and regression test scripts in Quality Center.
• Used Inner and Outer Joins in order to retrieve and validate the Various Transaction Details from multiple tables.
• Tested Subscribers/Providers and claims in Facets.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Verified and maintained Data Quality, Integrity, data completeness, ETL rules, business logic.
• Involved in Manual and Automated testing using QTP and Quality Center
• Verified Informatica sessions, worklets and workflows in QA repository.
• Extensively used SQL queries to check storage and accuracy of data in database tables.
• Used SQL for Querying the Oracle database.
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing.
• Involved in backend testing for the front end of the application using SQL Queries in Teradata data base.
• Tested whether the reports developed in Cognos are as per company standards.
• Tested different detail, summary reports and on demand reports using Report Studio.
• Reported bugs and tracked defects using Quality Center 10.
• Generated reports using SOAPUI
• Worked with business team to test the reports developed in Cognos.
• Personalized Cognos Connection for specified display options for testing regional options and personal Information; Also written several complex SQL queries for validating Cognos Reports.

Environment: Oracle 11g, Sql Server 2005, Oracle 10g, Informatica Power Center 9/8.5.1 ( Workflow Manager, Workflow Monitor), Cognos 8.0 Series, XML,SOAPUI, QTP,SOAP, SOAPUI, Web Services, Teradata SQL Assistant, Test Cases, Unix, Test Matrix, TOAD, Confidential Quality Center 10

Confidential, Baltimore MD

Sr. QA Analyst

Responsibilities:

• Involved in reviewing/analyzing Business Requirement Documents/Functional specifications/use cases.
• Worked with Business Analysts, developers while reviewing the Business Requirement Documents and when there are enhancements in the applications.
• ValidateEDI Claim Process according to HIPAA compliance.
• Tested the HIPAA EDI transactions 834, 837/835, 276/277, 270/271 according to the requirement test scenarios.
• Executed test cases for the existing market’s various lines of business. (The test cases covered: Authorization of claims, Accumulator, Benefits, Claim Payment and Pricing, as well as member and provider data updates)
• Involved in Data Extraction from Teradata and Flat Files using sql assistant.
• Peer reviewed test cases developed by QA team members and advice/point/discuss possible complex scenarios and make sure requirements are completely covered.
• Supported and provided test cases for UAT, staging and production Participated in review meetings and attended training sessions to understand various business concepts.
• Prepared Entry and Exit criteria for Testing cycles, review with functional leads and PMO.
• Exported Requirements, test plans and test cases to QC
• Analytical day to day support for FACETS enrollment and billing system and system enhancements
• Created Traceability Matrix to ensure that all requirements are covered in test cases.
• Develop Risk-based Test Strategy whenever required, to save time and to determine which test activities to carry out and created complexity matrices.
• Prepared Kickoff meeting PowerPoint and gave presentation on testing activities for each cycle of testing and for different releases.
• Extensively used SOAPUI to validate SOAP/WSDL and web services.
• Involved in Testing Web Services using SOAP UI.
• Conducted Defect meetings on daily bases to track defects status with functional leads and to speed up resolution process at end of each cycle.
• Interacting with developers, business analysts to communicate the defects.
• Involved in UAT process before rolling out to production when required. Participated in debugging prod issues along with support team.
• Worked in Agile methodology during application development and participated in daily scrum meetings.
• Developed user defined functions, created objects where required and used descriptive programing to automate.
• Created defects, manage defect reports and defect status in ClearQuest tool
• Extensively tested the Business Objects report by running the SQL queries on the database by reviewing the report requirement documentation.
• Developed and ExecutedSQL statementsinToadto retrieve data and to validate data.
• Tested data migration to ensure that integrity of data was not compromised.
• Validated the data thru various stages of data movement from staging to Data Mart to Data Warehouse tables
• Extensively involved in testing Facets Member/Subscriber, Billing, Medical Plan.
• Responsible for documentation of test results, test matrix,andparticipated in daily/weekly QA meetings.
• Conducted down test and up test for release builds pushed to UAT and to Production.

Environment: Informatica Power Center 8.6(Repository Manger, Designer, Server Manager), QTP,Oracle 10g,MS SQL, Confidential Quality Center 9.2, Teradata SQL Assistant, Teradata V2R6, Requirement traceability Matrix (RTM), IBM Rational Clear Quest 7.0, Unix, TOAD, SOAP, SOAPUI, Web Services, MS Excel, MS Project.

Confidential, Windsor, CT

EDI Transaction/QA Tester

Responsibilities:

• Analyzed current Claim Authorization Process across on the FACETS. Identified possible constrains that pending claims related to Claim Authorization Mismatch.
• Work as a Data analyst to set Facets data in Claims Processing, Members/Subscribers, Groups, Billing for different testing efforts.
• Extensively involved in Batch testing of claims submission.
• Extensively used Application Lifecycle Management to plan tests, manage test assets, create and run manual and external scripts to check GUI and functional features of the AUT.
• Established and maintained test cases and test data in ALM.
• Logged the defects in ALM and maintained track of the defects throughout its lifecycle.
• Worked on UNIX and Filezilla for manually loading failed ETL Packages and Daily claims to the Repository.
• Worked on Claims Processing and Claims Accumulation and Adjudication in FACETS.
• Analyzed HIPAAEDItransactions in XML and X12 responses and of 837I or 837P and looked for defects for amendment.
• Involved in generating BPM error report and uploading it to the share-point.
• Involved in generating TM/ETL error logs from different server for the failed ETL packages.
• Replaying the claims with missing ECHCF manually and also replaying 4010 claims through Filezilla and UNIX.
• Performed GAP analysis of ICD9-ICD10.
• Worked on Edifecs application TM and OR to validate the claims.
• Participated in discussion/conferences call on technical issues pertaining to 277CA replay and recovery.
• Designed state processes for HIPAA 4010 transaction processing EDI’s 837 Inbound.
• Involved in uploading the OR and HTR Balance Report on share-point.
• Monitored FTP (Filezilla) file transactions on Web logic and generated Excel based reports specifying the count and child claims.
• Developed guidelines for Business Process Modeling, Use Cases, Work Flow, Data Dictionary and Requirements Specifications.
• Actively participated in all phases of testing lifecycle (Design, Planning, Development and Results).
• Successfully analyzed the difference between ICD-9 and ICD-10 and their impact on related data.
• Worked in testing the Professional, Institutional Claims processing and adjudication and validate data with FACETS.
• Design Test Plan and test strategies based on high level business and technical documents.
• Wrote complex SQL Queries using Joins and Sub-Queries to test the reports generated by the different modules.
• Created and implemented test cases for EDI files generated for various transactions as 837 IB, 277CA.
• Tested for mappings in EDI files through Transaction mapping documents.
• Involved with other team members to set up testing tools, implementation and testing environments.
• Analyzed the Impact Analysis of ICD-09 to ICD-10 on the current Legacy Systems.
• Involved in XML testing.
• Documented Unit, Integration and System Test cases using Confidential Quality Center from Functional, Technical and other high level design documents.
• Performed both automated and manual testing.
• Manually Conducted Positive and Negative testing.
• Used SOAP UI, WebLogic ANT task to test Web Services running on WebLogic Server.
• Created Mock Services using SOAPUI.
• Enhanced scripts by creating Actions, Checkpoints, Synchronization points and parameterization with Quick Test Pro (QTP).
• Performed Sanity and Smoke Testing of the application manually after each build.
• Performed back-end testing and verified the data between GUI and database are reflected correctly.
• Involved in creation and maintenance of Test Matrix and Traceability Matrix.
• Use ALM for the reporting and tracking of defects.

Confidential, Baton Rouge, LA

Sr. QA Tester

Responsibilities:

• Developed technical design documents and mapping documents for implementing health care HIPAA transactions like 834, 837I, 837P, 837D, 997,270, 271, 276, 277.
• Implemented HIPAA transactions like 834, 837I, 837P, 837D, 276,277 by gathering the requirements, built maps to translate HIPAA ANSI X12 data to XML format and custom format to X12 format, performed unit/integration testing and production migration for 5010 changes.
• Involved in preparing test cases, test scripts based on use cases and BRD documents and high level X12 5010 based business requirements.
• Used QTP to write Data driven test scripts to handle positive and negative sets of data.
• Created test data for 837I, 837D, 837P to have Segments/loops information with different combination of Submitter, Receiver, Billing Provider, Pay-To-Provider, Subscriber, Payer, Confidential t, Claim Information, Physicians, Referring Provider, Service Line Info, Adjudication Information
• Wrote SQL queries to validate data in database and Facets.
• Experience in writing the test cases and test plans for Facets.
• Involved in Data mapping to/from legacy toFacetsthat will be used to populate the database
• Involved in writing extensive SQL Queries for back end testing Oracle database.
• Involved in configuration changes in Facets testing
• Performed QA Acceptance testing for test workflows with business users and performed data encryption testing as per HIPAA guidelines to ensure the privacy, security and confidentiality.
• Played major role in 24/7 production support for transactions like 834, 837I, 837D, 837P, 270, 271, 276, 277.
• Extensively used Confidential Quality center for defect tracking management of test cases.
• Used SYBASE to view tables, indexes, stored procedures. Triggers etc.
• Communicated with business and development teams to resolve issues during test execution and ensured enhancements meet established quality and end user needs.
• Tested web services by generating XML SOAPUI Requests and validated the corresponding XML SOAPUI Responses.
• Logged the errors, reported defects, determined repair priorities and tracked the defects until resolution using Mercury Quality Center.
• Extensive knowledge of Test Matrix, Traceability Matrix.
• Quality Center was used to create the test plan, store test cases and run the test sets.
• Used Quality Center to analyze, track and report defects.
• Worked on uploading all the Test cases to the Quality Center for the current and prior releases.
• Responsible for performing System and integration testing for release.

Environment: Quality Center, IBM Mainframe, HL7, HIPAA standards, Facets, Oracle on Windows, SQL, MS Outlook, Java, HTML.

Confidential, Howell, NJ

QA Tester

Responsibilities:

• Analyzed business rules to generate consolidated (fact/summary) data identified by dimensions using Informatica ETL (Power Center) tool.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository manager.
• Scheduled sessions and Batch process based on demand, run on time, run only once using Informatica server manager.
• Written Test Cases to cover overall quality assurance testing.
• Performed manual testing on different modules of the application.
• Performed data integrity testing by executing SQL statements and manually verifying the contents.
• Used SQL to perform Backend Testing on databases.
• Involved in supporting the deployment of data marts and reports.
• Performed manual testing prior to automate testing on the application.
• Scheduled and monitored transformation processes using Informatica Server Manager.
• Prepared Test status reports for each stage and logged any unresolved issues into Issues log.
• Prepared Test Plan from the Business Requirements, detected defects, tracked and reported bugs using Test Director.
• Involved in writing testing methodology by following standards for test documentation, test requirements and test procedures.

Environment: Informatica Power Center 6.1, Oracle 9i, PL/SQL, TOAD, SQL*Loader, XML, XSLT, XSD, VSAM, JCL, MVS, COBOL II, Copy Books, SQL, PL/SQL, Autosys, Test Director, HTML, Windows NT/2000.