Summary
Overview
Work History
Education
Skills
Certification
Personal Information
Mobile Numbers
Timeline
Generic

Vivek Lohani

Gurgaon

Summary

I am a seasoned Business Analyst with over 8 years of expertise in the financial services industry, specializing in data management, regulatory operations, settlement, reconciliation, and middle-office processes. Demonstrated success in client onboarding and reconciliation setup using Intelli Match, complemented by comprehensive expertise in Futures and Options. Strong capability in changing management and driving process improvements that enhance operational efficiency. Proficient in managing data test concepts, advising clients on robust data strategies, and delivering operational excellence through effective automation and analytics.

Overview

8
8
years of professional experience
1
1
Certification

Work History

Business Analyst

Saxo Bank
Gurugram
01.2021 - Current
  • Client Onboarding & Reconciliation: Designed and implemented effective client onboarding and reconciliation processes for new partnerships, such as Aspire, ensuring seamless data integration and high-quality outputs.
  • Agile and Waterfall Methodologies: Utilized Agile and Waterfall methodologies to manage projects, balancing flexibility and structure to meet project deadlines and stakeholder expectations.
  • Documentation & User Stories: Authored comprehensive Business Requirement Documents (BRD) and Functional Requirement Documents (FRD). Developed detailed user stories to capture requirements and guide development.
  • Quality Assurance & Service Reliability: Acted as a quality gateway for data integration and reconciliation setup using FIS Intelli match, leading to enhanced service reliability and operational accuracy.
  • Sprint Planning & Moscow Method: Applied the Moscow method for sprint planning to prioritize tasks based on stakeholder needs and project goals, ensuring focus on critical deliverables.
  • Broker & Custody Reconciliation: Established broker and custody reconciliation processes using FIS Intelli match to ensure precise and timely fee settlements, contributing to improved financial accuracy.
  • Process Automation & Improvement: Supported initiatives to enhance STP (Straight-Through Processing) and initiated process automation strategies to improve operational efficiency.
  • Change Management: Led change management activities, including detailed testing, documentation with Confluence, and effective stakeholder engagement, fostering seamless transitions and adaptations.
  • Data Analysis & Dashboard Creation: Conducted SQL-based and Python-based analyses, created monitoring dashboards using Power BI and Grafana, and wrote Python scripts to automate smaller team processes.
  • Domain Knowledge & Collaboration: Maintained extensive domain knowledge across equity settlement, mutual funds settlement, futures and options, regulatory updates, trading lifecycle, and investment products. Collaborated effectively with global middle-office teams in Denmark, Singapore, and India to optimize BAU processes, ensuring operational efficiency and compliance with industry standards.
  • Key Projects
  • Client Onboarding (Aspire at SAXO): Successfully owned and managed all reconciliation processes, including Trade, Cash, Derivative, Fee Reconciliations, and additional onboarding activities. Ensured seamless integration and execution to enhance client experience and operational reliability.
  • Custody Migration & Legal Mergers: Played a significant role in strategic projects involving custody migrations from Citibank to ABN AMRO, and legal mergers within Saxo entities across EU markets. Contributed to project planning, execution, and stakeholder communication, ensuring smooth transitions and compliance with regulatory requirements.
  • Clearing Broker Migration: Led the project for migrating a new clearing broker from a middle-office perspective. Managed the complete Futures and Options workflow, including execution setup, account creation, and IT developments related to Exercise, Assignment, Expiry, and Contra bookings. Ensured successful IT integration, operational compliance, and seamless execution flow to support trading activities and client requirements.

Trade Settlements Business Analyst

Brown Brother Harriman - Hexaware Technologies Ltd.
Pune
08.2019 - 12.2020
  • Responsible for processing settlements of trades on time and completing daily tasks with effective cooperation with other teams within the company and sub-custodian banks, with significant involvement in the migration of a new project from Infosys to Hexaware in the Trade Settlement Process, acting as a Business Analyst to manage the flow of trade settlements.

Assistant Manager

Karvy Stock Broking Limited
Hyderabad
02.2018 - 07.2019
  • Manage existing client portfolios.
  • Advise clients on buy, sell, and hold strategies.
  • Generate brokerage by encouraging intraday and F&O trading.
  • Cross-sell third-party products like mutual funds, ULIPs, insurance, IPOs, and bonds.
  • Provide clients with updates on economic condition.

Education

Master’s in business administration - Finance

Graphic Era Hill University
01.2018

Bachelor of Commerce -

MBPG College
Nainital, KU
01.2016

Intermediate - CBSE

Jawahar Navodaya Vidyalaya
U.S Nagar
01.2013

High School - CBSE

Jawahar Navodaya Vidyalaya
Almora
01.2011

Skills

  • SQL
  • Python
  • Power BI
  • Confluence
  • Grafana
  • Manual Testing
  • UAT
  • Agile Methodologies
  • Waterfall Methodologies
  • Client Onboarding & Data Integration
  • Data Management & Reconciliation (FIS Intelli match)
  • Financial Products (Equities, Derivatives, Structured Instruments, Cash Products)
  • Understanding of Regulatory & Compliance
  • Investment/Trade Lifecycle Operations
  • Change Management & Requirements Engineering
  • SDLC

Certification

NISM Series 8 Equity Derivatives, NCFM Financial Modelling, Atlas Award by Saxo for 2021, Wolf of Dalal Street by Karvy

Personal Information

Date of Birth: 06/26/95

Mobile Numbers

  • 9720157681
  • 7906245741

Timeline

Business Analyst

Saxo Bank
01.2021 - Current

Trade Settlements Business Analyst

Brown Brother Harriman - Hexaware Technologies Ltd.
08.2019 - 12.2020

Assistant Manager

Karvy Stock Broking Limited
02.2018 - 07.2019

Master’s in business administration - Finance

Graphic Era Hill University

Bachelor of Commerce -

MBPG College

Intermediate - CBSE

Jawahar Navodaya Vidyalaya

High School - CBSE

Jawahar Navodaya Vidyalaya
Vivek Lohani