Zihan Zhao: in Bellevue, WA

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

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

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

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

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