Aman Ghai
**********@*****.*** Contact No: 858-***-****
SUMMARY
• Over seven years of experience in QA testing of software systems in Client/Server and Web based
applications.
• Experience in reviewing business requirement documents, system requirement, and work flow diagrams.
• Experience in writing Test Plans, Test Cases and Test Procedures.
• Experience in execution of test cases to verify application functionality against business requirements,
and system requirements with automation testing using Rational and QTP, Quality Center.
• Experience in time bound implementations.
TESTING EXPERTISE
Manual testing on both Client-Server and Web-based applications, with multiple application server
domains.
Hands on experience with all phases of Software Development Life Cycle (SDLC) and Quality Assurance
methodologies
Prior experience testing on a Lab Information Management System
Sound knowledge in LIMS to ensure the highest level of efficiency, effectiveness, quality and
resource management.
Developed Test Strategy, Test Plan, Testing Process and Testing Needs
Involved in Writing Test plan, Test Cases, Create Test Data, Test Scenarios and Test Scripts
Experience in Business Analysis, System Analysis, and Project Management with strong understanding
of gathering business requirements, Business Process Flow, and Business Process
Excellent Presentation and communication skills compiled with a proficiency in problem abstraction,
Business Modeling, Business Process Flow and understanding Business Requirements and analyzing
components involved and translating into Use Case Requirement
Executed Test Scripts, Verified Test Results and Log Defects
Involved in functional testing, Smoke testing, System testing, Performance, stress, Load Testing,
database Testing, Black Box testing, White Box testing, User acceptance testing and regression testing
Gathering the Test Input data. Test Input data includes Pre-condition, Test Input, and Test Result data
Responsible for Test Methodology, Test Plans, Test Cases and Test Scripts on UNIX and Windows
platforms.
Experience in writing SQL Queries to query the database
Good understanding of Data integrity in relational database (RDBMS)
Excellent understanding of databases likes Oracle, MS-SQL Server, MS Access
TECHNICAL SKILLS:
C++, C, C#, SQL, TSL, ASP.Net, Java, SQA
Programming Languages Basic
Windows 95/98/2000/XP/NT, UNIX
Operating Systems
Microsoft Test Manager, Test Complete, LIMS,
Quick Test Pro 8.1,
Testing Tools 9.1., Win Runner, Rational Test Manager, Rational
Manual Tester
Quality Center 8.1, 9.1, Test Director. PVCS Tracker
Defect Tracking Tools Rational Clear quest
Ms-Office, MS-Excel, Visio, Ms Word, Ms Excel
MS-Suite
Database MySQL, SQL Server, MS-Access,Oracle
OTHER SKILLS
• Strong analytical problem solving, and conceptual skills
• Outstanding written and oral communication skills, extensive experience w/direct customer
• contact and presentation
• Time management skills to handle multiple business requests and the ability to prioritize to meet deadlines
• Excellent documentation skills to meet business requirements for the project.
PROFESSIONAL EXPERIENCE
MetLife, CA January 2012 – March 2013
QA Tester
MetLife, Inc. is a leading global provider of insurance, annuities and employee benefit programs, serving 90 million
customers.
• Developed system test plans for functional testing and regression testing.
• Prepared Test Cases with the complete description of requirements of client.
• Requirements actually are tested within the benefits, pricing and claims testing scope and loaded into
server.
• Developed datasheets (Test Scenarios) from scratch (template) or taken from a prior test release (claim
number, member number, and dates changed)
• User Requirements and Bug Management
• Devised, developed and executed various levels of test scripts like System and User Acceptance test
cases
• Executed the test scripts and ensure that the final outcomes of the tests are satisfactory
• Developed and implemented Back-End testing process like test plans and test scripts for Oracle based
databases using TOAD
• Performed System Integration, Regression, Security, Usability, Availability and User Acceptance testing.
• Developed SQL statements to query the Database for consistency of data and Data Quality.
Environment: Java, MS-SQL, Oracle and TOAD, JSP, Quality Center
Chase Financial Group, NY November 2010 – December 2011
QA Tester
The Chase Mortgage and Home Equity loan application was developed to provide and process loans and
mortgages for Chase Customers.
• Created, developed, and executed Test Cases and Test Plans on the basis of business
requirements.
• Analyzed business requirements to gather the business data for Credit Analysis and writing Test
Cases and Test Scripts based on the case diagrams
• Performed Testing on various Test Cycle dependent data complying with the required system as well as
the environment dates
• Used Test Complete to prioritize key test functions, test plan for coverage, control test execution
and reports.
• Interacted with developers for the modifications requests (MR).
• Conducted backend testing with Complex SQL queries.
• Involved in Functionality, System and end-to-end Regression testing during the various Phases of
the development using Test Complete.
• Involved in database testing using SQL commands for testing the performance of the
application.
• Performed positive/negative testing on Financial Analysis and Calculation Logic module
• Responsible for weekly status updates showing the progress of the testing effort and open issues
to be resolved.
Environment: Java, MS-SQL, Oracle and TOAD, JSP, Quality Center
Schering-Plough Corporation, Kenilworth, NJ July 2008 - October 2010
• QA Validation Test Engineer
•
Laboratory Information Management System (LIMS) Enhancement.
LIMS, a tracking and reporting, tool for the organization was enhanced with few more
functionalities to achieve organizational efficiencies in terms of its tracking, testing and also to meet
the regulatory requirements under HIPAA and IS9001, IS0 15189
• A member of assessment team to study the 21CFR requirements.
• Involved in developing and writing the Master Validation Test Plan in accordance with FDA regulations.
• Developed Requirements Traceability Matrix (RTM) to track requirements during the QA Testing Phase.
• Used Microsoft Test Manager to run manual tests, details test sessions, and automated tests from
a test plan.
• Used LIMS to ensure the highest level of efficiency, effectiveness, and quality.
• Verified data acquisition, data processing/approval, and Quality check and reporting using LIMS.
• Conducted Verification and Validation checks to ensure that the software meets the original design.
• Validated Quality Assurance policies and procedures for computer systems.
• Validated the system based upon on unique clinical trial requirements.
• Validated system for multiple clinical trial processes including electronic data capture (EDC), data
management, and adverse events reporting
• Validated the centralized data and reports generated though Clinical trial management solution
• Used Electronic Data Capture (EDC) system to test the clinical data in electronic format
• Performed final review of test data in accordance with standard operating procedures
• Reviewed reports to ensure that validation and procedures are consistent with FDA regulatory
requirements.
• Documented bugs found out during the process of testing using PVCS tracker
• Thoroughly documented test results to high level of standards of certification (FDA, ISO9000)
Environment / Tools: MS-SQL, Oracle, Quality Center
Blue Cross BlueShield, Washington DC August 2006 – June 2008
QA Analyst
BCBS gives the clear description of HealthCare plans to individuals or family and even to the group of employees.
We can also find plans for employers with multiple locations, international coverage with special products like Life,
Dental and Vision.
• Reviewed Functional Requirement Specifications and Software Design Documents for the application
• Involved in writing Manual Test cases and automation Test scripts for validating the application
• Manual and Automated testing in the LIMS environment testing on blood samples
• Utilized test manager for clinical samples to review the results.
• Created the Test cases for manual testing to check the functionality
• Conducted Functional testing using Mercury tools like Win Runner, responsible for Coordinating with
team
and resolving critical issues with development team.
• Conducted Smoke, Functional, Regression, and System & Integration testing of the application
• Performed various types of testing such as UI, Functional and Regression (Regression test is performed
using Mercury Win Runner
• Inserted checkpoints to check GUI objects, bitmaps, and databases and to check the response of the
application
• Reported the bugs to developers through Modification Requests (MR) using Test Director
• Responsible for writing SQL queries for accessing data from the Oracle database
• Status Reports: Daily and Weekly Status reports updates to the Team Lead, Test Groups and Test
Managers to Co-ordinate test cycles
Environment: Manual, Win Runner, Test Director, ASP, VB 6.0, Oracle 9i, SQL Server2000.
Global Hospitals HCIS (Health Care Information System), NY January 2005 – July 2006
Jr. QA Tester
The 3rd Generation HCIS (Health Care Information System) is comprehensive enterprise-wide software that covers all
aspects of management and operations of a hospital. It is designed to help achieve best clinical outcomes, optimal
financial performance and most importantly patient and employee satisfaction. This project includes 28 modules like
Registration, ADT, Lab, Wards, Phlebotomy, Blood Bank Discharge Summary etc.
• Involved in Manual Black Box Testing of the application
• Developed data flow diagrams for various systems
• Used LIMS for manual and electronic data entry and created reports in a specific format; schedule
and distribute reports to designated parties
• Developed Test Cases for various modules of the application
• Tracked testing activities and schedules
• Performed the Integration Testing and User Acceptance Testing
• Prepared the Bug Report using Excel
• Prepared weekly reports
EDUCATION
Master of Science, Punjab University, India
Bachelor of Science, Punjab University, India