Zhiqi (Ellen) Chen Email & Phone Number

New York, NY, US

Marketing Analytics: synthetic control method in geotest analyses

New York City Metropolitan Area

• Graduate Teaching Assistant at the Statistics Department for Stat UN1201 - Calculus Based Intro to Statistics:
• Held weekly office hours and exam review sessions covering topics in Probability, Set Theory, Hypothesis Testing, Point Estimation, ANOVA and Linear Regression etc.

New York City Metropolitan Area

• Cooperated with the NYC Department of Citywide Administrative Services(DCAS) in the NYC Parks Budget Spending project:
• Extracted, cleaned and transformed the NYC Department of Parks and Recreation(DPR) Capital Budget data from NYC OpenData APIs
• Used MySQL to join the Capital Budget data with race, ethnicity, income demographics by Zip Code and Neighborhood Tabulation Areas(NTA)
• Mentored 4 undergraduate students to implement a R Shiny app with visualizations of the park budget spending and demographics in NYC
• Established clear communications with the staff at DCAS, understood the project goals and formalized the idea into a deliverable project
• Specified short and long term metrics that aligned the project efforts, and supervised the students in managing the end-to-end project

• Contributed towards upgrading the Life Science Supply and Demand Models with the Strategic Analytics & Intelligence Team:
• Used R to collect, clean and combine 15+ Life Science related datasets from different open data sources
• Performed linear regression in R to forecast each feature for the next five years, and back tested with historical data
• Applied the cross-validation process to select the influential features for the LS S&D Model
• Implemented Time Series ARIMA, Neural Network and Random Forest models to forecast the LS industry growth in terms of the number of companies by category

New York, New York, United States

• Assisted the work of the Comprehensive Planning and Performance Assessment System(CPAS Team) under the Peace Operation Department:
• Used MS SQL and MS Power BI to write queries and build dashboards, supported the development of the CPAS online training platform
• Created interactive data visualizations in Microsoft Excel and analyzed 15+ UN missions' back-end performance data
• Experimented different conditional formatting and filtering to improve the adaptability of the CPAS training system
• Constructed the outline for inputting the qualitative and quantitative indicators in the CPAS training system

Columbus, Ohio Area

Mathematics & Statistics Learning CenterUndergraduate Math Tutor in Calculus, Linear Algebra, and Probability

Master'S Degree, Statistics, 3.6/4.0

Activities and Societies: Student Representative of the MA in Statistics program

Bachelor Of Science - Bs, Mathematics, Major Gpa: 3.9/4.0

Activities and Societies: Certified Facilitator @ Student Leadership Advocates Minor in Statistics, Magna Cum Laude