HIGHLIGHTS: CPA (Inactive)
Advanced Excel skills, including v-lookups, pivot tables and complex formulas
Advanced Access and SQL language skills
Microsoft Word, Word Perfect, Business Objects, Hyperion, Lotus 123, TOAD
Oracle Financial, Lawson, Great Plains
* Superior ad hoc reporting skills
* Experience in general ledger accounting, analysis, reconciliation, reporting, revenue posting, accounts payable, fixed assets, inventory
* Attention to detail
* Ability to effectively streamline processes
* Supervisory experience
Willing to relocate to most areas of the United States.
WORK EXPERIENCE:
FORM-A-FEED, Stewart, MN 2007 - May 2009
Accountant
* Monitor all General Ledger accounts with an emphasis on sales and cost of goods sold accounts.
* Create weekly sales reports for the salesmen.
* Prepare and enter journal entries for all companies.
* Perform month end closing procedures. This includes inventory maintenance procedures.
* Create month end reports for all companies. This includes highlighting individual products and sales territories to help explain changes in margins.
* Analyze Financial Statements for inconsistencies and make corrections as needed.
* Monitor and reconcile bank accounts for all companies.
* Create ad-hoc reports requested by management for monitoring specific products or salesmen.
* Run processes to update prices when market changes dictate.
* Maintain custom price lists for a select number of the customers and create work around calculations when necessary.
NEXTEL PARTNERS, Eden Prairie, MN 2002 - 2007
General Ledger Accountant
* Develop new reports for financial analysis.
* Analyze subscriber revenue data for six monthly bill cycles and create journal entries for these bill cycles.
* Create revenue reports for six monthly bill cycles to help in managerial decision making.
* Review, create reports and journalize line items from a joint venture settlement invoice.
* Review all of the monthly revenue data to determine the amount payable to third party vendors offering unique services through the subscribers' cellular phones.
* Prepare monthly revenue accrual based on the actual revenue and Average Revenue Per Unit from all bill cycles for the month.
* Reconcile the unearned revenue account, liability account for the third party content providers, and the liability accounts for the joint venture.
* Review monthly revenue data for all bill cycles to make re-classes between markets.
* Create monthly analysis reports that show the comparisons of recurring revenue to usage revenue.
* Provide information to internal and external auditors as requested.
* Sarbanes-Oxley documentation for areas of responsibility.
FINGERHUT, INCORPORATED, Plymouth, MN 1999 - 2002
Accounts Payable Supervisor
* Assisted and filled in for the Accounts Payable Manager.
* Balanced international accounts, including freight, duty, and commission.
* Reconciled general ledger accounts to cost variance tables for discounts, rebates and ad allowance accounts, and created worksheets for the Buyers and Vice Presidents of Merchandising based on this information.
* Created worksheets for accounts payable general ledger accounts separating company divisions and sub-totaling accounts by merchandise and overhead.
* Queried invoice tables for information required by Internal Auditors and Custom Auditors.
* Processed general ledger inventory adjustments and profit and loss worksheets for the company stores.
SCHWAN'S SALES ENTERPRISES, Marshall & Young America, MN 1993 - 1995
Fixed Asset Coordinator
* Accounted for the fixed assets of various subsidiary companies.
* Determined depreciation percentages for new fixed assets.
* Reviewed receipts and decided whether to capitalize or expense the invoices.
* Prepared necessary journal entries.
Supervisor (Not accounting work) 1995 - 1996
* Supervised 18 employees in production of food products, and supervised 20 + employees in cleaning of food processing equipment.
* Determined job duties for employees and tracked attendance and hours worked.
* Resolved any problems that occurred in production and addressed employee concerns.
EDUCATION:
Southwest State University, Marshall, Minnesota
Bachelor of Science, 1994
Major in Accounting; Minor in Business