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

Associate Researcher, Data Analyst Intern

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

Marketing Analyst

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

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

Data Analyst Volunteer

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

Business Intelligence Analyst Intern

Find out detailed information about Zihan Zhao,  in Bellevue, WA

Zihan Zhao: in Bellevue, WA

Zihan Zhao

University of California

University of Rochester, Simon Business School