Ivan Yan Email & Phone Number

Hong Kong

Shanghai, China

• Finished half-year claim reports for 7 firms. Processed and analyzed employee welfare insurance data, including the use of Pivot table, Vlookup and other functions in Excel to create insurance type table, etc• Industry information collection, including the collation of human resources, insurance, government social security policies and other relevant data• Other supporting work, including daily work such as using the company's system to enter insurance policy information, communicating with customers by email, invoice reimbursement, etc

Shanghai, China

• Building and monitoring a dashboard to track the global stock market capital flows, and completing weekly and monthly reports.• Extracting key metrics information such as dividends, share capital, and shareholder situation for A and H shares using Bloomberg and Wind.• Utilizing Excel to organize and visualize historical data of key metrics for A and H shares, such as EPS and AH premium rate, and assisting analysts in preparing investment strategy reports.

Shanghai, China

• Collaborated with a team to optimize the accuracy of an image clustering and YOLO v7 object detection model, leading to a 25% improvement in image recognition precision.• Utilized XShell for data extraction from cloud servers and performed an in-depth review of model outcomes. Executed advanced Excel functions to visualize complex data, delivering actionable insights that fueled a targeted strategy for a 30% uplift in model performance.• Applied LabelMe for meticulous annotation of key points on face images, amplifying the quality of the training dataset and elevating the model's learning accuracy and prediction capabilities.• Implemented OpenCV, JSON, and OS in Python to automate the generation of bounding boxes based on pre-labeled key points, enhancing the model's efficiency in recognizing distinct facial features such as closed eyes.

Seattle, Washington, United States

Searched and collected data about donations for the elections of different counties and states.Scraped data from over 2k unstructured PDF files and output to a manipulatable CSV file.

New York, United States

• Exploratory Data Analysis (EDA) of more than 1.6k online job applicants with NumPy and Pandas• Assisted senior team members to develop NLP pipeline, using Bag-of-Words(BOW), TermFrequency-Document Inverse Frequency (TF-IDF) for feature extraction. •Trained Naive Bayes, Logistic Regression, and Random Forest model to predict 1.6k users’ industry using text classification and text clustering• Applied oversampling and downsampling methods to resolve the data imbalance issue and improved the accuracy of the model

Master Of Science - Ms, Business Analytics

Bachelor Of Arts - Ba, Economics, 3.72/4.00

Minor In Data Science

Shanghai World Foreign Language Academy, 42/45

Activities and Societies: President of the Soccer ClubHigher Level: Economics, Mathematics (Calculus), English B Standard Level.