Analyst

Jamison Queen

**** ***** ***

Cincinnati, OH ****7

Mobile – 513-***-****

Email – *************@*****.***

WORK EXPERIENCE

Ste Michelle Wine Estates – 2022-present

Category Development Manager, Kroger Team. 2022-present, (Cincinnati, OH)

Call on Kroger GO with Kroger Team Director providing a category and shopper insights perspective leveraging Kroger and syndicated data. Developed total category new item tracking report in partnership with SGWS and Kroger providing performance metrics covering retail, market, and shopper. Provide internal/external After Action Reviews for key retail initiatives and programming. Assist 4 field Account Executives with Kroger retail, market, and shopper analysis and insights for their sales’ calls. Part of project team to transition reporting to Microsoft Power BI environment.

Molson Coors – 2011-2022

Category Manager, Kroger Team. 2011-April 2022, (Cincinnati, OH)

Call on Kroger buyers in partnership with Molson Coors NSEs. Provide category insights and opportunities to Kroger buyers while helping them define and execute their strategy. Leverage myriad data sources(IRi Suite(Execution(Market 6), Unify(syndicated market), Consumer Insights(84.51), Numerator, Numerator Panel data, Spectra to synthesize category centric opportunities and identify risks. Developed Kroger Feature Tool for Kroger that allows them to evaluate their feature strategy with timely(day after ad week close) data. Developed Total Category display and OOS reporting customized for action at multiple internal/external levels. Master Data Management process for team that drives all reporting. Special Project calling on King Soopers as they prepared for full strength beer conversion. Working with corporate IT as we transition to a Hadoop data environment that will allow us to better store our data for actionable reporting.

Kellogg Company - 2005-2011

Manager, Business Planning – Field Sales, Kroger Team. 2009-2011, (Cincinnati, OH)

Support the 17 Kroger Division Account Execs, 2 Sales Managers, and Sales Director through actionable reporting that enables them to better execute our promotional plans. Key reports include: Daily Sales covering all business, Display Validation Report, DSD Out of Stock report, Retail Scan report displaying weekly Kroger division retail sales at the Morning Foods item and Snacks type level. Facilitate the Kroger field IBP call process that is rolled up and compared to the Kroger total team call. Ad-hoc reporting that may require Nielsen, Kellogg’s SAP Business Warehouse, Kroger dunnhumby, and Kroger KCMS data sources. Assigned Annual GSV Budgets for the 20 Kroger Divisions by Kellogg Category.

Sr. Business Development Analyst, Kroger Team Snacks. 2007-2009, (Cincinnati, OH)

Work with national account executives to target optimal promotions that result in win-win results for Kellogg and Kroger. Perform post-analysis to determine success of promotion. Forecasted all product and maintained base and active items within SAP’s CRM module. Created daily sales report that gives field sales account specific detail that isn’t available through HQ reporting. Created Display Execution tracking report that leverages store level display audits provided to Kroger via 3rd party. Ad-hoc SAP Business Warehouse and BEx reporting. Consult on general technical issues and Microsoft Office expertise.

Business Solutions Analyst, Walmart Team. 2006-2007, (Bentonville, AR)

Provided business solutions for category management and sales departments on the Wal-Mart account. Identified and implemented increased efficiency opportunities. Managed/modified ETL process for data warehouse: this involved extracting Retail Link data and several in-house data sources; transforming data into import files, much of this was automated through batch and VBA programming; importing files into metadata tables and data tables. Managed cube build process – we used DME Crunch software with a SQL Server backend. Verified that the cube builds were successful and did post build quality analysis. Worked on team to implement new JDA Intactix Knowledge Base Category Advisor solution. Assisted Sr. Category Growth Managers with assortment analysis, new item performance analysis, and planograms using JDA Space Planning software. Developed/maintained front-end solutions using VS.NET, MS Access, and MS Excel. Maintained WM team intranet website. Automated reporting through batch and VBA programming. Ad-hoc analysis.

Retail Sales Representative, Walmart Account. 2005-2006, (Evansville, IN)

Managed account for 38 Wal-Mart Supercenter stores located in Southern Indiana, Western Kentucky, and Southeastern Illinois. Suggested display opportunities to Wal-Mart grocery and store managers. Ensured full distribution for Kellogg products. Worked with Kellogg’s Snacks TMs, DMs, and MMO to present and sell in Power of K events such as character appearances and NASCAR simulators. Communicated Kellogg performance to Store Managers and Dept. Managers. Improved store promotional execution.

Qwest Communications - 2001-2005, (Denver, CO)

Sr. Financial/Business Analyst, Corporate FP&A. 2004-2005

Developed MS Access(SQL Server backend) reporting tool as well as Crystal Reports for Qwest Legal department that provided functionality not available in their case tracking software(CaseTrack). Developed/maintained period/quarter/annual financial reporting tool that provided internal and external financial reporting. Process was automated and also produced an Adobe pdf deck (extensive VBA). Worked on team to transition corporate standard financial reports to more robust WebFOCUS based solution. Business Objects reporting. FOCUS reporting. Ad-hoc analysis.

Financial/Business Analyst, Procurement FP&A. 2003-2004

Developed/maintained MS Access reporting tool that provided lower level transactional data than was available through the corporate reporting tools. Developed/maintained MS Excel financial reports (OLAP cube interface) for Qwest Procurement. Managed Procurement’s PC/Software budget and inventory for about 400 employees. FOCUS report development and maintenance. Ad-hoc analysis.

Buyer, Procurement. 2002-2003

Developed MS Access and Excel applications(SQL Server and Oracle backends) to add functionality not available to the buyers through purchasing systems. Purchased IT hardware/software using PeopleSoft and ORBIT(proprietary system). Worked on multiple projects for different business units within procurement. Ad-hoc analysis.

Data Analyst/Programmer, Job Store Staffing – Qwest Contract. 2001-2002

Developed MS Access and Excel applications (extensive VBA) as part of the Procurement Dept project team. First project was focused on consolidating multiple purchasing systems (JDEdwards, PeopleSoft, and 3 proprietary systems). Performed ad-hoc SQL queries and data analysis. Second project was focused on implementing new contractor procurement and payment system.

TECHNICAL EXPERIENCE

Languages

Big Data

Web

Programming

RDBMS/ERP/DFS

BI Reporting

VB

R

HTML

MS Access

Tableau

C++

Python

VBScript

Oracle

MS PowerBI

COBOL

Fortran

Hadoop

Databricks

JavaScript

ASP

SQL Server

PeopleSoft

MS PowerPivot/Query

SAP/Biz Objects/BW/BEx

PROFESSIONAL TRAINING

Nielsen training. Answers, Nitro. Multiple sessions live/online.

JDA Space Planning

IRi reporting and analysis, multiple sessions. IRi CPGN. IRi Unify and BevAlc Kroger Shopper Insights.

dunnhumby training, multiple sessions.

MillerCoors Chain Academies(Space/Assortment, Profitable Beer Marketing, Customer Marketing)

Kellogg’s CatMan 101 (category review process, category analysis, IRi, dunnhumby)

Advanced MS Access, New Horizons. Application design, user interface, macro automation, VBA.

Intermediate/Advanced MS Excel, New Horizons. Working with multiple worksheets, protection, consolidating data, advanced formulas, macros(VBA), sorting, filtering, pivot tables, charts.

Crystal Reports, New Horizons. Connecting to data sources. Building queries. Reporting.

Tableau

EDUCATION

B.B.A., Marshall University

AACSB Accredited

Major: Management Information Systems

Computer Science coursework: 24 credit hours

Contact this candidate