Selected systems

Projects begin with an operating problem, not a technology.

One flagship platform, several proven capability modules, and a growing body of work around ERP reporting, finance, inventory and data quality.

Flagship · Production

SalesFlow BI Platform

Sales, receivables, inventory, cashflow, supplier settlement, reconciliation and Power BI datasets for a real distribution workflow.

ProblemWorkflowArchitectureResultLessons
Full case study →
Capability · Live

ERP Reconciliation Engine

Compares supplier DMS transactions with MISA accounting exports by month, channel, value and document count to surface exceptions.

Inside SalesFlow →
Capability · Live

Supplier Settlement Analytics

Rebuilds price variance, delivery service fees, samples and purchase discounts from raw DMS and sell-in records.

See business logic →
Capability · Live

Inventory Normalization

Maps product codes and pack units across sell-in, DMS and MISA sources to support stock movement and valuation analysis.

See data flow →
Capability · Export

Power BI Dataset Generator

Exports 25 clean fact and dimension tables from the same business logic used by the operational web application.

View semantic layer →
Historical analysis

2025 Profitability Reconstruction

Reconstructs monthly profit, supplier fees, samples and operating expenses from archived files without changing source records.

Read the lessons →

What these projects demonstrate

BI

Decision modeling

Translate operational questions into metrics, exceptions and drill-down paths.

ETL

Data pipelines

Normalize inconsistent Excel sources into stable monthly reporting datasets.

ERP

System reconciliation

Compare what systems say, identify authority and explain the difference.

FIN

Financial operations

Receivables, cash balances, operating expenses, inventory and profit estimation.

OPS

Internal tools

Interfaces shaped around the repeated actions of a real operating team.

AI

AI-assisted delivery

Fast implementation without outsourcing business ownership or validation.

The next project starts with understanding the workflow.

Discuss a system →