Zihao Liu Resume
no image
Zihao Liu Resume

70 Hope Ave, Apt 513, Waltham, MA 02453
EDUCATION
Bentley University
M.S in Business Analytics
The Ohio State University
B.S in Logistic Management PROFESSIONAL EXPERIENCE
American Airline
Business Analyst Intern – Cargo Sales Team
Cell:------------ ------------ LinkedIn
Aug 2020 - May 2022
GPA:3.9
Aug 2016 - May 2020
GPA:3.66
May 2019 - Aug 2019
Zihao (Stanley) Liu
• Worked with multiple team stakeholders for data gathering, to build optimization model that helps cargo sales team identify $20M new sales opportunity at the same time reduce overbooking by 20%
• Created predictive model to generate most promising results for demand forecasting for cargo space; Identified the fact of last minutes cancelation orders; Improved forecast accuracy more than 30%
• Supported client services teams by using ad hoc method to identify our client’s business needs; Consulted client services team with optimal solution and work through plan end to end
ACADEMIC EXPERIENCE
Bentley University Aug 2020 - Present
Research Assistant
• Lead data collection and data visualization around state-specific COVID policy and work with Dr. Clifton to publish a paper regarding mitigation strategies and compliance in the Covid-19 fight
• Guide and supervise more than 20 graduate students on project orientation about job duties, weekly deliverable, which reduced 50% of the project period, accomplished a more systematic working schedule
The Ohio State University Aug 2018 - May 2019
Teaching Assistant
• Provided academic support in recitation tutorials, average score increased by 20% that contributed to a stronger passing rate than previous semester
• Developed a data-driven reporting that helped instructor to identify the trends and area need to improve, which boosted 10% overall exam score improvement
• Onboarded and coached over 10 new Assistants about job duties, expectations and timeline LEADERSHIP EXPERIENCE
Health Promotion Organization - The Ohio State University
President
RELEVANT PROJECTS
Prediction Model on Used Car Value
Advisor: Jiaying Weng, Bentley University
Nov 2018 - May 2020
Sep 2020 - Dec 2020
• Funded Health Promotion organization and enrolled 30+ members aiming to enhance student health awareness, which benefited more than 200 students from exercise
• Organized 2 suicide prevention events and weekly workshop, which helped over 20 students with mental illness
• Obtained raw data from b2b auction, performed explanatory data analysis and visualization
• Initiated multilinear regression models by using RStudio and found the best one which could predict the
price with accuracy rate of 80%
SKILLS
Analytical: Statistical modeling, including regression modeling & optimization modeling with large-scale data sets, & data visualization & storytelling
Technical: Proficient in R, Python, SQL, & Tableau