Jay Lyon

I build systems to help your business succeed.

Custom Software Development

I develop custom software solutions for desktop or web using the Microsoft technology stack, including C#, Windows Presentation Foundation (WPF), Winforms, ASP.NET, ASP.NET Web API, HTML, CSS, and Javascript.

Data Modeling, Database Design, and Data Warehousing

Whether starting from scratch, or emerging from an outdated or outgrown database, I will analyze and model your data and build you a performant, scalable, and maintainable database using Microsoft SQL Server either on-premises or in the cloud.

I can also help you gain a unified view of the data in your existing systems by constructing a central store and loading data from your transactional systems for online analytical processing (OLAP), and creating dashboards to analyze and visualize these data.

Legacy Systems Upscaling

It's surprisingly common for stopgap solutions to become mission-critical systems used at the enterprise scale. I can help you migrate existing Microsoft Access, Excel, or other desktop systems to professional solutions that can scale with your business and integrate with other software systems.

Engineering & Business Software Development

Much of my experience has been within the Mechanical Engineering and Manufacturing domains. I've developed software to automate and optimize mechanical design including thermal and elastic deformation calculations, and integration with analysis software like Autodesk Moldflow.

I've also developed solutions for engineering change management, including web-based Engineering Change Notice (ECN) systems, Configuration Change Notice (CCN) systems, and resource scheduling and capacity planning systems.

Contact Me

Master of Business Administration
B.S. Mechanical Engineering