Aircel India is a telecom operator providing GSM services. the Database Design Specification for the Operational Data store (CRM and Billing) of Aircel IT Transformation project. It defines the various entities to be refreshed into the ODS from source systems. Additional details will be added to the document as more information becomes available from the source system. In data centre has 200 databases on production 150 databases pre- production and 100 database on testing and development. Handled the all database structure of Aircel telecom project. CRM software encompasses all aspects of communication an organization has with its customers, including sales, service and marketing.