Bruce Gilham Jr.

All work · Commerce & services

VectorUSA

Field labour capture for a network contractor: technicians, approvals and pay-period rules, replacing the slow Access front end accounting had been living with, and catching the duplicate dates and pay-period errors that were costing money.

Years
2008–2011
Sector
Network and infrastructure contracting
Role
Sole developer
Outcome
Handed over

The problem the business had

Technicians' hours, meals, travel and mileage against job sites were reaching accounting through a slow Access front end, with no approval chain and no way to catch duplicate dates or pay-period errors before they were paid.

What was done

The field capture system with a signature step, then the approval chain above it: project managers approving in batches, a five-day report that mails itself out, pay-period and duplicate-date rules that stop errors at entry, and a browser-based administration application replacing the Access front end.

What it returned

When a middle layer made the program unreliable over the office VPN, I removed it and had the program talk to the database directly rather than leave the field with a flaky tool. Ran in production and was handed over with the source code.

Stack

Silverlight Microsoft Access .NET WPF ASP.NET web services SQL Server ClickOnce Infragistics T-SQL
Does your business run on something like this? What I do about Silverlight · What I do about VB6 & WinForms

Does your business depend on a system like this?

Tell me what it does for the business, what it is written in, and what stops when it goes down. I will say plainly whether I can help.

Tell me what it runs on