Sansad Kumar Panigrahi
Fanwood,NJ
Summary
18+ years of experience as a Business Analyst with solid understanding of Counterparty Credit risk , Financial regulation along risk management with Business Requirements Gathering, Business Process-flow, Business Process Modeling, Data Analysis and Data Mapping.
Overview
18
18
years of professional experience
1
1
Certification
Work History
Vice President
SMBC
02.2023 - Current
- SMBC CM is an established derivatives dealer with a broad product portfolio, with specific emphasis on interest rates and foreign exchange products such as interest & FX swaps, FRAs, options, exotic products, commodity derivatives as well as exchange traded products such as treasury bonds, interest rate futures & options, currency futures, treasury futures & options, etc.
- Created Business and reporting requirements of SR 11.10 for counterparty credit risk which includes measurement of exposure at various levels of aggregation, concentration identification and measurement, stress testing to inform the banking organization’s exposure and concentration management, credit valuation adjustment measurement and management, and wrong-way risk measurement and management.
- Evaluating different Discount and floating index curves required for pricing and simulation of all different products
- Analyzed trade, CP (MSA and CSA), collateral data in PRISM (Trade booking System).
- Engaged with risk modelling team to define or enhance PFE methodology for existing or new products
- Analyzed and validated exposures (PFE) for any limit triggers and credit limit breaches
- Monitored CCR analytics for large DoD and MoM moves in PFE and MPE
- Reviewed top 20 counterparty exposures and collateral balances on daily basis.
- Provide month-end commentary for large exposure moves in top 20 exposures, for industry/country exposures, for product exposure analysis across IR, FX and non-derivative transactions
- Worked along with Credit Value Adjustment/XVA (CVA, DVA, FVA, FVL) teams for building the book of work and defining business requirements for BAU and Regulatory projects, enhancements .
Business and Data Analyst
Capgemini
09.2022 - 01.2023
- Company Overview: OneTick Trade Surveillance gives the power to monitor and protect their trading in both fully hosted and deployed configurations.OneTick Surveillance solution, built on top of the OneTick proprietary tick database and stream processing platform, delivers robust, configurable built-in alerts to support executing brokers: layering and spoofing, quote stuffing, wash trading, marking the close, and more
- Creating Data Requirements for Swaps (UST, IRS, FX and Currency, CDS) to onboard into onetick market data surveillance
- Creating and monitoring Alerts like layering, spoofing, cross trades and wash trades on various swap products
Business and Data Analyst
LTI and Iris Software
11.2017 - 08.2022
- Client :Citibank
- Scoping the Source Systems, Negotiate and Source data needed from various business asset classes by engaging with multiple stakeholders
- Creating data specification, mapping, quality for EMIR, SFTR, CFTC, CAT Regulation.
- Managed the SPIDER System with New requirements which includes the Disclosure of Interest and the trade surveillance for Positions data
- Worked on the reference data model like Account masters table and security masters table to ensure the lineage of data
- Implemented Data model for Golden Data source (Trade Data) which included data from Reference Data management like Product, Corporate action, Price, Security, Position, Account and Counterparty
- Ensuring Data Completeness, consistency, conformity, accuracy, Integrity and timeliness across all the data models
- Data lineage from front office trade data to post trade data
- Procuring all the collateral and margin data points from various systems to meet the EMIR and SFTR Requirements
- Building Data Model (Data Specifications) on the below: Daily Margin Calls, Margin Exposure, Collateral Balances and Position, Collateral Movements (Collateral Pledge In/Out)
- Products involved in Collateral Management: Securities Financing Transaction SFT (Repos, Reverse Repos, Security Lending, IRS, CDX and Options), Exchange Traded Derivatives (Initial Margin, Variation Margin, Maintenance Margin)
- Business Analysis and validation for the Completeness and correctness of data from various source systems and define business transformation rules / mapping logic for the new sources
- Creation of BRD, FRD, Epis, User Stories, Acceptance Criteria, Test Strategy and Test Scenarios involved in entire SDLC
- Used SQL queries extensively to do database testing and Data analysis
Senior Business Analyst
Cognizant
10.2015 - 10.2017
- Client :World Bank (IFC)
- Enhancements of Trade functionalities in SUMMIT and INVESTRAN
- Working on Summit (Misys) and Investran (Sunguard) Trade Accounting and Settlement and/or regulatory reporting
- Conversant at a functional level with the Misys Summit System (Trade blotters, Market Data, STP, Exception Blotters)
- Analyzing of the OTC trade life cycle (origination, trade modeling and execution, risk management, hedging, limits, credit risk management, ISDA standards and confirmations, reset processing, settlements, option event management)
- Worked on the Investran data model, Accounting and reporting hierarchies, transaction types, batch templates, Active Templates, Allocation Rules, Data Import Utility, and Report Wizard
- Worked in OTC Derivatives (IRSs, TRS, CDs, Options, FX)
- Liaise with colleagues within the Client’s Global network covering UK, Europe, USA and APAC in defining business processes and strategic approaches to meet Investment Operations outsourcing deliverables
- Analyze current OTC Derivatives operations processes, identify gaps in workflows, research system defects and inefficiencies, recommend and create new solutions to fill these gaps by leveraging expert derivatives business knowledge
- Writing BRD and FRD and creating Test cases
Senior Business Analyst/Scrum master
TCS
05.2011 - 09.2015
- Client : United Service Automobile Association(USAA) :MIGRATION OF BROKERAGE PLATFORM & REGULATORY COMPLIANCE, BASEL 3
- Responsible for ensuring compliance with various aspects of exchange regulatory requirements concerning portfolio reconciliation
- Creation of BRD and FRD and Test cases
- Requirement Gathering of the OTC trade life cycle (origination, trade modeling and execution, risk management, hedging, limits, credit risk management, ISDA standards and confirmations, Novation, Unwind, compression, settlements, option event management)
- Identifying, investigating, and escalating material disputes and discrepancies arising from Uncleared Margin Rules Reporting progress on dispute resolution efforts to senior business partners
- Interact with Front Office (traders and marketers), Middle Office (product control relating to derivative product risk and P&L process), Back Office (master agreements, confirmations, trade/rate valuations, margins, and confirmations), Corporate Treasury and Global Securities Operations, Pricing Team (price verification), and Credit Risk Management Team
- Applied Iterative/Agile model in each SDLC phases, involved in daily Scrum Calls/Meetings, and incorporated change requests throughout the project lifecycle
- Worked with developers to develop and document technical specifications of system document
- Used SQL statements for Back-end testing
- Worked with Scrum Master in implementing Agile SDLC processes, including ticketing system, burn down charts, scrum sessions, and sprint and product backlogs
- Created Test Plans, Test Requirements, Test Hierarchy, Test Cases and Test Scripts with QA
Business Analyst
TCS
07.2007 - 04.2011
- Company Overview: TCSBancs
- Client – Societe Generale bank and National Commercial Bank
- Worked in banking products including savings, checking, overdraft and deposit accounts
- Conduct ed interviews and workshops with stakeholders to understand their needs and gather detailed business requirements.
- Developed and document current and future state business process models to visualize workflows and identify areas for improvement.
- Proposed and design technical and process solutions that align with business needs and objectives
- Created detailed functional specifications outlining system requirements to guide development teams.
- Conducted Requirement Analysis and GAP Analysis to document BRD, FRD and Use Cases
Education
Masters in Business Administration - Finance
School of Inspired Leadership
01.2012
Bachelors of Technology - Electrical and Electronics
Vellore institute of technology
01.2007
Skills
- SQL
- MS Office Suite
- SharePoint
- JIRA
- MS-Visio
- Power BI
- Oracle Pl SQL
- HIVE
- CFTC
- EMIR
- SFTR
- CAT
- BASEL
- SDLC
- Waterfall
- Agile
- IRX
- ETD
- SFT
Certification
Algorithmic Trading, Quantinsti
Residency - Status
Canadian Permanent Resident & US H1B holder (I140 Approved)
Executive Programme in Algorithmic Trading Executive Programme in Algorithmic Trading QuantInstiQu
Modules Covered :
1. Statistics for Financial Markets
2. Python: Basics & Its Quant Ecosystem
3. Market Micro structure for Trading
4. Equity, FX & Futures Strategies
5. Data Analysis & Modeling in Python
6.Machine Learning for Trading
7.Trading Tech, Infra & Operations
8.Advanced Statistics for Quant Strategies
9. Trading & Back-testing Platforms
10. Portfolio Optimization & Risk Management
11.Options Trading & Strategies
12. R for Quantitative Trading
Languages
Hindi
Full Professional
English
Full Professional
Timeline
Vice President
SMBC
02.2023 - Current
Business and Data Analyst
Capgemini
09.2022 - 01.2023
Business and Data Analyst
LTI and Iris Software
11.2017 - 08.2022
Senior Business Analyst
Cognizant
10.2015 - 10.2017
Senior Business Analyst/Scrum master
TCS
05.2011 - 09.2015
Business Analyst
TCS
07.2007 - 04.2011
Bachelors of Technology - Electrical and Electronics
Vellore institute of technology
Masters in Business Administration - Finance
School of Inspired Leadership
Similar Profiles
Dean ZhouDean Zhou
Senior Analyst - Acquisition, Leverage Finance at SMBCSenior Analyst - Acquisition, Leverage Finance at SMBC
Subramanian NatarajanSubramanian Natarajan
Rates Trader at SMBCRates Trader at SMBC
Amit GopeAmit Gope
Senior Application Developer at SMBCSenior Application Developer at SMBC