Experience

• 

  Shougang fund

  Mar 2021 - Jun 2021

  Trainee

  Excel Data AnalysisSlide Making

• 

  China-u.s. women's foundation

  Jan 2022 - Apr 2022

  Program intern

  Fundraising and budgeting Questionnaire Design for survey Social media data analysis

• 

  Rutgers university office of university and community partnerships

  Jun 2022 - Jul 2022

  Research assistant

  Data collection and analysis

• 

  Siemens digital industries software

  Aug 2022 - Jan 2023

  Data analytics intern

  Used VBA to construct Excel templates from the China National Bureau of statistics database to display renewable energy and environmental technology dataUsed Python to crawl official published data on renewable energy and environmental technologies in relevant industriesQueried and retrieved updated status of renewable energy data using Ms SQL ServerProgrammed automated office applet using Python which automatically checked the status of database updates and automatically sent emails to data analysis team members in case of errorsUsed Excel to connect to financial database for energy stock data, and used VBA to design automated dashboards Used Power Query to crawl the epidemic data published by the National Health Commission in different provinces and summarized the data based on different regions and used Power Map to create visualized reports Show less

• 

  Bmw brilliance automotive

  Feb 2023 - Jun 2023

  Data management intern

  VBA and HTML coding for Outlook mailsending automationTableau data visualizationPower BI dashboard creation and report makingUAT Test by TableauPython coding for automationPower Query for data collection and data cleansingVBA data wrangling

• 

  School of social policy & practice at the university of pennsylvania

  Aug 2023 - now

  Research assistant

  REDCap database administrationQuestionnare design and follow-up surveysAssistance in academic writing and presentationsPatient recruitment and screeningData Analysis of vaccine survey outcomes

• 

  University of pennsylvania perelman school of medicine

  Jan 2024 - Dec 2024

  Research assistant

  R for spatial analysisR for regression modelingPenn Biobank data mining