Financial Analyst Data

XIAOQI ZHANG

******@********.***

**** * ******* ******, *** 308, San Mateo, CA 94403 • 614-***-**** EDUCATION

Columbia University, M.S. in Actuarial Science; GPA: 4.03, New York, NY Dec 2016 The Ohio State University, B.S. in Finance; Minor in Statistics; GPA: 3.91, Columbus, Ohio May 2015 ACTUARIAL EXAMS (SOA/CAS) AND OTHER CREDENTIALS

Exams Passed: P/1 (9/10); FM/2 (8/10)

PROFESSIONAL EXPERIENCE

XCG Design Corp - Data Analyst; San Francisco, United States Dec 2017 – Present

Organized and prepared environmental analytics data, reports and statistical models

Formulated and Analyzed the data to assist with design planning and decision making

Effectively communicated findings to a non-technical audience

Developed monthly financial reporting, including variance analysis Haver Analytics – Data Analyst Internship; New York, United States Jun 2017 – Aug 2017

Added new macroeconomic data series to the database based on the request of clients

Tracked down data source files and developed update procedures

Set up quality assurance checks for existing data series

Verified data outliers on economic data and researched on reasons for valid breaks in data Bank of China – Summer Internship; Qingdao, China Jul 2015 – Aug 2015

Effectively assisted manager of International Settlement Department to handle daily administration work

Interpreted incoming invoices from foreign banks and notified appropriate clients

Coordinated with clients to conduct forward exchange contract transactions Huajie Turbine, Inc. – Business Analyst Internship; Qingdao, China May 2014 – Jun 2014

Analyzed cost and benefit between different database systems and made recommendation

Identified and quantified potential cost and calculated price of the product for the bidding process

Supervised and reviewed bank transactions to ensure smooth implementation of the contract RELEVANT EXPERIENCE

Quantitative Risk Management Project Summer 2016

Established a well-diversified stock portfolio reflecting key investment strategies

Constructed volatility budget and constraint monitor the portfolio and adjust risk exposure

Analyzed portfolio performance every month using several key statistics for a three-year period

Reported overall return against benchmarks and interpreted the result STAT 5740: Data Analysis Project Fall 2014

Imported data file into R for analysis and mined for appropriate data

Developed graphs and chart to identify key characteristics of the data

Constructed regression model to capture relationships among key factors

Summarized and interpreted result into a report in PDF format HONORS

Dean’s List Fall 2011-Spring 2015

summa cum laude Fall 2011-Spring 2015

SKILLS AND INTERESTS

Computer Skills: Excel, Access, C++, SAS, R, SQL, Python Interests: Zither, Travel

Contact this candidate