In the product MileIq, I wrote a Job which aggregates last 1 month data of a user to determine the location visited a maximum number of times by the user. This location is set on the map when a user comes to miles dashboard.
- Data Aggregation Job running on AWS RedShift.
- The resulted analysis is uploaded to S3 in text files.
- From S3 data moved to Postgres database.
- Exposed API’s to fetch the most frequent location for each user.
- When a user visits MilqIQ dashboard, they see map loaded with relevant location personalized to their use case.