professional-work
Rebuilding an everyday work tool
During part-time office work, I replaced an awkward DOS ERP system with a Microsoft Access tool. I investigated the DBF files and reviewed features with users every day over a month. The tool remained in use for five years, until an official replacement arrived.
A problem found through daily work
This began during part-time office work over my graduate-school winter break in 2014. Both existing staff and new team members complained about the DOS system.
My background in quantitative social-science and urban-planning research had given me a basic understanding of relational databases. I investigated the DBF data structure and found that Access could support real-time sharing through files. I proposed taking on the conversion and started after receiving approval.
Starting with the work people actually did
I listed the existing functionality and asked users what should be added or removed. While teaching myself Access, I built CRUD forms, queries, printing, descriptive statistics, and search.
Sales and statistics menus sat on the left, alongside a single screen containing householder search and details, household members, inflow/outflow records for all products, and notes. Selecting a householder let users view, add, or remove household members. Double-clicking an inflow/outflow record displayed its details in a database table. The screen above is reconstructed from memory.
I worked with the actual users every day, gathering feedback on screens and features. After a month of implementation and data migration, the new tool went into use.
An experience that still explains how I work
The tool remained in use for five years, until an official system replaced it. There was little conventional coding beyond some SQL, but I went through understanding requirements, investigating data, and refining a tool with user feedback.
This record is adapted from the About text in my V1 portfolio. It contains no original system screens or data.