Sambhav Rekhawat
MSc Finance and Management Graduate | Risk Management | Financial Modeler
Summary
MSc Finance and Management graduate with strong technical and exceptional analytical skills. I’ve gained experience in roles as a data analyst at Bloomberg L.P. and an investment banking associate at Credent Global Finance, as well as through internships. Skilled in financial modelling, data analysis, risk analysis, and portfolio optimisation, with proficiency in Python, SQL, Excel, and Power BI. Knowledge of risk modelling, such as BASEL, IFRS 9 and stress-testing models. Adept at identifying emerging risks, problem-solving and optimising portfolios, with a keen understanding of financial products and their risk-reward trade-offs.
Work Experience
A summary of my professional experiences.
Data Analyst
Bloomberg L.P, LondonApr 2024 – Mar 2025
- Managed Equity products and analyst recommendations (ANR), reducing data processing errors through expert handling of corporate actions (e.g., stock splits, divestitures, dividends).
- Collaborated on TALK, an A.I. speech-to-text tool, improving efficiency for News and Earnings teams (both in the US and UK) in real-time transcription of live and recorded audio/Earning calls. Also worked in the events calendar function (EVTS) to help streamline the corporate events and corresponding details, addressing client queries and transcript corrections.
- Maintained high data integrity across EMEA Markets by sourcing and validating raw data from multiple channels (PDFs, HTML, XLSX, CSV), cross-referencing shares outstanding anomalies, and cleaning historical and live data.
- Won recognition for swift action, error management, and significant contribution to improved decision-making and strategic planning processes.
Investment Banking Associate Intern (Sales)
Credent Global Finance, LondonDec 2023 – Mar 2024
- Established and nurtured strategic client relationships through regular communication, delivering engaging presentations highlighting investment opportunities. This approach, coupled with comprehensive financial analyses and compelling investment proposals (using PowerPoint, Canva and PowerBi), played a pivotal role in successful capital-raising efforts and enhanced client satisfaction.
- Leveraged detailed knowledge of investment banking principles and stayed abreast of industry trends to provide insightful, up-to-date financial advice. This expertise improved client decision-making processes and the firm's overall growth.
Projects
Showcasing my financial modeling and quantitative analysis projects. Click on a project to learn more and download the Excel file.
Machine Learning Model for Corporate Acquisitions
Developed a machine learning model for predicting corporate acquisitions in the EU, analysing 8,000+ companies over 20+ years, achieving 0.68 AUC with a random forest model.
Machine Learning
Data Cleaning
Feature Engineering
Statistical Modelling
Python
Personal Finance Dashboard (Excel)
Curated a Personal Finance Dashboard leveraging Budget Planning, Retirement Planning, and Investment Tracking to offer a personalised experience of Financial Planning and its management using EXCEL.
Personal Finance
Budgeting
Retirement Planning
Investment Tracking
Excel
ECL Framework based on IFRS 9 Guidelines
Created an ECL framework based on the IFRS 9 guidelines using EXCEL, including scorecard modelling, prepayment modelling, forward-looking scenarios, converting TTC pd to PIT pd (integrating existing BASEL framework and ICAAP), model validation and implementation.
IFRS 9
ECL
Credit Risk
Basel
Excel
Financial Reporting
Financial Risk Assessment using Gaussian Copula & Monte Carlo Simulation
Utilised Gaussian Copula and Monte Carlo simulation to assess financial risk and identify optimal investment strategies for revenue potential.
Financial Risk
Monte Carlo
Gaussian Copula
Simulation
Investment Strategy
VAR, Stress Testing, and Interest Rate Risk Models
Created models to calculate VAR, stress testing, interest rate risks, duration models and yield curve analysis, efficient in pattern recognition.
VAR
Stress Testing
Interest Rate Risk
Duration Models
Yield Curve Analysis
Risk Management
Impact of Credit Rating Upgrades on US Stocks
Analysed the impact of credit rating upgrades on US stocks using BHAR and CAR over 11 years of data using Capital IQ and EXCEL.
Event Study
Credit Ratings
Stock Market
Capital IQ
Excel
Financial Analysis
Extracurricular Activities
My involvement outside of academics and professional roles.
Multi-Asset Portfolio Manager
Cranfield Finance Society, Cranfield, UKJan 2023 – Oct 2023
- Managed £100 million investment portfolio, achieving a 9% return over 12 weeks through strategic planning and comprehensive reporting.
- Leveraged Python to construct high-performance portfolios, optimising risk-return parameters and enhancing diversification strategies.
- Exhibited in-depth knowledge of market trends and dynamics, contributing to the development of investment strategies and decision-making.
Investment Banking Intern
J.P. Morgan, RemoteJan 2022 – Feb 2022
- Conducted in-depth financial analysis of 5 potential M&A targets, evaluating accretion potential and strategic alignment.
- Constructed dynamic 3-stage DCF models in Excel, determining fair valuation ranges and presenting findings with key assumptions.
- Presented valuation results, justifying key assumptions to provide a fact-based perspective on deal terms and pricing.
Skills
My technical and soft skills.
Soft Skills
Effective written and verbal communication
Teamwork
Problem-solving
Time management
Adaptability
Multi-Tasking
Programming Skills
Python (NumPy, Pandas)
VBA
SQL
Technical Skills
Financial Planning
Financial Modelling
Valuation
Financial Analysis
Risk Management
Credit Risk Modelling
Portfolio Optimization
Data Visualization
Excel
Power BI
PowerPoint
Google Docs
Google Sheets
Education
My academic background.
MSc. Finance and Management
Cranfield University, Cranfield, UKSep 2023
- Graduated with Honours.
- Excelled in Corporate Finance, Statistical Analysis, ESG, Fixed Income, and Data Analysis.
Bachelor of Commerce
Bhawanipur Education Society College, Bhawanipur, IndiaDec 2020
- Studied and excelled in Accounting, Financial Management, and Corporate Finance modules.
Certificates & Qualifications
My professional certifications and qualifications.
Credit Risk Modelling Certificate
VaR, Stress Testing, ECL (IFRS 9), SR11-07, Basel and IRB modelling (Peaks2Tails.com)Present
Financial Risk Manager (FRM) Part 2 cleared
Market, Credit, Liquidity and Investment Risk measuring and monitoringMay 2025
Mergers and Acquisitions (M&A) Modelling
Accreditation/Dilution, Sensitivity Analysis, Contribution AnalysisSept 2024
Certified Financial Planner (all 5 papers cleared)
Investment Planning, Retirement and Insurance PlanningMar 2022
Chartered Financial Analyst (Level 1)
Economics, Quantitative Methods, Corporate Issuers, Portfolio Management, DerivativesMay 2019