• Led the development of the AAN system from scratch, utilizing Typescript, AWS Lambda, DynamoDB, IAM Role, and Terraform to handle email notifications for daily KYC checks and Credit Limit changes.

• Optimized data analysis and reporting with automated extraction, loading, and transformation of raw data into Snowflake models and views using dbt.

• Built a flexible file synchronization system between SFTP and S3 bucket using Dotnet and AWS ECS Fargate.

• Designed and integrated the Orchestration layer for internal credit/debit transaction adjustment with I2C, including authentication middleware.

• Developed a shared DB migration tool for data fixes in production environments without any deployment, streamlining data management processes and reducing the risk of errors.

• Reduced pipeline running time by 50% through conditional building and triggering.

• Centralized and minimized public-facing load balancer for all CCAAS operations, reducing the cost of request load balancing.

• Worked on a large-scaled and distributed user group syncing system using SpringBoot and Java as the back-end.

• Migrated the database from Cassandra to Oracle, including database structure and Dao layer design.

• Migrated cache from Ehcache to Redis cache to improve performance.

• Integrated various tools, including Slack, Miro, Quip, Box, Wrike, and Oomnitza, with Apple Directory for provisioning, de-provisioning, and group syncing.

• Developed a single-page web application using React as the front-end and reactive Java as the back-end for the operation team to view data and transfer content more efficiently.

• Implemented nightly and periodic cache syncing modules to keep the cache and Apple directory synchronized.