Project Test Cases

Aamir Majeed Wani

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

Mobile +971-***-***-***

DOB: 25 Feb 1981

Dubai

Career Objective

A challenging career in Software Testing & Quality Assurance, that will

bring along good opportunities and where my education & professional skills

will be utilized towards achieving the organization's goal.

Work Summary (8 Years and 6 months of experience)

Company Name Designation Duration

The Royal Bank of Scotland Senior Test Designer Oct 2010 till date

(RBS)

Steria India Ltd, Noida Test Analyst October 2006 to Sep 2010

(India)

Sharp Software QA Consultant February 2005 to

Development, Bangalore September 2006

(India)

Iseva, Bangalore Technical Support January 2004 to January

Engineer 2005

Technical Skills

Certifications CCNA, IELTS with Overall score of 8

Testing Tools QTP 10.0, Quality Center, Clear Quest, PVCS Tracker,

JIRA

Domain Expertise 6 years in Banking Domain (Market and Credit Risk,

Payments, Collections, Balance and Transactions

Reporting, SWIFT, SEPA (Single European Payment Area),

Payment systems like API, AFTS, RTGS etc)

Operating Windows 2000/NT/Server/Unix and Linux

Systems(s)

Testing Techniques Smoke testing, Functional testing, Integration testing,

(Functional) Regression testing, System testing, Database testing

Databases/RDBMS DB2 8.2, Oracle 10g, Sybase, FAME

Automation Tools QTP (Quick Test Professional)

Languages SQL, Unix (basic commands), VB Script

Configuration Tools Clear Case, SVN

Professional Summary

. Working in Financial Risk (Market and Credit Risk) as Senior Test

Designer for The Royal Bank of Scotland.

. Experience in test estimation and efforts required in testing process

of projects.

. Expertise in understanding the business requirements and design test

plan/ scenarios for them.

. Experience in maintenance of test environments for

projects/applications.

. Experience in doing causal analysis of defects as a part of post

release process to identify and prevent the cause of defects for future

prevention.

. Experience in working in Onshore-Offshore delivery model and acting as

a point of interface between onshore and offshore teams (including

business users/project stakeholders)

. Experience in carrying out UAT phase of testing with Business Users.

. Testing experience in various Web-Based, Client/Server applications (5

years in BFSI domain).

. Worked for a year onsite at Barclays Bank, UK for banking projects.

. Currently working on an application used by RBS Risk Managers.

. Working knowledge of SQL, DB2, Sybase, FAME and Oracle 10g

. Experience in working on Time Series data.

. Expertise in Manual/Functional Testing

. Proficient in all cycles of test life cycle from test planning to

defect tracking and managing defect lifecycle

. Experience in working on different types of pain and pacs messages used

in transfer of payments/Account balance and transaction reporting for

different types of payments including SEPA Credit Transfer (SCT).

. Experience in creating different types of SWIFT messages (MT103, MT910

etc) manually that can be imported into payment systems

. Experience in running batch processes for payments.

. Handled the complete testing of a new payment type (SEPA Credit

Transfer) for the application 'Business Internet Banking' for Barclays

Bank Plc.

. Well versed with testing the logs/batch jobs using the UNIX commands.

. Good networking knowledge (Certified Cisco Network Associate 2003)

. Ability to quickly master Software Testing Tools and apply its full

range of capabilities.

. Good interpersonal and communication skills

Project Undertaken from October 2010 till date

Project Indicium

Client RBS, UK and Singapore

Company RBS, Gurgaon (http://www.rbs.com/)

Technology/Software J2EE, FAME

Project Description:

Indicium is used for market data loading through feed processing (Batch

File Processing) and Web Services. The values (risk codes) received from

feeds (internal and external) are stored in FAME which is used ultimately

for UNIVaR calculations. The loading of risk codes into FAME is involves

two processes viz Feed Processing and Fame Processing.

During this processing there are different files created depending of

certain validation and these files are further used for the calculation of

'Value at Risk' (VaR). The other modules of Indicium include Creating and

running Analytics, running the feeds, re-running the feeds.

Also, 'Manage Test Results' forms an important form of this application

which displays the list of failed risk codes of different feeds based on

the search criteria given. This screen also enables the users to pass the

failed risk codes or enter new value for the risk code and save the data in

FAME. This module provides various functions that can be used on risk codes

like rerun, pass, review, and unreview to name a few.

Contribution:

. Leading a team of 3 test engineers for the current project

. Handled the complete database testing

. Creating Requirement Traceability Matrix.

. Consolidating/Preparing Daily /Weekly Status Reports

. Involved in walkthroughs, understanding the Project Requirements using

Specifications

. Designing test cases and scenarios for the applications by referring

FRD

Project Risk Factor Control (RFC)

Client RBS, UK and Singapore

Company RBS, Gurgaon (http://www.rbs.com/)

Technology/Software J2EE, FAME

Project Description:

RFC is used for creating PLAFs and Risk Factors that are used by Univar

(calculation engine) to calculate VaR. Risk Factors and PLAFs are created

from UI and the data us saved in Sybase and FAME Database. The main

function of RFC is TSrefresh which is the process to assign values to PLAFs

that can be read by Univar. These values are extracted from the Risk

Factors stored in FAME and are assigned to corresponding PLAFs.

Contribution:

. Managing and testing the complete application

. Handling the complete database testing

. Creating Requirement Traceability Matrix.

. Designing test cases and scenarios for the applications by

referring FRD

. Automated the complete regression suite using QTP 10.0

Project Phoenix (Trade Loading)

Client RBS, UK and Singapore

Company RBS, Gurgaon (http://www.rbs.com/)

Technology/Software Core Java, Shell Scripting, Sybase

Phoenix is one of the biggest applications of RBS and is solely handling

the credit risk segment of the bank. Within phoenix there are various

streams like Trade Loading, Capital, PIR, Gateway, Deal Clearance etc.

Trade Loading is responsible for loading trades through various sources

(all internal) with huge set of daily load of around 2.2Million trades

(both Intraday and End of the day Trades) and applying various enrichments

(3 shift & 11 shift profiles) with parallel computing using Data Synapse

Grid & Loading the trades in Coherence Cache, and provide various APIs to

be used by layers above like Capital, PIR etc to generate Capital

reporting, Repo VAR etc.

Contribution:

. Managing and testing the application

. Database testing

. Designing test cases and scenarios for the applications by

referring FRD

. Reporting the defects found and tracking them down to closure

Project Undertaken from October 2006 to September 2010

Project Barclays Business Internet Banking (BBIB)

Client Barclays Bank Plc, UK

Company Steria India Ltd (http://www.steria.com/)

Technology/Software J2EE, DB2 8.2

Project Description:

Barclays Business Internet Banking is a project for the Corporate Customers

of the Barclays bank. All the banking transactions are properly studied and

implemented in it. Its main goal is the creation of the organizations,

users and maintaining the accounts of the users and doing all the banking

transactions like Payments, Collection etc. This project is being developed

in releases. The application has the ability to view or download account

information (transactions and balances) for domestic, currency and other

business accounts. It includes advanced financial transaction capability

allowing for domestic 3-day payments and same-day payments, international

payments, Inter-Account transfers, and collections. There are other

facilities available to Bank Users such as create and administer Bank

Users, create and administer customer profiles, Limited administration of

Inter-account transfers and payment instructions, administer beneficiary

details and View audit records.

Contribution:

. Consolidating/Preparing Daily /Weekly Status Reports for each

individual

. Creating different types of SWIFT messages (e.g. MT 103 for payments

and transfers).

. Involved in walkthroughs, understanding the Project Requirements using

Specifications

. Designing test cases and scenarios for the applications by referring

FRD

. Database testing in DB2 8.2.

. Doing System Testing of the assigned module.

. Created the regression suite and smoke test pack for this

application.

Project Undertaken from February 2009 till January 2010

Project Phoenix (BACS Aggregation Service)

Client Barclays Bank Plc, UK

Company Steria India Ltd (http://www.steria.com/)

Technology/Software J2EE, Orcale 10g, Middleware Message MQ

Project Description:

BACS Aggregation Service is a middleware component for Phoenix which

validates the three day payments as messages in form of XML (pain001)

received from the Integration Factory, stores them in the database after

validation, runs BACS, Billing and acknowledgement batch, thereby sending

processed data back to the Integration factory. Integration factory

receives the payment messages, debulks them and sends them to BAS to

validate and batch processes. BAS sends the acknowledgement message of the

received payment in form of XML (pain002) to the Integration Factory. The

BACS batch processes complete the validated payments and billing batch

creates billing information for the accounts used for the payment and sends

the file to connect direct.

Contribution:

. Handling all the test activities of this project.

. Consolidating/Preparing Daily /Weekly Status Reports.

. Involved in walkthroughs, understanding the Project Requirements using

Specifications

. Writing test cases and giving inputs to test plan for the applications

by referring FRD

. System and Regression testing of the application.

. Database testing in Oracle 10g.

. Importing, executing test cases and raising defects in Quality

Center.

Project Undertaken from November 2007 to August 2008

Project SEPA Credit Transfer on BBIB

Client Barclays Bank Plc, UK

Company Steria India Ltd (http://www.steria.com/)

Technology/Software J2EE, DB2 8.2

Project Description:

The Single Euro Payments Area (SEPA) project is an initiative to establish

a truly integrated European payments landscape where Euro payments are

subject to a uniform set of standards, rules and conditions and can

circulate as easily, quickly, securely and efficiently as in national

markets today. The SEPA Credit Transfer (SCT) Scheme is one of the first

new instruments under SEPA, and is designed as a low cost, high volume, non-

urgent, Pan-European Euro payment. The System operates in Euros. All

transactions are in Euro in all process stages within the scheme, including

all exception handling, i.e. Rejects and Returns. The accounts of the

originator and of the beneficiary may be in Euro or any other currency. Any

currency conversion is executed in the originator bank or beneficiary bank

and is not governed by this Scheme.

Contribution:

. Handled the complete testing of a new payment type (SEPA Credit

Transfer)

. Worked at on site (Barclays, UK) for testing implementation of SEPA

in BBIB.

. Creating and importing different types of SWIFT messages (e.g. MT 103

for SCT).

. Designing test cases and scenarios for the applications by referring

FRD

. Database testing in DB2 8.2.

. Doing System Testing of the assigned module.

. Raising the defects in Clear Quest (Onsite)

Project Undertaken during February 2005 to September 2006

Project Sharp Open System Architecture (OSA SDK)

Client Sharp Labs, US

Company Sharp Software Development India, Bangalore

http://www.sharp.co.in/

O/S Windows 2003 Server, Windows 2000, Windows XP

Technology/Software IIS, .Net Framework, C#

Project Description and contribution: Available on request

Client Site Experience

. Worked at Client Site at Poole, UK (Barclays Bank Plc.)

o November 2007 To August 2008

Education

B.E (Information Science and Technology) - with 65%

C.C.N.A (2003)

ISEB Certified Test Engineer

Personal Profile

Date of Birth : 25th February 1981

Sex : Male

Phone : +971-*********

Passport No : M3192449

Expiry Date : 10/11/2024

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

Contact this candidate