Sanjeev K Kondal Ph: 201-***-****

*acsetu@r.postjobfree.com

Summary:

Overall 14+ yrs of IT experience in Quality Assurance, planning, estimation, analysis, scripting, execution, result analysis & reporting

Involved (as an Auditee) in ISO Certification (surveillance audits) of Software Products (Health care, Retirement system’s, SCM (Retail sales) Banking. Involved (as an Auditor) in Internal Audits for couple of products

PROFESSIONAL EXPERIENCE:

Have an excellent Domain knowledge (tested applications in various domains) in Healthcare Management System, Pension Retirement system, Customer Relationship Management, and Supply Chain Management, Order management system

Firm understanding of HIPAA regulations and experienced working in all phases of healthcare insurance processing like defining Membership Eligibility and Enrollment and various Medical Claims processing, including Medicaid and Medicare claims processing

Proficient in Manual Testing,Integration testing, Database testing on client/server and web-based applications

Experienced in creating Test Strategy, Test Plans, drafting Test scripts conducting various types of testing (which includes Smoke, Integration, Functional, System Testing, Business Process, Database testing, Regression and Performance Testing)

Experienced in Estimation Techniques, creating Metrics, Requirement Traceability Matrix, Project Management Plan

Complete understanding and experience with Software development Life Cycle (SDLC), Testing Life Cycle (TLC) and QA methodologies

Experience in using web service validating request and response using SOAPUI in healthcare Domain

Sound knowledge of HIPAA 4010 to5010 migration and ICD 9 to ICD 10 codes conversions

Excellent experience in analyzing, reviewing of Scope, Requirement Specifications and experience in drafting Functional Designs

Experienced and expert in many features of QTP/UFT such as Object repository, checkpoints, output values, actions, functions, and transactions

Worked on preparing SQL queries for Data validation and Data Flow

Excellent Presentation, Communication and Documentation Skills

Experienced in Back-end testing using SQL queries to ensure Data Integrity and validate business rules

Experience in working on 3-tier Architecture, integration Engine Application

Excellent knowledge in HL7 standards, ADT Messages which acted as a healthcare messaging between the two applications Patient Administration System (PAS) and the Clinical management (i.CM)

Domain Knowledge:

Health Care, Banking, Pension system, and Supply chain Management. Pharmaceuticals

Mercury Testing Tools:

UFT 12.00 (QTP), Win Runner, Load Runner, (ALM HP Quality center).

Web/Middleware technologies:

HTML 4.0,Java 2.0, Java Server Pages(JSP 1.1), Java Script 1.1, Servlets (2.2),EJB2.0,RMI, .NET,XML.

Languages:

C++, VBScript, XML, PL/SQL, UNIX Shell Scripting,Hl7

Operating Systems:

Windows, UNIX (Solaris, Linux) Mainframe

Databases

Oracle, DB2, SQL Server.

Application/Web Server:

Windows 7 Enterprise /Cyrix /NT, HP-UNIX 10.x, Linux,

Tools:

Toad, Edit Plus, MS Office, MS Project plan, iASSIST, PVCS, Seriana (Bug tracking Tool), Integrity ( Requirement and defect tracking tool)

Protocol:

TCP/ IP, FTP, SMTP

PROFESSIONAL EXPERIENCE

Project: Cerner Application Salt Lake city, UT Sep 2014 – Present

Role: QA Lead

Project Description: iCentra (cerner Product) is a patient information management system which connects with several vendor applications via Egate interface engine. Cerner is capable of sending and receiving messages from multiple types of vendor applications such as Radiology, Cardiology, Pharmacy, Labs, etc. iCentra mainly communicates with HL7 message through interface and downstream application. Few applications sends in-bound message back to iCentra on a given format will be updated. Those received results will be sent to downs stream applications. Was extensively responsible for conversion of ICD-9 CM and PCS codes to ICD-10 codes and conversion of EDI HIPAA X12N-4010 transactions to HIPAA X12N-5010 version. EHR, eMAR Medication Administration, EMR, Clinical View, eMAR Alert Monitor, Outreach Scheduling, Maintenance, Lab Collect/Receive, Patient Care, Lab Workbench Monitor and Audit

Responsibilities:

Assist in the creation and maintenance of test plans and individual test cases using approved standards, processes, and tools for common and simple projects. Assists in the evaluation of level of risk in determining the scope and coverage of the individual test plan(s).

Execute test cases, accurately documents defects using approved standards, processes and tools for common and moderately complex projects.

Tested web service validating request and response using SOAPUI

Experience in cerner product (Cerner PMO Office, Cerner Powerchart, Cerner Millennium, Cerner Radnet, Cerner Revenue cycle, Cerner FirstNet application, Cerner Schaappbook )

Handled Different ADT hL7 messages for ADT, Radiology order, Radiology results, cardiology Order, cardiology results, Isolation orders

All individual components of ICD-10 impacted modules and executing a test to accomplish the flow of ICD-10 data

Tested the EDI 820,834, 835 and 837 interfaces, developed test cases and test scripts for all 835, 837 Institutional and Professional HIPPA Transactions

Manually tested the Extensions in the application like Claims Entry, Claims Provider Cross-Reference, Clean Claim Date, Explanation Codes and Claims down Pay.

Assist in the creation of Test Suite. Test Group, Test session

We followed Verification testing, Validation testing,Regression testing

Acquire and maintain a basic understanding of the technical and functional architecture, security and compliance requirements of assigned systems and integration.

Investigate and assists in the resolution of common and simple issues, incidents, and problems. Collaboratively works with peers, internal and external stakeholders, and vendors.

Create and maintains basic database queries.

Assist in the creation of test harnesses, automation and performance testing frameworks.

Assist in the development and implementation of communication plans to all stakeholder groups (internal and external).

Environment: Java, Web Service XML, HTML, SQL Server, Java Gateway, Integrity,

PROFESSIONAL EXPERIENCE

Project : State of Michigan Pension System Lansing, MI Mar 2010 – Sep 2014

Role : QA Analyst /QA Lead

Description:

JClarety is a state-of-the-art pension administration product designed to help Pension retirement systems provide more timely and efficient member services by streamlining and automating business processes. JClarety application covers the full life cycle of the Michigan ORS member - from enrollment to final payment of all allowable benefits.

.Responsibilities:

Analyzing and reviewing the requirements, participate in the review workshops to get the understanding of the requirements.

Analyzed the Business needs and system requirements, Developed Test plan, Test cases and Traceability matrix and executed System,End to End, UAT and Regression testing both in Front and Back-ends Designed and developed Test Scenario’s for Black Box testing

Designed data driven tests in Quick Test Professional (QTP) /UFT script to validate with different sets of test data

Tested application response for positive and negative sets of data with data-driven testing procedures

Performed traceability using Quality center 11.5

Participated in Test Case Peer Review to ensure test cases are appropriately translated and mapped to the requirements

Executed test scripts in QC and generated test status report for daily defect status meeting.

Strong Experience with Backend & front end testing

Prepared and Presented weekly and monthly QA Defect and Status Reports to the different Stake holders of the project using QC. Maintained bug lists for critical issues using QC.

Tested various types for Schedule Batch jobs,

Verify the results after running the batch in screen and report.

Worked with the core development team in resolving issues

Providing estimation for the change request, client interaction for user acceptance testing.

Prepared QA test plan and estimations, designed test strategies and test scenarios Automated Test Scripts using Quick Test Professional 11.5 for Regression Testing

Performed FileNet testing

Maintain good relationships with customers, team members to get things done smoothly

Created Traceability Matrix to keep track of changes in requirement to that of the testing efforts

Environment:Java,jclarety,Web Service XML, HTML, SQL Server, Windows NT, QTP 11, Quality center 11.5

Client: State of Indiana Pension System Indianapolis, IN Dec 2007 – Feb 10

Role : QA Analyst

Description: PERF provides financial and retirement services to people in nearly all fields of public service to the state of Indiana and our municipalities. The system's members and beneficiaries receive direct payments through retirement, disability, and death benefit programs. Public employers are able to use PERF as a quality benefit to attract and retain workers.

Responsibilities:

Developing the test case, test script and Defect Log in Test Director 8.0.

Reviewed test cases prepared by team members.

Database Testing, Input error validation testing, Sanity Testing, Regression Testing, Data Migration had been performed

Preparation of Testing Over view document and Test Result Report document

Preparation of Daily Status Report and Weekly Status Report

Scheduled preparation and task allocation.

Handled multiple releases and attained Quality Product Delivery in each of the PDLC Phases

Tested various types for Schedule Batch jobs

Prepared and maintained the requirements traceability matrix

Interacted with Clients for Technical Assistance and Usability, User acceptance testing (UAT).

Worked with the core development team in resolving issues

Maintained and executed test scripts through the Quality center

Providing estimation for the change request, client interaction for user acceptance testing.

Automated Test Scripts using Quick Test Professional 10 for Business Process Testing and Regression Testing

Executed SQL statements to validate the data

Maintain good relationships with customers, team members to get things done smoothly

Perform Regression Testing on the entire function, find defects and communicate the same to the development team through Quality center

Environment: J2EE, jclarety, Web Service XML, HTML, SQL Server 2005, Oracle 10g/9i, Windows NT, QTP 9.5., Quality center

iSOFT Manchester-UK & Sydney-Australia Jan 2005 – Nov 07

Project : ORMIS - Operation Room Management Information Systems

Client : National Health service NHS (UK), QLD health Department (Australia)

Role : Sr.Quality Engineer

Description: ORMIS is a health care application that manages the patient episode from the first contact, through the waiting list, pre-operative, Operation and recovery stages. ORMIS provides online access to the patient data and update the procedure information through Touch Screen Clinical Data Interfaces (TSCDI) for Surgeons and Nursing Staffs. The patient info can be accessed and update with a PDA device, interfaced with the ORMIS application.

Responsibilities

Analyzed the Business needs and system requirements, Developed Test plan, Test cases and Traceability matrix and executed System,End to End, UAT and Regression testing both in Front and Back-ends Designed and developed Test Scenario’s for Black Box testing

Understand the scope and analyze the Requirement Specification.

Used Toad and SQL, to access and performed functional Database testing

Reviewed Test Cases & Release documents’ such as Release note, configuration guide, Schema guide.

Tested web service validating request and response using SOAPUI

Coordinating the team on their day to day activities, preparing the Test Strategy, Test Script plan, Test Plan

Had taken up the role of a SQA and was active participant of Software Quality Audits for various products

Prepare Project Plan for the Testing Phase using MPP

Produce Status Reports (Weekly and Daily), Bug Tracking, Daily Meetings with the Testing and Development Team

Implemented & Tailored iBLC (Business Life Cycle) in Project Management

Created Automation test scripts using Quick test pro 8.2 (QTP)

Writing and maintaining system integration test cases.

Got a Best Tester Award from CSC for finishing testing one time for all releases.

Providing estimation for the change request, client interaction for user acceptance testing (UAT).

Used Toad and SQL, to verify DB values were saved, updated, and retrieved correctly

Provided Tier-3 support to Local Service provider CSC in U.K and (QLD health service, Royal women’s hospital) Australia

Created XML by using schemas for HL7 message

Involved preparing various kinds of Metrics for Schedule Variance, Effort Variance, Defect Density, Defect Leakage

Updated the metrics sheet and verifying the metrics filled by Team members

Prepared various reports in excel sheets for Testing Objective, Work Allocation and Daily Tasks, Resource Utilization

Environment: .Net, C#, J2EE, C++, JavaScript, Web Service XML, HTML, SQL Server, Oracle 10g/9i, Windows NT, UNIX, Load Runner 7.6, QTP 8.2,Test Director 7.6, Crystal Reports,HL7

iSOFT (Manchester, UK) Mar 2004 – Dec 2004

Project : i.IE LORENZO - (Integration Engine)

Client : National Health service NHS (UK),

Role : Sr.Quality Engineer

Description:i.IE (Integration Engine) integrates an iSOFT system to any of the third party systems. The data transport is carried out using XML schemas based on HL 7 format. The messages are monitored and tracked using MSMQ interfaces. Various Test Harnesses are available to mimic the third party application in market. Generated sample XML to test and validate them against the HL7 schemas provided. Track the message traveling through series of queues during a transaction and the rules applied during its transformation. The request and response messages are validated using XML Spy against the schemas

Responsibilities

Prepared Test Plans, Test case and Test Estimation

Reviewed Test Cases & Release documents

Designed and developed test Scenario’s for Black Box testing

Logged the defects and coordinated with the development team

Tested test Web harness for Web-based applications using XML

Piloted & implemented iBLC (Business Life Cycle) in Project Management

Had taken up the role of a SQA and was actively carried out Software Quality Audits for the product.

Developed automation scripts for various modules using Quick test Professional QTP for Functional, System, regression and user acceptance testing

Writing and maintaining system integration test cases

Created Test Sets in Test Director to manage the Test Run Process

Used Toad and SQL, to access and performed functional Database testing

Participated in Installation when new release of application occurs

Performed Web Testing connecting various applications through the Web Services using XML based messaging

Produce Status Reports (Weekly and Daily), Bug Tracking, Daily Meetings with the Testing and Development Team

Environment : .Net, C#, J2EE, UNIX,SQL Server 2000, XML, MSMQ, Quick Test Professional 8.2 (QTP), Test Director, HL7

Botree Software J&J Mar 2003 – Mar 2004

The financial application is shared between HSBC Bank, Call centers and Collection centers for customer services. This application covers entry of Cash-In, Cash-out, Loan approvals, and Financial Cash-flow statements, Credit Cards, Personal Loans, Mortgage Loan Access and repayments. Defaulters are forwarded collection center for collections.

Responsibilities

Involved in testing like brokerage, mortgage loan access, auto loan, and wire transfer.

Performed System Testing for Overall Project Functionality

Performed Regression and Performance Testing

Identifying bugs, interacting with QA team leader and developers to resolve the issues

Involved in project implementation phases, closely monitored and interacted with clients production testing

Helped new team members to understand the Business requirements & system flow of the application

Used Toad and SQL, to access and performed functional Database testing

Modified Test cases when changes in the application on new build using Test Director

Monitored Test Director to close the bugs/cases as and when developers fixed the bugs

Environment : Visual Basic 6.0, SQL Server, Oracle 8i, Windows 98, Crystal Reports

Botree Software Nicholas Pharmaceuticals India Ltd & Dr.Reddy’s Mar 2001 – Mar 2003

Overview of the Project:

The Stock Automation System has the following modules: Customer Register,

Drug Register, Scheme Master, Supplier Register, Company Invoice, Billing, Sales Return, Account Receipts, Financial Accounting, etc. The software automates the operations of the pharmaceutical stock and allows suppliers access to online stock movement reports.

Role : Tester

Responsibilities

System Study, drafting SRS based on the URS

Communicating with Clients, Implementing and performing User xAcceptance Testing at the Client's site

Validated crystal reports outputs with the application.

Preparation of Test plans using Data flow and ER diagrams.

Interacted with clients for User acceptance testing.

Prepare Test Cases (Unit, Integration and System) based on the URS and SRS Integration Testing of multiple screens that are inter related/dependent in the application

Performance Test for Run-Time Execution, System Test for Overall Project Functionality

Link and Compatibility Testing, Regression Testing for Error Tracking against Cascading

Perform Smoke, Functional Testing, involved in Bug Life Cycle

The other types of testing include Interface Testing, Positive, Negative and Destructive Testing.

Environment : SQL Server, Oracle 8i, Delphi 5.0, Windows 98, Crystal Reports

Contact this candidate