Robert Entwistle Email and Phone Number

Responsible for the enablement of global financial and business operations, and providing short-term and long-term financial planning, reporting, analysis and insights to the CEO, CFO, and all matrixed and line of business managers.

Integrate FP&A skills with finance systems management and process improvement to provide dependable, timely financial and business operations information to leadership. - Create annual company budgets, tri-annual reforecasts, and annual 5-year long-range plans.- Develop and present monthly financial reporting and analysis package to management and HQ. - Prepare and present all financial information, analysis, and commentary directly to CEO for bi-monthly presentations to Board of Directors and ensure understanding of information provided.- Financial modeling- Expert in Excel, Access, and VBA (macro). Applied skills in automating and improving processes, reports, GL entries and data imports resulting in hundreds of labor hours saved per year. - Implemented and managed a multi-currency consolidation module in Planful application complete with data integration to create a single view of Leadiant’s five global companies. - Manage consultants and third-party vendors for system upgrades, maintenance, support, software subscriptions, contracts, licenses, and invoicing.- Perform all financial system administration and enhancements in Microsoft Dynamics SL, Planful, ExpenseWatch, Concur Invoice and Harvest. Ensure consistent data across systems, develop and deliver end user training, support users, and create and maintain associated documentation.

90% travel. Work directly with clients (primarily Fortune 1000 companies) to configure and implement custom Consolidation and Corporate Performance Management (CPM) solutions using Longview programming logic and custom user interfaces. Perform system upgrades and modernizations. Work independently or leading a team to meet deadlines according to project plan. Provide documentation, direction, and mentoring to customer and transition new processes. Consolidation system configuration including foreign exchange and cumulative-translation-adjustment, intercompany eliminations, hierarchy structures, attributes, user and group security, KPI calculations, allocations, rollovers, workflow, and import processes (including mappings, automated email notifications, error handling).Created capital planning module calculating each projected additional long-term Asset’s impact on the Trial Balance, accurately predicting changes in fixed assets, accumulated depreciation, accumulated amortization, depreciation and amortization expenses, and CAPEX cash flow impacts. Also tracks spending, reconciling budgeted spend vs. updated forecast spending for assets classified as capital in progress (CIP) and incorporates an approval process from FP&A.Created rent planning module that allows users to plan rent by location to calculate the resulting expense and the impact to the Balance Sheet. Calculations also store results in granular detail outside the Trial Balance to facilitate reporting by location, by rent expense sub account.Created complex dynamic model for large cable services provider where changes in accounts trigger changes in other accounts. For example, if the forecasted number of new customers increases, a calculation occurs that increases the number of installers required in the workforce. An increase in the workforce would require an increase in compensation, headcount, etc. while at the same time increase forecasted revenue.

2010-2011:Corporate Real Estate Finance. Responsible for accounting, budgeting, and forecasting ~$342M in annual rent expense, and reporting functions for all domestic company-owned and leased locations.2010: Khalix Forecast and Budget System Adminstrator. Hyperion Planning System implementation team member. 2006-2010:Operating Expense Reporting and Analysis. 2005-2006:Khalix Developer for Expense Forecast & Budget Systems

Ensured audit compliance for settlement, handheld computer, and inventory processes in existing chilled-beverage sales centers.• Trained over 30 managers on software applications, reporting techniques, analysis, variance reconciliation, inventory management, and cost-cutting • Presented handheld, settlement, and policies and procedures information to 200 sales representatives and evaluated training progress of employees• Provided on-site change support at 8 East coast and Midwest locations