10473 Nelson Ct., Westminster, CO 80021
Mobile: (720) 473-3748
cathydcooley@gmail.com
www.linkedin.com/in/cathydcooley
MARKETING/COMMUNICATIONS COORDINATOR
Versatile business professional with 15 years of progressive experience across a broad range of marketing and data functions. Well developed project management skills and leadership qualities to assist in implementation of various marketing strategies from print and digital media to event and trade show logistics. Areas if expertise include:
♦ Excellent Oral & Written Skills ♦ Desktop Publishing/Adobe, Quark Xpress
♦ Printed Collateral Coordination ♦ Email Campaign Management/Pardot, iContact
♦ Google Suite/Analytics ♦ HTML/CSS
♦ Trade Show Management ♦ CRM Management/Salesforce
♦ Website Updates/Wordpress ♦ Social Media Updates
PROFESSIONAL EXPERIENCE
LEADERSHIP FOR EDUCATIONAL EQUITY (2017-2022)
Data Specialist
Designed, maintained, and strategized data architecture according to end user needs for a 200-person nonprofit organization using Salesforce, MySQL, and Tableau. Provided reporting, analysis, and troubleshooting for executive team including sophisticated comprehensive tools to measure KPIs and progress. Gathered requirements and advised staff in all business units on how to fully leverage data. Documented procedures for regularly scheduled data maintenance in Confluence.
Key Contributions:
♦ Streamlined inherited environment of 1,000+ Salesforce reports into an organized, accessible structure to significantly increase cooperation and reduce staff time. Created an accessible, searchable reporting index to align stakeholders on data of record and avoid duplicated effort
♦ Maintained a complex central system using SQL queries to score and track member engagement and leadership growth across thousands of data points, used throughout the entire organization to respond to member needs and quantify mission-driven success
♦ Created 2019-2022 Goals dashboard in Salesforce, using SOQL coding in custom built object, to inform stakeholders of progress to annual goals and metrics
♦ Decreased annual planning timeline by 20%, resulting in more strategic org-wide approaches
♦ Managed MySQL data warehouse and wrote SQL code to create more complex tables than is possible in Salesforce which were then used in Tableau to build visualizations
♦ Developed interactive Tableau dashboards based on robust exploratory data analysis to contextualize data across business units and tell compelling data stories that motivate staff performance
Email Assistant
Centralized email marketing and communication for a 50,000-member organization including full technical implementation of targeted emails in Pardot. Supported program recruitment staff through creation of complex lists and suppression criteria using Salesforce and MySQL.
Key Contributions:
♦ Formatted 20-30 emails weekly in Pardot, often customizing using HTML and CSS. Filtered lists and suppression lists using both Pardot and Salesforce
♦ Became SME of organizations data resulting in a deep understanding of the data, structures, and relationships
♦ Trained staff to use a custom internal email tool within Salesforce, increasing correct use of the tool by 20% with greater staff satisfaction. ♦ Created dozens of dashboards using Google Data Studio and MySQL queries to provide staff insight on performance, leading to a 10% increase in productivity
♦ Wrote complex SQL queries to enable highly segmented survey follow-up email campaigns in Pardot
AMICUS SOLAR COOPERATIVE (2015-2016)
Purchasing and Marketing Coordinator
Performed a dual role of Purchasing/Bookkeeping and Marketing.
♦ Managed re-design of website
♦ Created new member and vendor informational brochures using Microsoft Publisher
♦ Provided customer service to 38 member companies in the cooperative
♦ Improved member price list in Microsoft Excel to a more easily used format with links and navigation
♦ Maintained and improved purchasing data in Quickbooks and Microsoft Excel to track member purchases and rebates
RGS ENERGY ( 2014-2015)
Material Planner
Joined team to manage East Coast purchasing. Communicated with six warehouses to ascertain needs and delivery of upcoming projects. Made purchasing decisions based on current inventory levels.
Key Contributions:
♦ Designed and maintained inventory metrics PowerPoint presentation used to present to Board status of Procurement’s current status
♦ Report generation in Salesforce and Microsoft Excel to determine demand for product
♦ Resolution of invoicing discrepancies based on received product.
♦ Improved and maintained material resource planning report used company wide to keep abreast of critical inventory issues
♦ Streamlined department procedures, eliminating need for additional staff
HYDE ENGINEERING + CONSULTING (2012-2013)
Marketing Specialist
Joined Marketing team to manage trade show logistics (20 events annually) and coordination of RFQs and RFPs including word processing and layout of final documents.Also responsible for management of two company monthly newsletters and design and composition of email campaigns to client base using iContact with templates and some HTML coding.
Key Contributions:
Joined Marketing team to manage trade show logistics and coordination of RFQs and RFPs using Microsoft Word and Adobe Acrobat. Responsible for management of two company monthly newsletters and email campaigns to client base using iContact with templates and HTML coding.
Key Contributions:
♦ Restructure of Salesforce data to accurately reflect client companies with multiple locations
♦ Implemented API between iContact and Salesforce to enhance email marketing
PANANALYTICAL BOULDER (FORMERLY ASD INC) (2008-2011)
Marketing Coordinator
Hired to manage trade show logistics (up to 28 events annually.) Supported sales staff with lead management using Salesforce. Managed iContact for use with email campaigns. Other duties included web updates using a customized CMS, word processing and desktop publishing.
Key Contributions:
♦ Created summary lead reports in Salesforce and Excel for enhanced lead tracking, allowing each of 5 sales representatives to quickly view their new leads by product
♦ Assisted in implementation of Company rebrand through marketing collateral development and website updates
MOTHERHOOD (1998-PRESENT)
Managed and maintained 2 tiny humans through various stages of growth and opportunity to become effective, self-sufficient human beings.
RESOURCES TRUST COMPANY ( 1994-1998)
Project Coordinator
Joined team of four coordinators in Marketing responsible for creation of marketing collateral using Quark Xpress. Each project managed from start to finish, including writing, designing and contracting for printing.
Key Contributions:
♦ Designed and programmed an inventory and sales tracking database in Microsoft Access for Marketing collateral. This system was installed on a network to accommodate multiple Sales Associates.
EXPRESS PRESS (1992-1993)
Desktop Publisher
Designed standard business and promotional materials using PageMaker. Consulted with walk-in and established clients to create artwork according to clients’ guidelines. Production included: graphic design and typesetting, color separations and paste-up.
RESOURCE DATA INTERNATIONAL (1989-1991)
Marketing Assistant
Designed and produced marketing materials and corporate communications. Performed data entry of customer information into a UNIX database and created reports using SQL and SQR.
EDUCATION
University of Colorado, Boulder: BS, Business/Marketing; BA, English/Creative Writing