Data Analyst Sales

XIAOJIA HE

347-***-**** adb6zm@r.postjobfree.com *74 Warren Street, Apt #2405, Jersey City, NJ 07302 EDUCATION

Yeshiva University New York, NY

Master of Science in Data Analytics and Visualization expected Dec. 2020

• Relevant Coursework: Analytics Programming (Python), Structured Data Management (SQL), Visual Design

& Storytelling (Tableau), Information Architecture (AWS), Computational Mathematics, Project Management Xihua University China

Bachelor of Management in Auditing Sep. 2013 – Jun. 2017

• Relevant Coursework: Advanced Financial Accounting, Business Financial Auditing, Cost Accounting, Statistics, Calculus, Probability and Mathematical Statistics, Linear Algebra SKILLS

• Programming Language: Python, SQL Language, Tableau, Excel (VBA), Word, PowerPoint

• Languages: Mandarin (native), English (proficient) WORK EXPERIENCE

72 DRAGONS, LLC New York, NY

Data Analyst Intern Dec. 2019 – At Present

• Used Python API to scrape website data. Successfully helped movie companies identify most popular movies and got top ten actors who performed the most movies in 2018

• Create geographic maps through Tableau to show movie revenues in different countries and display numbers of movies in different years

Wan Qi Tech Co., Ltd China

Data Analyst Intern May 2018 – Oct. 2018

• Compiled sales and inventory charts to assist managers in identifying sales trends

• Analyzed statistics and calculated monthly sales ratios to compare sales changes

• Manipulated data from clients feedback to monitor sale staff performances and improve their work efficiency

• Analyzed charts to provide detailed information about extremes and exceptions to managers Rheem (China) Water Heater Co., Ltd China

Accountant Intern Jul. 2017 – Dec. 2017

• Compiled statistical charts of cash expenditures and bank deposits to record financial data

• Produced monthly balance reconciliation table to provide total expenditures and income for managers

• Created tax invoices for each sales transaction and maintained other non-monetary reports and records PROJECTS

Personal Income and Expense Analysis Sep. 2019 – Dec. 2019

• Imported Numpy and Pandas to clean data, then used Seaborn to generate barplots to display average income in different occupations and races in New York City

• Imported folium to Create geographic map to demonstrate income distributions in different counties

• Used Pandas aggregation and groupby function to build EDA that personal daily necessary expenditure only occupies 62% of their total expenses

• The city which has the highest expense ratio(67%) is Honolulu, and Minneapolis is the lowest city(58%) Crime Analysis in NYC

• Used matplotlib and seaborn to customize graphics and show the distribution of different crimes in NYC

• Build exploratory data analysis (EDA) that the most dangerous county is Kings where the crime reaches to 2.5 million from 1990 to 2017, and Larceny is the most common crime which average frequency is 803 per year Income Visualization in NYC with Tableau

• Used Tableau to create dashboards to identify and interpret trends of personal income in New York City

• Build barchart visualizations to successfully demonstrate relationships between income and Race, Gender, and Occupations separately

EXTRACURRICULAR ACTIVITIES & INTERESTS

• Volunteer of Chengdu AiSi Youth Club

• President of Student Union

• Interests: Dancing, Hiking, Traveling, Yoga, Music, Hollywood blockbusters

Contact this candidate