References / Our work
We implemented a number of unique tailor-made information systems.
Project: Upgrade of editorial system (CMS) for a TV station
- Customer: Ness Slovensko, a.s.
- Purpose: Implementation of new characteristics to the existing CMS (editorial system) according to the requirements of existing/new customers and maintenance and correction of errors in CMS. Implementation of changes and new characteristics also to server services for streaming of live video or VOD (video on demand).
- SW technologies and development tools:
- Oracle Database
- Application server Apache Tomcat
- Spring, Hibernate, Servlets, Struts, JDBC
- Perforce versioning system
- Eclipse
- Dedicated Solutions | Created in year: 2010
Project: Analysis and detail design for IS Production Planning
- Customer: Slovakia Steel Mills a.s. Strážske
- Purpose: The Company Planning System is a tool for calculation of material balance, planned allocation and capacity planning on production lines of the company SSM Strážske. Its main purpose is to provide accurate information about the state of orders fulfillment, a decrease in states of unallocated production-in-progress in warehouses, to enable planning of orders fulfillment with the accuracy of one week, and to specify material flows from production of crowbars/levers through to customers´ warehouses.
- SW technologies and development tools:
- Detailed description of modules and screens in UML 2.0
- Data model created in Oracle JDeveloper application – generated in DB Oracle
- Planning & Logistics | Created in year: 2010
Project: Customer Portal - ISPV SCM
- Customer: Steel company Košice
- Purpose: Information system of support for the steel company delivery chain. The superstructure of the planning system for monitoring the state of orders in SCM regime through the web application with a possibility to simulate consequences of potential changes in the expected customer purchases.

- Num. of users: 50
- SW technologies and development tools:
- Oracle Database 10g Enterprise Edition
- Oracle Application Server 10g Enterprise Edition
- JPA, EJB, Servlets/JSP, JSF, Oracle ADF, XML communications
- Oracle JDeveloper
- Web Solutions | Created in year: 2009
Project: Internet Reservation Portal - IRP
- Customer: ESTEN s.r.o.
- Purpose: Universal internet reservation portal enables to make reservations of equipment/premises/sports fields for a certain period of time. The system can be used in healthcare, trade and other areas or industries.

- SW technologies and development tools:
- MySQL / Oracle 10g DB / possibility to use also other DB
- Tomcat 6.0
- Hibernate, Spring, GWT, SmartGWT
- Eclipse
- Web Solutions | Created in year: 2009
Project: Sales and Production System - PVS
- Customer: STRING - embroidery
- Purpose: Complex and universal sales, planning and production registration system for mechanical automated embroidery plants. The system can also be used in other small manufacturing plants.

- SW technologies and development tools:
- Oracle Database 10g XE – freeware version of database
- Sybase PowerBuilder using PowerBuilder Foundation Class library
- Planning & Logistics | Created in year: 2009
Project: Subdelivery for postal system of payment
- Customer: IT Konzult for Slovenská pošta (Slovak Post)
- Purpose: Development of a module for the information system of Slovenská pošta for generation of reports. The module generates reports in batch or manual modes. The batch mode contains reports for the hybrid post.
- SW technologies and development tools:
- DB Oracle
- .NET C#
- Oracle Windows Forms using three-layer architecture
- Dedicated Solutions | Created in year: 2007 - 2009
Project: Subdelivery for the system of Cargo
- Customer: VSL a.s. for ZSSK Cargo Slovakia
- Purpose: The system ISP is a complex information system, which serves as a support for all areas of operation in the railway company Cargo Slovakia. The system is based on J2EE architecture with the central database and application logic placed in the centre. It uses the intranet technologies with support of a web client (and mobile equipment). It is integrated with the business system SAP R/3, communicates with information systems of the infrastructure administrator (ŽSR), business partners and international network Herms.
- SW technologies and development tools:
- ORACLE 10g Enterprise Edition
- portal SAP NetWeaver
- J2EE
- Web Solutions | Created in year: 2007 - 2009
Project: Global Monitoring of CO2 – GBCO2
- Customer: Steel company Košice
- Purpose: Information system for calculation of balances of CO2 and balances of energy in the steel company for a calendar year with a possibility to monitor development of balances throughout the year. The system is determined for the whole corporation; it solves the problem of national environments (multilingualism), time zones and conversion of physical units. All functions of the system are accessible through the web interface.

- Num. of users: 100
- SW technologies and development tools:
- Oracle Database 10g Enterprise Edition
- Oracle Application Server 10g Enterprise Edition
- Hibernate, Spring, Servlets/JSP, JSF, Oracle ADF, Web services
- Oracle JDeveloper, XML communications, Eclipse
- Web Solutions | Created in year: 2007 - 2009
copyright 2008 - 2012 ESTEN s.r.o.