Project Data

Chirag jariwala

**************@*******.***

I am specialized in analyzing and testing applications/projects for domains related to tax compliance, secured lending, AML and risk analysis. Proactive performance-driven with 8+ years progressive expertise in Business Analysis/QA and Project Coordination within domains like retail banking, foreign exchange and tax compliance using Waterfall and Agile methodologies.

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 (WinRunner & 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).

Education

Masters’ Degree in Electronics from Gujarat University (India)

Employment Experience

November 2013 - Present – Scotiabank IT & Solutions (Compliance testing), Toronto

QA Analyst

I am working with the QA and the BA team which is responsible in carrying out analysis and testing for 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 – 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 4 – Fircosoft application redesign (AML 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

This project is about 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 5 – 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 aim 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 6 – 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).

I am working on the reporting module in which I have to check 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.

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

Performing dummy transactions using intralink (a system used by the tellers when processing a client’s request for opening a new account, adding new features in existing accounts, paying bills, etc.) and logging into scotia online to check whether those transactions appear in the online statement.

Administering and maintaining bug tracking system.

Obtaining knowledge of applications and their functions through walk-through meetings, training sessions, preparing data mapping (creating test data) and performing testing of applications using HP ALM.

Conducting reviews, ensuring all technical solutions have met business requirements using HP ALM by preparing RTM (linking test cases to the business/functional requirements).

August 2008 – November 2013 - Scotiabank (Global Wholesale Operations, FX dept.) Toronto

Operations/Business Analyst

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.

Jan 2006 - Jul 2008 - TD Canada Trust (RESL - Real Estate Secured Lending), Toronto

Business Analyst

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.

Created and 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.

Created data models, performed 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.

Contact this candidate