Ariel Kaplan Email & Phone Number

New York, New York, United States

Inception of new data strategy and analytics team. Lead data engineering vertical. Prioritize data projects and tasks across multiple business units to drive forward organizational fundraising goals. Develop, designed and implemented warehouse solutions for Salesforce CRM including address standardization, vendor file integration processing, Salesforce archival processing. Maintain data warehouse tables and design harmonization between multiple CRM platforms. Lead in translating current state warehouse and lake stack to future state as part of NPSP migration.

New York, United States

Implementation and development of Data Warehouse. Data engineering of multiple data sources. Extraction, transformation and loading into data lake. Ongoing process of converting data lake into warehouse. Implementation and maintenance of multiple bidirectional data syncs between various platforms. Strategize and oversee data structure in redshift environment. Consult and provide guidance on database conversions. Subject matter expert on data mapping, migration techniques and best practices. Determine best data practices for Omni-channel fundraising marketing strategy and provide technical data expertise to enable full 360 degree view of donors. Support a Salesforce back end with high volume data loads and hygiene.

Designing and implementation of fundraising data warehouse. Lead for multiple affiliate database migrations into Salesforce from Raisers Edge. Administration of data lake. Building of discrete data sets for tableau implementations and reporting needs. Back-end support for Salesforce, MySQL, and Redshift.

434 W 33Rd St, New York City, Ny 10001

Troubleshooting and error resolution for a syncing dual database system. Data lead for Salesforce conversion. Mapping lead and some moderate ETL work. Generated reports out of the back end using multiple tools. performed light data analysis.

Manhattan, New York

Front-End Database Administration, back-end database support and administration, Helpdesk Support, User Roles and Security Settings, Automatic Data Uploads, Coordinate support to affiliate organizations, Data validation, General donation research, System conversion projects, QC auditing scripts, complaint code system, account merging, large scale data cleaning

Manhattan, New York

Opened and sorted mail based on a variety of factors. Knowledge of tax entities was required.

Assisting in Database converion from legacy system. Code translations, Documentation reviews, User acceptance testing, DBMS Manual editing, Data mapping.

Scanned, sorted, boxed and stored endless amounts of sensitive financial documents.

Wrote, edited, and published reviews of software for the iOS platforms.

Certified Data Architecture And Management Designer, Salesforce

Certified Administrator, Salesforce

Msis, Database Administration

Master of science - Information Systems, concentration in Database Administration

Bils, Computer Science/Business

Diploma