Dandi Pangestu

• Led the optimization of all reporting endpoints, successfully reducing latency by approximately 60% through advanced query tuning and improved indexing strategies, resulting in faster and more efficient data retrieval.
• Integrated Meta APIs to enable seamless connectivity and feature support for platforms under Meta, including WhatsApp, Instagram, and Facebook, enhancing product capabilities and user engagement.
• Migrated broadcast reporting infrastructure from Postgres to Metabase, utilizing AWS Athena as the data source to improve scalability, query performance, and analytical flexibility.
• Implemented various performance enhancements for Postgres queries, including the use of Common Table Expressions (CTE), multi-column indexing, and materialized views, significantly reducing response times across the platform.
• Addressed real-time chat notification delays by migrating from FCM to Vernemq WebSocket and developed an ACK (Acknowledgement) system for more reliable tracking and reporting of message deliveries.
• Designed and built a real-time chat counter system leveraging Kafka, Flink, and Clickhouse, providing accurate and high-throughput metrics for chat activities.
• Improved and consistently maintained the Chat Broadcast Service Level Objective (SLO) at 99.9%, ensuring high reliability and user satisfaction.
• Enhanced WhatsApp broadcast throughput by implementing dynamic throttling with Sidekiq Throttled, resolving persistent queuing issues, and successfully reducing Meta rate limit errors from over 1,054,871 to zero.
• Initiated the migration of Sidekiq and RabbitMQ workers from virtual machine (VM)-based infrastructure to Kubernetes, enabling better scalability, reliability, and operational efficiency.
• Resolved latency issues in the delivery of external webhook endpoints by re-architecting the webhook system into an event-driven architecture, introducing a scoring mechanism for endpoints based on latency, and segmenting worker queues according to these categories for optimal performance.
• Collaborated closely with the DevOps team to implement Kubernetes Horizontal Pod Autoscaler (HPA) using Datadog metrics and Keda, enabling automatic scaling of Sidekiq workers based on workload demands.
• Provided mentorship to several team members, supporting their individual initiatives and fostering a culture of continuous learning and professional growth.
• Developed a high-performance email broadcast service from scratch using Golang, Kafka, and Alicloud Direct Mail, utilizing Go routines for efficient multithreading.

Technologies: Ruby, Golang, Postgres, Elasticsearch, Redis, Kafka, RabbitMQ, Sidekiq, Vernemq, AWS, Alicloud, Kubernetes, Datadog, Grafana

• Led the end-to-end development of the Corporate Member project from scratch using Ruby, delivering a robust and scalable solution tailored to business needs.
• Maintained and enhanced the Main App SehatQ and the Telemed Doctor project, ensuring reliable operations and continuous feature improvements.
• Upgraded CMS services and other internal systems by leveraging Ruby on Rails and AWS, significantly increasing operational efficiency and system reliability.
• Served as the lead for the SehatQ content team, overseeing and managing all content-related processes and initiatives.
• Reduced latency for content endpoints by implementing effective caching strategies, resulting in faster content delivery.
• Improved search functionality by integrating Elasticsearch, which greatly enhanced the user experience through faster and more accurate search results.
• Developed a dedicated service for reindexing data into Elasticsearch, decoupling it from the main service to ensure better scalability and maintainability of the overall system.

Technologies: Ruby, Postgres, AWS, Elasticsearch, Redis, RabbitMQ, Kubernetes, New Relic

• Developed RESTful APIs for Logan Main Apps using Golang, ensuring robust and scalable backend services.
• Designed and implemented microservices for Warehouse Apps utilizing Golang, gRPC for efficient inter-service communication, and Kafka for executing asynchronous process.
• Built microservices for Internal Apps with Golang, gRPC, and Kafka, enabling seamless integration and high-performance data flow across internal systems.
• Engineered microservices for Invoice Funding Apps using Golang, gRPC, and Kafka.
• Developed an Autobidding Application for real-time auctions, leveraging Golang and Kafka for backend processing and Socket.io for real-time websocket communication, ensuring a smooth and responsive bidding experience.
• Implemented comprehensive unit testing for all codebases, achieving 93% code coverage to ensure code reliability, maintainability, and early detection of issues.

Technologies: Golang, Kafka, gRPC, Socket.io, Postgres, Kubernetes

• Developed RESTful APIs for Pawoon POS main apps and sales dashboards.
• Integrated Gopay for POS payments and Jurnal for accounting automation.
• Re-architected billing system from monolith to client-server, reducing technical issues.
• Implemented unit testing in the new billing system, achieving 98% code coverage.
• Coached the team to adopt unit testing practices in PHP Laravel.
• Mentored interns to build an HRIS system from scratch with Golang.
• Led and managed an internal team of four members.

Technologies: PHP, Laravel, AWS, SQS, MySQL

• Designed and developed server-side RESTful services using Spring Boot and Ruby on Rails.
• Migrated RESTful services from Spring Boot to Ruby on Rails.
• Built the seller web application with Ruby on Rails.
• Conducted testing, debugging, and assisted in database schema design.
• Analyzed industry trends to recommend new tools and methods.
• Provided weekly reports, technical guidance, and task estimates to the team.

Technologies: Ruby, Java, Springboot, Postgres, Redis

• Designed and developed server-side RESTful services with Spring Boot.
• Designed database schemas and led a backend development team.
• Defined API contracts for backend developers and performed testing/debugging.
• Responded to critical system issues and maintained Linux servers and AWS infrastructure.
• Analyzed industry trends to recommend new tools and methods.

Technologies: Java, Springboot, AWS, Linux, Redis, MySQL

• Designed and developed robust server-side RESTful services using Spring Boot and PHP Lumen, ensuring scalable and maintainable backend solutions.
• Created efficient and well-structured database schemas to support application requirements and data integrity.
• Developed multiple features for the main web dashboard using Laravel, enhancing user experience and system functionality.
• Effectively resolved development issues through timely and proper troubleshooting, ensuring project deadlines were met.
• Conducted thorough testing and debugging to deliver high-quality and reliable software.
• Actively participated in learning and applying core software engineering concepts, including algorithms, object-oriented programming, and SOLID principles, to improve code quality and maintainability.

Technologies: PHP, Lumen, Java, Springboot, Laravel, MySQL, Redis, Websocket