Data Project
Resume:
Parshu Khanal
*************@*****.***
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