Jiarui Lin
Chelsea,MA
Summary
Data Analyst and Digital Marketing Specialist with expertise in data visualization, statistical analysis, and machine learning. Proficient in Tableau, Python, and SQL to drive actionable insights and enhance business outcomes. Skilled in developing data-driven strategies to improve sales forecasting accuracy and optimize digital marketing campaigns. Effective collaborator experienced in presenting complex data insights to stakeholders.
Overview
6
6
years of professional experience
Work History
Web Analytics Teaching Assistant
Boston University
Boston , MA
2024.01 - 2024.05
- Graded assignments and organized office hours to support academic success, using R and SQL for analytics tasks such as constructing a database for demographic filtering in a class of 30+ students.
- Assisted in the delivery of a digital and e-commerce analytics course with a focus on SQL database, web analytics, and data mining.
- Enhanced classroom engagement and facilitated proficiency in analytical tools, collaborating with faculty to enhance Google Analytics skills and establish E-Portfolio setup.
Business Analyst & Consultant
Alba Inc.
Vancouver , BC
2021.04 - 2022.06
- Managed data collection and analysis for intakes, requests, and referrals. Coordinated collaborative projects across teams, tracking progress with the aid of interactive dashboards and an ERP system.
- Prepared and delivered weekly and monthly reports in Excel, showcasing sales trends, referrals, offers, commission, and income. Provided ad hoc analysis and presented key performance indicators (KPIs) for data-driven decision-making.
- Visualized monthly sales and key performance metrics with Tableau, enhancing trend forecasts and implementing time-series analysis to contribute to an 11% improvement in sales forecasting accuracy.
Marketing Analyst Intern
EF Education
Hangzhou
2018.05 - 2018.08
- Coordinated of offline booth setups and provided consulting for 100+ families, strategically positioned within 3 km of schools and high-traffic areas, using data analysis to target densely populated demographics.
- Utilized linear regression models to predict customer flows, optimizing budget allocation and booth placement for maximum visibility and foot traffic
- Conducted KNN-driven segmentation for marketing materials distribution, engaging potential clients and acquiring leads and customer information for strategic pricing and targeted marketing.
Education
Master of Science - Applied Business Analytics
Boston University
Boston, MA2024-05
Bachelor of Arts - Psychology
University of British Columbia
Vancouver2020-05
Skills
- Data Modeling
- Software Development Life Cycle (SDLC)
- Database Maintenance
- Machine Learning
- Data Visualization
- Data and Trend Forecasting
- Developing Presentations and Reports
- Email Marketing
- Trend Analysis
- Campaign Management
- ROI Analysis
- KPI Analysis
- A/B Testing
- Social Media Management
- Database Programming and SQL
- Expert in Python, R, SQL server tools, Excel, Google Analytics
Academic Project
Feline Behavior and Personality Traits Analysis ｜ Python ｜ 01/2024 - 05/2024
- Analyzed behavior and personality traits of 4,300 cats across 56 breeds to identify suitable breeds for prospective owners.
- Applied K-means clustering to categorize breeds into 3 clusters based on behavior traits. Conducted hypothesis testing using Pearson correlation and t-tests to investigate relationships between different traits.
- Developed classification models (Logistic Regression, KNN, LDA, SVM, Decision Tree, Naive Bayes) to predict problematic behaviors, achieving 65% accuracy with Logistic Regression. Used Random Forest classifier to predict suitability for first-time owners, achieving 65% accuracy.
Timeline
Web Analytics Teaching Assistant
Boston University
2024.01 - 2024.05
Business Analyst & Consultant
Alba Inc.
2021.04 - 2022.06
Marketing Analyst Intern
EF Education
2018.05 - 2018.08
Master of Science - Applied Business Analytics
Boston University
Bachelor of Arts - Psychology
University of British Columbia
Similar Profiles
Jenny DavisJenny Davis
Sr. Research Safety Specialist, EH&S at Boston UniversitySr. Research Safety Specialist, EH&S at Boston University
Maira ArevaloMaira Arevalo
Dental Assisting Training Program at Boston UniversityDental Assisting Training Program at Boston University
Liuzexin RenLiuzexin Ren
Undergraduate Research Assistant at Boston UniversityUndergraduate Research Assistant at Boston University