Douglas Devine

About Douglas Devine

With over ten years of experience in data analytics, I am passionate about transforming data into actionable insights that drive business growth and customer satisfaction. My core competencies include data segmentation, analysis, reporting, building data pipelines, and visualization using various tools and techniques such as SQL, Python, Power BI, and Tableau. I am currently a Marketing Data Analyst at Captive Resources, a leading provider of captive insurance services, where I create highly targeted and customized marketing audiences using data from multiple sources.

Experience

1. Marketing Data Analyst

   Captive Resources, LLC

   Dec 2022 — Present · Itasca, IL, US

   Target Audience Segmentation: o Combined data from multiple sources including MiEdge/Zywave, SQL Server, and SugarCRM to create highly targeted and customized marketing audiences o Utilized advanced data analytics techniques to segment audiences based on demographics, behavior, and preferences, optimizing email campaign effectiveness Data Analysis and Reporting: o Utilized Microsoft SQL Server to extract and manipulate large datasets for analysis o Created interactive and visually appealing reports using Power BI to present key insights to stakeholders o Generated detailed marketing performance reports using Excel, highlighting trends and areas for improvement Data Transformation: o Implemented data cleaning and transformation procedures to ensure consistency and accuracy of the extracted data o Employed Pandas for data manipulation, handling missing values, standardizing formats, and resolving inconsistencies across different datasets Data Aggregation and Roll-Up Tables: o Created custom Python functions to aggregate and summarize data based on specific marketing metrics and key performance indicators (KPIs) o Utilized Pandas dataframe operations to aggregate data from different sources, creating comprehensive roll-up tables tailored to the marketing team\'s needs

Education

• Northern Illinois University

  Bachelor of Science, Economics

  2005 — 2008

Skills

• Sql
• Salesforce.com
• Adp Payroll
• Sfdc
• Consulting
• Microsoft Word
• Business Objects
• Java
• Microsoft Office
• Salesforce.com Administration
• Solution Implementation
• Css
• Salesforce.com Implementation
• Access
• Cpq Consulting
• Customer Service
• Excel
• Microsoft Excel
• Project Management
• Training
• Customer Satisfaction
• Sales Process
• Software Implementation
• Html
• Time Management
• Business Development