Looking for a job

Ivan Aristov

@ivanaristov

System Analyst at First Bit who designed an ERP Project Calculation Engine and built ClickHouse analytics for business decisions.

Georgia

Message

What I'm looking for

I'm open to roles in the US, UK, EU, and EMEA, and to remote B2B or contractor opportunities.

At First Bit, I designed and implemented a custom Project Calculation Engine integrated into the core ERP system. I also developed database models and real-time data synchronization to support engineering and procurement productivity.

I engineered analytical datasets and used ClickHouse and complex SQL to aggregate transactional data, optimize reporting pipelines, and support business decisions. I also authored technical specifications and architectural blueprints for engineering and development teams.

At Groupe Atlantic, I managed an integration project connecting Procurement and Warehouse modules with WMS handheld devices through REST APIs. I built Yandex DataLens dashboards from scratch, including Sales Matrices, Employee Efficiency, and ABC/XYZ analysis for more than five departments.

Earlier, at Corada Consulting, I gathered and formalized business requirements, documented system behavior, and conducted manual system and integration testing. At Rival Group LLC, I supported database infrastructure, including Microsoft SQL Server administration, backups, migrations, and query-based troubleshooting.

Experience

Work history, roles, and key accomplishments

Senior System & Data Analyst

First Bit

May 2025 - Sep 2026 (1 year 4 months)

• Designed and implemented from scratch a custom Project Calculation Engine integrated into the core Enterprise Resource Planning (ERP) system, improving engineering and procurement productivity.
• Developed complex database models featuring highly normalized relational structures, transactional registries, and automated real-time data synchronization.
• Authored over 110 pages of comprehensive Te

System Analyst (ERP & Data Solutions)

Groupe Atlantic

Feb 2024 - Apr 2025 (1 year 2 months)

• Managed the integration project for the Procurement and Warehouse modules, establishing seamless data exchange between the core system and WMS handheld devices via REST API.
• Designed and maintained an OLAP data pipeline utilizing ClickHouse to process large datasets (1M+ rows), writing complex SQL queries (Window functions, CTEs, UNION ALL) to bypass BI limitations.
• Built corporate BI dashbo

Business System Analyst

Corada Consulting

Aug 2023 - Feb 2024 (6 months)

• Gathered and formalized complex business requirements from enterprise clients, identifying operational bottlenecks and system functional gaps (Gap Analysis).
• Authored Functional Requirements Documents (FRD) and designed system behavior models to guide the engineering teams during core feature development.
• Conducted manual system and integration testing (UAT) for newly deployed ERP components

IT Support Engineer / Database Infrastructure Specialist

Rival Group LLC

Jul 2022 - Jul 2023 (1 year)

• Administered core enterprise database environments leveraging Microsoft SQL Server (SSMS), managing backup strategies, database migration, and schema performance optimization.
• Provided Level 2/3 technical and application support for cross-border corporate partners across the US, Europe, and the CIS, resolving complex transactional and access right errors.
• Managed user identities, system acce