Jiwei Li

San Francisco, CA, USA +1-415-***-****

Email: adbdaf@r.postjobfree.com

LinkedIn: https://www.linkedin.com/in/jiwei-li-475587176/ Education

Master of Business Analytics (MBAN) August 2018- September 2019 Hult International Business School San Francisco, CA Relevant Courses: Python, SQL, R, Tableau, Power BI, Teradata, SPSS, Machine Learning, Data Visualization, Data Mining, MySQL, NoSQL, Hadoop, Spark, And Hive, Google Analytics MS, Economics September 2014-January 2016

Central University of Finance and Economics Beijing, China Courses: Investment, Reginal Economics and Block Chain BA, Marketing September 2010-June 2014

Dalian University of Foreign Languages Dalian, China Courses: Marketing Research and Make Market Strategy Experience

AKQA---San Francisco, CA September,2019 - Present

Senior Analyst

Apply data ETL through Datorama and Excel, from paid social APIs, DCM, and Google Analytics

- Visualize insights in Tableau/Power BI based on the data which were extracted from MySQL

- Report and analyze campaign performance in a weekly and quarterly basis to help optimize media tactics

- Implement reporting automation in R/Python and publish as apps to make program available to other team members

EVENT HOLLOW COMPANY San Francisco, CA May 2019-Aug 2019 Market Data analyst intern

Large dataset cleaning and gathering. Database management: add or extract data based on our existing database Data exploration and data visualization.

Use machine learning and AI technology to analyze customer retention and create optimized marketing strategy

NEWPATHVR COMPANY San Francisco, CA May 2019-Aug 2019 Data Analyst Intern

Use Power BI/Tableau to create the dashboard and use Python/R do some basic data analysis which is relevant to cost/revenue/ customer numbers.

GREENDATA.IO COMPANY San Francisco May 2019-Aug 2019 Data Analyst Intern

Building reports and visualizations using Power BI & Beautiful.AI along with other analytic reporting tools. Designing and building machine learning algorithms to be leveraged in various applications built by GreenData.IO, Inc and its partners/clients.

CMA CGM LOGISTICS COMPANY Dalian, China December 2016-June 2018 Operations & Data Analytics

Leverage customer’s data to figure out clients’ preference and use Clustering & PCA to understand the market segment and group our customers. Build the predictive model to anticipate the export volumes and future used space

KUEHNE + NAGEL LOGISTICS COMPANY Dalian, China January 2016– December 2016 Market Research Analytics

Use SQL to manage our database and extract the useful resource from database. Analyze the data collected from the market to predict the next quarter increase or decrease so that we can provide suitable container volume.