Designed and deployed a modular, API-driven reporting dashboard system for a fast-scaling SaaS client in the healthcare tech sector. The dashboard aggregates data across PostgreSQL, external APIs, and internal services, delivering real-time visualizations and downloadable reports with built-in access control.
Key features included secure authentication (OAuth2 + JWT), endpoint-level role enforcement, custom filters, and dynamic queries. Integrated seamlessly with a React frontend and allowed non-technical users to schedule and export reports from within their workspace.
Skills and Deliverables:
Python (FastAPI)
PostgreSQL + dynamic SQL builders
Secure API with RBAC and token-based access
OAuth2 authentication with refresh handling
Scheduled report generation with delivery (via SMTP)
Admin panel endpoints for role/user/report management
Swagger/OpenAPI documentation
Real-time metrics endpoint (for charts/graphs)
CI/CD deployment on Dockerized AWS stack