Post Job Free

Resume

Sign in

Data Analyst

Location:
Rockville, MD
Posted:
April 07, 2020

Contact this candidate

Resume:

Jialing (Carina) Liang

**** ******* ***, *********, **, 20852 Phone: 208-***-**** adco8q@r.postjobfree.com LinkedIn: https://www.linkedin.com/in/jialing-liang17 Career Target: Data Analyst/Business Intelligence EDUCATION

University of Maryland, College Park 2018.08-2019.12 Master of Science in Business Statistic, Marketing Analytics (STEM), GMAT 730, GPA 3.6/4.00 Primary Courses: Data Science, Digital Analytics, Statistical Programming, Pricing Analytics, etc. Zhongnan University of Economics and Law, China 2014.09-2018.06 Bachelor of Economics, GPA 3.62/4.00

Awards/Activities: Merit Scholarship (3 times), Outstanding Graduate/Student Leader, Student Union Director TECHNICAL SKILLS

Data Analytics: SQL, Excel Pivot Table, Google Analytics, A/B testing, Statistical Modeling, AWS, CRM Data Visualization Tools: Tableau, Power BI

Statistical Programming: R(dplyr,ggplot), SAS, Python(Numpy, Pandas, Scikit-learn), KNN,SVM WORK EXPERIENCE

Business Analyst Intern at EventBank, Inc., Tysons, VA 2020.03-2020.04

• Managed and updated company database and CRM system.

• Assisted the sales team by providing analytical support and campaign data visualization insight.

• Monitored the sales performance of the SaaS platform; acted as market development consultant by analyzing data of 10+ target market to optimize business development strategies in Great Atlanta and APAC area. Digital Analyst Intern at Precise Software Solutions, Inc., Rockville, MD 2019.06-2019.08

• Created the dashboard and analyzed the traffic data with Google Analytics for the official website.

• Identified the demographic and audience behavior insights with Tableau.

• Performed website optimization and A/B testing based on the funnel model of web analysis.

• Worked closely with the SDEs to conduct the Twitter data mining with Python for the NLP project (with 90.7% forecasting accuracy). The project won the 2019 Government Innovation Award. BI Analyst at Neighborhood Rescue of America, CA 2019.05-2019.06

• Generated dashboards in Tableau to visualize 20+ cities’ geographic mapping and calculate criminal rates.

• Worked closely with clients to identify their needs and generated customized analysis reports. Data Analyst Intern at China Vanke (Fortune 500), China 2017.06-2017.12

• Utilized Python to conduct data wrangling that extracts and organizes 6M real estate sales data; improved pipeline transparency and forecasting accuracy by 30%.

• Participated in the development and management of the CRM. Utilized SQL for data validation.

• Create Tableau dashboards and Excel functions (Pivot Table, Vlookup, conditional formatting) to discover transaction patterns; Optimized the third-quarter product portfolio and re-designed competitive pricing dashboards to accelerate the pricing decision-making process. Increased third-quarter sales by 8%.

• Measured online campaigns ROIs; proposed online strategies, including A/B testing email marketing. Data Analyst Intern at Taikang Insurance Group Inc, China 2017.01-2017.03

• Performed EDA on 6,000 records of daily training reflection data with Excel and SQL to get insights. Created data visualization and presentation for the reference of both the marketing and HR team.

• Monitored the talent acquisition performance of 150+ branches in province through weekly KPIs Calculation. PROJECT EXPERIENCE

Action Learning Project for Google Sales Data 2019.01-2019.03

• Cleaned 450,000 records of JSON data from Google Analytics with Python.

• Visualized data with Tableau to detect customers’ segmentation and transaction patterns.

• Used statistical models (linear regression & decision models) and utilized machine learning techniques (e.g. random forest, classification tree, SVM) and delivered a business report of high quality Leveraged strong analytical skills.



Contact this candidate