Alex Demidov

Hacking videos

◦ Learning Management System: Learning Management System: a system for provisioning training services for clients. Developed critical components, including user management, course player engine, progress tracking, scoring, message board, and certificate issuance. Built using Java, MongoDB, and AWS. ◦ Trajectories: Designed and implemented a new version of risk modeling software. Built using JavaFX. Available on Windows and macOS.

◦ ETL: Developed many parts of ETL system: Python library for aggregating data, Google Apps Script modules (Javascript) for importing data from Google Docs, Google Cloud Functions for requesting data from external services, Zapier jobs, and other services. ◦ Data Warehouse: Led a team of 3 engineers to migrate a data warehouse from MS SQL Server databases to Google BigQuery, reducing reporting latency by five times (8 hours to 90 minutes). For reporting service was chosen Google Data Studio. ◦ Database migration: Migrated the enterprise resource planning system data from MS SQL Server to PostgreSQL, reducing rental and subscription costs by 10x. ◦ Integration service: Led a team of 2 engineers to create a REST service for the integration of various systems used in the company: GSuite, ERP, BPM. ◦ Interviewing: Conducted 50+ onsite interviews for roles in the IT and Analytics department.

◦ Android app: Designed and implemented a sales agent Android application and a RESTful webservice used to create sale orders, currently used by over 200 users in the company. ◦ Integration service: Developed and maintained a REST service for connecting various systems: ERP, online store, warehouse system. This service reduced latency and had an impact on the business: the website began to display current inventory, and sellers could also see the movement of goods in warehouses online. ◦ Analytics system: Designed and implemented various analytics reports. Optimized indexing, rewrote queries, and restructured table schema to decrease some reports latency by 300%.

◦ Notification service: Designed and implemented internal notification service (SMS, email, phone). ◦ Payroll System: Developed a payroll service for employees.

◦ Replication service: Service for sharing updates between ERP nodes written on C# (ASP.NET). ◦ Geo-tracking service: REST service for geo-tracking of company trucks. As trackers, we used Android phones with an app that sends GPS coordinates every 5 minutes.

◦ App developing: Various small projects for clients of the company, mainly in C#, like plugins for cash register software.