SaaS, Project Management

brandstem™

The brandstem™ Product Relationship Management (PRM) system serves four primary functions:

  1. Store product information – this includes metadata such as product attributes, product descriptors, images, packaging details, etc.
  2. Manage product relationships e.g. product taxonomies, groupings and marketing campaigns (i.e. flyers, promotions and offers)
  3. Distribute product information and relationships through multiple channels, and
  4. Collect analytics from all marketing related activities managed through the system

By fulfilling these four primary functions, brandstem™ is able to provide detailed product data to any endpoint – microsites, flyers, e-blasts, banners, digital signage, etc. brandstem™ enables marketing teams to create a consistent brand experience across multiple channels. Furthermore, the analytics gathered from these activities will allow marketing teams to refine their promotions for maximum effect.

My Role

Led development of API V3.0 including the following improvements:

  • implementation of OAuth authentication
  • re-architecting internal applications to use API instead of direct connection to DB
  • implementing advanced database features such as LTree and JSONB fields
  • designed an extensible Entity-Attribute-Value database schema to support client needs