Los Angeles Data Analyst

CiCi Xu

Irvine, CA 213-***-**** ***********@*****.*** LinkedIn

EDUCATION

University of Southern California, Marshall School of Business Los Angeles, CA

Master of Science in Business Analytics December 2023

Bachelor of Science in Business Administration May 2019

Relevant Coursework: Business Analytics, Fraud Analytics, Advanced Regression Analysis, Applied Modern Statistical Learning Methods, Statistical Computing and Data Visualization, SQL Databased for Business Analysts

PROFESSIONAL EXPERIENCE

PurryPurry Inc Los Angeles, CA November 2023-Present

Data Analyst

Conducted data analysis and modeling to guide business advertisement investment decisions for pet supplies using 50K+ data including video views and lengths, formulating marketing strategies and applied A/B testing to result in a 68% increase in exposure and a 29% increase in sales revenue.

Extracted video comment data using SQL queries and executed view fraud detection in Python, removing 5% of records through Random Forest based on key performance metrics and achieving an R-sq of 0.95.

Implemented time series modeling to forecast views across various video categories by developing and comparing different models (ARIMA and LSTM), delivering 90% trend prediction accuracy.

Utilized Langchain to build LLM for automated comment generation under Instagram post and YouTube videos featuring company advertisements, deploying on AWS infrastructure for seamless integration and scalability.

Agricultural Bank of China Jiangsu, China June 2021-December 2021

Financial Analyst

Led card transaction fraud detection analysis on 200K+ transactions, applying data cleaning and feature engineering (entity linking) to identify fraud patterns based on transaction amount, frequencies, zip codes, etc.

Utilized machine learning algorithms (including Decision Tree, Random Forest, LightGBM, and XGBoost) to achieve a 67.6% Fraud Detection Rate (FDR) within the top 3% high-risk transaction cases.

Identified and recommended the rejection of 9% of transactions deemed high-risk through the final stacking prediction model, contributing to potential annual savings of $1.386M.

Fostered cross-functional team collaboration and effective communication, presenting complex analytical findings to a team of 100, cultivating a culture of continuous improvement within the team.

Union Apartment Real Estate Los Angeles, CA August 2019-August 2020

Marketing Analyst

Employed time series modeling techniques to analyze residential housing data in Los Angeles; leveraged LSTM to predict property rents and future listing prices, reaching an average monthly sales increase of $2K per property.

Produced insightful data visualizations by building interactive Tableau dashboards to drive strategic planning and optimized pricing strategies; exported analyzed data with ranked scores, to facilitate data-driven decisions.

Executed data preprocessing and feature engineering tasks, incorporating PCA to effectively reduce feature dimensionality; developed an autoencoder neural network using Keras and TensorFlow for anomaly detection, enhancing the identification of significant outlier records.

ByteDance Inc Los Angeles, CA February 2018-September 2018

Content Analyst Intern

Cleaned and analyzed viewership data to extract insights into key characteristics and behaviors using SQL; developed customer segmentation to tailor content recommendations, optimizing engagement and satisfaction.

Performed quality assurance checks on 3K+ articles and videos daily for TopBuzz and News Republic apps, implementing automation to streamline review processes and enhance editing efficiency, resulting in an average CTR of 90%+ (30% higher than team’s average).

Coordinated international content teams to align company policies and ensure consistency across global operations, creating a marketing strategy report for executive management review.

SKILLS

Technical skills: Python (Pandas, SciPy, sk-learn), SQL, Tableau, Excel (VBA, Macro,VLOOPKUP), PowerBI, NoSQL, SAS

Methodologies: Data Preprocessing, Database Management, Data Visualization, Machine Learning, A/B Testing

Interests: Painting, Writing, Reading, Calligraphy, Digital Photography, Video Editing, Teaching Chinese, Traveling

Contact this candidate