Colin Sullivan Email & Phone Number

Philadelphia, PA, US

Philadelphia, Pennsylvania, United States

Wilmington, Delaware, United States

• Assisted with website management via data reporting and working with SEO professionals; data was accessed in Looker and used from Google Analytics and Google Search Console
• Created multi-step triggers in email journeys to automate html blasts in Constant Contact
• Drafted emails that are to be crafted via html and sent out to leads and consumers
• Developed and supported Kalmar Nyckel Foundation’s social media marketing plan with a calendar system for posting on Facebook and Instagram while coming up with engaging copy and information on events
• Pitched sales deals for various venues around Wilmington

Philadelphia, Pennsylvania, United States

• Designed a specialized code that fostered integration of R programming into SQL code using Qlik Sense and RStudio
• Forecasted future prices for more than 30 different types of clothing fabric via predictive modeling and used ggplot2 in R to visualize the findings
• Pulled data from clouds such as Snowflake, Bamboo Rose, and BlueCherry for querying
• Interpreted data into various visualizations such as regression plots, combined pivot charts, containers, and other KPIs using Qlik Sense and Qlik Cloud
• Constructed dashboards to show Brand Operations data for Free People

New York, New York, United States

• Used Nielsen data to identify trends comparing ratings and other information such as consumer data or ad spending
• Constructed variable importance plots to assess relationships between different categories of website data relative to how many email subscribers that were gained online
• Competitive analysis: FOX Weather website and app traffic vs. weather sites such as Weather.com and WeatherBug
• Tabulated user data from websites and social media using Adobe Analytics and analyzed trends
• Researched and compared FOX News app content vs. key competitors (CNN, NBC, New York Times) with data from Comscore, Shareablee, SensorTower, and Emplifi and provided insights using data visualization on Excel
• Assessed social media data for Outkick and competing sports platforms Barstool and Sports Illustrated using Comscore, Shareablee, and Emplifi

Philadelphia, Pennsylvania, United States

• Performed QA on Salesforce emails utilizing functions such as applying double opt-ins, confirming with compliance, scanning recipients, inspecting CTA
• Optimized email marketing campaigns using Admaster
• Compiled Salesforce data, including open rates, minutes engaged, unique clicks, and click to open ratios
• Identified patterns in surveys and developed a sentiment analysis from responses
• Managed composition and revisions of ESG Newsletters

Philadelphia, Pennsylvania, United States

• Ran AB tests and used behavioral segmentation based on user data to gain stronger insights on ways to reach out to email audiences
• Gained nearly 100 leads through event marketing, survey generation, social media marketing campaigns, and telemarketing
• Implemented campaigns using HubSpot and brought open rate up to 46.6%, click rate up to 2.5%, and CTR up to 5.3%
• Came up with ways to implement cost effective email marketing campaigns, generate leads, and retain consumer interest
• Promoted and advertised the company digitally via social media campaigns using the platforms Twitter, Facebook, LinkedIn, and Instagram --> increased followers by over 100, doubled Twitter and Facebook impressions

Wilmington, Delaware, United States

• Internship for The Warehouse:
• Conducted virtual program participant research
• Created, administered, and tabulated survey data that impacted program improvements
• Designed video campaigns to encourage quarantining during the Coronavirus pandemic

Business Analytics And Marketing, Business Administration And Management, 3.8 Gpa

Activities and Societies: Delta Sigma Pi Professional Fraternity, Alpha Phi Omega Community Service Fraternity, American Marketing.

Education record

Activities and Societies: Cross Country, Indoor Track, Tennis, Symphonic Band, FUUCW Youth Group, Page at Woodlawn Library

Edge Summer Program, Entrepreneurial And Small Business Operations