Python, SQL, Tableau, Excel, R, Strong PowerPoint

Stan Zhang

adjuc5@r.postjobfree.com 718-***-**** LinkedIn GitHub Tableau Seeking Full-time Data Related Role EDUCATION

New York University New York, NY

Master of Science in Data Analytics, STEM (GPA 4.00/4.00) Sep 2019 - May 2021

• Relevant Coursework: Data Science, Machine Learning, Business Analytics, Statistics, Data Visualization Kunming University of Science and Technology Kunming, China Bachelor of Science in Engineering Management (GPA 3.84/4.00) Aug 2015 - Jun 2019 WORK EXPERIENCE

United Nations New York, NY

Data Analyst – Strategy Planning Sep 2020 - Present Data Warehouse and ETL Modeling

• Enhanced data integrity, correlation, accuracy for 100k confidential records by creating MySQL, OLAP cloud data warehouses

• Increased 50% efficiency by applying automatic data pipeline and ETL using Pandas, SQL partition and aggregation functions

• Developed 17 Excel spreadsheets with pre-installed functionalities to evaluate 1600+ Human Resource and demographical data Business Intelligence and Data Science for UN Policy and Operation

• Defined top 10 significant metrics for operational-policy performance to enhance user experience and save operational cost

• Improved 20% accuracy of forecasting operation cost by statistical hypothesis-test model using Pandas, Numpy, Matplotlib

• Designed 30+ interactive dashboards using Tableau, Power BI, and 10+ visually appealing infographics to provide deep-dive data analysis and story-telling reports, translated analysis result into rational business strategies for 15 UN sustainable missions New York University, Department of Technology Management and Innovation New York, NY Senior Graduate Assistant, Data Analytics Feb 2020 - Jan 2021

• Conducted 5 market research for potential Master programs to provide critical benchmarks and decisions to expand business

• Optimized 700+ students’ experience by developing auto-reply AI with tracking and analyzing their metadata using Python

• Reduced from 59% to 27% conflicts of courses schedule by deep-dive EDA analysis for students’ behavior of selecting courses

• Increased 5% CTR for university programs website button and 12% conversion rate by designing and performing A/B testing on adjustments regarding webpage UIUX using Google Analytics, hypothesis t-test by Excel functions, Numpy, and Pandas New York University, Tandon School of Engineering New York, NY Teaching Assistant - Data Science & Visualization for Business Intelligence May 2020 - Aug 2020

• Instructed 35 students using Tableau, Power BI, and SQL techniques including metrics definition, data processing optimization

• Increased 25% efficiency of net-working and applying jobs by creating 7 Tableau dashboards to identify data-driven strategies

• Conducted 8 analytical projects for O2O industries, AI, SaaS companies such as Facebook, Amazon, Airbnb, defined customer roadmaps and prioritized metrics for customer experience to identify actionable strategies and improve high-level performance PROJECT EXPERIENCE

Data Science Hackathon New York, NY

Machine Learning for New York City Restaurants Recovery during COVID 19 May 2020 - Oct 2020

• Visualized 10K customers data using SQL and analyzed their consumption habits to seek business gaps to increase daily orders

• Increased restaurant revenue from $25k to $46k/month using sign test to validate the significance of positive revenue changes

• Improved prediction accuracy of restaurant monthly revenue from 90% to 97% by feature engineering, feature selection, and parameter tuning to anticipate the restaurant’s financial risk and to decide data-driven strategies using ARIMA model, Pandas TECHNIQUE SKILLS

• Languages: Python, SQL, R, SAS, JavaScript

• ML Toolkits: PyTorch, TensorFlow, Numpy, Pandas, forecast

• Data Analytics & Visualization: Google Analytics, Hadoop, Alteryx, Excel, Power BI, Tableau, PowerPoint, A/B Testing ADDITIONAL INFORMATION:

• Languages: English (bilingual), Mandarin (bilingual)

• Interests: Swimming, ice skating, guitar, piano, snooker, graphic design

Contact this candidate