Scott Ward Email & Phone Number

San Francisco, CA

• System administrator for grants management system (Salesforce), investment and AP accounting systems (NetSuite), content management service (Box), and single sign on authentication.
• Developed custom objects, fields, validation rules, workflows, reports, and apex triggers in Salesforce platform to address foundation needs.
• Developed custom record types, fields, workflows, searches, reports, client scripts, user scripts, and scheduled scripts for custom investment accounting build in NetSuite.
• Analyzed technical requirements for new software systems and provided adoption recommendations for executives and training schedules for end users.

• Managed online course registration for students each semester, including curriculum database management and programming of all registration rules and pre-requisites.
• Implemented and programmed new degree audit interface in Datatel Colleague that allows students and advisors to monitor student degree progress with live data.
• Implemented and programmed new business intelligence reporting system to automate business processes.
• Maintained data quality and consistency for all student records including registration, transcripts, grading and billing processes.

San Francisco, CA

• Integrated donor data from webforms, QuickBooks, NCOA data, and excel mailing lists into a consolidated donor information system in DonorPerfect.
• Created custom filters, reports, and exports in DonorPerfect to facilitate donor mailings and to maintain data accuracy and consistency.

• Managed donor database in Kintera, including gift entry, quality assurance of records, data report production, donor e-newsletter production and donor acknowledgments.
• Co-produced multiple events including Dining Out for Life, BAR AIDS, and Queens are Wild by helping with vendor and sponsor solicitation, venue set-up and material distribution.
• Recruited and managed between 20-100 volunteers for over 8 different fund-raising events including SF AIDS Walk, Academy of Friends, and Macy's Passport.
• Trained as a sexual health outreach volunteer and regularly volunteered to perform outreach at bars, clubs, and street fair settings to promote sexual health and obtain research data.

Volunteered as CA Certified Rape Crisis Counselor for 24-hour crisis hotline.

• Maintained student support database within FileMaker Pro by defining new computed fields, writing complex script queries and altering table structure to accommodate changing business needs.
• Maintained quality assurance of school and student records during enrollment periods, as well as the accuracy of weekly student progress reports sent to parents and mentors.
• Coordinated the data exchange between FileMaker Pro - our in house database; UC Gateways - an integrated student information system used for course enrollment; and Blackboard - our content management system used for.
• Generated bulk mailings, data reports and internal processes documentation.

Los Angeles, CA

• Co-directed door-to-door fund-raising and political campaigns for the Sierra Club, CalPIRG, and the Human Rights Campaign.
• Recruited, trained, and supervised 20 person staff.

Ms, Computer Information Systems

Ba, Mathematics, Women'S Studies