Igor Ignatenko
Private message 
Ukraine
9 years back
available for hire
10 years back
1 client
on the service 12 years
Rating
Successful projects
Average rating
Skills and abilities
Programming
Administration
Portfolio
-
System of Management Accounting
Desktop Apps
system of management accounting. Elements: objects of analytical accounting with variable sets of properties and history; a set of indicators with the necessary analysis; documents of the adjusted resume composition; the mechanism of operations linking the resumes of documents with "guides" by indicators; the movement by indicators is stored for the arbitrary period (years) in established cuts; reports of several types, data on the movement and state of indicators; several currencies; the wooden structure of the reporting units.
The user interface is Delphi (EhLib, FastReport, VirtualTree, SDAC). The database is MS SQL Server. The development is completely own.
-
The FB2 Reader
Desktop Apps
Console book readers in fb2 format.
Sign tags, transition to links, display tables. Images are opened in the associated file type program.
The font and its size are selected in the properties of the console.
Programming Language - D
-
Sea container transportation
Desktop Apps
Information security of container transportation.
Acceptance of applications, tracking of shipments, passing ships.
Main information objects: delivery, flight (shipment), container and document.
The task is convenient navigation between these objects, quick obtaining full information on its fragment.
… Introduction, storage of documents related to transport, discharge, discharge, payment, delivery of the container to the recipient and return it to the port (HBL, MBL, Liner work sheet, POA (Power of Attorney), Agent delivery order, Invoice, CMR, Forwarder work sheet, etc.)
When signing, the documents are automatically "printed" into the report and are stored in the base as a copy for this time.
Creation of new types of documents.
Import data from the Excel tables.
About 40 reports.
MS SQL Server and Delphi.
WEB interface for cargo contractors. Acceptance of applications, monitoring of the passing of containers.
Implementation - ASP
its development.
-
Automation of preparation, planning and production accounting
Desktop Apps
Programme for automation of preparation, planning and operational accounting of production and accounts with customers.
The product as a structure.
The nodes and materials are resources, determined by assets of attributes.
… standards of expenditure. Operations of assembly, time standards.
Calculations and resource lists.
Calculation of the movement of resources. Closed cardboard, onboarded. and inventory.
Supply contract and specifications. The Calculation. Opening of orders.
Automatic drawing out of work.
Planning of production.
Calculate the delivery schedule taking into account contracts, residues and the production plan.
Distribution of works. Verification of the safety of the resources.
The production.
After the signature of the package, automatically, two of the listed to it are carried out: for the resource list and the arrival of the semi-fabricate or the delivery of the product.
The documents are always unfinished. The deviations. The actual calculation.
Conditions of accounts with customers.
Injected in a washing factory. The development is completely configured.
-
Automation of operational accounting on the oil base
Desktop Apps
Automation of operational accounting on the oil base
The tasks:
- collection and storage of data of sensors on tanks and engines
Description of the infrastructure: tanks, tubes, engines, dishes. Presentation in graphic form
… Planning of reception, shipping, shipping and so on. Automatic selection of tanks and marshruts taking into account the number and type of GSM, the filling of pipelines, the minimization of the filling of pipelines and the activity of pumps. Manual route on the scheme
Fixing the course of operation, opening and closing of engines
- generating reports of events - fuel leak, unplanned shipping, etc.
Automatic drawing of documents based on the operations carried out
Introduction of data documents (quality passports, etc.)
- Inventory
Reports of residues, movements, operations schemes
Their work:
SQL Server Database and Business Logic
TCP server to receive data from the SCADA system
User Interface – Delphi
The reports
-
The database administrator tool
Databases & SQL
The database administrator tool. The designation:
Study the structure of the database, viewing objects.
- Loading - loading data from the tables taking into account the connections between them
- cleaning the database tables taking into account the connections between them
… - Editing stored procedures, views and triggers
Implementation of SQL requests
- for MS SQLServer 2005 and above - Command Tracking (Profile)
Access to the databases is made through the ADO interface.
Set up to a specific SUBD (SQL Server, Informix, Sybase Anywhere, MS Access).
Made in Delphi. I use this task to verify the possibilities of the programming tool.
Therefore there are analogues for D2 (juno, DFL), Windows Mobile (C#), Oberon (XDS, ODBC, WinAPI), Modula 3 (CM3, ODBC, WinAPI), Lua (luacom, IUP) and HTML (MSIE).
-
The web server
Web ProgrammingMulti-linked web server for a small site. It accepts HTTP requests, supports sessions, works with databases through ADO, generates HTML pages and images. You can use templates. Implemented on D2 as a Windows service. It makes sense to use on the server not scripts, but a complete compiler.
Reviews and compliments on completed projects 1
24 June 2015
Resource management system of the enterprise
Quality
Professionalism
Cost
Contactability
Deadlines
A good professional!The !
