Post Job Free

Resume

Sign in

marketing/customer analytics, R, Python,SQL,Tableau, PowerBI

Location:
La Jolla, CA
Posted:
June 08, 2021

Contact this candidate

Resume:

Chen Li

La Jolla, CA 858-***-**** LinkedIn Github adm0cm@r.postjobfree.com

Education

University of California, San Diego San Diego, CA

Master of Science in Business Analytics (STEM designated) 09/2020-12/2021

• Major Courses: Business Analytics, Collecting and Analyzing Large Data, Pricing Analytics, Big Data Technology & Business Applications, Customer Analytics, Business Intelligence Systems Beijing University of Technology Beijing, China

Bachelor of Science in Statistics 09/2011-07/2015

Specialized Skills

• Languages/Coding: Python(Numpy, Pandas, Sklearn, TensorFlow, NLTK, spaCy), SQL, R, MATLAB, SAS

• ML Toolkits: K-means, Clustering, Logistic Regression, Time Series analysis, A/B testing, XGBoost, Neutral Networks

• Big Data Toolkits: Spark, AWS, Google Analytics, SQL Server, PostgreSQL, Scala, Hive/Hadoop, Access, SPSS

• Data Visualization: Matplotlib, Seaborn, Tableau, Power BI, R Shiny, Plotly, Dash, ggplot Professional Experience

Ividea Cultural Co., Ltd (A multimedia firm focused on customizing new media contents) Beijing, China Business Analyst 10/2019 –08/2020

• Contributed to analytic platform construction, generated dashboards and visualizations to conduct periodic trends reports of customer retention and growth

• Developed SEO strategies for clients based on keyword research, competitive analysis, churn analysis, current rankings using Python, increasing organic traffic 18% within 1 month

• Built marketing expense allocation in channels by analyzing performance metrics (CTR, CVR, PV); contributed to apply clustering algorithms in Python to optimize content pattern, improving resource allocation and performance China Central Television (Chinese largest public service broadcaster) Beijing, China Marketing Analyst 01/2018 - 05/2019

• Designed questionnaires and conducted market research, contributing market expansion recommendations, to help company increase 1.5 million dollars annual revenue

• Initiated refined product classification in R with product development team by creating data-based customer role, promoting business inquiry by 26% within 6 months

Product Pricing Senior Assistant 05/2016 - 12/2017

• Performed deep dive into sale data with R, identifying opportunities for improving pricing strategies

• Provided data requirements using SQL for customer service team and performed competitor analysis to advance marketing service, boosted revenue by 10% within 2 months Product Pricing Assistant 08/2015 - 04/2016

• Collaborating cross-functionally, executed product sales process and conducted database maintenance, integrity checks, and performance optimizations; completed data requests and statistical analysis for decision-making Projects

Data Science Related Job Analysis Data Visualization, Statistical Analysis Dec 2020

• Scrapped 12K data-related job recruitment data form GlassDoor; using R analyzed and visualized employment market by job requirements, opportunity, salary range, and location, and identified the key skillsets for four job titles

• Trained regression model to predict salary range based on job location and industry, achieving 70% accuracy Customer Analytics Project CLV Management, RFM Analysis, Machine Learning Feb 2021

• Calculated customer lifetime values for different advertisement email frequency from Intuit and determined the optimal advertisement email sent-out frequency

• Determine expected profit of new campaign in targeted customers by implementing RFM, logistic regression, tree- based and deep learning models, and increased profits by 32% in the campaign

• Provided individual level customized advertisement from different product departments for current customers by analyzing purchase behavior in deep learning models and leads to 29% net profit increase Petco Case Study Time Series Analysis, Machine Learning May 2021

• Concatenated data of 200 million+ entries from 1500+ stores in the past 27 months from different tables, and processed data into ideal forms for different models

• Built ARIMA and Prophet model to predict weekly or daily sales and margin (next 12 months), supporting the company determine budgets and control spending



Contact this candidate