Sign in

Business Analyst

Oakville, ON, Canada
October 29, 2018

Contact this candidate


Neha Mahajan

Toronto, Canada Cell: 647-***-****


Client-focused dynamic professional with varied experience in Business Analysis in Banking & Financial services industry across Canadian/ US and UK Banking industry

Executed few very high-profile projects with a successful track record, including Regulatory Compliance and Tax initiative projects- Capital Market - MiFID, US FATCA / OECD CRS, IFRS9 regulatory reporting (accounting standards) and other projects involving -System Integration, Mergers and Acquisition

Experience with Regulatory reporting frameworks across multiple jurisdictions and Regulatory bodies

Rapid prototyping Business process and systems and designing proposed target operating model

Proficient in preparing System Requirement Specs (SRS)/ Functional Specs, Business Requirement Document (BRD), conducting business case, gap and impact analysis across diverse lines of business, using various requirement management tool JIRA, HP Quality Centre (HPQC), ALM

Analysis of the business needs in the form of Use Case Diagrams, Use Case Narratives, Activity Diagrams using UML Modeling, Data Flow Diagrams (DFD) and Functional Flowcharts

Master data management (MDM) and ETL experience in designing for large business processes

Analyzing large sets of data in excel spreadsheets and executing SQL queries, in-depth Knowledge of ORACLE, MS Access, Informix and SQL Server

Extensive experience in modeling business processes (BPM tool-ARIS); using prototyping approaches to confirm requirements and design in MS Visio

Implemented QA methodologies - Agile-Scrum, practices, and processes in all types of system architecture design- Front end, middle ware and back-end.

Proficient with MS Office products, particularly Visio, Excel, and PowerPoint, Outlook

Fair understanding of SDLC, application architecture, cost / time / risk / scope / incident / change management, SLAs and relationship building between IT, clients, vendors and the business community

Strong Aptitude in establishing quality standards & best practices for large-scale project initiatives, meeting with Governance team / Project board, complying and strictly abiding with the scope, objective, SLAs and relationship building between IT, clients, vendors and the business community

Domain / Competencies

Business Analysis Regulatory IFRS 9, FATCA, CRS Capital Market - MiFID MUREX Treasury Operations

Stress Testing Governance & Controls CCR Risk TSYS MDM ETL UML Agile Business Process

Modeling UNIX Quality Center/ ALM HLTML 5

Professional Experience

BMO Capital Markets Toronto, Canada

Role: Sr. Business System Analyst June 2017 – Sept 2018

Project Profile: Capital Market- MiFID –II (Markets in Financial Instrument Directive)

Working with the Regulatory Compliance support group, supporting Capital Market regulations across various jurisdictions/ regulatory bodies – UK (FCA), EU (ESMA)

Worked across various Regulatory initiatives Best Execution reporting, Costs & Charges disclosures and SI Threshold monitoring, across varied asset classes- Currency Derivatives, Commodity Derivatives, Equity Derivatives, Fixed Income, OTC Derivatives

Designing detail requirement specifications (DRS), Data mappings and decomposition artifacts, business process/ procedural documentation for implementation and adherence to BMO’s compliance with MiFID II

Worked across MiFID-II Costs & Charges disclosure requirements and analyzed margin (mark-up/ mark down/ MTM) reporting requirements for financial instruments

Working with third party vendors ‘TRAX’, ‘Bloomberg’, Reuters, Trade Web to design the specifications for MiFID-II Regulatory reporting, Best Exec reports across regulators FCA, Bank of Ireland (BOI)

Actively engaged in the regulatory report support, reconciliation, relevant categorization of exception, warning and informational errors and working close with business for resolution

TD Securities Toronto, Canada

Role: Business Analyst Nov 2016 – May 2017

Project Profile: Capital Market- MiFID –II (Markets in Financial Instrument Directive)

Working with the Regulatory Compliance- Strategic Initiative group, within TD Securities Capital Market, supporting various business operations across Canada, UK and EU

Conducting traceability mappings & requirements analysis between ESMA/ EU regulations, Business requirements and solution design to provide and auditable view of TD’s compliance with MiFID II regulations

Interface with multiple stakeholders across Risk, CCR, operations and technology to validate, develop appropriate business requirements, business processes and technology solutions

Conducting feasibility assessment of the existing source systems and conducting impact assessment with the new regulations and recommending proposals for the future state/ To-Be systems

Design changes to existing business operating models and processes to ensure TD’s processes are optimized and adherence to Business Process management and change management

Conducting functional specification mapping of MIFID trade data reporting requirements, analyzing system’s impact vs. impact on compliance, legal, business procedural manuals/ client information

Executing SQL queries, to analyze the existing trade data set and documenting ‘To-Be’ data mappings for the new data fields

JP Morgan Chase Toronto, Canada

Role: Sr. Business System Analyst Sept 2013 to Sept 2016

Project Profile: US FATCA, OECD CRS, IFRS 9,

Worked on diverse Regulatory Tax Compliance projects, conducting initial impact assessment, with extensive engagement during the project analysis/ design phase leading to Business acceptance testing (BAT) and successful implementation into BAU transition utilizing Agile methodologies and practices

Analyzing the ‘As-Is’ and ‘To-Be’ business processes. Documenting existing business processes and systems and designing revised processes to accommodate new and enhanced reporting requirements

Working closely with solution architects to analyze data sets/ data models, producing functional specifications from source to target for ETL processes and User interface for AXIOM tool in HLTML 5

Worked on different elements of ‘Counter Party Credit risk’, such as calculation of EAD, PD, LGD

Monitored risk exposures from Treasury operations and investigated on large exposures and variances

Leveraging third party tool (AXIOM/ HYPERION) to generate reports to the Regulator in a compliant format and delivery, facilitating the development and test team in design, build and test activities.

SCOTIA BANK Toronto, Canada

Role: Business Systems Analyst Oct 2012 to Aug 2013

Project Profile: FATCA US Regulatory Compliance

Implementing US FATCA Compliance initiative at Scotia Bank's Canadian banking system

Analyzing and Interpreting the new regulatory requirements, seeking engagement with various business groups, understanding the implications of FATCA and performing impact analysis, effort estimation.

Planning and defining the project scope and creating detailed business requirements document (EDD) for FATCA implementation project. Leveraging existing systems, customer data (MDM) for developing FATCA release implementation road map.

Developed use cases, defining & documenting user procedures and workflows for FATCA aggregation of account balances, scanning for US Indicia and other internal reporting requirements.

Working with IT and business stakeholders across the group to define rules against which the data quality is measured.

Prototyping FATCA reference tables for creation of new FATCA database, analyzing existing data models and executing SQL queries to analyze source data inputs (MDM, Customer Data)

TD BANK Toronto, Canada

Role: Sr. Business Systems Analyst Apr 2012 to Oct 2012

Project Profile: TD-MBNA Bank Merger

Plan, manage, and lead the delivery of detailed business requirements and user workflows that align to TD’s standards and frameworks, utilizing Agile methodologies and practices

Eliciting new business requirements; conducting business analysis for the TD’s iHub Integration system.

Translated conceptual user requirements into Activity Diagrams; Use case diagrams and flowcharts utilizing Visio that is comprehensible to project team.

Documented plan for delivery of detailed business requirements to contribute to the development of the project plans including project deliverables, cost/benefit analysis, time line estimates

Designing Business workflows from MBNA to TD’s TSYS platform for card services KYC/ AML scenarios

Assisted in the implementation roadmap planning and strategy for successful delivery during Pilot Phase


Role: Business Analyst Mar 2010 to March 2012

Project Profile: Compliance with MiFid (Markets in Financial Instruments Directive)

Analyzing & Modeling the ‘As-Is’ and ‘To-Be’ business processes in Visio; documenting existing business processes and developing future business processes to improve business performance.

Documenting detailed business requirements and conducting walk-through session with key stakeholders and ensuring any ambiguities in the business requirements have been resolved

Analyzed static reference data requirements for MiFid reporting.

Supporting the implementation process including preparing the training materials, procedural manuals, user guides and release notes

BANK OF AMERICA, Merrill Lynch Delaware, USA

Role: Business Analyst Jan 2009 to Feb 2010

Project Profile: MiFid Reporting

Eliciting business needs from Compliance and Business stakeholders to interpret the changes to reporting under MiFid.

Classifying the gathered requirements into Business rules, Functional and Non-Functional requirements. Translating business needs into functional specifications (FRD).

Facilitating workshops with Development and Testing teams to walk-through the functional specification document and assisting in designing test scripts.

Supporting System Integration and UAT testing, ensuring the business requirements are developed and tested as per the Functional specifications document.


Bachelors (Finance/ IT), M.B.A (Finance)

Contact this candidate