Summary
Overview
Work History
Education
Skills
Timeline
Generic

Philip Desagun

San Diego,CA

Summary

Personable business professional bringing successful 15-year career in financial roles within large and fast-paced corporations. Release-planning specialist trained in advanced Excel modeling. Creative solutions architect with real-time problem-solving flexibility.

Overview

12
12
years of professional experience

Work History

Senior Data Analyst

ShopCore
11.2022 - 06.2024
  • Delivered comprehensive reports highlighting key trends, patterns, anomalies, presenting findings to senior management for informed decision-making purposes.
  • Analyzed large amounts of data to identify trends and find patterns, signals and hidden stories within data.
  • Streamlined data analysis workflows for increased efficiency and faster decision-making processes.
  • Leveraged text, charts and graphs to communicate findings in understandable format.
  • Partnered with IT teams to ensure seamless integration between databases and analytical tools, maximizing system efficiency across departments.
  • Spearheaded implementation of dashboard visualization tool, Power BI, providing actionable insights for stakeholders and decision-makers.
  • Reduced manual data entry errors by designing and deploying automated ETL processes to transform raw data into usable formats.

Senior Property Accountant

ShopCore
02.2021 - 11.2022
  • Addressed questions from external auditors and provided requested documentation to enable issue resolution.
  • Audited recovery pools in assigned portfolio resulting in the recovery of $100k+ in missed billings.
  • Reviewed numerous financial statements for accuracy.
  • Reduced manual input errors by incorporating advanced data validation tools, leading to improved data integrity.
  • Contributed to the continuous improvement of accounting policies and procedures through regular reviews of best practices, maintaining alignment with industry standards.

Senior Accountant

Trigild Management
04.2019 - 01.2021
  • Reviewed financials of two staff accountants (total portfolio of 8 hotels) and supervised work of accounting clerks (AP/AR)
  • Responsible for complex accounting setup of new properties, reviewing management/operating agreements, creating billing schedules, preparing documents for new bank accounts, coordinating with insurance brokers to obtain required policies, etc
  • Managed corporate bank accounts, initializing book transfers / EFTs / ACHs when needed
  • Assisted with payroll reconciliation, booked tax and salaries expense to appropriate accounts for each individual property
  • Reconciled corporate GL accounts
  • Generated monthly billings for all projects.

Senior Property Accountant

HP Investors
01.2018 - 04.2019
  • Reviewed CAM estimates and CAM reconciliations for accurate calculations accounting for caps on CAM and other exclusions based on tenant’s lease
  • Prepared/reviewed annual budgets
  • Worked with property managers to ensure proper setup of building suites, tenant leases, and rent schedules
  • Communicated with different departments to assist with the acquisition and disposition of properties
  • Accounting for multiple commercial properties, including preparation of journal entries, bank reconciliations, and financial statements
  • Prepared/reviewed monthly financials for multiple properties on a monthly and quarterly basis
  • Implemented new procedures and guides for accounts payable and accounts receivable
  • Developed spreadsheets to simplify procedures and make them more efficient.

Staff Accountant

Trigild Management
01.2017 - 01.2018
  • Accounting for multiple commercial properties, including preparation of journal entries, bank reconciliations, and preparing financial statements for management review
  • Assisted with revenue balancing for hotel properties
  • Trained and reviewed work of Accounts Payable Clerk, Accounts Receivable Clerk, and Corporate Accounting Clerk
  • Managed cash for multiple projects and prepared funding requests when needed
  • Streamlined processes and implemented internal controls, reducing workloads.

Accounting Specialist

Hilton Mission Bay
04.2015 - 12.2016
  • Accounts Payable: Processed 300+ invoices weekly, ensuring proper supporting documentation before disbursing checks
  • Accounts Receivable: Prepared billing statements; processed cash, check, and credit card payments; posted payments
  • Reconciled daily revenue with POS/ERP systems throughout hotel
  • Monitored aged trial balance for outstanding bills and made collection calls for delinquent accounts
  • Assisted with bank reconciliations.

Accounting Clerk

SeaWorld Parks & Entertainment
06.2012 - 04.2015
  • Audited cash receipts daily for park and retail outlets, posting adjusting entries as needed
  • Processed credit card payments
  • Posted revenues by verifying and entering transactions from lock box and local deposits
  • Prepared sales and ad hoc reports using Excel (pivot tables, v- and h- lookups, sum ifs, linking spreadsheets, etc.)

Education

Bachelor of Science in Accountancy -

National University
San Diego, CA
07.2018

Associates of Arts in Business Finance -

Mesa Community College
San Diego, CA
06.2012

Skills

  • NexusPayables
  • M3
  • MRI
  • Quickbooks
  • AVIDx
  • Yardi Voyager
  • Great Plains
  • Advanced Excel

Timeline

Senior Data Analyst

ShopCore
11.2022 - 06.2024

Senior Property Accountant

ShopCore
02.2021 - 11.2022

Senior Accountant

Trigild Management
04.2019 - 01.2021

Senior Property Accountant

HP Investors
01.2018 - 04.2019

Staff Accountant

Trigild Management
01.2017 - 01.2018

Accounting Specialist

Hilton Mission Bay
04.2015 - 12.2016

Accounting Clerk

SeaWorld Parks & Entertainment
06.2012 - 04.2015

Bachelor of Science in Accountancy -

National University

Associates of Arts in Business Finance -

Mesa Community College

Similar Profiles

CREATE PROFILE
Philip Desagun