Creator Management System
• Designed and developed a scalable backend system incorporating 15+ RESTful APIs for managing creator data and campaign operations, leveraging Spring Boot and AWS RDS. The system automated repetitive tasks, saving the team 2+ hours daily, and increased monthly GMV by 200%.
• Streamlined multi-environment CI/CD pipelines using AWS Elastic Beanstalk, Nginx, and rsync, achieving seamless deployment environments(local, test, beta, and prod) with minimal downtime.
• Collaborated with cross-functional teams to deliver scalable solutions, ensuring smooth integration across backend and frontend systems, which improved development efficiency and reduced project delivery time by 20%.
Database Performance and Data Cleaning
• Enhanced database performance for 10M+ records, reducing query latency by 50% through optimized SQL queries and partitioning techniques.
• Implemented a scheduled system with Spring Scheduling working with Lark API and Gmail API to automate bidirectional data synchronization and Gmail Inbox updates for 1.2M+ records, reducing manual workload by 50% and improving data sharing accuracy by 80%.
• Developed advanced de-duplication logic for creator records using Hibernate Criteria API, ensuring data integrity across 15M+ records datasets and reducing redundancy by 40%.
• Automated data validation and deduplication using Spring Batch, cutting manual efforts by 70%.
Email Campaign and Creator Data Integration
• Automated email workflows using Mailchimp API, enabling role-based access control and increasing email campaign throughput by 300%.
• Built a centralized dashboard to monitor email click-through and reply rates, helping refine targeting strategies and improving campaign engagement.
