Data Analyst

• Feb 2021 - Present

Data Analyst

• Jan 2021 - Feb 2021

Data Analyst

• Apr 2020 - Dec 2020

• Collected budget of libraries and police offices in United Stat and cleaned data set using Sql • Calculated correlation, adjusted R square and beta to choose most suitable independent variable and chose 25 to 75 percentile libraries based on independent variable • Used Library Value Calculator to calculate the final benefit Vendors may get • Combined Library information data set and Campaign data set using Vlookup in Excel • Found out correlated variables of vendors’ investment successful rate using logistic regression in SAS Show less

Teaching Assistant

• Aug 2019 - Jan 2020

Intern for Pricing Analytics and Product Analytics teams

• Jul 2019 - Sep 2019

• Conducted market research to compare territory factors affecting insurance prices among main competitors based on pricing reports • Extracted, sorted and validated effective research data from Ratefilling website according to the zip code across five states in Excel • Imported research data into Farmers’ database to establish models of territory tools and multiple zip factors tools using Vlookup, Match, Char, etc. function; identified if the original territory factors are reasonable • Supported the team members to optimize the process with their territory tools and ensured accuracy of 100% • Used Visual Basic and VBA in Excel to build template, detect inaccuracy, and correct errors between rate engine and agent system • Evaluated potential impact on revenue returns caused by price changes and analyzed the difference between the capped and uncapped impact • Created dashboards in Tableau showing states’ maps of current legacy and residual factors to compare factors affecting prices • Presented to Product Manager and delivered a recommendation for the upcoming rate revision using Power Point Show less

Business management

• Sep 2017 - May 2018

• Compiled daily, weekly and monthly financial reports including income statement and balance sheet based on company’s account • Assisted the finance team to reconcile, collect and post payments using Excel • Compared data from Short North EEPLY system and customers account payable to resolve valid or authorized deductions • Calculated People data by using DPS system to calculate total number of customers and sales percentage within the system • Predicted the seasonal sales utilizing historical trend, compared and analyzed the actual data with the forecasted growth rate • Coordinated with the suppliers to place orders, organized invoices and contacted with other fair-trade organizations Show less