John Patterson Email & Phone Number

Cleveland, Oh

Primary analytic resource for assigned account executives and divisional VPs. Led three analysts, providing sales, shipment, and other ad hoc analysis for Drug and Dollar Channel retailers and numerous specialty retailers. Provided loyalty portal metrics for select retailers in Cognos, MS Excel, SAS Enterprise Guide data environment. • Directed analysts to conduct and enhance standard weekly / monthly reporting and analysis and provided direction to successfully manage assigned retailers by studying trends within other channels and competition.• Monitored business to determine appropriate analyses to address retailer-specific strategic business questions.• Performed analyses for strategically important projects such as CVS exit inventory projections, seasonal “No Scrap” cost / benefit projections, hurricane sales loss impacts, and summer temps card reporting. • Developed annual Joint Business Plans, aligning American Greetings sales expectations with those of the retailer.

Cleveland, Oh

Supported sales teams as dedicated analytic support for Kmart ($110M annually) and Shopko ($27M) retail chains. • Served as department lead for cross-retailer Everyday Card and Seasonal Card reporting and additional high-visibility analyses for senior leadership.• Provided standardized and ad hoc reporting of sales trends, promotional sales, sell-through, and comparison of card department to all-commodities volume (ACV) at store, category, season, program, and price point levels.• Conducted pre / post-test analysis aimed at measuring the effectiveness of marketing programs, product placements, in-store presentation, and store conversions.

Hudson, Oh

Primary business intelligence / analytic resource for all department subdivisions. Led team of four analysts, providing marketing support to merchandising, finance, and IT in complex MS Excel, Access, SAP, SQL and MicroStrategy Business Intelligence data environment.• Directed standard reporting workflow for ad / promotional planning, digital marketing, and CRM marketing analysts and maintained ad hoc analytic queue to meet marketing manager needs.• Conducted “what if” scenarios for coupon strategy, analyzing sales and margin impact of promo calendar changes.• Maintained 26M member customer database, responsible for data integrity, contact strategies and reporting and analysis for direct mail, e-mail, and affinity loyalty programs, with program expense of $25M.• Coordinated $80M department budget in conjunction with the finance department.

Highland Hills, Oh

Worked in household reporting group specializing in creating standardized reports to summarize customer behavior at a household (HH)-level across all product lines; DB2, SAS, SQL data environment.• Measured all HH, open HH, closed HH, returning HH, and HH static pools across the following lines: Checking, Savings, CD, IRA, Credit Card, Installment Loans, Lines of Credit, Mortgages, Investments.• Utilized key statistics including household growth, cross-sell, retention, attrition, tenure, efficiency ratio, net income before tax in order to categorize households by market, profitability index, and age-income. • Built HH reporting data mart for Mid-America Bank acquisition, enabling integration into National City Datamart.

Hudson, Oh

Key business intelligence / analytic resource for all departments within the marketing division. Led two analysts with general business analysis and customer database analytic responsibilities. • Conducted market selection, test design, and analysis of in-market tests aimed at determining effectiveness of direct marketing programs, newspaper inserts, and other promotional vehicles. • Utilized multiple data sources to facilitate weekly sales, monthly marketing, and quarterly merchant reviews.• Maintained customer database (12M members) and coordinated marketing department budget ($70M).

Hudson, Ohio

Led a team of five associates, responsible for computerized in-store product display and managed SAP listing function, enabling replenishment of all sku-store listing conditions, SAP store assignments, and site productivity analysis.• Directed employee workflow and planogram, shelf label, and digital imaging processes.• Provided business analysis functions for VP, Merchandising Information Organization.• Designed, tested, and validated conversion of merchandising reports during implementation of SAP Retail.

Ms, Statistics

Mba, Graduate School Of Management

Bs, Applied Math/Statistics

High School Diploma