XINYUE ZHANG

http://www.linkedin.com/in/katezxy

585-***-**** adnjcf@r.postjobfree.com

EDUCATION

Simon Business School, University of Rochester Rochester, NY Master of Science in Business Analytics (STEM Program) 2020 - Present

• GPA 3.76/4.0

• Leadership: GYZ Consulting Group Leader for Blackalicious LLC, Pricing Case Competition Leader -Price f(x)

• Relevant Coursework: ETL Method SQL Data Warehouse, Optimization Method, Machine Learning, Advanced Probability

(modeling and simulation), Analytics in Operation Management, Statistics, Pricing Analysis College of Business, Missouri State University Springfield, MO Bachelor of Science in Accounting & Minor in Business Analytics 2016 - 2020

• GPA 3.95/4.0 Dean’s List

• Barry Lewis Memorial Scholarship, China National Scholarship.

• Relevant Coursework: Shangri-La Hotel Database Design and Analytics, Startup Carbon Fiber Bicycle designed Project, Vehicle Mileage Substantiation Construction Analysis, Global Warming Hadoop & MapReduce Project.

• Leadership: Freshman Business Case Competition Member – 3rd. EXPERIENCE

Blackalicious LLC Rochester, NY

Associate Consultant Jan 2021 - April 2021

• integrate internal and external data to provide 10+ marketing decision suggestions and marketing effect analysis suggestions for a client through conducting consumer behavior research, competition analysis, and explore marketing opportunities.

• Tracked industry development dynamics and trends over past 15 years, and actively maintained mining data information channels. and independently complete 3 core digital industries’ data research collection and data model applications NDY Auto Insurance Firm Henan, China

Department Minister Assistant, Financial Department June 2018 - September 2018

• Improved overall profitability by 7% while reducing 3% of selling costs through efficiently allocating resources with accurate forecast results; Created a prediction model using Python and effectively forecasted quarterly sales with 75% accuracy.

• Analyzed and evaluated sales agents’ performance data to develop comprehensive benefits and compensation mechanisms by leveraging Tableau. Visualized sales data on Tableau to inform manager of sales in upcoming quarter on Tableau. Sinopec Henan, China

Sub-Accountant Intern, Financial Department June 2017 - September 2017

• Collected and collated daily transaction data utilizing SQL and Pivot Table while publishing reports to highlight human error and coordinating with departments to integrate income statements and cash flows statements.

• Improved working efficiency by 20% and helped companies save time and labor costs through using VLOOKUP and Data Analysis to create spreadsheets and Pivot Table collecting data and calculating sales automatically. PROJECT

Predictive Model and DSS Evaluation of HELOC Application Risk Simon Business Project – Spring 2021

• Built a predictive model to evaluate the risk level of HELOC. Selected the optimal model was out of eight machine learning methods( CART, Logistic Regression, KNN, Random Forest, etc.) and utilized cross-validation and grid search.

• Designed an interactive interface on Spyder that successfully helped 10+ clients evaluate and predict the risk of Home Equity Line of Credit applications.

Data Warehouse and Machine Learning Skills in ExcelInc Simon Business Project – Fall 2020

• Improved products and fulfilled customer needs by implementing features experiment and 5000+ surveys and created an exhaustive data warehouse (supporting ETL) to simulate profits & business behaviors through A/B testing and Chi-squared.

• Derived actionable business forecasting products using R to perform geolocation, Priori segmentation, and conjoint analysis while building; federated engine and server to import large global datasets to a local database. ADDITIONAL INFORMATION

• Technical Skills: SQL, SaaS, Python, R, Statistics, Google Cloud Platform, Tableau, Statistics, Advanced Excel, Pivot Power

• Languages: English (fluent), Chinese (native).

Contact this candidate