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.