Douglas Smith Email & Phone Number

New York, United States

• Lead for Company’s migration from Cognos TM1 to IBM planning analytics• Responsible for Administration of Cognos TM1/Planning Analytics & Cognos Analytics supporting the company globally and provide ongoing troubleshooting support for systems/processes• Maintain product, account, customer & all other hierarchies. Update as needed from SAP to TM1 and ensure items are coded properly in SAP and roll into correct hierarchy within TM1. Restructure hierarchies as needed for Sales Regions structure, communicate any issues to correct in SAP• Responsible for extraction of Monthly Sales Trade Spend Data from SAP and scrubbing data, manually adjusting date, assignment, and internal order fields to facilitate proper period analysis• Generate monthly Trade report used by Finance to determine month end accruals• Provide T&E Reporting for all departments; responsible for loading actual expenses from SAP & Concur monthly, analyzing expenses & fix any inconsistencies, generating and sending reports to all budget owners monthly• Provide ad hoc reports & analysis to General Counsel, Sales VPs and their teams for presentations and Board Meetings• Generate reports as needed for Finance team for annual audit, tax paperwork completion, budget and LE preparation• Provide Daily Sales report to Sales VPs and their teams

Queens, Ny

• Provided financial leadership & support to internal and external teams (Field Sales, BOMs, TBTs, RGMs) to support in the delivery of volume and profit plans• Recommended, implemented & maintained financial reporting systems, procedures & controls to ensure timely and accurate tracking & recording of ALB Trade Spend actual vs proper budgets• Established monthly and quarterly financial review meetings with key budget stakeholders for FUZE/NOS brands• Worked as part of team to establish standardized BI reporting templates and workbooks that's consistent across brands• Assisted in the Operating Plan process in SAP for all cost centers including data collection, SAP uploading, monitoring and tracking of plan changes, and final communication to budget owners• Supported end-users with integration of Coke’s systems• Provided ongoing troubleshooting support for systems/processes

• Assisted in designing and implementing OLAP based Trade Promotion Tracking Tool, including reporting design• Tracked trade promotion commitments by bottler, national accounts, expense type and dates. • Worked as part of Finance team during month end processing journal entries, creating reports, analyzing results and highlighting variances• Managed Paychex Payroll system and T&E reporting monthly• Help Desk Support for entire organization

Harrison, Ny

• Responsible for Financial/Sales Systems Administration, Maintenance, Reporting & Troubleshooting for this $500 million coffee division. Work independently to provide accurate data to all departments• Implementation of TM1 OLAP System for Sales Forecasting & Budgets forecasting system, enabling company to generate real-time customer, brand and SKU forecasted P&L’s• Maintain and Administration of all TM1 Servers on a daily basis• Assisted in design, testing and implementation of in-house forecasting system, enabling company to generate real-time customer, brand and SKU forecasted P&L’s• Educated field sales on accessing systems for P&L management (product mix, factory absorption) and syndicated data analysis, resulting in more accurate planning and financial results.• Conceptualized and implemented new in-house trade deal and deduction system, including the establishment of new procedures to ensure all liabilities are recorded accurately and timely• Perform forecast analysis including validating volume and pricing by major customers. Review forecast by comparing to syndicated data trends, identify opportunities or risk based on market conditions or planned marketing programs• Perform data into TM1 from many sources for forecast analysis including validating volume and pricing by major customers. Review forecast by comparing to syndicated data trends, identify opportunities or risk based on market conditions or planned marketing programs• Provide Technical assistance in quarterly Business reviews with Executive Team and Field Sales managers

• Desktop support at all levels to 100+ Windows NT/98 workstations.• Restructure and migrate clients and resources out of NetWare to 100% NT network.• Plan, purchase and implement roll out of new desktop and laptop Computers Company wide.• Setup NT Servers and configure TCP/IP and DNS on DHCP and WINS Server.• Setup, configure and maintain NDS on multiple Clustered Novell 4.x Servers.• Setup and support Bloomberg financial terminals on NT workstations.• Provide trading floor support for municipal bond tracking management system.• Import market data into SQL database from many sources.• Analyze market data and create detailed reports.• GroupWise, Exchange, FaxServe administration and maintenance.• Troubleshoot remote access with Netware Connects and PC Anywhere.• Hands-on training and helpdesk support for all applications Company wide.• Install, configure & manage hubs, switches, csu/dsu and firewall.• Manage software upgrades and patches.• Setup and Configure Outlook and GroupWise Email Clients.• Backup entire network using ArcserveIT and Backup Exec.• Setup Novell and NT Print Servers.• Scheduled maintenance of LaserJet, Inkjet and Dot matrix printers.• Troubleshoot Toshiba Strata DK424 phone system and escalate problems to vendor.• Install, configure and maintain firmware revisions on sonic firewall.• Troubleshoot Internet connections problems on T1, DSL, and Frame relay circuits and escalate to provider.• Deployment for Y2k compliance on all hardware and software.