Designed and implemented automation solutions for varied city infrastructure; Implemented and maintained systems and procedures to ensure that the City of Wooster stays compliant with Ohio State mandates & policies
Project: Automation for Bulk Water Filling Station
Environment/ Technologies: C, MySQL on Linux, and C# on Windows
I designed and ployed a cost-effective (<$15K) automation solution for the bulk water filling station after the city had spent over $150K unsuccessfully attempting to automate the control systems
Prototyped and implemented a pump controller running Linux on a custom PCB to convert 4-20V to RS232C; wrote C code to communicate with, and control the pump
Implemented smart-card based authentication mechanism to provide authorization for customers & integration with billing - delighting customers since this eliminated manual authorization by city employees
Implemented C# based front-end UI invoicing systems using a MySQL connector to cut down billing process from 1 week to 15 minutes
Project: Mandatory Compliance (various)
Environment & Technologies: Linux, PHP MySQL, Windows, MS SQL Server
Implemented multiple systems & software solutions to ensure that the city complied with Ohio State mandatory policies
Interviewed stakeholders, gathered requirements and implemented LAMP-based web applications that used Microsoft Active Directory for authentication and authorization
Ported / migrated legacy applications to Windows / MS SQL server
Resulted in the city saving several million dollars in regulatory fees