Experience

ProAct - PBM

• United States
• Hospitals and Health Care
• 1 - 100 Employee

• Business Intelligence Analyst

  • Jul 2017 - Present



Qingjiang Source Beverage Ltd. Company

• Yidu, Hubei Province,China

• Data Management Specialist (remote intern)

  • Mar 2017 - May 2017

  Collect data from the company’s ERP system and design dimensional models in relational database accordingly Implement the star schema by writing SQL and manage ETL process to extract, transform and load data Visualize the processed data in Tableau to answer business questions and support intelligence decision Collect data from the company’s ERP system and design dimensional models in relational database accordingly Implement the star schema by writing SQL and manage ETL process to extract, transform and load data Visualize the processed data in Tableau to answer business questions and support intelligence decision



Syracuse University

• United States
• Higher Education
• 700 & Above Employee

• Faculty Assistant

  • Sep 2016 - May 2017

  Set up a multi-user server for Jupyter Notebooks to save students efforts of installing Jupyter on their own computerTested the JupyterHub server at each development stage to identify bugs and guarantee operationCollaborated with professor to create optimum solutions for labs and homework in R

• Research Assistant

  • Sep 2015 - Nov 2016

  Directed team to compile statistical analysis on 10,000 collected Twitter posts to find potential user behavior patternsBuilt and tested a regression model to predict user interactions (number of favorites, comments, and retweets) in SASCreated charts through ggplot and shiny to explore patterns and trends



iBranch

• Syracuse, New York Area

• Vice President

  • Jun 2016 - May 2017

  Planned and organized some speech sessions by faculty staff and Professionals, and workshop activities Held cultural activities to publicize Chinese culture and strengthen the cohesion of Chinese students group Planned and organized some speech sessions by faculty staff and Professionals, and workshop activities Held cultural activities to publicize Chinese culture and strengthen the cohesion of Chinese students group