Yiyun Xu

Location

Seattle, WA
Education
    University of Washington-Seattle Campus
    March 2023 - June 2024
    degree
    Master's
    major
    Computer Information Systems
    University of Hawaii at Manoa
Work Experience
    Verve AI
    Data Analyst Marketing
    June 2024 - present
    company
    Verve AI
    title
    Data Analyst Marketing
    overview
    - GenAI - powered B2C Startup - USA(Remote - Techniques: Data Pipeline, SQL, Dashboard, PostHog Data Warehouse - June 2024 - Present - Boosted product visibility and user engagement by conducting web analytics and using SQL to identify paid search as the top ROI - Boosted new subscriber base by 1,000+ by using SQL to segment user activity data, identifying pricing concerns among Asian - Improved stakeholder insights by 30% by using SQL to analyze user activity data captured and stored in PostHog's data warehouse and developing interactive dashboards in PostHog to monitor weekly active users, retention rates, and pageview funnels by browser - Improved company revenue by 17% by using SQL to ETL backend user data from platforms such as LinkedIn, Instagram, Reddit - Pinterest, TikTok, leveraging ROI metrics to measure performance across channels and develop data-driven marketing strategies
    University of Washington
    Data Analyst
    Seattle, WA, US
    April 2023 - June 2024
    RSM US Alliance KMH
    Data Analyst
    Honolulu, HI, US
    August 2021 - November 2022
    Verity Certified Public Accountants
    Audit Intern
    Honolulu, HI, US
    July 2020 - August 2021
Skills
A/B TestingAccountingAirflowAmazon RedshiftAmazon S3Amazon Web ServicesAnalytical ThinkingApache SparkApplication Programming Interfaces (APIs)Artificial IntelligenceAuditing SkillsAutomationAWS LambdaBackendBig DataBusiness MarketingCascading Style Sheets (CSS)Certified Public AccountantCloud ComputingCommunication SkillsComputer ProgrammingConsultingConversion MarketingDashboardsData AnalysisData CleansingData IntegrationData LossData MiningData ModelingData PipelinesData ProcessingData VisualizationData WarehousingDecision Making SkillsE-CommerceEmployee RetentionEntity Relationship ModelsExtract Transform Load (ETL)Feature EngineeringForecasting SkillsFunnelsGitHTMLInformation SystemsKnowledge of ClothingKnowledge of FinanceKnowledge of StatisticsLarge Language ModelsLogistic RegressionMachine LearningMacrosMarketingMatplotlibMetricsMicrosoft AzureMicrosoft ExcelMySQLPandasPower BIProphetPython (Programming Language)Relational DatabasesRetail CommerceRetention RateSalesSales PlanningSales PromotionSales TrendsScikit LearnSearch Engine MarketingSnowflakeSQL DatabasesStakeholder ManagementStock ControlStrategies of MarketingStrategies of PricingSubscription ManagementSuccess Driven PersonTableau (Software)TensorflowTransact-SQLVba Programming LanguageWeb AnalyticsWeb ScrapingWorkflows