NAOMI (XIAOXUAN) ZHANG

● New York, NY ● 929-***-**** ● ad20rm@r.postjobfree.com ● https://www.linkedin.com/in/xiaoxuan-naomi-zhang EDUCATION

COLUMBIA UNIVERSITY, New York, NY 12/2023

Master of Enterprise Risk Management Cumulative GPA: 3.7/4.0

• Courses: Credit Risk Management, Market RM, Financial RM, Liquidity RM, Model RM, Operational RM, Strategic RM UNIVERSITY OF CALIFORNIA, IRVINE, Irvine, CA 06/2022 Master of Professional Accountancy Cumulative GPA: 3.85/4.00

• Courses: Financial Report Analysis and Forecasting, SPSS Market Analysis, Python Financial Data Analysis, Tableau Data Analysis

• Recipient of: 2021 UCI Dean’s Recent Alumni Fellowship Merage Scholarship UCI Accounting Area Scholarship IMA’s CMA Scholarship STATE UNIVERSITY OF NEW YORK AT ALBANY, Albany, NY 06/2020 Bachelor of Science in Accounting Minor: Business Cumulative GPA: 3.45/4.00, Cum Laude (top 20%)

• Courses: Financial Accounting (I/II/III), MySQL, Excel in Accounting, Corporate Financial Strategy, Corporate Strategic Management

• Recipient of: Dean’s Honor List (Spring/Fall 2019, Spring/Fall 2018) Dr. Seth Spellman Achievement Award (Spring 2020/2018) PROFESSIONAL EXPERIENCE

McDonald’s Corporate Valuation Research Project of Yuval D. Bar-Or, Ph.D. (Baltimore, MD, hybrid) 09/2021-12/2021 Research Assistant

• Researched open-source data and analyzed market competitiveness of McDonald (MCD) using Porter's Five Forces Model and SWOT Model.

• Individually built financial statement analysis and automatic forecast models in Excel to predict MCD’s financial performance of 2022-2031.

• Estimated the MCD’s future market value based on the predicted financial statements using Dividend Discount Model and Free Cash Flow Model. Currently error rate between estimated and actual data is less than 10%.

• Created a journal article as the first author and corresponding author, publishing in Proceedings of the 2022 International Conference on Business and Policy Research.

Shanghai Sutuo Management Information Technology Co., Ltd. (Shanghai, China, hybrid) 06/2021-08/2021 Finance Intern Team Supervisor

• Supervised the intern team providing financial reporting services to 12 client companies. Produced a sum of 180 annual financial statements.

• Created Excel PivotTables visual tables to summarize financial performance trends of clients and reported to VP.

• Led 7 interns to obtain bank statements, verify customer transactions, and create bank journals and monthly reports.

• Trained interns on financial statements and to declare value-added tax and income tax to government. All interns could initially process financial flows and tax declarations within 2 days.

School of Computer Science and Technology, Shandong Jianzhu University, (Jinan, China) 05/2021-07/2021 Research Assistant Intern

• Research on new retail automatic ordering solutions, crawled and batched process commodity and industry sales data in Python and Excel, and analyzed data through dynamic optimization and Bayes' theorem.

• Designed and developed product ordering strategies and algorithms for machine learning with Python Pandas and scikit-learn database. The commodity dynamic pricing models and experimental plans achieved smart revenue management. PricewaterhouseCoopers Zhong Tian LLP. (PwC) (Jinan, China) 08/2020-11/2020 Audit Intern

• Joined in 4 on-site auditing or review projects. Reviewed audited financial statements over 50.

• Collected and sorted out the financial details, bank statements and invoices of the client companies, and verified the accuracy and source of clients’ financial records and statements by drawing vouchers and issuing confirmation letters to banks. Created PivotTable of costs in Excel.

• Researched deeply on industry information, calculated customer costs and revenues, and prepared financial drafts of relevant costs and revenues.

• Participated in the production of final AUP reports. Draft slides to communicate audit results to clients and internal stakeholders. RESEARCH PROJECTS AND LEADERSHIP ACTIVITIES

Risk Management Consulting Program for Tapestry, Inc., Capstone Project, New York, NY Team Leader 09/2023-12/2023

• Conducted Qualitative Risk Assessment on existing risk framework of Tapestry. Led 4 members to analyze risk factors and risk exposures of the incident. Identified critical risk factors using Risk Categorization and Definition Tool.

• Composed Impact-Likelihood Risk Matrix to visually display the threat level of critical risk factors and determine the priority of risks.

• Built Failure Modes and Effects Analysis and quantified potential impact of risk scenarios on Tapestry. Established risk factors shock assumption model on Excel, to estimate impact of company value shocked by risk scenarios in the next 5 years. VaR and Market Risk Analysis Project, New York, NY Market Risk Analyst 09/2023-12/2023

• Connected to multiple data sources, gathering and cleaning data mainly from U.S. Treasury Yield, to create useful databases.

• Build Daily Treasury Rates Model and Spread Shocked Yields Curves Model with historical method in Excel, to measure potential losses from equity risk and credit risk. Calculated the VaR of the U.S. bond credit market from 2021 to 2023 at a 95% confidence level.

• Established curves of sorted spread movement to quantify and illuminate risks. Communicated forecasting market risk trend via presentations. Experian Business Information Services Consulting Project, Irvine, CA Industry Analyst 01/2022-03/2022

• Provided product consulting services to the BIS Group of Experian U.S. headquarters. Collected and organized product market dynamics and market information, researched and analyzed the credit market of small and medium-sized enterprises in the United States.

• Analyzed product competitiveness in Porter's Five Forces, SWOT, and PESTLE Models.

• Created Qualtrics questionnaires and interviewed more than 40 target small and medium-sized enterprises through telephone interviews.

• Delivered research results and product development suggestions in presentations and slides during and at the end of the project. SKILLS

• Computer: Proficient in Microsoft Office (Excel, PowerPoint, Word, Access); Python (certification in China); Tableau; SQL; SPSS Statistics

• Language: Mandarin (native), Cantonese

• Expertise: CFA level 1 candidate; quantitative and qualitative risk analysis; fundamental analysis; big data analysis; financial statement analysis

• Activity: Researcher, Event Organizer in nonprofit Global Development Research Center of Columbia Global ESG Leadership Association

• Interest: 9 Chinese national musical instruments (national awards), Chinese painting (highest-level certification), surfing, ballet dancing, opera

Contact this candidate