Experience Summary

Six years of experience in Software Quality Assurance with extensive knowledge in testing both web based and client server applications.

Well versed with various SDLC methodologies like Agile & Waterfall and supporting the testing efforts during the various phases of the project.

Expert in Manual and mid-level Automated Testing using tools like HP Quality Center-ALM, Quick Test Professional and SoapUI to verify SOAP based web services.

Possess a good knowledge and understanding of applications in Healthcare/Insurance domain mainly in Claims, Benefits and Enrollment. Experienced in working with EDI 837 transactions as per HIPAA based transactional 5010 formats.

Designed and executed SQL queries to extract the needed test data and validating the data accuracy.

Validated the extraction, transformation and load (ETL) process for a Data Warehouse from their OLTP systems using Informatica.

Sound Knowledge and experience in Metadata and Star schema/Snowflake schema. Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W.

Experienced with Test Management and documentation like writing Test Plans, detailed Test Cases, Collection of the required Test Data and publication of Test Results and Traceability Matrix.

Experienced in Defect Management, communicating the status of the defects and determining the readiness for Product Owner or User verification using tools like JIRA and HP Quality Center-ALM.

Played an active role in Defect Triage meetings and generated various reports to update the status to the management. Used Confluence to document the known issues, lessons learned and best practices for future reference.

Experienced in working with cross-functional teams like Web-Services, security, and coordinated the test effort.

Tested applications on mobile devices like iPhone, iPad and in multiple versions of iOS.

Technical Skills

Languages:

HTML, SQL, XML, VB Script

Databases:

Oracle/SQL

Platforms

Windows XP/2000/7/NT, UNIX, iOS

QA Tools

HP Quality Center- ALM, HP Quick Test Professional, Jira, Confluence

Other Tools

SoapUI, Altova XML-Spy, SQL Developer, MS SQL Server Management Studio, Informatica.

Browsers:

Internet Explorer (IE), Google Chrome

Others

MS Office (Word, Excel, PowerPoint, Outlook), iPad, iPhone

Professional Summary

Client: Risk Management Solutions of America, Chicago. IL.

Role: QA Analyst June 2017- Present

Currently working as an EDI QA Analyst for an application called AEGEAN with Risk Management Solutions of America (RMSOA). AEGEAN is the industry leading EDI clearinghouse, uniting providers and payers in the workers’ compensation and automobile industry.

Responsibilities:

Writing Test Plan, Test Scenarios, Test Cases and Test Matrix documents analyzing the Use Cases and updating the Traceability Matrix to check the coverage analysis.

Analyzing the Healthcare Claims EDI 837I and 837P files and modifying them appropriately to create different test data scenarios to validate various business rules of the application.

Experienced in Data transformation and Data flow validation of the inbound EDI transactions from various providers into the staging server via SFTP or directly from the Application Portal.

Possess good understanding of eligibility enquiry (270) and response (271) type EDI transactions.

Have worked with edit codes to validate HIPAA compliance of the application.

Experienced in working with Secured FTP client and SQL Database.

Actively involved in Defect reporting, Triage, Defect Tracking, Summary Reports & Regression Testing. Used Practitest for defect reporting and tracking

Environment: .NET, Practitest Test Management Tool, Microsoft SQL Server Management Studio, Microsoft Office Suites, FileZilla SFTP, SQL Database.

Client: AllState Corporation, Northbrook, IL Oct 2016 – June 2017

Role: QA Analyst (ETL)

RoadSmart Gateway is a web-based application to provide AllState Roadside Services (ARS) by different registered providers across US and Canada. The application enables service providers to receive, accept and update jobs in progress. The application allows dispatchers to send jobs to different available service providers in the vicinity of the incident when eligible customer calls the ARS helpline for roadside assistance. This application has been instrumental in improving AllState Roadside Assistance program; hence resulting in a great customer satisfaction.

Responsibilities

Participation in Business requirements review meetings and identification of key scenarios for functionality testing.

Writing Test Plan, Test Scenarios, Test Cases and Test Matrix documents analyzing the Use Cases and updating the Traceability Matrix to check the coverage analysis.

Good understanding of application build cycles and following the required test strategy to meet the testing requirements.

Responsible for manually testing the entire application for GUI, Functionality, Business Logic and Use case adherence.

Defect Reporting, Tracking and interacting with the development team and the real-time users to implement the entire Test Management process.

Used Jira for writing test cases, reporting and tracking defects and test management.

Used SQL Developer for extracting the required data related to testing, test data set creation and data validation.

Used SoapUI to verify SOAP based web services.

Tested the website on mobile devices like iPhone and iPad.

Worked with on-site and off-shore resources and supported UAT testing.

Environment: Java, Hibernate, Spring, JSON, JQUERY, AJAX, S, Oracle, SOAP UI, Jira, Confluence, MS Office Suites, XML-Spy, iOS, Informatica.

Client: United Healthcare, NY Aug 2015 – Oct 2016

Role: QA Analyst

United Healthcare is one of the largest health benefits companies in the United States. Efficient management of member and their dependents’ enrollment; prompt and easy claim processing, presenting accurate and timely claim statuses and issuing payments; providing detailed Coverage & Benefits Information are some of the key facilities provided by UHC to its customers which makes UHC as one of the leading Healthcare Insurance provider in the country.

Responsibilities

Reviewed and analyzed Business Requirements, Project Plans, Prototype, Flow Diagrams, Use Cases, System Design documents and created Detailed Test Cases.

Prepared traceability matrix to map the requirements against the test cases and validated the test coverage analysis.

Experienced in reviewing and analyzing raw data of EDI 837 transactions as per HIPAA based transactional 5010 formats to triage incidents caused due to data discrepancy between the provider, TPA and claim processing system.

Experienced in ICD 10, Obamacare/ PPACA and HIPAA 5010.

Automated the key functional scenarios using QTP to support regression testing and managed the entire test efforts in an integrated QC environment.

Good understanding of application build cycles and following the required test strategy to meet the testing requirements.

Coordinated with offshore teams and organized conference calls to update the management team regarding the project testing status.

Actively involved in Defect reporting, Triage, Defect Tracking, Summary Reports & Regression Testing. Used Quality Center for defect reporting and tracking.

Drafted detailed defect reports with required attachments and steps to reproduce the defects and communicated effectively with the development team.

Environment: Java, Web logic, Web-Services, Oracle, IBM Mainframe, HP Quality Center, Quick Test Professional, SQL Developer, Microsoft Office Suites.

Client: Axis Bank, India March 2011 – Nov 2014

Role: ETL Tester

Axis Bank Ltd is the third largest of the private-sector banks in India offering a comprehensive suite of financial products.

It offers the entire spectrum of financial services large and mid-size corporates, and retail businesses.

Responsibilities:

Performed data validation testing writing SQL queries.

Validated the extraction, transformation and load (ETL) process for a Data Warehouse from their OLTP systems using Informatica.

Verified data completeness and transformation rules.

Tested referential relations and integrities of data.

Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.

Sound Knowledge and experience in Metadata and Star schema/Snowflake schema. Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W.

Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)

Environment: Java, JSP, JavaScript, UNIX, SQL, Windows XP, HP Quality Center, Microsoft Office Suites, Informatica Power Center.

Education: Master of Science.

Certification: ISTQB Foundation Level (CTFL)

Status: Employment Authorized (EAD)

Contact this candidate