Data Analyst Engineer

Jingchao Fu

DATA ANALYST · DATA-DRIVEN AND CURIOUS PROFESSIONAL

*** ******** **. ****** ** 02148

510-***-**** adb7ie@r.postjobfree.com Jingchao-Fu Skills

Programming Languages/Tools Python,Sciktlearn package, R, SQL, Tableau, Qlikview, Advanced Excel, KNIME, BigQuery, AWS basic Skills Data Warehousing, Data Modeling, Data Visualization, Data Reporting, Detail-Oriented, Problem Solving Experience

ViacomCBS

LEAD DATA ANALYST FOR MARKETING PROJECT Oct 2019 - Dec 2019

• Optimized pricing strategy by building and validating predictive models with Python and KNIME to reverse engineer Facebook’s pricing algo- rithms and forecast CPM from for Viacom’s 154 pages on daily level.

• Led team of 5 to perform ETL on complex dataset and built a customer look-alike model along with conversion funnel analysis enabling man- agement to accurately predict audience profile and behavior using k-mean clustering

• Expanded 5 % profit margin using XGBoost to predict and analyze customer’s behavior within each conversion funnel and forecasted daily revenue over 154 accounts.

• Created actionable, user-friendly and interactive Tableau reporting dashboard to present insights and recommendations on channels, conver- sion rate, click through rate, CPM for each audience group to enhance campaign performance. Alibaba Group

BUSINESS DATA ANALYST INTERN Jul 2019 - Sep 2019

• Performed end to end data analysis from data extraction, data cleaning, data transformation and loading.

• Conducted Root Cause Analyses and presented solutions with Tableau dashboard for our clients to handle predicted obstacles during digital transformation for continuous improvement.

• Performed customer clustering analysis with Python and SQL to efficiently evaluate demands and promote product to target customers for our client Forest Cabin, increasing revenue by 20 percent.

• Examined previous key metrics and designed newmetricsproactivelytoprovideguidanceonincreasingmarginopportunityandthebusiness. InterContinental Hotels Group-Crowne Plaza

DATA ANALYST INTERN OF BUSINESS DEVELOPMENT May 2016 - Sep 2016

• Performed data analysis for our client Daimler’smarketing event and assisted in the designing analytical reports to deliver insight in Tableau.

• Checked data integrity and accurately predicted return by conduct Monte Carlos Simulation by analyzing revenue data in Excel. Harlyn Investment Management (Beijing) CO. LTD

DATA ANALYST INTERN Jun 2015 - Sep 2015

• Collected, extracted and transformed financial data from clients to load information in database

• Collaborated with team to conduct data analysis using Excel VLookup and Pivot Table to present top 5 companies to reach target ROI.

• Reduce operation cost by 5 % by volunteering to design standardized solutions to enhance hiring efficiency. Project

Real Estate and Housing Prices in Ames(R/Tableau)

TEAM LEAD Apr 2019 - Jun 2019

• Applied data mining technique to deal with miss data and anomalies and prepare data for Machine Learning.

• Implemented Random Forrest, Ridge/Lasso Regression, XGBoost Machine learning algorithms to predict housing price in Ames,Iowa USA

• Improved model’s accuracy by implementing feature engineering and generated insights on entering Ames’ housing market. Education

Northeastern University Boston, MA

MASTER OF SCIENCE IN DATA ANALYTICS-STATISTICAL MODELING Mar 2020

• Relevant Coursework:Data Mining, Regression Analysis, Relational Database Management, Predictive Model Building, MySQL, Visual Basic, En- terprise Analytics, Machine Learning, Marketing, Experimental Design

• GPA: 3.89

California State University-East Bay Hayward, CA

BACHELOR OF ART IN ECONOMICS Jun 2018

• Relevant Coursework: Econometrics, Mico/Marco-Economics

• GPA: 3.2

Contact this candidate