Data Analyst Business Intelligence

Omaha, NE • 402-***-**** • ************@*****.*** • www.linkedin.com/in/johnpmattern

Data Analyst Profile

Detail-oriented professional with a track record of achievement in transforming complex datasets into revenue-driving insights to enhance operational performance and financial forecasting. Adept at identifying process inefficiencies, optimizing data ecosystems, and developing scalable analytics frameworks to improve accuracy, streamline decision-making, and improve business intelligence. Recognized for navigating complexity, enhancing visibility into key performance indicators, and delivering actionable solutions.

Trusted advisor to executive leaders, adept at delivering data-backed recommendations to shape corporate strategy, mitigate risks, and drive operational excellence. Relentless in pursuit of efficiency and precision and unlocking hidden value within financial and operational data. Competent at operating in executive-facing settings and delivering real-time insights to align analytics with business priorities and accelerate data-driven transformation.

Data Analysis & Visualization • Forecasting & Financial Analysis • Inventory & Demand Planning • Sales & Performance Reporting

Process Improvement & Automation • Production Scheduling & Supply Chain Management • Cross-functional Collaboration

Database Development

Extensive Root Cause Analysis

Led the entire scope of inventory management in a Dynamics 365 Business Central environment, including creating item and customer databases and overseeing inventory transfers between company-owned and third-party facilities.

Key Stakeholder Engagement

Profit & Revenue Growth

Improved visibility into key revenue drivers and sales team effectiveness across major markets, including Boston, New York City, and Philadelphia by developing account-based reports and dashboards.

Oriental Trading Company Omaha, NE

2023 to 2025

Inventory and Demand Planning Manager

Led seven inventory specialists in overseeing thousands of SKUs across global vendor networks. Improved efficiency in purchasing and inventory management for $500M+ e-commerce and retail operation. Optimized cross-functional reporting related to marketing, sourcing, demand planning, transportation, finance, and senior leadership.

Reduced reporting turnaround time by 24 hours by revitalizing reporting processes, including rebuilding outdated systems and enabling faster access to raw data.

Provided real-time visibility into inventory levels, shipping delays, and overseas stock movements by developing in-stock reporting from scratch.

Spearheaded a transition project to Oracle ERP, including training teams on system functionalities and integrating purchasing, receiving, cost management, and reporting workflows.

Delivered hands-on leadership to seasoned and new employees through challenging over-inventory period to prioritize purchases and ensure effective management of open-to-buy dollars.

Hugo Specialty Foods Omaha, NE

2019 to 2023

Data Analytics-Forecast Manager

Planned and established a data analytics function for a fast-growing startup to provide data-driven insights. Built the company’s first analytics infrastructure by integrating data from five disparate sources into standardized Access databases for extensive analysis and reporting. Developed forecasting models by using historical sales trends and collaborating with sales teams to refine projections.

Enabled growth by scaling pie production from 460K to 1.1M units while supporting a diverse portfolio of specialty food products.

Created automated POS data reporting by leveraging pivot tables and dashboards to analyze sales velocity, profit margins, and product shrinkage across multiple retailers.

Maximized revenue potential by leading integration of cross-product sales strategies for grocery retailers and identifying synergies between specialty food brands.

Marriott International Omaha, NE

2014 to 2019

Manager, Business Analysis

Oversaw data-focused sales performance tracking and reporting for 112 Marriott properties and a 160-person sales team across U.S. markets to ensure accuracy in revenue reporting and compensation eligibility for Group Sales teams. Partnered with senior leaders and sales directors to improve reporting precision, identify data gaps, and develop actionable insights.

Ensured 100% accuracy for incentive compensation by managing sales performance goals and revenue tracking across monthly, quarterly, and annual periods.

Developed advanced reporting tools in Microsoft Access and Excel by leveraging queries, pivot tables, and linked tables to automate and streamline sales performance tracking.

Maintained cleaner and reliable datasets for business decisions by managing data validation efforts and identifying inconsistencies and gaps in corporate reporting systems.

Verified revenue data, enhanced reporting accuracy, and strengthened cross-functional partnerships by collaborating with sales and marketing directors across properties.

Sergeant’s Pet Products Omaha, NE

2013 to 2014

Director, Retail Operations

Transformed data and analytics practices by modernizing reporting from paper-based to digital systems and delivering granular insights in a highly competitive retail landscape. Partnered with diverse teams to drive data-informed decisions on product placement, margins, and distribution. Directed six team members across headquarters and field operations to ensure seamless execution of retail strategies.

Drove substantial sales growth for both Sergeant’s and key retail partners by developing and implementing planograms through sales data to optimize shelf placement.

Secured expanded product distribution and maintained stronger retail partnerships by preparing and presenting data-driven recommendations to senior decision-makers at major retail accounts.

Enhanced retail analytics capabilities by revitalizing complex reporting processes and improving insight into sales performance, margins, and competitive positioning.

EARLY EXPERIENCE

Sergeant’s Pet Products Omaha, NE

Marketing Director, Analytics

Promoted data-driven decision-making by transforming raw market data into actionable insights for cross-functional teams. Developed a product rationalization platform by integrating financial and sales metrics to ensure SKUs meet profitability benchmarks. Deployed COG reporting to analyze bills of materials and accounting practices. Partnered with retail and sales teams and presented market intelligence to position Sergeant’s as a trusted industry expert.

Strengthened retailer partnerships and improved profitability by developing a proprietary database to standardize and enhance reporting.

Enabled seamless integration of sales data from IRI, Nielsen, and retailer-specific sources by creating and deploying a proprietary database of 100K UPCs.

Optimized financial performance across product lines by developing a pro forma accounting system to analyze profitability at the item level and enhance sales teams’ visibility into pricing, margins, and customer allowances.

Supported strategic assortment decisions and drove sales growth by designing an opportunity gap analysis tool to facilitate retailers in comparing product mixes against competitors.

ADDITIONAL EXPERIENCE

Consultant - Tevra Pet Products

District Supervisor – Douglas County Election Commission

EDUCATION

Bachelor of Arts in Business Administration, Finance - University of Nebraska

TECHNICAL SKILLS

Pivot Tables, Power Query, Macros, MS Access, Tableau, MS Dynamics 365, Oracle, AS400, Retail Link, IRI, Nielsen

John Mattern

CAREER HIGHLIGHTS

PROFESSIONAL EXPERIENCE

Streamlined purchase order tracking for 10K+ open POs to ensure accurate receipt tracking and cost management.

Audited open orders for receiving errors and discrepancies and used Oracle to fix issues.

Developed company wide financial tool to improve margins and profitability.

Built user friendly demand planning tools used by sales and purchasing that improved inventory levels and account visibility.

Contact this candidate