TECHNICAL DEBT PROGRAM

• DevOps focused Sample Data Set
• Orphaned Account Hierarchies
• Mass Uploads
• SFDC Admin Audit

CHALLENGES

• Preserving account hierarchal structure
• Creating a sample data set for Dev and Dev/Pro lower environments across 212 objects
• Building a fully automated upload process
• Mitigate the risk associated with a proliferation of System Administrators

SOLUTIONS

• Created queries in Ab Initio against relevant Teradata tables to identify, mitigate, & delete orphaned records.
• Deployed an automated upload process for a defined SFDC profile permitting non-technical users to upload sales “projects” using Jitterbit Data Loader.