Accounts Payable Receivable

DEAN E. ANDERSON

**** ******** *****, *********, ** 92056 760-***-**** (Cell)

***********@*****.***

OBJECTIVE

To secure a position in Finance/Accounting or Information Systems supporting client Accounting and IT Departments. I have worked with numerous groups to reconcile their control documents. Recently performing installations and enhancements of the Microsoft Dynamics Great Plains and Microsoft D365 Business Central software.

PROFESSIONAL EXPERIENCE

Dynamics GP Sr. Functional & Business Central Support Carlsbad, CA

PIRCH, Inc 12/2021 to 12/2023

Provide Dynamics Great Plains (GP) Support to users within functional areas of the company including Directors of Accounting/Finance, Logistics, Controller and Accounting Managers in Accounts Receivable (AR), Accounts Payable (AP), Purchasing, Finance, Inventory control (IC).

Work with preparation of financial and operational data for migration to their new financial system software Microsoft D365 Business Central (BC).

Reviewed SOP documentation to confirm existing modifications to Dynamics GP standards and then compare to BC processes.

Assisted users with their Dynamics GP support cases as they occurred providing detailed explanations on why their present integrations with CRM to GP were miss leading or confusing the end user. Also, provided detailed explanations as to how to correct the issues to allow posting.

Worked with multiple ad hoc applications built in-house to provide workflow representations of the Dynamics GP data. Some of the applications were solely for use by Store Sales and Customer Services. Others were used to process data in a means that the GP system could not accommodate.

Worked with developers to understand integrations already implemented and those presently in the development database. Worked with the Development Manager to offload some of his workload regarding database corrections to allow AR users to post invoicing hung in the system.

Provided training for personnel in finance, AR, AP, IC to increase their understanding of the volume of integrations in the Pirch system and the impact on the GP and CRM environments.

Dynamics GP Sr. Functional & Business Central Consultant Solana Beach, CA Columbus Global US / Tridea Partners 2/2016 to 8/2021

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 clients with their prior system process 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 streamline processing within the new financial system. Provided training for personnel in finance, 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 or other reporting software.

Provided Accounting and Information System personnel support (on-site and remote) during their go live process.

Provided support to existing Dynamics GP customers who were experiencing new module errors, required new user additions, data integrity assistance, process development and new module implementations as required.

a.)EFT for Payables d.) Integration Manager

b.)EFT for Receivables e.) SmartConnect

c.)Safe Pay f.) Smart List

GP Application Solutions Consultant Oceanside, CA

Negotium Technologies-US 1/2013 to 2/2016

Prepare clients for the implementation of their new Dynamics GP 2013 Financial Systems or assisting with service pack updates or upgrades to GP 2013R2, GP2015 and GP2015R2.

Assist clients with financial system discovery processes & system configuration analysis to detail their unique corporate requirements. Work with client management teams to revise corporate process flows to streamline processing within the new financial system.

Provide client support for development of Integrations to either import historical legacy data or daily process integrations for General Ledger and Accounts Payable.

Implemented multiple financial modules for clients including Professional Services Tools Library, Rapid Start Configuration tool, Safe Pay, EFT for Payables, new company creations, Encore Account Reconciler/Auto Reconciler, Fixed Assets and general core Dynamics GP modules.

Assist clients with development of Financial Reporting using FRx and Management Reporter 2012.

Train client system administrators on the System configuration processes, security, and sub module setups.

Train end users on the process flows for the Dynamics Great Plains core modules including:

oSystems Management System Security,

oGeneral Ledger Bank Reconciliation,

oReceivables Management Sales Order Processing,

oPayables Management Purchasing,

oReceiving Management Inventory Control,

oPayroll Manufacturing processing

Along with a variety of third-party application software.

Develop process and training documents for client use during Go Live and day to day operations.

CFO San Diego, CA

TV Magic, Inc. 10/2009 to 12/2012

Responsible 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 proposal negotiations, 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 as required.

Dynamics GP Solutions Consultant Oceanside, CA

Strophe America, Inc. 10/2007 to 03/2009

Prepared clients for the implementation of their new Financial System. Assisted clients with financial system discovery processes & system configuration analysis. Worked with client management team to revise corporate process flows to streamline processing within the new financial system. Installed Microsoft SQL Server and Dynamics Great Plains software and established system setups based on the discovery parameters. Trained client system administrator on the System configuration processes, security, and sub module setups. Assisted the Financial / Accounting personnel in the development of worksheets which were used to integrate their historical data, from legacy databases to Dynamics tables using the Microsoft Dynamics Integration Manager tool.

Trained end users on the process flows for the Dynamics Great Plains modules. Modules included:

oSystems Management System Security,

oGeneral Ledger Bank Reconciliation,

oReceivables Management Sales Order Processing,

oPayables Management Purchasing,

oReceiving Management Inventory Control,

oPayroll Manufacturing processing

and a variety of third-party application software.

Provided system and financial support (on-site and remote) during go live process. Provided support for development of Financial Reports with their FRx Report Writer software. Assisted Corporate office with Customer Support cases as needed.

Microsoft Dynamics Great Plains 10.0 Financials certification (MB3-528) October 2008

Financial System Administrator San Marcos, CA

John Deere Water Technologies 09/2002 to 10/2007

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.

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.

Dynamics Great Plains Software / Accounting Consultant Oceanside, CA

Dean E Anderson Consulting / Robert Half Technology 11/2001 to 09/2002

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.

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.

Financial Systems / Accounting Manager San Diego, CA

Star Solutions, Inc. 04/2000 to 11/2001

Financial System Manager

Directed 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.

Accounting Manager

Managed 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.

Mgr Financial Analysis & Fin. Sys Administrator Carlsbad, CA

ISIS Pharmaceuticals, Inc. 04/1993 to 03/2000

Financial Systems Administrator

Served 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, and 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 1999.

Microsoft Visual Basics Development introduction course, February 2000.

Financial Analysis Management

Review, 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.

Corporate Accounting Manager Newport Beach, CA

Loral Aerospace/Ford Aerospace 03/1982 to 04/1993

Manager, Corporate Accounting/Financial Reporting

Supervised corporate staff of eleven with responsibility for consolidation and analysis of seven divisions and four subsidiaries. (1987 – 1993)

Responsibilities included consolidation of monthly financial statements and monthly/quarterly bank reporting. Coordinated external reporting with financial analysis staff. Reviewed monthly journal entries. Reviewed / prepared financial statement variance analysis for presentations to Controller and Chief Financial Officer. Reviewed division opportunity results. Interfaced with parent company management, division Controllers, department heads and internal/external auditors.

Coordinated development of general ledger and financial reporting database structures for a Dun & Bradstreet MD2 general ledger system.

Managed corporate and division general ledgers, including account analysis reviews.

Supervised special projects for Controller. Interfaced with corporate tax department to calculate tax provisions, review balance sheet tax account roll forward analysis and establishment of deferred tax liabilities.

Financial Analyst – Budget and Profit Analysis

Interfaced between finance & accounting departments during monthly financial closing.

Reviewed consolidation support documentation, assisted with preparation of quarterly financial statements and developed financial model for consolidation of eight strategic business units.

Prepare and assist with review of staff/divisional forecasts, 5-year plans, cash flows and variance analysis.

Assisted with acquisition accounting for subsidiary (STARNET Corp) and corporate (Ford Aerospace) acquisitions.

General Accounting Manager – STARNET Corporation/International, Inc. (1982 - 1987)

Managed the day-to-day accounting operations, general ledger and subsidiary databases. Supervising an accounting staff of 10.

Prepared and analyzed monthly and quarterly financial statements. Reviewed monthly journal entries. Provided training for the general ledger staff.

Developed system query reports to assist reconciliation processes and interfaced with Information System staff to maintain integrity of financial systems.

Managed year-end and due diligence audits. Assisted operating departments with the preparation of departmental budgets.

Created procedure manuals for accounting staff functions. Developed asset inventory structure and supervised network asset inventory audits. Created file retention system tracking after subsidiary sale to American Network.

Negotiated with vendors to reduce telecommunication liabilities after the sale of STARNET Corporation and supervised the post-sale receivables collections process.

Accounting Manager San Diego, CA

Howard Equipment Corp. 06/1981 to 03/1982

Accounting Manager San Diego, CA

San Diego U-Drive 02/1978 to 06/1981

Accounting Manager San Diego, CA

Commercial Press, Inc. 04/1976 to 01/1978

Bookkeeper San Diego, CA

Camera World, Inc. 06/1975 to 04/1976

United States Navy 01/1969 to 01/1973

EDUCATION

National University San Diego, CA

Bachelor of Science, Computer Information Systems June 1982

Minor in Accounting, California State University Northridge

Votex Training Center San Diego, CA

Microsoft SQL Administrator and Database Development courses, November 1999.

Microsoft Visual Basics Development introduction course, February 2000.

Prometric Testing Center Carlsbad, CA

Microsoft Dynamics Great Plains 10.0 Financials certification (MB3-528) October 2008

REFERENCES

References and letters of recommendation will be provided upon request.

Contact this candidate