Ryan Rocks Email & Phone Number

San Francisco, California, United States

Consulted with partners to identify and define business requirements and translate marketing needs into technical solutions.• Utilizing multiple databases, supported the design of complex marketing and lead campaigns across multiple distribution channels (email, phone, ATM, on-line, direct mail).• Supported Merchant Services transition to Strategic Segments, enabling standardization across campaigns.• Developed new campaigns and managed existing campaigns using Unica Campaign.• Engaged with Marketing Partners to determine audience selection and test strategies.• Queried customer and prospect databases using Teradata Studio.• Formatted files for multi-channel delivery using Unica Campaign.• Uploaded data to campaign history using Unica Campaign.

Developed new campaigns and updated existing campaigns for Wells Fargo utilizing Unica Campaign. Engaged with Marketing Partners to determine audience selection and test strategies.• Queried customer and prospect databases using Teradata Studio.• Formatted files for multi-channel delivery using SAS or Unica Campaign.• Uploaded data to campaign history using SAS or Unica Campaign.

Lee'S Summit, Mo

Build direct mail campaigns using IBM Campaign.QC campaign data using SQL Server Management Studio.Maintain and update marketing reports.Prepare ad-hoc analysis.

Tampa/St. Petersburg, Florida Area

Execute the Customer Programs Marketing Plan by creating and qc'ing mail file extracts, managing source code assignments and activations, and coordinating with Creative, Production, Systems, and external vendors to ensure that all deadlines are met. Support testing and integration of new programs and products to achieve sales and test objectives. • Build direct mail, email, and telesales campaigns using IBM Campaign / Unica software.• Manage over 2,500 source code assignments and activations, key to accurate test results, and meeting our $91mm sales objective.• Maintain, update, process and review direct mail extracts for accuracy. • Create and distribute output matrices for AARP Customer Programs. • Support Member Services inquiries related to the implementation of AARP Programs.• Responsible for projection of test quantities.• Provide data processing/letter shop instruction to our internet team and print vendors.Key accomplishments in the Marketing Associate role:• Developed an Access template, which allowed source codes for our largest campaign to be uploaded in less than half the time and with more accuracy than the manual method.• Developed an Access macro that allowed output matrices to be created in one-third of the time of the manual method.• Managed the Marketing Intern in the digital QC project, enabling increased work efficiency and productivity.• Identified a pre-existing condition that allowed customers who changed their billing mode to receive conflicting premium quotes, and implemented a database quality control procedure to resolve it.

Tampa/St. Petersburg, Florida Area

Manage the AARP Life Weekly Reports Package that supports NY Direct Marketing’s strategic planning requirements. Develop processes around the business user’s needs to help them better understand the results of various marketing efforts. Work with business users to make changes and provide ad hoc reports as requested. Used advanced Excel skills to produce ad hoc reports. • Update the following weekly reports: AARP, AARP Admin, Customer Program A Pages, Blue and White, Paid Rate, and Inbound Service Upsell.• Responsible for new AARP Direct Mail, Internet, and DRTV reporting to support Tranzact testing.• Analyze user data to assist in creation of targeted marketing campaigns.