Fichil · Focused data tasks

Make spreadsheet work repeatable.

Excel / CSV cleanup and recurring reports.

Start with a small sample and the output you need. Agree the rules, deliverables and quote before work begins.

Live engineering system

From system signal to exact release

  1. OBSERVEObserveCapture reproducible runtime signals.
  2. ISOLATEIsolateNarrow the real failure boundary.
  3. VERIFYVerifyConfirm the repair with reviewable evidence.
  4. RELEASEReleaseDeliver the exact reviewed commit.

Latest Engineering Notes

Recent field notes from debugging, backend work, DevOps, and AI-assisted development.

Export a Report Through One Cursor

A report could display a filtered page, yet exporting the same selection took much longer. It already used a streaming workbook writer, making batch …

javamybatisxlsx
Add Event Detail Without Inventing History

A daily counter can answer how many requests occurred. It cannot identify every request, recover its exact time, or explain which read path it used. …

data-integrityevent-logtransactions

An Open, Reviewable Way of Working

I use this site as both an engineering notebook and a public record of how I work. Each useful case starts from observed behavior, follows the real data and runtime path, limits the change surface, and ends with verification.

  • Evidence before edits: logs, process arguments, database state, network paths, and reproducible failures.
  • Small, reversible changes: preserve existing contracts and parallel business flows unless the requirement explicitly changes them.
  • Verification at the real boundary: reconcile data, test retries and failures, build release artifacts, and confirm the deployed version.
  • AI-assisted, policy-gated: people define the delivery policy and remain accountable; narrowly scoped bilingual blog PRs may auto-merge only after protected checks, while other changes remain human-reviewed.
Core Stack
  • Java / Spring / REST APIs
  • MySQL / SQL troubleshooting
  • Linux / Runtime / Networking
  • Docker / GitHub Actions
  • WMS / TMS / YMS / SAP integration
  • Codex / AI-assisted engineering

Selected Engineering Cases

Production Reliability & Performance
SQL Performance Production
Production Reliability & Performance
A production dashboard showed zero while business data existed. The request path loaded large detail sets into Java, timed out, and left the UI's default value visible as if it were real data.
AI-Assisted fichil.com
Open Source AI-Assisted Sites
AI-Assisted fichil.com
This site is an open-source delivery system: Hugo Markdown remains the content source, vinext renders the Sites application, and validated changes move through CI, exact-SHA release evidence, and version-based rollback.
Enterprise Logistics Integration
WMS/TMS/YMS SAP/ERP Reconciliation
Enterprise Logistics Integration
Integration work across WMS, TMS, YMS, SAP/ERP, carriers, billing, proof of delivery, and OpenAPI requires more than connecting endpoints: identity, ownership, state, retry, and reconciliation rules must agree.

What do you want your files to produce?

Describe the manual step, the files you start with and the output you want. A short description is enough for the first email; samples and scope can be agreed afterwards.