Precious Metals Management Platform – Client & Leasing Subsystems

The Precious Metals Management Platform is a financial business system that supports client contract management, fee settlement, collection processing, and gold leasing operations.

The platform consists of multiple business subsystems. The Client Subsystem manages fee settlement and collection for individual and corporate client contracts, while the Leasing Subsystem supports gold leasing contracts for corporate clients.

As a financial-grade system, the platform processes more than RMB 1 million in daily transaction volume, with a total contract value exceeding RMB 100 million. The system required high reliability, data accuracy, operational traceability, and strong support for batch processing and reporting.

Project Background

The original system needed to support growing business requirements, reporting integration, database migration, and performance optimization. As the business scale increased, the system also required better maintainability, more stable batch processing, and improved compatibility with the company’s infrastructure strategy.

The project focused on:

Migrating the database from Oracle to OceanBase.
Improving batch processing performance and maintainability.
Supporting system reporting and integration with the reporting platform.
Upgrading system dependencies for better security and stability.
Optimizing system performance for high-value financial business scenarios.
Improving documentation and delivery processes for long-term maintenance.

System Architecture

The system adopted a Java-based enterprise architecture with Spring MVC, Spring Boot, MyBatis Plus, Redis, Oracle, OceanBase, Docker, and Kubernetes. It supported contract management, settlement processing, batch jobs, reporting integration, and financial transaction-related data processing.

My Role

In this project, I contributed to database migration, reporting feature development, system optimization, dependency upgrades, and batch processing subsystem refactoring.

My work focused on improving system reliability, maintainability, performance, and compatibility with the upgraded infrastructure.

office

Personal Contributions

Database Migration from Oracle to OceanBase

Participated in migrating the system database from Oracle to OceanBase.
Adjusted SQL scripts, database access logic, and persistence-layer behavior to support the new database.
Helped resolve compatibility issues caused by differences between Oracle and OceanBase.
Supported data validation to ensure business data remained accurate after migration.

Reporting Feature Development

Developed and delivered system reporting features for business and operational analysis.
Integrated the system with the reporting platform.
Supported data extraction, report generation, and reporting-related business logic.
Helped improve data visibility for contract management and financial operations.

System Optimization

Implemented multiple system optimization tasks to improve performance, stability, and maintainability.
Upgraded system dependencies to more secure and stable versions.
Improved system integration with internal platforms and infrastructure components.
Supported performance tuning for key business workflows and data processing logic.

Batch Processing Subsystem Refactoring

Led the refactoring of the batch processing subsystem.
Improved the structure and maintainability of batch job logic.
Optimized batch processing efficiency for large-scale contract and settlement data.
Reduced operational complexity and improved system stability for scheduled financial processing.

Technical Highlights

Financial business system development
Client contract fee settlement and collection processing
Corporate gold leasing contract management
High-value transaction and contract data processing
Oracle to OceanBase database migration
SQL compatibility adjustment and data validation
Reporting platform integration
Batch processing subsystem refactoring
Performance optimization and dependency upgrade
Backend development with Java, Spring MVC, and Spring Boot
MyBatis Plus-based persistence layer development
Redis-based caching support
Containerized deployment with Docker and Kubernetes