Campaign Manager/Data Analyst
Bellsouth Telecommunications / At&T
• Campaign manager for Consumer direct marketing efforts involving multiple channels, responsible for coordination between marketing program managers, vendor managers, and IT• Team Lead of three person group responsible for implementation of direct marketing campaigns using Affinium Campaign (Unica) software• Post-campaign analysis to improve efficiency and effectiveness of Consumer marketing campaigns • ETL development to populate Marketing Datamart with new data elements sourced from Teradata enterprise data warehouse• SQL development for various projects including Customer Lifetime Value, customer segmentation, propensity modeling, and direct contact strategy• Ad-hoc query support for Consumer Marketing department using Teradata enterprise data warehouse• SQL development to execute full cycle of marketing campaigns, including pre-campaign analysis used to determine targeting criteria, creation and delivery of vendor lead files, and back-end analysis to support channels including telemarketing, direct mail, and in-bill media• SQL development of recurring reports and ad-hoc query support for Consumer Marketing, Large Business, Small Business, Legal, Finance, Credit and Collections, eStore, and Internet business groupsTeradata SQL; Teradata utilities (FastExport, FastLoad, MultiLoad, BTEQ); MS Access; Unica