References / Our work
We implemented a number of unique tailor-made information systems.
Project: Master Planning Module – MPM ISPV
- Customer: Steel company Košice
- Purpose: Information system of support for strategic planning of the metallurgical plant taking to account sales plans of individual assortments and the actual planning module. The tool for creating annual, quarterly and weekly business plans as well as creating alternative plans.
- SW technologies and development tools:
- Oracle Database 9i Enterprise Edition
- Oracle Forms & Reports
- Planning & Logistics | Created in year: 2005
Project: IS Production Planning - ISPV
- Customer: Steel company Košice
- Purpose: Information system for capacity and material planning of continuous metallurgical production which enables online re-planning and planning of orders in real time. The system also provides a detailed summary about the actual state of an order. Support for SCM, PCS, online allocations, managerial reports and graphs for support of operational management.
- Num. of users: 800
- SW technologies and development tools:
- Oracle Database 9i Enterprise Edition
- Oracle Forms & Reports
- Planning & Logistics | Created in year: 1999 - 2009
Project: Tanks - Tank Management
- Customer: Steel company Košice
- Purpose: Protection of persons and environment against the harmful effects of stored dangerous substances. The environment protection includes water and air. It fulfills the requirements of the law and the audit results related to records of tanks and stored substances in the information system. The system supports generation of the photo documentation of tanks through PDA as well as the identification of tanks using a barcode.
- Num. of users: 70
- SW technologies and development tools:
- Oracle Database 9i Enterprise Edition
- Sybase PowerBuilder using PFC
- MS Visual Studio .Net, C#
- Dedicated Solutions | Created in year: 2006 - 2007
Project: Plannig of product checking and quality management IS – PKaRV
- Customer: Steel company Košice
- Purpose: Information system enables to automatically generate the plan of check and quality management for a product or semi-finished product; the plan is the basis for control by comparing the real measured values from the production process to the required, planned parameters. These plans of quality control with the control results can serve as the basis for various audits as well as decision making in claims.
- SW technologies and development tools:
- Oracle Database 9i Enterprise Edition
- Oracle Forms & Reports
- Oracle Application Server 10g Enterprise Edition
- JPA, EJB, Servlets/JSP, JSF, Oracle ADF, XML communications
- Planning & Logistics | Created in year: 2008
Project: ToolEast
- Customer: for several engineering companies - the project was co-financed by the EU
- Purpose: Universal ERP and OMS system for Eastern Europe engineering companies based on the existing Open Source system.
- SW technologies and development tools:
- DB MySQL
- Java, J2EE, JPA, EJB, Servlets/JSP, JSF
- Eclipse
- Planning & Logistics | Created in year: 2006
Project: Design of technological planning of a production line – NTPL
- Customer: Yazaki Wiring Technologies Slovakia s.r.o.
- Purpose: Information system for design of technological planning for production of cable bundles for cars. The system is primarily determined for technologists, for whom it provides the necessary tools for recording the procedures with their versions, work with the structured parts bills (bill of materials – BOM), through to the editor of procedure operations with a possibility of alternative procedures and optimization of the production line.
Printed reports are the output of the system; the most important of them is the production technological procedure for the line’s workers and specification of materials for the warehouse keepers who provide supplies for the lines. 
- Num. of users: 30
- SW technologies and development tools:
- Oracle Database 10g Express Edition
- Sybase PowerBuilder using PFC
- Planning & Logistics | Created in year: 2006
Project: Dimensions Editor
- Customer: Softip Košice
- Purpose: Information system of analytical support for evaluation and administration of data warehouses in the form of the Web portal.
- SW technologies and development tools:
- DB Oracle / MS SQL
- WEB application, MS IIS (Microsoft Internet Information Server)
- .NET
- Dedicated Solutions | Created in year: 2005
Project: System for balancing emissions of CO2 – BCO2
- Customer: Steel company Košice
- Purpose: Information system for balancing emitted CO2.
- Num. of users: 60
- SW technologies and development tools:
- Oracle Database 9i Enterprise Edition
- Oracle Forms 6, PL/SQL
- Oracle Designer, Oracle Developer
- Dedicated Solutions | Created in year: 2005
copyright 2008 - 2010 ESTEN s.r.o.