David Campbell Email and Phone Number

•Prepared a weekly forecast for two transmix processing plants.•Preformed an monthly accounting close for two processing plants.•Reconciled the operational inventory balances to the general ledger each month.•Designed reports for product movements to improve accuracy and speed of the inventory reconciliation process. This process was taking 5 days to complete each month, now it is only 1/2 days to complete.•Built and ran HFM & Essbase financial reports each month to look for journal entry errors and compare to budgeted numbers.•Reviewed and approved invoices for payment and invoices for billing.•Designed and wrote a program that took freight vendors invoice files uploaded and compared to our system data by BOL for improved payment accuracy.•Built a JE upload program to reduce errors and increase the accuracy and speed of the close process. Significantly reduced the number of JE entry errors each month. •Built an error checking program for budget upload templates for 10 different assets reducing the budgeting time. •Prepared variance explanations actual to plan and forecast each month.•Designed and wrote an A/R tracking report in MS Access to reduce the A/R balances .

•Worked with internal/external auditors concerning review and annual audit questions.•Analyzed and solved several monthly intercompany out-of-balances.•Created Deski queries that helped correct multi-year intercompany out-of-balances•Preformed 30+ monthly reconciliations for several business units.•Improved the readability and analysis of the reconciliations by adding historical data and descriptions of the recon.•Prepared and reviewed journal entries for a heavy fuel oil supplier Duke Intl. controlled.•Reviewed journal entries from business units to ensure accurate financials.•Analyzed monthly variances to budget for missing expenses or over stated income.•Review accounts receivable reports for accuracy•Assisted with daily close call to home office on any issues that may affect the timing of the financial close process.

• Worked with internal/external auditors concerning sox quarterly review and annual audits problems. Automated the Sox control user review procedure. (One week of work each month reduced to one hour)• Developed a monthly A/P trial balance to G/L reconciliation and fixed several large accounting issues (one being $13 million).• Solved an accounting payroll outstanding reconciliation ($18 million issue).• Developed a monthly wire reconciliation program. • Developed and wrote numerous MS Access programs to improve the Accounts Payable Associate’s Fixed Assets reporting efficiency. • Developed an audit program and prepared audit selections for corporate credit cards.• Participated in the monthly close process overseeing the final close process. • Prepared ad hoc reports that the Shared Services Director, Company President, & Company Controller requested to solve several operational and process problems.• Trained two assistants to create a reporting department covering F/A, Travel, Amex, and A/P. • Worked with internal/external auditors concerning quarterly financial statement review and year end Audit.• Helped prepare the press release and analyst packages for Quarterly 10Q’s and 10K under the Company Assistant Controller. • Opened and closed general ledger accounts and general ledger account segments for the entire company.

•Gave daily updates to fuel manager about significant price changes of oil, gas and jet fuel, why they occurred, and what was the potential future price of the commodities. •Prepared budget templates and reviewed the manager's budget schedules for fifteen international offices. •Communicated effectively with upper management about raising fuel margins by 4 cents a gallon, increasing net profits by $500K+ a month. •Prepared 15 month end reports (IS, BS, Cash Flows) for the CFO and President of the company and made recommendations about solving current and future cash flow problems. •Built a spreadsheet that created a pro-forma variable input sheet and improved the understanding of the Joint Venture Financial Statements. (This improved the pro-forma results credibility of the financial data.) •Completed the analysis on several Joint Ventures and had several recommendations acted upon by the project champion and CFO. •Reduced the month end reporting to one day, by automating monthly reports in Oracle, Access, and Excel.

•Prepared and reviewed the financials each month and presented them to the Chief Financial Officer. •Developed and co wrote a pricing program for the entire company in MS Access. (Increased the profit margin by 4%)•Calculated future value of properties for potential acquisition. •Prepared the Annual budget templates and preformed the review for the entire company. •Property tax analyst for values and lawsuit break-even analysis against county assessors. •Created and developed a very sophisticated program that would catch internal theft of monies. (Reduced internal audit time by weeks each month.) •Provided quarterly statements to bank and investors to comply with loan covenants. •Negotiated credit card rates for a 25% decrease in cost. •Supervisor of nine people in the accounting department. •Supervised an audit for 5 subsidiary companies. •Improved the efficiency of the four bookkeepers by 100% by automating Journal Entries and designing a new income reconciliation program•Created and programmed a cash management system using Microsoft Access saving money on voided checks. •Manager of the fixed assets. •Lead contact and audit work paper preparer with the external auditors

Prepared budgets and forecasts. • Analyzed the actual to budget variances, improving processes for potential cost reduction, and providing efficiency reports for the departments. • Analyzed the cause and effect of the logistics warehouse and freight expenses. • Calculated bonuses, provided timely financial reports for the department operational reviews. • Distributed the quarterly warehouse cost allocation to various division managers. • Investigated general ledger account discrepancies and communicated the discrepancies to the appropriate Vice President. • Conducted operational audits of inventory, return expenses, and freight billing.