Quality Testing

Malar Kalaikumar

Email: ***********@*****.***

Phone: 803-***-****

Professional Summary:

• Over 8 years of extensive experience in system analysis, design, and Testing/Quality Assurance of client/server and web based

applications.

• Over 6 years of experience in Quality Center.

• 5 years’ experience in developing and executing SQL statements, which includes all joins in both production and development

environment.

• 4+ years of experience in Data Warehousing/ ETL Testing within the environment of Oracle, SQL Server, Informatica Power

Center.

• 2 years’ experience in Automation Testing Tool called IBM Rational Integration Tester (GH Tester).

• 1 year experience in QTP.

• Extensive experience in investment banking, International banking and corresponding banking.

• Extensive experience in SWIFT messaging and web services.

• Expertise in developing Test Plans, Test-Case Designs, and Test Scripting based on Application, User Needs, specifications and

System’s Needs.

• Performs all aspects of software testing, including testing of Graphical User-Interfaces (GUI) and application functionality.

• Experience working in an Agile/Scrum development and Waterfall environment.

• Proficient in working independently on major technology initiatives. Good verbal and written communication, interpersonal,

planning and organizational skills. I am also a fast learner.

• Ability to perform effectively and efficiently in a team and individually.

• Excellent Documentation and Communication skills, willingness to learn the latest cutting edge technologies.

Technical Skills:

Operating Systems: Windows 7, UNIX.

Automatic Test Tool: IBM Rational Integration Tester (Green Hat) and ALM 11.

Database: MS-Access, Oracle 8.0 and SQL server.

Version Control Tools: Microsoft Visual Source Safe.

Professional Experience:

Wells Fargo, Charlotte, NC Mar 2014 – Current

QA Analyst

Currently working on a project, ‘AFFIRM for Annuities’, which is the internal working title for the initiative to replace EBIX/Annuity Net,

the front-end order entry application used by financial advisors to initiate annuities.

1 Responsibilities:

• Participating in a daily Agile Scrum meeting and providing the testing status.

• Testing tx103 file formatted correctly, which created after trade submitted and compare with App sub file.

• Experience in Metadata and Star schema/Snowflake schema. Analyzed Source Systems, Staging area, Fact and Dimension tables

in Target D/W.

• Testing ETL applications in relational databases, XML files and flat files using Informatica Power Center and involving in the

report generation of BI systems using OBIEE

• Testing the files and make sure it is processed and loaded correctly in the database table.

• Develop test scripts and test cases for dashboards and reports being developed in OBIEE.

• Testing for API calls of SOAP XML using Service Tester for Brokerage Account, Fund, License and Appointment and Trade

Summary validations.

Malar Kalaikumar

Email: ***********@*****.***

Phone: 803-***-****

• For regression testing for API calls of SOAP XML, using IBM Rational Integration Tester (Green Hat Tester) for Brokerage

Account, Fund, License and Appointment and Trade Summary validations.

• Testing web service call to RIF for when a trade is submitted.

Environment: Window 7, Microsoft Office, Oracle, ALM 11.0, IBM Rational Integration Tester (Green Hat), Informatica Power Center,

OBIEE, Version One, and Mainframe.

PHH Mortgage, Mount Laurel, NJ Sep 2013 – Feb 2014

QA Analyst

I was working on Loan origination application, which is based on new customer details, including personal information, credit processing,

information forwarding to underwriting and completion of the Loan process. I am part of the ‘ MLA Enhancements’ Project, which is

primarily developed to have the Approvers perform the approvals through Mobile devices including Android Phones and Tablets,

IPhone, iPad and Blackberry. The primary goal was to reduce the waiting time for the approvals and the approvers could do the approval

on the go.

2

1 Responsibilities:

• Reviewing residential loan application to verify that application data is complete and meets establishment standards, including

type and amount of mortgage, borrower assets, liabilities and length of employment.

• QA Functional test Execution of Test cases in various Mobile devices IPAD, IPHONE, Blackberry and Android phones and

tablets.

• Security Testing in Mobile devices (IPAD, IPHONE, Blackberry and Android phones).

• Testing the application in Android using Emulator.

• Identifying and preparing test data for Mobile Application testing.

• Hands-on testing Web, Mobile application running on Cloud with multiple browsers.

• Testing the application under different networks and Internet speeds including while on EDGE, 3G, 4G, LTE, and Wi-Fi.

Environment: Window 7, Microsoft office, SQL Developer, Android and iOS emulators and ALM

Wells Fargo, Charlotte, NC Feb 2013 – May 2013

QA Analyst

This project is to implement Core FX functionality in support of International Treasury and Foreign Exchange trading, sales and

operations requirements for dealing foreign exchange (FX) and money market (MM) transactions in the WFBNA London branch and

Wells Fargo Securities (WFS) and Wells Fargo Securities Int’l Ltd. (WFSIL) entities. These entities are not currently on the Core FX

platform. Transactions from these entities in the current legacy platforms will be migrated in the Core FX platform and into the

applicable application and system of record databases.

2 Responsibilities:

• Validated data to ensure the quality, validity and accuracy of content. .

• To generate test data, I used SQL query to get messages from the production and scrubbed the messages with sender and receiver

BICs.

• Injected the scrubbed messages into SAA using injecting tool 2SBS or message queue (MQ).

• Validated the message input and output in the SAA.

• Prepared Test Summary Report, which included Traceability Matrix, Execution Report, QA sign off, issue log.

• Prepared test scripts in Test Automation tool Green Hat (GH) and ran it and validate the result.

Environment: Window 7, Microsoft Office, Oracle, ALM 11.0, Green Hat, Version One, and Citrix.

Malar Kalaikumar

Email: ***********@*****.***

Phone: 803-***-****

PHH Mortgage, Mount Laurel, NJ July 2012 – Feb 2013

QA Analyst

I have worked on Loan origination application, which was based on new customer details, including personal information, credit processing,

information forwarding to underwriting and completion of the Loan process.

3 Responsibilities:

• Reviewed residential loan application to verify that application data is complete and meets establishment standards, including type

and amount of mortgage, borrower assets, liabilities and length of employment to write Test Plan document.

• Prepared Test Summary Report, which included Traceability Matrix, Execution Report, QA sign off, issue log.

• Performed User Interface testing, Regression testing, User Acceptance Testing (UAT).

Environment: Window 7, Microsoft word, Microsoft Excel, Microsoft Access, SQL Developer, Selenium, Main frame, Quality Center 11.

Wells Fargo, Charlotte, NC Jan 2012 – June 2012

QA Analyst

The project will ensure that the Variable Annuity product offering aligns to the funding principles of product simplification, narrower carrier

lineup, customer value proposition, lower cost to customers and consistency across channels. Develop and launch a fee-based VA offering

for Advisory accounts. Integrate annuity into performance Reporting. Develop on-going data management processes and monitoring

/reporting to ensure annuity carrier data quality.

3 Responsibilities:

• Experienced working in an Agile/Scrum development environment.

• Performed Enterprise Level Testing and validate the data.

• Tested the report that checks the performance on Variable Annuity.

• Worked in OLTP and OLAP environment that includes production, QA and development database in SQL Server.

• Tested various Reusable ETL Transformations which facilitate Daily, Weekly & Monthly Loading of Data.

• Performed the back ends testing by executing SQL queries to validating output data

• I developed SQL queries, which includes inner/outer joins and executed in SQL developer.

Environment: Windows 7, Microsoft Office, SQL Developer, Quality Center 11, Version One, SharePoint.

Vanguard, Malvern, PA Aug 2009 – Feb 2011

QA Analyst

This project automates post trade life cycle, which includes trades matching, affirmation, confirmation, trade settlement with all the

custodian banks and posting trade in accounting system. This release also introduced enhanced interfaces with the DTCC and the custodian

banks including in/out bound SWIFT Net capabilities with custodian bank to enable tracking of status for pending settlement activities.

Also, ACH technique was used to do the payment transactions from bank to bank.

4 Responsibilities:

• Worked multiple applications like Middle Office Trade Processing System, Front Office Trade Processing System, Foreign Stock

Handling, and Foreign Money Transfer.

• Ensured all SWIFT messages that are generated by the system in XML file functioning correctly.

Malar Kalaikumar

Email: ***********@*****.***

Phone: 803-***-****

• Involved with testing the ACH money transfer and NACHA compliances.

• Exposure in FEDWIRE and CHIPS messages that are generated by the system in XML file.

• Used MQJ explorer, which is message-injecting tool.

• Understood Agile Processes and worked in an agile development environment.

• Performed the back end testing by executing SQL queries for validating output data in the database tables on execution of standard

transactions.

• Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W.

• Performed Regression testing with QTP by executing the automation test scripts.

Environment: Oracle, Informatica Power Center, Windows XP, Quality center 9.2, Mainframe, Jira, QTP 10.

Pirelli Tire, Rome, GA August 2008 – April 2009

QA tester

Involved with SAP batch processing set up on several FI/MM/HR related processes. Also involved in testing a product for calculating

employee’s bonus calculation every year. It is a user interactive product that works with a Java front-end and SAP as back end. This product

is also enabled with workflow models. Each manager in the division or plant will log on to this product and work on the bonus calculation

for the employees that they are reporting to.

Responsibilities:

• Designed test plans and defined cases for functional, integration system, and user acceptance testing.

• Determined testing requirements developed and reviewed scripts for positive and negative test scenarios, conducted

baseline testing, and generated reports.

• Involved in Backend Database testing in oracle using SQL.

• Tested critical bug fixes including critical fixes and coordinated with developers in release of bug fixes meeting tight

timeline.

Environment: Java, SAP, Oracle, Java script, Windows XP, Quality Center 9.2

CSC, Falls Church, VA July 2007 – May 2008

QA Analyst

‘Track-It’ is a web Based tool, which is used for tracking the Service Requests known as ‘Tickets’ for an organization having multiple

departments. This tool helps in maintaining a complete record of all the stages a ticket undergoes before its completion. The ticket status at

any time can be tracked which is important for setting deadlines. This tool is designed for the use of all the members of the organization.

This tool reduces the cumbersome task of maintaining records in an Excel file.

5 Responsibilities:

• Involved in GUI, Functional, Regression and performance Testing.

• Examined application for testing, data validation, and work flow of customers.

• Used Clear Quest for repository, reporting and tracking bugs, and providing updates on resolved bugs.

• Executed SQL scripts to validate all defined criteria.

Environment: IBM Web sphere Portal, Windows XP, Clear Quest, Oracle

Ardent, Nashville, TN August 2005 – May 2007

QA Tester

The application automates the process of bidding for the nurses (for amount and availability). The functionality required bidding the

available nurses in their organization (Ardent) to the hospitals both in contract and permanent basis.

Malar Kalaikumar

Email: ***********@*****.***

Phone: 803-***-****

6

7 Responsibilities:

• Performed tests for Functionality, Security, GUI, End to End, System Configuration and Backend.

• Creating baseline Excel Template for manual test case flow.

• Worked with technical staff to validate test requirements, resolve design issues and software defects.

• Review of Test cases, test results and creating the issue log.

8

Environment: C++, ASP.NET, UNIX, SQL Server, Windows 2000, Quality Center 9.

Education & Professional Training:

• BS - Madurai Kamaraj University, India.

• Training in Computer Applications, Chennai, India.

• QA training in USA.

• US Citizen.

Contact this candidate