Post Job Free

Resume

Sign in

Systems Analyst Business

Location:
Whitinsville, MA
Salary:
85,000
Posted:
February 16, 2024

Contact this candidate

Resume:

Zachary J. Hochmuth

**A Millbury Ave D***

Millbury, MA 01527

508-***-****

ad3omi@r.postjobfree.com

Creative, analytical thinker, capable of developing innovative approaches to leveraging customer data and continuously improving marketing strategies.

Employment Experience:

Epsilon Waltham, MA

Sr Business Systems Analyst Jan 2020-Current

•Lead documentation and review of all business requirements, data needs, and business rules in requirements documents (BRD)

•Creating data flows and marketing through Unica campaign tool and IBM Campaign

•Analyzed data quality and provide recommendation for changes

•Created traceability of all business requirements to functional and non-functional specifications to cover data exchange, warehouse/mart processing, business rules, and end user use cases (campaigns, reports, and analytics)

•Drive product fitment analysis versus gap areas and create specifications for those

•Performed complete and accurate source to target mapping and API specifications including end points, authentication and encryption methods.

•Developed quality checks and reports to ensure that systems are performing appropriately (Weekly reports)

•Identified and communicate areas to improve the overall marketing processes

•Reporting of EM campaigns through SQL

•Analysis of financial data and results

•Creation and pull advanced Adhoc/Trigger-based lists within Campaign management tool

Pluris Marketing Framingham, MA

Marketing Analyst Jan 2018-2020

•Analyzed systems, marketing data and reports to identify and help resolve discrepancies

•Creating campaign targeting and marketing flows through Unica campaign tool

•Analyzed and interpreted marketing data to identify trends, patterns and relationships. Develop and present recommendations to improve results

•Documented the client’s business requirements and work with the Client Services team to create a technical/functional specifications document to execute on

•Developed quality checks and reports to ensure that systems are performing appropriately

•Identified and communicate areas to improve the overall marketing processes

•Created customized reporting of DM/EM/LOC campaigns through Business Objects software

•Created and pull advanced Adhoc/Trigger-based lists within Campaign management tool

CVS Health Woonsocket, RI

Data Advisor, BSS Team Sep 2016 –November 2018

•Manipulated data tools for targeting, including Campaign Relationship Management (CRM) system and Relational Database Management System to produce data files.

•Creation of campaign marketing flows through Unica campaign tool

•Collaborated with business partners to vet data requests, explore options, and design solutions.

•Developed and maintained procedures and queries necessary to prepare data, based on targeting requirements.

•Developed and implemented quality-assurance checks for implementations, start-finish, and provided recommendations of corrective actions when appropriate.

•Lead project management activities for new implementations and development.

Sr Consultant, Campaign Targeting Nov 2013-Sep 2016

•Manipulated data tools for targeting, including Campaign Relationship Management (CRM) system and Relational Database Management System to produce data files.

•Creation of campaign marketing flows through Unica campaign tool

•Participated on multiple projects of varied complexity simultaneously.

•Manipulated data to develop target lists for member communications based on targeting requirements.

•Created documentation and maintain procedures and queries necessary to prepare database targeting for various requests ad-hoc and ongoing

•Applied problem-solving and analytical skill in conjunction with SQL/SAS language to conduct quality assurance checks on data, from start to finish, ensuring data accuracy.

•Worked with multiple business partners, clients and channel vendors to assist and facilitate flawless execution on data requests.

•Provided research and analysis on historical communication as well as troubleshoot data related issues and recommend corrective actions

Pluris Marketing Framingham, MA

Marketing Analyst Oct 2012-Nov 2013

Harte-Hanks Billerica, MA

Marketing Analyst Feb 2011-Oct 2012

•Responsible for multi-channel marketing list selection, segmentation, and generation

•Prepared and executed database marketing deliverables for direct mail, email, and voicemail campaigns utilizing database software tools

•Responsible for research list selections and analysis of findings

•Developed standard monthly management reports for trend measurement

•Responsible for maintaining valid control groups to ensure proper testing

•Performed customer segmentation of database to better target customers

•Reported on marketing program results using incremental sales, ROI analysis, response analysis, and customer segment performance

•Managed loyalty, retention, and acquisition programs

•Standardized many internal job functions to better allocate time and resources

Skills:

•Proficient in Oracle and Teradata PL/SQL 12 years

•Proficient on CRM tools Aprimo, Unica, and IBM Campaign 12 years

•Experienced with reporting tools: Tableau, Business Objects, Cognos, and SAS 10 years

•Proficient with Microsoft Office Suite 12years

•Consistently and effectively work with all levels of organizations

•Excellent time management skills especially under tight schedules

•Extremely fast learner highly skilled in communication, problem solving, and resolution

Education:

Westfield State College

Bachelor of Arts in Communication and Journalism May 2005

Magna Cum Laude Graduate

References Available Upon Request



Contact this candidate