Software Engineer
Current1. System Development and Maintenance: Responsible for the development and maintenance of the backend Customer Relationship Management (CRM) system for a publicly listed large-scale enterprise, managing over 2 million customer records. Designed and implemented API integrations using a microservices architecture to ensure seamless client application operations.2. Database SQL Optimization: Optimized complex SQL queries and multi-table associations, achieving an average API response time of under 1 second. Applied indexing optimization and query restructuring to significantly enhance data query efficiency.3. Feature Development and Design: Designed and implemented consumption data collection and coupon issuance functions, leveraging Redis caching to reduce database load and utilizing message queues (MQ) to handle up to 200,000 data entries. Developed performance-optimized and stable solutions, considering network stability and memory resource constraints during the design process.