INDUSTRY:

University / Academics

PRODUCTS:

Education – Law School

COMPANY SIZE:

150+ Employees

HEADQUARTERS:

Berkeley, CA

PROJECT OUTCOME:

• Cleansed existing data and implemented process to prevent additional data duplication
• Applied SFDC customizations to streamline business processes

OUR CLIENT’S CHALLENGE

UC Berkeley (UCB) School of Law is one of 14 schools and colleges at the University of California, Berkeley and is consistently ranked as one of the top law schools in the nation. The School had an existing Salesforce instance titled “Higher Education Data Architecture” (HEDA) that they used to track bar examination results of UCB graduates as well as prospective students with interest in attending. This information is collected by running numerous automations and daily data imports from ACES2, a national database used by law schools to house information regarding the bar exam, and Pardot, a web-based solution used for tracking enrollment interest.

Existing data processes were performed without cleaning or validating information before and after import causing a high volume of duplicate data. UCB School of Law engaged Ten2Eleven to assist with data clean-up, process modifications to ensure data integrity, and implementation of a backlog of Salesforce improvements and changes.

TEN2ELEVEN’S APPROACH

Phase 1 – Identification and Data Cleanup:

Ten2Eleven reviewed UCB’s Salesforce data and systematically removed duplicates entries. Once the data was cleansed, Ten2Eleven determined the root cause of the issue and implemented new jobs to prevent duplication during data load routines without impacting current business processes.

Phase 2 –Instance Customization:

Ten2Eleven customized UCB’s Salesforce instance to avert workflow disruptions related to Pardot integrations. Ten2Eleven researched process limitations and provided a solution that accomplished University objectives without requiring changes to existing workflow.

Phase 3 – Global Picklist Implementation:

Ten2Eleven applied global pick-list values to eliminate data inconsistency across objects and constrain introduction of new values.

THE SOLUTION

Ten2Eleven completed the following items:

• Data review and cleanup
• Custom data integrations to eliminate dirty data
• Global pick-list implementation

Products:

• Salesforce Enterprise Edition – Lightening

Technologies:

• Customized Standard Objects
• Scheduled jobs to synchronize data

Languages:

• APEX