Professional Experiences

Data Analyst & Visualization Specialist--Local Government, Community Engagement, Economics, and Transportations, Comengage.us, Dec 2021-Jan 2023 (Part-Time Volunteer Feb 2022-Jan 2023) 

• Survey data analysis and visualization using R programming language and dashboarding software such as Displayr 

• Quantitative data analysis includes statistical analysis (such as data normality analysis), regression analysis, discrete choice modeling (such as MaxDiff or Conjoint), Principal Component Analysis, etc. 

• Automate reports/dashboards such as generate dynamic text and update for longitudinal studies 

• Delivered high quality for multiple projects to meet critical business deadlines 

• Software used: R, Displayr, Tableau 

Post-Doctoral Researcher--Health Insurance, Capital Markets, Macroprudential, NAIC, Nov 2019-Nov 2021, and Research Consultant--Nov 2021-Feb 2022 

• Conduct healthcare and health insurance-related research and analyses, including healthcare cost drivers, marketplace enrollment, network adequacy, etc. 

• Fulfilling researcher and analyst duties for NAIC Capital Market Bureau’s insurance infrastructure investment project, including fixed income credit performance analyses (source: Moody’s and S&P), private equity performance analyses (platform: Preqin), infrastructure climate exposure, keeping abreast of industry-related news flow, etc. 

• Conduct quantitative analyses on the macroprudential of the insurance industry, including collecting and analyzing data on macroeconomic conditions, etc. 

• Other studies include the application of the health care cost actuary model, health insurance knowledge survey analysis, Model Law adoption analysis, Business Interruption-related analysis, etc. 

• Over the two more years, besides the above duties, I have published four organization website expert reports, one peer-reviewed publication, one peer-reviewed paper currently under revision, and one industry-wide export webinar. 

• Software used: Tableau, Stata, Python, MS Excel, and MS PowerPoint 

Research Staff--Hedge Fund, Nonprofit, Harvard Business School, May 2019-Sep 2019 

• Fulfilled all research staff duties for a Professor at Harvard Business School for two projects over the summer of 2019 

• One project evaluates the impact of the JOBS Act on the hedge fund industry; the other project investigates the non-profit organizations' revenue effect from the churn of the person in charge 

• Software used: Stata, LaTex, MS Excel, and MS PowerPoint 

Private Equity Analyst--Due diligence, Ocean Trail Partners, Apr 2019-May 2019 

• Conducted extensive research and due diligence on potential acquisitions within the lower middle market 

• Produced reports/PowerPoint slide decks on compelling potential investments supported by quantitative and qualitative data to help identify strong investment opportunities 

• Set up and maintain an Excel database for determining attractive investment opportunities 

• Software used: MS Excel, and MS PowerPoint 

Program Assistant--SAS, D’Amore-McKim School of Business, Northeastern University, Jan 2012-May 2012 

• Fulfilled all program assistant duties in a team of five members led by a faculty of the School of Business to support a U.S. nationwide hospital study 

• Cleaned and manipulated raw data (i.e. Fuzz lookups in Excel, process missing values, create pivot tables, etc.) of a total of 20 GB 

• Furnished data insights, proposed and applied analytical approaches (i.e. ANOVA analysis, F-test, etc.) to address challenging issues arising in the project 

• Software used: SAS, MS Excel 

Research Assistant--Mobile Marketing, D’Amore-McKim School of Business, Northeastern University, Sep 2011-Dec 2011

• Conducted detailed investigative literature research and produced reports of 150+ papers/articles/cases on mobile marketing 

• Performed extra tasks due to good job performance, such as creating PowerPoint Slide decks for the professor's presentation 

• Software used: MS Word, and MS PowerPoint 

Project Assistant--Cost-Benefit Analysis, Yellow River Conservancy Commission, Ministry of Water Resources, China, Jan 2008-July 2008 

• Reviewed and documented current projects, identified areas for improvement, and provided recommendations to the appropriate groups 

• Gathered data and developed statistical analysis, such as pioneered the use of the cost-benefit analysis on the potential investment project 

• Coordinated and updated meetings with multi-functional teams 

• Software used: MS Word, and MS Excel