Data Analyst Social Media

Alan Harris

Phone 213-***-****

Email: ************@*****.***

PROFESSIONAL EXPERIENCE

Total Traffic & Weather Network Feb. 2016 - Feb. 2018

Traffic Production Manager/Analyst

●Analyze live traffic accidents, road closures, & slow moving traffic

●Record data of live traffic reports using the Total Traffic and CHP Network

●Maintain & update data accuracy around the minute

●Coordinate with CHP Headquarters and KFI Radio listeners for new traffic data

Community Coalition Aug 2017 - Dec 2017

Data Analyst

The Data Specialist will play a key role in the growth of the organization's dues-paying membership by establishing and maintaining a database that can track member activity and engagement, as well as house demographic and other data. The goal is develop rich member profiles that can inform cultivation strategies to maximize member activism.

Additionally, the Data Analyst will be responsible for evaluating and addressing the data needs of the organizing civic engagement, communications and development departments to develop and maintain a comprehensive database that serve the organization holistically.

Essential Duties:

•Assess organization data needs and make recommendations as to the fit of the organization's current database system.

•Preform back and database maintenance on a regular basis.

•Create reports that respond to organizational needs.

•Enter data in an accurate and timely manner.

•Track member information, activity, communication.

•Establish database training protocol for staff, members and volunteers.

•Assist in research project to determine the best methods for signing up dues-paying members from a base of South Los Angeles voters.

•Compile and input multiple lists and data sets in different formats into database.

Prostate Cancer Foundation April 2017 - August 2017

Data Associate

•Daily data imports and exports to and from the Raiser's Edge database, Kintera CRM and Direct Mail.

•Kintera bi-monthly imports of multiple initiative reports. Reformat reports with created macros, clean/edit information to be compatible with Raiser's Edge, import new constituent records, matchback of existing constituents through Microsoft Access and importing gifts, tributes and attributes.

•Annual Report: Capture donors with cumulative giving of $5K+ and ensure their accurate listing preference, giving tier and giving amount. Import updated information annually.

•Update existing Annual Report donors as new gifts are received and to capture new donors of cumulative giving of $5K+.

•Monthly direct mail donor giving matrix for Grizzard. Exporting single and multiple direct mail donors since inception and creating formulas and pivot reports to capture donor giving trends.

•In-house mailings and donor lists. Create queries, export data, ensure accurate data for mail merge and globally add appeals to these recipients.

•Bi-monthly donor conversion reports for Agilis. Clean and format data files from Kintera, import potential new donors and globally adding appeals to these constituents and any constituent in Raiser's Edge that has bought a store product/requested a guide and has not given a general donation.

•Generate daily financial exports and reformat with created macros to be compatible for Navision.

•-Bi-weekly exporting and coding of direct mail letters and guide requests to be fulfilled by Agilis.

•Weekly direct mail eVision maintenance to capture tributes, removals, emails, comments, prostate cancer diagnosis/relationships and address updates.

•Maintain and help establish in-house policies and procedures for data management and new employee training.

Gumbiner Savett Mar. 2016 - Aug. 2017

Executive Assistant

●Assist 7 CPA partners/shareholders of the firm

●Prepare & finalize tax return engagement letters

●Finalize cover letters & send certified mail to firm’s clients

●Sign out, scan, mail K-1 tax return forms to firm’s clients

●Create shipping/mailing labels for USPS, FedEx, & Certified Mail

●Analyze & route E-file for tax returns forms in GoFileRoom.com

●Screen & transfer calls for all my partners of the firm

●Gather & deliver incoming mail for partners of the firm

●Email tax return engagement letters to firm’s clients for signature

●Saving Records of signed tax return engagement letters in GoFileRoom.com

●Prepare “Power of Attorney & Declaration of Representative” form 2848 using CFS Tax Tools 2016

●Prepare Franchise Tax Board “Power of Attorney Declaration” Form 3520 using CFS Tax Tools 2016

●Prepare tax billing invoices for 6 partners of the firm using Practice CS

●Mail tax billing invoices to clients

●Collect time sheets from the entire firm for payroll

●Manage employee leave request and up the firm's calendar

Constant Contact Jan. 2015 - 2016

Virtual Assistant

●Updates/maintains all event calendars and event Google drive spreadsheets

●Creates ALE events and emails for West ALE team members

●Update Wordpress blog with new events in coordination with Salesforce to track & report event data

●Assists with local event coordination and registration

●Manages event vendors

●Updates expense reports and tracking receipts using Concur system

DyeTribe Inc. Retail & Wholesale 2014 - Seasonal

Co-Owner, Marketing Coordinator, and Designer

Started a Long Beach based tie-dye wholesale and retail company

●Markets products and interacting with customers using various social media outlets such as Twitter, Facebook and Instagram

●Creates new designs and color schemes to dye various articles of clothing

●Tracks sales, refunds, and receipts

U.S Department of State, Washington, DC 2006 - 2013

Clerical Assistant

●Maintained a security clearance and retired various forms of financial disclosure reports in the Office of the Legal Advisor

●Entered and scanned new and old information into a financial disclosure database under strict deadlines while verifying the information accuracy

●Retired files in alphabetical, chronological, and numerical order via Content Server

●Provided customer service to incoming clients in person and by telephone

●Gained an in-depth knowledge of general administrative functions, ability to prioritize, coordinate, and organization skills

EDUCATION

Old Dominion University, Norfolk, VA (2013)

Bachelors of Science, Interdisciplinary Studies

COMPUTER SKILLS

●Microsoft Word (50 WPM) / PowerPoint / Excel / Outlook, 10-key

●Google Drive, Constant Contact, Wordpress, Salesforce and Content Server Database

●GoFileRoom.Com

●Practice CS

●CFS Tax Tools 2016

●Nation Builder

●Giveffect

●Rasier

●Raisers Edge

●Citrix

●Lexus Nexus

●Kintera

●Data Mapping (1yr)

●SQL (1yr)

ADDITIONAL SKILLS

●Creating websites using Squarespace and Wordpress

●Providing social media marketing strategies and analysis

Contact this candidate