Performance analytics tool that measures transaction speed and efficiency across multiple stores. Leverages daily data retrieval from store POS systems to provide actionable insights.
Technical Specs
Daily task scheduler/cron module retrieves store transaction data, with queries running each day to connect to multiple store databases, gather data, and insert it into the app's database.
Uses a mix of raw CSS and vanilla JavaScript.
Codebase is functional with an object-oriented approach.
Utilizes PDO for database interactions.
Initially deployed on an Apache 2 physical server, later migrated to Amazon EC2 with CentOS 7 OS.
Features
Internalization; English and French
Can select different transaction types:
Per store, hourly, half hourly, breakfast, mid-morning, lunch, afternoon, dinner evening, late night.
Dine-in
Take out
CSV Importing
Exportable through; csv, excel, pdf
Total cashier's transactions time
Preparation time
Total transaction time
Average time per transactions
Speed of service dashboard - Overall computation summary. Average transaction time, hit rate and ranking per store.
Role
Contributions
Responsible for overall development including UI/UX design
Freestyle design, no wireframes
Worked closely with project manager, system analyst and system admin