Helen Yizi Hua
helen.yizi.hua@gmail.comú Los Angeles, CAú 424-***-****
LinkedIn: www.linkedin.com/in/thisishelenyizihua
Profile
• Finance & Accounting professionals and CFA candidate with strong experience in performing analytical tasks such as Financial Analysis, Data Analysis, Project Analysis, Due Diligence, Valuation, Real Estate Finance, Bank Reconciliation, Book Keeping, Month-End Close, Auditing assistance, Financial Reporting, Compliance Reporting and Budgeting within the financial service, commercial real estate, Non-profit Financial Service industries.
• Possess strong knowledge of financial concepts, such as Macroeconomics, Accounting, Portfolio Management, Corporate finance, Fix Income, Equity Investment, Financial Risk Management, and Financial Modeling. Proficient in Microsoft Excel (Pivot Table, V-Lookups, If-Analysis), Word, PowerPoint, Abila MIP, Yardi Voyager, QuickBooks, and Salesforce.
• Fluent in English and Mandarin, verbal and written communication. Also knowledgeable in various high- level analytical skills, such as FCF, Budgeting, Discount Cash Flow, LBO, PE/PB Valuation and accrual base accounting methods.
Education
Pepperdine University, Graziadio School of Business and Management Malibu, United States Master of Science in Applied Finance, Investments August 2017-August 2018 Central South University, Business School Changsha, China Bachelor of Science in Economics, Finance September 2013-June 2017 Experience
Charter Impact Northridge, CA
Accounting Associate June 2019 – August 2020
• Responsible for accounting, financial reporting and compliance reporting tasks, such as bank reconciliation, payroll reconciliation, revenue recording, general ledger analysis, month-end close, budgeting and forecasting for multi-clients within the accounting department of a non-profit organization financial service company.
• Update the financial positions for each bank account of all the clients on weekly basis through bank reconciliation and cash out flow projection to monitor the cash positions of clients and to ensure the Accounts Payable team function efficiently and correctly.
• Record monthly bank activities through different models such as cash receipt, cash disbursement and Journal Voucher in the Abila MIP accounting system to do book-keeping for the clients; do the monthly journal entries for the prepaid amortization, fix asset depreciation and some recurring accruals for each client; Preform general ledger analysis for month-end close of each responsible client monthly to generate the financial packages for clients; Update the forecast sheet for clients monthly with variances notes to support the Director’s budgeting.
• Perform quarterly, annually compliance reports for clients of various funding’s revenue and expenses reconciliation; Asist the third-party auditors to perform the auditing job of clients, which includes providing backups for some certain selection samples and answering questions of various entries and accruals to generate the annually audits reports for clients.
Achievement:
• Formatted the payroll sheets for one of our biggest clients with more automatic excel functions, which saved at least 6 hours of reconciliation monthly.
• Finishing maximum 18 bank reconciliations within a day; recording more than 50 complicated transactions within a day.
The Mat West Company Sherman Oaks, CA
Staff Accountant February 2019 - May 2019
• Responsible for accountant tasks, such as monthly journal entries, bank reconciliation, depreciation, financial reports, schedule rent roll calculation, construction projects’ cost monitoring and weekly payable batches review under the management of the controller of a real estate management company in the commercial real estate industry.
• Track, calculate and book the journal entries by using the Yardi Voyager system to record the monthly recurring activities during the month, review AP’s working sheet weekly before cut the check day, reconcile bank accounts and prepare monthly cash flow statement and income statement to support the works of the controller.
• Prepare, calculate and analyze rent roll sheet of all properties twice a month through excel to monitor the monthly vacant units’ situation and to compare the properties rent with the market rent to better support the owners to know the properties’ running situation.
Achievement:
• Developed code in the rent roll excel sheet by using Marco VBA to automatically collect and calculate vacant units’ data of each property, which eliminates the appearance of errors of manual calculation. Vanguard Investment, Inc. Los Angeles, CA
Commercial Real Estate Intern October 2018 - January 2019
• Responsible for research and information analysis task, such as loan review, data entry, information update, property analysis, deal analysis, data collection, valuation and underwriting within a top active brokerage company in the commercial real estate industry.
• Research, organize and renew information of multi-family properties and on market transactions by conducting information researching, transactions checking, loan reviewing, data collecting to update the company’s own database to support agents in the company to bring more business.
• Compose sales comparison and perform financial analysis to properties by creating an appraisal spreadsheet of rent rolls and estimation of operation costs to do the valuation of properties to assist the marketing process of underwriting side.
Achievement:
• Deep researched more than 800 transactions and 500 on market properties by using Costar, Title, LoopNet and other information resources, which improved the working efficiency of calling agents at least an hour a day.
Hunan ChuCaiWeiYe Investment Management, LLC. Changsha, China Finance Analyst – Part Time October 2016-June 2017
• Responsible for analysis tasks, such as searching for retail properties from the sales side in the market, performing due diligence, financial analysis, and capital budgeting within the investment department of a medium-sized company in the commercial real estate industry.
• Research and process due diligence of properties by conducting property inspections, market positioning analysis, risk analysis, and capital budgeting to create the analysis report to support the manager’s decision- making.
• Underwrite for leasing stores by managing daily market prices, posting properties pictures online, meeting clients and reviewing lease terms and rent rolls to assist the marketing side of the company.
• Collect and prepare key invoices of expenses, process general A/R and A/P, prepare journal entries and account reconciliation for review by the senior financial manager to support the development of the monthly financial report and cash flow projection.
Achievement:
• Successfully develop and implement an Excel spreadsheet model to automatically calculated net operation income. This automated process has resulted in a significant time saving of half an hour calculation time for each project.
Sealand Securities Changsha, China
Due Diligence Intern June 2016-August 2016
• Responsible for writing of nation equity exchange files, such as the description of the business model, risks and structure of the management team within the investment banking department of a public security company in the financial service industry.
• Compose equity exchange files of a client company by reading and analyzing other companies’ 10Ks in the same sector to illustrate the client company’s intrinsic value to investors.
• Conduct some administrative tasks such as agenda management, minute, follow up clients and collect documents to assist the team to work more efficiently. Achievement:
• Received recommendation letter from supervisor to apply for the master’s degree of U.S.’s business schools.