About Me

Hi I am Jacquelin Lai,
an enthusiastic Data Scientist!

Programming Skills

HTML5/CSS3

      <
Expert

Python

      <
Expert

C++

      <
Intermediate

Java

      <
Beginner

Other Skills

Data Visualization (Tableau, Power BI)

      <
Advanced

Excel

      <
Expert

Machine Learning

      <
Intermediate

Data Cleaning & Preprocessing

      <
Expert

Statistical Analysis

      <
Advanced

Data Warehousing

      <
Intermediate

Hadoop

      <
Intermediate

Data Analyst

May 2024 — present

Location: Wet & Forget

• Create key performance indicators (KPIs) through market analysis, and develop data visualization report -interactive dashboards in Excel, Looker Studio, Power BI that enhance decision-making efficiency
• Implement A/B Testing in Google Optimize with Search Engine Optimization (SEO) and Tag Manager
• Design a structured SQL database (SSMS & SQL Server) to optimize data storage, showcasing flexibility in adapting to complex data management needs and supporting informed business analysis
• Improve reporting efficiency by 59% with SQL queries to manage marketing and sales data on Azure
• Improve data accuracy and reduce processing time to 10 seconds by optimizing ETL pipelines, employing the best practices in database administration to efficiently process large-scale datasets
• Initiated minimizing manual efforts and errors by creating RESTful APIs with Python, JSON, Java, XML, and Agile methods to create automated data pulling from various e-commerce and marketing platforms
• Leverage TensorFlow to develop machine learning models to provide informed strategic forecasting

Bechelor Student majoring in Data Science & Info Sciences

Aug 2021 — May 2025

Location: University of Illinois at Urbana-Champaign

• Minor in Computer Science
• Conducted research in AI Modeling to Predict and Classify Fatigue Levels and Types
• Won 1st place in Data Dive Competition hold by [Data Science Illinois Club] (https://one.illinois.edu/illinoisdatascienceclub/home/)
• Part-time work at IT Partners of the Education Building
• Published paper, [Text Sentiment Support Phrases Extraction based on RoBERTa (NLP Model)] (https://ieeexplore.ieee.org/document/9607135)

Business Analyst Intern

May 2021 — Aug 2021

Location: AliPrice Technologies Co. Ltd.

• Performed customer behavior data analysis from multiple e-commerce platforms and SQL Server Management Studio to identify procurement trends and patterns, resulting in a 20% increase in conversion rates for product listings
• Wrote product blogs and articles about cross-border E-Commerce trade to perform search engines optimization
• Assisted in the design and execution of A/B testing to evaluate the effectiveness of different features and digital
marketing strategies, leading to a 400k user growth