Jocelyn A. Email & Phone Number

Washington, District Of Columbia, United States

• Creating personalized dashboards and reports for our gift officers and development team• 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 filters to create reports and dashboards• Part of a team to implement and deploy Veevart into Salesforce• Scheduling weekly backups of our Salesforce database• Training co-workers on Salesforce• Updating Salesforce flows to send automatic gift officer notification emails• Creating Salesforce sections, fields, and roll up fields

Washington D.C. Metro Area

• 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

Washington D.C. Metro Area

· 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

Washington D.C. Metro Area

· 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

Washington D.C. Metro Area

• 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

Data Analytics And Visualitzation

a 6 month certification program in MySQL, Python, MongoDB, HTML/CSS, JavaScript and data analytics

Bachelor Of Science, Communication Studies

Activities and Societies: Public Relations Student Society of America, Association of Women in Communication

Bachelor Of Science (B.S.), Media Arts & Design: Corporate Communication

Activities and Societies: Public Relations Student Society of America, Association for Women in Communication