Manjiri Patil
Toronto,ON
Summary
14+ years of relevant experience as a Lead Business Analyst/ Product Owner providing Strategic Consulting, deciphering & gathering requirements, managing stakeholders and deliverables throughout SDLC in agile environment for large scale high visibility integration projects and programs within Capital Markets and wealth management for US and Canadian Banks. Extensively worked on projects for Trade Surveillance, Regulatory Reporting, Capital Market operations and Risk & Compliance functions for Wealth management and Capital Markets lines of business. Strong working experience with data analysis using SQL queries, data -mapping, data profiling, data sourcing and enterprise data migration leveraging DB2 and CASPIAN databases. Strong understanding of capital markets products such as equities and fixed income, wealth management business, provided strategic consulting for replacement and enhancement of trading systems, leading requirement gathering workshops and drafted RFI and RFP questionnaires for strategic initiatives. Well-acquainted with trade life cycle data flow, SWIFT messaging for capital markets products FX Spots, FX Forwards through front, mid and back-office systems Strong experience working with SWIFT (MQ) messages, FIS, Reuters, Bloomberg, DSTS and Euclid trading systems.
Overview
17
17
years of professional experience
1
1
Certification
Work History
Sr. Business Analyst – Wealth Technology
BMO Wealth Management
05.2025 - 08.2025
- Project Description: As part RISE PROGRAM, was responsible for documenting conversion requirements for BROADRIDGE data extracts for BMO Nesbitt Burns Line of Business for development of new platform for FNZ.
- Responsibilities:
- As part of BPS POD, created project artefacts – DRS (Detailed Requirements Document) and process flows for current and future state by documented functional and custom data extract requirements for Broadridge-BPS and ICS Functionalities like Scheduled events, ATON Transfers, Registered Products, DRIPS, SPAD Memos, Statements, Global and Domestic Proxies, Corporate Actions.
- Analysis of B204, B212 and B228 files for drafting custom data extract requirements to Broadridge.
- Documented requirements and produced process flows Convert and Migrate POD for Conversion Tranches
- Created Project artefact – Detailed requirement document stating functional requirements to Broadridge to mark Accounts, Branches and IA codes for each conversion tranche.
Lead Business Analyst – Enterprise Compliance
RBC
05.2023 - 03.2024
- Project Description: As part Project Emerald (RBC- HSBC Bank Integration) was responsible for data migration and integration for Enterprise Compliance and compliance function for all business verticals.
- Responsibilities:
- Spearheaded enterprise-wide compliance data migration and integration for Project Emerald (RBC–HSBC merger), leading a team of Business Analysts and Data Analysts to capture and validate structured, unstructured, and hybrid data across compliance verticals including Trade Surveillance, Registration, and Regulatory Reporting.
- Collaborated with cross-functional teams like Compliance IT team and Enterprise data team (project team); performed data profiling, data analysis, creating and documented requirements for building Relational Databases for Historic and Inflight data and to ensure accuracy of data received from HSBC team for Compliance data.
- Documented Data Ingestion requirements for Historic, Inflight, Structured, Unstructured and Hybrid data in existing RBC systems and Enterprise Data Repository.
- Build and maintained a repository of reusable requirements documentation to support future initiatives, following the enterprise standards in JIRA and CONFLUENCE pages.
- Provided advanced coverage analysis techniques to ensure relationship between scope, detailed requirements, and testing through to implementation.
- Chaired meetings with HSBC Business teams to discuss data requirements and ensure timely delivery of data.
- Support User Acceptance Testing by supporting planning, development of test cases and execution of tests.
- Documented and build future state (post-integration) business processes for compliance functions for business users in CONFLUENCE pages.
- Created benefit reports, status updates, facilitating small to large meetings, prepare meeting agendas and take meeting minutes using PowerPoint slides.
- Created and updated project plan and tracked activities in project plan for Compliance workstream in MS-Project.
- Work in collaboration with Senior Change Manager(s) to support change management activities where required.
- Represented Compliance team as PM at Enterprise level project meetings and provided updates and highlight project risks.
Lead Business / Data Analyst – Digital Direct & Risk Squad, Risk and Compliance Wealth Management Business and Capital Markets
Morgan Stanley
04.2021 - 04.2023
- Projects description:
- 1. Project: Model Development for Employee monitoring (Control Room) and Client Trade Surveillance of trading activities of Morgan Stanley.
- Rewrite and enhance existing trade surveillance models and alerts in ACTIMIZE to monitoring trading activities in accordance with Black-out trading, Front-running trades, Trading regulations on Employee and Employee Related accounts especially MS Financial Advisors.
- 2. Project: ETRADE – MS Merger – Data Migration from E- Trade in MS ecosystem for enterprise-wide trade surveillance for Wealth Business.
- Responsibilities:
- Collaborated with Risk & Compliance officers to define the scope of project for business requirements for Risk and Compliance Oversight Controls development for Black Out Trade, FA Front Running controls, Crypto surveillance Control, lead working session for eliciting business requirements for trade surveillance and monitoring trading activities of financial advisors.
- Led migration of E-Trade data into MS infrastructure, executing deep data analysis and domain object mapping across accounts, transactions, orders- executions, trades, and products.
- Build clients relationships and manage expectations, Project delivery via agile methodology and ceremonies like sprint planning, backlog grooming, daily scrums, sprint release, scrum retrospectives using JIRA and CONFLUENCE for tracking purposes.
- Design and create prototypes of Trade surveillance Risk & Compliance Oversight Controls and alerts for business validation
- Authored functional requirements documents and business logic for ACTIMIZE controls; validated data flows and supported alert development for enhanced monitoring.
- Support development team in creating detailed technical specifications and development user stories.
- Plan and conduct QA testing, prepare test cases.
- Conduct UAT and QA using Behavior Driven Development (BDD) test scenarios by extracting data via SQL queries to create test data, test case writing, planning and execution, User demos and plan release for deployment of Controls in production.
- Conducted extensive data analysis and data mapping using SQL queries by joining tables for E-Trade to MS Data for Accounts, Trade Orders, Products and Transactions into DB2 and CASPIAN databases post data conversion by Upstream Data Lake team for Risk and Compliance projects.
- Created and designed logics for extracting and loading data to/ from CASPIAN and DB2 databases for employee monitoring controls in ACTIMIZE.
- Draft Business logic to be set up in DB Domain Objects created from relational databases as part of data profiling, that is further leveraged by each Control for Alert detection, suppression, and generation in ACTIMIZE.
- Ensure data requirements for Controls are met successfully and data is available in lower environment for testing.
- Perform independent data validation for each ACTIMIZE Control and alerts.
Sr. Business Consultant /Lead Business Analyst – Banking and Finance
CGI
02.2017 - 04.2021
- CLIENT: BMO – SKIP Trace Process Automation – Automation of SKIP TRACE process for collections team, this involves customizing changes to collections product Collection 360 used by bank.
- CLIENT: BMO – Virtual Account Management (VAM) Solution – Strategic consulting for BMO’s Treasury & SWIFT Payment team to run with RFI and RFP to short-list vendor for VAM solution and prepared business case. (1st bank to rollout this offering in North American Market).
- CLIENT: CIBC - Capital markets Tech. - FIS Bonds Assessment – Strategic consulting for client to assess feasibility for replacement of FIS Bond Fixed Income ordering Application for CIBC’s Capital Markets and Wealth Business.
- CLIENT: BMO - Capital Markets LCCG Engagement – BA /Project/Release Manager for up gradation of Capital Market Legal & compliance Trade and Communication Surveillance Applications - ACTIMIZE, Conflict of Interest, Global Relay.
- CLIENT: BMO - E- Forms Digitization Project - $60 Million Digitization Project of Enterprise-wide Digitization of regulatory forms.
- CLIENT: BMO - Collections 360 – $50 Million Integration Project for Collections System, wherein 327 MS and 11 regulatory forms.
- Responsibilities:
- As a Sr. Business consultant/Lead Business Analyst, managed group dynamics, collaborated and lead requirements gathering session with diverse business partners, business stakeholders and senior management to define business objectives, processes, requirements and sign-off project scope.
- Planned Business Analysis project delivery milestones, created BA team estimates and ensured BA team tracks to deliver days using JIRA
- Demonstrated problem-solving aptitude by identifying inconsistencies and gaps within business processes, resolving complex multi-faceted problems of Business users and their internal/ external customers by applying business and technological knowledge.
- Conducted Gap analysis and extrapolated new requirements, documented current state and future state business process, performed SWOT analysis, requirements workshops, business process workflows, prototypes, whiteboards , user stories and created use cases.
- Conducted data analysis by extracting and loading data via SQL queries; reviewed and analyzed XML and JSON files for data intensive projects.
- Delivered project related artifacts (Business Requirement Document, Target Operating Model), work packages for projects using CONFLUENCE.
- Collaborated with Third- party Vendors for new application functionalities based on functional requirements in the planning, design, development and deployment of new applications, enhancements to existing applications.
- Managed all lifecycle phases for project and iterations for enhancements in agile environment.
- Assigning resources for projects. Estimating and forecasting costs for each phrase/iteration. Working with sponsors for project funding.
- Chaired risk workshops during planning phrase for risk identification.
- Scheduling and holding project kick-off meeting.
- Scheduled Releases, perform cost and schedule variance analysis, present project performance status and reports to Management. Analysis of change requests and provide report to Change Approval Board (CAB committee)
Sr. Business Analyst – Wealth Management
Broadridge
02.2016 - 02.2017
- Project description: Implemented Portfolio Management System (PMS) to modernize client’s portfolio management services to their clients.
- Responsibilities:
- Lead Business discussions to finalize and sign-off high level scope (HLS).
- Conducted Business requirements sessions with business users to document and finalize detailed requirements.
- Gathered requirements for Client onboarding, Trading & Order management, corporate events and settlement of trades by conducting interviews, Joint Application Design sessions, and user story walk through meetings with front office, middle office & back-office teams.
- Elicited requirements for system enhancements and changes to align with IIROC Regulatory reporting.
- Understood the system boundaries and design to enable effective requirements gathering and defining process models and determining logical model concurrently.
- Performed Gap Analysis to verify compatibility of the existing system infrastructure with Charles River PMS and highlighted shortcomings to the relevant internal stakeholders.
- Provided requirement walkthroughs with project teams.
- Facilitated clients in redefining their standard business operating procedures and ensured that business users adapt to change in procedures seamlessly.
Int. Business Analyst – Treasury/Capital Markets Operations
HSBC Bank
03.2012 - 12.2015
- Project Description: Enhancing HSBC.net – HSBC’s application for Regulatory Reporting. Scope included enhancing Canadian Reporting interface to DTCC’s GTR for Dodd-Frank Global Trade reporting regulation for FX (spots and forwards) and Equities.
- Responsibilities
- Reviewed business process documents to create business scenarios and incorporate these scenarios into business requirement documents to identify high-level scope.
- Elicited business requirements for Dodd-Frank trade reporting regulation from Front office traders, middle –office users related to FX and Equity trades executed, using various requirement gathering techniques such as end-user interviews, job shadowing and questionnaires.
- Documented detailed business requirements/mapping of 124 Data fields for FX confirmations and settlements including SWIFT messages like MT300, MT340, MT341 required for Global trade reporting (GTR) for Dodd-Frank Regulation.
- Conducted data analysis using SQL queries for large data sets.
- Created prototype reports and conducted usability study for business users.
- Prepared detailed business use cases to translate requirements for design & development team.
- Conducted JAD sessions to allow different stakeholders i.e. business users (users from Front office, middle office and back-office team) and development team to share perspectives, raise and resolve concerns to align on requirements. Developed traceability matrix of functional requirements
- Assisted QAs to create, execute test cases and verify test results.
- Developed basic SQL queries to query data from database.
- Created data flow/business process diagrams to illustrate the flow data.
- Assisted clients with post implementation activities such as user support, troubleshooting issues and user training /coaching to assist with implementing the new operational processes.
- Prepared workflow charts and diagrams to specify in detail operations to be performed
- Created status reports, summary reports and communicated accurate progress to stakeholders
Business Analyst – Investment Banking/Capital Markets Operations
RBS Bank
10.2008 - 02.2012
- Project Description: Automation of RIMS-SWIFT (settlement system) to facilitate straight-through-processing for settlements of Equities and Fixed Income products in European market stock exchange via SWIFT messages. The system was integrated with upstream applications: Murex, FIDESSA, Reuters and Euclid and downstream reconciliation application: INTELLIMATCH.
- Responsibilities:
- Gathered requirements to setup the entrance criteria for trade event processing and manual created settlement and payment instructions via SWIFT messages MT500’s and MT200’s (MT200, MT202, MT203, MT540, MT541, MT542 etc.) esp. Spanish, Dutch & German markets for OTC trades.
- Reviewed business system design, and technical specifications and identified gaps, ambiguous points and coordinated with respective team to address the gaps
- Interacted with the settlements team to create detailed process models based on the processes and business flows. Independently performed gap analysis and documented gaps between AS-IS and TO-BE focus.
- Created Use Cases using UML and managed the entire functional requirements life cycle using Rational Unified Process.
- Identified Use Cases from the requirements. Created UML Diagrams including Use Cases Diagrams, Activity Diagrams/State Chart Diagrams, Web Page Mock-Ups
- Created Process Workflow, Functional Specifications, Functional Specification Document (FSD), SOPs
- Authored design documentation which included: traceability matrices, functional specifications and Complex process and data flow diagrams using MS-Visio.
Education
Masters - Financial management
Jamnalal Bajaj Institute of Management studies
01.2014
Bachelors - commerce (Accounting & Finance)
Mumbai University
01.2006
Skills
- JIRA and CONFLUENCE
- XML
- SHAREPOINT
- MS-PROJECT
- JSON
- SQL
- VISIO
- Broadridge
- SWIFT (MQ)
- ACTIMIZE (Risk & Compliance Case Management Tool)
- Agile methodology
- Requirements gathering
Certification
- Pursuing Salesforce Administrator certification
- Profession Scrum Master (PSM 1) - 2018
Languages
English
Full Professional
Timeline
Sr. Business Analyst – Wealth Technology
BMO Wealth Management
05.2025 - 08.2025
Lead Business Analyst – Enterprise Compliance
RBC
05.2023 - 03.2024
Lead Business / Data Analyst – Digital Direct & Risk Squad, Risk and Compliance Wealth Management Business and Capital Markets
Morgan Stanley
04.2021 - 04.2023
Sr. Business Consultant /Lead Business Analyst – Banking and Finance
CGI
02.2017 - 04.2021
Sr. Business Analyst – Wealth Management
Broadridge
02.2016 - 02.2017
Int. Business Analyst – Treasury/Capital Markets Operations
HSBC Bank
03.2012 - 12.2015
Business Analyst – Investment Banking/Capital Markets Operations
RBS Bank
10.2008 - 02.2012
Masters - Financial management
Jamnalal Bajaj Institute of Management studies
Bachelors - commerce (Accounting & Finance)
Mumbai University