Wallingford, Connecticut, United States
Integrate MDR educational data into the Snowflake data marketplace for sale and distribution to customers. Designed and implemented the relational database and staged the data for loading from AWS S3 buckets.
Designed multi-channel marketing platform allowing customers to manage lists, content, and campaigns for email, social, and display advertising. Retrieve campaign metrics from online platforms using API calls. Power BI dashboard allowing customers to evaluate and act on response KPI's. Designed and implemented email BI data warehouse, consolidating 15 years of deployment history. Analyzes result trends over time using Tableau visualizations, allowing decision making to optimize deliverability and inbox placement. Maximize email deliverability by enforcing best practices, ensure effective list cleanse, and assisting customers with email domain authentication.
Email repository in SQL Server, allowing for email list generation, cleansing, personalization, and tracking of deliverability, frequency, and response. Actively used by marketing, editorial, and customer service departments for prospecting, renewals, and nurturing.
Designed and implemented the Postal Sorting and Reporting System for magazine business. Captured magazine components, weights, and calipers. Utilized United Sates Postal Service standards and regulation files. Prepared customer fulfillment files to maximize postal discounts.