Zhaoju Liu
Seattle,WA
Overview
5
5
years of professional experience
Work History
ETL Enginner
Shanghai Yeexun Information And Technology Co., LTD.
12.2021 - 05.2022
- Write SQL to build data pipelines to transport and load data from source to front end
- Use Alicloud platform Dataworks to manage daily data transformation
- Make sure data safely upload to client end
- Main translator in Volve China CRM BI RPORT project
- Help local teams collaborate with global teams.
Project Manager
Shanghai Kailuewansheng Management And Consultant Co,. LTD.
01.2019 - 10.2021
- Participated in designing questionnaire and turning into an evaluation system for a supply chain management consulting project, enhanced its functionality by finding and reporting bugs
- Made calls to 256 respondents from 8 countries and improved survey’s completion rate by 20%
- Managed survey and telephone interview result, analyzed current competition patterns, strengths and weaknesses of the company
- Interview customers for different clients
- Help them understand customer insights in order to make better future market prediction.
Marketin
BBDO Proximity
05.2017 - 09.2018
- Used Google Analytics to continuously monitor official website on 4 fields: audience, acquisition, behavior and commerce; collected clicks, conversion rate, bounce rate, and mediums, wrote monitor reports
- Analyzed visitor behavior, provided suggestions aiming to improve user-friendliness on contents, layouts, and transaction processes of the website, improved 8% clicks.
Education
Master of Science - Information Science
Northeastern University
Seattle, WA05.2025
Bachelor of Arts - Mathematics
University Of Rochester
Rochester, NY09.2016
Skills
- Java
- SQL
- R
- Python
- Google Analytics
- English(Business)
- Chinese(Mother language)
- Cantonese(Mother language)
Course Projects
- CUSTOMER BEHAVIOR ANALYSIS AND PREDICTION- THROUGH SPSS, Rochester, NY, Cleaned 226,000+ transaction data, transformed transaction data into customer records through data aggregation, and created customer database;, Selected variables based RFM model and conducted a hybrid of Hierarchical and K-Means Cluster Analysis, Used Multiple Linear Regressions to develop predictive models for future customer behavior and provided managerial recommendations aiming to better target customers and increase revenue;, Wrote data analysis report and conducted data visualization through designing Infographic on Photoshop.
Timeline
ETL Enginner
Shanghai Yeexun Information And Technology Co., LTD.
12.2021 - 05.2022
Project Manager
Shanghai Kailuewansheng Management And Consultant Co,. LTD.
01.2019 - 10.2021
Marketin
BBDO Proximity
05.2017 - 09.2018
Master of Science - Information Science
Northeastern University
Bachelor of Arts - Mathematics
University Of Rochester
Similar Profiles
YAN XIAYAN XIA
Accountant at Shanghai Baojufeng Information Technology Co., Ltd.Accountant at Shanghai Baojufeng Information Technology Co., Ltd.
Jingxuan TONGJingxuan TONG
Lighting & Compositing Artist LRC Department at Mofa (Shanghai) Information Technology Co., LtdLighting & Compositing Artist LRC Department at Mofa (Shanghai) Information Technology Co., Ltd
Jiawei SunJiawei Sun
Intern at Shanghai Credit Information Co., Ltd., Technology DivisionIntern at Shanghai Credit Information Co., Ltd., Technology Division
Victor BautistaVictor Bautista
Transportation Manager at J.B. HuntTransportation Manager at J.B. Hunt
Jamison MaehlerJamison Maehler
Police Lieutenant at Seattle Police DepartmentPolice Lieutenant at Seattle Police Department