3 MEGA REAL PORTFOLIO PROJECTS TO TEST YOUR KNOWLEDGE ON DUPLICATE RULES, DATA MODEL AND DATA SECURITY: 3 GROUPS
THIS IS FOR STUDENTS WHO HAVE GOTTEN TO THIS LEVEL: ๐๏ธ GROUP A โ PROJECT TITLE: CleanHire CRM Overhaul Company: PrecisionHire UK Ltd โ London-based tech recruitment agency Sector: Recruitment & Staffing Focus Areas: Data Security โข Data Model โข Duplicate Rules ๐ Business Scenario: PrecisionHire helps tech startups find top-tier developers. Their sales and talent teams use Salesforce to manage Clients, Vacancies, and Candidates โ but things are breaking fast. Hereโs whatโs wrong: โ Everyone uses the same profile โ Talent team can see sensitive client billing data โ All Candidates and Vacancies are dumped under Accounts and Opportunities โ Duplicate Candidates are flooding the system โ same names, emails, or just slightly different spellings ๐ Management is struggling to track who placed which candidate in which vacancy, and reporting is unreliable โ
Your Admin Tasks: ๐น Data Model: Create 3 Custom Objects: Candidate__c Vacancy__c Placement__c (junction object linking Candidate and Vacancy) Add necessary fields like: Candidate: Full Name, Email, Skillset, Recruiter Vacancy: Title, Client (lookup to Account), Status Placement: Candidate, Vacancy, Start Date, Status Use Lookup or Master-Detail relationships appropriately Ensure you can run reports showing Vacancies filled per Client and Candidate status ๐น Data Security: Talent Team should ONLY access Candidate and Placement data Sales Team should ONLY see Vacancies and Client Accounts Billing Team should only view Placement fees (hide from Talent team) Use Profiles, Permission Sets, Role Hierarchy, and Field-Level Security Set Org-Wide Defaults properly and apply sharing rules where needed ๐น Duplicate Rules: Prevent duplicate Candidate records using Email + Full Name Warn users on similar Vacancies using Title + Account Block exact matches on Placement records (same candidate, same vacancy) ๐ข GROUP B โ PROJECT TITLE: BuildPro CRM Revamp Company: BuildPro Solutions โ Manchester-based commercial construction firm