Summary
Overview
Work History
Education
Skills
Certification
Projects
Accomplishments
Beyond Academics
Synopsis - Summary
Timeline
Generic

Kaushal Dalal

Toronto,ON

Summary

Senior Specialist - Business Analyst having more than 12 years of experience with Master’s Degree in Business Management (Finance), B.E. (Electronics) Managing ETL logics of Deposit product for Centralize Data Warehouse (Genesis) of Citi Bank for all 90 countries with 3000+ feeds. Successfully implemented Consent Order requirement of FED for Deposit Insurance Calculations discrepancies in Global Liquidity Risk Reports versus Local reporting for Citi Bank. Worked on credit risk PD, LGD, CCF models implementation for capital calculation as per IFRS9 norms for HDFC Bank. Successful bank vide implementation of Pooling, Bad Flagging & Risk Estimation system for retail loan portfolio to calculate ECL for HDFC Bank. Implementation of ETL and rule based logic for the system to calculate Expected Credit Loss for bank. Professional offering several years achieving success in industry. Highly qualified and skilled leader. Priority on driving business growth and motivating teammates to consistently exceed goals.

Overview

12
12
years of professional experience
1
1
Certification

Work History

Senior Specialist - Business Analyst

LTIMindtree
03.2020 - Current
  • Company Overview: CITI Bank
  • Deposit Logic Maintenance for Genesis (Data warehouse): Ensuring consistency & enhancement of ETL logic (TRL) for more than 3000 deposit feeds for all 90 countries where Citi operates
  • Responsible to update logic for Staging/Dmart/UAL/Manual Scripts/Derived Elements & IFW reports to users
  • Enhancing logics of Data model/ETL/Default Templates/User maintained templates for adjustment positing in line with upstream changes
  • Liaising with all 90 country controllers to ensure logics for deposit insurance calculations for local reporting is in sync with global reporting
  • FDIC: Responsible for regulatory requirement of the Federal Deposit Insurance Corporation where attestation of the CITI Bank for yearly deposit insurance compliance & attestation
  • Ensured that appropriate data pertaining to NAM region for Deposit product flows to the insurance calculation engine and manages T+1 requirement of the regulator
  • Worked on the project of on boarding new consumers to centralized data warehouse which collects Insured/Uninsured amount from FDIC insurance engine and send it to downstream consumers
  • Intercompany Breaks: Providing resolutions to the breaks that occurred in the intercompany transactions.
  • Doing map gap/logic/enrichment analysis for migration of existing system to the new platform
  • Liaise with Global Product Controller team to understand & resolve breaks occurred due to inconsistency in the attributes like rates/dates/ toxic combination of trades/missing contracts in in intercompany transactions etc
  • CITI Bank

HDFC Bank
12.2017 - 02.2020
  • IFRS: OFSAA (Oracle Financial Services Analytical Application) implementation for IFRS9 ECL calculation
  • Capital Computation (CRAR) of the bank under Standard & FIRB approaches for Retail portfolio
  • Facilitate the transition of the bank from Standardized to IRB approach
  • Estimation of the Expected Credit Loss (ECL) & Credit Risk Impact of the newly proposed IFRS guidelines
  • Computation of risk estimates for Probability of Default (PD), Loss Given Default (LGD) & Exposure At Default (EAD) used in AIRB and Ind AS reporting
  • PARCC: Implementation of Pooling Automation And Risk Component Computation project for different products like auto loan, gold loan, LAP, Inventory Funding, Credit Card as per BASEL norms
  • The system is used to provide feed to calculate risk estimation

Morgan Stanley
12.2015 - 05.2017
  • Company Overview: On demand Agility
  • Worked in internal audit team for credit risk data analysis and validation
  • Worked on model validation by using different statistical techniques
  • On demand Agility

Business Analyst

GoldenSource Corporation
11.2012 - 12.2015
  • Worked as Business analyst in collecting and analyzing requirements, designing business solutions and solution validations
  • Worked as quality analyst in scrum team to perform UAT
  • Analysis of the current Enterprise Level Financial Data Management Software and customization of it for financial products like equity, derivatives, commodities etc as per the requirements of the major investment banks & stock exchanges around the globe
  • Compiling functional specifications based on business requirements with consideration to data model, data management, process, business rules for various LOBS’
  • Explaining requirements to the Development & QA group and ensuring that the product being built meets the requirement
  • Audit and Traceability of Vendor Data: The requirement is for audit and traceability functionality developed for enterprise financial data for end of the day pricing, corporate action, curves, derived data sets like correlation matrices and volatility surface etc
  • The requirement provides multi dimensional view to address the challenges of the risk relevant data (eg
  • Calculation of VaR) on the platform designed to cater macro view of the financial data across the enterprise level
  • Clients: Ameriprise Financial, HSBC, Deutsche Bank, Nordea Bank, Charles Schwab

Education

MBA - Finance

IIPM
01.2012

BE - E & C

Sarvajanik College Of Engineering & Technology
01.2009

Skills

  • Root-cause analysis
  • Process optimization
  • Stakeholder engagement
  • Proficient in SQL and Excel
  • Risk management
  • Analytical thinking
  • Documentation management
  • Quality assessment

Certification

  • Certified Scrum Product Owner (CSPO)
  • National Eligibility Test (NET-2012) qualified

Projects

Tracking & analysis of INR depreciation against USD during OCT-2011 to DEC-2011. To study the nature of financial derivatives including futures and options.

Accomplishments

  • Received appreciation from Citi Bank CFO for successfully implementing a requirement of FED's observation within a month in collaboration with Upstream/Downstream partners
  • Achieved excellent in Financial Management.
  • College topper in Economics for Managerial Decision Making.
  • Got excellent in Derivatives- Options and Futures.
  • College topper in International Finance and statistics lab.

Beyond Academics

  • Participated in integral part of National Level technofest KSHITIJ-2007 team and worked in Lodging & Boarding committee.
  • Participated in ROBOTICS event of National Level technofest KSHITIJ-2007-08.
  • Participated in Model Presentation event of KSHITIJ-2008.
  • Sales committee member in INVEST-X.
  • Participated in Blood Donation camp.

Synopsis - Summary

Senior Specialist - Business Analyst having more than 12 years of experience with Master’s Degree in Business Management (Finance), B.E. (Electronics & Communication). Managing ETL logics of Deposit product for Centralize Data Warehouse (Genesis) of Citi Bank for all 90 countries with 3000+ feeds. Successfully implemented Consent Order requirement of FED for Deposit Insurance Calculations discrepancies in Global Liquidity Risk Reports versus Local reporting for Citi Bank. Worked on credit risk PD, LGD, CCF models implementation for capital calculation as per IFRS9 norms for HDFC Bank. Successful bank wide implementation of Pooling, Bad Flagging & Risk Estimation system for retail loan portfolio to calculate ECL for HDFC Bank. Implementation of ETL and rule based logic for the system to calculate Expected Credit Loss for bank.

Timeline

Senior Specialist - Business Analyst

LTIMindtree
03.2020 - Current

HDFC Bank
12.2017 - 02.2020

Morgan Stanley
12.2015 - 05.2017

Business Analyst

GoldenSource Corporation
11.2012 - 12.2015

MBA - Finance

IIPM

BE - E & C

Sarvajanik College Of Engineering & Technology
Kaushal Dalal