Unica Campaign & Oracle SQL Analytics Consultant

HONOR M. STANTON

**********@*****.*** 978-***-**** Foxborough, MA

Summary

Seasoned Unica Campaign and Data Analytics Consultant with 20+ years of experience leading enterprise marketing operations, customer communications, and advanced reporting initiatives. Proven expertise in HCL Unica campaign design and execution, Oracle SQL analytics, and multi-channel marketing delivery across complex data environments. Adept at building scalable workflow automation, enforcing rigorous QA standards, and developing executive dashboards and KPI frameworks that drive strategic decision-making. Extensive experience supporting high-volume organizations in telecommunications, financial services, and retail industries.

Skills

Attention to Detail

Time Management

Project Coordination

Workflow Prioritization

Critical Decision-Making

Process Improvement Mindset

Customer Segmentation

Oracle SQL Development

Advanced Excel Analytics

Campaign QA & Validation

Marketing Automation Systems

Business Intelligence Reporting

Experience

01/2012 - Current

Pinpoint Systems, Inc

Consultant

Spearheaded end-to-end execution of multi-channel marketing campaigns (email, direct mail, digital, and billing), supporting enterprise clients such as Shutterfly, Home Shopping Network, Time Warner Cable, and Charter Communications.

Engineered advanced audience segmentation strategies using complex Oracle SQL queries, improving targeting precision and campaign effectiveness across large customer datasets.

Designed and implemented robust quality assurance frameworks, reducing deployment errors and ensuring accuracy for high-volume customer communications.

Developed and maintained campaign tracking infrastructures, including log tables for contract history, audit trails, and longitudinal performance analysis.

Automated recurring reporting and campaign workflows, significantly enhancing operational efficiency, consistency, and on-time delivery of marketing initiatives.

11/2010 - 01/2012

Putnam Investments, Inc

Boston, MA

Sr. Campaign Business Systems Analyst

Led enterprise-wide support and implementation of HCL Unica Campaign and NetInsight, ensuring seamless configuration, testing, and ongoing platform optimization.

Designed and deployed SQL-driven campaign workflows and extraction logic, enabling high-volume, data-driven marketing initiatives across diverse investment product lines.

Automated recurring campaign processes and reporting deliverables, improving operational efficiency and reducing manual effort across marketing operations.

Translated complex business requirements into scalable technical solutions by collaborating closely with stakeholders, ensuring alignment between campaign strategy and system execution.

Executed comprehensive campaign QA and validation processes, identifying and resolving data inconsistencies, logic errors, and output discrepancies prior to production release.

11/2009 - 09/2011

Harte-Hanks, Inc

Billerica, MA

Sr. Business Systems Analyst

Conducted in-depth campaign performance analysis to enhance audience targeting strategies and improve segmentation accuracy for retail marketing clients.

Designed and executed complex HCL Unica campaign logic aligned with client objectives, supporting both recurring and time-sensitive marketing initiatives.

Developed comprehensive campaign documentation and analytical reports to support internal process optimization and external client communication.

Resolved technical and operational issues across campaign execution cycles, reducing delays, minimizing risk, and improving delivery reliability.

Partnered with marketing leadership teams to identify new campaign opportunities and refine execution strategies based on historical performance insights.

07/2007 - 11/2009

Epsilon, Inc

Wakefield, MA

Business Systems Analyst II

Developed and executed HCL Unica Affinium campaigns supporting large-scale financial services initiatives, including credit card marketing programs for Bank of America across multiple customer segments.

Designed, optimized, and maintained complex SQL queries for campaign selection, testing, validation, and post-campaign analysis in high-volume data environments.

Delivered on-site training and ongoing technical support to client teams, improving adoption of campaign tools and ensuring consistent execution standards.

Created comprehensive process and workflow documentation, detailing data dependencies, campaign logic, and system enhancements to support operational continuity.

Produced detailed campaign performance reports using Business Objects and Excel, enabling data-driven insights into future targeting and optimization strategies.

01/2001 - 01/2007

Putnam Investments, Inc

Andover, MA

Analytical Systems Sr. Analyst

Led the design and delivery of database-driven reporting solutions supporting marketing, sales, and advanced analytics across enterprise business functions.

Developed executive-level dashboards and performance reports using Business Objects, Crystal Reports, and Hyperion BRIO to support strategic decision-making.

Built, optimized, and maintained Oracle and MS Access databases used for recurring reporting, analytical modeling, and campaign operations.

Partnered with business stakeholders to gather requirements and translate complex business needs into scalable technical system designs.

Managed full software development lifecycle (SDLC) activities, including system design, development, testing, documentation, and production deployment.

Education

2007

Burlington, MA

Bachelor of Science in Executive Business Management

Bay Path College

Certifications & Licenses

Certificate in Client Server Programming and Web Development Clark University Braintree, MA 2000

to 2001

Certificate in Computer Applications Computer Ed Institute Brockton, MA 1993 to 1994

#HRJ#ddec0fcf-1839-4a52-828d-8fcd0943aab4#

Contact this candidate