0% found this document useful (0 votes)
70 views1 page

Sheldon Xie: Financial Engineering Profile

Er Xie is pursuing a Master of Science in Financial Engineering at Columbia University with a 3.9/4.0 GPA from Nanjing University in Financial Engineering. He has internship experience at GSA Capital Partners conducting quantitative research to develop alpha strategies, UBS conducting equity derivative strategy analysis, and Tianfeng Securities developing quantitative models. His projects include valuation of Philip Morris' acquisition of Kraft using DCF and statistical arbitrage strategies based on stock cointegration.

Uploaded by

Jonathan Shao
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
70 views1 page

Sheldon Xie: Financial Engineering Profile

Er Xie is pursuing a Master of Science in Financial Engineering at Columbia University with a 3.9/4.0 GPA from Nanjing University in Financial Engineering. He has internship experience at GSA Capital Partners conducting quantitative research to develop alpha strategies, UBS conducting equity derivative strategy analysis, and Tianfeng Securities developing quantitative models. His projects include valuation of Philip Morris' acquisition of Kraft using DCF and statistical arbitrage strategies based on stock cointegration.

Uploaded by

Jonathan Shao
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

ER XIE (SHELDON)

(917) 539-4995 | ex2117@[Link]


305 W 50th St, New York, NY, 10019
EDUCATION
Columbia University New York, NY
Master of Science in Financial Engineering Aug 2018 - Feb 2020
Nanjing University Nanjing, CN
Bachelor of Economics in Financial Engineering Aug 2014 - Jun 2018
⚫ Cumulative GPA: 91/100; Major GPA: 3.9/4.0 (WES verified)
⚫ Honors and Awards: Outstanding Student at Nanjing University (5%); People’s Scholarship in 2015, 2016, 2017 (5%);
Outstanding Leader of Student Association (0.5%)
PROFESSIONAL EXPERIENCE
GSA Capital Partners New York, US
Alpha Research Intern, Global Equity Investment Team May 2019 - Oct 2019
⚫ Conducted quantitative and fundamental alpha research to develop market-neutral long/short trading strategies utilizing
statistical and machine learning approaches on global equities such as ETF flow decomposition, short interest, and
competitive advantage on ROE ranking
⚫ Pre-processed and analyzed large vendor data sets and internal data to generate and improve signals through SQL Server
and Python (pandas, numpy, sklearn, pyodbc); including validating, cleaning, normalizing, and loading into database
⚫ Performed portfolio construction and performance attribution analysis; built auto correlation, positions crossover and
strategy statistics tools based on Python
UBS Business Solutions Shanghai, CN
Analyst Intern, Equity Derivative Strategy Team Nov 2017 - Apr 2018
⚫ Prepared reports on realized and implied volatility, skews, convexity, correlation and vol spreads of major stocks and
indices; developed tools and automated templates in Excel VBA for analysis and publications
⚫ Developed and backtested low frequency equity derivative strategies based on S&P500, STOXX50E, Nikkei and HSI
⚫ Developed automated warrant screener, KOSPI2 pricing, and NKY-JPY analysis templates based on Excel VBA and
Bloomberg; fixed old templates and speed bespoke requests for data calculation
Tianfeng Securities Shanghai, CN
Quantitative Research Intern, Research Department Jul 2017 - Sep 2017
⚫ Developed a position adjustment model for a trending market through MATLAB based on technical and fundamental
indicators (MA, P/E and MACD); achieved an annual return of 32.9% in back-testing over 2016 data of CSI300
⚫ Captured arbitrage opportunities of 50 ETF options based on Call-Put Parity theory using Excel VBA
⚫ Prepared equity derivative market reports on volume, basis, arbitrage opportunities and volatility cones
Ernst & Young Nanjing, CN
Audit Intern, Assurance Department Jan 2017 - Feb 2017
⚫ Initialized and prepared bank and business cash flow statements and confirmations of enterprises automatically through
Excel VBA; actively followed up with clients, and facilitated the auditing process
⚫ Checked data consistency between enterprise’s reports and audit requirements by alternative tests and interest rate tests

PROJECT EXPERIENCE
Philip Morris Companies’ Acquisition of Kraft in 1988 Apr 2019
⚫ DCF valuation under both with- and without-acquisition scenarios; quantify Kraft’s restructuring effects using DDM
and justify its validity
⚫ Analyzed market reactions on the deal and its effects and risks to the domestic food industry
Statistical Arbitrage Based on Cointegration of Stocks on A Share Market Dec 2016
⚫ Built an arbitrage strategy based on trading pair stocks picked by correlation and cointegration tests by Python
⚫ Adjusted position on arbitrage, stop-profit, stop-loss intervals generated by lognormal distribution
Empirical Analysis on Performance of Equity Fund Based on Carhart Four-Factor Model Nov 2016
⚫ Conducted Dickey-Fuller stationarity tests and correlation tests between variables by R Studio
⚫ Found that momentum factor was not significant while market factor, size factor and value factor were significant for
equity fund on A Share Market over 2006-2016 data
SKILLS & INTERESTS
⚫ Computer Skills: Python; SQL Server; Excel VBA; MATLAB; R
⚫ Interests: Table Tennis; Swimming; Gym
⚫ Certificates: Passed CFA level 1

Common questions

Powered by AI

ER Xie employed skills and technologies such as Python, SQL Server, Excel VBA, MATLAB, and R across his quant research projects. These tools facilitated data analysis, model building, and automation of complex calculations, significantly contributing to the development and testing of trading strategies, such as the statistical arbitrage strategy and the position adjustment model .

In his projects, ER Xie utilized computational statistical tests such as correlation and cointegration tests for the statistical arbitrage strategy, managed through Python, which allowed for precise pair stock trading. For equity fund performance, he used the Carhart Four-Factor Model and employed Dickey-Fuller stationarity tests and correlation tests using R, which provided significant insights into different factor impacts on performance .

ER Xie managed and improved signal generation by pre-processing and analyzing large vendor datasets and internal data, utilizing SQL Server and Python libraries like pandas, numpy, sklearn, and pyodbc. He focused on tasks such as validating, cleaning, normalizing, and loading data into databases, which were critical for refining and generating more reliable signals .

The position adjustment model developed by ER Xie was highly effective, achieving an annual return of 32.9% in back-testing using 2016 data of the CSI300. This outcome indicates strong performance and suggests that the model successfully leveraged technical and fundamental indicators such as Moving Average (MA), Price-to-Earnings (P/E) ratios, and Moving Average Convergence Divergence (MACD).

The empirical analysis conducted by ER Xie on equity fund performance using the Carhart Four-Factor Model found that the momentum factor was not significant. In contrast, the market, size, and value factors showed significance, indicating that these factors had a more substantial impact on equity fund performance on the A Share Market over the 2006-2016 period .

ER Xie's academic background in Financial Engineering from Columbia University and Nanjing University, coupled with his strong academic performance (Cumulative GPA: 91/100, Major GPA: 3.9/4.0), provided a solid foundation in both theoretical and practical aspects of finance. His honors and awards, such as the Outstanding Student and People's Scholarship, demonstrate excellence and leadership, fostering skills that are essential in his professional roles .

ER Xie's internships provided practical applications of theoretical knowledge gained through his financial engineering studies. His roles at GSA Capital Partners, UBS Business Solutions, Tianfeng Securities, and Ernst & Young involved hands-on experience with quantitative research, model development, data analysis, and automated tool creation. These experiences bridged the gap between academia and industry, enhancing his applied skills and understanding .

At UBS Business Solutions, ER Xie developed tools and automated templates in Excel VBA for tasks such as analyzing realized and implied volatility, skews, convexity, correlation, and volatility spreads. He also created automated warrant screeners, KOSPI2 pricing, and NKY-JPY analysis templates, in addition to improving old templates for data calculations .

Python played a central role in developing ER Xie's statistical arbitrage strategies by enabling the implementation of correlation and cointegration tests to identify trading pair stocks. It also facilitated the adjustment of positions and setting stop-profit and stop-loss intervals through the application of lognormal distribution models. These capabilities allowed for automated and sophisticated strategy development .

ER Xie utilized both quantitative and fundamental research methods to develop market-neutral long/short trading strategies. He employed statistical and machine learning approaches to analyze global equities, focusing on metrics like ETF flow decomposition, short interest, and competitive advantage based on ROE ranking .

You might also like