Domain: Real Estate
The client is a leading property development and management services provider serving global clients with head office in the UAE. With more than 5 business segments and 50+ active companies, the client is one of the most renowned real estate company across North America, Asia, Middle East, Africa and Europe.
Considering the huge customer base and enormous data generated involving a wide range of data systems, the client company confronted numerous business challenges.
- Multiple data sources and data formats with multiple file extensions
- Manual processes to manage large volume transactions
- Manual effort for data massaging and cleansing
- No centralized data source
- Multiple source systems is the biggest challenge in daily reconciliation of transactions at organization level
Considering high volume transactions and unavailability of a centralized source system, technical and domain experts at Cygnet suggested implementation of a centralized data warehouse.
- Designed and developed a central data warehouse and integrated all the source systems
- Designed and developed TestingWhiz Connected for data extraction and data massaging
- Also developed an automation tool to automate the data uploading process on Cygnet Tax application
- A report was developed that gives transaction counts comparison to users between source systems and Cygnet Tax Application