I have worked in the Machining industry for over 10 years, interfacing with almost all departments and determining their data needs. A lot of times, these departments have outdated means of recording information, or even doing most things by hand on paper—this is one of the largest inefficiencies that I have observed during my years of development. After learning MS Excel and using that tool to the best of my ability, I needed something more powerful and effective when it came to automation. I have been working with Microsoft’s Access software for over 6 years and have combined this platform with several languages to vastly improve manual data processes. Once an assessment of the existing processes is completed and the need/desired changes for improvement have been discussed, I build a custom Access application solution that can be utilized by a an individual/small team, or something more scalable utilizing a SQL Server as a backend for robust database management and integration with rich business intelligence platforms.

I utilize the VBA language in conjunction with SQL, XML, and API calls to interface with the Windows operating system and other applications that are running on-premise or on the web. The main industry I have served using this type of solution implementation is manufacturing. This includes: Purchasing, Scheduling, Machining, Inspection, Material Handling, & Shipping. I also have lots of experience with the Sage 100 ERP (MAS 90) system and Global Shop Solutions ERP system (including migration from Sage to GSS). I have implemented many solutions that run parallel with Sage/GSS to integrate custom reporting and advanced data collection.