Shawn Mcdonald Email & Phone Number

Remote- Nyc

Remote- Nyc

Remote- Nyc

Work closely with customers and direct marketing agencies to execute offline campaignstrategy. Perform campaign segmentation for accurate, on-time file delivery.Automate campaign files and other production functions, including nightly summary processes and charge processing.Verify, troubleshoot, and thoroughly quality check results of all campaign outputs.Attend regularly scheduled internal and external customer-facing meetings to managecomplex campaign schedules. Provide customer support for segmentation and data analysis questions.Create, update, and maintain customer-specific documentation.Develop content and participate in periodic customer-facing reviews for improved customerexperience.

Greater New York City Area

Managed report design, implementation, review and testing for American Civil Liberties Union (ACLU) as they transitioned to NGOC/Salesforce and EDW reporting via Amazon Redshift.

Greater New York City Area

Headquarters New York, NY$102 Million 2016 Revenue, 23 State Programs, 41 Nature Centers and 500 ChaptersDatabase Manager (2014-2017)Managed and maintained the fundraising CRM of record, Abila’s Millennium. Primary line of support for National Audubon state offices and chapters while establishing business rules for CRM workflow across the network. Collaborated with the national IT team to improve data sync processes between the central CRM and all other data sources and cloud-hosted warehouses, ensuring optimum performance, data integrity and user productivity across all data systems.Improved processes to protect highly confidential, sensitive donor data.Lead liaison between multiple business departments, including Major Gifts, Finance and Marketing, and the technical team in IT.Designed and built custom queries, views, reports and dashboards for both Millennium donor data and Salesforce customer service interaction data. Generated reports and queries for all departments, including Finance, Fundraising and Audubon magazine. Implemented comprehensive data hygiene processes to ensure donor data was accurate and reliable.Designed and implemented data structures, new codes and data flows to supply logical and consistent data points for easy and accurate reporting/segmentation.Managed relationships with internal and external service providers and programmers as they affected data flow and integrity.

Greater New York City Area

Headquarters New York, NY$138 Million 2015 Revenue, 53 State and Affiliate OfficesFundraising Data Manager (2007-2014)Technical lead within the American Civil Liberties Union (ACLU) fundraising-database support team of 6, providing database production support to all Development professionals, including Major Giving, Membership, Online Marketing, and Planned Giving.Liaised between database services providers and fundraising and IT staff at the ACLU.Integrated financial information from national and affiliate offices to ensure a reliable revenue database of record. Lead the project to leverage the new shared donor database environment to finally automate complex revenue sharing rules.Managed data hygiene processes to ensure donor data accuracy within the ACLU and its affiliates for fundraising, financial reporting, and auditing. Designed and built custom reports to guide the executive team’s decision making.Managed data integration of multichannel fundraising program by enhancing, testing and maintaining data-feeds for a variety of data sources such as NCOA and merge-purge and syncs from online transactions and caging vendors.Worked closely with research and data-analysis team and collaborated with affiliate and national colleagues at national headquarters and 53 state/regional offices to design and implement best practices and business procedures, rules and controls.

Greater New York City Area

Headquarters New York, NY$172 Million 2016 Revenue, 9 State and 3 International OfficesInstitutional Giving Associate (2005-2007)Provided database support and training to all levels of fundraising staff.Developed financial reports and implemented business processes to record and report on budget and income projections.Nominated by senior management to chair the Internal Communication sub-committee of the Staff Advocacy Committee.Development Assistant (2004-2005)Assisted Institutional Giving Director with: database maintenance; data entry; cleanup of Pledge Maker prospect files; coordination of mass-mailings; generation of Business Objects reports (e.g., income projections); upkeep of physical files.

Boulder, Co

Retail Clerk and Online/Mail Order Processing Supervisor (2001-2003)Processed purchases and coordinated inventory with shipping system; monitored flow of orders from online cart to fulfillment.Generated reports to analyze shipping costs and determine flat rates charged to customers.