Project 1: Disadvantage Population PredictionCollected and consolidated American Community Survey Consensus Data and Public Use Microdata Areas Data; standardized the variable names and examined the correlation between variables (such as economic status and English efficiency)Performed variable screening and built a robust multiple linear regression model to estimate the percent of the population that is disadvantaged in SAS; conducted model diagnostics and validationDrafted a 20-page technical memo on data, methodology, and future application of the model Project 2: Crash Data CleaningDeveloped streamlined solutions to efficiently remove duplicate records, flag the crash that happened during holidays, and merge third-party vendor data in Python

Analyzed financial statements & financing activities of potential sellers; conducted due diligence on target sellers, and advised commercial building sellers with revenue-boosting strategies Focused on pitching affordable housing construction & rehabilitation projects that qualify LIHTC along with cost-saving plans to buyers by building revenue prediction models and future valuation models of the target project

• Researched Shenzhen Sunway Communication Co., Ltd (stock code: 300136.SZ) & EVE Energy Co., Ltd (Stock Code: 300014.SZ) and drafted two 20-page in-depth research reports with valuation estimation• Wrote a 30-page industrial research report for PCB (Printed Circuit Board) industry• Analyzed and compared performance of about 3,000 listed companies in technology sector and communicated recommendations to trading and management teams• Gathered, synthesized, and interpreted financial & economic data from various sources and developed statistical plots to visualize trends and industrial chains for 10+ Industry/Company Research Reports