DATA PLATFORM FOR ONLINE TRAVEL BUSINESS
Leading Travel Business: Data Platform for Analytics
&
BI (UAE)
About the Company
One of the largest Online Travel, Hotel and Flight Booking Platform in UAE.
Objective
Deliver KPI Dashboards by implementing a Data Lake inline with long term goal for customer
segmentation and targeted marketing campaigns automation.
Problem Statement
Lack of one view of Customer Info and No consolidated data view for products and services
including reports.
Challenges
Multiple sources of unstructured data with no one data owner and fixed requirement. Extensive
Testing and Data Validation for Quality Assurance.
Solution Implementation
- Building common connectors for identified structured/semi-structured and unstructured data
sources using FilePull, Mongo Connector, FB Connector, GAd connector, Adjust Connector.
- Complete Configurable Control by changing JSON transformation and adding new source
account/campaign with ETL workflow.
- Scalable Data Platform Architecture using Hadoop, HDFC, Hive, mySQL for data storage,
transformation, data aggregation and complex KPI calculations using Map Reduce.
- Rich KPI Dashboards with very strong visualizations and widgets for key stakeholders –
Management, Operations and Sales/Marketing teams.
- Strong Monitoring of scheduled and real-time ETL processes and data ingestion pipelines.
- Selenium based Test Automation for data validation.
- Two generations of the platform – 1st implemented On premise and next migrated and
implemented on AWS.