QA (Automation, ETL, V&V Engineer) / RAJ GOVINDA

Email: adg7ya@r.postjobfree.com 214-***-**** Address: Coppell (Dallas county), TX 75019 Strong Technical System and Integration QA for complex architecture involved with various integrated systems (in-house and vendors), databases, servers, DataWareHouse etc., Profile Summary:

HealthCare Provider Experience:

Senior QA consultant, part of Agile Scrum team with 6 to 8 Developers, 1 Product Owner and 1 Scrum Master.

Participating in Scrum Daily Stand-up meetings and provide the status on task completed, task InProgress and impediments, if any.

Participating in Bi-Weekly Sprint Planning meetings and providing the capacity and effort for QA.

Participating in Bi-Weekly Back-log Grooming meetings and finalize acceptance criteria.

Participating in Bi-Weekly Sprint Retrospective meetings and analyze on improvement areas.

Updating Agile Scrum board using JIRA for the user stories assigned.

Reporting and tracking defects in JIRA and linking to the user stories.

Developing and Maintaining Test Strategy and Test Plan documents.

Developing and Maintaining Manual Test Cases and Automation Test Scripts in HP ALM or SmartBear QA Complete.

Developing and Maintaining Functional Libraries, Driver Script, Object Repository

(NameMapping), Data Sheets etc., in VB and JavaScript using HP UFT and SmartBear TestComplete respectively.

Developing and Maintaining Java class files using eclipse IDE and Selenium WebDriver JAR files to automate web applications (corp apps).

Expertise in creating application. Properties file and storing objects identified using ID, Name, Class Name, XPath and CSS Selector.

Setting up various Non-Prod environments like INT, TST and TRN.

Supporting UAT team.

Providing Signoff on QA for various RFC’s using service now.

Validating Practice management systems (front desk apps) and Electronic Health Record systems

(EHR/EMR).

Validating Occupational Medicine Line of Business, Worker’s Comp Injury Physician, Therapy and Specialist visits.

Validating CCM/CRM application, which stores customer data and carry forward the data to downstream applications.

Expertise in testing ETL workflows between systems or between databases.

Expertise in testing end to end ETL workflows from stage to source, source to EDW, EDW to DataMart and DataMart to Reporting tools (MicroStrategy Web or QLIKView).

Expertise in testing TIBCO BW EAR’s developed to integrate data between more than one system.

Expertise in testing backend data, by developing complex SQL queries or using JSON WSDL/SOAP Request and Response using SOAP UI.

Expertise in API validation.

Expertise in validating integrated vendor-based apps like FormFox, eScreen, MDscripts, FormMaiton etc.,

Expertise in validating bill package extraction, packaging bill package documents, aggregating bill packages and printing bill packages.

Expertise in validating .Net based apps used to develop vast rules engine runs every 10 sec and generates various forms electronically, fill the forms using mappings, deliver the forms to respective Employer or Payer or Program or MRO using Autocomm Definitions.

Expertise in validating Payer portal and PEARL dashboard used to store and display state forms, results or reports.

Expertise in Developing and Maintaining SQL queries in various databases like MS SQL Server, Oracle, Sybase etc.,

Expertise in executing Informatica PowerCenter Workflows in Workflow module.

Expertise in validating Informatica PowerCenter Workflows in Monitor module.

Expertise in understanding Informatica PowerCenter Workflows in Designer module.

Expertise in executing batch jobs using Putty and validating MFT share and files generation using WinSCP.

HealthCare Payer Experience:

Expertise in validating Pharmacy Benefit Management System (PBM).

Expertise in validating Data Extraction, Data Restructure, Prescription Drug Event, Explanation of Benefits and Transcription Letters.

Expertise in creating and validating B1 Paid claims, B2 Reversal claims, B3 Rebill claims, N1, N2 and N3 claims.

Expertise in validating claims at different phases like Deductible, Initial Benefits, Coverage Gap and Catastrophic.

Providing test estimations.

Reviewing Business Requirements and raising clarifications.

Having Test Case review with the stake holders.

Developing SQL queries to validate DataStage ETL jobs.

Executing and Monitoring DataStage ETL jobs for Core, Code and Claim tables.

Validating Control files, flat files, Kronos etc.,

Developing and Maintaining Test Strategy and Test Plan documents.

Reporting defects in JIRA.

Computer System Validation (CSV) Experience:

Performed a role as Independent Verification and Validation Engineer for a Class 3 Medical Device.

Reviewed SRS (User or Software Requirements and Specifications) document and raised clarifications.

Developed Master Test Plan with Good Documentation Practice (GDP).

Executed Test Scripts, with Test Protocol handy and provided signatures wherever is needed especially on footer of each page of Test Execution section.

Reviewed Test Execution outcome with QA Manager and classified the issues as Software Defects or Test Protocol Error.

Created and Maintained RTM (Requirements Trace Matrix) for every individual requirement from SRS.

Performed Clinical Trails.

Developed Simulators using Microsoft VC++ and LAB View tool.

Performed Risk Assessment.

Participated in peer reviews and walkthroughs on the Preliminary Test Approach, which contains high-level test conditions for verifying the software solution.

Handling entire process of testing artifacts for Verification and Validation with respect to the FDA standards 21 CFR Part 11.

Concluded the development of System test plan documents for the most important functionalities in SDS like PRU Graphical User Interface, Automated Response Monitor (ARM), Non-Invasive Blood Pressure (NIBP), SpO2 and Barcode.

Developed NIBP Software Simulator, HL7 Extract Tool using VC++ for 100% verification of NIBP Module Functionality.

Performed Volume testing, Stress testing and Load testing to verify the 100% functionality of class 3 medical device.

Design Verification Matrix (DVM) for requirements verified for feasibility studies.

Expertise in extracting the data using HL7 tool and validating the HL7 messages.

Involved in all Phases of SDLC

Actively involved in developing software verification for feasibility.

Hands on experience with FTP in uploading and downloading the files.

Volunteered for Clinical Trials happened at Ethicon Endo Surgery Inc.

Worked in close coordination with developers and business analysts in performance and failure analysis.

Worked on DOORS for the traceability matrix of all the work products. Please find below my experience, strengths and skills listed in a tabular view for better understanding. Professional Work Experience

Employer Name Designation Client Name Role Place Start Date End Date Cognizant Technology

Solutions US Corp.

Senior Test

Analyst

Concentra Health

Solutions Inc.

QA Consultant Addison, TX 07/08/2013 Currently

working here.

Walgreens/Catam

aran Rx

PBM QA

Consultant

Deerfield, IL 08/30/2011 06/30/2013

Strategic Resources

International Inc.

Programmer

Analyst

Walgreens PBM QA

Consultant

Deerfield, IL 08/09/2010 08/29/2011

Cognizant Technology

Solutions INDIA Pvt

Ltd.

Associate –

Projects

PEMCO

Insurance

Offshore QA

Lead

Chennai, INDIA 02/25/2008 07/23/2010

TATA Elxsi INDIA Pvt

Ltd.

Senior

Associate

Samsung Senior Tester Chennai, INDIA 08/22/2007 01/18/2008 HCL Technologies Ltd. Member

Technical Staff

Ethicon Endo

Surgery Inc.

Verification &

Validation

Engineer

Chennai, INDIA

Cincinnati, OH

08/09/2004 08/10/2007

CMC INIDA Pvt Ltd. Graduate

Apprentice

Trainee

Toyota Validation

Engineer

Hyderabad,

INDIA

10/22/2003 07/30/2004

Strengths

Good Listener Very Detail – Oriented Team Player Big Helper Collaborative Quick Grasper Communication Skills Versatile Responsible Focused Good Judgment Analytics

Dependable and Dedicated Leadership and Teamwork Creative Thinking Logical Thinking Skills/Knowledge/Expertise/Hands-on

Quality Assurance Agile Scrum Domain Tools Database/System Scripting Requirement

Analysis

User Stories HealthCare

Provider

Occupational

Medicine LOB

SmartBear

TestComplete

SQL Server SQL

Test Strategy/Test

Plan

Epic HealthCare

Payer

PBM/RxClaim

SmartBear QA

Complete

Oracle VB

Test Scenarios/Test

Cases

Sprint General

Insurance

HP ALM / HP UFT Sybase JavaScript

Test Execution Sprint Planning Class 3 Medical

Device

JIRA / Confluence

/ Bitbucket

Allscripts EMR (.Net

and SQL)

Java

Test Estimation Backlog Grooming Automobile Informatica Power Center

OccuSource Power

Builder

Object Repository

Functional Testing Stand-up Meeting Consumer

Electronics

DataStage PBM Name Mapping

Automation Test

Scripts

Sprint

Retrospective

QuerySurge Exceed Functional

Libraries

Automation Testing Putty FormMation (.Net) Driver Script Database Testing WinSCP PEARL Dashboard Data Sheets Integration Testing SQL Developer Employer Portal VC++ Interface Testing Sybase Central Payer Portal XML

API Testing

(SOAP/REST)

MS SQL Server FormFox JSON

ETL and DWH

Testing

TOAD eScreen

BI Reports Testing eclipse IDE SPNet / MedRisk

UAT

Testing/Support

Git Billing and Collection

System

Regression Testing Selenium Web

Driver

Mercury

Defects Reporting

and Closure

TIBCO BW MAAT

Load Testing QLIKView Referral Automation

Automation

Regression Testing

MicroStrategy

Web

PJ&A / M*Modal

PROD Data Analysis

/ BA

SOAP UI /

Postman

PROD Support Lab View

Operations Support Microsoft Visual

Studio

Setting up Test

Environments

Award & Recognition:

Awarded “Best Employee” for the years 2006, 2008, 2010 & 2012.

“Star Award” for getting maximum client appreciations at PEMCO and Catamaran RX.

Concentra Outstanding Achievement award received on Jan 2016 for successful implementation of Allscripts application across all the Concentra Urgent Centers in USA. Educational Qualification:

B.E. in Electrical and Electronics, Osmania University, Apr '03. Professional Certification/Training:

Certified ISTQB Professional.

Certified Core JAVA and J2EE from NIIT.

Certified CCP (Cognizant Certified professional) for General Insurance.

Brain Bench Certified SQL.

Certified HP Quality Center.

Certified QTP.

Completed HIPAA Online Training at CTS.

Contact this candidate