ZZ

Zihan Zhao

Associate Researcher, Data Analyst Intern · Sovereign Wealth Fund Institute

Bellevue, WA

Work Experience

Associate Researcher, Data Analyst Intern

Sovereign Wealth Fund Institute

2019 – 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).

Marketing Analyst

Transitowne Automotive Group

2019 – 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).

Data Analyst

Blue Hill Country Club

2019 – 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

Data Analyst Volunteer

Wei Cosmetics Reward

2015 – 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).

Business Intelligence Analyst Intern

Alibaba Group

2017 – 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

B.S. in Mathematics and Economics

University of California

2015 – 2018

B.S. in Mathematics and Economics

M.S. in Business

University of Rochester, Simon Business School

2018 – 2019

M.S. in Business