John Mattern Email & Phone Number

Omaha, Ne, Us

Omaha, Nebraska, United States

Greater Omaha Area

Overseeing all internal sales analytics in multiple food categories.Responsible for the administration of all finished goods forecasting for 3 operating companies.Overseeing inventory management for several different locations.

Greater Omaha Area

Member of Group Sales Operations Support team responsible for on-going Group Sales analysis and reporting.• Manage monthly, quarterly and yearly goals for sales office, property and citywide sales at both the property and salesperson level.• Use Microsoft Access to reference and build queries out of dozens of tables to maintain and create Microsoft Excel reports for use by Sales Office and Property personnel.• Did data analysis to determine effectiveness of Sales Office personnel… Show more Member of Group Sales Operations Support team responsible for on-going Group Sales analysis and reporting.• Manage monthly, quarterly and yearly goals for sales office, property and citywide sales at both the property and salesperson level.• Use Microsoft Access to reference and build queries out of dozens of tables to maintain and create Microsoft Excel reports for use by Sales Office and Property personnel.• Did data analysis to determine effectiveness of Sales Office personnel, who sold into 96 Marriott banner hotels in northeast United States. Major markets include Boston, New York City and Philadelphia. Worked closely with Directors and Leaders in creating ad hoc reports.• Extensive use of pivot tables, pivot charts and tables linked into Access queries for easy updating. Show less

Greater Omaha Area

Managed six people, most of whom worked at least some of the time in the field, working closely with store personnel and brokers to implement schematics and to use data in order to increase sales for company and retailer.Developed a hierarchy to be able to process and analyze large amounts of data from many disparate sources in a highly competitive CPG environment. Used this data in development of sales materials and store schematic rankings to help ensure maximization of sales. Worked… Show more Managed six people, most of whom worked at least some of the time in the field, working closely with store personnel and brokers to implement schematics and to use data in order to increase sales for company and retailer.Developed a hierarchy to be able to process and analyze large amounts of data from many disparate sources in a highly competitive CPG environment. Used this data in development of sales materials and store schematic rankings to help ensure maximization of sales. Worked closely with outside sales personnel to give them any materials they may have needed for prospective new business and maintenance of current business. Worked with and traveled to present at most of the major national accounts.Developed and maintained company pro forma system that mirrored the internal accounting system to analyze all potential business profitability potential.This system took into account all costs of doing business and weighted all items according to sales velocity in order to predict the profit outcome for each account.Developed an internal forecast system when management decided to go to a "by-item, by customer" system as opposed to a single number for each item. Company would normally be maintaining around 500 items that would have to be looked at monthly, so my system streamlined the process. Worked closely with purchasing department during development and ongoing maintenance of program. Show less