Shubh Mehta Email and Phone Number

-Led data integration of IPO and blockholder data(695,000 rows,88 columns) using Python and Stata, improving merge efficiency by 20%.- Standardized company names using text manipulation techniques, achieving a 95% match rate in blockholder-IPO merge.- Created and automated Stata scripts to process blockholder ownership (5%+ holdings), enhancing analysis of ownership patterns andfinancial indicators.- Performed data visualization using matplotlib and Stata, identifying trends in… Show more -Led data integration of IPO and blockholder data(695,000 rows,88 columns) using Python and Stata, improving merge efficiency by 20%.- Standardized company names using text manipulation techniques, achieving a 95% match rate in blockholder-IPO merge.- Created and automated Stata scripts to process blockholder ownership (5%+ holdings), enhancing analysis of ownership patterns andfinancial indicators.- Performed data visualization using matplotlib and Stata, identifying trends in blockholder ownership, including a decline in highownership percentages post-2000.- Engineered predictive models (xtlogit regressions, moderation analysis) for IPO layoff decisions, determining variables influencingdownsizing trends. Show less

-Analyzed CCTV sales data, applying advanced statistical techniques in SAS to extract key insights, identifying buyer type as a critical factor influencing sales.-Optimized machine learning models (Random Forests, GBM), improving prediction accuracy by 15%.-Enhanced sales revenue predictions by 20% through refined model validation techniques.-Visualized data insights using Tableau, regularly presenting findings to senior management and the analytics team.