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.

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.