API for Web App Dashboard for scheduling, dispatching and tracking campaigns
- Maintained Django APIs and MySQL database powering mobile app and admin portal.
- Wrote efficient Stored Procedures to replace Django ORM queries and unnecessary serializers.
- Optimized SQL queries and aggregation endpoints for analytics dashboard, doubling data output while maintaining speed and adding search filters.
- Wrote k6 tests to benchmark API performance across all environments.
- Enhanced PDF generator for canvasser routes and instructions.
