Tian Guo Email & Phone Number

Saint Petersburg, Fl, Us

Chicago, Il, Us

Chicago, Illinois, United States

Nyack, New York, United States

• Conducted in-depth analysis of 11 industries in the US financial market using GICS standard; presented key financial metrics to optimize the company's industry-specific valuation and ranking automation pipeline• Developed a comprehensive financial rating algorithm that combines multiple dimensions such as valuation, growth, profitability, price momentum and sentiment to provide quantitative scores for the targeted companies• Utilized Python for calculating daily returns and generating heatmaps for 6 companies from the DJIA and the Nasdaq 100 index; analyzed correlations with their benchmark indexes, and developed algorithms to identify stocks highly correlated with market trends and systemic risks

• Performed in-depth research and analysis for the FinTech industry and E-Commerce sector regarding its market trends, key performance, market volume, enterprise financial portfolios, user behavior etc.; presented findings to the product development teams which contributed to a 10% increase in user engagement and conversion rates• Utilized Python and Excel to conduct comprehensive analyses for the Online Payment market by analyzing the users buying habits, revealing valuable consumption characteristics, behavioral trends and industry competitors; produced initial draft of Due Diligence Report to the senior management team for business intelligence• Created interactive Tableau dashboards utilizing large datasets of consumer transactions in the past 5 years to visualize customer preferences & buying behavior, resulted a 15% rise in personalized product recommendations

• Performed initial review, evaluation and implementation for more than 60 packages and documentations for the new client onboarding process• Assisted the operation team to manage accounts and transactions for high profile clients; maintained client relationship (CRM) by regular phone calls, email follow-ups and business mails• Coordinated with the finance team and assisted conducting year-end financial statements and reports for the enterprise regarding Sales, Revenue, Gross Profit, EBITDA etc. which also utilized by the management team for business plan, business budgeting and forecasting process

Master Of Science - Ms, Finance Wealth And Asset Management, 3.39/4.00

Bachelor Of Business Administration - Bba, Major In Marketing And Minor In Finance, 3.41/4.00

Dean's List of Spring 2020, Fall 2020 and Fall 2021