Robert Cooke Email & Phone Number

Sacramento, Ca, Us

Sacramento, Ca, Us

Mansfield, Massachusetts, Us

• Vendor Rebate Budget Management: Managed a nine figure vendor rebate budget across multiple buying group channels, overseeing 1,000+ custom rebate programs to ensure alignment with financial and strategic objectives• Vendor Rebate Forecasting: Developed and implemented forecasting methodologies for vendor rebates, incorporating sensitivity analysis across various spend scenarios to assess their impact on EBITDA across 11 divisions all using different ERPs• Power BI Reporting & Optimization: Developed Power BI reports for super users to identify vendor spend shifting opportunities, enabling the organization to optimize rebate strategies and maximize savings• Rebate Tracking Tool Development: Developed a corporate rebate input tool to capture key data for tracking vendor rebates against purchase invoices. Partnered with the Data as a Service team to create a canonical model across multiple ERPs, harmonizing data to track custom rebates by vendor, item, and end customer

Mansfield, Massachusetts, Us

• Inventory Oversight: Managed inventory valued between $50M - $70M, ensuring optimal stock levels across the supply chain• DIO Reduction: Successfully reduced Days Inventory Outstanding (DIO) from 75 to 45 days through targeted sales incentives, inventory balancing, and proactive identification of slow-moving inventory• Inventory Optimization: Rationalized product assortment across three distribution centers and eleven retail locations, improving inventory efficiency and reducing excess stock.• Inventory Control & Reporting: Led the development and management of inventory control reporting, key performance metrics, cost control plans, and inventory improvement initiatives using Power BI• Demand Planning Tool Development: Developed and implemented a Power BI-based demand planning tool, enhancing forecasting accuracy and inventory alignment with sales trends• Returns Management: Established and managed a high-performing returns team, ensuring timely vendor returns and effective inventory balancing across the network• Business Support: Provided data-driven insights and presented findings to process owners and senior management to support strategic business initiatives• Audit Oversight: Directed physical inventory audits, cycle counts, ad-hoc audits, and reconciliations to ensure accuracy and compliance with inventory policies

Mansfield, Massachusetts, Us

• Data Engineering and Analysis: Developed ongoing profitability datasets in Alteryx, uncovering insights that drove a YoY EBITDA increase• Profitability Consulting: Led the sales portfolio review process, managing a schedule that included meetings with over 50 sales reps to ensure continuous performance evaluation and effective action tracking utilizing Smartsheet to optimize profitability• Category and Customer Profitability Analysis: Analyzed category and customer profitability, translating findings into actionable recommendations for sales and project teams• Trend Identification and Reporting: Created and maintained Alteryx models to highlight key trends and opportunities, driving division-wide profitability improvements• Strategic Support and Financial Analysis: Conducted pricing analysis, financial reviews, account deep-dives, and category assessments to inform strategic decisions

Port Washington, New York, Us

• Budget & Forecasting Management: Led the design, management, and forecasting of a nine figure annual budget for pricing and trade programs, ensuring alignment with business goals• R&O Adjustments & Financial Reporting: Provided monthly Risk & Opportunity (R&O) adjustments and mid-period financial bridges to senior leadership, offering insights on program impacts• Accrual Accounting & Reconciliations: Managed accrual accounting adjustments to ensure accurate monthly and quarterly financial reconciliations in line with company policy and trade strategies• Expense Analysis & Postmortem Evaluations: Utilized PowerPivot and SAP to analyze periodic expenses and perform detailed postmortem evaluations of promotional activities, special pricing, and discount strategies, delivering granular insights to inform future decisions

Port Washington, New York, Us

Port Washington, New York, Us

Port Washington, New York, Us

Rancho Santa Fe, California, Us

• Automated start to finish invoice processes with MS Excel using VBA, Macros, data validation tools, tables, power queries, and complex formulas.• Customized Bullhorn CRM database by integrating database with large amounts of contact information from existing job platforms, such as LinkedIn.• Performed mass data cleaning in Bullhorn CRM.• Rebuilt existing Daily Field Reports in Google Sheets used for monthly labor and expense documentation for over 100 employees.• Developed Sales Dashboard to highlight key organizational KPI’s and their monthly changes.

• Assist president with coordinating officer and general meeting times/locations.• Contact and coordinate with guest speakers to present to club members.• Delegate and oversee tasks of other officers.

San Diego, Ca, Us

La Jolla, Ca, Us