Yuan Wang

*** ******** ***, *** ***, San Jose, CA 95129 • 301-***-**** • adcdvs@r.postjobfree.com

EXECUTIVE SUMMARY

Full-time Data Analyst at Apple Maps where I focus on data validation and reporting. Use SQL, HiveQL, and Python to query and validate newly ingested data. Build reports on the quality of data we ingest that is sent out to company stake-holders after data validation. Part-time graduate student in San Jose State University for Data Analytics. US Citizen and no need for any sponsorship.

TECHNICAL SKILLS

Programming Languages: Python, SAS, R, SQL, Hive, Hadoop, PostgreSQL, MongoDB, HTML, JavaScript Tools: Unix, Statistical Data Modeling in Python, Univariate, Bivariate and Multivariate Analysis in Jupyter Notebook

(Numpy, Scipy, Pandas, Matplotlib), Tensorflow, Machine learning and Bayesian in Python, Tableau, QGIS PROFESSIONAL EXPERIENCE

Data Analyst, Apple (via Apex Systems) Sunnyvale, CA Sep 2019 - Present

• Modernize and optimize Apple Maps

• Write complex queries using SQL to map 10,000+ old data points to new data points to ensure no key information is lost

• Develop python scripts to automate reporting and validation on newly ingested data

• Report on the quality and cleaning done on data for a given country that is sent to company stakeholders as a release report

Army Reserve for Supply Specialist Mountain View, CA 2018 - present

• Monthly drill for the Army unit as supply specialist for data collection for warehouse and weapons room EDUCATION

San Jose State University

• Master of Science for Data Analytics San Jose, CA 2019 - 2021

• Core Courses: Database Management, Mathematical Methods for Data Analytics, Machine Learning, Data Mining, Big Data Technologies, Information Visualization CodingDojo Bootcamp

• Full Stack Development Certificate San Jose, CA 2019 University of Maryland at College Park College Park, MD 2013 - 2015

• Master of Science for Civil Engineering

Nanjing University of Technology Nanjing, China 2009-2013

• Bachelor for Civil Engineering

INDEPENDENT PROJECTS

Practical Machine Learning Project in Python on House Prices Data

• Using Kaggle’s dataset to do the data exploration. Creating charts, graphs using univariate and bivariate analysis. Machine learning model training and testing to predict house prices. Weather Forecaster using API

• Programmed an API in Python to forecast daily weather information for users across multiple cities throughout a 30-day period based on historical data of a whole year.