Juanjia Yuan

Location

New York City, NY
Education
    Fordham University
    July 2019 - December 2020
    degree
    Master's
    major
    Information Technology (IT)
Work Experience
    ZETA GLOBAL
    Senior Analyst Data Science AND Analytics Martech
    New York, NY, US
    March 2023 - present
    company
    ZETA GLOBAL
    title
    Senior Analyst Data Science AND Analytics Martech
    overview
    - Led a code migration project to reduce runtime by 70% and processed up to 10M+ rows of data by migrating Pyspark - Actively formulated strategies to improve ROI with clients have $1M+ quarterly budget(UnitedAirline, DiscountTire, WilliamSonoma) by deep diving into KPIs and data patterns to understand the key performance drivers - Built and scored predictive models such as GLM for different customer priorities (LTV, Propensity, Channel Specific - Processed up to 10M+ rows of data by building ETL pipeline between Snowflake and AWS S3 buckets using Boto3 - Designed and deployed an end-to-end reporting solution for 30+ clients across the analytics departments
    CARVANA
    Data Analyst Strategic and Expansion Business Forecasting
    Tempe, AZ, US
    April 2021 - January 2023
    GABELLI SCHOOL OF BUSINESS FORDHAM UNIVERSITY
    Senior Technical Member
    New York, NY, US
    May 2020 - February 2021
Skills
AirflowAlteryxAmazon S3Analysis of Variance (ANOVA)Analytical ThinkingApplication Programming Interfaces (APIs)AutomationBoto3Budgeting SkillsBusiness AnalysisBusiness ForecastsClimate ChangeCloud ComputingCode MigrationComputer VisionCorporate Social ResponsibilityCropping SkillsData AnalysisDatabricksData IntegrityData PipelinesData ScienceDecision Making SkillsDialectical Behavior TherapyDigitizationDronesExtract Transform Load (ETL)Forecasting SkillsGeneralized Linear ModelGoogle AnalyticsGoogle CloudGPTHTML5JavaScript (Programming Language)JIRAKeyword ResearchKnowledge of EngineeringKnowledge of StatisticsLoan-To-Value RatiosLogistics OperationsLooker AnalyticsMachine LearningMetricsMicrosoft AzureMicrosoft ExcelNatural Language ProcessingNetworking SkillsNetwork OptimizationObject DetectionOracle ApplicationsPredictive ModellingPresentationsProduction Costs ManagementProduction SchedulePysparkPython (Programming Language)QliksenseRelational DatabasesS3 BucketSentiment AnalysisSnowflakeSpotfireSPSS (Software)SQLAlchemySQL DatabasesStakeholder ManagementStandardizationStock ControlStrategic ThinkingSustainabilityTableau (Software)Tax EfficiencyText AnalysisTradingVba Programming LanguageYAML