Financial Analysis, Data Analysis, SQL, R, Excel

ZIYUN TIAN

626-***-**** *******@*******.*** www.linkedin.com/in/ziyun-tian-a4860013a

SUMMMARY

• 2 years of experience in Data Mining, Data Analysis, Data Validation, Predictive Modeling and Data Visualization

• Data modelling skilled in interpreting and analyzing data. Proficiency in all aspects of advanced Excel

• Experienced in preparing detailed documents and reporting while managing complex internal and external data analysis responsibilities

EDUCATION

FORDHAM UNIVERSITY, GABELLI SCHOOL OF BUSINESS New York, NY MS, Applied Statistics and Decision Making 2018-2019 Relevant courses: Financial Modeling, Data Mining for Business, Database Management, Data Visualization UNIVERSITY OF CALIFORNIA, SANTA BARBARA Santa Barbara, CA BS, Financial Mathematics and Statistics 2014-2018 PROFESSIONAL EXPERIENCE

ALLIED MILLENNIAL PARTNERS, LLC, New York Financial Analyst Intern, 5/2019-7/2019

• Prepared marketing materials, collected data and news from Yahoo Finance, Wall Street Journal and Finviz, analyzed and visualized data by Excel

• Completed DCF model, evaluated target companies’ value, wrote research reports and presented to the senior financial analyst to recommend actions of investment

• Implemented Regression, Artificial Neutral Networks (ANN) and Decision Tree models in SPSS Modeler to find out the most effective technical indicator and selected the ANN as the best model INDUSTRIAL SECURITIES CO. LTD, Beijing Financial Analyst Intern, 10/2017-12/2017

• Assisted department chief with various tasks including monitoring market performance, performing daily risk analysis across multiple funds, and developing client strategies

• Published detailed portfolio reports on market performance and outlook as well as stock justifications for companies with the fund for clients on a weekly basis

• Developed close working relationships with clients and assisted in providing relevant marketing & research materials BANK OF AMERICA, Beijing

Intern, Service, Fulfillment and Operations Department Administrative Assistant Intern, 07/2016-09/2016

• Coordinated with cross functional teams globally to collect and review clients' data for Cash Management products

• Participated in upgrading BOA Anti-Money Laundry system responsible for testing and monitoring the security

• Managed relevant reports on balance of payments statistics using analytical tools

• Arranged and organized the validation process of client receipts on a daily basis PROJECTS EXPERIENCE

Portfolio Optimization Winter 2018

• Optimized a portfolio composed of two ETFs: US equity follows S&P 500 and fixed income market tracks long-term US Treasury bonds using R studio

• Be responsible to build and maintain well-managed data solutions and delivered capabilities to tackle business problems

• Gathered all the data that is required from multiple data sources and created datasets that will be used in analysis

• Computed returns for both assets, created visualization to analyze volatility, implemented techniques to determine portfolio weights and gauged quality of portfolio returns via Sharpe ratio to evaluate projected portfolio performance Literacy Rate Across Countries Fall 2018

• Developed multiple linear regression models using R and obtained optimized model to figure out influence factors

• Processed data merging, changing and cleaning, calculated summary statistics, created visualization to identify features in data set

• Implemented statistical analysis to check regression assumptions and conducted hypothesis test

• Interpreted, translated and communicated data into meaningful informatics TECHNICAL SKILLS

• Technical: Excel, Word, Power Point, R, SAS, SPSS Modeler, SQL, CFA Level I

• Analytical: Statistics Analysis, Financial Analysis, Data Analysis, Regression, Simulation, Classification

Contact this candidate