Jocelyn A.
Database Manager at White House Historical Association- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Credentials
-
TESOL
ITTT - International TEFL & TESOL trainingNov, 2017- Sep, 2024
Experience
-
White House Historical Association
-
United States
-
Museums, Historical Sites, and Zoos
-
1 - 100 Employee
-
Database Manager
-
Mar 2022 - Present
• Using Salesforce to create reports to assist gift officers• Using Salesforce to create new users and assign them a user profile• Using Salesforce Apsona to deduplicate and merge 15,000+ records • Using Salesforce to create reports to assist gift officers• Using Salesforce to create new users and assign them a user profile• Using Salesforce Apsona to deduplicate and merge 15,000+ records
-
-
-
American Farmland Trust
-
Civic and Social Organizations
-
100 - 200 Employee
-
Database Coordinator
-
Apr 2019 - Mar 2022
• Directed the data entry and processing of all gifts from multiple sources into Raiser’s Edge• Managed the exportation of donations from credit card processing systems, transformation of data, andimportation of data into the database• Produced a policies and procedures guide for our database to guarantee proper database management• Supervised and examined data donation coding for accuracy on a daily basis by using SQL and Microsoft Excel• Assisted with the processing of state registration forms to corroborate compliance• Created queries to perform database management to check consistency across donors’ records• Coded and ran a SQL query to fix 25,000+ donor records by giving them personal name titles• Increased efficiency by adding donors' information to the credit card processing system to allow the correct coding to be downloaded• Analyzed and distributed five monthly reports for the development and finance departments• Ensured database integrity by managing source and flag codes by marking them either active/inactive• Made recommendations about data integration systems in regards to the nonprofits credit card processing system and routine data enrichment services• Improved the data health score by one letter grade from a D- to a C• Supported and monitored databases by performing database management
-
-
-
Food & Friends
-
United States
-
Hospitals and Health Care
-
1 - 100 Employee
-
Development Operations Assistant
-
Jul 2017 - Apr 2019
· Served as the liaison with the Finance team for financial adjustments and reconciliations· Managed the Raiser's Edge database to establish consistency across donor records· Merged 100+ duplicate records to create one single master record for the individual· Managed the data entry and processing of donations from multiple sources· Imported and cleaned data in the database as it synced from a third party plug-in· Imported monetary donations using Luminate and a credit card processor· Researched new credit card payment and processing methods· Created a policies/procedures guide to establish database management· Devised systems of organizing records to maintain order and tracking· Produced reports and queries to assist gift managers with their donors' pledges and pledge payments
-
-
-
Christ House
-
United States
-
Hospitals and Health Care
-
1 - 100 Employee
-
Volunteer Assistant
-
Nov 2014 - May 2017
· Orchestrated and updated the Christ House website using WordPress and HTML· Assisted with the layout, management, updating, and launching of the new website· Sent out monthly volunteer newsletters using Constant Contact to highlight Christ House news and volunteer vacancies· Provided volunteer data for the monthly financial committee meeting and quarterly board reports· Analyzed the monetary value of utilizing volunteers over staff employees for Christ House's taxes· Coordinated volunteer schedules to fill volunteer vacancies in the kitchen and on the phone at the nurses station· Verified monthly meal groups to ensure they were following Christ House nutritional guidelines· Assisted with volunteers by providing tours and orientation trainings· Assisted with the event planning of the annual Volunteer Appreciation Night and staff Christmas party· Designed graphics, mugs, t-shirts, and invitations utilizing Photoshop and Illustrator · Assisted with coordinating 400+ in-kind Christmas gifts for Christ House patients· Assisted as relief receptionist by taking calls, welcoming people, and logging and distributing the mail and packages
-
-
Development Assistant
-
May 2014 - Nov 2014
• Created an acquisition report on acquired donors to analyze the success of Christ Houses' prospecting campaigns• Created, produced, and coordinated four mailings of 5,000 pieces that resulted in raising $26,000+• Assisted with the creation of donor lists by using queries to exclude certain individuals/organizations• Uploaded monetary and in-kind donations into the DonorPerfect database• Managed and pulled statistical data from DonorPerfect to produce weekly direct mailing reports and monthly reconciliations• Processed credit card donations using PayTrace• Kept track of individual partner giving to manage pledge payments
-
-
-
Make-A-Wish Foundation of Greater Virginia
-
United States
-
Non-profit Organizations
-
1 - 100 Employee
-
Communications and Development Intern
-
Jan 2013 - May 2013
• Updated and managed the website utilizing HTML and WordPress• Entered and updated donor information into Raiser’s Edge and sent out corresponding acknowledgment letters in a timely and accurate manner• Analyzed, evaluated and updated Facebook which led to an increase in likes• Utilized Microsoft Publisher, InDesign, and Illustrator to create flyers, invitations, sponsorship and response cards• Developed, wrote, and sent electronic newsletters to segmented audiences using Constant Contact• Researched Virginia print and online newspapers to create a media database• Used AP style to write and distribute press releases• Assisted in fundraising for Over the Edge by securing an in-kind donation from the Pepsi Distribution Center• Solicited a $1,300 donation from the College of William and Mary’s Inter-fraternity Council for an Over the Edge event• Assisted with events at Richmond International Raceway
-
-
Education
-
2018 - 2019
The George Washington University
Data Analytics and Visualitzation -
2008 - 2012
James Madison University
Bachelor of Science, Communication Studies -
2008 - 2012
James Madison University
Bachelor of Science (B.S.), Media Arts & Design: Corporate Communication
Community
