Website for Atlantic-Pedia Members

This project focuses on enabling seamless digital transactions through a responsive web interface. It includes features such as user authentication, profile management, balance tracking, transaction processing, e-wallet and bank transfers, as well as detailed transaction history. To enhance security, the system is integrated with multiple protection mechanisms, including Google Authenticator, and supports various payment methods and service providers to ensure a faster and more efficient transaction experience. As part of the backend development, I also redesigned the database schema to improve system efficiency and scalability. The data structure was optimized to handle high transaction volumes, accelerate query execution, and maintain data integrity. This process involved normalizing tables and adjusting indexes to reduce data duplication and improve overall system performance. Key features include: • Mobile-Optimized Web Interface • Secure Authentication with Google Authenticator • User & Profile Management • Balance Management • Multi-Provider Service Integration • Payment Gateway Integration • Bank & E-Wallet Transfers • Transaction History & Filtering

One of the main challenges during system development was the poorly structured legacy database, which led to data redundancy and slow query performance. Additionally, differences in structure between the old and new databases made it impossible to migrate transaction history. The previous system also faced potential race conditions during transactions, which in some cases resulted in negative user balances.

To address these issues, the database schema was normalized and indexes were optimized to improve storage efficiency and query speed. User data was successfully migrated to the new system, while transaction records are now handled directly within the updated structure. To ensure data consistency and prevent transaction conflicts, ACID-compliant transactions were implemented along with row-level locking mechanisms.