Catherine Cooley Email & Phone Number

Denver Metropolitan Area

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.Key Contributions:♦ Compiled list of vetted Salesforce reports in Google sheets for stakeholders to quickly and easily find the data they need (list is link driven and searchable)♦ 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 project timeline on annual goals/metrics building by 20%, allowing stakeholders more time to make their strategic plans for the upcoming year♦ Managed MySQL data warehouse and writing SQL code to create more complex tables than is possible in Salesforce which are then used in Tableau♦ Analyzed and documented organization's data using Tableau to develop dashboards which enhance stakeholder's understanding of data visualizationr's understanding of data visualization

Greater Denver Area

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:♦ 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 campaigns

Boulder, Co

Performed a dual role of Purchasing/Bookkeeping and Marketing.♦ 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♦ Managed re-design of website♦ Created new member and vendor informational brochures using Microsoft Publisher

Louisville, Colorado

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:♦ Report generation in Salesforce and Microsoft Excel to determine demand for product♦ Resolution of invoicing discrepancies based on received product. ♦ Designed and maintained inventory metrics PowerPoint presentation used to present to Board status of Procurement’s current status♦ 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

Boulder, Colorado, United States

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

Boulder, Co

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

Bs & Ba, Business/Marketing And English/Creative Writing

Selected as one of four participants from the CU Business School to attend the MCI Case Competition at the University of Virginia.

Bachelor Of Business Administration (Bba), Marketing