Case Studies

IP management implementation

Implemented a full IP management solution for an academic and government client in Hong Kong, supporting complex licensing structures, multi‑party royalty distribution, and strict accounting recognition requirements. The system automated compliance workflows, reduced reconciliation time, and improved transparency across departments and external stakeholders.

PostgreSQL ERP design

Designed and deployed a scalable PostgreSQL relational database for a semi‑government ERP initiative, supporting over 100 end users across finance, operations, and procurement. The architecture strengthened data integrity, improved reporting accuracy, and provided a foundation for future modular expansion.

Long‑term outsourced IT support

Provided 10+ years of outsourced IT support, remotely handling Level 1–3 incidents with consistent SLA performance. Delivered proactive monitoring, rapid troubleshooting, and continuous system optimisation, achieving an average satisfaction score above 95% over the past five years.

ERP + AI workflow automation

Delivered end‑to‑end ERP and accounting system deployment for a leading Hong Kong property agency, including AI‑driven workflow automation, dynamic database generation, and an OCR layer for document processing. The solution significantly reduced manual workload and improved operational turnaround time.

MSSQL enterprise deployment

Led MSSQL database design, implementation, administration, and maintenance for a regional insurance company. Built a secure, high‑availability environment with optimised performance, robust backup strategies, and compliance‑aligned data governance.

Oracle migration to 信创

Migrated Oracle databases to 信创/open‑source platforms including TiDB, 达梦, KingBase(金仓), OceanBase(阿里), and PostgreSQL for a Chinese bank. Ensured compatibility, regulatory compliance, performance stability, and smooth cutover with minimal business disruption.