Sign in

Data Management

Mississauga, Ontario, Canada
November 07, 2018

Contact this candidate


Ken Dinshaw



Business System Analyst with Quality Assurance

Creation of Business Requirements Documents (BRD), Integrated Requirement Document (IRD), Software Requirement Specs (SRS), Data Mapping Spreadsheets, QA documents,

Contribute towards implementation of new systems, upgraded systems, new or augmented data warehouses, reporting and extracts, retirement of legacy systems

Use of Agile, Iterative and Waterfall methodologies and their respective tools


Excellent knowledge of Capital Markets, Wealth Management, Investments, Financial Products, Credit Risk, Liquidity Risk, Market Risk, Custody

Excellent knowledge of retail banking and retail lending products (Loans, Mortgages, Credit Cards) and Order Fulfillment

Experienced with SWIFT Electronic Funds Transfers (MT0xx through MT9xx)

Excellent knowledge of Trade Confirmation Processing, Call Centres, Insurance, Debit and Credit Card processing, Cheque Processing

Experienced in compliance and regulatory initiatives (CDIC, IIROC, FATCA, BASEL, OSFI, CRM2, OSC, CASL)

Print Industry – Credit Card Statement Composition, Banking Statements, Cheque Processing, Trade Confirm Composition, Tax Slips, and Letters and related workflows

BA / BSA Skills

Research and document business and system requirements in a well-defined manner for business end users, development team, and QA team

Reviewed and provided input to test strategies, test plans, and test cases against documented requirements.

Provide ongoing and timely user support for activities to Front, Middle, and Back offices and other cross functional groups to meet business and technology expectations.

Collaborate across cross functional teams including: business leaders and staff, application development and technology teams, vendors and 3rd parties to ensure that business requirements are clear and understood

Issue investigation and solution proposal or possible work arounds


Use Cases

User Stories

Requirements Traceability Matrix

Requirements / Specification documentation

Data Flows / Business Process Mapping

Gap Analysis

Data Mapping / Dataset Analysis

SQL Queries

Reverse Engineering / Re-engineering /

Streamlining and Process Improvement

Organizational Design / Change Management


MS Office / SharePoint / MS Access / MS Visio

Securities Brokering with Straight Thru Processing

JIRA / Confluence

SS&C Camra 2000

HP Quality Center (HPQC) / HPALM

Bloomberg, Reuters

BaNCS Custody System

SWIFT Messaging / Wire Transfers

Blueprint Requirements Centre

Manual and Automated Regression Testing

Bond One (formerly DSTS)

iFAST / Corfax

Business Objects / Crystal Reports

IBM Rational Composer


Software Development–College Diploma

CFA Level One

Canadian Securities Course

Economics – Bachelor of Arts Degree

Political Science–Bachelor of Arts Degree

Institute for Computer Studies

Institute of Chartered Financial Analysts

Canadian Securities Institute

York U


Ken Dinshaw 647-***-****

Symcor March 2017 – October 2018

Senior Business Systems Analyst (Contract)

Operational Migration and Legacy System Retirement

Provided input into updating a legacy BRD template

Deployed new BRD template to document initiative for migrating client document creation process from a legacy platform to a newly designed platform.

Documented details of various client document inventories, including Credit Card Statements, Monthly Client Statements (with and without cheque images), Tax Forms and Letters on legacy platform that required platform migration

Authored or co-authored BRDs, and created document mock-ups with annotated details for end client and internal use.

Created process maps with swimlanes, context diagrams

Data Mapping fields from client file raw data file to finished product for API

New Core Platform System

Documented requirements from Operations team and third-party vendor for Monitoring and Control Interface of print production, statement archiving and client file return

Created BRDs for Production Summary Report and Billing Reports for each client for use by Operations team

Authored requirements using JIRA for ‘Batch Cheque Extract’ service and its complete end to end automation workflow from incoming client file to ETL, Image Request (csv file) Cheque Image Retrieval, (tiff file) Statement Composition (xml file), Emit (Print, AFP, PDF format) and Packaged Return File to end client or archive

Documented Epics and Requirements in JIRA.

Creation of Use Cases and User Stories

Client Change Requests

Reviewed client change requests and provided estimates on required work.

Updated BRD according to change request for client review and approval

Assist PM as required

Co-ordinated and arrange meetings with internal team, internal clients, external clients


Acquired of knowledge of Print Industry

Gathered detailed processes of credit card statements, cheque processing, banking statements creation, tax forms, and letters

Gained knowledge of third-party statement management tool

Familiarity with Dev-Ops principles and methodology

Assisted with APIs requirement

Broadridge Feb 2016 – Dec 2016

Senior Business Systems Analyst (Contract)

CRM2 / Trade Confirmation Revisions / Document Fulfillment / Reporting

Document business requirements of Wealth Management Divisions of major Canadian Bank

Created several mock ups of trade confirmations displaying Term Deposits, Equities, Fixed Income, Options transactions

Creation of process maps to detail current vs future state business processes

Collaborate and communicate with client, trade confirmation composition partner, development teams, print partner and electronic archiving facilities.

Review of composition files sent to print vendor

Data analysis of functional and system requirements to ensure alignment amongst all groups

Data Mapping from text file to position on Trade Confirms.

Utilized Reference Data, Customer Data and Transaction Data

Analysis and documentation of data acquisition data specifications, data analysis, data cleansing, data transformation

Documentation of business rules for all lines of business within Wealth Management division

Creation of business rules for each and every field on trade confirmation for equities, fixed income, options, seg funds.

Evaluation of information from multiple sources to identify and determine most beneficial and efficient solutions

Contribute to resolution of business and system issues

Verified PnL calculation against client’s system calculation


Acquired detailed and in-depth exposure to the creation of Trade Confirmation and related processes

Engaged in multiple initiatives concurrently

Macros within excel for data analysis

Ken Dinshaw 647-***-****

Manulife Securities Jan 2015 – Jan 2016

Senior Business Systems Analyst (Contract)

Manulife Online Trading Platform

Creation of several requirement documents revolving around Manulife’s new line of business for Wealth Management

Gathered requirements and created Business Requirement Documents for ‘User Access Control’ for CSRs, and IRs, Scheduler Requirements for file transmission and acquisition, Reporting Requirements for Compliance, Operations, Risk Management, Anti-Money Laundering, Possible Terrorism Funding

Gathered and documented technical requirements for ‘Managed File Transfer Protocol’ (MFT)

Identification of possible policy and procedure changes and their impact

Registration of several domain and website names for Manulife Securities

Creation of process maps, context diagrams for client onboarding

GUI testing for new website and tracking defects

Utilized Reference Data, Customer Data and Transaction Data

Created excel macros for for testing of PnL (Profit and Loss) against trading system

Utilized HPALM for requirement and bug fixes


Authored several documents relating to new online trading system

OSC Compliance

Creation of business requirements document for OSC legislation relating to F-class investment products held fee based advisory accounts

Documented necessary changes for in-house application to capture updates and modifications

Highlighted procedural changes for operations area to ensure advisory fee exclusion where applicable

Documented necessary changes for in-house application to capture modifications, updates and data remediation


Enhanced knowledge Wealth Management and various pieces of OSC legislation

Internet Explorer 11 upgrade

Documenting all in-house and vendor applications that use web browsers

Testing of several in-house and vendor-based applications to ensure compatibility of Internet Explorer 11


Acquired detailed knowledge of IE11

Adastra at CIBC Nov 2013 – Nov 2014

Senior Business Analyst (Contract)

Enterprise Content Management – Wealth Electronic Document Solution

Gathered business requirements for migration of client documents from legacy storage system to new ASP storage

Translate business requirements into functional and non functional requirements

Reviewed and commented on several documents related to this initiative

Creation of Use Cases from Business Requirements Document

Created and Updated Issue and Risk Logs on SharePoint

Liaised with various groups on project status

Led group of 4 business analysts in obtaining requirements

Created internal user matrix for access control of client confirms and statements


Gained knowledge of Enterprise Content Management

Acquired knowledge of Wealth Management retail client statements


Reviewed CRM2 regulations and its affect on specific lines of business.

Created matrix of legislation and how it may affect specific investment products and retail client statements

Analysis of pricing sources, market pricing hierarchy, retail client statements

Identified required changes for Front Office, Back Office, and Statement Composition

Ken Dinshaw 647-***-****

Analysis of transfers in and transfers out procedures

Created Business requirements document for Private Wealth Management division of CIBC

Identified issues and risks

Creation of process maps and data flows

Updated Accounting related documentation for securities transactions


Acquired knowledge of complex legislation for retail client statements

Acquired knowledge of statement creation and delivery to retail customers.

Enhanced accounting knowledge for various security types

RBC Investor & Treasury Services June 2011 – July 2013

Senior Business Analyst (Contract)

CDIC - FID (Fast Insurance Determination)

Translating CDIC regulatory data and system requirements into clear, concise, and understandable requirements.

Led and co-led requirements gathering sessions with Finance, Systems, Accounting, Risk Management, End Users, Development and Operations staff

Wrote and co-wrote Business Requirement documents for various vendor based and in-house custody systems

Created data mapping spreadsheets from various source systems to the CDIC required data extract for Depositor and Deposit Accounts

Documented business rules, data size, data type for data feed mapping spreadsheet for Extract, Transform, Load (ETL)

Creation of business process maps using swimlanes

Documented decisions, risks, issues on Sharepoint

Reviewed and commented on SRS, Traceability Matrices and Test Cases

Assisted in creation and review of power point presentations for steering committee

Data analysis extraction using MS SQL

Led and co-led business users and technical staff in translating business requirements

Excel macros for data analysis


Acquired knowledge of CDIC and their regulatory requirements

Created data source mapping documents

Performed QA tasks after QA personnel contracts concluded

FATCA – Foreign Account Tax Compliance Act

Collaborated in translating IRS legislation into functional requirements

Led or co-led discussions with legal, compliance, and tax subject matter experts to ensure alignment with FATCA regulations.

Utilized IBM Rational Composer to analyze, organize and manage functional requirements, process maps, glossary, assumptions risks, and linking them to business needs and goals

Distinguished between various types of US persons, US financial entities, US non-foreign financial entities and how their information is stored in various custody systems.

Led and co-led business users and technical staff in translating business requirements


Acquired knowledge of FATCA regulations

Utilized IBM’s Rational Composer for gathering, inputting, linking requirements, business rules

Acquired knowledge of Documentum scanning software

Enterprise Custody Platform – Canadian Subcustody

Worked with business sponsors, stakeholders, and various business groups to identify, comprehend and clarify business reporting requirements

Authored Business Requirement documents for end user reporting and data extracts for Canadian subcustody initiative

Report rationalization from current system for client and operations for transaction processing in Entitlements, Trade Orders, Inventory positions. Securities Transactions, Security Balancing, Taxation, Counterparty, Market, Credit and Liquidity Risks

SWIFT wire transfers (MT1xx-payments, MT2xx-FI transfers, MT3xx - Treasury, MT5xx - Securities, MT6xx - Treasury) and BIC codes

Testing of SWIFT messaging within UAT environment to ensure proper financial processing

Ken Dinshaw 647-***-****

Created report mock ups according to branding guidelines and presented reports to required users

Monitor and ensure accuracy of instructions and their related products originating from various parts of RBC Capital Markets or their clients

Liaise with system vendor, users, subject matter experts and other resources

Provided feedback and support of test plans and test scenarios

Monitoring and managing defects with HPQC software

Vendor Management – TATA Consultancy (TCS)

Verified various calculation from source systems using MS Access or Excel including PnL


Completed and reviewed several business requirement documents for Transactions, Positions, Counterparty, Tax, Market Risk, Credit Risk, Liquidity Risk, Asset Transfers, Trade Surveillance

Acquired understanding of Asset Custody business and related systems

Acquired detailed knowledge of SWIFT wire transfers

Royal Bank of Canada

Senior Business Analyst Sept 2010 – Apr 2011 (Contract)

Corporate Treasury BASEL III

Contributed to initiatives relating to developing, communicating, validating and implementing Liquidity Risk, Credit Risk and Market Risk measures methodology for BASEL III

Developed both high level and detailed requirements

Determine and document business rules for Extract, Transform and Load process (ETL)

Created detailed business process maps in swimlane diagram

Data source extraction using SQL

Data source analysis with MS Excel

Data extraction and analysis of capital market products sourced from various capital market systems for liquidity assessment

Analysis for Trading Credit, Credit Risk, Collateral Risk, Counterparty Risk


Completed and assisted several data flow diagrams and business process maps

Documented details for various process flows

Contributed towards peer reviews

Assisted in determining business process optimization

Scotiabank - Aug 2009 – Aug 2010

Senior Business Systems Analyst (Contract)

Enterprise Data Warehouse

Contributed to initiatives relating to various business lines including, Scotia Life Insurance Call Centre, Retail Fixed Income, Visa Credit products, Mortgages, Consumer Loyalty, Data Warehouse Enhancement and Web Portal Migration

Developed both high level and detailed functional requirements from business requirements

Contributed towards Source to Target mapping

Determine and document business rules for Extract, Transform and Load process (ETL)

Created detailed process maps with swimlanes

Performed data source analysis for development and data architects

Documented Service Level Agreements

Reviewed and contributed to SRS’s

Assist in the definition of project deliverables, work estimates and schedules

Designed several reporting templates using Cognos and Business Objects reporting tools

Data extraction and data source analysis

Drill down and Data Mining of summarized data

Led business users in obtaining their requirements

Data extraction and analysis with SQL

Ken Dinshaw 647-***-****


Completed and assisted in creation of 50+ data flow diagrams and process maps

Led or co-led sessions for reverse engineering and re-engineering business processes.

Contributed towards peer reviews

Acquired knowledge of Lotus Notes

Change management of enhanced business processes

CGI at TD Waterhouse - Nov 2008 – Aug 2009

Senior IT Consultant – Systems Integration and Consulting (Contract)

TD One Wealth Platform

Lead or assist in various work streams for translation of TD Waterhouse’s Wealth Management business requirements into comprehensive, complete and accurate functional and non-functional requirements

Analyze and document business and functional requirements according to SME and other BA’s

Contribute and recommend system solutions to meet business goals and product requirements

Determine and document business rules for input for conceptual designs

Assist in development and documentation of conceptual designs for key system processes

Communicate conceptual designs, requirements and business rules to developers for data modeling

Develop detailed functional requirements and associating them to appropriate business rules and business requirements

Assist in the definition of project deliverables, work estimates and schedules

Contributed towards conceptual designs relating to front, middle and back offices.

Exposure to Unitary and mutual fund processing


Completed several data flow diagrams and process maps for transaction processing for various security types

Well versed in Blueprint’s Requirements Centre Application

Contributed toward Joint Requirements Sessions (JRS)

CIBC – Sept 2006 –Sept 2008

Call Centre and Collections Technology (Contract)

Business Systems Analyst - July ’07 to Sept ‘08

Retirement of Legacy System

Elicit, analyze, validate and document business requirements for account processing including credit cards (Visa), mortgages, consumer loans, and lines of credit

Gathered and documented requirements for Business Intelligence project

Created and reviewed several Business Intelligence documents (BRD, SRS, Data Models)

Created and maintained Business Rules Catalogue for all terms relating to credit card, mortgages, consumer loans, lines of credit and other retail lending products

Created or assisted in creation of several mapping documents using excel spreadsheets

Documented data flow designs for current state and future state for financial products.

Assisted data modeler with data mapping in excel by defining data elements and their respective data types, field lengths and positions via data dictionary


Created and maintained Business Rules Catalogue and Source to Target mapping CIBC’s financial product portfolio

Created and maintained data dictionary

Additional documents created as required

Interviewed with all levels of personnel to elicit and comprehend requirements

Contributed in the creation of test strategies, test plans and test scripts for various business scenarios for CIBC’s financial product portfolio

Ken Dinshaw 647-***-****

World Markets

Business Systems Analyst - Sept ’06 to June ’07 (Contract)

Creation of new Database

Documented current process flows for data feeds for fixed income, forex, derivatives (futures and options)

Data source analysis for data feeds for fixed income, forex, futures and options in excel

Conducted analysis of current reports and report packages to recommend improvements

Assisted in conducting interviews with senior managers of various departments (trading, risk management, compliance, and back office) and documenting their requirements.

Assisted data modeler with data mapping – defined data elements and their respective data types and field length

Ensured data manipulation and data integrity from data source to data warehouse

Researched transaction and position discrepancies against ADP (Broadridge) data


Created data dictionary for 100+ data extracts

Completed several report design specifications for administration components and online reporting

Reverse engineered numerous processes and highlighted potential business process improvements

Moneris Solutions - April ’05 to July ‘06

Business Systems Analyst (Contract)


Created several detailed business design specifications for proprietary web based application for Point of Sale (POS) and payments processing for debit and credit cards process for the Acquirer business (Visa, Mastercard, AMEX)

Created GUI requirements documentation for e-business solution as determined by management and users

Designed administration and security design model for internal and external user access

Created design specifications for internal and external reports

Data flow designs and flowcharting

Defined data elements and their respective data types and field length for transaction table

Contributed several transformation rules for business needs in ETL process

Verifying data manipulation and data integrity from data source to data warehouse


Created Information access control matrix for internal and external users

TD Securities - Feb ‘04 to Feb ‘05

Senior Business Systems Analyst / Quality Assurance (Contract)


Application support for 3rd party vendor institutional fixed income trading application designed for front office (real-time institutional fixed income, repo trading), middle office (credit, risk management, limit monitoring, compliance) and back office (operations)

Coordinated parallel testing for middle and back offices and reconciling results

Creation of comprehensive test strategies, plans, manual test scripts, data, reports and documenting results

Vendor Management with Candeal, Prebon, Freedom, Brokertec, and Shorcan


Tested and implemented transaction types (Repos) and securities products (Mortgage Backed Securities)

Created report to reconcile security positions between two systems

Implementing STP (straight through processing) 3RD trade processing from Candeal, Prebon, Freedom, Brokertec, and Shorcan trading applications

Contributed toward seamless application upgrades for several trading applications to high profile users

Created test plans, test scripts for various business scenarios for a fixed income trading system

Ken Dinshaw 647-***-****

Scotia Capital Markets July ’98 to June ‘03

Senior Business Systems Analyst

CAMRA 2000 Jan ’02 – June ‘03

Application support for vendor application designed for straight through processing for institutional trading, inventory positions, investment accounting, and limit monitoring and regulatory reporting.

Defining user requirements, user specifications and processes.

Software testing in user assisted testing environment (UAT)

Liaise between front office, middle office, back office and developers


Created several Crystal Reports for users according to specifications

Developed strategy of application upgrade and implementation strategies

Documented and co-ordinate Data / Disaster Recovery processes


Support for vendor application designed for real-time institutional fixed income trading and inventory positions

Ensured proper workstation customization for traders, trading assistants, salespeople, trading management risk managers, compliance,

Software testing performed in user assisted testing environment (UAT)

Trading order management

Determined source of position discrepancies with ADP’s BPS204 and BPS212 files


Successful testing for new product coverage – Mortgage Backed Securities

FIXED INCOME RESEARCH July ’98 – March ‘00

Support of in-house application residing on VAX/VMS environment using relational database designed for storing fixed income dynamic data and static data

Documenting and co-ordinated software upgrades and patches


Successful Y2K planning, co-ordination, testing and implementation

Financial Models / Securities Valuation Company Oct ’90 – Jul ‘97

Data analysis / Database management for fixed income securities

Executed fixed income matrix pricing on a daily basis

Institutional client services

Contact this candidate