Albanero Datamesh
Role
User Experience Designer
Years
2022 – 2024
Domain
Enterprise data / ETL
Outcome
99% data accuracy
An ETL tool built specifically for the Infor M3 product. I designed Datamesh, a large-scale data management and transformation platform with complex, data-heavy workflows for enterprise users — work that contributed to product maturity during the period culminating in the company’s acquisition by Infor.
Problem
Moving a 34,000-row source file into an M3 target means deciding, per column, what it maps to, how it is cleaned, and which reference table resolves it. Doing that across seventeen columns in separate tools loses the thread.
My role
Sole designer on the mapping experience: information architecture, the operation model, interaction patterns and the shipped UI, working directly with engineering.
Outcome
One four-step flow — target mapping, Q&A, data mapping, reference mapping — running at 99% data accuracy, and a product mature enough to carry through the Infor acquisition.
Stage 01 / Problem
Seventeen columns, three tools, and nothing holding the thread
An Infor M3 migration starts with a source file — in one representative project, 34,000 rows across seventeen columns. Every single column needs three separate decisions: what it maps to in the M3 target, how its values are cleaned, and which reference table resolves its codes.
Those three decisions were being made in three different places. By the time an analyst reached reference mapping they had lost sight of what they decided at the schema step, and there was no single view that could answer the only question that mattered: is this column finished and correct?
For the business, mapping accuracy was the product. A mis-mapped column does not fail loudly; it surfaces months later as broken reporting, and every failed migration is consulting time the company absorbs. Datamesh had to make mapping auditable enough to stand against incumbent ETL tooling in enterprise evaluations.
Stage 02 / Research
Watching a migration actually get done
I interviewed the implementation consultants who run migrations for customers and the data analysts and owners who do the column-level work, and sat with them through live mapping sessions. Separately I ran a heuristic audit of the existing tooling and the competitor products customers compared us against, and went through support tickets and product analytics from migrations already in flight.
The tickets were the most useful source. They were not feature requests — they were people asking each other what a column meant. That reframed the brief from “make mapping faster” to “make the unresolved questions visible and answerable inside the tool”.
Stage 03 / Insights
What the research changed
The unit of work is the column, not the file
Everyone described progress column by column, but the interface was organised around files and steps. Making the column the primary object let progress, status and history sit in one row.
Ambiguity is a conversation, not an error state
Analysts routinely stalled waiting for a data owner to confirm what a field meant, and that exchange happened over email. It had to move into the product, attached to the column it was about.
Trust comes from seeing before and after
Nobody trusted a transformation they could not check. Every rule had to show the original value and the resulting value side by side while it was being written, not after the job ran.
Stage 04 / Flow
Four steps, one auditable spine
The mapping experience was restructured into four explicit steps, with a per-column overview acting as the audit layer across all of them. The steps are sequential but not locked — an analyst can jump back to schema without losing transformation work, because the column, not the step, holds the state.
Step 1
Target mapping
Match source columns to the M3 target, with a validity score per column.
Step 2
Q&A
Open a thread on any ambiguous column; data owners resolve it in place.
Step 3
Data mapping
Chain cleaning and transformation operations, with a live old/new preview.
Step 4
Reference mapping
Resolve codes against reference tables using readable conditions.
Stage 05 / Decisions
Three layouts for the same model
The hard question was not what the operations were, but how to show a chain of them for seventeen columns at once. I wireframed three structures and tested each against the same 34,000-row file.
Explorations — the transformation editor
With the row model settled, the remaining work was the editor inside it: how a chain reads, where properties live, and how the preview stays visible while a rule is being written.
Stage 06 / Final UI
The shipped mapping flow
Stage 07 / Validation
Tested on real migration files
We ran moderated usability sessions with data analysts and implementation consultants, using their own migration files rather than sample data. Tasks were the real ones: finish mapping a column end to end, find out why a value came out wrong, and hand an unresolved column to someone else.
The sessions were where the row model earned its place — and where three things broke.
Rows now collapse by default
Participants opened every column out of caution and immediately lost the overview. Collapsed became the default state, with status readable without expanding.
The validity score was made explicit
People could not tell a confident auto-match from a guess. Surfacing the score per column at the target-mapping step turned it into a triage tool.
Empty states say what is missing
“No rules” was read as an error. Reference mapping now states plainly that no rule is applied yet, which is a valid state for many columns.
Stage 08 / Reflection
What I would do differently
Bulk operations came late. Analysts frequently apply the same cleaning rule to several columns at once, and the column-as-row model makes that natural — we should have designed the multi-select case alongside the single case rather than after it.
Reference mapping still assumes you know your reference tables. It reads well if you do, and is opaque if you do not, which is a research gap: I spoke mostly to experienced analysts and under-sampled the consultants picking up an unfamiliar customer domain.






















