Todd Hilbert Email & Phone Number

Anderson, Indiana, Us

Anderson, Indiana, Us

Indianapolis, In, Us

• Built financial model for sales tracking, forecasting and backorder analysis. • Prepared multiple reports analyzing sales information that were placed into the monthly financial reports and distributed to the executives.• Created and distributed bi-weekly forecast reports analyzing forecast to actual sales, as well as forecast to inventory projections.• Coordinated with the Sales, Purchasing, Branding and Manufacturing departments to update the monthly sales forecast in the Axapta Accounting system.• Responsible for calculating of all customer pricing and uploading of those prices into the Axapta Accounting system.• Completed special projects and analytics for executives and the Sales, Branding and Purchasing departments. • Created and distributed a Daily Report of the monthly/yearly sales and cost of sales to all managers and executives.• Created and distributed a Daily Production Schedule for the manufacturing group leaders, verifying what the system showed as produced and shipped by Manufacturing and received in by the Warehouse to aid in supply-chain management activities. • Distributed weekly a backorder report analyzing the revenue opportunity lost due to items on backorder.• Calculated and recorded monthly Marketing Program Accruals by Distributor.• Supported and backed up finance team with day-to-day activities and various audit requests.• Responsible for the completion of all financial Census Surveys.

• Completed monthly financial statements templates for each department and branch.• Completed annual budget financial statement template for each department and branch.• Ran financial data and updated figures for Income Statement, Balance Sheet and Statement of Cash Flows.• Calculated amount of revenue to be recognized monthly for projects based on predefined revenue recognition method (fixed fee, percent complete formula, deliverable based, time and material).• Acted as primary contact with project managers to gather, monitor and maintain fixed fee schedules that define invoicing, estimated hours worked and hours to complete on projects.• Responsible for developing and posting journal entries required for recognizing, accruing and reconciling revenue.• Gathered, monitored and maintained the detail for the Flexible Spending Accounts on a plan year basis to determine if employee contributions will cover employee spending or if the plan year will result in a loss.• Created Board Resolutions for new stock options granted and update Stock Option Ledger to reflect any changes.• Responsible for sending Employee Stock Option Agreements out, verifying signatures and maintaining necessary documentation showing employee Stock Options and Stocks.• Responsible for creating Yearend Stock Option Footnote.• Responsible for completing and filing State and Federal surveys and forms.• Reviewed daily bank activity for all company bank accounts. Summarized and reported the information in a Daily Cash Report that was distributed to management.

Carmel, Indiana, Us

• Started with company as Investment Reporting Staff Accountant I. Promoted to Manager in March 2004.• Past duties included preparation and review of investment related information for the Statutory Annual Statements, GAAP 10K and 10Qs, and the Tax department.• Verified the investment work papers produced in the department tied to the Hyperion ledgers for Statutory and GAAP for several life companies. Primary contact if there were any issues with any of the companies.• Mentored staff and helped increase the engagement level of the department. Was able to empower the staff in order to make the department more productive.• Coordinated information from multiple departments in order to complete all investment related requests from various departments.