Hi, This is Qian Qiao, the new grad of University of Miami. My background is Business Analytics and Public Administration. Actively seeking Business Analysis Opportunities.
-
Experience
Carnival Cruise Line Miami, FL, USA
Data Analyst Intern Feb – May 2020
Analyzed and cleaned dataset of 370k+ observations, 51 variables with R and SQL. Manipulated raw data by eliminating null value and outliers to better fit in the models. Joined and combined multiple date sets in MySQL.
Developed and optimized machine learning and regression models on 74k+ data to identify key variables driving the greatest revenues.
Provided marketing strategies by visualizing 23 data features and model outcomes with Tableau and R, and created 5 customized offers to the respective segments.
Designed weekly report based on model and plot findings in the PowerPoint format.
New Ventures, PwC Shanghai Acceleration Center Co., Ltd Shanghai, China
Business Analyst Intern Jun – Jul 2019
Optimized working processes within IT Consulting by translating business goals to analytical goals for setting strategic targets, and establishing division of tasks management with tech lead.
Improved communication and official meetings among US PwC design team, China out-sourced IT team and Q&A team. Used Jira and Confluence to track tickets to summarize problems and progress in real time.
Conducted comprehensive research on tech products such as Website and App on generating product requirement, determining specifications, production timetables, pricing and time-integrated plans.
Report to clients using Tableau. Assisted with initiating quality management projects for data integrity and to maintain business requirements.
-
Projects
Time Series Modeling: Detected the trend of New York City housing prices by applying autocorrelation analysis and predicted future performance with ARIMA model.
Machine Learning: Analyzed credit profiles by selecting important variables using stepwise selection. Developed a grading system that assesses risk of loan applicants by building machine learning models (decision tree, elastic network, random forest, logistic regression and gradient boosting) .
Applied Regression Analysis: Identified customer groups who are unsubscribing to telecommunication services by building generalized linear model and survival analysis; proposed a retention plan based on statistical testing results.
Data Visualization: Conducted the trend of Las Vegas’s hotel tax revenue growth over the past 20 years with Tableau; Forecasted future hotel industry development and tourist growth trend.