Est. Budget: $1,500.00
Proprietary security system stores all data into set of huge XML files.
- employee ID
- security card ID
- event (when employee enters / exists the office)
- create model in PostgreSQL to store entities
- create job in Pentaho Kettle that will take XMLs, parse them, and load into database
- create job that aggregates events into hours that employee spend in the office