Hui Wu Email & Phone Number

New York, NY, US

• Leveraged SQL and wrote 100+ queries to retrieve, analyze, interpret, and aggregate data from primary database
• Manipulated data and conducted exploratory analysis using Python (NumPy, Pandas) to optimize client experience
• Developed Dashboard with Tableau to perform data visualization and business analysis from the collected data
• Built linear regression models with Python (Scikit-Learn) for 50 states to predict next 20-year energy consumptions
• Analyzed the business strategies behind data, gave data-driven solutions to clients' needs and conducted final reports to provide insights aiming customer to understand the country-wide potential market

• Replicated three hedge funds by 21 ETFs to convert passive selection into active investment
• Conducted data cleaning to remove outliers and used linear regression model via Excel and SAS to analyze variables to select significant factors for difference hedge funds
• Created four factor replication models and used out of sample to test clone model results, analyzed model error, and conducted the model selection and optimization with the lowest Bayesian information criterion (BIC).
• Predicted hedge funds returns using the selected model, made various plots with data visualization tools, and presented results to internal stakeholders

Reviewed the overall plan and financial statement reports of Liton Hotel in 2019.Did a research to find competitors of Hotel and collected competitors' financial data from Yahoo Finance Wrote reports about comparison and competitive advantages and backwards of Liton.Delivered improved ways and presented to stakeholders about business insights and.

• Provided consulting services and technical help proximately 100 local students and summer camp exchange students
• Led 16 team members and volunteers to organize 6 activities to introduce Business College and major core courses

Master'S Degree, Financial Mathematics

Bachelor Of Business Administration, Major: Finance Minor: Economics