Quality Assurance Testing

REGIN MATHEW SKARIAH Mobile: 201-***-****

~ E-Mail: ************@*****.***

Seeking assignments in Software Testing / Quality Assurance / Business

Analyst with an organization of high repute in IT Sector

Summary

< 7 years and 6 months of Software Testing experience in the Banking and

Capital Markets Domain.

< Associated with Infosys Technologies Limited from Oct 2006

< Experience includes analysis of business and end user requirements,

strategizing, planning, execution, reporting, tracking and coordinating

activities.

< Expertise in Functional Testing, SOA and Middleware Testing.

< Had worked in System Testing.

< Strong knowledge in writing SQL queries.

< Has worked in Data warehouse testing.

< Well versed with ETL testing concepts.

< Well versed with Testing WEBQQ Pershing Application.

< Well versed with Testing TAOS Pershing Application.

< Well versed with Testing GDR Pershing Application.

< Well versed with testing of GUI, functional and regression, application

testing, black box testing, especially in Client/Server systems and web

applications.

< Well versed with Middle Office Operations.

< Well versed with SWIFT message verification (MT541, MT543, MT202, MT210,

MT300, MT304, MT545, MT547, MT548).

< Has good knowledge in xml structure.

< Has worked on OASYS and CTM Workstations for matching Client and Broker

Trades.

< Good Knowledge on SDLC and STLC.

< Strong Analytical, communication and decision making skills.

< Has good knowledge in workflows for FX, FD, CD, INKIND, EFL, FI, EQ, DV

asset class.

< Good at Banking and Capital Markets industry business knowledge.

Skill set

TECHNICAL

Operating System : Windows 98/2000/XP/Vista

Software Testing : Manual Testing Concepts, SOA

testing Concepts.

Domain Knowledge : Middle Office Operations, Banking and Capital

Markets.

Defect Tracking Tool : Team Track (In-house tools), Quality

Center

Automation Test Tools : ACCORD (In-house tool), QTP

(training)

Project Management Tools : Quality Center

Database Tools : SQL Developer, Toad

FUNCTIONAL

< Software Testing

- Managing the Software Testing Life Cycle activities.

- Project planning, scope finalization, estimation and

tracking.

- Engineering test cases design.

- Analysing the functional requirement document.

- System Integration testing and regression testing and

analysing reported defects and tracking towards closure.

< Quality Assurance

- Defining the best practices for project support and

documentation.

- Training, mentoring, deploying and counselling of the

processing associates.

< Project Management

- Requirements gathering, analysis and testing of system.

- Interacting with team members to ensure smooth progress of

testing activity.

- Daily status reporting to the client.

Organisational Experience

Multi National Company: Since Oct'06

Role: Test Analyst

Projects Handled:

< NEXT GEN MOTO

Jan'10 - Till Date

Client: Citigroup - Institutional Portfolio Services

Role: Test Analyst

Tools used: Toad, QC.

Environment: Windows 2000/XP/Vista, J2EE, Oracle 10g Server,

Websphere6.1 application server

- Scope: The objective of Institutional Portfolio services is

to tackle the following issues which can be encountered on

any given day - Critical Investment Decision, trading

marketing and Customer Service.

- I was involved in the Middle Office Operation of

Institutional Portfolio Services. The Middle Office

Operation takes care of the following services - a.

Accounting and Data Management and b. Post Trade Services.

- Responsibilities:

- Requirement Specification Analysis - Understanding the

requirements from the Functionality Requirements Document

and identifying the test scope

- Analyzing the document and providing estimates provided for

the complete test cycle.

- System and Integration Testing - Test cases design, Review

and Execution

- Getting the environment ready for testing from the technical

team.

- Mentoring new testing resources about the testing process

and product/applications.

- Performing the test data setup when the test environment is

ready for testing.

- Analyzed application data using the SQL to identify the ETL

processes

- Performs ETL testing to validate the date being loaded to

the datawarehouse.

- Modifying and creating SQL Queries and stored procedures for

quality assurance and analysis.

- Performing backend testing of the DB by writing SQL

queries to test the integrity of the application and Oracle

databases.

- Wrote and modified SQL validation scripts, and writing

scripts in SQL to validate the outputs.

- Wrote queries to compare the counts and data from source to

target.

- Performing database testing to verify backend database

transactions.

- Involved in writing SQL statements to create test data for

test cases and data validation test to extract data from the

tables.

- Compared SQL results with application results by writing SQL

queries.

- Performing Sanity Test and System Integration Testing (SIT).

- Tested workflows for FX, FD, CD, INKIND, EFL, FI, EQ, DV

asset class.

- Dropping the trades into different queues and verifying if

the messages gets populated in the front end.

- Analyzing the various SWIFT messages which goes out from the

bank to different recipients after a transaction is

completed.

- Analyzed MT541, MT543, MT202, MT210, MT300, MT304, MT545,

MT547, MT548 swift messages.

- Worked with CTM and OASYS workstations for matching Client

and Broker trades.

- Verifying the reports which get generated at the end of the

day and check if it matches the details in the database.

- Providing UAT support after the SIT is completed.

- Participating in the UAT defect analysis meeting.

- Leading and tracking a team of 10 test team members in all

their testing assignments.

- Defect Tracking and Closure verifications. Test reports

Preparation from Quality Center.

- Day to day status updating to client and other stakeholders

< Pershing Investment

Oct'10 - Dec'10

Client: Citigroup - Pershing

Role: Test Analyst

Tools used: SQL Developer, QC.

Environment: Windows 2000/XP/Vista, J2EE, Oracle 10g Server

Scope: Before recession, the Alternative Investments were handled by

Smith Barney. After recession, Smith Barney moved away from

CITI and joined Morgan Stanley. A third party company

'Pershing' is assisting CITI BANK in replacing the Smith

Barney Systems which supports the Alternative Investment

process.

Responsibilities:

- Requirement Specification Analysis - Understanding the

requirements from the Functionality Requirements Document

and identifying the test scope

- System and Integration Testing - Test cases design, Review

and Execution

- Mentoring new testing resources about the testing process

and product/applications.

- Performing the test data setup when the test environment is

ready for testing.

- Performing Sanity Test and System Integration Testing (SIT).

- Providing UAT support after the SIT is completed.

- Participating in the UAT defect analysis meeting.

- Leading and tracking a team of 5 test team members in all

their testing assignments.

- Defect Tracking and Closure verifications. Test reports

Preparation from Quality Center.

- Anchoring different team engagement activities to create

stress free work environment

- Day to day status updating to client and other stakeholders

< Global Transaction Services

Aug'09 - Sep'10

Client: Citigroup - UK Implementation

Role: Test Engineer

Tools used: ACCORD, SQL Developer, Soap-UI, TeamTrack.

Environment: Windows 2000/XP/Vista, J2EE, Oracle 10g Server,

Websphere6.1 application server

Scope: The growth and market expansion of the Small and Medium

Enterprise (SME) market has mandated the need to restructure

the current CitiDirect Offerings to match the client's need

to manage their Cash Flow more effectively and efficiently.

The involvement of multiple back-end systems interfacing

with "SME" and the fact that stakeholders involve global,

local and Flexcube teams are at this time considered the

major risk factors.

The Business Requirements from the SME market detail the

need for a single system approach that provides various

Services like Payments, Direct Debits, Loans and Investments

all under one roof. Though SME portal is a single

application, it will be customised to accommodate the

business requirements from various countries involved.

< Global Transaction Services

Oct'08 - Jul'09

Client: Citigroup - Poland Implementation

Role: Test Engineer

Tools used: ACCORD, SQL Developer, Soap-UI, TeamTrack.

Environment: Windows 2000/XP/Vista, J2EE, Oracle 10g Server,

Websphere6.1 application server

Scope: The growth and market expansion of the Small and Medium

Enterprise (SME) market has mandated the need to restructure

the current CitiDirect Offerings to match the client's need

to manage their Cash Flow more effectively and efficiently.

The involvement of multiple back-end systems interfacing

with "SME" and the fact that stakeholders involve global,

local and Flexcube teams are at this time considered the

major risk factors.

The Business Requirements from the SME market detail the

need for a single system approach that provides various

Services like Payments, Direct Debits, Loans and Investments

all under one roof. Though SME portal is a single

application, it will be customised to accommodate the

business requirements from various countries involved.

Responsibilities:

- Requirement Specification Analysis - Understanding the

requirements from the Functionality Requirements Document

and identifying the test scope

- System and Integration Testing - Test cases design, Review

and Execution

- Perform Web services Message Verification testing using

Accord automation tool.

- Preparation and Execution of Automated Test Scripts using

ACCORD

- Mentoring new testing resources about the testing process

and product/applications.

- Performing Smoke Test and System Integration Testing (SIT).

- Leading and tracking a team of 5 test team members in all

their testing assignments.

- Update project status to the clients.

- Defect Tracking and Closure verifications. Test reports

Preparation from Quality Center and ACCORD

- Anchoring different team engagement activities to create

stress free work environment

- Key Team Player in a Project with team size 40

- Day to day status updating to client and other stakeholders

< Private Banking

Oct'06 - Sept'08

Client: Citigroup

Role: Test Engineer

Tools used: Toad, Putty (Unix Box), Team Track

Environment: Windows 2000/XP/Vista.

Scope: Private Banking division of Citi Bank provides financial

services to high net-worth individuals. The Citi Private

Bank (CPB) operates from 5 regions - US(USA and Canada),

LATAM(Latin America), EMEA(Europe Middle East and Africa),

Asia Pacific.

CPB multiple systems support different products in different

regions. These products are supported by Product Processors.

Bank Statement Summary, Reports and Legal Statements etc are

generated from these different Product Processors.

Responsibilities:

- Requirement Specification Analysis - Understanding the

requirements from the Functionality Requirements Document

and identifying the test scope

- ETL testing - Test cases design, Review and Execution.

- Loading of data from feed files into the database using

AUTOSYS jobs.

- Package installation whenever a new package comes for build.

- Analyzed application data using the SQL to identify the ETL

processes

- Performs ETL testing to validate the date being loaded to

the datawarehouse.

- Modifying and creating SQL Queries and stored procedures for

quality assurance and analysis.

- Performing backend testing of the DB by writing SQL

queries to test the integrity of the application and Oracle

databases.

- Wrote and modified SQL validation scripts, and writing

scripts in SQL to validate the outputs.

- Wrote queries to compare the counts and data from source to

target.

- Performing database testing to verify backend database

transactions.

- Involved in writing SQL statements to create test data for

test cases and data validation test to extract data from the

tables.

- Compared SQL results with application results by writing SQL

queries.

- Mentoring new testing resources about the testing process

and product/applications.

- Performing Smoke & Functional Test and System Integration

Testing (SIT).

- Leading and tracking a team of 5 test team members in all

their testing assignments.

- Defect Tracking and Closure verifications.

- Anchoring different team engagement activities to create

stress free work environment

- Key Team Player in a Project with team size 10

Certifications

< FDN-BN101-DB - Foundation Course in Banking- (Internal)

< IVS Technical Foundation Certification(Internal)

< IQ Foundation Certification(Internal)

Scholastics

< B.E. (Electrical & Electronics) from Anna University in 2006.

Personal Dossier

Date of Birth : 17th August, 1984

Languages Known : English, Hindi and Malayalam

Marital Status : Married

Nationality : Indian

Contact this candidate