Zihan Zhao: in Bellevue, WA
Zihan Zhao
Bellevue | United States
Skills
No information
Interests
No information
Industries
No information
Summary
No information
Activity
Projects
No information
Work experience
Sovereign Wealth Fund Institute
Associate Researcher, Data Analyst Intern | 11/2019 - 03/2020
Collaborated with stakeholders to determine research objectives in media and technology industry; reported to Director
on automating transaction information collection process, shortening process time from 40 minutes to 1 minute (Python).
• Launched email campaigns for Sovereign Wealth Quarterly (SWQ, Quarter 4 - Year 2019); increased conversion rate of subscription by 19% by testing past performance and determining areas to improve (SQL, Excel).
• Built and maintained ETL pipelines and data warehousing of entities; updated and expanded over 200 entity profiles
according to subscribers' requests; refined entity's asset allocation to time-series trend analysis (Excel).
Transitowne Automotive Group
Marketing Analyst | 02/2019 - 05/2019
Combined sales and service data with car registration and census data from US government to summarize past trends,
perform descriptive analysis of customer segmentation and expand data-driven marketing capabilities (R, Python).
• Web-scraped customers' reviews and location coordinates from Google Map and automated web browser interactions to prepare text-mining and sentiment analysis; identified patterns of customer behavior to determine best target customers
and strategies to maintain customer loyalty and discover potential opportunities (Python, SQL).
• Improved client's customer retention strategy by identifying missed-out service customers; proposed a data-driven
marketing campaign and decisions (SQL, Tableau).
Blue Hill Country Club
Data Analyst | 01/2019 - 03/2019
Designed and created a data warehouse from aggregating 10 tables with over 50,000 entries to support ad-hoc queries;
identified the overall performance by departments and membership information, investigated cross-selling opportunities
and developed three recommendations for marketing strategies using descriptive analysis (SQL).
• Visualized results; transformed technical insights into an understandable slide deck and gave a final presentation to non-technical audience (R, Tableau).
ASSETS & INTERESTS
Wei Cosmetics Reward
Data Analyst Volunteer | 12/2015 - 01/2019
Captured consumer buying behavior pattern by designing the 50-category products survey and processing 8,000-12,000
data samples annually; built target audience profiles using predictive models (SQL).
• Generated product recommendations posts, which were forwarded 25K times and received 5M views in total;
coordinated with PR agencies for optimal advertising segmentation, increasing sales by 30% (Tableau, Photoshop).
Alibaba Group
Business Intelligence Analyst Intern | 12/2017 - 01/2018
Conducted in-depth research and gathered data about an Internet payment system; examined new network payment cases
to verify whether the payment system had security and operational bugs; explored payment processes by reviewing over
30 case studies and case comparisons to evaluate system security (R).
• Utilized Tableau to visualize and review critical information related to the payment channel and customer purchasing
histories; constructed user location heat map to identify new market opportunities (Tableau).
ANALYTICS PROJECTS
Education history
University of California
B.S. in Mathematics and Economics | 2015 - 2018
University of Rochester, Simon Business School
M.S. in Business | 2018 - 2019
Connections
Companies (0)
No information