
Integration · ERP · data pipeline
Fastbolt, now part of AFC Industries
Fastener distributor and federal contractor · South Hackensack, NJ
An ERP connector that turned a week of reconciliation into a minute of input.
- The problem
- Fastbolt received CSV files that were really several reports stacked in one file, with section boundaries nobody marked and dates in European format in some sections and American in others, depending on which country the section came from. Getting them into their Microsoft ERP took a week of manual work every cycle.
- What I built
- A parser that reads the file line by line, finds the section boundaries, corrects the date format per section, stages the clean data, merges the records and pushes the result into SQL Server for the ERP to consume.
- What it did
- A week of manual work became about a minute of input and ten minutes of waiting. After Fastbolt was acquired, the new owners assumed they would not need the tool. They called me back for a change request because it still outperformed what they had replaced it with.
Microsoft SQL Server · Microsoft ERP · Access · Excel · multi-section CSV













