Patrick G. Dittmann, Mba Email & Phone Number

New York, Ny, Us

Elizabeth, New Jersey, Us

Manage end-to-end process from program and goal entry to reporting, reconciling, and calculating payouts. Serve as point of contact for related inquiries and issues.• Partnered with commercial finance team to assist with the development of a budgeting dashboard to track ongoing incentive spend vs LY. • Designed SOND executive dashboard to track financial targets and earnings for key initiatives. Output is easy-to-read visual charts vs hundreds of lines of data.• Built comprehensive Sipsource reporting tool for comparing ABG vs state performance. Insights include uncovering where ABG is gaining/losing share and category trends.• Consolidated fragmented Core Objectives (CO) reporting by creating one unified, streamlined, and semi-automated tool resulting in the elimination of multiple steps.• Implemented a structured CO process flow to promote consistency, facilitate training, minimize errors, and allow management to better understand the process holistically.• Leveraged MS SharePoint to create shared incentive Excel files which eliminated saving/emailing multiple copies of files and allows for one single version of the truth.

Elizabeth, New Jersey, Us

Developed and delivered KPI dashboards and reports to the executive team, key management, and sales force. Created routine and ad hoc goal trackers to support strategic initiatives.• Created inventory trackers for portfolio managers and operations team to help track promotional items and the customers who are entitled to them.• Created a SKU allocation dashboard for the executive team which automated the product reserves process and improved turnaround time by 80%.

Basking Ridge, New Jersey, Us

Analyzed and monitored all advertising campaigns. Mining of marketing data including paid search, Search Engine Optimization (SEO), call tracking, mobile ads, and direct mail.• Constructed a KPI dashboard that traced leads from six ad sources. Its multi-level structure provided a high-level aggregate view that cascaded down to granular data.• Created a budgeting dashboard for the finance team that tracked monthly costs and summarized overages/shortages (vs allocations) for each marketing spend category.• Developed operationally-driven Excel-based reports and KPI dashboards relating to labor, productivity, and delivery service times.• Leveraged MS Teams to create recorded sessions with screen sharing and commentary to train marketing team and provide a resource to after contact ended.• Identified geographical and ad campaign trends which allowed the marketing team to optimize advertising spend better allocate resources.

Published and managed reports relating to sales, financial incentives, pricing, and inventory depletions on an ongoing basis. • Identified and fixed a major flaw in the Retail Incentive Payment (RIP) program that was costing ≈$78,420 annually. Projected ten-year savings amount to ≈$¾ million.• Standardized and automated category management data-cleansing procedure for 31 Shoprite locations. Data sets ranged from 1,000 to 3,000 lines per store. Development of Excel-based macros resulted in a 20% reduction in processing time.• Partnered with top retailers by developing an open-to-buy plan Excel template that aggregated RIP deals, order history, and POS data from customer scorecards and supplier/vendor portals to optimize buying and minimize excess inventory.

Provided periodic financial reporting relating to transportation costs, transit times, and delivery performance. Managed daily dispatch plan for 29 drivers in the Tri State area.• Uncovered an ongoing occurrence of internal theft. Shrink equated to ≈$182,700 over a five-year period. Loss prevention procedures were implemented as a result.• Crafted a dashboard which provided data-driven statistics of route profitability and payroll hours which allowed management to create a strategy to reduce overtime.

Managed daily dispatch plan for the north and central Jersey areas. Processed daily delivery invoices in AS400 by reconciling returns and entering payments on accounts.• Used Roadnet Transportation Suite software to create and manage daily (300-750 stops) dispatch plan within the NJ region for internal delivery fleet of 29.• Developed standard operating procedures (SOPs) and introduced the use of MS Excel to create reports from data exported from AS400 and Roadnet.

Master Of Business Administration - Mba

Bachelor Of Arts In Business Administration (B.A.B.A.), Business Administration, Management And Operations