Tsu-Jung (Claire) Liu
Analytics Student Consultant at Carlson Analytics Lab- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Experience
-
Carlson Analytics Lab
-
United States
-
Information Services
-
1 - 100 Employee
-
Analytics Student Consultant
-
Jul 2023 - Present
Minneapolis, Minnesota, United States Impact Analysis for College Readiness Program • Built a logistic regression model using 10 years of K-12 data to determine key drivers impacting post-secondary academic achievement • Delivered findings with Tableau dashboard to illustrate effectiveness of college readiness programs
-
-
-
Shopee
-
Retail
-
1 - 100 Employee
-
Data Analyst
-
Aug 2021 - Apr 2023
Taipei City, Taiwan • Designed data pipelines and implemented ETL processes in SQL to optimize sales performance reports on 37 multidimensional metrics and improve data integrity • Analyzed transactions across 2M+ orders by aggregating data and performing customer segmentation to reduce cash levels for regulatory compliance • Created automation systems for warehouse management team, improving manual efficiency in storage tasks by 8% and facilitating returned order logistics tracking process
-
-
-
inline Apps
-
Taiwan
-
IT Services and IT Consulting
-
1 - 100 Employee
-
Revenue Operations Intern
-
Feb 2021 - Jul 2021
Taipei City, Taiwan • Developed Excel formulas to automate sales commission calculation process and reduce manual input by 55% • Analyzed monthly revenue in 5 countries and presented results to senior management • Recovered $6K+ in 3 days by identifying key delinquent merchants from billing datasets
-
-
-
NTU Data Analytics Club
-
Taiwan
-
Information Services
-
1 - 100 Employee
-
Project Member
-
Sep 2020 - Jun 2021
Taipei, Taipei City, Taiwan
-
-
-
PwC
-
Professional Services
-
700 & Above Employee
-
Audit Intern
-
Jan 2021 - Feb 2021
Taipei City, Taiwan • Reconciled cash transaction details by collecting, cleaning, and summarizing 6K+ datasets in Excel • Reviewed inventory account by investigating client sales trends and drafted examination results
-
-
Education
-
University of Minnesota - Carlson School of Management
Master of Science - MS, Business Analytics -
National Chengchi University
Bachelor of Science - BS, Accounting