Los Angeles Data Analysis

Jorge Gonzalez

Accountant

Los Angeles, CA. *****. USA - 310-***-****

**********.***@*****.*** - hCps://www.linkedin.com/in/george-g-837926344/ Summary

Experienced accountant/bookkeeper with over 15 years of experience in financial management and accoun>ng roles across various industries. Proven track record in managing financial opera>ons, month-end closings, and genera>ng comprehensive financial reports. Proficient in various accoun>ng soCware, including QuickBooks and Sage, and skilled in data analysis using advanced Excel func>ons. Bilingual in English and Spanish, with strong organiza>onal, record management, and analy>cal skills. Expert at streamlining processes to improve efficiency and accuracy. Work Experience

Accountant – Financial/Property Nov 2018 - May 2024 WestCorp Mgmt. G./Ascent MulPfamily AccounPng Las Vegas, NV.

• Managed the month-end close and evaluated financials for 15 residen>al proper>es

(5,060 units) across five states and three >me zones.

• Uploaded biweekly payroll files in CSV format for all en>>es.

• Assisted in preparing 1099 (MISC/NEC) tax forms and repor>ng filings

• Generated and uploaded annual budgets for all accounts in CSV format.

• Reconciled balance sheets and income statements on a monthly basis.

• Recorded final closing statements for new sales, purchases, and refinances.

• Prepared and submiZed quarterly financial reports to investors and lenders.

• Reviewed, adjusted, and reconciled monthly mortgage and lender statements.

• Documented and recorded year-end adjus>ng journal entries and deprecia>ons.

• Assisted auditors with the necessary documenta>on and reports for annual audits.

• Biweekly reviewed the General Ledger for reclassifica>ons or omissions in transac>ons.

• Reconciled and recorded monthly amor>za>ons, deprecia>on, and fixed asset ledgers.

• Allocated and issued monthly management and asset fees by assessing income statement reports.

• Dispersed monthly and quarterly distribu>ons to owners and investors via wire and check payments.

• U>lized Pivot Tables, VLOOKUPs, delimited data, and other advanced Excel func>ons for data analysis reports.

• Developed customized Excel reports for current cash flow by combining vendor aging and liability data reports.

• Reviewed and recorded monthly adjus>ng journal entries, accruals, prepaid expenses, and true-up to market rent.

• Generated monthly preliminary reports for final approval by: Property and Asset Managers, V. President, and owners.

• Reconciled an average of 40+ bank statements monthly for opera>ng, reserve, DACA, and secured deposit accounts.

• Accounts Payable - processed check runs for payables averaging over $200,000 in more than 100 checks and over 20 wire payments per run weekly.

• Produced monthly financial packets that included balance sheets, P&L statements, trial balances, check registers, vendor aging reports, trailing twelve reports, variance reports, and more to owners, CEOs, investors, vice presidents, and lenders for all en>>es. Data Analyst for Mul7media Slot Games/Administra7ve Assistant Jun 2017 - Nov 2018 MGM Industries - Resort InternaPonal Las Vegas, NV.

• Created sta>s>cal and analy>cal reports, tables, and graphical representa>ons of performance data.

• Assisted in seing up readings from gaming soCware for daily, weekly, and monthly meter readings.

• Produced and delivered performance reports for all floor machines to NGC-Nevada Gaming Control.

• Compiled data and iden>fied elements of games that can be u>lized to enhance the success rate of game designs.

• Monitored and collected PAR sheets and pay tables from various manufacturers to analyze incremental contribu>on measurements, basic game and par elements, win percentage issues, and progressive PAR holds.

• Evaluated incremental contribu>ons, progressive holds, and designated machines/games as WAP (Wide Average Progressive) or CWAP (Corporate Wide Average) Progressive).

• Created Excel spreadsheets for thorough performance analysis, code updates, win percentages, pay table correc>ons, and EPROM assignments.

• Maintained and updated comprehensive databases – OASIS BlackBart, PRIME, OASIS FloorLogix, and Excel Spreadsheets.

Accoun7ng Clerk & Office Assistant Jan 2015 - May 2017 Belle1 Racing Comm./Formula Dri[ LLC. Signal Hill, CA.

• Reconcile bank and credit card accounts monthly.

• Monitoring customer and vendor aging accounts weekly.

• Reviewed General Ledger weekly for accurate classifica>on.

• Recorded monthly accruals of missing expenses.

• Recorded and documented monthly prepaid expenses.

• Posted customer account check payments received via mail.

• Generated budget spreadsheets for each event to maximize profits.

• Generated and submiZed monthly financial reports to external par>es/CPAs.

• Created and updated Excel spreadsheets and QuickBooks inventory weekly.

• Handled weekly payroll, invoices, work orders, and daily cash reconcilia>ons.

• Issued vendor payments using wire transfers, credit cards, or company checks.

• Generated invoices weekly and used the QuickBooks feature to send them via email.

• Provided detailed spreadsheets that summarize monthly revenues, expenses, and cash flow.

• Prepared and analyzed monthly profit and loss reports u>lizing QuickBooks and Excel worksheets.

• Generated vendor purchase orders for products and supplies: office, events, warehouse, and rental inventory.

• Office tasks included scanning, filing, answering a mul>line phone system, processing quote requests, following up on proposals, and upda>ng or crea>ng new rental contract agreements. Bookkeeper & Administra7ve Assistant Aug 2012 - Dec 2014 360 CommunicaPon Rentals, Inc. Moorpark, CA.

• Accounts Payable and Receivable.

• Account and record weekly inventory.

• Reconcile company credit card accounts.

• Monitored customer and vendor aging accounts.

• Recorded journal entries, accruals, and prepaid expenses.

• Review General Ledger for any misclassified transac>ons.

• Generated by-weekly rental billing and followed up on collec>ons.

• Generate new accounts by researching the internet and produc>on leads.

• Reconcile bank accounts, including opera>ng, reserves, and savings accounts.

• Account acquisi>on and reten>on. U>lizing social media and email marke>ng.

• Conducted research, organized files, input data, and answered incoming calls.

• Assist customers with issues, concerns, or general inquiries regarding billing, credit payments, equipment troubleshoo>ng, and service/product recommenda>ons. Educa3on

QuickBooks Online – ProAdvisor Online/Website Sept. 2025 ProAdvisor Level 1 – Cer>fied (Renewed)

Intuit Inc. / Coursera Online/Website Jan 2024 - Dec 2024 Higher Secondary School (8) Cer>ficates – Accoun>ng & Bookkeeping. DeVry University – Campus. Long Beach, CA. Mar 2002 - Aug 2004 Associate’s in Accoun>ng – Degree A.A.

Summary of skills/qualifica3ons

• 22 years of experience in MicrosoC Office.

• 15 years of experience in AP/AR.

• 12 years of experience in QuickBooks.

• 10 years of experience in Bookkeeping.

• 08 years of experience in Accoun>ng.

• 07 years of experience in Office Management.

• 06 years of experience in Execu>ve/Admin. Assistance.

• 04 years of experience in Sales Management.

• MicrosoC: Excel, Access, Word, and Outlook.

• QuickBooks and Quicken (Online & Desktop).

• Excel at Organiza>on, Record Management, and Data Analyzing.

• Dropbox.

• OneDrive.

• Google Docs.

• Propertyware.

• Sage/Mass200.

• Entrata Plaoorm.

• Resman Plaoorm.

• Realpage/Onesite.

• Yardi (Voyager & Breeze).

• Type 55 WPM and 10-key by touch.

• Experienced with PC/Windows and

MACINTOSH Technology.

Contact this candidate