Lucid Commerce DW Case Study
Direct Marketers Data Processing and On-demand Business Intelligence Services
The Client
Lucid
COMMERCE, Seattle, WA
The Business Challenge
Direct Marketing companies work with multiple vendors and end-up with data silos.
The problem for direct marketers is rarely a lack of data. The problem is the inability
to collect, organize, and access that data at a reasonable cost and in a timely
manner.
Lucid Services
Lucid Commerce is an on-demand business intelligence solution provider for direct
marketers by processing and warehousing the data. Direct marketers engages Media
houses, Call Centers and Websites for marketing their products, and incur a cost
in acquiring customers . Lucid commerce BI solution concentrates on attributing
post-sale customer metrics to media purchases.
Lucid provides the following services to customers:
- Business Intelligence for Direct Marketers
- Data Processing
- Data warehousing
- Data export services
- Continuity Orders generation service.
The Solution
GGK's Offshore team was involved in building various components for ETL, Data Processing
and Order management systems, designed various SQL Reporting service reports. GGK
engineers added several new features and tuning of the existing systems.
GGK team was actively involved in providing production support from Offshore.
Features in Lucid Commerce system
GGK team was actively involved in providing production support from Offshore.
Features in Lucid Commerce system
The Results
- Notification system has added value to the lucid data processing and warehousing by alerting the clients with the status of various data Processing systems.
- A Robust Order Processing system for raising continuity orders
- Improves Performance of report procedures
- Improving data accuracy; through reconciliation and data variance checks.
- Introduction of Error logging
- Reduced ETL times; through the Performance tuning of ETL routines.
- Eliminating the manual process for setting up new files for Processing.
Technologies Involved
SQL Server 2005, SQL Server Reporting Services , SQL Server Notification Services,
Informatica 8.1 Power Center , Business Objects, SharePoint , .NET, VB.Net , C#,
and Asp.Net.