Executive Assistant Data Analyst

JINGYAN ZHANG

NY *****, USA *******.********@*****.*** +1-831-***-****

PROFESSIONAL EXPERIENCE

ST.GILES HOTELS, LLC – New York, NY May 2017 – Present Financial Data Analyst / Staff Accountant

Using advanced Excel skill (including Pivot Table; Advanced Formulas – vlookup, hlookup, sumif(s), countif(s), index, match, find, iferror, ifna, data validation, statistical functions and etc.; Conditional Formatting; and Advanced Table & Chart), SQL and Python on data compilation, modeling, analysis and reporting.

• Build and maintain complex financial reports and quantitative analysis for operation activities, P&L, budgeting, forecasting, variance explanation, cash flow, payroll & benefits, activity schedules for balance sheet account, fixed assets, taxes collection & payable, and travel agent commissions.

• Prepare month-end and year-end closing journal entries including prepaid, accrual, payroll & benefits by department and position, depreciation, fixed asset schedule, and etc.

• Perform balance sheet reconciliations, maintain general ledger accounts and resolve reconciling items timely.

• Conduct and allocate weekly payroll in a Union and Non-Union setting via ADP by gathering and analyzing information submitted by department directors using Time Saver.

• Manage Account Payable functions - ensure adequate supporting documentation including purchase/service order approval, work paper, delivery slips, and other backup files; record expenses and invoices in accounting system to the correct general ledger account; process check/bank/credit card payment to ensure that all invoices and reimbursements are paid accurately in accordance with finance policies and procedures.

• Assist with annual audit and quarterly review process with external auditors by preparing schedules and providing supporting documentation.

• Assist in overall day-to-day operations including cash movement and finance related issues by effectively interacting with vendors and company employees.

CP GLOBAL CAPITAL – New York, NY Jul 2016 – Apr 2017 Investment Analyst & Executive Assistant

Responsible for managing all US investment projects, investor activities, business meetings and events for CP Group.

• Conducted due diligence on entertainment and real estate investment projects, gave recommendations to senior managers, and prepared related deal documents.

• Established and maintain relationships with clients and investors while generating new opportunities.

• Provided executive support to the c-level executives and seniors managers on various business events in US. CHARDAN CAPITAL MARKETS – New York, NY Dec 2014 – Jun 2015 Investment Banking Intern

Worked with 3 teams on 10+ cross border (US, China and UK) M&A transactions with deal value ranging from $30m to

$200m in Healthcare, Construction, Oil & Gas industries.

• Conducted in-depth researches on target industry and companies by analyzing 10-K, 10-Q, 8-K SEC filings and other financial data from Capital IQ and Bloomberg; evaluated investor returns.

• Prepared transaction documents including non-disclosure agreement, management presentation, letter of intent, investor teasers and pitch books; and drafted models in accordance with the investment objectives and parameters defined by clients including DCF, LBO and Comparable Valuation model. EDUCATION

New York University – New York, NY

• Master of Science in Financial Engineering (GPA 3.55) May 2014 Groupe Sup De Co Montpellier Business School – Montpellier, France

• Bachelor of Business Administration Jun 2012

Sichuan University – Chengdu, China

• Bachelor of Science in Financial Engineering Jun 2012 SKILLS

Certification – Passed CFA Level I, Passed FRM Level I. Computer – Advanced Excel, Word, PowerPoint, Python, SQL, Mode, M3 (Accounting Software), ADP Payroll. Language – Native in Mandarin.

Contact this candidate