BK – CSV Upload Service to migrate school data

Led a team of 3 developers on a nightly job to migrate School District data through CSVs instead of burdening school administratorsFeatures with manual data entry.
Client Journey:

Initial Client Meetings

  • Came up with an architecture to pull CSVs from their servers nightly
  • Advised their IT teams on how to structure their exported data

Consulted on these items:

  • Usernames of parents should be their emails to make it easier to remember
  • Not spend development time handling > 300K records since nightly updates are only ~100 records.

Project Completion

School principals thanked us for never having to fill out a student form again.

Video Overview: