Ankit Khatri
Gurugram
Summary
Accomplished fixed-income professional with over 14 years of expertise in pricing fixed-income securities, SQL, and client management. Proven proficiency in various asset classes, including bonds and credit default swaps, with a track record of establishing effective products and processes in India. Strategic thinker dedicated to optimizing resource utilization to enhance operational scalability and profitability. Recognized for strong organizational skills and natural leadership abilities, which foster relationship-building within teams.
Overview
15
15
years of professional experience
Work History
Director/Senior Manager, Product Specialist
Markit Intelligence, S&P Global
Gurugram
01.2025 - Current
- Overseeing and improving the convertible bond pricing model to enhance accuracy and efficiency.
- Spearheading the development of a new GSAC pricing platform aimed at delivering high-quality pricing and analytics.
- Leading the pricing technology group to drive automation initiatives across multi-asset pricing teams.
Regional Operations/SME Associate Director
Markit Intelligence, S&P Global
Gurugram
04.2021 - 12.2024
- Led the Evaluated Bond Pricing team, which provided an independent pricing service for over 150,000 government, sovereign, agency, and corporate bonds worldwide, operating from India.
- Managed a team of 15 members across two primary products: Parsing and Evaluated Bond Pricing.
- Developed an innovative pricing model (Jump Diffusion Model) for convertible bonds, improving upon the traditional Black-Scholes Model, and performed comprehensive model validation.
- Evaluated over 20,000 bonds across diverse currencies and sectors using yield curves (relative spreads), dealer-driven prices, rules-based pricing, and comparables.
- Generated data quality reports using SQL and Power BI, including large variation reports, staleness check reports, event information reports, auto-approved levels, and upcoming INR issues, which assisted evaluators in improving bond price quality and reducing client challenges.
- Designed queries on Snowflake to meet client requirements and created dashboards for enhanced management insights.
Regional Operations Manager/ SME Principal
IHS Markit
Gurugram
04.2017 - 03.2021
- Established and led the Bond Pricing team in India, successfully managing a team of 9 members.
- Evaluated over 20,000 securities across diverse currencies and sectors using yield curves, dealer-driven prices, composite pricing, and comparables.
- Validated securities that breached data quality checks, including wide bid-offer spreads and credit market assessments, prior to publication to clients.
- Calculated liquidity scores based on various metrics and conducted post-evaluation checks on securities that exceeded established thresholds.
- Managed and reviewed daily benchmarks to ensure accurate valuation of corporate bonds.
- Developed comprehensive data quality reports using SQL and Power BI, including large variation reports, staleness check reports, event information reports, auto-approved levels, and upcoming INR issues, which aided evaluators in improving bond price quality and reducing client challenges.
- Created a pricing model for convertible bonds utilizing the EWMA and Black-Scholes-Merton models with SQL and VBA in 2018.
- Automated multiple processes, such as tracking new bond issues and US savings bonds, reducing processing time from 4 hours to just 10 minutes, while also streamlining feed upload processes.
Assistant Vice President, Team Lead
IHS Markit
Noida
04.2015 - 03.2017
- Established Evaluated Bond Pricing operations in India, expanding the team from 2 to 8 members.
- Facilitated the transition of tasks from the US to India, ensuring seamless operational continuity.
- Conducted coverage checks on client portfolios while managing client onboarding and post-sales support.
- Compiled monthly management reports to evaluate query handling, turnaround times (TAT), and resource needs.
- Successfully migrated municipal and corporate bond clients to a new data delivery platform with minimal disruption to business operations.
- Assumed ownership of the coverage check process across multiple Markit products, including Bonds, Loans, CDS, Municipal Bonds, and Structured Products.
- Provided support to evaluators in addressing and filling coverage gaps.
Assistant Vice President, IC
IHS Markit
Noida
04.2012 - 03.2015
- Delivered real-time quote parsing services through Markit Parsing, extracting indicative and live over-the-counter (OTC) pricing from email communications and publishing the data for buy/sell side clients.
- Trained new team members and supervised their performance to ensure adherence to standards.
- Analyzed pricing and messaging patterns across various asset classes, including Bonds, CDS, Indices, ABS, MBS, Options, and more, received from different trading desks via Bloomberg Terminal.
- Reported misparsed message patterns to the parsing development team, employing regression analysis and validating fixes in both QA and production environments.
- Coordinated with the development team to implement parsing rules, drive improvements, initiate new projects, and assess results in QA and production.
- Generated reports on Credit Index options with implied volatility using the Black-Scholes Model after conducting various data cleaning tests.
- Maintained capacity and data quality matrices to analyze monthly team utilization and ensure optimal data quality.
- Developed SQL queries (Oracle-based) to support daily operational tasks.
- Created automated reports using the Jasper tool for both internal and external clients.
Associate
IHS Markit
Noida
06.2010 - 03.2012
- Analyzed pricing and messaging patterns across various asset classes, including Bonds, CDS, Indices, ABS, and others, received from different trading desks and dealers.
- Implemented parsing rules in accordance with the trading conventions specific to each asset class.
- Reported misparsed message patterns to the parsing development team, utilizing regression analysis and testing fixes in both QA and production environments.
- Collaborated with the development team to implement parsing rules, drive improvements, initiate new projects, and evaluate outcomes in QA and production.
- Developed SQL queries (Oracle-based) to facilitate daily operational tasks.
Education
PGDBM - Finance
Institute of Marketing & Management
New Delhi01.2010
Bachelor of Commerce -
Chaudhary Charan Singh University
Meerut01.2008
Skills
- Excel
- SQL
- Tableau and Power BI
- Python & AI assistant
- Pricing and Valuation of Bonds and Convertibles
- Client management
- Team management
- Snowflakes
- Data analysis
- Project management
- Dashboard creation
- Problem solving
- Performance management
Accomplishments
- Promoted to Director in 2020
- Promoted to SME Associate Director in 2020
- Establish Bonds Evaluator team in India 2019
- Promoted to SME Principle in 2018
- Setup Markit EVB Operations Team in India
- Received 'Caught Being Excellent' Award in 2015
- Received 'Superhero' Award in 2015
- Nominated for 'Markit Star' & 'Employee of the Year' Award in 2015
- Received 'Markit Achiever' Award in 2014.
- Setup Markit Parsing team in India as a semi-techno team.
- Promoted to Assistant Vice President (Senior Research Associate) in 2012.
Languages
Hindi
First Language
English
Proficient (C2)
C2
Timeline
Director/Senior Manager, Product Specialist
Markit Intelligence, S&P Global
01.2025 - Current
Regional Operations/SME Associate Director
Markit Intelligence, S&P Global
04.2021 - 12.2024
Regional Operations Manager/ SME Principal
IHS Markit
04.2017 - 03.2021
Assistant Vice President, Team Lead
IHS Markit
04.2015 - 03.2017
Assistant Vice President, IC
IHS Markit
04.2012 - 03.2015
Associate
IHS Markit
06.2010 - 03.2012
PGDBM - Finance
Institute of Marketing & Management
Bachelor of Commerce -
Chaudhary Charan Singh University
Coursework
- Complete Python Developer, 2023, Zero to Mastery
- Python for Non-Programmers, 2022
- Tableau Essential Training, 2021
- Advanced SQL for Data Scientists, 2020, Linkedin Learning
- Advanced SQL for Query Tuning and Performance Optimization, 2020, Linkedin Learning
- Ultimate Excel VBA, 2020, Udemy
Projects
Money Market Overriding Process: Automated the process of pricing MMI using Python so that we can price hundreds of securities in a minute, versus pricing 30 to 50 securities using Excel and SoapUI in 10 to 15 minutes
MMI pricing for bespoke client requests: Automated the pricing of MMI for a client, requiring manual effort of 50 minutes every day, whereas the same is now automated and completes in a minute using Python.
Comparison Report: Comparing data from two databased and highlighting the issues.
Submission Manager: The project was about creating an automated report through the Jaspersoft tool and SQL for our sell-side firms, such as GS, JPM, MS, etc.
Business Process Management: The project was about the mapping of all the processes and tasks in Blueworks Live
Bond Reference Data - Bonds New Issue: The project was to capture all the new issues that come to market, and publish the same to internal and external clients, I have defined the logic of tracking new issues and automated the process of tracking and filtering the relevant issues using SQL and VBA.
Pricing – Bond New Issue: Initiated the project to price newly issued bonds as soon as the dealer starts quoting the security
Data Science Educator
Conduct training sessions for freshers and professionals on data science applications, including Excel, SQL, Power BI, and others, both within the organization and at leading institutes in Gurgaon.
Coursework
- Complete Python Developer, 2023, Zero to Mastery
- Python for Non-Programmers, 2022
- Tableau Essential Training, 2021
- Advanced SQL for Data Scientists, 2020, Linkedin Learning
- Advanced SQL for Query Tuning and Performance Optimization, 2020, Linkedin Learning
- Ultimate Excel VBA, 2020, Udemy
Projects
Money Market Overriding Process: Automated the process of pricing MMI using Python so that we can price hundreds of securities in a minute, versus pricing 30 to 50 securities using Excel and SoapUI in 10 to 15 minutes
MMI pricing for bespoke client requests: Automated the pricing of MMI for a client, requiring manual effort of 50 minutes every day, whereas the same is now automated and completes in a minute using Python.
Comparison Report: Comparing data from two databased and highlighting the issues.
Submission Manager: The project was about creating an automated report through the Jaspersoft tool and SQL for our sell-side firms, such as GS, JPM, MS, etc.
Business Process Management: The project was about the mapping of all the processes and tasks in Blueworks Live
Bond Reference Data - Bonds New Issue: The project was to capture all the new issues that come to market, and publish the same to internal and external clients, I have defined the logic of tracking new issues and automated the process of tracking and filtering the relevant issues using SQL and VBA.
Pricing – Bond New Issue: Initiated the project to price newly issued bonds as soon as the dealer starts quoting the security
Data Science Educator
Conduct training sessions for freshers and professionals on data science applications, including Excel, SQL, Power BI, and others, both within the organization and at leading institutes in Gurgaon.
Coursework
- Complete Python Developer, 2023, Zero to Mastery
- Python for Non-Programmers, 2022
- Tableau Essential Training, 2021
- Advanced SQL for Data Scientists, 2020, Linkedin Learning
- Advanced SQL for Query Tuning and Performance Optimization, 2020, Linkedin Learning
- Ultimate Excel VBA, 2020, Udemy
Similar Profiles
Rakesh PakaRakesh Paka
Data Specialist at S&P Global Markit IntelligenceData Specialist at S&P Global Markit Intelligence
Chandrasekhar AragaChandrasekhar Araga
Data Quality Associate at S&P Global Market Intelligence (Formerly IHS Markit)Data Quality Associate at S&P Global Market Intelligence (Formerly IHS Markit)
Akshit KheraAkshit Khera
Senior Corporate Actions Analyst at S&P Global Markit IntelligenceSenior Corporate Actions Analyst at S&P Global Markit Intelligence