Lucas Hawthorne Email & Phone Number

Scottsdale, Arizona, United States

Phoenix, Arizona Area

- Perform weekly labor cost reporting and quarterly estimate-at-complete (EAC) review for F/A-18 fabrication work at the Mesa site. This involves assembling timely, accurate financial data; conducting rigorous, defensible analysis; evaluating and improving existing reporting processes; and building strong working relationships across multiple sites and functions through constant, clear communication- Resolve ad-hoc analysis requests that require rapid turnaround and familiarity with financial reporting systems- Actively participate in Excel-R8 volunteer employee resource group, leading quarterly trainings and heading organization-wide Excel/Macro/VBA troubleshooting and project requests

My wife and I took a brief hiatus from our careers to fulfill some international travel dreams before relocating to our home state of Arizona

- Managed monthly close and operating expense reporting for six different divisions throughout the company. This involved quick turnaround of actual vs budget analysis, developing new reports in response to budget manager feedback, and identifying and preparing reclass journal entries as needed- Generated monthly company consolidated headcount and operating expense reports with commentary for management- Oversaw creation of annual budgets totaling over $48 million for expenses spanning multiple service divisions- Conducted ad hoc analysis of accounting transactions at request of budget managers and division leaders. This required comprehensive understanding of the company structure and accounting systems- Overhauled, automated, and documented accrual process for monthly company card spending tracked through Concur software. Met with multiple stakeholders throughout corporate financial services to gain a full understanding of the key process components and created a guide based on this understanding for future department reference

- Managed operating expense reporting process which included monthly distribution of departmental budget vs actual reports, expense trend analysis, and comprehensive knowledge of P&L line items- Facilitated FP&A relationship with department leaders, ensuring information and reports were accurate, up-to-date and aligned with department expectations- Utilized newly implemented reporting and budgeting software (Prophix) to automate monthly reporting and develop detailed operating expense budget, reducing monthly reporting cycle time by 30 analyst hours/month (50%) and budgeting cycle time by two weeks (25%)

Corporate Office

- Managed monthly reporting and payment of recycling rebates for 15 National Account customers that generated over $8 million in annual rebate revenue- Enhanced reporting integrity and timeliness through active participation in a process improvement initiative that condensed average reporting time per customer by 15 analyst hours/month. This involved Microsoft Excel macro development and database design in Microsoft Access

Phoenix, Arizona Area

Scottsdale, Az

Master Of Business Administration (Mba), Financial Management And Markets

Bachelor Of Business Administration (B.B.A.), Accounting