Yugandhar Venigalla
ablfdq@r.postjobfree.com
____________________________________________________________________________
__
SUMMARY:
. Over 10+ years of Professional experience in Software Quality
Assurance Methodologies and Testing with extensive experience in
performing Manual and Automation Testing.
. Experience in testing Healthcare, Insurance and Client-Server
applications on different environments.
. Strong knowledge of Software Development Life Cycle (SDLC) and QA
Methodologies.
. Expertise in Testing Mainframe Applications involving COBOL, DB2,
CICS, JCL, QMF, FILE-AID and MVS.
. Expertise in all HIPAA transactions (837I/P, 835, 270/271, 276/277,
834 and 278) and Code Sets experience. using Diamond tool.
. Having Experience in standards like ISO, CMM, RUP, EDI, HIPAA, HL7
standards.
. Expertise in testing of .NET and J2EE environments.
. Strong experience in developing Test Plans, Test Scripts and Test
cases using requirements and design documents while specifying Testing
Overview, Approach, Strategy, Scope, Roles and Responsibilities.
. Developed Test Cases and scripts for different HIPAA EDI ASC X12
Message Formats.
. Expertise in Health Care Epic Products like Cadence, Resolute, ADT,
RCSI, Epic Care and Prelude.
. Experienced in software analysis, Requirements Management, Quality
Assurance, Modeling, Configuration Management and Change Management.
. Extensive Experience in Installing and Configuring of Mercury Testing
Tools (Win Runner, Load Runner, QTP, Quality Center and Test Director)
and Rational Suite (Requisite Pro, Robot, Test Manager, Clear Quest
and Clear Case), Selenium and Diamond
. Involved in Rational Unified Process (RUP) to develop iterative and
detailed project management plans and schedules.
. Expertise in performing different types of Testing: White-Box Testing,
Black-box Testing, Load, Integration, System, Functional, Stress,
Volume, Performance, UAT and Regression Testing.
. Good understanding of RDBMS (Oracle, SQL Server, DB2 and DB2/400) &
UNIX shell scripts.
. Experience in Writing SQL Stored Procedures and Triggers for Business
applications to validate data
. Wrote Documentation including an Installation and User guide,
customized training presentations, technical specifications
customizing testing tool which has been used in the projects, input
forms for business users and various ancillary maintenance documents.
. Capable of working as an individual and also as a part of team.
TECHNICAL SKILLS:
Operating Systems : MS-DOS, UNIX, MVS, OS/400, Windows 9x/NT/2000/XP
and Linux
Languages : C, C++, COBOL, JCL, PERL, JAVA, SQL, PL/SQL, T-SQL,
Shell Scripting and TSL.
RDBMS : Oracle 8/8i/9i, MS SQL Server, MS Access and IBM DB2 &
DB2/400.
Web Technologies : HTML, DHTML, V.B Script, Tibco, ASP, Java Script,
Java Servlets, JSP
Web Server : Java Web Server, BE A Web Logic, IBM Web sphere,
Microsoft IIS
Packages : EPIC Products, Facets.
GUI Tools : Oracle Developer 2000 and V.B 6.0, Seagull Software-
GUI/400
Testing Tools : Mercury suite (Win Runner, Test Director, Load Runner,
QTP), f Tracker, Rational Suite (Requisite Pro, Robot, Test
Manager, Clear Quest, Clear Case)
Version Control : Visual Source safe, PVCS and Clear Case.
PROFESSIONAL EXPERIENCE:
Blue Shield of California, CA
Dec 09-Till date
Sr.QA tester
As a Software engineer/Senior QA tester, Involved in testing various
healthcare Mainframe applications and migration of plans from legacy system
to FACETS application. Involved in testing
Provider,Membership,Claims,Accumulators modules.
Responsibilities:
. Developed Test plans, Test cases and Test Scripts using Mercury Quality
Center.
. Extensive testing experience with Provider management, Claims
processing, Provider reimbursement and Claims adjudication.
. System Integration testing (SIT)was carried out and the SQL queries are
written for testing the retrieval of the data from the database and
tested the Procedures and Functions.
. Performed Backend Testing by writing SQL statements to review the
returned data to ensure that the correct data was retrieved.
. Interacted with programmers to identify and resolve technical issues.
. Participated in Walkthrough and defect report meetings periodically.
. Retested the fixed issue and done regression testing if necessary.
. Produced supporting documentations such as window/screen prints and
reports as requested to assist defect resolution.
Environment: Mercury Quality Center 8.2, Oracle 9i, Java, J2EE, JSP, MS-
Visio, MS-office, Facets, IBM Mainframes
Kaiser Permanente Health Insurance Denver CO /Emeryville, CA
July'07- Nov 2009
Sr. QA Tester
Description:
Kaiser Permanente is the largest nonprofit health plan in the United
States. KP- IT provides and coordinate the entire scope of care for KP-IT
members, including preventive care, well-baby and prenatal care,
immunizations, emergency care, screening diagnostics, hospital and medical
services, pharmacy services. As a Senior QA tester I had worked in a WIT
(Workflow Integration Testing) for the Inpatient, Outpatient, RCSI (Revenue
Capture Strategy Initiative), Resolute (Hospital Billing (HB), Professional
Billing), Claims, Pharmacy, Radiant, radiology orders, Lab orders modules
of EPIC Software Suite for Northern California region.
Responsibilities:
. Reviewed the requirements given by Application Coordinators (AC) for
the RCSI and Hospital Billing modules.
. Followed Rational Unified Process (RUP) throughout SDLC.
. Drafted the corresponding Test Case for the workflows given by
Business Application Coordinators.
. Modified the Test Cases as per Business and IT ACs and discuss the
changes and impacts on the application.
. Once the Test cases had signed off by ACs, we export them into Test
Director by adding the Description and Prerequisites.
. Tested Workflow integration between various EPIC Modules
. Developed Test Cases using Mercury Quality Center.
. Developed test cases based on requirements and visio flows.
. Worked with Unit Charge, Batch Charge, Payment Posting, Insurance
Payments and follow-up workflows.
. Involved in testing the various Interfaces in the application like
Inpatient for HB.
. Participated in validating various Tapestry services, Enrollment and
Member Records, ID Card Printing, Account Records, Referrals, Claims
. Execute manual testing of EPIC based applications running on AIX and
DB2.
. Design, development and execution of reusable and maintainable test
cases for regression test.
. Involved in HIPAA/EDI Medical Claims Analysis, Design, Implementation
and Documentation.
. Created test data for testing specific billing functionalities
. Tracked the defects using the Mercury Quality center.
. Worked closely with developers to resolve defects found in Hospital
Billing module
Environment: Mercury Quality center 9.0, Hyperspace, Hypertext, EPIC
product suite, HIPPA, HL-7, MS-Excel, Windows 2000 Pro, Oracle, MS-Visio,
Mainframes (COBOL, DB2, JCL, CICS, VSAM, FILE-AID), and UNIX.
Great-West Health Care, CO
Aug '06 - June'07
Senior QA Tester
Description:
Involved in testing effort of healthcare applications and working on
Patient Liability Extension, Claims, OON Pricing,Claim query
Screen,Expected payment,MARS extract,Reports Modules.. Also involved in a
project to verify the conversion of data from legacy systems to Trizetto
Facets.
Responsibilities:
. Involved in reviewing Business Requirements and Use Cases to manage
requirements.
. Involved in writing Test Plans, Test cases and developing Test scripts in
Quality Center.
. Performed end-to end testing on applications manually Using Quality
Center.
. Created Test Scripts for Premium calculation of Patient Liability
Extension and executed using Quality Center.
. Created Test Scripts for OON Pricing and executed by using Quality
Center.
. Performed manual and automated testing and maintain documentation on
different types of Testing viz., GUI, Regression, Integration, System,
Performance and User Acceptance testing.
. Involve with testing the loading of the Claim processing information
Data.
. Test the adjudication of Claims and Migration process.
. Tested the Mainframe screens.
. Created and modified test data using File-Aid.
. Validated the data on Mainframes.
. Tested the EDI/Hippa Transactions (270, 271, 835, and 837).
. Communicated inconsistencies between system specifications and test
results to development and/or analyst team.
. Performed regression testing of application for every new build
released.
. Automated the functionality using Quick Test Pro (QTP)
. Tracked the defects in Merant Tracker.
. Validated the mapping and integrity of data populated in the database.
. Evaluated the progress and take initiatives to meet the QA testing
targets.
Environment: Windows 2000, Linux, UNIX, TriZetto Facets 4.31, Merant
Tracker, Mainframes (DB2, JCL, File-Aid), Mercury Tools (Mercury Quality
Center, QTP 8.2), J2EE, Java script, XML, PL/SQL, Web logic and Oracle 8.1
United Health Group, MN
Jun '05 - July'06
Senior QA Tester
Description:
As a Senior QA tester, Involved in testing various healthcare
Mainframe applications and migration of plans from legacy system to FACETS
application. Involved in testing Provider, Membership,Provider Pricing,
Benefits, Claims and Product based applications and customer service
functionality.
Responsibilities:
. Developed Test plans, Test cases and Test Scripts using Mercury
Quality Center.
. Extensive testing experience with Members enrollment, Member services,
Premium billing, Provider management, Claims processing, Provider
reimbursement and Claims adjudication.
. Transaction testing was carried out and the SQL queries are written
for testing the retrieval of the data from the database and tested the
Procedures and Functions.
. Performed all phases of end-to-end testing which includes Functional,
Regression, GUI, System and Smoke testing of the application and its
interfaces Client-Server Utilities Prepared detailed Test Plan and
Test Cases by understanding the business logic and user requirements.
. Performed Backend Testing by writing SQL statements to review the
returned data to ensure that the correct data was retrieved.
. Tested the Web-Based Java applications.
. Tested the online programs and batch programs.
. Tested the Mainframe CICS Screens.
. Worked with JCL extensively to schedule and execute the jobs.
. Tested the database integrity by writing SQL Queries using QMF.
. Tested various menus, options and utilities.
. Created and modified test data using File-Aid.
. Validating of all the incoming/Outgoing data from EDI 837/835
interfaces.
. Developed test scripts for data driven tests using Mercury Quick Test
Pro.
. Involved in testing the Provider Conversion/config, Pricing and
Capitation configuration.
. Responsible for testing online processing for the new interfaces of
financial claim systems.
. Created Test Plans, Test Cases and Test Specification Document for the
application under test (AUT).
. Tracked defects in Mercury Quality Center.
. Build test scenarios and test cases (negative / positive) to validate
expected outcome
Environment: Mercury Quality Center 8.2, Oracle 8i, Java, J2EE, JSP, MS-
Visio, MS-office, Facets, IBM Mainframes System 360, OS/360, MVS, TSO,
ISPF, QMF, DB2, File-Aid, CICS, JCL, Endeavor, Tibco, QA Hiperstation, IBM
AIX Unix, IBM Lotus Notes and Windows 2000/NT.
Kaiser Permanente Health Insurance & Hospitals, Portland, OR
Sep'04-May'05
Sr. QA System Tester
Description:
K P is one of the largest health care Insurance and Hospital
organizations. The system implemented was the integrated suite from Epic
Systems Corporation and included Prelude, Cadence, ADT, Ambulatory,
Resolute, Epic Care.
Responsibilities:
. Developed Test Plan and overall Test Strategy for the applications.
. Developed Test Cases and Test Scripts for System and UAT Testing.
. Tested all applications End-End Manually.
. Involved in testing work flow integration of Cadence, Resolute, ADT
and Out-Patient.
. Involved in writing test scripts on Hospital billing and professional
billing of Resolute.
. Participated in Business Analysis, Requirement Analysis and Data
Analysis.
. Used Test Director for requirements management and for defect tracking
. Tested the Interfaces and management reports.
. Validated the reports and files according to HIPPA X12 enforced
standards
. Validated HL7 messages in Bridges.
. Tested the ADT and Ambulatory modules.
. Tested Workflow integration between various EPIC modules.
. Tested the User interfaces for the Health care web application
. Validated the batch production of documents and transaction-driven
documents.
. Tested the processing of claims in Diamond.
. Developed and executed various scripts using Win runner for automated
testing of each individual functionality of the applications
. Performed volume testing by transmitting batch files and validating
them.
. Recommending continuous process improvement, maintain QA standards and
artifacts.
. Validated the data by using SQL extensively.
. Worked with UNIX shell scripts.
. Developed Test Summary Reports and participated in GO / NO-GO
meetings.
. Tracked defects using Test Director & Conducted Bug-Review meetings.
. Coordinated with Business, Providers, Project Managers and Developers
Environment: Mercury suite (Test Director 8.0, Win Runner, QTP), IBM MQ
Series, Diamond tool, EPIC Products (Cadence, Resolute and Epic Care ADT
and Prelude), IBM Web Sphere, Windows NT/XP, MS SQL server, WS_FTP Pro
server and Citrix Products.
West Group, St.Paul, MN
July'02- Aug'04
QA Tester
Description:
As a Senior QA Tester for Westlaw at West Group, which is West's
online legal research service, which provides fast and easy access to an
extensive collection of legal resources, news, business, and public records
information. Involved in developing and executing Test Plans for sub
projects Online Idex, UDM Checkboxes, UDM Date Restrictions which are parts
of Westlaw. The system is customized to each user's specific needs, while
providing a common set of features to all users.
Responsibilities:
. Manage requirements using Requisite Pro.
. Analyzed the business requirements and wrote a Test Strategy and Test
Plan.
. Involved in the complete Software Development Life Cycle (SDLC) by
following Rational Unified process (RUP).
. Analyzed Functional specifications and requirement documents to
categorize the units in
. Created test Cases as per the business requirements and executed them.
. Developed Test Plans, Test Cases in Test Manager.
. Involved in writing and implementation of the various test cases and
test scripts.
. Conducted data pool tests with Robot.
. Generated automated scripts using Robot
. Performed database integrity check using SQL and Unix Shell Scripts.
. Interacted with developers, Business & Management Teams and End Users.
. Interacted with programmers to identify and resolve technical issues.
. Participated in Walkthrough and defect report meetings periodically.
. Developed SQL queries to extract data from the source tables.
. Version control and configuration management was done using Clear Case
. Extensively worked on Clear Quest for bug reporting/tracking.
. Involved in bug review meetings.
Environment: Java, J2EE, Oracle8.0, PL/SQL, TOAD, XML, Visual Source Safe,
Web logic, UNIX Shell Scripts, Windows 2000, Rational Suite 2003
(RequisitePro, Test Manager, Robot, Clear Quest, Clear Case), Selenium
Verizon Communications, VA
Sep'01 - Apr'02
QA Tester
Description:
As a QA Tester, Tested the Verizon Billing applications.
Responsibilities:
. Analyzed user requirements, setup test environment, prepared test
strategy and test cases.
. Participated in use case analysis and requirement analysis and
identify Gap between requirements and use cases.
. Managed requirements in Requirement Plan Manager of Test Director.
. Developed Test Plan, Test Case in Test Plan Manager of Test
Director.
. Conducted Requirements walkthrough with in the Testing team.
. Involved in Risk Analysis & Gap Analysis based on the requirements
. Tested the Web Services Interface with the Legacy Mainframes
System.
. Involved in integrations testing in implementing special features
like CMR, CSR, TTS and CTI.
. Validated data for billing of voice, data, and commerce services
using Amdocs enabler.
. Worked with function generator for quick and error free programs.
. Involved in functional testing of different Menu options.
. Involved in testing various billing applications developed in
AMDOCS.
. Developed Tractability between requirements and test cases.
. Extensively used SQL queries/Unix commands for data verification
and backend testing.
. Automated Test scripts using Win Runner for Regression Test.
. Worked with TSL functions and involved in synchronizing the Test
Scripts using WinRunner.
. Maintains the Test Environment means make sure all the Network &
Gateway provisioning processes / Shell scripts are up and running
. Attended weekly status meetings with Project management and team
members on testing update.
. Assign defects in defect manager of Test Director.
. Involved in End-to-End testing for Order Entry/Provisioning to
Invoice generation in BP.
. Executed all kind of scenarios for User Acceptance Testing.
. Maintained reports in Test Log Viewer.
Environment: Mainframes 3/390, JCL, IMS, DB2, TSO/ISPF, Windows NT,
Oracle8i, MS-Access, ASP, VB script, IIS, XML, Amdocs systems, HTML, Win
Runner 7.x, Test Director 7.x, Load Runner 7.x, PVCS Tracker.
MYM Trades& Channels LTD, Hyderabad, India
Jan'98 - Aug'01
Software engineer
Description:
This Application has been developed /tested for MYM Trades &Channels
ltd, manufacturers of Leaf Springs and Assemblies for Heavy / Light
Vehicles. It provides a complete Supply Chain Management System
encompassing the following Business Processes. Purchase, Stores, Work in
Progress and Dispatch. Application has been successfully completed and
client is implementing the same.
Responsibilities:
. Involved in every aspect of Project from the Beginning
. Entire coding part in Stores, Work in Progress was done by me
. Written all the Database Methods used in the entire Project
. Done Ground work for Reports
. Almost all client side validations in Java Script is done by me
. Developed test plans, which specify testing overview, approach,
strategy and roles.
. Designed and developed test cases, test procedure and test scenarios.
. Interacted with developers and DBAs regarding Y2K problem and defect
reports.
. Conducted performance testing, Integrity testing, and Functional
testing.
. Tested the application manually
. Performed testing to validate all the User Interface of the
application.
. Performed testing for tables and forms
Environment: Linux, Apache Server with Browser Clients, PERL, ASP, VB, CGI,
HTML, Java Script, Postgre SQL, Rational suite tools, Oracle 8i, CRYSTAL
Reports 5.0, UNIX (Sun OS 5.6), Windows 9x/NT, VB6.0, MS SQL Server.
Sujana Industries LTD, Hyderabad, India
Oct'95 -Dec'97
IT Assistant
Sujana Industries LTD(SIL) is one of the largest Bearing Industry in the
India. Involved in testing a store module to monitor fresh indent note
raised from various departments to Stores. Application updates central
department of stocks the same day material enters the factory. It also
tracks rejected material and updates central stocks. Testing of sub-module
to monitor stock level and generate receipt report after quality control on
coordination with indents, raised to update total holding stock as of date.
Responsibilities:
. Involved in writing backend procedures, using PL/SQL that would load
and retrieve data from the database.
. Involved in writing and implementation of the various test cases and
test scripts.
. Performed Manual Testing.
. Analyzing and documenting detailed program information working and
interacting with software developers and members of various other
dependent departments.
. Created Unix shell scripts to perform repeated Tests
. Analyzing User and Functional requirements to point out gaps between
them and the application
. Used Clear Quest for bug tracking and reporting, also followed up with
development team to verify bug fixes, and update bug status
. Performed System, Security & User Acceptance testing.
. Documented bugs found out during the process of testing.
. Reported periodic project status and updates to the QA Lead and QA
Manager
. Wrote SQL & PL/SQL queries for data validation.
EDUCATION:
Bachelor of Engineering, Bangalore University(India).