Mingkun Xuan

About Mingkun Xuan

Talented Financial Analyst with exceptional background utilizing data from diverse…

Experience

1. Financial Analyst

   Garnick Llc

   Oct 2016 — Present · San Mateo, CA, US

   Working directly under the CFO of Tastes on the Fly; a $77 million restaurant group, which owns and manages 25 airport restaurants nationwide. • Prepared monthly airport restaurant P&L reports for executive team and management group• Managed and monitored company cash flow of approximately $6 million, including releasing checks to vendors, banks, and other parties• Performed development budgeting for new restaurants and preparing financial pro forma for new airport restaurant proposals. Evaluated the previous restaurants\' financial forecast by comparing projection vs actuals and investigated budget variance• Built and maintained sophisticated Excel models for forecasting and financial reporting• Coordinated and managed data requests with management group and restaurant managers. Performing ad-hoc analysis and data manipulation. Ensure availability of data for timeliness of financial analysis• Researched and analyzed seasonal trends, adjusted financial projections for restaurants and provided advice for management group• Participated in month-end closing by performing bank account and accounts payable reconciliations

Education

• University of Minnesota

  Bachelor's degree, Economics

  2009 — 2014

• University of San Francisco

  Master of Science (MS), Financial Analysis

  2015 — 2016

Skills

• Customer Service
• Microsoft Word
• Erp
• Matlab
• Mas 90
• Teamwork
• Corporate Fp&a
• Stata
• Financial Accounting
• Financial Services
• Forecasting
• Spreadsheets
• Financial Analysis
• Financial Planning
• Account Reconciliation
• Bloomberg Terminal
• Microsoft Excel
• Powerpoint
• Financial Reporting
• Corporate Finance
• Social Media
• Skilled Multi-Tasker
• Financial Modeling
• Data Analysis
• Microsoft Office
• Sales
• Budgeting
• Public Speaking
• Ms Excel Pivot Tables