SUMMARY

• Seeking a fast paced dynamic environment to align my professional skills in the field of software quality assurance and configuration management with my strong work ethic.
• 6 years of experience as a Quality Assurance Analyst with extensive knowledge and experience across the project life cycle in Systems Development Life Cycle (SDLC) in the fields of Insurance, HealthCare and Finance.
• Implemented and experienced in various QA methodologies.
• Experienced in every phase of Quality Assurance Life Cycle (QALC) and Software Development Life Cycle (SDLC)
• Performed planning and development of Test Plans, Test Strategies, Test Cases and Test Scenario to meet product’s business requirements.
• Proficient in Defect Reporting and Tracking throughout the entire defect life cycle.
• Possess strong problem solving skills with the ability to adapt to a new environment and meet deadlines.
• Expertise in Testing of Client/Server and Web based applications.
• Skilled in bug reporting and tracking using Test Director, HP HP ALM.
• Strong in IT research, software analysis and design skills.
• Extensive experience in Backend Testing on distributed databases using SQL queries.
• Experience in Functional Testing, System Integration Testing, Back End Testing, GUI Testing, configuration Testing, User Acceptance Testing.
• Solid understanding of Membership, Claims Processing, Billing, Benefit/Eligibility, Authorization/Referrals, COB, and have experience in HIPAA standards and corresponding EDI transactions.
• Knowledge of Medicaid and Medicare Services.
• Solid understanding of Membership, Claims Processing, Billing, Benefit/Eligibility, Authorization/Referrals, COB, and have experience in HIPAA standards and corresponding EDI transactions.
• Strong knowledge of EDI Claims, member enrollment, and billing transactions as well as ICD - 9 and ICD- 10.
• Experience in performing functional testing using Quick Test Pro.
• Followed Workgroup for Electronic Data Interchange standards for testing that need to comply with the HIPAA guidelines.
• Tested the HIPAA EDI transactions 834, 837/835, 276/277, 270/271 according to the requirement test scenarios.
• Optimum use of documentation to avoid any form of miscommunication or misinterpretation during the entire software development process
• Excellent communication and organizational skills with the ability to adapt to a new environment.
• Experience in facilitating meetings with clients to discuss and sign-off on the document.
• Conducted User Acceptance Testing (UAT)
• Motivated self-starter with exceptional team building, leadership, and interpersonal skills. Good team player with the ability to work in time sensitive environments.
• Proficient in working with FACETS, claim processing systems.

TECHNICAL SKILLS

Methodologies: SDLC, RUP, Agile, Waterfall

Platforms: Windows, Mainframe

Testing tools: WinRunner, LoadRunner, HP ALM, Quick Test Professional

Change Management Tools: Rational ClearQuest, TestDirector, HP Mercury Quality

Office Tools: MS Project, MS Office, MS Visio

Database: MS SQL Server, MS Access, Oracle, Toad

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Sr. QA Analyst

Responsibilities:

• Analyzed system requirements and developed detailed Test Plan
• Wrote Test Plans, Test Strategy, System Testing and End-to-End Tests based on the business requirements
• Wrote test cases in HP ALM derived from the Design documents and generated a Traceability Matrix for testing purposes.
• Performed functional tests in HP ALM to execute, report and document bug information useful in the debugging process and evaluation of test data.
• Developed Test Script for Functionality, Security, and Regression testing.
• Performed System, Integration, Unit, Regression Testing and User Acceptance Testing.
• Performed Manual as well as Automation Testing to verify the expected results.
• Uploaded, managed and reported defects using HP ALM.
• Resolved various code issues using Informatica Debugger ensuring high performance and optimal implementation of solution.
• Worked closely with Informatica Administrators to migrate and deploy codes to production through Development and QA environments.
• Used Informatica ETL tool for Extraction, Transformation and Loading the data into target database.
• Found the Informatica mappings bottlenecks and optimized mappings to get the best performance and tuned the SQL queries.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.
• Worked closely with the production development team to resolve bugs and ensure stability.
• Worked on Unix Platform and experienced in back end testing by executing SQL Queries
• Checked the data flow through the frontend to backend and used SQL Queries to extract the data from the database
• Tested the PL/SQL procedures, functions, packages as per the requirement.
• Involved in writing extensive SQL Queries for back end testing oracle database
• Retrieved files using SQL statements and UNIX commands
• Delivered project assignments on time, within budget and with high quality.
• Developed SQL Queries for backend testing and validate database integrity.
• Processed claims in FACETS and verified they are generated and sent to Provider.
• Involved in FACETS Implementation, end-to-end testing of FACETS Billing, Claim Processing and Subscriber/Member module.
• Conducted GAP analysis and filling gap according to the format set by HIPAA.
• Trained new team members in new business initiatives through data analysis, identification of implementation barriers and user acceptance testing of new systems.

Confidential, Louisville, KY

QA Tester

Responsibilities:

• Analyzed the business requirements, functional specification and use case documents.
• Developed test plans, test cases using requirements, use cases, wire frames and design documents.
• Ran the scripts on multiple environments (QA, UAT and Production) to ensure that requirements were still met.
• Performed and coordinated User Acceptance Testing (UAT) with the appropriate 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.
• Performed Manual Testing prior to automate testing on the application.
• Involved in testing FACETS Member, Provider, Claims Processing, Utilization Management, Accumulators, Contracts and Benefits
• Performed back end testing in SQL on the Oracle database.
• Analyzed the front end Customization requirements on FACETS applications ( Member, Group/Subgroup application, Member maintenance, etc).
• Involved in FACETS Implementation, involved end-to-end testing of FACETS Billing, Claim Processing and Subscriber/Member module.
• Involved in testing EDIs according to code set X12 835 Claim Payment & Remittance Advice Claims processing and 837 Claim transactions with HP ALM
• Profiled the data using Informatica data quality (IDQ)
• Extensively used Informatica Workflow Manager to run the workflows/mappings and monitored the session logs in Informatica Workflow Monitor
• Involved in the development of Informatica mappings and mapplets and tuned them for Optimum performance, Dependencies and Batch Design
• Created Several Informatica Mappings to populate the data into dimensions and fact tables
• Monitored and analyzed Activities Report, Performance Reports, Cross results and merged graphs in Load Runner
• SQL Tuning and rewriting of SQL code to improve performance
• Wrote PL/SQL stored Procedures and Functions for Stored Procedure Transformations
• Actively participated in walkthroughs and enhancement meetings
• Customized Mercury HP ALM to suit the requirements of testing effort
• Monitored the Defect Tracking Process and generated customized graphs and reports for the client using HP ALM.

Confidential, Nashville, TN

IT QA Analyst

Responsibilities:

• Participated in developing test plans templates and guidelines to be used by the project team with detailed screen layouts with regards to various types of corporate actions.
• Involved in the development of Test Plans and Test Cases and coordinated the tests with the QA team to verify implementation of new features and enhancements.
• Facilitated Joint Application Development (JAD) Sessions for communicating and managing expectations involved in FACETS Implementation, involved end to end analysis of FACETS Billing, Claim Processing and Subscriber/Member module.
• Set claim processing data for different FACETS Module.
• Design, analyze and performed Integration and wrote System requirements on different leading health care software’s such as FACETS.
• Writing Test Plans/Test Scenarios/Test Cases/Test Matrix.
• Followed the Agile methodology for the entire SDLC
• Involved in writing and executing test cases using HP ALM based on the requirements
• Performed Back-End testing using SQL Query.
• Wrote SQL queries to check for data validation.
• Created and executed SQL statements manually to perform Backend Testing that ensured data consistency on the Front-end.
• Used SQL to test various reports and ETL load jobs in development, QA and production environment
• Developed design Specification writing Test report s and documenting Test results
• Identified customer requirements besides reviewing test plans and documented the development of these plans
• Developed automation test scripts for performing regression testing on the application using Quick Test Pro
• Conducted interviews and workshops for soliciting customer requirements
• Performed Test execution and wrote and executed Test scenarios /Test Scripts
• Interacted with the technical team for the 837 claims transactions design
• 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)
• Executed Test Scripts for Functionality Testing and reported defects in Rational Clear Quest
• Created Relationship and column discovery in Informatica’ s Developer Tool, Informatica Analyst Tool (IDQ)
• Validated various SSIS packages as per functional specifications
• Created and monitored workflows and task using Informatica PowerCenter Workflow Manager
• Created Autosys jobs using command interface to run the Informatica workflows
• Prepared UNIX scripts to run the Informatica ETL jobs from command line

Confidential, Eden Prairie, MN

QA Tester

Responsibilities:

• Involved in HIPAA/EDI Medical Claims Analysis, Design, Implementation and Documentation
• Involved in HIPPA Complaint X12N837 Transaction testing.
• Developed and implemented EDI applications to process Health Care transactions as per the HIPAA implementation
• Conducted Black Box Testing on the application and validated the dataflow in the application.
• Involved in preparing the Test Scenarios for Health Care Claim Payment/Advice
• Written multiple Test Cases (System, Integration) for multiple transactions include 837I, 837P, 835, (both inbound and outbound) transactions
• Reviewing the Use Case Requirement, Functional Design Documents and Technical Specification documents.
• Creating Test Cases after analyzing the BRD’s.
• Performing Functional and GUI testing on FACETS.
• Prepared test matrices based through defect status in HP ALM.
• Involve in testing of FACETS Implementation, involve in end to end testing of FACETS Claims Processing module, Membership and benefits.
• Logged defects in HP ALM and interacted with the developers to resolve technical issues.
• Performing Backend Testing extensively by writing validation queries on DB database.
• Validating member’s benefits against the benefits matrix.
• Analyzed and tested data on claims manually and writing queries on DB database for validating data.
• Validating member’s accumulator track right member’s benefits and making sure that Claims gets paid according to the SEPY’s rule.