• Gathered and cleaned user engagement data in SQL, conducted EDA to define project scope, performed the statistical analysis, created data visualizations, and built ML model in Python to provide information and technical support to the academic community by collecting and processing data from Columbia University Library Information System• Manage library book system, handle literature data statistics, analysis, and updates using SQL and Python• Collaborated closely with sister schools to assist with resource allocation and handle online requests

• Performed effective performance tracking by planning and executing advertising programs, tracking advertising data, and generating placement reports to assess user acquisition metrics; delivered simplified and visualized analytical outputs• Conducted exploratory data analysis to understand patterns and trends in product popularity and the correlation between ads watching and orders over time using Python data visualization tools such as Matplotlib and Seaborn.• Conducted and analyzed 3+ A/B testing to evaluate operational efficiency improvement, specialize in user acquisition within the local market, with a deep understanding of infomercial placement mechanisms and optimization strategies

• Delivered customer insights, including monthly cohort performance, customer segmentation analyses, and ad tracking• Participated in marketing activities such as developing the loyalty program and new branding prototype testing• Monitored business volume forecast and planned according to areas of manpower, productivity, and other costs• Assisted with management of the operations of the front desk and bell staff to maintain the high service standards of the Hilton Hotel; coordinated front office activities and resolved issues such as guest complaints, reservations, room assignment