Hao NI

Hao NI

Washington D.C., DC, USA


Last updated June 2, 2020

One Sentence About Me  

Data Analyst

Who I Am  

A Little About Me

I have a background in digital marketing and CRM for clients where I used SQL to extract KPIs for them, primarily for well-known brands, such as L'Oréal-Armani, YSL, Mercedes Benz, and Nestle etc. I also performed a deeper data analysis using R/ Python/ SAS for them to meet their brief. I am a current Master's in Business Analytics Candidate at GW. My skillset: - Tools: SQL, R, Tableau/Shiny, Python, Hive, Spark, Google Analytics, Adobe Analytics, Google Ads, SAS, Excel - Statistical knowledge: GLM, regression, decision tree, random forest, boosting, clustering, KNN, SVM, time series, PCA, EDA, A/B testing

Interesting Factoid

I have a background in digital marketing and CRM for clients where I used SQL to extract KPIs for them, primarily for well-known brands, such as L'Oréal-Armani, YSL, Mercedes Benz, and Nestle etc


Languages

English
Chinese

What I Do  


Professional Experience

Amber Mobile Limited

Data Analyst

• Extracted KPIs, including numbers of new, active, and retained users, page view, downloads, and conversion rate of 100+ applications with SQL; determined performance of each application and whether to keep or remove information • Created heat map of clicks, landing rates, and funnel charts of paths for A/B test, optimizing interactions of applications, increasing click rate by 5% • Mastered Umeng, Firebase, and Facebook databases; helped decide features on app to advance customer obsession; jointly designed ads pricing of Facebook/Admob; and analyzed one million users’ information to maximize profits

Publicis Sapient

Data Analyst

• Applied SQL to query channels, membership status, and parental information of Nestle milk powder, tracking channels’ conversion rates; created analytics via survey of 400,000+ pregnant women, capturing answers from social media interactions and offline shopping guide activities data; and elevated targeted advertising, increasing conversion rate by 1% • Led multi-dimensional content performance review and content tagging of a social media account with Excel, increasing open rate and engagement rate and enhancing targeting content • Built official website for Mercedes Benz with Adobe Experience Manager; tagged 28 customer categories to personalize one million users’ experiences and launched successfully in the Greater China • Analyzed Nestle’s CRM monthly Nielsen report with SWOT; held workshops to share strategies for next campaign topics
+1 more experience

What I Stand For  

Social Causes

Down syndrome association

Education  

School

George Washington University

Master of Science, Business Analytics


Academic Interests

Data Analytics