Business systems for real operations

Business Intelligence & Business Automation Engineer

I turn fragmented Excel files, ERP exports, inventory reports and financial workflows into practical internal systems using business-first thinking and AI-assisted development.

13operational modules
25Power BI-ready tables
5monthly snapshots
1production deployment
Business-firstRequirements begin with operating decisions, not frameworks.
AI-assistedAI accelerates implementation; business ownership stays human.
End-to-endRaw files, ETL, APIs, dashboards, deployment and BI exports.
OperationalBuilt from daily sales, finance, inventory and ERP workflows.

Messy workflows, made operational

The interesting part is rarely the dashboard. It is understanding why five sources disagree, which business rule is authoritative, and what action the user needs next.

01

ERP reporting automation

Connect supplier DMS data, accounting exports and customer mappings into repeatable reporting flows.

02

Financial visibility

Bring receivables, cash balances, expenses, inventory and profit logic into one decision surface.

03

Data reconciliation

Find mismatches between operational systems before they become accounting or collection problems.

04

Inventory intelligence

Normalize product codes, units and pricing rules to explain stock movements and valuation.

05

Internal tools

Design focused interfaces for repeated work: upload, validate, review exceptions and export actions.

06

BI-ready data models

Turn application logic into clean fact and dimension tables ready for Power BI analysis.

Many people believe building dashboards is difficult. I believe the difficult part is understanding business logic.

Technology changes. Business workflows remain. I begin by understanding how a business makes decisions, where its data disagrees and what must be trusted before choosing an implementation.

Sanitized SalesFlow BI Platform dashboard preview

SalesFlow BI Platform

A production internal platform for a distribution business, bringing sales, receivables, inventory, supplier settlement, cashflow and ERP reconciliation into one workflow.

Python ETLREST APIsOpenPyXLGoogle SheetsPower BIHawkhost

Every reporting cycle began with multiple files that had to be reconciled manually before the business could trust the numbers.

From source files to decisions

Architecture details
01Operational sourcesDMS, MISA, bank, inventory
02Python ETLParse, clean, normalize
03Business rulesChannels, fees, debt, stock
04Snapshots & cacheFast, repeatable reporting
05Web APIsOperational dashboard
06BI modelFacts, dimensions, Power BI

AI is the accelerator. Business ownership stays human.

The work moves quickly because responsibilities are explicit, not because judgment is outsourced.

Human01Business problem

Identify the operating pain and decision that needs support.

Human02Workflow design

Map actors, timing, sources, exceptions and desired actions.

Human03Business rules

Define identifiers, authority, ownership and calculation meaning.

Human × AI04Architecture

Shape a practical system around real constraints and future options.

Codex-assisted05Implementation

Generate, refactor and document the application under direction.

Human06Operational testing

Validate with real files and investigate every material mismatch.

Human × AI07Iteration

Turn usage feedback into safer rules, faster flows and clearer UI.

Human-owned08Production

Deploy, operate and remain accountable for the system outcome.

A portfolio that keeps learning

Short, honest notes from building systems around imperfect operational data.

Read all notes

Building a BI platform when the business starts in Excel

Why the first job was not choosing a framework, but identifying which spreadsheet represented each business truth.

Read note →

The total row that became a customer debt

A single ERP summary row produced a multi-billion receivable and taught a durable lesson about validation.

Read note →

Why business logic matters more than the chart

Monthly debt, delivery-only customers and unit conversion made the visual layer the easy part.

Read note →

Have an operational workflow that still lives across five spreadsheets?

Start a conversation →