Market Cost Envelope Intern
As an intern with Kodak working with senior managers, I analyzed marketing spend and provided tools that not only streamlined reporting processes but also improved future marketing strategy planning for Consumer Digital Group, and used statistical technique to help understand the correlation between marketing spend and category brand awareness and sales for future development of marketing ROI metrics.
·Analyzed marketing costs and performance of all product lines from 2007 to 2008 in Consumer Digital Imaging Group. With results, evaluated the effectiveness of the category marketing strategy implementations and presented comprehensive analytical reports to senior management that would drastically improve future market planning.
·Streamlined managerial reporting process for marketing costs by standardizing and automating input data, which reduced the time required for data consolidation from over 5 days to 1.5 hour.
·Analyzed impact of media advertising investments on sales and market share with multiple regressions and presented written report that assisted senior management in evaluating marketing ROI.
·Compiled internal financial data and external benchmarking report; presented findings to inform managers of company’s status and future trends to assist with adjusting strategies and reallocating company resources.
·Designed an analytic marketing funnel tool that facilitated product group managers with understanding the impact changes in category brand awareness preferences and more tightly linking marketing objectives to future sales goals.
·Reconciled system generated marketing cost reports with manual reports of first and second quarter that substantiated the correctness and reliability of system reports for future reporting usage.