Drew Workman Email & Phone Number

Orlando, Fl, Us

Pittsburgh, Pennsylvania, Us

Pittsburgh, Pennsylvania, Us

Create financial models for RFP process to submit to potential customer projects. Work cross-functionally with Sales, Operation, and Inventory Control teams to create a full forecasted P&L for each contract bid. Models are presented to CEO, CFO, and other Senior Leadership to show the financial impacts of contracts to thebusiness unit. More than $10.6 Billion in potential sales submitted to customers since July 2019.• Meet monthly with large alliance customers to review full P&Ls for Return on Sales models. The meetings are to ensure we are hitting contract milestones. These contracts are more than $400M and $150M in annualrevenue.• Create financial models that track progress of implemented projects. Communicate with Sales, Operations,and Project Management team’s key variance drivers compared to anticipated plan.• Analyze and approve inventory cost write-downs on reserved items. Since beginning the write-down initiative,our business segment has realized a $5 Million increase in revenue due to inventory reserve release.• Track and communicate customer rebate claims. Automated rebate claim process. Previous process took upto 7 hours monthly, new process takes 15 minutes.• Assist in completing business units’ annual budget of full P&L for more than 150 operation and sales locations.• Created a Daily Sales dashboard utilizing Tableau that is distributed to over 200 sales and operationsmanagers, directors, VPs.

Pittsburgh, Pennsylvania, Us

Created an Aged Inventory Report that has led to an 18% reduction of aged products in 12 months, totalingnearly $7.4 Million utilizing tableau• Modeled several Real Estate Relocation Proformas that will bring an additional $40 million in ContributionMargin to the business over the next 5 years. All proformas have been review and signed off by CEO and CFO.• Created a Days Inventory on Hand Report to communicate inventory levels by location. The report gives theInventory Control Team better visibility of stocking requirements• Responsible for making quarterly forecasting changes to the P&L using variance analysis and communicatingchanges with Finance VP.• Created a Visibility Report that shows sale leaders what their book & ship sales should be based off anticipatedbacklog shipment and monthly sales forecast.• Created a report that demonstrations Sales Teams customer quote win percentages based of numerousdifferent criteria. This report is also presented in vendor meetings to negotiate better cost.• Created a Cost Analyst Report that shows YoY price change by vendor and total spend impact based off currentquarters inventory demand. The purpose of this report is to negotiate vendor cost.• Created Sales Rep Dashboard using Excel and Tableau. Report communicates CY vs PY; Sales, GP, GP%,and Backlog. A macro is used to individually calculate and distribute to over 50 sales reps.

Bethesda, Md, Us

• Track and compare spending to actual milestone performance of contracts up to 100 million• Redesigned and maintain a complex weekly manpower tool to pull all weekly actuals which are automatically sorted by Contract and Engineer then compared to monthly forecast plans• Developed four major direct reports, reducing process speed by 33% and improving reliability• Create and maintain a management charging matrix, on a weekly basis, for the chief engineer that analyzes all prior week charging trends and utilizes macros• Update quarterly actuals/forecast inputs forms for 3 engineers, review and analyze inputs, and ensure accurate transfer of data into our pricing tool• Assist engineers with time management, labor cost transfers, salary adjustments and time inputs• Creates and maintain budget spend plans for all F-35 EOTS capital projects tracking labor and material expenditures• Distributes weekly performance reports aiding management in rostering employees to avoid bottlenecks• Forecast and submit Premium OT Forms for government approval• Trained new intern on all responsibilities to prepare him as a backfill