Download
slide1 n.
Skip this Video
Loading SlideShow in 5 Seconds..
30+ years servicing top-tier loyalty and incentives programs 700+ employees PowerPoint Presentation
Download Presentation
30+ years servicing top-tier loyalty and incentives programs 700+ employees

30+ years servicing top-tier loyalty and incentives programs 700+ employees

112 Views Download Presentation
Download Presentation

30+ years servicing top-tier loyalty and incentives programs 700+ employees

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. 30+ years servicing top-tier loyalty and incentives programs • 700+ employees • 8 offices in the U.S.; 1 office in Brazil • Delivered $6.7 billion in rewards experiences in the past 3 years • Reach more than 100 million people each year with rewards,incentives & benefits • #1 U.S. loyalty travel agency (Travel Weekly) • Top 10 clients have been with Connexions an average of 10 years each Oracle Confidential – Internal/Restricted/Highly Restricted

  2. Certifications • ISO 27001 • PCI Level II • Cybertrust • Safe Harbor • SSAE16 standard • Other tech stats • High availability • 6 physical servers • 205 VM’s • Peak page view / hour 268,237 Oracle Confidential – Internal/Restricted/Highly Restricted

  3. Business Architecture Primary Business Segments Affinion Membership Business Segment Connexions Loyalty Business Segments Protection Product Lines Retail Services Product Lines Loyalty Product Lines Travel Product Lines Protection Product Lines GM Product Lines • GM Card • Vehicale Purchase Programs • Private Offer Programs • GM Goodwill • Card Offer Registration Portal • GM Deli • Digital Targeted Offer • Pre-Generated Auths • Exceed Platform SaaS* • Exceed WebStore SaaS* • Exceed Fulfillment SaaS* • MotivEngine SaaS* • Loyalty Open API • Retail Purchase Earn SaaS* • shopRaising Mall SaaS* • Flex Checking Saas • Earn More Mall • ORXe Redemption • ORXeRetail • Travel Open API • Exclusive Access* • Hotel and Car Discounts • Online Cruise • Individual Incentive Travel • Claims Platform SaaS • Buyers Advantage 2.0* • Legacy Buyers Advantage • Genesis Platform SaaS* • preGenesis Coupon Platform* • Legacy Coupon Platform • EverSave Bank My Rewards* • WebLoyalty Programs* • Legacy Shopping* • Claims Platform Saas • Claims Portal Saas • Engagement Portal Saas* • Benefits open API Integration Integration Supporting Business Segments Supply Chain Management Finance Misc Corporate Operations Contact Center Operations * Oracle ATG Commerce Oracle Confidential – Internal

  4. Implementations by Product Line Primary Business Segments Affinion Membership Business Segment Connexions Loyalty Business Segments Additional Affinion Segments Oracle Confidential – Internal

  5. Loyalty Conceptual Architecture Oracle Confidential – Internal

  6. Loyalty Overall Architecture LOLA Point System Oracle Weblogic OSB Client / Third party Integration Weblogic SOA Suite Oracle ATG Commerce Oracle 11g Oracle Endeca Oracle Confidential – Internal

  7. Affinion Commerce Platform (Loyalty Points Programs) Oracle Confidential – Internal

  8. List Of Unique Issues Unified Product Catalog Shopping Platform Data Mgt Tool • Multiple website applications across many platforms • Do not share product data • One shopping platform that would fit all of our websites: Shopping and Loyalty • Ability to modify for Points Based System • Data Config was entered by developers. • Ability to move those tasks to the Product team. Search Engine Multiple Clients • Previously used Lucene • Needed an application that handled dimensionswelland could handle extensive data • Each client has it’s own subset of products • Each client has it’s own pricing • Need all to share same product catalog Oracle Confidential – Internal

  9. Finding New Products To Meet Our Needs Oracle Database Extended ATG Data Model Multi-Client based Loyalty Websites Extended BCC Endeca Oracle Confidential – Internal

  10. ATG - Points Based System Multi-Client Solution Challenges • Extended payment framework to fit a points based/multi-client system within the constructs of ATG • Extended the existing ATG tables to fit our needs. • Ex. - dcs_product was extended to xtend_product • No existing tables were modified • All new extension tables start with the same Prefix, so they are easily identifiable. • Only pricing data is created per client. All product data stays unique. • Added new screens to the BCC to handle the new data model. • Must work with shopping websites and Loyalty Points Based platform. • Must handle Multiple Clients on points based system • Ability to modify ATG data model without breaking future upgrades. Oracle Confidential – Internal

  11. Endeca - Multiple Client Product Catalog Multiple Clients • N to Many Clients created through the BCC • Each client has can have all or a subset of entire product catalog • Each client’s product pricing is unique. Progression of Solutions One pipeline for all clients One pipeline per client • Original Solution • All clients reside on same pipeline and share data • Crawl became slow with overwhelming data as we added clients to Endeca. • Optimized Solution • Multiple Feeds – Solves one to many issues • Category, Pricing, Product, Product/Category, Brand • Each client has it’s own pipeline. • Client index no longer with shared data Oracle Confidential – Internal

  12. Database Feeds to CAS: Multiple Clients Product Feed Client 1 Pipeline Category Feed Client 2 Pipeline CAS Pricing Feed Client 3 Pipeline Brand Feed Client 4 Pipeline Product/Category Feed Oracle Confidential – Internal

  13. UseCase – Overall Architecture for Connexion Loyalty’s MyCompany Rewards Web Application Oracle Confidential – Internal

  14. UseCase – MyCompany Rewards Web Application Integrations Exceed Platform Oracle SOA Suite Spring Container ProductDetailWS Product Detail WebService Client Controllers Connexion Loyalty Oracle DB TaxCalculateWS Tax Calculate WebService Client PreAuthWS Client / Third party Integration PreAuth WebService Client Web Application Interceptors PostAuthWS PostAuth WebService Client ECertFulfillWS ECertFulfill WebService Client Services OrderCreate WebService Client OrderCreateWS Oracle Confidential – Internal Oracle Confidential – Internal

  15. The data for this page is configured in Endeca’s Experience Manager. On clicking any of the menu item (representing categories on the use catalog), takes the user to category landing page (showed in the next slide). Use Case –MyCompany Rewards Web Application Oracle Confidential – Internal Oracle Confidential – Internal

  16. Define code-value with “Product List Type”. Create a code value for all the items with the same type. ATG Catalog tables are extended to store these information. Use Case – ATG BCC Configuration Oracle Confidential – Internal Oracle Confidential – Internal

  17. To each of the product list created, add preferred products used across the application catalog. The order in which the products are added, becomes the rank of the product within the list. Use Case – ATG BCC Configuration Oracle Confidential – Internal Oracle Confidential – Internal

  18. Attach the product list to the profile segment. The profile segment tables in ATG catalog is extended to allow storing the product list on the segment record. Use Case – ATG BCC Configuration Oracle Confidential – Internal Oracle Confidential – Internal

  19. For the Electronics category, location is specified and a TwoColumn page is defied. Rotation Spotlight cartridge is used to represent the “recommended for you” item. Spotlight records are configured to fetch records by query. Use Case – Endeca Experience Manager Configuration Oracle Confidential – Internal Oracle Confidential – Internal

  20. Dimension is created to be sortable by rank in the pipeline. Select the sort option as ascending. Limit records to active refinements (categories) Select the number of records to be returned. Use Case – Endeca Experience Manager Configuration Oracle Confidential – Internal Oracle Confidential – Internal Oracle Confidential – Internal

  21. The offer model (object) representing this page is constructed by querying Endeca using Assembler API and also from data obtained by calling a Oracle SOA Web Service. This SOA web service in turn calls a ATG Web Service to fetch details for the product and sku’s associated with the product displayed on this page. Use Case –MyCompany Rewards Web Application – Product Detail Page Oracle Confidential – Internal Oracle Confidential – Internal

  22. Questions? Oracle Confidential – Internal