Lin (Tommy) Wang Email & Phone Number

美国

Developed advanced Excel Macros to fully automate the generation of monthly exchange rate tables for 8+ currencies, significantly enhancing accuracy and efficiency in financial calculations.Monitored NYMEX and EIA energy prices with weekly updates for internal reporting.Applied statistical models (regression analysis, time series forecasting, ARIMA) to.

Guangzhou, Guangdong, China

• Defined 10+ important metrics in order to evaluate the performance of ads, including CTR, conversion rate and retention rate etc.
• Analyzed the metrics in 4+ different dimensions, including ads category, promotion time and placement etc.
• Performed statistical methods for the sale price data in order to reduce potential errors and outliers
• Monitored the major KPIs and created daily summary statistics reports of sales data with complex SQL queries
• Developed dashboard report automation system to create 3 interactive Tableau marketing reports weekly with ads performance database, saved 30% of the reporting time
• Collaborated with 3+ cross-functional teams to modify the SEM, increased the conversion rate by 20%

Guangzhou, Guangdong, China

• Collected and extracted 20k students grades of all the primary school students in the college with Python
• Analyzed the students’ grades through the subjects, gender, enrolled courses etc.
• Identified the root cause of the low grades by tracking down the data into the deeper-level granularity
• Provided recommendations for the course design, successfully improved the average students' grades by 4%
• Co-taught with foreign teachers to help students learn content, completing 95% of course plans on time.

Master Of Library & Information Science - Mlis, Data Science; Interaction Design And Informatics, 3.78

Bachelor'S Degree, Information Technology & Informatics (Iti), Major Gpa3.5

Activities and Societies: Japanese conversation club