Summary
Overview
Work History
Education
Skills
Tools
Certification
Timeline
Generic
SANTOSH KUMAR HELA

SANTOSH KUMAR HELA

Mumbai

Summary

Result Driven Business Analyst with extensive experience at Tata Consultancy Services, specializing in capital markets and digital transformation. Proven expertise in business analysis and requirement gathering, driving successful project outcomes. Skilled in SQL and stakeholder management, I excel in enhancing trade applications and ensuring regulatory compliance, contributing to improved operational efficiency. across the IT solution

Overview

19
19
years of professional experience
1
1
Certification

Work History

Business Analyst

Tata Consultancy service (TCS)
Kolkata
06.2022 - Current

Project : CITI ICG MSST Cash Securities (CCP-EXG) Capital Market

Client : CITI

  • Gather Business Requirement from stakeholders trading desk & clearing ops for cash securites & derivatives/Bondsvia CCPs (LCH, CME, LME, AUSTRIA, ICE, Euroclear)
  • Conducting gap analysis of existing clearing flows vs enhanced EXG Models involving trade novation & netting Logic
  • Create BRD FRD & process Flow for cash securities from Xceptor to EXG (IM, VM, Collateral, Guarantee)
  • Mapped Trade attributes (eg. ISIN Cusip, COB, SETTL_CCY,) to CCP connectivity Formats
  • Collaborated with the Xceptor team to develop automated workflow for enrichment & validation of trade attributes to EXG submission
  • Define trade life cycle events & configured cash securities in Xceptor for enrichment, validation & routing to Downstream
  • Collaborate with cross functional teams & work closely with technology teams & support User Acceptance Testing (UAT)created test case for trade events

Business Analyst

Tata Consultancy service (TCS)
06.2020 - 01.2022

Project : SSBT ERM/ Global Market Risk

Client : SSBT

  • Engaged stakeholders to gather, finalize, and review requirements, ensuring alignment with project goals.
  • Enhanced Trade Exposure and Monitoring Application for Agency Lending, Custody VAR Automation AFS, and Fact Repo.
  • Created detailed process and data flows; mapped UI to database and conducted thorough data validation.
  • Conducted business and data analysis, writing user stories and BRD for new netting strategies in securities lending.
  • Performed data quality checks on transactions and exposures failing in production, analyzing failure causes.
  • Generated CCST Algo stress scenario reports, adding new scenarios per business requirements, reviewing CCAR for compliance.
  • Collaborated on user stories and acceptance criteria, supporting development team in defining 'Definition of Done.

Business Analyst

Tata Consultancy service (TCS)
06.2016 - 01.2020

Project: BFSI (Depository Trust Clearing Corporation) DTCC

Client : DTCC

  • Engaged with Product Owners and multiple stakeholders for requirements elicitation, analysis, and documentation, Including BRD/FRD, AS-IS TO-BE analysis and Gap Analysis created Mock Wireframes in collaboration with the UI Team
  • Part of digital Transformation team in DTCC for modernization for multiple Squads for rewriting the application. (SPA) Security Process Application
  • Documented entire requirements in the form of user stories, created and managed artifacts in JIRA and Confluence, and generated user stories for UI & API with detailed documentations
  • Facilitate Training for Modules, Workflows & Trade soft Applications, Securities Processing Application (SPA), AIM Custodian and CEDE Vault, P-Lite Module Business Users.
  • Participate with a team in sprint Planning & sprint retrospective sprint grooming in a scrum
  • Facilitates session with the testing team to help in identification of Test scenario & Test Cases with & participate in User Acceptance Testing (UAT)/ Production Implementation

Senior Associate

Tata Consultancy service (TCS)
Mumbai
04.2011 - 01.2016
  • Resolve trade breaks on fixed income securities which arise due to different reasons – Quantity difference, price difference, Cost difference
  • Derive pricing for portfolio investments. Updating status reports & Act as an intermediary between the funds and their investment managers and serve as the official record keepers for the Funds.
  • Cash & Position recons done to let the investor know the number of shares held by client at the end of the trading day,
  • Reconciliation between fund administrator (SEI Alternative investment located in USA) and broker

Research Analyst

Carol Securities Pvt Ltd.
Delhi
02.2010 - 04.2011
  • Providing Research support to institutional and retail clients as per industry & sector wise, prepare a research report and manage a portfolio of clients.

Associate

Bank of America
Delhi
08.2007 - 01.2008
  • Conducted ad-hoc research, including data gathering and analysis for investment strategies.
  • Performed income stream analysis and evaluated fixed income investments for portfolio managers.
  • Analyzed SEC filings to prepare comprehensive investment presentations.
  • Executed measurement and performance reporting of various stocks and funds using proprietary databases.

Associate

Sovereign N V Securities pvt Ltd
Delhi
07.2006 - 07.2007
  • Analyse the Indian Equity market, conducting research on different stock & Industry as per sector wise, giving assistance to Clients & manage a portfolio, ensuring customers delight, as well as generate revenue for organization.

Education

MBA - Finance

Indian Institute of Planning and Management
New Delhi, India
New Delhi, India

Post Graduate Computer - Computer Science

CMC
W.B., India
W.B., India

B.A. -

Seth Anand Ram Jaipuria College
India
India

Skills

  • Agile methodologies and Scrum framework
  • Change management
  • Business analysis and requirement gathering
  • Data analysis and digital transformation
  • GAP analysis and documentation (BRD, FRD, FRS)
  • Trade lifecycle and derivatives
  • Capital markets and investment banking
  • User stories, epics, and features
  • Problem solving and decision making
  • Stakeholder management
  • Risk analysis
  • Product backlog prioritization
  • Software development lifecycle (SDLC)
  • SQL and database management (MongoDB)
  • Project management tools (JIRA, Confluence)
  • Data visualization (Power BI)
  • Financial software (Bloomberg, Xceptor, Alteryx, Techia)

Tools

JIRA | Confluence | SQL | Power BI |MongoDB| Techia | Bloomberg |Xceptor | Alteryx |Trade Soft Application TEM (Transaction and Exposure Monitoring)

Certification

  • Certification in Agile Methodology (TCS Internal)
  • Certification in Power BI (TCS Internal)
  • Certificate in Business Analyst- Requirement Gathering (TCS Internal)
  • Certification in AI Dashboard using Microsoft Power BI (Skill Nation)
  • Certification in Alteryx Foundational Micro-Credential

Timeline

Business Analyst

Tata Consultancy service (TCS)
06.2022 - Current

Business Analyst

Tata Consultancy service (TCS)
06.2020 - 01.2022

Business Analyst

Tata Consultancy service (TCS)
06.2016 - 01.2020

Senior Associate

Tata Consultancy service (TCS)
04.2011 - 01.2016

Research Analyst

Carol Securities Pvt Ltd.
02.2010 - 04.2011

Associate

Bank of America
08.2007 - 01.2008

Associate

Sovereign N V Securities pvt Ltd
07.2006 - 07.2007

MBA - Finance

Indian Institute of Planning and Management

Post Graduate Computer - Computer Science

CMC

B.A. -

Seth Anand Ram Jaipuria College
SANTOSH KUMAR HELA