Websites
Summary
Overview
Work History
Education
Skills
Languages
cb
Tianyan Zhou

Tianyan Zhou

Toronto,ON

Summary

Dynamic professional with a proven track record at Glaxosmithkline and PharmaSights, specializing in data analysis, database management, and product development. Leveraged Python and cross-functional collaboration to enhance data integrity, drive user engagement through UX design, and boost brand visibility through marketing strategy, contributing to significant sales growth.

Overview

2
2
years of professional experience

Work History

Marketing & Product Developer

PharmaSights
11.2023 - 07.2024

Product Developer:

  • Pulled and cleaned raw metrics data from over 300 pharmaceutical companies, developing a comprehensive product database of diseases, drug generic names, drug modalities, pipeline phases, and drug sales data. Implemented rigorous data cleaning processes to ensure data accuracy and readiness for subsequent SOP steps.
  • Implemented quality control processes throughout the entire product development lifecycle to maintain the integrity and relevance of the database, and collaborated with cross-functional teams to streamline data integration and improve database efficiency.
  • Summarized and presented data from the world's top biopharma companies in visually appealing and interactive charts such as bar charts, donut charts, and treemap charts. These visuals helped in understanding growth drivers, key products, therapeutic areas' market maps, and pipeline drugs of the top 100 leading biopharma companies, effectively providing smart, visual commercial insights.

Website Developer & Designer:

  • Spearheaded the UX design of the company website, focusing on user-centric design principles to enhance user experience, leading to higher user engagement and reduced bounce rates.
  • Updated the website with modern designs in line with industry trends and maximized the potential of product features by integrating intuitive navigation, interactive elements, and clear calls to action.
  • Collaborated with cross-functional teams to ensure seamless integration of web design elements with backend systems.
  • Optimized web content for SEO purposes, resulting in increased organic traffic to the site.

Marketing & CRM Associate:

  • Enhanced the company's LinkedIn presence with creative content and effective targeting, significantly increasing followers by 300+ in 3 months.
  • Boosted brand visibility by developing and executing targeted marketing campaigns.
  • Attended BIO International 2024, showcasing products with compelling presentations during the conference and product demos afterward, contributing to over $16,000 in total product sales.
  • Designed and launched the first edition of the company's email newsletter, focusing on creating engaging and informative content to keep customers informed about company updates, industry trends, and new product offerings.
  • Managed a portfolio of over 300 customer relationships, ensuring high satisfaction and retention levels.
  • Organized and facilitated regular meetings with key customers to provide product demos, discuss their needs, gather feedback, and provide tailored solutions.

Digital Analyst Intern

Glaxosmithkline Llc
04.2022 - 06.2022
  • Spearheaded maintenance and update of nine comprehensive medical disease databases, significantly enhancing back-end database of a cutting-edge medical search website with 27,000+ drugs, 5,000+ target information, and 60,000+ MeSH database information.
  • Conducted in-depth analysis of IT requirements and pain points from local business units (BU), devising tailored digital solutions that optimized website interface and visualization, leading to improved technical services for end-users.
  • Provided daily business partner support, facilitating seamless communication and consulting services in technical and professional domains.
  • Implemented standard central solutions, establishing a streamlined and efficient procedure for local technology operation coordination in disease, target, and drug aspects.
  • Promoted regional and local DDA (Digital, Data, and Analytic) plans and local technology operation coordination in three aspects of diseases, target spots, and drugs.

Education

Honors Bachelor of Science - Specialist: Bioinformatics & Computational Biology

University of Toronto
Toronto, ON
06.2023

Skills

  • Programming Languages: Unix/Linux, Python, R, C, SQL, Javascript
  • Software & Platforms: WIX, Canvas, HubSpot, CodePen, AWS, Google Clouds, Git, GitHub, Docker, AlphaFoldDB, SnpEff & SnpSift,
  • Proficiency in Analysis of High-Throughput Genomics Data (RNA-seq)
  • Efficiency in Data Cleaning, Mapping, Normalization, and Scoring
  • Accomplished in Creating Different Kinds of Graphics for Data Visualization(Heatmaps, Volcano Plots, Violin Plots, Bubble Plots, and Enrichment Mapetc)
  • Savvy in RNA-Seq Alignment, Gene Expression Analysis, Gene Set Enrichment Analysis (GSEA), Post/Signature Analysts, SNP Analysis, Variant Calling
  • Skilled Microsoft Office Set User

Languages

English
Native or Bilingual
Chinese (Mandarin)
Native or Bilingual
Chinese (Cantonese)
Full Professional
Japanese
Limited Working
Tianyan Zhou