Drive Vicinity

Published in Microsoft India Development Center, 2017

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.