Phantasma · Tangible solutions for abstract problems.

We turn manual operations into measured systems.

We are consultancy, technology enablers for mid-market teams that have outgrown spreadsheets. We untangle heavy operations and help companies scale up by leveraging their existing data and infrastructure to build robust, Cloud native data pipelines, intelligence, CRM, and IoT systems. Quietly. With numbers behind every claim.

Different engagements, multiple industries.

We are not a dev shop. We diagnose, document, and solve. The common thread across every engagement is not the technology — it is the problem.

What we do

  1. Operations & Data

    Manual processes and data silos — structured into reliable, connected pipelines that run without extra headcount.

    ETL/ELT · API integration · financial automation · operations pipelines · ClickUp · n8n · Google Workspace

  2. Intelligence & Infrastructure

    Forecasting models, IoT networks, and cloud systems that turn raw data into autonomous, measurable decisions.

    Azure · ML · IoT · Power BI · SQL/NoSQL · DevOps · Shopify · Amazon SP-API

  3. Advisory & Scale-Up

    Short-term delivery or long-term partnership — expertise brought in without the cost of a full-time hire.

    Project delivery · embedded consulting · product management · documentation

How we do it

  1. Business Problem Solving

    We audit operations, map where data is lost or misread, and document the actual problem before any code is written. Then we implement — or hand you the document so your team can.

    Operations audit · process mapping · problem documentation · solution design · implementation

  2. Technical Execution

    Data warehouses, ML forecasting, IoT networks, API integrations, AI tools for non-technical users, BI dashboards, DevOps pipelines, e-commerce and billing automation.

    Azure · ML · IoT · AI · SQL/NoSQL · DevOps · Power BI · n8n · API integration · e-commerce

  3. Engagement Models

    Fixed-scope project with full handoff, or long-term: embedded consulting, stakeholder advisory, product management while the company scales.

    Project delivery · embedded consulting · product management · handoff documentation

Why we do it

  1. Operations that won't scale

    Revenue grows but so does manual work — more orders, more spreadsheets, more staff doing the same tasks. We find the bottleneck, quantify it, and replace it with a system.

    Operations automation · throughput · manual elimination · e-commerce · logistics · finance

  2. Data that doesn't help you decide

    The data exists — in the ERP, CRM, IoT sensors, accounting system. But it lives in silos or no one can read it. We unify, clean, and surface the decisions it supports.

    Data warehousing · ML forecasting · BI analytics · IoT · SQL/NoSQL · API integration

  3. Expertise you need — not full-time

    You need a data architect, ML engineer, or e-commerce specialist for a defined project. We step in, implement, document, and leave you with something you own.

    Embedded consulting · AI tools · product management · stakeholder advisory · knowledge transfer

How we work

Approach

  1. 01

    Discover

    Audit operations and model the ROI of automation.

  2. 02

    Architect

    Pipelines, data contracts, governance, and stack choices.

  3. 03

    Build

    Pipelines shipped, validated, and tested against your history.

  4. 04

    Hand-off

    Documentation, training, runbooks. Your team owns it.

  5. 05

    Operate

    Optional retainer for evolution, monitoring, scaling.

Aggregate impact

What it adds up to.

75 hrs

reclaimed per cycle

E-commerce engagement

€15K

total cost over 2 years

Mining transformation

12 ha

autonomous, weather-aware irrigation

Precision viticulture

6 stores · 20 yrs

of data unified, GDP-compliant

Pharmacy chain

About Phantasma

Small team. Embedded with your operations.

Phantasma is a boutique technology enabler and process transformation consultancy. We work with mid-market teams — typically post-acquisition or post-spreadsheet — who need an architecture that scales without adding headcount and process nodes. We embed with your ops, build the system end-to-end, hand it back with documentation, and then leave.

We choose engagements where we can put a number against the outcome. If we cannot tell you what manual hours you will reclaim, what a cycle will cost to run, or what accuracy your forecasts will reach — we are not the right team for that project.

Tell us what's manual.
We'll tell you what's possible.

30 minutes. We listen, you describe what's manual or operationally inefficient. You leave with a one-page outline of what an automation could look like, what tech brings to the process, what it would cost to run, and roughly what it would reclaim.

Or just email us: consult@solvephantasma.com

Calendly

Open booking calendar

Loads on demand. No third-party request before you ask for it.

E-Commerce Cost Engine & Financial Reporting Pipeline

Executive Summary

Developed an end-to-end data automation ecosystem for a multi-channel e-commerce firm managing 8,000+ SKUs and 20+ manufacturers. Transformed a manual accounting process into a scalable $60/month cloud-native solution.

The Challenge

Variable pricing across 20 manufacturers, multi-channel marketplace commission complexity, logistical fragmentation, and a resource drain of 80 man-hours per cycle across 3 senior staff over 5 days.

Technical Solution

Azure ETL/ELT pipeline with custom API retrieval platform, multi-format Data Lake handling JSON, CSV, and Parquet, star schema SQL Data Warehouse, Power App for logistics rate updates, Google Sheets-to-Azure pipeline for business users, and automated Paginated Reports generating client-ready invoices.

Business Impact

93.7% labor reduction. Turnaround time cut from 5 days to 2 days. Operational cost from 3 senior FTEs to $60/month. 75 hours of high-level employee time reclaimed per cycle.

Technology Stack

Azure Data Factory, ADLS Gen2, MSSQL, Power BI, Power Apps, Amazon SP-API, Shopify API.

Industrial Scale-Up & Operational Intelligence — Mining Operations

Executive Summary

Integrated data ecosystem for a rapidly expanding mining and raw materials producer following a series of acquisitions. Automated document processing, unified task management with financial flows, and provided C-level executives with real-time decision-making snapshots.

The Challenge

Non-standardized processes across mining sites, data trapped in local computers and manual invoices, and massive human effort required to map cash flows to mining tasks.

Technical Solution

Azure Data Factory and Databricks for ETL/ELT. Azure Machine Learning OCR to digitize manual invoices and map them to project tasks. ClickUp API integration linking every task to its financial cash flow. Power Apps for structured data entry. SharePoint as a governed document library. Row-Level Security and Active Directory integration.

Business Impact

700% increase in monthly task capacity. 314% increase in raw material processing. 40% reduction in labor inefficiency. Data accessibility from under 10% to 80% organization-wide. Total cost of ownership €15,000 over two years.

Technology Stack

Azure Databricks, Azure Data Factory, Azure Machine Learning, Power BI, Power Apps, SharePoint, ClickUp API.

Strategic Architectural Overhaul & Data Integration — E-Commerce Platform Recovery

Executive Summary

Forensic audit and complete architectural overhaul of a failing e-commerce PHP monolith operating across Amazon and Shopify. Replaced with a modern decoupled microservices cloud architecture.

The Challenge

Single massive codebase caused regressions across modules. Only the original author could navigate the system. Reports hard-coded in Python. Single-threaded ETL lagged as sales volume grew.

Technical Solution

Azure Data Factory for orchestration and ETL. Azure Databricks for Spark compute. Azure SQL as Single Source of Truth. Power BI for self-service BI. Azure DevOps CI/CD separating Dev, Staging, and Production. ADLS Gen2 Bronze layer for raw JSON. Terraform and Bicep Infrastructure as Code. Azure AD RBAC for department-level access control.

Technology Stack

Azure Data Factory, Azure Databricks, Azure SQL, ADLS Gen2, Power BI, Azure DevOps, Terraform, Bicep, Azure Active Directory, ClickUp, Amazon SP-API, Shopify API.

Precision Viticulture: End-to-End IoT & Irrigation Ecosystem

Executive Summary

Complete precision agriculture system for a 12-hectare vineyard combining IoT sensor infrastructure, edge computing, cloud data pipelines, and predictive automation for fully autonomous weather-aware irrigation.

Technical Solution

IoT devices monitoring soil NPK, moisture, and temperature in real-time. Low-power always-on on-premise server as data retrieval center. Azure and Databricks pipelines syncing sensor data with Weather Forecast APIs. Machine learning model forecasting water needs based on evapotranspiration versus predicted rainfall. Automated pump control maintaining optimal moisture while minimizing energy.

Technology Stack

IoT soil sensors, on-premise edge computing server, Azure cloud pipelines, Azure Databricks, Weather Forecast API, automated pump control systems.

Pharmacy Chain Digital Transformation & Regulatory Compliance

Executive Summary

End-to-end modernization of a 6-store pharmacy chain to align with Georgian healthcare regulations. Complex migration of 20 years of legacy data, AI-driven product mapping, and centralized IoT monitoring for GDP compliance.

Technical Solution

Central Product Library integrating Ministry of Healthcare, Revenue Service, logistical databases, and historical invoices with AI-powered medicinal name matching. Custom Data Warehouse with automated procurement generating purchase orders per branch. Centralized IoT network monitoring temperature and humidity across 6 locations. Automated Ministry of Healthcare reporting workflows.

Technology Stack

Custom Data Warehouse, IoT sensors, AI product mapping, ERP integration, Google Workspace, HubSpot.

Automated Demand Forecasting & Inventory Optimization Engine

Executive Summary

End-to-end data pipeline and machine learning solution for a large-scale e-commerce distributor managing 12,000 SKUs across 200 brands. Achieved 98% forecasting accuracy, outperforming human procurement specialists at 81%.

Technical Solution

Azure Data Factory and Databricks ETL/ELT pipelines. MSSQL Data Warehouse with Golden Record table unifying all sales channels. Feature engineering with rolling 7/30/90-day windows and YoY comparisons. Azure Machine Learning model generating automated replenishment suggestions. Rigorous backtesting against 4 years of historical data.

Technology Stack

Azure Data Factory, Azure Databricks, MSSQL, Azure Machine Learning, Python, Shopify API, Amazon SP-API.

Predictive Infrastructure & Operational Optimization for Urban Water Utility

Executive Summary

Turned a reactive century-old water utility serving 3M+ residents into a predictive data-driven operation. Daily incident throughput doubled, average fix time dropped 33%, high-severity pipe bursts fell 12% year-over-year.

Technical Solution

PostgreSQL data warehouse consolidating SAP incident records, IoT telemetry from pressure gauges and reservoir levels, asset inventory, and billing consumption map. Machine learning forecasting achieving 80% daily, 90% weekly, and 93% monthly confidence. KPI and alert management layer connected back into SAP via custom REST API generating work orders. Power BI dashboards for incident volume, fix-time distribution, team utilization, and warehouse readiness.

Technology Stack

SAP ERP, PostgreSQL, Python ML, Power BI, IoT telemetry, custom REST APIs, Azure infrastructure.