Ivacon
Building IT infrastructure and a production accounting system
A metalworking and polymer coating enterprise producing doors, metal structures, shelving and pavilions. I built its IT infrastructure and personally developed most of the system for warehouse and job-order accounting, production cost calculation and management reporting. By the end of my time there, the system covered the entire enterprise: three geographically separate branches and, by my estimate, more than 50 workstations.
- Participation started
- 1997
- Company
- Ivacon CJSC
- Positions in the project
- Head of the Computing Department
Roles and achievements
| Responsibilities | My contribution | Results and metrics |
|---|---|---|
Business Analyst
|
I personally investigated processes from raw-material purchasing to finished-product sales. With production, procurement, warehouse, accounting and quality-control teams, I defined system requirements, data structures and calculation rules. |
Electronic exchange replaced courier delivery of accounting documents between departments. Daily data transfers between branches and headquarters replaced document transport for operational reporting. Calculating metal consumption and waste from material parameters and production output replaced manual weighing, reducing labour and costs. |
Project Manager
|
Led a three-person team. Built the local network and Microsoft server infrastructure and arranged daily data exchange with remote branches over dial-up. Presented solutions for management approval; together with the team, trained employees and rolled out the system with user participation. |
The shared infrastructure covered the entire enterprise: three geographically separate branches, three production workshops, three warehouses and administrative departments. I estimate that it included more than 50 workstations. |
Systems Analyst
|
Personally developed most of the software in VBA using Microsoft Access, with data storage and SQL queries in Microsoft SQL Server; used ODBC to connect Access to the server database. Implemented warehouse accounting, material movements, order and cost accounting, exports to BEST and imports of calculation data from CAD software. Developed material consumption and waste formulas with production technologists and built daily, ten-day, monthly and quarterly reports. |
Employees entered source data at their workstations for shared accounting. Direct costs, overheads and selling expenses were collected by order, and data was exported to the BEST accounting software. The economic planning department, accounting department and management received reports and analysis from a shared database. Local data was updated as it was entered, while branch data arrived daily, giving management the previous day’s results. |