Rajvi Gandhi

Experience

• 

  MSCI Inc.

  Jun 2019 - Jul 2022

  Software Developer

  Owned & managed a REST application (of BEON, a product of MSCI) in java, responsible for storing clients’ portfolio information in SQL database. Contributed to integration of new functionalities, performance enhancement, and bug fixes.• Enriched MSCI’s internal java-based Entitlement System, a system responsible for storing clients’ entitlements in neo4j graph database. Created database scripts in cypher query language to capture data.• Devised analytical metrics such as Annualization in Portfolio Metrics at a greater level of performance as compared to legacy implementations by leveraging vectorized implementations (Scala), addressing performance issues of return attribution logic.• Led efforts to standardize and automate the process for incremental updates of MAC (multi-asset class) models by building Azure data pipelines & integrating approvals in between different stages - benefiting users with 32% increase in efficiency.• Built data pipelines to migrate on-premises Model data from Oracle database to Azure Data Lake with Azure Data Factory,enhancing delivery efficiencies for over 18 projects by 27% on average.• Built Azure CI/CD pipelines, resulting in reduction of build and compilation time for the existing factor models by 40%.• Wrote stored procedures for storage & retrieval of data from DB, and crafted Liquibase scripts for DB version maintenance.• Rewired existing Oracle based services with Cosmos DB to examine performance enhancement for portfolio metrics, monitored its performance, & presented results to higher management to make business decisions.• Formulated computational and comparison logic for Model estimation metrics in Python and MATLAB.• Served as the Scrum Master, facilitating and orchestrating the Agile planning processes to ensure effective team collaboration. Show less

• 

  NXP Semiconductors

  May 2023 - May 2024

  Data Engineer Intern

  Responsible for implementing an end-to-end data pipeline to incrementally update data sources (only update the changed data since last run) required for generation of license related critical reports, encompassing DBT, Dagster & various AWS services,achieving a significant reduction in report processing and loading time from 660 seconds to 21 seconds.• Leading the development of a reverse data pipelining system to extract data from AWS Data Lake and make it available on-premises, mainly leveraging use of AWS Lambda, enhancing overall performance by greater than 3x. Show less

• 

  NXP Semiconductors

  Jul 2024 - now

  Data Engineer