Aijia Yuan

About Me

Data enthusiasts who hope to provide better products that deliver more values to customers

Location

New York City, NY
Education
    Columbia University in the City of New York
    September 2024 - December 2025
    expected degree
    Master's
    majors
    Data Analytics
    Statistics
    University of Waterloo
    September 2019 - June 2024
Work Experience
    Super.com
    Data Analyst Intern
    Toronto, ON, Canada
    September 2023 - December 2023
    company
    Super.com
    title
    Data Analyst Intern
    overview
    - Communicated insights weekly from deep dive analysis on customer behaviors and made recommendations on product improvements. Collaborated with agile sprints cross-functionally to enhance loan repayment and cross-sell to customers, which led to a 5% reduction in churn intention for the quarter. - Queried data in SQL and developed visualizations in Looker and Amplitude to monitor OKRs and track user journeys. Identified key drop-off points in customer journeys, leading to a redefinition of serviceable customers and revised OKR metrics. - Handled ad-hoc requests from stakeholders, earning praise for speed and proactive engagement.
    ScotiaBank
    Data Analytics Intern
    Toronto, ON, Canada
    January 2022 - August 2022
    Enrst & Young Global Limited
    Consulting Intern
    Shanghai, People's Republic of China
    September 2020 - December 2020
Skills
Agile MethodologyAmplitudesApache SparkArtificial Neural NetworksAttention to DetailBanking ServicesBusiness AnalysisCloud ComputingComputer ProgrammingConsultingCredit RisksCross SellingCustomer ExperienceDashboardsData AnalysisDatabasesData ProcessingData VisualizationDesign of ExperimentsDigitizationEmployee RetentionESG CriteriaFinancial AnalysisForecasting SkillsInnovationKnowledge of MathematicsKnowledge of StatisticsLooker AnalyticsMachine LearningMapReduceMarketing AnalyticsMarket ShareMatplotlibMentoringMetricsMicrosoft AccessNLTK (NLP Analysis)NumPyOperations ManagementPandasPower BIPython (Programming Language)Random ForestRisk ManagementScikit LearnSciPySelf MotivationSnowflakeSQL DatabasesStakeholder ManagementTeam WorkingTechnological ChangeTensorflowTime SeriesVba Programming LanguageWeb Scraping
Leadership
    University of Waterloo
    Math Tutor
    September 2022 - April 2023