Finance

Implementation of the Data Access Control System

client: International European bank based in Rome

Problem description

The largest banks in Central and Eastern Europe belong to the client (banking group). Their systems differed significantly from each other, so it was decided to gradually unify their IT environments. The Murex system functioned within the banking group in 3 environments: Interest Rate Differential, Treasury and Credit. At the time of the decision to standardise the methods of managing the access to key data, it was decided to implement Data Access Control System (DACS). OpenDACS, i.e. the chosen solution had to be implemented in all banks belonging to the banking group.

Problem solution

The first phase of the project was to check whether transactions released by dealers are in line with the (FX) market. For this purpose, a reporting tool was created that examined this data every 15 minutes. The second phase of the project involved:

  • adding the OpenDACS module to Murex
  • configuration of the OpenDACS module to work with Murex
  • checking whether the OpenDOCS module restricts access to data where it has been thus specified by a business.

The final aspect was to test whether inclusion of the OpenDACS module will affect the performance of the whole system and whether access times exceed established standards.

Industry and energy

A system for EDI message exchange in real time

client: Essent Energy

Problem description

Changes to the law in the Netherlands to liberalise the energy market have caused a sharp increase in EDI standard messages exchanged between the public energy trading market and private companies that are energy market participants. The current systems were not able to cope with the substantial amount of messages, reaching a level as high as 300,000 messages a day. Many of them had a set reaction time limit of no more than 5 minutes.

Problem solution

To streamline the process of message flow in the organisation, it was decided to implement the following solutions:

  •  Launch a mail server acting as an intermediary in the forwarding of messages, based on the Linux system in order to queue messages in accordance with the required response time.
  • Introduce intelligent grouping of messages by existing solutions based on Java/XML, processing EDI messages
  • Owing to the introduction of separate paths based on the priority of messages, it was possible to avoid reconstruction of existing systems. Only minor modification of the TIBCO environment integrating other systems was required.

Logistics

An application to support the logistics department

client: Pfleiderer Grajewo S.A

Problem description

Pfleiderer is a leading supplier of wooden building components in Poland. The significant increase in sales volume and the expanding portfolio of products have highlighted the ineffectiveness and low efficiency of the current transport planning system. The main task of the application developed by eConsulting was to support the logistics department in planning transport and to enable increased use of trucks and ramps.

Problem solution

The application was developed using the Java Swing GUI graphic interface and backend resources run on an AS/400 server. The whole solution was integrated in real time with a secure e-commerce (online shop) solution using WebSphere technology.

Pharmacy

A map of occurrence of a particular disease imposed on the list of locations of clinical trial institutes

client: International pharmaceutical company based in Switzerland

Problem description

Identification of the clinical trial sites in one of the countries (USA) and evaluation in terms of their usefulness in the disease occurrence research. The aim was to select the site/location near which a disease occurs the most frequently and where the research on the same will be the easiest to complete and will give the most precise results.

Problem solution

A web-based application was developed (Spotfire Web Player) presenting maps of the country where the research is conducted (with administrative division into states, counties shown) as well as data in the form of tables relating to the clinical trial sites and the intensity of occurrence of a disease depending on the location (shown with colour gradients).

The user is able to dynamically filter data depending on the characteristics searched for in people in whom the disease was identified (sex, race, age etc.).

Applied technologies:

  • TIBCO Spotfire – an analytical and visualization tool. In comparison to other systems, it loads data and does not use a database thanks to which the analysis and filtering are completed very quickly
  • TIBCO Spotfire Web Player – a front-end for using the analysis completed in TIBCO Spotfire. A component of the TIBCO Spotfire package.
Download extended description of the project

Services and trade

A data exchange system

client: Rawa architectural studio

Problem description

The aim of the project was to develop a system for exchanging data between design offices and individual designers. The architecture studio needed a server for communication between cooperating companies and industry-specific designers. The solution should enable the integration of data produced by individual industry-specific designers, supervised by a head designer. The application is designed to track file changes and enable their automatic synchronisation. The solution should be characterised by easy accessibility, without the need to install software, while the updating process should be conducted in a manner transparent to users.

Problem solution

The effect of eConsulting’s work is an application available via a web browser. The solution is based on the use of SVN Subversion software as a document repository, a system for tracking changes and management of document versions. Furthermore, the solution is based on a database cooperating with a Hibernate library (e.g. PostgreSQL, H2 or another similar library). Tomcat was used as the application server and Apache as the web server. The use of the application is protected by encryption of messages (SSL) which ensures confidentiality of transmissions. Access to the application is protected by a login and password. Part of the server, along with the document repository have been installed on hardware specified by the customer.

Telecommunications

A product lifecycle management system

client: Swisscom AG

Problem description

Due to the specific nature of an organisation operating in the telecommunications industry, the access to information contained in a large number of dispersed systems is of key importance. Along with the company’s development and the expansion of the services offered, new functions are needed in its IT systems. For various reasons (costs, possibilities and time) existing solutions are not always expanded. New applications and systems are created or implemented; thus the number of solutions in the organisation grows, extending time taken by data flow. In order to replace the cyclic exchange of information between systems for real-time access, it was necessary to create a solution in SOA (Service Oriented Architecture) based on an ESB (Enterprise Service Bus).

Problem solution

An EAI class integration solution from the TIBCO Company was used for the integration of existing systems in accordance with SOA. The data bus created on the TIBCO platform enabled integration of many various systems with the TIBCO Human Workflow product. The project required the development of numerous interfaces between the Enterprise Service Bus and the various systems supporting the full lifecycle of new products marketed by the organisation. This included integration of a billing system, a (TIBCO) workflow support product and several smaller systems complying with the paradigm of service-oriented architecture (SOA). The entire project was carried out in accordance with the idea of ​​continuous integration and agile methodology. Integration allowed not only for post-factum analysis, as in the case of traditional data warehouse solutions, but also several other functions, such as: real-time service level management, action-based marketing, and human workflow integration.

Go to top