Making Franklin Sports data driven.

Act as player/coach for B2C and retail dot com digital marketing efforts which includes planning, execution and measurement of the Franklin Sports digital strategy. Some days involve white boarding customer journey optimization strategies with marketing analysts. Some days involve walking through Python code w/ a data engineer to ensure we pull the correct data elements from the AdWords API. Some days are spent personally writing SQL/DAX/R code to evaluate various CPC bid modification opportunities. No project is too big or too small.

Advise on topics related to analytics for the John E. Simon School Of Business.

Hands on data manipulation experience across various "customer addressable" communication channels including but not limited to email marketing (Listrak), in store retail shopper data (RetailNext), customer loyalty data (Clutch) and high level web analytics (Rawlings.com - Google Analytics). OLS and Multivariate regression model building to understand various retail trends including but not limited to - impact of precipitation on foot traffic, relationship of foot traffic versus revenue, and impact of Google Adwords spend on foot traffic increasesTools in play - Excel (Pivot Tables, PowerPivot, PowerQuery), Tableau, IBM Cognos (developer side report studio and user side Cubes), SQL server 2012, Import.io and R.

:: Retail POS Data Warehouse: Managed the migration of 50MM+ POS records across 7 retailers from third party provider (SPS) to internal data warehouse in collaboration with multiple functional departments (ETL, EDI, Sales, Product). Developed weekly financial dashboards from POS records to understand "heartbeat" of the business for C Suite inside company BI tool and Power Pivot. Through Microsoft Power Map, created location based heat maps & 3D bar graph visualizations to assist sell in process with major retailers. Standardized product dimension attributes across 7 retailers into a singular definition. ::Guided "market saturation" analysis with Jr. analyst which uncovered $2MM of incorrect assortment decisions. Synced 4 other sales channels zip code level sales data against larger POS database. :: Financial Planning: Establish top line financial targets with VP, Retail Sales to align with strategic corporate initiatives. :: Sales Planning: Along side National Account Managers (NAM) and Account Executives (AE) build sales plans by division/account that align with financial targets. Optimize account sales, turns, margins, and profitability.

:: Oversee all sales operations and analytics needs necessary to Catalog Internet customers (Amazon.com, Eastbay, Rawlings Gear):: Redesigned the sales operations order fulfillment process between Rawlings & Groupon to achieve +2% OTD rate while automating a large portion of daily tactical work.

:: Authored reporting solutions for Sales History, Sales Planning, Demand Planning, Inventory, and Purchase Order Tracking:: Implementation of pricing programs across $350M organization:: Developed OTD scorecard driving a 3% incremental boost to on time shipments:: Helped define and implement customer segment strategy for $30M brand:: Expanded use of CRM software (Salesforce.com) to new Sales Groups:: Administered training for Cognos, Excel, and JDE for 100+ users

Division: IT Audit