Team Leader - Excel Design Tax Accounting Workbooks
CurrentLong-term consultant for major private equity firm in Philadelphia. Designed and maintained various process improvement and technical models.Complex Section 274 (Limitation of aircraft expenses) at the click of a button, taking data from the software PFM and turning it into a database and report for easy review and changes based on the latest tax regulations. This design uses extensive VBA and pivot tables.Design and maintain apportionment workbook taking consolidating companies and calculating state apportionment with "intelligence" for each state using simplified input, pivot tables and VBA.Design and maintain state trust workpapers for calculations in at least 30 states coming from various operating companies owned by the Private Equity firm..Design and maintain data and analysis of tax workbooks used by the Big 4 accounting firms in tax analysis and preparation.Tax and Financial Operations consultant specializing in Tax Automation Projects, Excel modeling including design, documentation, VBA programming and implementation at large companies as a full time employee for Experis (A Manpower Company)