QA Tester
Resume:
Kavita
*******@*****.***
Professional Profile:
• Over 6+ Years of experience in Software Design, Development and Testing Expertise in Designing and
Developing Test Plan Test Cases and Generating Test Scripts, Hands on experience in Software Quality
Assurance (SQA), Manual and Automated Testing .
• Experience in testing Web-Based Applications, ETL applications, and Client Server applications.
• Extensive work experience in System Testing, Functional, GUI, Database, Black Box Testing, System
Integration Testing, Regression Testing and User Acceptance Testing.
• Good Experience in Testing the Applications on UINX/Linux Environment and Unix/Linux Commands
& Shell Scripting
• Hands on experience with all phases of Software Development Life Cycle ( SDLC).
• Experience with industry standard methodologies like RUP (Rational Unified Process), Waterfall,
Agile/Scrum methodology and CMM (Capability Maturity Models) within the Software Development
Life Cycle.
• Experience in requirement analysis, Business analysis, use-case analysis, changes management and
configuration management.
• Extensive experience in implementing SQA Methodologies, test plans, test cases, test scenarios and
test deliverables
• Defect tracking and change management using Test Director, Quality center, Rational Clear Quest and
Jira.
• Attended scrum meeting(stand up) for status updates on the projects.
• Experience in working with different database like Oracle, DB2 and SQL Server.
• Experience in testing Web services and XML application with using SOAP UI.
• Expert in documentation using MS tools (Word, Excel, PPT, Project, Visio, and Access).
• Expertise in writing queries to retrieve data from database by using SQL.
• Possess excellent communication and Problem Solving skills and the ability to work as a team member,
as well as independently.
• Experience working with a wide range of applications in all phases on Testing.
• Known for ability to multi-task and work on different applications at the same time.
Technical Skills:
Testing Tools Test Director, Quality Center 10/11,ALM, Clear Quest,Jira,
Bugzilla, QTP10/11, Selenium and Load runner10
DWH Tools Informatica, and Business Objects
Languages C, C++, Java, VB, SQL,HTML and XML
Scripting Languages JavaScript, VBScript, PERL and Shell
Databases MS SQL Server, Oracle 8i/9i/10g, MS Access, and DB2
Operating Environments Windows, Linux, and Unix
Other Tools MSOffice, Testing Tools, Web Services, SOAP and TOAD
Project Experience:
CITI Group, GA(Remote) July’12 to Till Date
QA Tester --Manual and Automation
Description:
Citi's Global Consumer Banking (GCB) business is among the largest retail banks in the world.
GCB consists of five primary business units - Retail Banking, Citi Branded Cards, CitiMortgage, Citi
Commercial Bank and Retail Services - that operate in our four key global regions: North America, Latin
America, Europe, Middle East and Africa, and Asia Pacific.
Citi Banks Online services projects involve working on Citi online direct and Citi internal support site
projects. These projects need to monotonously monitor for their performances / daily enhancements and
for their daily payments schedule. There are different kinds of payments and generating payment reports.
Responsibilities:
• Reviewed the User Requirements Document, Functional Requirement Documents and Technical
Requirement Documents.
• Analyze and write detail specific requirements and test requirements using QC.
• Design and Execution of test suites/cases using QC for Testing
• Written the Test Plan, Test Cases, Test Scripts and Test Steps.
• Performed various Knowledge transfers and Presentations for Team Members in the Team.
• Attended daily status meetings as application used in Scrum and Agile methodology
• Functional testing using the Quick Test Professional tool.
• Tested the SOAP requests and responses using the tool called SOAPUI.
• Performed Interface, System, and Regression Testing both Manual and Automation on the mapping
functional components to ensure correct operation.
• Performed back-end testing using SQL queries to make sure that data entered correctly into the
Oracle Database.
• This project involved doing Black box testing including functional, System testing, Integration
testing, Compatibility testing across platforms on Windows, UNIX/Linux .
• Connected remotely to UNIX servers using Putty/WinSCP and FTP files across different test
environments by using Command prompt.
• Updated and created parameter files using vi editor.
• Reviewed Error log files in UNIX box when order fails to load into SQL tables.
• For each build generated the Test Execution Reports and Graphs.
• Involved in the Integration Testing, System Testing, UAT Testing, Regression Testing
• Understood and studied all the uses cases and executed those in the QC.
• Used tools effectively for Defect Logging and Defect Tracking.
• Created and executed Test cases for verification of any Server Configurations.
• Performed Test Data Management using SQL tables.
• Performed Web Services /API testing.
• Executed and updated QTP UI regression scripts.
Environment: QTP 10.0, Quality Center 10, Oracle, DB2, TOAD, XML, JAVA, Windows, and
UNIX/Linux, Web Services
Guardian Life Insurance, NYC Jan’11 to June’12
QA Analyst
Description:
The Guardian Life Insurance Company of America and its subsidiaries sell life, long term care insurance,
disability income, offer 401(k), annuities and other financial products for Individuals and Group.
Guardian owns several independent subsidiaries. Among the largest and most visible are The Guardian
Insurance & Annuity Company, Inc.; Berkshire Life Insurance Company of America; Park Avenue
Securities LLC; and RS Investment Management Co. LLC.
The Objective of this project (Agent Compensation) is to replace existing compensation calculating
system which is in mainframe with a new third party application (Varicent) for the Agency compensation
calculations. Data from the different source will import to the Varicent application tables and calculation
will run through Varicent application. Output data will produce using web forms, reports and outbound
files.
Responsibilities:
• Involved in Internal Review, Tech Review and Walkthrough of the Test Procedures with the
Developers, Requirement Management, Testers and Project Quality personnel.
• Involved in writing test procedures, test cases and describe the purpose of the test, setup conditions,
test conditions needed to produce the pass/fail criteria, and specific instructions on how to conduct the
test.
• Creating test case and test sets, tracing them to requirements and executing them in Quality center.
• Compared the data from Source system (DB2) to target system (SQL Server) after Informatica
workflows ran.
• Analyzing the ETL process created in Informatica and developed SQL queries to validate the data
from the source to the target tables.
• Querying data from different database tables as per the requirement and executing the SQL queries.
• Experienced in navigating the UNIX/LINUX system when executing the commands .
• Tested the application on Unix/Linux Environment when navigating the system with UNIX
commands and Shell scripts.
• Performed the system integration testing which validate the data is mapped correctly which provides
a qualitative check of overall data flow up and deposited correctly in Target Tables.
• Developed the test cases to test functionality, interface of the web application and web reports.
• Executed the test cases for the web application and web reports.
• Tested the application utilizing the Scrum (Agile) methodology.
• Tested the outbound files which are created by the Varicent application after compensation
calculations are done and compared with the files created from the existing mainframe system.
• Categorized bugs based on the severity and interfaced with developers to resolve them.
• Used Clear Quest for the bug tracking, and assigning the defects to developer then performed
regression testing once code is fixed.
Environment: Quality Center 10, Clear Quest, DB2, SQL Server, JAVA, Main Frames, WinNT, and
UNIX.
AXA Equitable, NY Nov’08 to Dec’10
QA Tester
Description:
AXA Equitable has been providing millions of customers with life insurance, annuities and other needs-
based products. Data warehouse will maintain the information of Policies, Products, Agents and
Commissions. Data is used for help the management query, analyze and make decisions on commissions
paid to agents and products.
For COIL (Corporate Owned Life Incentive new product from AXA) project which has different
interfaces like Accounting, Sales, Commissions and Prior Insurance.
Responsibilities:
• Reviewed the User Requirements Document, Functional Requirement Documents and Technical
Requirement Documents.
• Analyzed user business requirements and converted those requirements into functional specifications.
• Participated in System Requirements Review, Design Review, and Production Readiness Review.
• Leading the team of five members.
• Involved in Internal Review, Tech Review and Walkthrough of the Test Procedures with the
Developers, Requirement Management, Testers and Project Quality personnel.
• Involved in writing test procedures, test cases and describe the purpose of the test, setup conditions,
test conditions needed to produce the pass/fail criteria, and specific instructions on how to conduct the
test.
• Wrote test conditions for positive and negative test cases, to verify that the software works as
intended and that it will respond properly when presented with erroneous conditions.
• Responsible for writing Test Cases in Quality center.
• Worked as ETL QA Analyst responsible for the requirements / ETL Analysis, ETL Testing and
designing of the flow and the logic for the Data warehouse project.
• Created, maintained and executed test procedures and test scripts using Quality center.
• Worked with developers to communicate regarding issues in the application.
• Compared the data from target system to Source systems after Informatica workflows ran.
• Wrote PL/SQL scripts to verify the database updates, inserts and deletes of the records.
• Performed the Unit Testing and smoke testing which validate the data is mapped correctly which
provides a qualitative check of overall data flow up and deposited correctly in Target Tables.
• Performed the Data Driven tests that deal with different sets of data.
• Written generic functions in compiled modules that are reusable in different parts of the application.
• Developed the test cases to test functionality, interface of the application
• Categorized bugs based on the severity and interfaced with developers to resolve them.
• Performed data validation between various systems and drive changes that ensure the integrity of
data, along with creation and consolidation of reports.
Environment: Informatica 8.1, Quality Center 9.0, Oracle 9i, Toad, SQL Server 2000, WinNT,
UNIX, Main Frames, and COBAL.
PENNDOT, Harrisburg, PA Mar’07 to Sep’08
Deloitte Consulting
QA Tester
Description:
Pennsylvania Department of Transportation has implemented a (.centric) to redesign the Safety
Administrations Driver Licensing and Motor Vehicle Computer Systems by replacing the existing Safety
Administration Legacy System i.e., the order processing and Inventory Control Systems (TOPICS). The
project .centric enhances and redesigns the way the Business Partners and Customers conducts business
with PennDOT. .centric will be implemented in different phases for Drivers Licensing system, Motor
Vehicles and Sanctioning
Responsibilities:
• Involved in the creation of the Requirement Traceability Matrix and the Test procedure for various
modules of .centric.
• Involved in the documentation of various modules.
• Involved in the creation of Test Plan and execution of test cases for Entity Administration, Inventory
Management and Financial Administration and EDMS (Electronic Data Management System)
modules based on SRS and DSD.
• Involved in the Unit Testing, System Testing and User Acceptance Testing (UAT) of .centric
application.
• Written the Test cases in Excel sheet and imported to Quality Center.
• Created Identity Manager Test Plan and executed Test Cases in Test Lab for Security Roles.
• Created and modified the Test Scripts with the help of requirements and use cases provided by
Business personnel.
• Analyzed, documented and maintained Test Results and Test Logs in Clear Quest.
• Used SQL tools like TOAD to run SQL queries and validate the data in warehouse and mart
• Participated in team meetings to discuss the issues after execution of Test Scenarios.
• Involved in fixing invalid mappings, testing of Stored Procedures and Functions, Unit and Integrating
testing of Informatica Sessions, Batches and the Target Data
• Using Black box test validated the system functions of mappings against customer requirements.
• Developed VB scripts for reusable functionality using Quick Test Pro.
• Interacted with developers for status of the bugs and re-tested the fixed Bugs.
• Executed Batches and Reports using Business Objects
• Extracted Log Files for defects using Web sphere Application Server.
• Maintained and updated Test metrics on build basis along with defects summary.
• Involved in the Performance Testing of the application using Load Runner.
• Performed Regression Testing after the defects are fixed.
Environment: Mercury Quality center 9.1,QTP,Clear Quest, JAVA, JSP,J2EE, Java Script, SQL
Server 2005, TOAD,MS Office, WAS Server, Business Objects, Requisite Pro, iRise,
Erwin
Educational Qualifications:
Bachelors of Science from Osmania University, India.
PGDCA ( Post Graduate Diploma in Computer Applications), India.
Contact this candidate