1. EMail DB for incorrect bounce handling at Amazon's SES

    At Daymon Interactions, we are sending out e-mails to clients via the Amazon Simple Email Service (SES) which handles bounces for us. Unfortunately, the way it is done leaves so much to be desired so that we decided to place our own db in between in order to determine which e-mail bounced, the type of bounce, how many re-tries etc. Amazon decided to send a "Delivered" notice for every sent e-mail unless they have already a permanent bounce record in their system. Later on, that "Delivered" status might get changed to a bounce requiring us to handle it.

  2. BizTalk Application Development for Carefusion

    For the health care provider Carefusion we developed several BizTalk applications and developed an analytical queueing model for performance analysis. The analytical queueing model allows the company to establish a baseline performance and to analyze various what-if scenarios. Metaphor Technologies also developed a statistical sampling application that queries the BizTalk database BizTalkDTADb for entries about service times and waiting times. The application permits a life view into the information of the BizTalk Tracking Database. It focuses on the following pieces of information: Service times...

  3. Automated Rule Reprocessing for Daymon World Wide

    Metaphor Technologies was retained to develop a way to automatically schedule documents such as purchase orders and invoices for reprocessing through BizTalk when underlying information in the Master Data Management system was changed. Due to the setup between the MDM and the brokerage management systems (BMS), the decision was made to utilize triggers that are automatically created. The triggers are attached to entities and attributes based on reprocessing parameters that non-developer users enter into tables. Those triggers then place entries into a reprocessing queue which then ultimately causes...

  4. Pay Per Call Website

    Metaphor Technologies, Inc. has developed a website to provide services to pay per call customers. Customers can register for pay per call services along with service phone numbers for service areas. Any phone call that is transferred via ifByPhone to a customer's service number is charged at a determined rate and customers receive weekly or monthly bills based on the number of received phone calls. The website integrates with ifByPone to collect phone calls for each customer and with Authorize.Net for billing purposes. The billing information is stored at Authorize.Net to comply with the Payment...

  5. Sara Lee

    Metaphor Technologies is retained for the Analytics project at Sara Lee Corporation in Chicago, IL to build a Data Mart. The purpose is to import facts exported from SAP and Manugistics to veryfy compliance of their Inventory and Planning with previously set goals. The project is critical to control distressed inventory which will ultimately result in costly distress sales, donations, and tanking of goods. Metaphor Technologies designs the data mart, ETL via SSIS packages, and extensive report generation through SSRS. The project is particularly interesting from a Business Intelligence perspective...

  6. Operational Data Store

    Currently, we are building for a preeminent Colorado child sponsorship organization an Operational Data Store that fits into a larger picture which introduces a master data management system and an enterprise data warehouse. The implementation of the ODS is especially challenging since some future avenues with respect to the final purpose of the data store must be kept open and the integration of other off the shelf compents will be explored. The co-founders of the Data Warehouse concept, Ralph Kimball and W.H. Inmon represent significant differences in the design and architecture of the enterprise...

  7. Data Warehouse

    We are currently designing a data warehouse solution to support administrative analysis, data mining and reporting for a premier child placement agency in Colorado. The solution includes: Creation of a time-stamped replicated section of the OLTP database to a staging area Scheduled regular ETL processes to the warehouse Scheduled regular and subscription based reports from the warehouse Predictive reports based on analysis service All solutions are based on Microsoft Technologies such as: SQL Server 2005 Replication SSRS SSIS SQL Server Analysis Services The highlights include no interruption of...