Project Test Cases

Chirag jariwala

QA Analyst - Scotiabank IT & Solutions

ac0s6v@r.postjobfree.com

Willing to relocate: Anywhere

WORK EXPERIENCE

QA Analyst

Scotiabank IT & Solutions - Toronto, ON - 2013-11 - Present I am working with the QA and the BA team which is responsible in carrying out analysis and testing for the following projects related to banking & finance domains: - Project 1 - Family of cards (FOC)

This project is about the introductions of multiple credit cards (Gold AMEX, Scotiabank AMEX, Scotia gold passport, SCENE Visa, etc.) between Scotiabank and American Express. Project 2 - Momentum Savings

* This project is about introducing a new type of Scotiabank savings accounts in which Scotiabank customers can earn extra interest.

* In this case, they have to maintain a balance of 5000$ or above every 90 days if no withdrawals are made. Project 3 - ER maintenance

* This project is about the ER (Enterprise repository) reporting model which generates OSFI (Office of the Superintendent of Financial Institution - independent agency of the government of Canada which supervises and regulates federally registered banks and insurers, trust and loan companies, as well as private pension plans) reports like global country risk reports, global cross border reports, all banks by business lines report, collateral report, industry risk appetite report, industry extracts reports, etc.

* This project will ensure that the existing OSFI dataset will be enhanced to include additional data elements. The ER will be enhanced to provide regulatory and status reports to the GRM management team.

* The objective of this maintenance release is to test this enhancement done to the ER reporting dataset. Project 4 - STEEL

* This project (codename = STEEL) is about introducing a new type of Scotiabank momentum MasterCard in which Scotiabank customers can earn 1% cash back on gas stations, grocery stores and 0.5% on other eligible purchases.

* This is due to Scotiabank acquisition of Sears financial MasterCard credit card from JP Morgan Chase

(Toronto Branch).

Project 5 - AML Fircosoft application redesign/upgrade

* Fircosoft is an application which is used to filter AML transactions and customers against sanctions and PEP

(Politically exposed persons) to ensure compliance with regulations on terrorist financing

* The objective of this project is to test the upgrade/redesigning the application to include PEPs from CA

(Canada), US (United States of America) and UK (United Kingdom) and generate report displaying these three countries along with the others.

Project 6 - FINTRAC

* FINTRAC (Financial Transactions and Reports Analysis Centre of Canada) is a Canadian government agency which requires banks and other designated institutions to report particular types of transactions for their analysis.

* The legislative requirements of The Proceeds of Crime (Money Laundering) and Terrorist Financing Act dictates that Scotiabank report all incoming cash transactions with an equivalent value of CAD$10,000 or more and any cross-border electronic funds transfers totaling $10,000 or more to FINTRAC.

* The objective of this project is to replace the existing FINTRAC reporting process that was built on AML Searchspace by Fiserv's FCRM (Financial Crime Risk Management) application. Project 7 - FATCA

* FATCA (Foreign account tax compliance act) is a US federal law which required US citizens residing inside and outside of USA to report their foreign income to IRS (Internal Revenue Service).

* The objective of this project's reporting module is to check and test whether the name, address and US TIN

(Tax Identification number) for each account held by a US citizen, account numbers, account balance / value and other financial institution is displayed properly in XML / Excel / PDF format in order to be sent to IRS. Responsibilities for the above AML related projects:

* Preparing and executing test cases, test scripts and performing data analysis for data migration.

* Maintaining and providing accurate testing status reports during the testing phases.

* Preparing test data, test case creation & execution, defect management.

* Working collaboratively with Functional, End-to-End, Regression, Performance and UAT testing teams for high profile critical regulatory initiatives from a Test Automation perspective for Anti-Money Laundering (AML) applications.

* Maintaining existing automation scripts in QTP for regression testing for US and Canada AML applications.

* Performing SQL queries in DB2 to pull the required data for AML validation.

* Performing Browser compatibility testing (IE,FIREFOX,SAFARI,CHROME).

* Selecting and executing test cases for regression testing when new changes are added thus ensuring that the existing functionalities are not impacted.

* Administering and maintaining bug tracking system.

* Performing, functional, regression & UAT testing.

* Participating in meetings with Project Managers, Business Analysts, Developers whenever a new project is scheduled to go live or an changes appear in an existing project and collecting business requirements accordingly.

* Preparing RTM (linking test cases to the business/functional requirements). Operations/Business Analyst

FX dept - Toronto, ON - 2008-08 - 2013-11

* Worked with business partners and project managers to understand business and technical requirements during the process of upgrading WSS from ver 4.3 to ver 5.1

* Assisted in writing requirement documents performing data mapping and participated in discussions between business and technology groups for the wallstreet upgrade.

* Performed data analysis for data migration.

* Analyzed and evaluated business, functional requirements, documentation, process flows and data models to contribute to the development and testing of project plans including project deliverables, cost/benefits analysis, time line estimates, scope and control.

* Defined and documented workflows using MS-Visio and developed use cases.

* Assisted in developing use cases, defining and documenting workflows in order to add Spanish language capabilities in order to implement WSS for BNS Latin America.

* Interacted with other technology teams within the organization to solve problems and deliver solutions, thus ensuring that the WSS upgrade and adding Spanish language capability for BNS Latin America was done successfully.

* Managed the WSS Queues for "Outside Adjustments Queue" and "Get Back Funds Queue" ensured that the items (trades) showing up in these queues related to trades already settled where an amendment was made and the original payment had to be cancelled or recalled or reversed.

* Using BESS, managed the ADMR (Administrative messages receipt) queues to file / print / route incoming wires (as necessary) for the confirmations group that to book FX trades pertaining to the GFX (Global Foreign Exchange) business line transactions, composed SWIFT messages to be sent to other banks regarding FX confirmations, payments monitoring, wires management, etc. Business Analyst

TD Canada Trust - Toronto, ON - 2006-01 - 2008-07

I worked in the Mobile MSF (Mortgage Sales Force) unit, which consists of mortgage specialists who meets clients (wanting to purchase/refinance) their residential properties (houses, townhouses, condominiums). In order for a client to purchase property, they have to meet up with a mortgage specialist for further processing, but sometimes the timings to not match; so these mortgage specialists make arrangements in such a way that they can meet the client at their convenience (meeting clients at their homes, outside, any day during the weekends/weekday; thus guaranteeing complete client satisfaction and catering to the clients' needs). These MSF team is located Canada wide and have all the tools (laptops, pagers, blackberries, etc.) which help them to assists the client in all possible ways. As a part of the RESL team, I made sure the MSF team was functioning the way they should.

* Assisted in developing technical business solutions in response to client needs.

* Maintained databases, desktop applications depending on the requirements.

* Supported and maintained business specific applications for applications in production; ensured there were no disruptions and resolved any issues impacting the performance of the application.

* Addressed concerns/challenges during projects and escalated issues where necessary.

* Assisted in performing ETLs and validated results with business representatives.

* Supported implemented business intelligence solutions by: monitoring and tuning queries and data loads, addressing questions concerning data integrity and communicating functional and technical issues.

* Participated in extracting data from various database sources like CSV, XML into Data stage (ETL tool).

* Assisted in defining and documenting workflows and developing use cases using MS-Visio.

* Ensured developmental activities were consistent with Systems Life Cycle Methodologies.

* Participated in user acceptance testing, impact analysis, and the development of policies and procedures.

* Designed, built and modified macros used by business unit. EDUCATION

Masters' Degree in Electronic Engineering in Electronic Engineering Gujarat University (India) - Gujarat, IN

SKILLS

data migration., DB2, HP UNIFIED FUNCTIONAL TESTING, QTP, Visio ADDITIONAL INFORMATION

Technical Skills

* Skilled in software applications like SQL, Lotus SmartSuite, MS-Access, MS-Office, Lotus Notes, MS-Outlook Express. Also Operating systems like Windows (NT, XP, Server 2003, Vista, and Windows 7-8) and UNIX.

* Good working knowledge of HP ALM (11.52), automation tools like QTP and defect management tools

(Quality Center, Test Director, JIRA, Bugzilla), Relational databases (backend) like SQL server, Oracle and DB2.

* Good working knowledge of all phases of SDLC and Test Life Cycle.

* Expertise in test data preparation, test suite design, test execution, data migration and defect management.

* Good knowledge of banking applications like WSS (Wall Street Systems), BESS (Bank Electronic Support System), SWIFT and diagramming application (MS-Visio). Soft Skills

* Self-motivated, analytical thinker, process oriented with a strong focus on quality and attention.

* Hard working and highly organized with the ability to manage multiple tasks at tight deadlines.

* Customer centric and empathetic towards clients and other business stakeholders at all levels.

* Good sense of personal responsibility in achieving success.

* Strong desire for expansion of current skillset in a fast-paced work environment.

Contact this candidate