Ryan Powers Email & Phone Number

Responsible for maintaining and coordinating data across multiple database environments for over 40 million unique customers.Oversee analytic work conducted at external marketing vendor, loyalty program management vendor, and internal resources.Leverage and maintain Customer Behavioral Segments, Customer Lifetime Value, and Attrition modeling in order to increase effectiveness of CRM.Monitor customer trends including segment migration, retention, and sales.Execute ad hoc data queries to support CRM campaigns, customer segmentation projects and rewards program. Partner with CRM manager to provide ROI and ROAS analysis for all CRM marketing campaigns and make recommendations for new test or rollout offers to management

Develop tracking and analysis of campaign performance across retail and web channels for CRM activity in Direct Mail, Email and Mobile. Provide reporting and insights on customer behavior and trends in order to maximize effectiveness of targeted campaigns in driving sales and customer engagement.Use Campaign Management tool in order to generate targeted customer lists for marketing efforts.Oversaw building and migration of existing marketing database into a new custom database environment Responsible for integrating new data sources into marketing database

Responsible for reporting and analyzing customer loyalty card dataPerformed data analytics of strategic marketing and merchandising initiatives as well as store level customer profiling.Create and maintain ad hoc and ongoing reports employed across several organizational departments using internal data and external syndicated data. Collaborated with representatives across departments to develop reports to fulfill business needs.

Performed promotional forecasting using sales data and history of retail price point and AD placement.Responsible for maintaining a 95.0% or greater raw service level and 97.0% or greater base service level.Responsible for inventory management of all assigned categories. Scope includes left over ad, disc liability, short coded, dead and excess inventories.Worked with the wholesaler procurement and demand planning associates to assure adequate inventory and excellent service level for sales programs.Management of system generated or manual store product distributions.

Developed reports on sales, inventory and market conditions based on internal and external data to assist Category Manager with strategic category planning. Cordinated the introduction and removal of SKUs in over 300 retail locations including but not limited to updating plan-o-grams, removal of discontinued items, and ordering of new items.Responsible for proofing of weekly print advertisements to ensure correct pricing, images, and copy.Assist store managers and employees with any category related issues.