Test Cases Quality
Resume:
Malathi
***********@*****.***
SUMMARY
6+ years of extensive QA/Testing Analyst experience in Internet and Intranet based
•
applications using Java, J2EE, VB Script, Visual Basic, ASP, .Net, Xml, HTML and
Oracle and Data warehousing Tools.
• Expertise in Manual & Automated testing of two-tier and three-tier applications.
• Expertise in documenting test scripts; Defect tracking and reporting; Collecting test
metrics; Maintaining trace ability of requirements.
• Knowledge in all phases of the software development life cycle (SDLC).
• Experience in Mercury Tools: Win Runner, Load Runner and Quick Test Pro
• Experience in Defect Tracking Tools: Test Director, Quality Center, ALM 11 & PVCS
Tracker, JIRA.
• Experience in testing methodologies, developing test plans, designing test cases and
executing test procedures.
• Experience in logging the defects using defect tracker HP ALM.
• Participate in the hardware and software development life cycle including business
analysis, systems analysis, applications development, and quality assurance.
• Skilled in performing: Integration, System, Functional, Regression, GUI and Web testing,
End-End testing.
• Very strong experience in Back End testing on various databases on different
Environments.
• Good Knowledge and excellent testing experience on data warehousing tools.
• Knowledge in all phases of the software development life cycle.
• Extensive work experience on databases: Oracle 8.x/8i/9i/10g, SQL Server 2000/7.0/6.x
and MS Access.
• Experience in Black Box testing Macros using VBA-Excel,Reconciliation
• Excellent communicative, interpersonal, intuitive and analytical skills
• Proven ability to work both independently and in team based environments accurate and
execution of given testing tasks on-time and within budget).
• Excellent mentoring and presentation skills.
EDUCATION
Master’s in science. (Andhra University, INDIA)
SKILLS
Operating Systems Sun Solaris, HP UNIX, Windows XP/NT/2000/98/95
Languages Known C, C++, Java, .Net, DHTML, SoapUI, XML, JSP, Perl, ASP.Net,
shell scripting, C#, JavaScript and VBScript SAP ABAP.
Databases Dbase, MS Access, Sybase, Oracle 8.x/9.x,/10g,11g, Informix,
Oracle Financial, HRMS,SQL Server, E-Business Suite,
Business Intelligence,
Web Technologies JDBC, EJB, Servlets, MTS, RMI, JSP, Web Logic, SharePoint,
Web Sphere, IIS and JWS
Defect Tracking Tools HP ALM, Quality center 9.0, 10.0 Rational Robot, Test Manager,
Scarab, PVCS tracker and Rational Clear Quest.
Testing Tools QTP 10, Performance center, business center, Rational Robot,
Quality Center 10.0, unit, Silk Test. Test Director
PROFESSIONAL EXPERIENCE
Bank of America, Charlotte, NC Jan’ 15- Till date
QA Analyst
Bank of America is a diversified financial services company providing banking, investments,
mortgage and consumer finance, Data deals with home mortgage service provided by Bank of
America. The mortgage application consisted of different modules, Hamp Tier 2, BK Enhanced
Loan Suppression, Palantir, NCL & TDR Enhancements Gen 3, Loss Mitigation, Tested
Reporting systems. On-boarding, Bulk, Delta, Daily and weekly data loads for various lines of
business.
Roles and Responsibilities:
• Involved in Defining, and Analyzing the Test Requirements based on the Application
Functionality.
• Involved in gathering business requirements, understanding the application.
Tested the ETL mappings output with the back end by writing test cases and SQL test scripts.
• Performed backend testing by validating data between source and target by developing SQL
scripts, and verifying stored procedures.
• Responsible for testing and reviewing of ETL mapping and transformation specifications based
on the business requirements from various teams and the business teams.
• Testing of ETL jobs that are scheduled for file transfers from Operational Data Stores to
designated file systems/directories.
• Used Toad and SQL Plus for testing execution of ETL Processes' PL/SQL procedures, packages
for business rules.
• End to end data validation, and functionality testing data warehouse projects using Informatics
ETL, Oracle Database, and reports.
• Exported Test Requirements and Test Cases from Excel to Quality Center.
• Performed System testing and Integration testing.
• Used Quality Center for generating Requirements, Test Sets, and Test Plan and for reporting
defects.
• Logged the defects in QC and retested the application after the defects are fixed.
Interacted with developers regarding priority of bugs and update the status of bugs once they are
fixed.
• Executed test cases before and after bug fixes for each build for User acceptance testing.
Environment:
Informatica Power Center 9.1.0, Power Connect, JAVA, C#, C++, .Net, TOAD, PL/SQL, Oracle
11g, Oracle designer.
The Northern Trust Bank, Chicago, IL Jun ‘11 –
oct’14 QA Analyst
The purpose of Basel II project is to create an international Standard that banking regulators can
use when creating regulations about how much capital banks need to put aside to guard against
the types of financial and operational risks banks face. The Basel II regulations require that we
create a system of stronger risk measurement, management and reporting.
The objective of the project is to provide a controlled, automated, centralized IT architecture
database where Basel II credit risk regulatory capital is derived from data source system extracts
which feed to a calculation (and reporting) engine which calculates and reports regulatory capital
.The end result is a consistent, timely, accurate, and automated mechanism that provides the
required data with appropriate control, governance and integrity.
Responsibilities:
• Tested various source systems for data validation and verification.
• Strong testing QA experience within both waterfall and Agile methodologies.
• Good understanding of agile software development lifecycle.
• Participating in the daily scrum meetings.
• Excellence in writing the test cases and test plan and executing them in ALM.
• Worked on SoapUi middle ware testing, and have good knowledge of web technologies
like web services, SoapUi, Xml, and Html.
• Involved in testing the data flow from source to targets as per mapping documents.
• Documented Test case for the source systems based on business requirements.
• Developed scripts in PL/SQl for retrieving data from source and target.
• Written Test Cases for ETL to compare Source and Target database systems.
• Reviewed cognos mappings and test cases before delivering to client.
• Executed System Test cases and System Integration Test cases.
• Assured software delivered meets all requirements and expectations of final UAT test
plan.
• Documented testing metrics and project feedback provided consultation to the Client
Coordinator on matters related to the Application.
• Extensively involved in executing and analyzing Test Plan, Test Lab, and Defect
Tracking using QC.
• Developed/Reviewed Test Plan, Test Strategy, Test Report, Test cases that are
traceable to software requirements.
• Reviewed and approved the Test cases written by team members by Using Quality
Center.
• Validated the outputs from source query and target query.
• Various Cash Management and Payment message verification using SWIFT Alliance
Access and Web platform.
• For Reports testing retrieved data from the UI and validating the same with data in
respective tables.
• Tested the Business Objects reports to WEBI to be viewed by all users on the internet.
• Involved in testing the data in System Test, System Integration, UAT environments.
• Manually performed back-end testing by writing SQL queries.
• Used Joins like Equi Join (Inner), Left Outer Join, Right Join, Group By, functions to
retrieve the database.
• Create SQL queries to validate the output of the Report using Rapid SQL.
• Mapped the test cases to the requirements (RTM), Created Traceability Matrix.
• Strong Knowledge in accounting, Foreign Exchange and have experience in exchange
rates and currency.
• Logged defects report using Quality Center and ALM.
• . Mapped the test cases to the requirements (RTM), Created Traceability Matrix.
Environment: SQL, Quality Center 9.2,ALM 11 version,Cognos tool, Rapid SQL 7.3.3, Share
Point, Business Objects XI R2/6, Rational Clear Case, Beyond Compare 3.1.3,SOAP UI
US BANK, PORTLAND, 0R Oct ’10 – May
‘11
QA TESTER
Involved in testing of the Credit Card application. This involves testing various front end
applications as well as the data stored in the back-end Mainframe system (ACAPS).
The Front end validation involves 4 screens…Application Introduction, Personal Info,
Spouse Info (For Wisconsin Residents) and Employment & Financial References.
The Application Introduction screen consists of the Information about various types Credit
Cards and their features like Terms and Conditions. Each Card has its own set of Terms
and Conditions. Involved in validating them.
All this data will be stored in the back-end Mainframe System called ACAPS (Automated
Credit Application Processing System). The data we enter from the front end will be
distributed across various panels in the ACAPS. Involved in checking the accuracy of the
data stored in ACAPS panels.
Responsibilities:
• Involved in the manual testing of the Application.
• Followed all US Bank Testing standards and Methodologies (RUP and AGILE) for
SDLC
• Performed functional and Navigation testing of the application
• Tested Web based, Mainframe and Client Server Applications.
• Tested Web page contents manually for different browser compatibility, performed Cross
Browser Testing
• Designed the Test Cases and participated in review Inspections.
• Developed Test Cases after analyzing the specifications Document.
• Extensively performed Batch testing, Functional, Integration, User Acceptance
testing.
• Designed the data for interpreting the positive/negative results.
• Conducted system and regression testing, debugged the software errors and interacted
with developers to resolve technical issues.
• Wrote test cases using the Functional Requirements as reference.
• Involved in the execution of Regression Test Scripts using QTP.
• Extensive use of SQL queries to perform Data Integrity testing.
• Imported data from the Database to the Data table and performed Data Driven Testing
with different Data.
• Used User-defined Error Codes wherever error messages are required.
• Involved in cross browser testing of the application
• Extensively involved in using Quality Center to report bugs.
• Monitored Quality Center to close the bugs as and when developers fix the bugs.
Environment: Quality Center 9.0, Developer 2000,JCL,TSO,ISPF,CICS, SQL, Oracle 8.0,
Visual Basic, Unix (HP-UX), Lotus Note, MS Office, Windows XP.
Sierra Atlantic Software Services Ltd. Lisle, IL Jan’09-Sep’10
QA Analyst
Sierra is A ERP based company .The product Nshore a project management tool with features
like workflows, deliverable driven projects, extended resource management, multi-site project
management, multi-level organization structure, invoicing, portfolio management, earned value
management. All the process management can be handled within the product and is easily
accessible web application with highly secured features.
Responsibilities
•, Quality center Analyzed systems design specifications and developed test plans, test
cases to cover overall quality assurance testing
• Played co-ordination role for defects tracking between test team and development team.
• Involved in both manual and automated testing. Performed black box testing
including smoke, regression, integration and functional testing.
• Performed web test using Quickest Pro for checking page contents, broken links, web
objects, frames and tables. Parameterize the scripts to run the scripts using varying form
data
• Developed/Reviewed Test Plan, Test Strategy, Test Report, Test cases that are
traceable to software requirements.
• Initiate, coordinate and implement the QA Process and SOA Methodologies.
• Used Test Director for Defect Tracking and Test Management.
• Involved in verification and validating the test cases/scripts.
• Performed Regression testing using QTP and Performance testing using Load Runner.
• Performed load testing using Load Runner and measured the response time under peak
load conditions.
• Extensively used Quality center, for test planning, bug tracking and reporting
• To review the test results by validating the web services output in XML.
Environment: SQL server 2000, c-sharp, VB.NET, ADO.NET, ASP.NET, Java, Web
Services,
XML, Windows NT, Virtual Network Computing.
Nendra sys technologies, India Apri’08 - Dec’08
Test Engineer
The Project is aimed to build an online store for Epson customers to shop online. Besides it
provides services like activate warranty, register a product, subscribe for Newsletter and promote
offers to customers online.
Responsibilities:
• Involved in whole life cycle of QA Methodologies starting from Planning, Capturing,
Creating, and Executing, Reporting and Tracking the defects.
• Developed and executed Test cases, Test Scripts based on the business requirements.
• Involved in Integration testing and Regression testing.
• Created and tracked the bug reports and interacted with development team to fix the
issues.
• User Acceptance testing (UAT) with 100% compliance with all end-to-end test
specifications.
• Prepare Release notes at the end of milestone.
Environment: ATG fat wire, ATG BCC, ATG CSC and i18 keys publishing.
Contact this candidate