Nancy Sparks

Project Manager for the Accounting Systems Implementation at Peerless Coffee & Tea
  • Claim this Profile
Contact Information
Location
Benicia, California, United States, US

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
You need to have a working account to view this content.

Credentials

  • Adaptive Planning and Reporting
    Adaptive Insights
    Nov, 2014
    - Sep, 2024
  • Certified Public Accountant (Inactive)
    State of California

Experience

    • United States
    • Food and Beverage Services
    • 1 - 100 Employee
    • Project Manager for the Accounting Systems Implementation
      • May 2015 - Present

      • Responsible for all aspects of Systems conversion to Microsoft Dynamics Great Plains and SalesPad. • Prepared legacy data for import to Great Plains (Customers, Vendors, Inventory). • Developed strategy for complex pricing structure implementation in SalesPad in coordination with Peerless staff. Prepared data using extracts from existing system and Microsoft Access database for testing. • Gathered requirements and implemented additional modules including ShipCenter, DataCollection and Equipment Management. • Designed data warehouse as data source for SSRS reporting. • Specified reporting strategy and coordinated with outside programmers to design and create SSRS reports for management and salespeople. Developed schedules for automated delivery of monthly report distribution. • Provide first level support for all systems in organization. • Primary interface with 3rd party software vendors. Show less

    • United States
    • Wireless Services
    • 1 - 100 Employee
    • Interim Controller
      • Jan 2015 - Apr 2015
    • United States
    • Beverage Manufacturing
    • 100 - 200 Employee
    • Interim CFO
      • Aug 2012 - Apr 2014

      • Responsible for all corporate finance functions including P&L, cash flow management, debt management, audit & tax reporting, 409A analysis, and commercial banking relationships.• Implemented Adaptive Insights for budgeting and forecasting for multiple business lines, utilizing cubes, sheets, and assumptions.• Designed and created financial statements from Adaptive Insights for consolidated reporting.• Primary liaison with valuation experts for acquisition accounting of multiple entities. Show less

    • Controller
      • Jan 2012 - Aug 2012

      • Prepared monthly consolidated financial statements using multiple systems.• Identified and implemented process improvements for Oracle functionality not previously implemented correctly.• Interfaced with IT department for process improvement design and implementation.• Lead multiple technically challenging special projects using multiple data sources and large amounts of data.• Implemented functionality and reporting in SalesForce to track collections efforts.

    • United States
    • Maritime Transportation
    • 700 & Above Employee
    • Project Manager - Accounting System Conversion
      • Nov 2006 - May 2011

      • Prepared Request For Proposal documenting system requirements.• Coordinated with Oracle Implementation staff for system requirements by Oracle ledger and operating unit.• Reviewed and approved all configuration documentation for adequacy.• Extracted general ledger and vendor data from legacy system for import to new system.• Documented all required financial reports by entity.• Created all mapping of legacy financial reports to new reporting system.• Phase 1 – Coordinated with IT department and tested all financial reports.• Phase 2 and 3 – Designed and tested all financial reports using Oracle Financial Statement Generator (FSG). Show less

    • Interim Accounting Manager
      • Feb 2007 - Apr 2008

      • Supervised professional Accounting staff including review of accounting reconciliations and entries.• Oversaw cash transfers and accounting for funding of large payroll and benefit plans.• Created procedures and processes for accounting manager function.• Interviewed and assisted with selection of permanent Accounting Manager.• Prepared monthly and quarterly financial statements.• Planned and coordinated the annual audit for 5 benefit plan entities.• Coordinated all financial information with outside agency for Annual Report for entire organization. Show less

    • Internal Controls Documentation Project
      • Nov 2006 - Feb 2007

      • Documented internal controls using flowcharts and control matrices for all accounting functions including General Ledger, Revenue, Accounts Payable, Fixed Assets, and Treasury.• Documented the 17 accounting ledgers by type and functionality including intercompany relationships and cash movement.• Documented all other systems used in the organization and how they interface with the general ledger.• Created new procedures for processing weekly payroll processing including significantly more extensive review and control of the entire process of funding millions of dollars in weekly payroll. Show less

    • United States
    • IT Services and IT Consulting
    • Project Manager - Accounting System Conversion
      • Oct 2000 - Jun 2006

      • Managed all aspects of accounting conversion to Great Plains for US, UK and Australia offices, hiring 3rd party consultants in other countries as well as Great Plains consultants in US to complete required implementations. • Managed all module implementations as well as provided on-going support to accounting staff after module implementation completed. • Modules implemented included standard functions as well as enhanced functionality for AR (Collections Management), AP (Expense Reporting, eRequisition) as well as Multi-Currency, Intercompany and more. • Project lead for the Accounting Department for the integration of Sales Logix with Great Plains for customer, inventory and sales orders including integrating invoice and payment data back to Sales Logix. • Designed and implemented Crystal Reports for Finance Department. • Technical and accounting support for datamart project, data collection, and financial reporting. • Redesigned FRx reporting structure for entire organization by reorganizing reports and specification sets by functional currency and organization. • Prepared various analysis and reconciliations for 10Q and Investor Relations department. Show less

    • United States
    • Banking
    • 200 - 300 Employee
    • Interim Manager of Portfolio Operations
      • Mar 2000 - Oct 2000

      • Manager of Portfolio Operations Department which included all on-balance sheet items (Advances/Loans, Deposits, Bonds). • Review and supervision of staff of 8 professionals. • Review of daily work, releasing investment and swap payment wires, review of monthly certifications and reports. • Prepared testing plan for off-balance sheet items (swaps) to adequately document testing for conversion to new software. • Manager of Portfolio Operations Department which included all on-balance sheet items (Advances/Loans, Deposits, Bonds). • Review and supervision of staff of 8 professionals. • Review of daily work, releasing investment and swap payment wires, review of monthly certifications and reports. • Prepared testing plan for off-balance sheet items (swaps) to adequately document testing for conversion to new software.

    • Interim Internal Auditor
      • Jun 1992 - Sep 1999

      Two separate consulting projects, 1992 to 1994 and 1996 to 1999 • Performed Year 2000 review of test plans and results for adequacy and completeness. • Performed final reviews for all issued reports from the Internal Audit department for quality control purposes. • Performed audits, prepared findings reports, and completed audit committee packages. • Supervised and evaluated Internal Audit staff members. • Assisted new Internal Audit Director with departmental planning. • Trained staff on various departmental functions including maintenance of the Cost of Funds Index and Timekeeping databases. Developed documentation for both databases and enhanced reporting capabilities. • Completed policies and procedures manual for Internal Audit Department, which allowed Audit Director to meet his personal annual goal. Show less

    • United States
    • Financial Services
    • Vice President, Controller
      • Feb 1992 - Sep 1992

      • Supervised accounting staff and responsible for all accounting functions including cash management, Board reporting, Call Reports, and SEC filings. • Prepared tax returns for Civic Bank and Civic BanCorp. • Responsible for the accounting department’s portion of the bankwide computer system conversion. • Prepared projections for purchase of mortgage servicing company. • Supervised accounting staff and responsible for all accounting functions including cash management, Board reporting, Call Reports, and SEC filings. • Prepared tax returns for Civic Bank and Civic BanCorp. • Responsible for the accounting department’s portion of the bankwide computer system conversion. • Prepared projections for purchase of mortgage servicing company.

    • United States
    • Financial Services
    • 700 & Above Employee
    • Business Unit Consultant
      • Nov 1990 - Jan 1991

      • Assigned to business unit management for real estate and mergers and acquisitions. • Assigned to business unit management for real estate and mergers and acquisitions.

    • Supervising Senior Auditor
      • Sep 1986 - Nov 1990

      • Clients included financial institutions, retailers, and property developers. • Coordinated all aspects of audit from planning, supervising staff, interfacing with clients to completion of audit report and review of SEC filings. • Clients included financial institutions, retailers, and property developers. • Coordinated all aspects of audit from planning, supervising staff, interfacing with clients to completion of audit report and review of SEC filings.

Education

  • California State University-Hayward - School of Business and Economics
    Bachelor's Degree, Business Administration, Accounting Option
    1982 - 1986

Community

You need to have a working account to view this content. Click here to join now