Jin Ziqi

202-***-**** adwe2u@r.postjobfree.com www.linkedin.com/in/ziqi-jin-jhu Washington DC

EDUCATION

Johns Hopkins University Washington DC

Master of Science in econometrics and quantitative economics GPA 4.0/4.0 ODL students assistant Sept.2022 – Jan.2024 Core Coursework: Statistics, econometrics, database management, programming and data management, machine learning, etc Donghua University Shanghai, China

Dual degree in Bachelor of Economics in Finance and Law in Law GPA 3.85/4.0 Sept. 2018 – Jun. 2022 PROFESSIONAL EXPERIENCE

Bosch Investment Ltd. Shanghai, China

Business Analyst Intern May 2022 - Sept. 2022

• Used Mysql to select data to e-commerce market database from central database, consolidate from multiple channels, improved data processing efficiency by 30%

• Built Tableau dashboard to visualize analytical results, outlined the specific improvements for e-commerce products, and provided business recommendations and data-driven solutions to team leaders

• Established country evaluation model and conducted in-depth global market research by collecting the latest E-commerce news and industrial data, supported D2U Strategy and roadmap decisions with a focus on innovation and maximum profits Jifeng Ventures Shanghai, China

Investment Analysis Intern Oct. 2021 – Mar. 2022

• Used Python to clean, transform, and normalize 10K+ pharmaceutical industry data and analyzed the status trends, performed descriptive analysis to summarize the distribution of demographic data

• Established Comparable and DCF models to estimate the market value, Analyzed the financing frequencies of targeted companies to propose investment suggestions for the stakeholders with product managers based on data-driven results Guotai Junan Future Shanghai, China

Asset Management Intern Jul. 2021 – Sept. 2021

• Collected and processed historical financial data and relevant news of fallout stocks, analyzed daily fluctuation of stock price, optimized price prediction model with seasonality factors, and improved model accuracy by 20%

• Utilized iFinD and Wind to gather information, implemented the fundamental analysis for companies of interest to capture the buy/sell signal and comparative analysis by calculating financial key ratios such as P/E ratios CPIGTJA-Allianz Funds Management Co., Ltd. Shanghai, China Marketing Intelligent Intern Mar. 2021 – Apr. 2021

• Used python connected to Wind and Galaxy Securities API ports, found up-to-date data of related funds and indices.

• Optimized the Mysql database for each managed funds by the company, making it convenient for the production manager to know the distribution of funds under management and the average return in the last two years

• Used MatplotLib to visualize the daily financing and financing transactions and updated report charts automatically. ACADEMIC PROJECTS

New York Airbnb House Price Analysis Jan. 2022 – Mar. 2022

• Transformed and normalized 4,000+ rows of data and implemented regression model from scratch

• Extracted 20 features from raw housing data containing different types, such as categorical, numerical and time-series data, performed feature selection through exploratory data analysis

• Built linear regression and Random Forest model and evaluated the model via 10-fold cross-validation Shanghai Covid Data Analysis May 2020 – Jun. 2020

• Performed research in the early warning of COVID-19 outbreak in China through Internet search data, established a search fever monitoring module and a warning module to issue early warnings 7-10 days in advance

• Get Baidu search index of keywords (symptoms of pneumonia, fever, and heart disease), used Pandas to conduct lagged correlation analysis by processing 20K+ raw data, used MatplotLib to visualize the relationship diagram SKILLS

Technical Skills: Python, R, DBMS (Mysql, Oracle), Advanced Excel,matlab,SAS, Financial Valuation Models Machine Learning & Statistics: Regression, Hypothesis Testing, Time Series, Probability, Clustering, Classification

Contact this candidate