Project
Reporting & Analytics API
Read-optimized reporting endpoints aggregating sales and usage metrics for leadership dashboards.
- Node.js
- PostgreSQL
- SQL
- Express.js
- Wrote aggregation queries with date ranges and filters
- Indexed reporting tables for common dashboard filters
- Cached expensive summaries with short TTLs
- Returned chart-friendly payloads for frontend widgets