Technologies

 

Kunde:	Mercer Alternatives AG
Applikation:	Mercer
Technologie:	Web2Py, Python , MySQL

Mercer Alternatives AG is an independent Swiss investment advisor for institutional investments in private equity, real estate and infrastructure. With more than 130 employees at its offices in Zurich and Nyon, Mercer is one of the leading providers of pension advice, investment consulting and solutions as well as advice on human capital and compensation management in Switzerland.

The company offers individual advisory solutions and collective investment vehicles, as well as investment controlling and reporting services.

soXes has developed an application for Mercer to calculate the total expense ratio, or TER (Total Expense Ratio). The Total Expense Ratio is a key figure that puts all administrative costs of an investment vehicle in relation to the assets under management.

The calculation basis (funds and their net asset value as well as investors and their units per fund) is imported from a central system via an import interface into the Mercer TER application. In contrast, the management costs are entered manually. Based on this data, the application calculates the total cost ratio per investor for their investments at the touch of a button. The results can be output as PDF or Excel reports and distributed to the investors. A user management function allows the distribution of roles with different authorizations.

The Mercer web application is programmed in Python and the data is managed in a PostgreSQL database.

soXes developed the initial web application in 2013 and since then has further developed the TER application in the context of change requests. In 2019 soXes received a refactoring order. The data model was fundamentally revised in order to better represent fund of fund structures (multi-level hierarchy) and at the same time the technology stack was updated.

With today's solution, calculations are more efficient, significantly faster and easier. This reduces the source of errors and enables significant time savings. The documents are now stored centrally and clearly arranged at the right place and are available at any time. In addition, the proportionate total cost ratio for an investor in complex investment structures can be calculated in the desired level of detail.

 

Kunde:	Wiegand AG
Applikation:	Wiegand
Technologie:	JAVA, SOA, SQL, Java Script, Angular JS, Python, Phone Gap, Mobile, Unit Test, Build Server

Wiegand AG, based in Bülach, specializes in drug management and hospital logistics. It develops concepts for medication processes, storage and transport of medication and consumables in hospitals and homes.
 
In a comprehensive IT project of more than 2 years duration, with a team of 7 developers, Wiegand AG has commissioned soXes to develop a secure, fast and reliable system that ensures the management of medication in hospitals. This comprehensive system is based on four pillars: WMCC (central management server) WMPS (directional station), WM5R (mobile device for dispensing) and the MedManager Cockpit (WMCP)
 
The WMPS straightening station is primarily concerned with the electronic support of the set-up or preparation of medication. Via 2D barcode readers, all medications for straightening are identified and managed - including LOT and expiry dates, if available. Step by step, the straightening station guides the nursing staff both when straightening medication into the distribution dispenser and when providing individual medication. The electronic prescription provides information about the medication, preparation and dispensing. Straightening and dispensing activities are compared with the time axis. Traffic light functions signal the urgency status of the activities.
 
WM5R is a mobile app that runs on various operating systems and devices. It ensures that medication can be traced back to the patient's bedside, thus ensuring traceability and medication safety by allowing the dispensing process to be logged directly at the patient's bedside. The WM5R app implements the 5-R rule: right patient, right drug, right dosage, right application, right time.  Both the entries from the WMPS and the WM5R are automatically fed back into the hospital system.
 
The WMM environment can be managed with the web application WMCP Cockpit. In addition to user and group administration and an overview of patients and prescriptions, this includes a very large part of logistics. The entire supply of the pharmacy and central warehouse as well as the ward can be monitored and coordinated via WMCP. The staff has an overview of the stock levels of all wards everywhere and at any time via a web-based interface. Orders are automatically triggered or manually released and transmitted to the purchasing system. Thus, every material movement is automatically saved (date, user, patient). Evaluations per package, LOT, expiration date, etc. make it possible to trace the movements in detail. The automatic ordering procedure is a central component of this solution and is implemented based on three principles:
1. directional station: according to the dispensations (consumption), the system determines a forecast of the future demand for a drug.
2. kanban: orders are automatically triggered when stock levels fall below a certain level.
3. autoinventory: special cabinets with scales, especially for consumables, allow a completely automatic warehouse, which determines the stock and the necessary orders by weight.
 
The Wiegand drug management system is based on the Java programming language with a PostgreSQL database in the background for WMCC and WMPS. The WMCP was implemented with Python on the server and AngularJS, Bootstrap and HTML5 on the frontend. The WM5R app runs under Phonegap (Apache Cordova) on all major mobile platforms. Throughout Switzerland, the system has already been successfully implemented in several hospitals and connected to the local hospital information and prescription system, while maintaining the HL7 (Health Level 7 an international standard for the exchange of data between health care organizations and their computer systems) standard.