GuardianVets
Guardianvets is an after hour pet care platform where you can get emergency services on call, book an appointment or chat with our customer service rep or call directly for emergency situations. The project had the database that was 719GB in size. Handling the data was a problem in itself.
Key Features
- check_circle
Built and optimized large-scale data systems spanning PostgreSQL and MongoDB, processing and synchronizing hundreds of gigabytes of production data.
- check_circle
Implemented ETL pipelines and materialized views that significantly improved query performance, reporting reliability, and operational visibility.
- check_circle
Created materialized views to show data to the user in near-realtime.
- check_circle
Used agendaJs to create ETL pipelines to extract, transform, and load data.
- check_circle
Utilized aggregation pipelines to calculate statistics data and send it to the user.
- check_circle
Implemented functionality to create reports in Excel format.
- check_circle
Developed a dashboard displaying total appointments, calls, chats, convergence rate, and ER referrals.
- check_circle
Setup read replicas for MySql database hosted on AWS RDS.
Technologies Used
Project Role
Team Lead
Timeline
2022
Visual Gallery
Screenshots & Prototypes
