Data Analyst

Dongqi Tang

! Mobile: +1-929-***-**** " Email: *******@*****.*** " LinkedIn: dongqi-tang-9b3519134

EDUCATION

New York University New York, U.S.A

M.S. in Information Science 09/2020-12/2022

Related Courses: Fundamental Algorithms, Database System, Machine Learning, Deep Learning, Reinforcement Learning, Big Data Science, Data Science for Business, Digital Strategy, Data Modeling (SQL), Statistics University of Minnesota, Twin Cities Minneapolis, U.S.A B.S.B in Management Information Systems, Minor in Finance 09/2015-08/2019 SKILL

Technical: SQL, Python, Tableau (Certificate), R, Java, Hadoop, Spark, Visual Basic, Google Analytics, MS Access WORK EXPERIENCE

Data Analyst, Aolai Company - Chengdu, China 03/2020-07/2020

• Identified customers’ life journey and adopted SQL to establish metrics of customer churn and customer behavior

• Helped business partners to establish reducing churn interventions to investigate the relationship between behavior and churn by performing cohort analysis and clustering analysis

• Implemented Python (Panda, NumPy, Matplotlib, Scikit-learn) to build a logistic regression model to forecast churn probability

• Created and presented reports to stakeholders to highlight the status of business development and profitability Operation & Data Analyst, Inspur Information - Beijing, China 06/2019-11/2019

• Used SQL to apply Funnel Analysis on channel traffic and landing pages, improving the registration conversion rate by 12% for AI Computing Conference (AICC)

• Operated official account on Twitter, working with cross-functional groups to identify marketing focus and generate operation strategies, contributing to accelerating Inspur Oversea promotion

• Retrieved keywords and gained insights by using Python to perform Text Mining Analysis and Topic Modeling on event-related marketing tweets, achieving a 5% increase in 2019 OCP Amsterdam Regional Summit Twitter operating performance

Google Ads Analyst, US Marketing, Inc. - Remote, USA 09/2018-05/2019

• Used Google Ads/Analytics and Unbounce to build search ads, to optimize the performance of keywords, search terms, landing page, etc.

• Applied A/B test on ads campaign to split the ads and quantify the impact of the adjustment

• Tracked ads performance and analyzed metrics, such as bounce rate, quality score, conversion rate, etc., to optimize ads operation plan and successfully improved client ads’ conversion rate by 10% RPOJECT EXPERIENCE

Forecast Energy Demand for a Building to Improve Resource Management – Personal 06/2021-08/2021

• Performed exploratory analysis, data preprocessing and feature selection for energy and temperature data, built the forecasting model using Python to predict energy use on Linear Regression, KNN and Decision Tree

• Built the Holt-Winters Exponential Smoothing model and ARIMA model to perform time series analysis on residual values gained from the regression analysis

• Optimized energy use prediction by adding the predicted residuals to the predictions of energy use from the regression model, decreasing the MAPE by 1.2%

Cluster Posts and Predict the Tag of a Submission Post from the Subreddit - NYU 10/2020-12/2020

• Built an ETL data pipeline using Reddit API to the database on MongoDB

• Preprocessed text-based data using NLTK and performed topic modeling using LDA to cluster documents

• Established an NLP model (T5) to apply transfer learning and to predict the tag of a post, improved the weighted f1-score by augmenting imbalanced dataset

LEADERSHIP & ACTIVITIES

Member, Rewrite the Code, NYU 09/2021-Present

The Secretary-General, Chinese Students Scholarship Association, UMN 01/2017-02/2019 Volunteer, Foreign Children Adoption, UMN 09/2015-02/2017 Super Host, Airbnb Operation (achieved nearly $42,000 annual sales, hosted more than 100 guests) 01/2015-01/2017

Contact this candidate