Ty Lamb

IT Administrator · SQL Developer · Builder of useful internal tools

Dallas–Fort Worth, Texas

I run IT and Accounting for a sheet-metal fabrication shop — SQL Server on the back end, Node and JavaScript on the front. I have built internal apps and external apps. I like small, fast, well-made software.

Experience

IT Administrator / SQL Developer / Supervisor · Team R2 (R2 Fabrication)

2013-Jan-01 – present

Built time collection and production tracking systems for the shop floor, including a custom-built Node.js / Express / PostgreSQL web app that utilizes scanners to scan bar codes on workers and pieces they are working on.
Own IT administration for a manufacturing / shop-floor environment (Microsoft 365, SharePoint, networking).
Design and maintain T-SQL reporting and data exports against the production SQL Server database.
Building a JavaScript production-workflow UI for the shop floor and converting the internal my.TeamR2.com site from IIS to Node.js in a Linux container.
Built a Copilot Studio HR knowledge agent grounded in SharePoint.

IT Administrator / SQL Developer / Supervisor · Trinity Contractors --> Polk Mechanical

1995-Feb-01 – 2012-Dec-31

Exchange Admin, SQL Server Admin, MySQL Admin, HP UX Admin, Oracle Admin, Windows Server Admin, IIS Admin, Networking Admin, and more.
Creation and management of intranet website with IIS, ASP.net, SQL Server, MySQL, and JavaScript.
Design and maintain T-SQL reporting and data exports against the production SQL Server database.
Automated digital time collection.
Converted multiple companies to multiple accounting systems. Penta and Timberline were the accounting systems we used.

Skills

Data & SQL: SQL Server, T-SQL, MySQL, PostgreSQL, Reporting & Exports
Web & Code: Node.js, Express, JavaScript, HTML/CSS, IIS
Automation & Scripting: PowerShell, Excel VBA, GitHub Actions, C#
Platforms: Microsoft 365, SharePoint, Copilot Studio, Windows Server / IIS, Ubuntu Linux, Docker, Hyper-V
Shop-floor systems: Fusion, CAMduct / Autodesk Fabrication, Autodesk, BuildingConnected API, Revit, Autocad
3D Manufacturing: Fusion, Bambu Labs, Creality