Data Analyst

ALEX X. LI

*** * *** ******* ****., Apt. #*, San Gabriel, CA 91776

626-***-**** *********.**@*****.*** www.linkedin.com/in/alex-li94 SUMMARY

Motivated, teamwork-oriented, and responsible data Analyst with 3+ years of experience in interpreting and analyzing data for driving business solutions. Proficient knowledge in statistics, mathematics, and analytics. Excellent understanding of business operations and analytics tools for effective analyses of data. HIGHLIGHT

• Data Analysis • MS SQL/MySQL • Database Design

• Data Visualization & Storytelling • Tableau • Optimization Modeling

• Machine Learning • R • Python

• A/B Testing • Alteryx • Business Intelligence (BI) WORK EXPERIENCE

Trusaic Los Angeles, CA

Data Analyst May 2019 – Present

Performed thoughtful analysis for clients under Pay Equity Act by machine learning algorithm (Multiple Linear Regression / Logistic Regression) with R, reducing $53,000 penalty amount on average per client

Created visually impactful dashboard in Excel and Tableau for data reporting by using pivot tables and VLOOKUP

Extracted, interpreted and analyzed data to identify key metrics and transform raw data into meaningful, actionable information by using ETL tool - Alteryx

Challenged existing Excel-based database. Designed and developed the SQL database in MS SQL Server iResearch Guangzhou, Guangdong

Data Analyst June 2017 – June 2018

Assisted technical team to develop rules of cleaning data and obtain accurate data source based on iResearch's database and customer-provided database by using Excel/MySQL/R-Studio

Provided customized data analysis and research consulting services to customers in the Internet industry, media, advertising agencies and other industries by using Google Analytics

Designed and built statistical analysis models on large data sets that helped increase online sales (up to 30% per product) and landing page conversion (up to 10% per product)

Output visualized data analysis reports by using Tableau, and interpreted and answered questions for customers, maintained customer relationships and extended customer needs EDUCATION

Pepperdine University, Graziadio School of Business and Management Malibu, CA Master of Science in Applied Analytics GPA: 3.5/4.0 August 2019

Relative Courses: Advanced Statistical Tools / Machine Learning / Big Data Management / Data Visualization & Storytelling / Marketing Analysis / Database Administration Sun Yat-Sen University, Lingnan (University) College Guangzhou, Guangdong, China Bachelor of Management Science GPA: 3.6/4.0 June 2017

Leadership: President of Department of Public Relations

Honors: Graduate with high distinction, Champion team of Corporate Culture Competition RELEVENT COURSEWORK

Predictive Modeling Malibu, CA

HOW to find targeted customers, Group Project June 2019

Collaborated with 4 teammates and went through the whole analytics process flow, including problem statement, data collection and processing, identifying biases, building quantified model, visualizing and storytelling.

Built machine learning models using R and SAS JMP in identifying key attributes of achieving goals.

Contact this candidate