Summary
Overview
Work History
Education
Skills
Tel
Personal Information
Languages
Timeline
Generic

Zeyan JIN

Shoreline,WA

Summary

Experienced Program Representative adept at providing information and guiding customers through the system. Highly self-motivated with strong problem-solving, time management, and critical thinking abilities.

Overview

5
5
years of professional experience

Work History

Program Representatives of Applied Analytics

Columbia University, Student Union
New York, NY
01.2023 - 05.2024
  • Optimized SQL queries for better performance by creating necessary indexes on tables or by rewriting the query itself.
  • Managed user access rights across multiple databases and provided appropriate privileges according to user roles within the organization.
  • Performed regular backups of all critical data files and maintained detailed documentation about all changes made to the database environment.
  • Assisted developers with complex query tuning and schema refinement for better application performance.
  • Use the Shiny app for the database to provide the user with a greater UX.

Music Database Management Part-time

NetEase Cloud
02.2019 - 05.2022
  • Collaborated with the Music Data Team to maintain and enhance the expansive music database, ensuring accuracy and efficiency
  • Assisted in the integration of new music releases into the system, ensuring metadata consistency and track quality
  • Utilized tools and software to detect and rectify duplicate entries, missing data, and mislabeled tracks, enhancing the user experience
  • Participated in the development of search algorithms, improving track retrieval times and accuracy for end-users
  • Engaged in weekly brainstorming sessions, contributing ideas for innovative features like mood-based playlists and artist discovery algorithms
  • Achievement: Successfully invited to become a Music Partner, securing a spot among the limited 150 national slots.

PTA Assistant of Data Scientist

Google
07.2021 - 08.2021
  • Followed the mentor to experience the strong power of machine learning and AI in natural language processing. Was responsible for collecting data using the skills of Pegasus, Sentencepiece, TensorFlow, and Tokenization. Completed a business analysis report. Improved my analytical skills and stimulated my curiosity about machine learning and AI.
  • Organized and maintained filing systems for documents and records.

Education

M.S. in Applied Analytics -

Columbia University
NY
05.2024

Bachelor of Arts in Geography: Data Science -

University of Washington
Seattle
07.2022

Skills

  • R
  • Python
  • Intermediate proficiency with graphic design tools
  • Adobe Creative Suite
  • Digital prototyping platforms
  • SQL
  • NoSQL
  • PostgreSQL
  • MongoDB
  • HTML
  • CSS
  • JavaScript
  • Windows Word
  • Algorithmic problem solving
  • Numerical methods
  • Computational modeling
  • Calculus
  • Linear algebra
  • Differential equations
  • Statistical analysis
  • Hypothesis testing
  • Regression modeling
  • Data visualization techniques
  • Tableau
  • Power BI
  • Data preprocessing
  • Pandas
  • Excellent Communication
  • Machine learning algorithms
  • Scikit-learn
  • TensorFlow
  • Comprehensive visualizations
  • Matplotlib
  • Seaborn
  • Critical Thinking
  • Communication
  • Team Leadership
  • Creative Thinking
  • Organizational Skills
  • Self Motivation

Tel

+1 206-823-9292

Personal Information

  • Date of Birth: 06/18/1999
  • Gender: Male

Languages

English
Professional
Chinese (Mandarin)
Native/ Bilingual

Timeline

Program Representatives of Applied Analytics

Columbia University, Student Union
01.2023 - 05.2024

PTA Assistant of Data Scientist

Google
07.2021 - 08.2021

Music Database Management Part-time

NetEase Cloud
02.2019 - 05.2022

M.S. in Applied Analytics -

Columbia University

Bachelor of Arts in Geography: Data Science -

University of Washington

Similar Profiles

CREATE PROFILE
Zeyan JIN