Management Consulting, Financial Services, Equity Analyst

LinkedIn: www.linkedin.com/in/kyleqigao

Kyle Gao

Tel: 917-***-**** Email: *****@*****.*******.*** 39-04 Clearview Expressway, Bayside, NY, 11361

OBJECTIVE

To obtain a challenging and exciting position in the field of predictive analytics, utilizing my technical and interpersonal skills. Further, to work in a dynamic and exciting team environment where I can collaborate innovative ideas and expand my knowledge with my peers.

EDUCATION

Hofstra University, Frank G. Zarb Business School Hempstead, NY, USA MBA Business Analytics Anticipated May 2020

Set up Amazon Web Service (AWS) for data mining, and big data analysis. Utilized R studio / MySQL on AWS for large datasets running neural networks, decision trees and other machine learning algorithms. Migrated data into SQL Server from ZTRAX (Zillow). Created a python crawler to collect and store web data (300MB) into MySQL. Separately, collected and analyzed data using advanced regression methods for click analysis. Related Courses: Data Mining for Business Analytics, Database Management Systems, Spreadsheet Modeling, Web analytics, etc.

Tianjin University of Finance and Economics Hexi, Tianjin, China B.A. Journalism in Financial News Track June 2016

B.S. International Finance

Project administrator in Grassroots Innovation and Research Association. Coordinated with local entrepreneurs and innovators. Assisted in raising capital by presenting to angel investors. Aided in registration of patents and set up corporate structure. Provided business consultation for entrepreneurs including advice on day-to-day operations, product optimization, marketing, accounting and using data in innovative ways to create a competitive advantage for company. Related courses: Banking, Accounting, Statistics, Marketing, Economics, Taxation, etc. TECHNICAL EXPERIENCE

Programming language: R, Python, C, PHP, HTML, Visual Basic, C# Database Management: SQL server, MySQL, Oracle Database, Amazon RDS, MS Access Statistical /Analysis: R, SPSS, SAS, RapidMiner, Google Analytics, Facebook Insights Operating Systems: Windows, MacOS, Linux (Ubuntu, RedHat), VMWare Visualization: Tableau

Backoffice: Excel, Word, PowerPoint, Prezi

Development Tools: Bash, Git, Visual Studio

Financial Tools: Bloomberg Terminal

PROFESSIONAL EXPERIENCE

McQuilling Partners, Inc. Garden City, NY, USA

Market Analyst Intern Oct 2019 – Mar 2020

Utilized multiples tools, such as Excel, SQL Server to provide analytical insights for executive management, used for decision making, including developing an advanced regression model for market forecasting adjusted by brokers’ experience.

• Monitored CPP (clean petroleum product) and DPP (dirty petroleum product) market. Analyzed freight rate, demurrage rate and time charter equivalent rates. Calculated marine transportation expense and triangulation expense in spreadsheet model.

• Built supply and demand models to analyze oil and tanker markets, including regression, DCF, WACC, PV, etc. Attributed to Tanker Market Outlook that was sold over one million dollars among global clients.

• Collected data and process daily through industry-leading proprietary databases. Optimized Excel Macro to collect data from global offices report. Optimized Macro’s algorithm to enhance efficiency and accuracy. Avoided any potential loss caused by misleading data.

• Cleaned AIS data and input data into logistics SQL Server database. Retrieved historical data and correct errors.

• Maintained company website. Updated latest news and information.

• Conducted ad-hoc research to support production of weekly reports and monthly reports. Generated and publish formal report to clients.

LinkedIn: www.linkedin.com/in/kyleqigao

Berko & Associates Commercial Real Estate Service New York City, NY, USA Real Estate Analyst Intern Jan 2019 -- Jun 2019

Participated in commercial real estate financing cycle. Undertook property evaluation, searching customers, CRS system maintenance, mezzanine loans investigation, and property securitization. Worked with property owners, asset management companies, lenders, and SPV.

• Researched, analyzed and underwrote to determine viability of quality candidates for Israeli Bond financing.

• Supported agents in all sales and development related activities such as canvassing New York City neighborhoods to determine potential listing and clients using programs such as Property Shark and Actovia.

• Implemented interactive sales and development research, solicitation and coordination of sales, marketing and business development presentations.

• Supported Capital Markets team in calculations of projected NOI, mortgage payments and loans.

• Revised company databases such as apto.com and implemented efficient processes to streamline information. China Business Journal Haidian, Beijing, China

Financial Planning Consultant Jan 2018 -- Jun 2018 Utilized API data for click analysis. Diagnosed advertisement marketing performance to optimize $5 million marketing budget. Modified financial planning for eight conglomerate clients week by week. Utilized multiple technological methods to find new subscribers and created one million RMB income.

• Collected advertisements’ performance data on differential media websites. Determined potential advertisers by analyzing data by classification and cluster algorithms.

• Delivered special offers to advertisers. Persuaded advertisers to purchase CBJ’s propaganda products, such as web advertising, blog advertising etc. Achieved over $1million income by special offers.

• Managed advertisers’ budget, maintained relationships and presented new suggestions for advertisers by latest click analysis.

• Traced hotspot news by analyzing clicks and reading. Raised preventive solutions to eliminate impact of negative news on client companies.

• Optimized news pushing system to individual clients. Identified clients’ personal preference by analyzing browsing history. Customized pushed news by subscribers’ preference. Cathay Life Insurance Co., Ltd Heping, Tianjin, China MIS Analyst Mar 2016 -- Dec 2017

Managed a five-person business development team. Maintained top four performance among fifteen sales teams in Tianjin. Maintained top 25% performance among 150 Chinese sales groups.

• Analyzed historical sale performance. Visualized performance in weekly and monthly report by charts and drafts.

• Ranked clients by purchasing behavior, such as purchasing expense, renewal and repost etc. Distinguished most valuable clients and customized insurance plans by preference.

• Segmented client clusters by feature. Grouped best sold insurance products and most practical sales pitch for each cluster. Created cheat-sheet brochures for sales representatives.

• Opened customer sources. Planned advertising budget. Evaluated margin effectiveness of the advertisements. Planned reasonable investment on advertisements.

• Collected latest insurance products from open market. Compared research between competitive products. ELM Asset Management Inc. UK Hexi, Tianjin, China

Forex Trader Intern May 2014 -- Oct 2015

Modified and tested the quantitative trading strategies in an eight-people trading group, which traded with ten million dollars customer fund and half million private capital. Maintain above 1.75% monthly profit in consecutive 8 months.

• Evaluated factors such as volatility, liquidity, developed trading strategy, managed currency positions using technical and fundamental analysis.

• Formulated and executed hedging strategies based on risk and market factors, expected profit to determine price and size of trades.

• Standardized trading method to generate quantitative trading system.

• Designed arbitrage model and test model by mock trading.

• Discussed large trades and special situations with corporate research department.

Contact this candidate