Malathi

203-***-****

acpegx@r.postjobfree.com

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