Log InSign Up

Zihan Zhao: in Bellevue, WA

Zihan Zhao

Bellevue | United States
Skills

No information

Interests

No information

Industries

No information

HomeSummaryActivityProjectsWork experienceEducation historyConnectionsCompanies
Summary

No information

Activity
Projects

No information

Work experience
Image Sovereign Wealth Fund Institute

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).
Image Transitowne Automotive Group

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).
Image Blue Hill Country Club

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
Image Wei Cosmetics Reward

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).
Image Alibaba Group

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
Image University of California

University of California

B.S. in Mathematics and Economics | 2015 - 2018

Image University of Rochester, Simon Business School

University of Rochester, Simon Business School

M.S. in Business | 2018 - 2019

Connections
Companies (0)

No information

1501 Lincoln Blvd.#1014 Venice, CA. 90291