- Led multiple accounting workstreams for global implementation of CoStar lease administration and accounting system to support adoption of ASC 842 and IFRS 16 for $16B+ portfolio, including system and process requirements, SIT and UAT testing, ITGC security design, lease abstraction validation, and post-implementation support and enhancements- Responsible for reviewing month-end close deliverables for 6 accounting analysts for facilities and lease accounting

- Developed automated data model to reduce manual touchpoints in the subledger capitalization review process, increasing accuracy of initial review while decreasing review time by 67%- Developed a versatile ‘VBA Toolbox’ with dozens of tools that can be used in a wide variety of situations (filter by list of values, bulk formula auditing, bulk formula editing, custom reporting automation, and more)

Dell Accounting Development Program - Second Rotation- Lead quarterly Balance Sheet review for Dell and present the results to the Chief Accounting Officer and other finance and accounting executives- Global accounting lead for Dell severance actions, partnering with HR, business, and finance leaders to ensure accrual is accurate and business leaders can forecast cash and income impacts- Developed a flexible Excel model to save one workday each quarter for severance journal entries and two workdays for a colleague each year-end for corporate bonus journal entries- Responsible for tracking and reporting non-GAAP acquisition and integration expenses

Dell Accounting Development Program - First Rotation- Utilized dynamic formulas and custom functions in Excel to reduce manual steps for journal entry preparation by 60%- Ensured accuracy and compliance of Borrowing Base submission to lender for Dell's $2B asset-backed loan (ABL) facility- Performed account reconciliations and journal entries for Dell's $2B ABL facility and multi-billion dollar custody investment portfolio

- Lead associate on investigative audit resulting in recovery of misappropriated assets identified through data mining and analysis of purchasing patterns- Created and enhanced data mining tools using VBA to reduce effort auditing time reporting, purchasing cards, and travel expenses by 40%- Audited $4.5 million of an affiliate university's purchasing card transactions, and presented recommendations for improving control design and effectiveness to the Chief Audit Executive- Worked 20-28 hours per week while maintaining a full university course load of up to 27 credit hours per semester

- Prepared financial statement footnotes and assisted in the overall process of issuing financial statements and earnings materials to key stakeholders- Prepared Management Representation Letter (MRL) tool for implementation, enabling streamlined electronic submission of MRL attestations and support- Researched accounting literature and industry peers to identify and implement changes to financial statement footnote disclosures- Updated and clarified several corporate accounting policies to reflect recently issued accounting guidance

- Identified and corrected reporting variances for a new inventory tracking tool, devised metrics to track its accuracy, and trained international staff in preparation for global implementation- Utilized pivot tables and dynamic formulas to simplify importing, analyzing, and reporting warranty parts inventory data and key metrics