Yijia Liu

Location

Berkeley, CA
Shanghai, People's Republic of China
Education
    University of California-Berkeley
    August 2024 - August 2025
    degree
    Master's
    major
    Data Analytics
    Fudan University
Work Experience
    TikTok
    Data Analyst Intern
    Shanghai, CN
    February 2024 - June 2024
    company
    TikTok
    title
    Data Analyst Intern
    overview
    - Led a team of 5 members in conducting advanced data analytics - Developed and optimized SQL queries to extract and analyze performance data from 3,000+ brand shops - TikTok Shop, building operational dashboards - Built optimization models and implemented linear programming with Python(Gurobi) to optimize livestream and promotional banner slot allocations for JBP project with 70+ clients, resulting in a 40%+ increase in GMV for merchants - Utilized SQL to identify and address 5+ operational anomalies by querying and joining multiple datasets - Presented business analysis findings to senior management during Southeast Asia regional meetings
    China International Capital
    Quantitative Research Analyst Intern CICC Equity Research Institute
    Shanghai, CN
    June 2022 - September 2022
    Customer Retention Optimization
    April 2022 - June 2022
Skills
A/B TestingAccountingAlgorithmsAnalytical ThinkingAutomationBrand ManagementBusiness AnalysisBusiness EfficiencyBusiness ProcessesCloud ComputingCommunication SkillsComputer ProgrammingConsumer Packaged GoodsCredit AnalysisCustomer RetentionDashboardsData AnalysisDatabasesData CleansingData MiningData ProcessingData ScienceData VisualizationDecision TreesDeep LearningE-CommerceEmployee RetentionFeature EngineeringForecasting SkillsFutures ExchangeIndustrial EngineeringInvestment DecisionsKnowledge of FinanceKnowledge of StatisticsLaTeXLinear ProgrammingLinear RegressionLogistic RegressionMachine LearningMarket DataMarket ShareMarket TrendsMATLABMatplotlibMentoringMicrosoft ExcelMicrosoft PowerPointMicrosoft SQL ServerMicrosoft WordMongoDBMutual FundsMySQLNormalization ProcessesNumPyOperations ManagementOperations ResearchPandasPostgreSQLPredictive Data AnalysisPredictive ModellingPrincipal Component AnalysisPrivate EquityProject ManagementProphetPython (Programming Language)PytorchQuantitative ResearchRaw DataReliabilityRisk ManagementSalesSales PromotionScikit LearnSciPySecurities ResearchSQL DatabasesSQLiteStataStrategic ThinkingStrategies of PricingStreamlineTableau (Software)Team WorkingTensorflowTime SeriesVideo StreamingVisualizationXgboost