Keyue Tong

Experience

• 

  EY

  Dec 2020 - Jan 2021

  Data Analyst Intern

  - Executed due diligence and anti-fraud data analytics tests for an education company by extracting/filtering/aggregating financial raw data in Excel to ensure the financial integrity of over 650 franchises and utilizing ITGC tools to validate data sources - Performed anomaly detection through writing 300+ SQL queries and visualizing financial data in various charts; Worked cross-functionally with the IT department to conduct 5+ ad-hoc root cause analyses to investigate the abnormal fluctuation for user activities- Designed and implemented 35+ anti-fraud tests for the online platform users’ activities data(new users demographics, DAU/MAU ratio, retention rate of returning users) as well as operating data to ensure the data authenticity and fair IPO valuation- Created a financial ratios calculations pipeline via VBA in Excel that could compute ratios such as profitability, turnover, liquidity, and solvency from raw data to support financial statements validation and evaluation by the auditing department Show less

• 

  Morris Habitat for Humanity

  Sept 2021 - Dec 2021

  Business Analyst

  Rutgers Consulting Analyst Program- Collected data from the US census website by Python, identified and analyzed the area with the most housing needs by performing geospatial visualization and generating radar/line/pie/bar charts for demographic characteristics(age, race, income, etc) of 68 towns in Morris county, supporting comparative evaluation of different towns- Conducted exploratory data analysis for the population in areas with urgent needs to facilitate the partnership between local NPOs and communities Show less

• 

  Fullgoal Fund Management Co., Ltd.

  Apr 2023 - Jul 2023

  Data Science Intern at Metrics Development Team

  - Streamlined and optimized 10+ volatility metrics automatic generation by creating pipelines via Python and SQL that execute data retrieval, data cleaning, data manipulation, and relational mapping from various sources in the database, and tuning parameters- Compiled the 10+ metrics generation instruction documents on Confluence, detailing the required user input, metrics formula breakdown, input units conversion, etc, reporting the logic and computation to managers and team members- Conducted funds performance & attribution analysis through statistical models Barra Risk Model and Brinson Fachler Model to support monthly portfolio manager performance evaluation; Collaborated with cross-functional teams (risk management) to determine the factors used for those models- Monitored and visualized 10+ metrics fluctuation on a daily & weekly basis and contributed to monthly metrics report generation by creating interactive dashboards in Tableau that show metrics’ trends over time, presenting the results to the senior management Show less