Xiangyi (Adrian) Wang

adl9yq@r.postjobfree.com 413-***-**** Amherst, MA www.linkedin.com/in/xiangyiw

EDUCATION

Boston University Boston, MA

Master of Science in Applied Business Analytics (STEM) Expected Sep 2021

• Course: Data Analytics, Marketing Analytics, Enterprise Risk Analytics, Web Analytics, Operations Management University of Massachusetts Amherst Amherst, MA

Bachelor of Science in Resource Economics (STEM) Sep 2016 – Dec 2019

• Course: Intermediate Statistics for Business; Quantitative Methods in Applied Economics; Cost Benefit Analysis SKILLS

• Data Analytics: SQL, Python, R, Excel, Google Analytics, MATLABS, SAS

• Data Visualization: Tableau, Power BI, Python, R WORK EXPERIENCE

Boston University Boston, MA

Research Assistant SQL, Python, Excel, Dashboard Jan 2021 - May 2021

• Implemented Excel and SQL to scrap and analyze data in nationwide analyst job market based on Labor Insight

• Created KPI dashboard for Dean to evaluate positions with good prospects and required candidate’s skills Beijing Broad & Bright Law Firm Beijing, China

Project Team Assistant Excel, PowerPoint, Communication Jun 2018 - Aug 2018

• Communicated with cooperative law firms in Malaysia and Singapore in due diligence

• Researched and proofread Due Diligence of Southern-Ukrainian Mykolaiv 300 MW Wind Power Plant Project

• Analyzed and generated PowerPoint report about potential risks in Shenergy Group & Genting Group Oil and Gas Kasuri Block Project for client

Shanxi Guoke Energy Saving Co., LTD Shanxi, China

Business Analyst Assistant SQL, Python, Machine Learning, Dashboard, Market Research Jun 2017 - Aug 2017

• Utilized Python & SQL to clean and scrap data for Renovation Project of Jinneng Changzhi Thermal Powerplant

• Set KPI and applied Python (pandas) to build dashboard of cost saving implementation status for the management

• Applied Machine Learning in Python to Predictive feasible options for renovation (focus on pipeline)

• Generate report for the management and collaborating with marketing team on tender contract, reduced cost by 14% PROJECTS

New York City Real Estate Business Running R, Power BI, Time Series, Regression Sep 2020 – Dec 2020

• Utilized Power BI to visualize market in Queens Village (commission rate, sale scale, market penetration, etc.)

• Developed KPIs to cluster the sales and ran t-test in 95% confidence level to compare with nearby neighborhoods

• Implemented Time Series Model and Regression Model in R to predict market’s growth in next 8 quarters

• Applied Optimization Model to maximize the NPV of business in next 8 quarters and generate recommendation Lower Manhattan New BrewPub Investment R, Excel, Break-even, SWOT Sep 2020 – Dec 2020

• Performed Break-even Analysis in financial management and reduced the break-even point by 5%

• Implemented SWOT Analysis in marketing and innovation management to establish and promote brand value.

• Evaluated and summarized result and formulated decision strategy for business owner Renewable Energy’s Effect on Residential CO2 Emission in New England R, Regression Sep 2019 – Dec 2019

• Built regression model of emissions in R based on EIA & EPA data, included total generation of renewable energy, Regional Greenhouse Gas Initiative (RGGI) as binary variable and number of powerplant closed

• Analyzed emission reduction performance of each state under 0.001, 0.01 and 0.05 significance level

• Generated a report of current emission reduction status include ambiguous impact of RGGI

Contact this candidate