Healthcare

ERTL Shopping Center

Development of a voucher transaction system

The Client

Since 1954, the ERTL Shopping Centre in Bamberg has been setting the standard as the largest shopping centre in the region. Family-run for almost three generations, it combines traditional charm with a modern shopping experience. Our careful selection of stores and our commitment to excellent customer service set us apart from other centres. The ERTL Zentrum offers a unique atmosphere that harmoniously combines tradition and innovation. A visit to us means quality, variety and enthralled.

GENERAL INFORMATION

Objective

  • Establishing a comprehensive gift card transaction processing solution that would enable gift cards to be loaded and redeemed in all the shopping centre's stores.
  • Integrating a billing and clearing function for the various stores operated under different billing parties.
  • Developing an intuitive and user-friendly system to ensure a high level of acceptance and satisfaction among employees.

Challenge

  • Ensuring scalability and high availability of the system to avoid outages that would affect the sale and redemption of vouchers.
  • Implementation of maximum security standards in the application to ensure data integrity and confidentiality.
  • Transfer of existing vouchers and transaction data into the new system without data loss or corruption.

Result

  • Successful launch of the system with the ability to process transactions in real time.
  • Direct connection to existing point-of-sale systems and implementation of a REST API for integrating third-party systems.
  • Ensuring a highly available application through redundant infrastructure and comprehensive monitoring.
  • Implementation based on modern technologies such as Docker and a CI/CD pipeline, supplemented by automated tests.
  • Introduction of a highly secure Print@Home

TECHNICAL DETAILS AT A GLANCE

High Availability

To ensure seamless availability and performance of the application, a scalable architecture based on Amazon Web Services (AWS) was implemented. This includes the use of load balancers for optimal distribution of incoming data traffic, in-memory caching to accelerate data access, and auto scaling groups that dynamically adjust to load requirements.

  • Load balancing: Use Amazon Elastic Load Balancing (ELB) to distribute network and application traffic across multiple server instances.
  • In-memory cache: Use Redis or Memcached to minimise latency and maximise throughput.
  • Automated scaling: Configure Auto Scaling to automatically adjust resource capacity according to current demand.
  • Error monitoring and correction: Implement automated tests in the CI/CD pipeline to detect possible errors early on and use continuous monitoring to monitor system status in real time and take immediate action.
  • Redundancy: Set up a duplicate infrastructure in different AWS Availability Zones to ensure seamless failover.

Clearing & Settlement

Processing and financial clearing of voucher transactions across different locations requires a sophisticated and automated system that seamlessly supports both the purchase and redemption of vouchers. An automated clearing system has been developed that ensures an efficient flow of funds between the parties involved.

  • Transaction management: Automatic recording and administration of all voucher transactions between points of sale.
  • Balance calculation: Monthly calculation of the financial balances between the parties involved to ensure correct billing.
  • Document generation: Automated creation of detailed transaction histories and billing documents that contribute to transparency and traceability.
  • Financial reports: Integration of reporting tools for the creation of comprehensive financial reports in real time.

REST-API

The application was developed using an API-first approach, whereby an OpenAPI document was created first to ensure consistency and predictability of the API implementations. The REST API is the backbone of system interactions, including integration with point-of-sale systems and the Print@Home service.

  • API-first design: structured development based on predefined OpenAPI specifications.
  • Integration: Connecting various external systems such as point-of-sale systems and online services to enable broad use of the API.
  • Security measures: Implementing modern security protocols and authentication mechanisms to ensure data security and integrity.
  • Maintenance and documentation: Providing extensive developer documentation and regular updates to the API to improve usability and customisability.

Print@Home

The Print@Home system allows customers to purchase, print and immediately redeem vouchers from the comfort of their own home. The technology seamlessly integrates payment processing and the printing process, supported by a robust API that guarantees secure and immediate voucher issuance.

  • User-friendliness: Simple interface for the end user to purchase and print vouchers.

  • Instant validation: Automatic verification of incoming payments and immediate issuance of the voucher.

  • QR code functionality: Integration of QR codes that enable quick and secure verification of the voucher when it is redeemed.

  • API integration: Seamless integration of functions into the central REST API to ensure a consistent user experience.

This site is registered on wpml.org as a development site.