Parshu Khanal

214-***-****

ac8axi@r.postjobfree.com

US Citizen

Professional Summary

* ***** ** ** ********** in Testing and Analyst in Web based application, Client Server application, and desktop application

Expertise in multiple testing including; Smoke, Functional, Integration, System, UI, Front end and Back end

Solid experience of Agile, Waterfall Methodologies, and Scrum processes

Excellent experience in HP ALM, TFS, MTM, MS-SQL and Quick Test Professional (QTP), JIRA, SharePoint, Soap UI and FileZilla

Develop UAT Test Plan, Create test case and execute scripts with different data sets and document test results

Hand on experience in Software Development Life Cycle (SDLC) as well as Software Testing Life (STLC) and Role of QA in different testing mythologies like Agile, Scrum and Waterfall etc

Validate front end and back end data, Prepare data for testing purpose

Experienced in QTP–VB Script programming standards, developed reusable functional libraries, reusable script, enhance script

Hand on experience on ETL (Informatica and SSRS), Mainframe Testing, HP 300 and SharePoint Portal

Worked heavily on testing various ETL process as well as many reports developed in BI tools.

Involved with every phases of the life cycle development project, maintenance & production support project, QA environment, UAT environment and continually provided value-added services to the clients

Excellent Organization, Analytical and Problem-solving Skill, ability to quickly learn new technologies, handle multiple tasks and work independently as well as in a team

Communicate project testing status, risk, issue to leadership and peers

Proven ability in Working individually or as a part of team, Problem solving, Process improvement activities, Analytical skills, Reporting and Assisting to Manager

Veritiv Corp

Carrollton, TX July 2016 - Present

Project: E-Commerce, ETL, data Migration

Sr QA Analyst

Veritiv Corp is a full-Service strategic distribution company offering Business-To-Business solution including packaging, print and paper, publishing, facility solutions and logistics. Actively involved in testing of E-commerce sites, ETL, data migration during the Migration process.

Executed Test estimation, Reviewed BRDs, communicated Business Analysts for understanding of requirements, business rules and followed Agile methodology

Extensively Write test scenario, test set and test Cases for ETL to compare Source and Target database systems

Performed smoke testing, Sanity testing, Regression Testing, End to End Testing and System Testing

Updated existing Regression Test cases for impacted features due to new features.

Testing thoroughly each feature of create order, place an order, order processing, deliver the Order and Invoicing processing

Expensively executed test cases, validate test results and determine defects

Reported issues in the bug reporting system and follow up with the development team

Participate in Agile planning, review and test development from the user story

Performed back-end testing using SQL queries to make sure that data entered has been uploaded correctly into the backend database

Hand on experience on testing at the Service layer with SoapUI

Validated request and response XML against the database

Trained Testing process and ALM tool for junior team members

Tested all the ETL processes developed for fetching data from OLTP systems to the target (Data Mart) using complex SQL queries

Validate the data against the business rules and requirements and verify that the transformed data can loaded without any loss of information.

Performed data validation and Data Migration Testing during the Migration process

Attended daily/weekly status meeting, review meetings, test case review meeting Requirement Traceability Matrix and Defect management

Coordinated UAT with Business Users for all releases and archived test results and user signoff

Environment: HP ALM, HP 3000, Oracle, SSIS, SQL Server, SharePoint, JIRA, ServiceNow, Service+, Windows 7, SSMS, MS Office, SoapUI, Outlook, Jabber, Smart Sheet, BI4 Report,

Cognosante

McLean, VA Jan 2015 – May 2016

Project: Market Place (Healthcare)

QA Analyst/Tester

Cognosante assists the States and Federal to provide project management support and oversight during the design, development and implementation phase of integrated eligibility systems project which includes implementation of EDI transaction, Enrollment Resolution and Reconciliation process for health insurance exchanges.

Analyzed Test Design, Mapping Documents, test estimation and test closure

Generated test plan, test scenario and test script, executed and log defects

Actively worked on EDI transactions and on the reconciliation processes.

Validated the EDI Transaction HIPPA X12 834 for health insurance exchanges and performing root cause analysis.

Design, development and implementation of an Enrollment Resolution and Reconciliation process for health

Analysis of discrepancies in the eligibility reconciliation process

Extracted the data from different sources base on scenario and analyst them and trigger the matrix base on requirement, business rules

Tested with Premium Payment transactions, start date and end date discrepancy with MIDA and EDBO FFM and Issuer Data

Validated the enrollment reconciliation process conciliation with CMS and CEERS if any discrepancy occurs

Generated the report using ISSRS and validate with the database

Analyzed of discrepancies in the eligibility reconciliation process for multiple stakeholder’s continuous process improvement of the reconciliation process

Actively worked on SharePoint portal to update the case status, Run the job and track the log file and analyst the root cause

Update the project progress report in share drive and walkthrough with the client.

Attended daily/weekly status meeting, review meetings, defect meeting and new release meeting

Defects tracking, review, analysis and compares results, communicate to the developer

Environment: Oracle, MTM, .Net, Java, MS Office (Word, Excel, Power Point) SharePoint, Alter Editor, Marco, SSRS, SQL Server, SSMS, HICS (CMS), Transaction Management, FileZilla

CVS Caremark

Tampa, FL Feb 2014 – Nov 2014

Project: Pharmaceutical (Medicare/Medicaid)

Functional Test Analyst (UAT)

CVS Pharmacy provides service for Medicare and Medicare member through Government-sponsored Prescription Drug plan. This would help health insurance with its Membership enrollment and Management Information Tracking System, Finance and Utilization management System modules, which integrate directly with FAZAL and FACETS.

Developed and executed test strategies and plans for various testing types and levels for Medicare/Medicaid enrollment process

Analyzed Design documents, BRD, FRS, Requirements, use cases and Mapping Documents

Involved in testing of Facets Implementation, Tested end to end testing of FACETS Membership and benefits module

Validated different type of enrollment plan, benefit and Duplicate member in Facets, FAZAL front end with Oracle and MS SQL database

Developed and executed DM46/ Online Electronic Control/ Manual enrollment Process as per plan and loaded member into FAZAL.

Enrolled the Member through DM46 file and land it in incomplete Queue (Dup Queue, CMS Queue, Fail Queue, OPS Queue, Denial Queue and Hold Queue) as per scenario

Updated the necessary details of member and process it to complete status

Coordinates with internal and external customers to ensure the documentation, implementation, and modification of benefit plans is completed on a timely basis

Prepared and coordinated execution schedule for jobs related to Parallel Testing, SIT/UAT and End to End Testing

Worked effectively on Member/Subscriber Benefit in Facets and functionality of new features, new enrollment, enhancements and Data validation in Facet

Update project report in SharePoint folder and communicate with Business and User for approval

Extensively used SQL statements to query the Oracle Database for Data Validation and Data Integrity

Used HP Quality Center to document issues found during testing and prioritized the defects for resolution in coordination with the development team

Walk-thru the test results to business/operations team, Client and provide release sign-off.

Environment: Oracle, FAZAL .Net, Java, HP ALM, Mainframe, MS Office, SharePoint, Alter Editor, SQL Server Facets, SQL Developer,

Bank of America

Fort Worth, TX Jan 2013 – Dec 2013

Project: Mortgage Application

QA Test Analyst

The Web base application allows Loan Administrator and business units to generate the correspondence loan process. The application merges data from the AS400 onto MS Word letter and gives the user the ability to enter information when required. It utilizes HP Extreme Dialogue as composition engine.

Executed daily activities of test planning, test design, test scenario, test data development, test environment configuration, test execution schedule in UAT Environment

Validated CGS, HVILA and ILA letter template in LMS application and validate the records in different servers

Validated Job status in Cass, resubmit the Job and review the log files for Job errors and troubleshoot them as needed

Executed assigned quality control and quality assurance audit activities.

Assists in the preparation and conduction of Quality Control routines to assist project objectives

Monitored the jobs and ensure all are processed and send to vendor printed without error.

Determined type of error and escalates. Such as System error, Template errors and Data errors

Ensured archiving process takes place as expected, escalates issues to MST when required.

Assist senior staff, providing resolution on projects to enhance

Developed and executed queries to verify backend functionality and validate data front end and back end using MS-SQL

Communicated with test team, project team and business partners for issues/errors depending on severity.

Validated, extract the data from Production, staging Database and update the BCMR ticket in SharePoint

Maintained the test logs, test reports, test issues, defect tracking using TFS

Attended daily/weekly status meeting, review meetings, defect meeting and new release meeting.

Coordinated with Team lead, project manager, BA, LOB, CDT, MST, on boarding Team, Tech team and Vendor

Environment: Mainframe, COBOL, JCL, DB2, SQL Server 2008, Java, .Net, XML, Calyx Point, MS Office, AS400, SharePoint, TFS, MS-SQL, DB2, .Net, JIRA

Anthem

Alexandria, VA April 2011 – Nov 2012

Project: Healthcare Application

QA /ETL Tester (Manual/Automation)

Anthem Health Plans provide complete healthcare solution and management information system for managed healthcare. This would help health insurance with its Membership and Claims Management Information Tracking System, Finance and utilization management system modules, which integrate directly with Facets.

Participated reviewing Business Requirements, Functional and Technical specifications with business analyst and defined the testing approach and resources and time lines

Coordinated with other team members and conducted the weekly status meeting to make sure the all team members are on the same page

Actively involved in Functional, Regression, System, Smoke, End to End and Integration Testing

Mapped the Requirements to Test Cases, ensured that all requirements are covered using RTM and HP QC

Attended sprint plan meetings to review the user stories closely with Business Analysts and Developers

Uploaded Business requirements, test scenarios, test cases and defects to QC

Tested functionality of new features, Benefit testing, Validation, new enrollment in Facets

Performed Web Services request and response XML using SOAPUI, Update the end point in WSDL file as needed

Developed and executed SQL joint to validate Test data results in Web Services and Frond end with Database

Created Project, Module and specific testing level Recovery Scenario and trigger them as required in QTP

Executed Batch Mode and Master file, communicated with Technical architects and DBA for the performance of test results

Utilizing Dictionary object in QTP, Maintaining Test data in Excel files and Importing Excel files from Resources module in Quality center to QTP data table and read the values based on the functional requirement

Analyzed functionality of X12 Transaction and validated 270, 271, 820, 834 transaction

Performed ETL Informatica mappings and other ETL Processes (Data Warehouse Testing) using SQL.

Tested the messages published by ETL tool and data extracted from and loaded into various databases

Performed data validation according to data mapping document with data conversion logics from source system and target system

Aggregated the data at source and compared with the Target to validate Transformations

Attended QA Walkthrough meetings with team member this includes technical Specification review, Functional Specification review and defect tracking

Generated test execution reports, get sign off and uploaded documents in share drive

Environment: Java, Oracle, MS SQL Server, Facets, Informatica, Soap UI, Quick Test Professional (QTP), HP QC, XML, Linux, JIRA, MS Office, SQL Developer

Education

Bachelor of Science (Tribhuvan University, Nepal 1995)

Contact this candidate