Data Analyst

Robert C. Glass

310-***-**** *****@*****.***

Professional Experience

Notre Dame High School - Sherman Oaks, CA Jul 2018 - Oct 2018

Database Manager/Data Consultant

Oversaw the daily operation of the constituent relationship management database (Raiser’s Edge) and responsible for ensuring the accuracy and integrity of all educational and biographical data.

Maintained the constituency database via updating the contact information to match the other supported databases. (Education Edge and On-Core)

Maintained the RE database to ensure program enables maximum efficiency as a CRM system

Updated database to remove duplicate records, updating relationships, managed opt-outs and importing data as needed.

Submitted data for Data Health Center and incorporating updates into Raiser’s Edge Database; including NCOA, Phone Finder, Email Finder and WealthPoint Screening.

US Vets - Los Angeles, CA Oct 2016 - Jan 2018

CRM Technical & Reporting/Data Analyst

Oversaw the daily operation of the constituent relationship management database (eTapestry) and responsible for ensuring the accuracy and integrity of all financial and biographical data, training staff in data and gift entry. First point of contact for staff with questions about or problems with the use of database, and served as the liaison with vendors to maintain the software and troubleshoot problems.

Ensured the accuracy and integrity of U.S.VETS fundraising database including data input and output, and end-user training and support.

Oversaw the daily operation of the database including coordinating gift processing with sites, reconciling with Finance and importing contact records.

Designed, build and test new reports, forms and controls to meet U.S.VETS needs.

Supported staff at U.S.VETS’ sites in the creation of SQL queries, reports and mailing lists.

Wrote complex SQL queries while accessing data

Trained Gift Processing staff to ensure accurate gift processing & records management.

Provided registration and marketing support for site events including targeted email lists and ecommerce setup.

Developed standards and policies for data entry, and ensures compliance.

Maintained & update quality control procedures to provide clean and accurate constituent data.

Maintained user manual and support, and clearly document workflows which pertain to CRM use.

Mapped and import data from external sources to eTapestry.

Exporting data into Tableau from Oracle and showing how sites have met their fundraising goals.

Provide recommendations and implements integration of CRM with payment processing and fundraising solutions.

Responsible for quarterly updating of contact information for key stakeholders.

Directed mail list preparation for three annual appeals.

Annual gala support includes creation of online registration, invitation list management, creation of prospect lists, attendee tracking and creation of financial reports.

Prepare monthly board reports on fundraising progress and unrestricted revenue reports.

Used Tableau to show management campaign given status and the revenue source

Reconciled fundraising data with accounting database using exported excel files.

U.C.L.A. Advancement / Information Services - Los Angeles, CA

Feb 1999 – Oct 2015 Data Analyst/ Report Analyst/Business Analyst

SQL Report Writer and Software Quality Assurance Specialist with over 15 years of experience.

Provided database reports to the various UCLA External Affairs department units in their efforts to promote advocacy and support for UCLA.

Reviewed incoming data requests, analyze the data elements in the source SQL Server database, consult with the users, and make recommendations regarding their requirements.

Performed analysis of user requests and develop specifications for data extracts, queries with SQL, and reports.

Created database reports from the UCLA alumni/donor (BLACKBAUD CRM) database tailoring to management and users for their business and data analysis needs.

Assisted in the development of the data architecture: identify areas of improvement regarding data integrity, access, usability and the data model.

Acted as a liaison between Information Technology staff and user community to create data solutions.

Analyzed user needs to determine system enhancements required to meet their reporting needs and to support their business processes.

Discovered opportunities and recommended solutions for further efficiencies within the team and department.

Knowledge of the BLACKBAUD CRM environment, including developing Smart Queries,

Ad-hoc Queries Marketing Efforts, Interaction updating, event planning and general processes.

Ability to acquire input from and lead discussions with a wide-ranging group of stakeholders across both business and IT teams.

Wrote complex SQL queries to access data in MySQL and Oracle databases

Ability to analyze complex technical and administrative information in order to identify relevant concerns, recognize alternatives, formulate logical and objective conclusions, and communicate these with management, team members, customers and vendors.

Expert knowledge of scripting, optimizing, and executing SQL & T-SQL queries against a SQL Server database using SQL Server Management Studio (SSMS).

Created reports using SQL Server Reporting Services (SSRS) from T-SQL Queries in a MS-SQL Server database.

Technical Skills/Knowledge

Databases: Oracle/Sybase/SQL Server Databases, Microsoft Access

Database Languages: SQL, Transact-SQL, MS-SQL, PL/SQL

Software: Blackbaud CRM, Blackbaud eTapestry, Raiser’s Edge, SSRS, SSMS

Visualization Tools: SPSS, Tableau, Excel

Education

Dowling College, Oakdale NY

• Bachelor of Science Degree, Aeronautics and Applied Mathematics

Contact this candidate