Data Warehouse Solutions

· Data Warehouse
· e-Business Intelligence
· Re-Engineering of DW applications
· CRM Data Warehouse
· Data Warehousing Implementation
· Data delivery applications
· Data integration

Case Studies
· Business Management System
· Data Warehouse WAP System
· Cell-phone Users Survey
· BI Platform Development
· Data Warehouse Reporting Portal

Data Warehouse Technologies

OLAP tools:MicroStrategy, Brio, Business Objects, Cognos, Hyperion, Informix Metacube

ETL tools: Informatica, Datastage, Datajunction, DataMirror

Databases: Oracle, MS SQL Server 2000, Sybase, DB2, Informix, Redbrick, Teradata;

Datamining Tools: SAS Miner, Intelligent Miner;

End to end tools: SAP Business Warehouse suite and Oracle Data Warehousing product suite


Database Consulting

· Offshore Database Consulting
· Embedded Database Development

Case Studies
· Database programming

Offshore CRM Data Warehouse Solutions Development

What is CRM? CRM stands for Customer Relationship Management. It is a strategy used to learn more about customers' needs and behaviors in order to develop stronger relationships with them.

Goals of CRM

• provide better customer service
• make call centers more efficient
• cross sell products more effectively
• help sales staff close deals faster
• simplify marketing and sales processes
• discover new customers
• increase customer revenues

Some examples of the types of data CRM should be collecting

• Responses to campaigns
• Shipping and fulfillment dates
• Sales and purchase data
• Account information
• Web registration data
• Service and support records
• Demographic data
• Web sales data

Our CRM data warehouse solution combines our expertise in CRM with extensive experience in data warehousing.

SolovatDesign's analytical CRM data warehouse solution framework offers the following:

· Data model to capture and track customer product holding, product usage, contact history and events

· A well defined process model for design, development and implementation

· Focus on data cleansing, match & merge and ETL to integrate customers