Post Job Free
Sign in

Business Systems Analyst - Financial Services

Location:
Toronto, ON, Canada
Posted:
October 26, 2026

Contact this candidate

Resume:

HARLEEN KAUR

BUSINESS SYSTEMS ANALYST BUSINESS ANALYST

Toronto, ON 289-***-**** **********@*****.***

PROFESSIONAL SUMMARY

Business Systems Analyst with 9+ years of experience translating business needs into functional requirements, system specifications, data mappings, and testing solutions across financial services and insurance. Skilled in stakeholder workshops, gap analysis, user stories, process modelling, REST API mapping, SQL-based data validation, and end-to-end UAT. Experienced in Agile/Scrum delivery and partnering with business and technology teams to resolve system issues, improve workflows, and support reliable implementation.

CORE SKILLS

Business Analysis: Requirements Elicitation, Stakeholder Workshops, JAD, Gap Analysis, Business Rules, User Stories, Acceptance Criteria, Use Cases, Functional Specifications, RTM

Business Systems Analysis: Current-State/Future-State Workflows, Process Mapping, BPMN 2.0, UML, Systems Integration, REST APIs, JSON/XML, Source-to-Target Data Mapping, Data Dictionaries

Data & Reporting: SQL, Data Profiling, Data Validation, Data Reconciliation, ETL Verification, Data Quality, Power BI, Tableau, Power Query, KPI Reporting, Dashboard Development

Testing & Delivery: Agile/Scrum, Jira, Confluence, MS Visio, draw.io, SIT, UAT, Defect Triage, Test Case Coverage, Root-Cause Analysis, Change Management

PROFESSIONAL EXPERIENCE

Senior Business Data Analyst BNP Paribas Canada

Toronto, ON November 2025 – Present

Project: Institutional Multi-Asset Trading Execution and Order Management Gateway

Gather business and system requirements from institutional trading desks for order routing, trade allocations, and pre-trade credit verification.

Document source-to-target data mappings and REST API request/response fields for order fills and downstream clearing feeds.

Use SQL to validate execution blotters, position allocations, trade reconciliations, and data quality across business systems.

Develop Power BI dashboards to monitor order latency, execution fill rates, queue exceptions, and operational performance.

Analyze complex datasets and investigate exceptions to identify root causes, business impacts, and process improvement opportunities.

Developed SQL queries using JOINs, aggregations, CASE statements, subqueries, filtering, and conditional logic to investigate business and data-related issues.

Senior Business Systems Analyst Desjardins Financial

Toronto, ON June 2023 – October 2025

Project: Commercial Loan Origination Modernization and Credit Assessment Platform

Facilitated stakeholder workshops to define requirements for commercial credit intake, financial statement spreading, and risk-scoring workflows.

Prepared Functional Specification Documents (FSDs) and mapped API integrations between the loan intake portal, credit bureau feeds, and core subledgers.

Wrote SQL queries to validate borrower data, credit decision history, and interest and fee calculation feeds.

Coordinated end-to-end UAT with commercial credit underwriters, managing test execution, defect logging, and triage in Jira.

Validated data migration through source-to-target reconciliation, checking record counts, key fields, relationships, and transformation rules.

Analyzed workflow gaps and data-quality issues with business and technology teams to support resolution and process improvements.

Business Systems Analyst Desjardins Financial

Toronto, ON / Montreal, QC May 2019 – May 2023

Project: Capital Markets Analytics and Asset Allocation

Gathered and documented requirements for Bloomberg analytics covering historical market trends, yield curves, and projections.

Created process flows and UML activity diagrams in MS Visio to map order placement, risk management, and trade settlement processes.

Used SQL to validate trade tickets, pricing feeds, and settlement status updates; investigated exceptions and data issues.

Worked with end users, business stakeholders, and technical teams to clarify requirements and resolve process issues.

Developed dashboards to track settlement volumes, failed trades, aged transactions, and high-value exceptions.

Business Systems Analyst Desjardins Financial

Toronto, ON / Montreal, QC May 2019 – May 2023

Project: Mortgage Collections, Default Risk and Enterprise Data Warehouse Integration

Defined business rules for mortgage delinquency risk categories, repayment schedules, customer demographics, and call reporting.

Documented source-to-target mappings between the collections application and enterprise data warehouse (EDW) for business intelligence reporting.

Facilitated stakeholder workshops, developed use cases, and coordinated UAT sign-off with mortgage risk operations managers.

Translated reporting needs into dashboard requirements, KPIs, metrics, and reporting logic; supported user training and adoption.

Partnered with technical teams to investigate data defects, identify root causes, and validate fixes.

Business Analyst BNP Paribas Canada

Toronto, ON March 2017 – April 2019

Project: Web Broker Portfolio Management and Order Routing Portal

Gathered functional requirements for portfolio modelling and trade order routing with cross-functional advisory teams.

Developed user stories, acceptance criteria, use cases, business rules, and workflow diagrams using Agile delivery practices.

Coordinated System Integration Testing (SIT) and User Acceptance Testing (UAT) to verify order routing against business and risk requirements.

Used SQL for post-implementation validation and created dashboards to monitor data quality, settlement exceptions, transaction aging, and process performance.

Business Analyst RSA Insurance

Toronto, ON April 2014 – June 2017

Project: CRM Redesign and Underwriting Platform Migration

Conducted gap analysis and requirements interviews with SMEs to define current-state and future-state CRM workflows.

Documented web and functional requirements and prepared Functional Specification Documents (FSDs) within Scrum delivery.

Tracked defects in Jira and Confluence, reviewed test coverage, and led UAT with underwriting teams.

Used SQL to analyze customer activity, account information, and transaction history for CRM reporting and data validation.

Investigated failed test scenarios, validated defect fixes, and analyzed user feedback to recommend workflow improvements and automation.

EDUCATION & PROFESSIONAL DEVELOPMENT

Bachelor of Science in Computer Science & Information Systems 2014

Advanced SQL for Data Analytics

Cloud Data Architecture Essentials

PMI Agile Certified Practitioner (PMI-ACP) coursework



Contact this candidate