Summary
Overview
Skills
Work history
Education
Hobbies and Interest
Timeline
Generic

MANDEEP SEHRA

London

Summary

Dedicated and results-driven professional with hands-on experience in investment services and actuarial work. Holds a master's in financial mathematics with experience in asset management and actuarial roles. Seeking a role where I can continue to grow and apply my analytical, quantitative skills in a dynamic and challenging environment. Keen to study for the Actuarial exams.

Overview

4
4
years of professional experience
8060
8060
years of post-secondary education

Skills

  • Mathematical algorithms in R
  • Data analysis with Python
  • SQL query creation
  • Excel formulas and functions
  • VBA macro development
  • Technical management information
  • MS Access query creation
  • Morningstar proficiency
  • LaTeX documentation skills
  • Actuarial science knowledge
  • Financial reporting expertise
  • Advanced Excel skills
  • Database management

Work history

Investment Risk Analyst

Dynamic Planner
Reading
01.2023 - 07.2025
  • Managed asset class mappings for equity and fixed income solutions.
  • Developed Excel tool for equity mapping, streamlining process efficiency.
  • Produced initial and quarterly risk profiling reports, analysing fluctuations in risk profiles.
  • Created SQL queries and utilised Python for thorough data analysis.
  • Coordinated client meetings to provide updates on risk profiles.
  • Assessed client portfolios to identify potential risks and vulnerabilities.
  • Conducted comprehensive market research to forecast risks in investment opportunities.

Actuarial Analyst - Modelling

HSBC
Canary Wharf, City of London
10.2022 - 01.2023
  • Provide support to the IRFS 17 reporting standards by organizing large data in Excel for deterministic runs
  • Gained an insight of running stochastic and deterministic models in Prophet and carrying out regression analysis
  • Debugging VBA to fix spreadsheet errors
  • Analysing profitability obtained from yield curve stress testing

Pricing Technician - Actuarial

Canada Life
06.2021 - 10.2022
  • Working in the Wealth, Product & Pricing team
  • Updated assumptions and parameters in Excel
  • Dealing with ad-hoc requests from customers regarding their pensions
  • Running pricing models and analysing the profitability of our products
  • Developed processes in Excel for improving data analysis and automating processes in VBA
  • Assisted with new pricing deals and writing reports to senior management
  • Providing support with updating growth rates core ranged funds Mortality rates for the April reprice
  • Analysing MI for our DB and DC customers
  • Gather investment information using Morningstar and experience in asset allocation for policyholders
  • Updating the monthly RPI into our live software
  • Producing Technical MI in Excel for our onshore and offshore products, which was presented in board meetings
  • Completing the MIFID process for customers
  • Support with E2E testing that contributed to the improvements within the actuarial department

Education

MSc - Financial Mathematics

Brunel university
London
Sep 2019 - 09.2020

BSc. Hons - Mathematics

Brunel university
Uxbridge, Hillingdon
Sep 2012 - 09.2015

A-levels -

West London College
Ealing
Sep 2009 - 09.2012

GCSE's -

Villiers High School
West London
Sep 2007 - 09.2009

Hobbies and Interest

  • In my spare time, I tutor Mathematics to GCSE and A-level students.
  • I enjoy traveling, reading and physical activities.

Timeline

Investment Risk Analyst

Dynamic Planner
01.2023 - 07.2025

Actuarial Analyst - Modelling

HSBC
10.2022 - 01.2023

Pricing Technician - Actuarial

Canada Life
06.2021 - 10.2022

MSc - Financial Mathematics

Brunel university
Sep 2019 - 09.2020

BSc. Hons - Mathematics

Brunel university
Sep 2012 - 09.2015

A-levels -

West London College
Sep 2009 - 09.2012

GCSE's -

Villiers High School
Sep 2007 - 09.2009
MANDEEP SEHRA