-
Dong Yang posted an update 1 year, 11 months ago
Experience
LT Analytics LLC logo
Data Science & Analytics Summer InternData Science & Analytics Summer Intern
LT Analytics LLC · InternshipLT Analytics LLC · Internship
May 2022 – Aug 2022 · 4 mosMay 2022 – Aug 2022 · 4 mos
Irvine, California, United StatesIrvine, California, United States
Reconciled and complied insurance claim data for mid-size high deductible commercial clients, performed EDA (exploratory data analysis), and drafted formal visualization reports for various line of business such as workers compensation, automobile liability, and property.
Developed automation of claim data preparation, increasing efficiency, and allowing more time for value-added analysis.
Sampled, collected, and cleaned recent sold real estate data through Zillow by zip code including the sold price, size of property, build-year, type of property, average school rating, etc. to create and optimize a linear regression property pricing model in R.
Used the pricing model to generate Listing Agent Pricing Report including the following items: central estimated price, 40-80% price confidence interval, and recent sold nearby property summary tables/visualizations.
Helped on business proposal preparations, identified, and formulated components necessary to maximize success.Reconciled and complied insurance claim data for mid-size high deductible commercial clients, performed EDA (exploratory data analysis), and drafted formal visualization reports for various line of business such as workers compensation, automobile liability, and property. Developed automation of claim data preparation, increasing efficiency, and allowing more time for value-added analysis. Sampled, collected, and cleaned recent sold real estate data through Zillow by zip code including the sold price, size of property, build-year, type of property, average school rating, etc. to create and optimize a linear regression property pricing model in R. Used the pricing model to generate Listing Agent Pricing Report including the following items: central estimated price, 40-80% price confidence interval, and recent sold nearby property summary tables/visualizations. Helped on business proposal preparations, identified, and formulated components necessary to maximize success.
Skills: Data Analysis · Leadership · Microsoft Excel · Communication · Microsoft Office · Microsoft Word · R&R · Microsoft PowerPoint · Microsoft Excel