matt-taylor.tech
← Back to projects

Work · Ross & Witmer

Acowin rollout & field digital transformation

Acowin Visual FoxPro / DBF iOS field deployment Office 365 integration

Selected and rolled out Acowin, a third-party HVAC service management platform, as the replacement for a legacy Unix-based service management system at Ross & Witmer. Alongside the system swap, took the field operation from paper to iPads.

What I owned

  • Vendor selection and the business case for choosing Acowin.
  • Schema mapping from the Unix predecessor into Acowin's Visual FoxPro DBF datastore.
  • End-user training for dispatchers, technicians, and office staff.
  • Ongoing administration through the remainder of my tenure: user provisioning, schema and code-file maintenance, backup and recovery of the FoxPro DBF data, mobile device provisioning for techs.
  • Integration with Office 365 (calendar and email) and the company's reporting workflows.

The field workflow change

Before the rollout, the field workflow looked like this:

  • Techs wrote paper work orders.
  • Whenever they needed to charge a customer's credit card, they phoned the office.
  • At the end of each week, they returned to the office with a stack of completed paper work orders.
  • Office staff re-keyed every work order into the computer.

After:

  • Techs use iPads in the field with in-field card processing.
  • Work-order data is captured into Acowin in real time.
  • Dispatchers have a live view of field work.
  • The weekly paper-to-database re-entry cycle was eliminated entirely.

Honest framing

Acowin is a third-party COTS product, not something I built. My work was product rollout, schema migration, training, and ongoing administration. There's a separate, recent personal repo where I've experimented with reading Acowin's DBF tables in Python via dbfread, but that's exploratory tooling, not a shipped reporting platform.