Sign in

senior business analyst

Toronto, Ontario, Canada
April 23, 2018

Contact this candidate



Email id:; Contact # 647-***-****

Senior Business Analyst with 8+ years of experience in Investment Banking and Risk Projects. Assiduous, proactive & achievement-oriented professional with demonstrated strengths in Business and Technical Analysis, Process Maps, System Design, integration and implementation of IT business solution with reference to Structured Products, Fixed Income, Equities, Derivatives, Risk & Compliance. Experience in Requirement gathering, documenting and revising system design procedures, test procedures, quality standards, Defects Tracking. Providing advice on Information system strategies, policy management, and security and service deliveries. Strong communication & interpersonal skills, with abilities to multi-task, handling risks under high-pressure environment.

Experience Summary:

Over 8 years of experience as a Senior Business Analyst and Managing projects as Assistant Manager with frontline leadership role in System Development Life Cycle (SDLC).

Strong subject matter expertise with extensive experience and strong knowledge in capital market and its products (FI & EQ), including their structures, valuations, P&L attributions, Risk (Market, Credit), VaR, trade lifecycle. and experience in the domains of Banking, Regulatory Reporting,Accounts Management, Client Reporting, Transaction analytics, Global Custody, Equities, Fixed Income, Derivatives, Financial Statement Analysis, Data mapping & analysis, Reference data, Trade Finance, Corporate Actions, Dodd Frank, Basel III, CCAR and SCCL.

Excessive awareness of the financial services products - Equities & Fixed Income, Hedge Fund & Mutual Fund, Assets and portfolio analysis. Expertise in Asset/Risk Management, Process Migration, Claims Management, Audit & Reporting, Risk Analysis

Accomplished in Business Analysis, System Analysis, Risk Management and Project Management with extensive experience in business products, operations and Information Technology on the capital markets space specializing in Finance such as Trading, Fixed Income, Equities, Bonds, Options, and Mortgage with sound knowledge of broad range of financial instruments

Extensive experience in stock distribution, cash distribution, alternate asset servicing processes.

Extensive experience in implementing Software Development Life Cycle (SDLC) principles and methodologies such as Agile, and Waterfall Method in development.

Expert in writing Functional and non- Functional requirements.

Highly experienced in conducting Gap Analysis and Feasibility Analysis to check the compatibility of the existing system infrastructure with new business requirements.

Conducted in project assessment, functional analysis and requirements gathering and converting business requirements into functional requirements.

Expert in interaction with the stakeholders, planning, facilitating, and organizing working sessions with cross-functional resources and mentoring to meet and exceed business needs.

Conducting JAD sessions with the technology areas, interviews, written correspondence, reports, implementation requirements, project status reports, oral presentations and email, to keep executive staff and team members apprised of goals, project status, and resolving issues and conflicts.

Skilled in developing testing scenarios and testing scripts.

Extensive knowledge of UML modeling, Drawing Sequence Diagrams, Flow diagram and Activity diagram using tools such as Microsoft Visio and Rational Rose.

Proficient with Information System Strategy, Policy Management, Security and Service Deliveries. Implementing Business solutions at end product level to provide efficient and accurate results.

Extensive knowledge of managing Diversified Portfolios of Corporate Clients, Retail and HNWI investors.

Expert in trading Stocks and Derivatives which include Stock Futures, options and Commodity futures for the corporate clients and retail investors.

Proficient with Microsoft Office tools (includes MS Project, MS Visio, MS Access, MS Excel, MS Word, MS PowerPoint, MS SharePoint).

Skilled in coordinating and communicating between Developers, QA Teams, Management, QA and project leads and stakeholders to keep them informed at all the times about the development and the open issues.

Exceptional communication skills, Result oriented professional who combines formal education/certifications with experience gained from research and hands-on opportunities.

Analytical, methodical and resourceful approach to problem solving, identifying root causes and corrective actions to meet short and long-term business as well as financial and system requirements.

Versatile mix of Technical Strengths:,

Methodologies: SDLC, Agile, Waterfall,RUP

Process/Model Tools: MS Visio, Power BI, Jira, UML Diagrams

Diagrams, Activity Diagrams,

Sequence Diagrams, Bloomberg, TLM

FISS, Intellimatch, IMS

Project Management: MS PowerPoint, MS Access, Excel,

SharePoint, Confluence

Axiom - Controller View

Certification Status

IAQ (London) Completed

Green Belt Certification Completed


CBAP Pursuing

Client: Scotiabank, Toronto

Senior Business Analyst

Project: Axiom Controller View / Single Counterparty Credit Limit & Large Exposure Nov 2017- Jan 2018

Scotiabank project – Axiom – SCCL and Large Exposure is to develop a risk reporting system which maintain a risk assessment to ensure compliance with Basel 283: Large exposure framework and OSFI’s ongoing requirement for Large Exposure. The system will be used as the primary reporting tool for developing the reports, which will be used for direct submission to the national supervisor.

Working directly with a global cross-functional stakeholder community to assess current business processes and determine how these can be improved (e.g. business process re-engineering, new technologies, minor adjustments to existing process)

Co-coordinating with different lines of business

SCCL and Basel 283 implementation guidance document

SA-CCR – Standardized approach for Counterparty Credit risk ascertainment

Look through Approach implementation for Special Purpose Vehicles.

Credit Risk Mitigation for CDS and Collaterals, Repo, Rev-Repo, Stock Borrow/Lending

Proof of Process & Process Flow Diagrams

Client: Barclays, NYC

Senior Business Analyst

Project: Octon- Liquidity Risk and CMReporter Nov 2016- Oct 2017

Barclay’s project – Octon – Liquidity Risk and CMReporter was to develop and maintain a risk assessment system to ensure compliance with Fed Reporting Requirement based on Dodd Frank and Basel 3: Large exposure framework. The system will be used as the primary reporting tool for developing the reports, which will be used for direct submission to FED.

Working directly with a global cross-functional stakeholder community to assess current business processes and determine how these can be improved (e.g. business process re-engineering, new technologies, minor adjustments to existing process)

Managed and completed CCAR schedule for counterparty credit risk. Worked across groups to implement Fed-prescribed scenarios for annual and mid-year CCAR.

Implemented Single Counterparty Credit Limits ( SCCL)based on Fed requirements, Defined exposures to counterparties connected by certain controlled relationships beyond those set out in definition of counterparty.

Documented business requests and created business cases for new functionalities and enhancements requested by clients.

Developing future state business processes as well as the required activities to achieve the target end state.

Defining functional requirements, which reflect the business requirements and developing approaches to enable them to be delivered via process changes / technology solutions.

Developing approaches and tools to test new solutions and business processes prior to use. Coordinating test planning and end-user testing of newly built processes Identifying and escalating as appropriate issues that may arise during the various stages of the change process (i.e. from analysis and design through to adoption).

Worked closely with business owners, end users, cross functional groups, stakeholders of various geographies to define, gather, and analyze specifications.

Participated and contributed in daily scrums, Sprint meeting and Sprint review meetings

Prepared BRD, FRD and assisted in preparing Technical Design Document.

Provided functional inputs and provided sign off in creating and reviewing Logical and Physical Data Models.

Created backlog with user stories and acceptance criteria, Designed sprint and assigned story points. Projected Burndown chart to management stating the progress of the sprint and project.

Worked closely with product owner to design the structure of the sprint with approachable time frame. Acted as Scrum Master while conducting scrums.

Performed and documented Gap Analysis to determine deltas between existing and proposed systems.

Performed data mapping from Source to Warehouse and then to Mart to on board the data.

Conducted Knowledge Sharing sessions with the Development team and testing team to provide functional aspect of the project and provide the Business rules.

Facilitated sessions for volume requirements, design reviews and periodic sessions for on-going progress.

Created scripts in SQL to populate data into Referential tables.

Investigated and resolved data quality issues across platforms and applications

Developed Test Strategy, Test Scenarios, Test Cases for SIT and UAT Testing

Company : Barclays, India July 2015 - Oct 2016

Assistant Manager/ Senior Business Analyst

Project: Treasury Execution Services and Investment Function

Barclays Treasury execution Services and Investment Function project was to develop and maintain a risk assessment system to ensure compliance with Basel –III:Liquidity coverage ratio .The system will be used as the primary planning tool for developing the supervisory plan, which will detail examination, monitoring, and review activities

Delivered accrual-based metrics methodology for Treasury's Investment Function to improve their P&L and risk management.

Delivered various client-facing projects for bank’s Official P&L and Risk calculation via full SDLC. Work closely with stakeholders from Front Office, Middle Office, Risk Management, and Product Control, Quantitative Analytics, and Market Risk Project team to validate and analyze measures such as P&L, P&L attributions and Market Risk, and enhance the existing P&L attribution methodology.

Provided business requirement analysis, functional design, specification writing, and testing to critical BASEL III and Volcker Rule enforcements, including Incremental Risk Charge (IRC) reporting, Credit Support Annex (CSA) discounting, Inventory Turnover, Liquidity risk, Client-facing Trade Ratio.

Lead analyst to build Money Market trade capture platform via full SDLC. This includes: requirement solicitation, BRD (gap analysis, “As Is” vs. “To Be”), QA training, UAT and end user training, and deployment. Agile methodology was adopted for the whole development cycle to obtain business users signoff at each milestone.

Supervised analysts to onboard new business to IB's infrastructure STP for global Treasury’s liquidity pool portfolios – Loans, Bonds, L/D, CD/CP, IRS (with SEF implementation under planning); so to consolidate reporting across all asset classes and provide bank’s aggregated P&L and Risk reporting.

Lead analyst and hands-on to decommission firm's legacy reporting tool and replace 1000+ legacy reports with 200+ strategic reports from hypercube.

Manage the communications and relationships to all the users from regional LOB.

Senior Business Analyst – Rates Official P&L and Risk Calculation & Reporting.

Lead analyst to bring the Fixed Income securities and derivatives of all the emerging markets (LATAM, EEMEA, and APAC) to Barclay’s Rates valuation platform.

Managed and supported regression test and UAT.

Debugged analytic issues with extensive SQL usage, code reading and close interaction with Quant team and any other up-stream dependencies.

Company: Barclays, India Aug 2014 - June 2015

Assistant Manager/ BA- Strategy Consultant

Project: Wealth Management Client Reporting

In the context of Barclays Wealth Management and Market expansion strategy, to define the client reporting requirements scope for the initial service offering to support the US region. Projecting Client Reporting initiative in the broader context of Barclay’s strategy and secured key stakeholder commitments to the proposed scope.

Collaborated with internal stakeholders, including Relationship Managers, Investment Advisors, Client Experience, Client Marketing, Sales, Product Managers, Operations, Technology and Legal in defining the future state vision, outlining a roadmap for mobilization and prioritizing capabilities for future deployment and delivery phases.

Based on service offer definition work stream input and output from executive interviews, defined and documented business requirements for the “family” relationship report, a consolidated summary of client accounts at the firm on a single statement, to support targeted client segments and internal stakeholders.

Defined granular level functional specifications for the relationship report, enabling client designated account aggregation, total assets, liabilities, cash flows, income, and valuations tracking across the portfolio, asset type, multi-currency and region-based asset allocation views and alternative investments reporting, including structured products, private equity and hedge funds

Achieved performance reporting transparency through the integration of money-weighted, net of fees performance overview, analysis of portfolio returns against indices, customized blended benchmarks and risk exhibits, thereby enabling Relationship Managers and Investment Advisors to conduct a more value-added in-depth relationship reviews, identify expansion opportunities, and provide clients with on-demand performance updates

Created the relationship report visualization mock up and facilitated, budgeted and negotiated the RFP (Request for Proposal) process and vendor selection with four report design firms. Identified and applied key selection criteria, such as use of graphics and color to illustrate key areas, including asset allocation and performance, font size and style, simplifying information and delineating sections, appropriate disclaimer placement and budgetary constraints

Company: Barclays, Singapore Feb 2012 – Aug 2014

Senior Business Analyst

Project: Market Risk and Mark to Market analysis

Barclays Shared Services underwent functional re-design to enrich the customer trading experience with new features and capabilities. The goal of the project was to allow customers to perform research on Stock Rates, Structured products and bonds providing them with complete news and stories about the recent events related to investments.

Prepared, analyzed AS IS and TO BE of existing architecture and performed Gap Analysis.

Served as a liaison between the business team and project team by assisting the business in identifying, understanding, and documenting their business needs.

Utilized various Moody’s tools to check the credit risk measurement, economic and consumer credit analytics.

Consolidate Trade Date and reconcile from across multiple settlement platforms like equity, bond market, derivatives and commodity market.

Provided technical assistance in identifying, evaluating, and developing systems and procedures that are cost effective and meet business requirements.

Created workflow scenarios, designed new process flows and documented the Business Process and various Business Scenarios and activities of the business from the conceptual to procedural level.

Proficiently managed client facilitation meetings to gather Interface and Business Process Requirements from Subject Matter Experts (SME’s) in trading shares, equities and Fixed Incomes like bonds, and converted them into functional requirements by implementing the RUP methodology, authored the same in Business Requirement Document (BRD).

Collected and documented the business processes and business rules, translated the Business and User needs into System requirements. Provided key input in working with users in defining project and system requirements.

Created UML Diagrams like Sequence Diagrams, Activity Diagrams and process flow diagrams to elaborate the processes using Rational Rose and MS Visio.

Directed and managed the Change Control process for the project as a whole by facilitating group meetings, one-on-one interviews and corresponding through emails with work stream owners to discuss the impact of change request on the project.

Effectively coordinated with the plan owners to update the project plans with any impact due to a change request. Verify if the contingency plan will absorb any delay in project due to change request. Track progress on updates in project plans.

Involved in developing the test strategy and assisted in developing test plans, test case objectives and test cases. Developed Test scenarios, test plan, test conditions and test cases to be used in testing based on business requirements, technical specification and/ or product knowledge

Company :TCS /Citigroup, India

Business Analyst - Canadian Fund Accounting NAV

Project: Accurate Pre- NAV reporting Feb 2011- Feb 2012

Project Description: Develop tools with which the accurate NAV can be calculated so that it can be released in the market in hassle free manner on timely basis. Enable team to work proactively on the various files at a time which will cut down the turnaround time for one fund and speedy calculations can be generated.

Oversaw the valuation and accounting of Canadian/ US hedge funds and mutual funds .Updated the clients and syndicate with any changes to NAV and impacts acquisitions and mergers .Reviewed the reconciliation of company's books and custody books

Coalesced the trade transactions based on Buy/Sell/Short Sell/Buy to Cover into the systems. Monitored & Recorded the changes on derivatives, asset backed mortgages and securities .Construed baseline foundation to eliminate income volatility

Calculated & formulated preliminary NAV reports and cash projections for next 2 days. Dealt with NYSE, FTSE100, London stock exchange, Toronto stock exchange, OTC markets and Canadian stock market. Analyzed and amalgamated reports on portfolio performance

Conducted Knowledge Transfer sessions to Development and Testing teams.

Created BRD, FRD and assisted the Development and Testing teams in preparing Technical Design Document and Integrated Test Plans.

Developed and Documented User Stories, use cases and facilitated Story Point discussions to analyse effort levels.

Developed flow diagrams for Business process of the company, UI Wireframes and Mock ups using Microsoft Visio

Worked extensively through Agile development methodology by dividing the application into iterations

Prepared end-to-end data mapping document for Development and Testing teams

Acted as a Single Point of Contact to all the clients, developers, testers on functionality of the application.

Provided timely status, updates, risk and issues log to the higher management.

Performed data validation, data integration and backend testing using SQL Queries.

Worked with Testing team in defining Test Scenarios, Test Cases for SIT and UAT Testing

Company: HSBC, India

Business Analyst- Hedge funds

Project: End to end income processing Dec 2009 - Feb 2011

Description: HSBC hedge funds income team receives various types of incomes in their system. The project dealt with identifying the correct funds for which the income is for and applying it to the fund account (dividend /coupon/ swap/fees). The differentiation among the amounts can be done based on the client it is coming for and the shapes it is coming in. It has to be identified correctly based on the instrument type and should be auto calculated and accrued correctly in the system.

Collaborated with Fund Managers on weekly and daily basis for generating reports on portfolio performance .Reviewing Income data after the SWIFT message is received from the client. Auditing the data inflow as per fund types.

Calculated and booked all the currency contracts - spots and forward contracts. Amalgamated various reports for portfolio performance. Resolved queries of clients and syndicates. Adhering to market risk and regulatory requirements.

Gathered and analyzed requirements from Business users and SMEs and documented BRD, FRD etc. implemented SWIFT enabled Positions and Trades processing system.

Successfully used d/Scrum Method for gathering requirements and facilitated user stories workshop.

Created BRD, FRD, MDD, Business dictionary and other related business documents

Created Use Case Diagrams, User Stories, Data Flow Diagrams, Business Rules to understand and finalize the Functional and Quantitative requirements

Organized Knowledge Transfer sessions with the Development and Technical teams and prepared Traceability matrix to ensure all the requirements have been developed and tested thoroughly.

Conducted workshops with end users, developers, testers to analyze and rectify open issues and bugs identified during Testing process.

Created UAT Scenarios, UAT Test cases and UAT scripts and assisted Business users in UAT execution


August 2007 – September 2009: Masters of Business Administration with specialization in Finance and Computers Application, Institute of Engineering and Management (Kolkata, West Bengal, India)

June 2004 – July 2007: Bachelor of Commerce in Finance & Computers, Calcutta University, (Kolkata, West Bengal, India)


Global Exposure of working in Singapore in 2012 & 2013 for Asset Servicing & Client Money Project and was solely responsible for their execution

Awarded High-rated Employee for 2 consecutive years in Barclays

Achieved 5 white belt certificates resulting from System Enhancement (JIRA), Risk Mitigation, Time Save

Contact this candidate