← Portfolio
Proprietary

Lead intelligence for graduate programs at UAI

Industry
Executive education
Type of work
Lead data and recommendation
Period
2021

Confidential project: code and data are not public.

Architecture

LinkedIn public profiles PhantomBuster extraction SQLite profiles + history Contacts sales base Record linkage profile ↔ person Career moves promotions andcompany changes What to offer program perprospect Python · SQLite · periodic refresh

Goal

The sales team for diplomas and master’s programs had thousands of contacts but knew little about them. The goal was a living profile of each prospect (role, company, career path) used to offer the right program when the person was ready for it.

What I did

  • Designed and built the platform in Python, with SQLite storing profiles and their history.
  • Automated extraction of public LinkedIn profiles with PhantomBuster.
  • Implemented record linkage to match each profile to its person in the contact base, even when names, emails or companies did not match exactly.
  • Tracked how each professional evolved (promotions, company or area changes) to spot the right moment to reach out.
  • Matched role and career path against the program catalog to suggest what to offer each prospect.

Stack

PythonSQLitePhantomBusterrecordlinkagepandas