Ivan Andrievich

Development on PL/pqSQL, python. Participation in the development of a BigData product as an analyst: interaction with architects and developers; Analysis of business requirements in terms of assessing the capabilities of their implementation; Search and analysis of data sources, participation in integration tasks; Formation of datasets; Writing and support of project documentation.

Key Achievements - Developed a POSM business process solution in Dynamics365 (Javascript + MSSQL) - Reworked the integration code (T-SQL) Dynamics365 -> Inspector cloud to eliminate errors at the stage of generating master data and speed up data transfer. - Developed an alert system for data discrepancies between administratively dependent but technically independent systems affecting sales and sales team KPIs (T-SQL).

Developed: - procedures for automated uploading and delivery of reports - API for automated reconciliation of corporate system data - systems for automated notification about servers problems - automated import system for billing various operators - unified procedure to access accounting systems. Reduced time for creating accounts from ~40 min. to 40 sec. Wrote ~45000 lines of stored procedures, functions and integrations that are used in the company daily (MS SQL, MS Dynamics 365, Javascript, PostgreSQL)

Completely reconstructed IT infrastructure of the enterprise: implemented virtualization, IP telephony, call center, emergency alert system throughout the entire territory of the enterprise. Reconstructed company's video surveillance system. Developed internal website. Reduced costs of the enterprise: - for intra-zone and national long-distance calls by 50%, - for maintenance and repair of copying-and-duplicating equipment by 55%, - for service of video surveillance system by 10 times,

- Maintenance and repair of computer and copying-and-duplicating machinery park of the enterprise. - Technical support of corporate employees. - Installation and maintenance of networks and communications (telephony, Internet, video surveillance) at the facilities of the enterprise production facilities, construction sites, storage facilities, etc.). - Minor repairs of various equipment (telephone sets, computers, printers, etc.) - Work with contractors on purchase of expendables, etc.

Responsibilities: Setup, maintenance and repair of servers based on FreeBSD OS, RedHat, Windows Server. Maintenance and repair of computer and copying-and-duplicating machinery. Programming and maintenance of the library automation system ‘IRBIS’ in the language of ISIS. Achievements: Developed the automated system for scanning and archiving books in the library with automatic undercutting and color and brightness correction. Developed the RFID tag reader to control students' access to library computers.

Responsibilities: Repair and maintenance of computers and copying-and-duplicating machinery. Technical support of teachers and students during study sessions. Achievements: Mathematical modeling of holding frames for production of YAK-130 combat-capable trainer aircraft for the Irkutsk Aviation Plant in the engineering analysis environment MSC Nastran. Developed the industrial equipment drawings (crushing equipment, industrial sieves, vibration machines etc.) for the Irkutsk Plant of Nonmetallic Materials.

Specialist of Transport systems, Technical maintenance of air vehicles and engines