Selected work · Process Automation

QA Report Splitter

Principle 06Connecting process to platform

Macro that splits batch QA reports from new system into individual language files matching legacy format. Identified company-wide gap after system change caused hours of overhead across all QA teams.

Stack

VBA · Excel

Status

Adopted Company-Wide

Impact

Company-Wide

Scope

Tool Adoption

The problem

What it replaced.

Company changed QA systems after a decade. New file layout confused clients. QAs across entire company spent hours clicking through tabs to create individual reports for 26 languages—previously took 10 minutes.

before · the manual waymanual

›time Hours

›process 26 languages manual

›impact Company-wide pain

The work this took off the team’s plate.

The approach

How it works.

Created macro to run one batch file in new system, then split into individual files matching old format exactly. Adopted by lead developer and absorbed into company QA tools.

What it does

+Batch splitting

+Legacy format matching

+Multi-language support

+Company adoption

How a run flows

Before / after

Time per cycle

Proven, not trusted

Verified before it ships.

The rules that produce these numbers are written as tests and run on every change — and every run, success or failure, writes to the record.

vitest run

✓ output matches the legacy layout exactly

one solution, adopted across every QA team

Built with

The same discipline, this tool’s stack.

VBA · Excel · Data Processing