Kc Smith Email and Phone Number

• Responsible for writing Seasonal Candy orders to achieve category sales, units, profit dollars and growth objectives for assigned divisions.• Collaborated with Kroger divisions to understand division specific goals and merchandising plans and ensured they were met for each season.• Helped institute and develop the Regional Candy Team. Streamlined the order writing process by creating better alignment across the Kroger enterprise. Established the team as a trusted source among the divisions.• Served as Subject Matter Expert on the Seasonal Candy program for assigned divisions by analyzing division data and working collaboratively with division teams• Reviewed and communicated information to divisions including: category results, trends, market share, and targets.• Improved and updated reporting processes to provide more relevant, simplified reports with increased efficiency and accuracy

• Developed and maintained a Tableau Weekly Digital Dashboard to provide key performance indicators to executive leadership• Performed Data Profiling and Data Quality• Developed expertise in SQL Server, Alteryx, Tableau and digital analytics tools such as Adobe Analytics, Pentaho/YouTech and Google Analytics• Experienced with various data warehousing tools and concepts• Compiled and interpreted data for ad-hoc analysis requests • Measured the success of on-going digital programs and events• Analyzed metrics in order to identify cause-effect relationships between marketed actions and outcomes• Worked closely with the Big Data Services team to validate data from new sources and ensure that data models were developed in line with department standards and guidelines• Performed market basket analysis on transaction level data to determine which products are most frequently purchased by customers• Created customer segmentation indexes that visualized how specific groups of customers are segmented in comparison to a control group• Worked closely with project managers and subject matter experts in planning and developing methods for data collection, storage and analysis

• Compiled and interpreted data from multiple sources for on-going analysis on targeted direct mail and in store corporate promotions.• Provided training and documentation on how to use various tools and how to perform data analysis for other analysts within the company• Became proficient in pulling data from a variety of sources including raw transaction log data, the Enterprise Data Warehouse, Hadoop and internal tools• Simplified the promotions post analysis process using Microsoft SQL Server• Identified trends and results by period using Kroger, IRI, and Nielsen insights and data to compile summary notes for company leadership

• Performed post analysis on in store promotions• Learned how to analyze sales activities, marketing campaigns, customers and pricing• Learned effective time management, listening, communication and business writing skills• Developed strong communication, project management, organizational and analytical skills• Developed a good understanding of raw Kroger data sets• Created pre and post analysis reports projecting ad performance• Became proficient in pulling and manipulating data from a variety of sources