Dean Anderson Email and Phone Number

Assist Directors of Accounting, Controllers and Accounting Staffs with preparation of financial and operational data for migration to their new financial system software either to Microsoft Dynamics GP or Microsoft Business Central. Responsible for coordinating the Discovery & Analysis meetings regarding the clients existing accounting system. Documenting their present financial and other internal processes. Assist client’s with their prior system discovery documentation to establish parameters and settings for the implementation of their new financial system. Developed, with client management team, financial models needed to reconcile Trial Balances for current and historical years. Assisted the Financial / Accounting personnel in the generation of their Chart of Accounts, and created worksheets used to integrate their historical data from legacy databases into the new account structure. Guided accounting staff through the revision of corporate process flows to stream line processing within the new financial system. Provided training for personnel in accounts payable, accounts receivable, inventory control, collections, customer service and the system administrator. Assisted Finance personnel with development of Financial Statements using their Management Reporter software. Provided Accounting and Information System personnel support (on-site and remote) during their go live process.Microsoft Dynamics Great Plains 10.0 Financials certification (MB3-528) October 2008

Assist Directors of Accounting, Controllers and Accounting Staffs with preparation financial data for migration to their new financial system software. Responsible for coordinating the analysis of clients existing accounting system, documenting their present financial processes. Revised client’s system discovery documentation to establish parameters and settings for the implementation of their new financial system. Developed, with client management team, financial models needed to reconcile Trial Balances for current and historical years. Assisted the Financial / Accounting personnel in the generation of their Chart of Accounts, and created worksheets used to integrate their historical data from legacy databases into the new account structure. Guided accounting staff through the revision of corporate process flows to stream line processing within the new financial system. Provided training for personnel in accounts payable, accounts receivable, inventory control, collections, customer service and the system administrator. Assisted Finance personnel with development of Financial Statements using their FRx Report Writer and Management Reporter software. Provided Accounting and Information System personnel support (on-site and remote) during their go live process.Microsoft Dynamics Great Plains 10.0 Financials certification (MB3-528) October 2008

TV Magic is a Broadcast Systems integrator providing solutions for companies in the US and Latin AmericaResponsible for all financial reporting for the corporation, financial statements, cash analysis and projections, sales backlog reporting, and operating expense analysis. Interface with financial institutions coordinating cash management of multiple U.S. and Mexican bank accounts which accommodate sales traffic for our Mexican subsidiary. Work with various audit firms (U.S. and Mexican) both public accounting and government tax entities, improving relations and meeting reporting obligations. Developed and implemented a manual Project Cost tracking model to validate project expenditures which could not be monitored through the existing computer system. Manage a finance staff of 4, Operations staff of 4 (including Sales Administration, Purchasing, Logistics and IT) and Human Resources staff of 2. Supervise month-end close processing delegated to finance staff as well as well as intercompany processing with our Latin America subsidiary. Manage the year-end close schedule to ensure timely closing. Interface with Latin America Sales staff regarding credit terms and logistics of all international sales to control cash flow, foreign taxation issues and system/product importation. Developed and implemented new Sales process flows to minimize cash outlays and reduce collection timing. Negotiated new vehicle fleet cost reductions improving monthly cash flow. In addition, assist CEO, Exec GM and Sales Engineers with sales proposal generation and negotiations as required.

Assisted Directors of Accounting, Controllers and Accounting Staffs with preparation financial data for migration to their new financial system software. Responsible for coordinating the analysis of clients existing accounting system, documenting their present financial processes. Revised client’s system discovery documentation to establish parameters and settings for the implementation of their new financial system. Developed, with client management team, financial models needed to reconcile Trial Balances for current and historical years. Assisted the Financial / Accounting personnel in the generation of their Chart of Accounts, and created worksheets used to integrate their historical data from legacy databases into the new account structure. Guided accounting staff through the revision of corporate process flows to stream line processing within the new financial system. Provided training for personnel in accounts payable, accounts receivable, inventory control, collections, customer service and the system administrator. Assisted Finance personnel with development of Financial Statements using their FRx Report Writer software. Provided Accounting and Information System personnel support (on-site and remote) during their go live process.Microsoft Dynamics Great Plains 10.0 Financials certification (MB3-528) October 2008

Developed Audit schedules to support Financial Period-End and Year-End closes. Enhanced Inventory management processes. Coordinated Accounting and Inventory Control cycle counts of Sales Inventory. Generated reports using Crystal Reports and Excel providing management concise Sales and Inventory data to analyze daily operations. Developed numerous financial models used to reconcile trial balance data to the financial system sub-modules. Supported Sales Managers by providing Sales Reports which allowed them to analyze sales trends for their Territories and Salespeople. Created and maintain FRx financial statements while training users on their functionality and how to validate reports against General Ledger. Worked as part of the Due Diligence team to provided audit support data for the sale of Roberts Irrigation Products, Inc to John Deere Corp. Developed and maintain processes for integration of Dynamics GL to Hyperion system used by parent company. Performed other Financial Analysis duties when requested by Controller to support the Finance / Accounting departments. Provided training to accounting and other departmental staff on new system process changes to enhance their individual productivity. Responsibilities as Financial System administrator included the maintenance of the Microsoft Dynamics Great Plains databases to ensure the data integrity, to provide Finance and Accounting support to enhance internal processes, and to assist with development of computer processes. Generated SQL scripts to update system when necessary to correct data input errors and upload new pricing data schedules. Managed database security, trained end users on processes for all modules. Project managed the development of a new Sales Pricing system and deployed in early 2007.

Interim Accounting Manager for multiple companies. Provided oversight for their accounting operations while management personnel were on leave. Monthly Financial Statement preparation for management review. Assisted Finance departments with Audits and other various financial reporting. Managed month-end financial reconciliations for accounting departments, reviewing pre and post close journal entries.Performed financial and software consulting services related to Microsoft Dynamics installations for multiple companies. Implemented process changes in Inventory, Sales Order Processing, Accounts Payable, General Ledger, etc. Developed a variety of ad-hoc data inquiries, using crystal reports, for users and management review.

Accounting ManagerManaged Accounting Staff of 7, for a hardware/software reseller while implementing a Microsoft Dynamics Great Plains financial system. Prepare Monthly Financial Statements and review with Senior Management. Prepare cash forecasts and oversea Logistics management of Sales Order Entry process and Inventory Management. Direct accounting staff in preparation of audit schedules for Year-end and Sales Tax Audits. Direct and review Great Plains Subsidiary module reconciliation’s (Cash Management, Accounts Receivable, Accounts Payable, Inventory) to the General Ledger. Reviewed and approved quarterly tax filings. Project managed corporate process flow documentation to develop desk procedures for all area’s integrating into the Great Plains Financial System. Train Accounting and Logistics staff to handle new Inventory management processes for multiple site Inventories.Financial System ManagerDirected installation and maintenance of the Microsoft Dynamics Great Plains financial system software. Implemented the General Ledger, Sales Order Process, Inventory, Accounts Payable, Accounts Receivable modules, FRx Financial Reporting and Crystal Reports. Established backup procedures for the SLQ Server. Created SQL scripts to correct database problems resulting from either direct or indirect data input errors. Scheduled and executed weekly maintenance routines to ensure integrity of the Financial Data. Maintained system generated Financial Statement report formats. Trained customer service, sales and general accounting staff and provide system support to resolve process errors.

Financial Analysis ManagementReview, analyze and prepare corporate & departmental budgets and forecasts. Develop financial models used to prepare Strategic Planning presentations for senior management and provide Summary and Detail Budget/Forecast data.Review Board of Directors’ financial statement package, SEC filings (10k, 10Q &S8) for accuracy and assist with preparation of MD&A when required. Review financial statement packages prepared by accountant to secure government contracts and grants. Supervise the preparation of tracking worksheets to document cost accumulations. Liaison with Government Accounting Office and Contract Officers to obtain adjustments to contract budgets and reimbursement for Incurred costs.Review Financial Reporting variance analysis of corporate and departmental budgets vs actual reporting.Managed the Accounts Payable staff of 5. Coordinated cash management with VP Finance.Financial Systems AdministratorServed as Project Team Leader for selection and implementation of the Microsoft Dynamics Great Plains financial system. Assisted with implementation of Microsoft Dynamics GP modules including General Ledger, IPOP Purchasing, Inventory, Receiving, Accounts Payable, Accounts Receivable. Created FRx Reporting financial statements and Crystal Reports for Senior Management and Departmental Management review. Implemented new process flows to minimize data entry conflicts in Accounts Payable, Purchasing, Receiving and General Ledger. Developed training procedures to increase staff awareness of system functionality.Managed SQL Server to maintain backups, maintenance schedules and database integrity. Generated Transact SQL Queries against database to resolve database conflicts caused by various department process flow errors. Microsoft SQL Administrator and Database Development courses November 1999Microsoft Visual Basics Development introduction course February 2000

Manager, Corporate Accounting/Financial ReportingSupervised corporate staff of eleven with responsibility for consolidation and analysis of seven divisions. (1987 – 1993)Prepared consolidated monthly financial statements, monthly/quarterly bank reporting. Reviewed monthly staff JE's. Reviewed / prepared Fin. Stmt variance analysis for presentations to Controller and CFO. Reviewed division opportunity results.Interfaced with parent company, division Controllers, department heads and auditors.Supervised special projects for Controller.Assisted with tax provisions calculation, reviewed Bal Sht tax roll forward, established deferred tax liabilities.Financial Analyst – Budget & Profit AnalysisReviewed consolidation support documentation, prepared quaterly Fin. Stmts, developed financial model for consolidation of eight strategic business units.Prepare staff/divisional forecasts, 5 year plans, cash flows and variance analysis.Assisted with acquisition acctg for subsidiary (STARNET Corp) and corporate (Ford Aerospace) acquisitions.General Accounting Manager – STARNET Corporation/International, Inc. (1982 - 1987)Managed accounting operations, general ledger and subsidiary databases. Supervised staff of 10.Prepared monthly/quarterly financial statements. Reviewed monthly JE's. Provided training for general ledger staff.Developed queries to assist reconciliation processes and interfaced with Info System staff to maintain integrity of financial systems.Managed year-end and due diligence audits. Assisted operating departments with departmental budgets. Created procedure manuals for accounting staff functions. Developed asset inventory structure and supervised network asset inventory audits. Created file retention system after subsidiary sale to American Network.Negotiated with vendors to reduce telecommunication liabilities subsequent to sale and supervised the post sale receivables collections process.