Overview
Work History
Education
Skills
Certification
Competitions
Timeline
BusinessAnalyst
Prakhar Bhargava

Prakhar Bhargava

Mumbai

Overview

3
3
years of professional experience
1
1
Certification

Work History

Associate Quantitative Analyst

Morningstar
07.2024 - Current
  • Ongoing maintenance of 100+ indexes with different reconstitution cycles, covering a wide variety of families / themes such as Style, ESG (Sustainability), Crypto, Moat, Dividend, and Volatility indexes.
  • Analysis of index & market data used in the construction of indexes to ensure quality and post-recon checks to rectify any potential problems before the start of proforma period.
  • Automation of over 30 Client Service Indexes from manual steps on excel to python script to enhance efficiency.

Intern

Morningstar
01.2024 - 06.2024
  • Fixed Income Market Classification: Conducted comprehensive research and analysis to classify countries as Emerging Markets (EM) or Developed Markets (DM) for inclusion in fixed income indexes.
  • Index Replication and Analysis: Used Python and SQL to replicate the Morningstar Transatlantic Gender Diversity Select 100 Index, which pursues objectives aligning with ESG standards and gender diversity policies.
  • Quality Assurance Checks and Automation Projects: Implemented QA checks to validate data accuracy and integrity in index calculations. Developed automation tools to streamline repetitive tasks, increasing efficiency and reducing the potential for human error.

Summer Intern

Hyphen SCS
06.2022 - 07.2022
  • Analysed financial data and created business visualisations for over 600 warehouses using MS Power BI and MS Excel.
  • Conducted comprehensive competition analysis by examining competitors’ sales processes, margins, and promotion strategies.

Education

B.E. (Hons.) - Mechanical Engineering

BITS Pilani
Hyderabad, India
07-2024

Class XII -

GVN - The Global School
Bhopal, MP
01-2020

Class X -

The Sanskar Valley School
Bhopal, MP
01-2018

Skills

  • Python
  • Tableau
  • SQL
  • Microsoft Excel
  • Microsoft Power BI
  • Portfolio Management
  • R Programming

Certification

CFA Program Level 1

Credential ID - 139033333

Competitions

CanSat Competition 2022

  • Represented Team Janus as Management Lead in the CanSat competition organized by the American Astronautical Society (AAS) at Virginia Tech, USA, achieving 23rd position worldwide.
  • Oversaw the entire project lifecycle from design to deployment, ensuring timely completion of all phases.
  • Coordinated the efforts of multidisciplinary team members to meet competition requirements and deadlines.
  • Successfully managed all aspects of international travel for the team, including visa acquisition, flight bookings, accommodation arrangements, and local transportation within the USA.
  • Secured sponsorships and additional funding to support the teams participation and travel costs.

Timeline

Associate Quantitative Analyst

Morningstar
07.2024 - Current

Intern

Morningstar
01.2024 - 06.2024

Summer Intern

Hyphen SCS
06.2022 - 07.2022

B.E. (Hons.) - Mechanical Engineering

BITS Pilani

Class XII -

GVN - The Global School

Class X -

The Sanskar Valley School
Prakhar Bhargava