Gregory Applegate Email & Phone Number

• Assisted in a billing project that expedited the collection of ~$70 million cash in Q4 of 2023.• Executed the Research and Development analysis yielding ~$30 million in tax credits for FY 2023.• Assisted in the testing and migration from physical to virtual servers hosting the Honeywell Finance BI SSAS infrastructure.• Maintained the Aerospace Management Reporting (Aerospace Internal Reporting) SAP and Oracle hierarchies.• Developed Alteryx workflows and Tableau dashboards to monitor month end close processes.• Performed system reconciliations between Honeywell External Reporting, Honeywell Corporate Reporting, and Honeywell Internal Reporting tools.

• Managed the NetSuite, Concur, and CCC system integration teams.• Led multiple external teams to develop APIs for our new systems. • Identified $8 million in unapplied accounts receivable. • Performed monthly gross profit margin analysis, commissions reports, and system administrator duties. • Conducted lunch and learn meeting for team development.

• Prepared forecasts, budget models, KPI stats, and review tools on a monthly cadence for ~500 locations. • Wrote macros and python scripts to automate trackers, budget rollups, and other reports. • Led the initiative to update all Essbase reports for the Landfill, SEC, Tax, FP&A, and Corporate Accounting departments in the new ERP. • Designed an Alteryx ETL to automate our IT Budget process.

• Designed and implemented an Alteryx ETL process to consolidate sales, credit, and accounts receivable data. • Created Enterprise-wide Power BI reports to display key performance indicator trends at multiple levels for each department.

• Generated monthly and ad hoc reports for legal counsel, audit, retail, supply chain, human resources, and back-office support. • Developed tools that helped us implement new KPIs to drive change in our organization resulting in more than $2 million dollars of savings, enhanced compliance, and increased employee productivity. • Provided training videos, documentation, and in person sessions of skills training.