Aaron Hooper Email & Phone Number

Grain Valley, Missouri

Independence, Mo

• Oversee accounts payable department consisting of 3 accounts payable clerks• Supervise 2 district bookkeepers who are responsible for cash reconciliation, journal entries and foundation bookkeeping• Responsible for the accounting for all education related grants (Title I, SPED and many miscellaneous grants) including budget applications, final expenditure reports, account code set up and working with grant supervisors• Worked with the financial software company to develop and implement a paperless process for accounts payable and presented a presentation at their national conference• Implemented a new credit card process across the district• Assist the financial software company in developing various new tools to better support the users and enhance the value of the financial software• Interact daily with department and building bookkeepers regarding purchasing issues, account code issue and general financial system questions• Conduct various professional development training sessions• Asses current processes and procedures and develop ways to improve• Assist in the annual audit• Cash management

Leawood, Ks

• Track the new business revenue for multiple reporting sectors in energy division• Track new business backlog on a monthly basis• Perform monthly analysis for new business compared to forecast and budget and research for management• Prepare variance reports and goal tracking reports for upper management• Reconcile customer billing system to the general ledger system• Analyze section of overheads on a monthly basis • Research variances for other income each month• Work with project accountants on explanations on various issues• Asses current processes and make improvements• Assist management with various request as needed• Create miscellaneous journal entries

Kansas City, Missouri Area

• Generated various accounting journals for month end closing including expenses and revenues• Undertook the responsibility for the entire closing process of business unit including revenue and cost analysis• Oversaw derivative accounting including mark-to-market and hedge settlements for natural gas financial contracts • Tracked Fuel Adjustment Clauses for three jurisdictions in accordance with regulatory commissions• Analyzed detailed variances for balance sheet and income statement accounts on a monthly and quarterly basis for upper management• Budgeted for various balance sheet accounts and assisted with other budgeting and forecasting issues• Collaborated in the implementation of new software automating the posting of accounting journals for financial contracts significantly reducing the amount of time by 20%

Kansas City, Missouri Area

• Reported the margin accounting for natural gas division made up of eight different business units• Generated monthly accounting journals including both expenses and revenue• Analyzed monthly margins compared to budget and researched any variances for upper management• Communicated with other groups such as regulatory, tax and financial managers about various issues• Worked directly with financial managers to resolve budget variances • Trained personnel from acquiring company on margin accounting allowing them to make a smooth transition at the purchase date • Streamlined the bank reconciliation process significantly reducing the time required to complete the reconciliation by 40%

Kansas City, Missouri Area

• Monitored weekly interface between customer billing system and People Soft Financials and corrected any discrepancies• Posted journal entries to General Ledger for monthly close, including journals to true up the billing system with accounting system• Reconciled all revenue accounts for both regulated and non-regulated business units and resolved any variances• Prepared monthly reconciliations for large bank accounts, including a lockbox account with more than 10,000 payment transactions per month• Implemented new payment deposit process for one bank account which significantly simplified the reconciliation process• Assisted Sr. Accountant with various journals on a monthly basis

Undergraduate, Accounting

Associates