Lajpatrai Vyas

Developed 10-plus customized advanced excel sheets in collaboration with developers at BlackRock. The spreadsheets allow entry of data into a proprietary eFront/Aladdin database and generate 40-plus valuation reports for use by top management in reviewing performance of AUM, valued at $180 billion. Educated over 15 analysts on how to enter data, push data into the system, and retrieve data for multiple analytical and reporting purposes. Also designed processes to maintain data quality and data accuracy using a Bloomberg terminal.

Assisted senior data scientists on multiple projects in aggregating data, pre-processing, conducting exploratory data analysis, fitting and validating machine learning models. Sourced data from APIs, engineered features using Pandas and NumPy, and created visualizations. Fitted and cross-validated models including Logistics Regression, Decision Trees, Random Forests, and XGBoost. Developed an ETL pipeline for skills data and collaborated on a $3-million ML model to predict employee attrition.

Drove portfolio management processes and coordinated analysis of investment banking transactions. Strengthened growth of $17M portfolio by reviewing data and assessing transactions. Developed an excel file with 400+ securities using Bloomberg terminal to improve valuation accuracy. Built a comparable tableau dashboard to determine enterprise value of 20 private entities.

Analyzed stocks, conducted valuation analysis, and formulated investment models. Doubled portfolio value for clients between 2014 and 2017. Achieved 25% profitability per annum for four years by trading equity, index, commodity and currency derivatives. Delivered over 10% excess returns per annum between 2015 and 2017 using technical analysis and macro event risk analysis.

Coursework: Advanced Statistics & Econometrics, Regression Analysis, Tableau, Data Mining

Professional Certification with below 5% Pass Rate