SQL & reporting
A faster operational report
A report took about 35 seconds to run. After some SQL and backend changes, it was down to roughly 2.
Jonathan Leigh.
Senior Software Engineer · Orange County, California
I work on web apps, databases, and internal tools at Design West Technologies. A lot of that means getting newer software to work with the manufacturing systems already in place.
Here’s a bit about my experience and some of the things I’ve worked on.
Some of my work
All projectsInternal applications
A platform for internal web apps
My work on the applications, deployment setup, and monitoring behind internal web tools.
Workflow tools
Making a compliance workflow easier to follow
Internal tools helped move a compliance metric from roughly 60–70% to over 90%.
ERP integration
Working with manufacturing systems
Integrations around ERP data, inventory, purchasing, production, and quality workflows.
These are brief write-ups. I’ve left out internal details that aren’t mine to share.
Senior Software Engineer
CurrentDesign West Technologies Orange County, CA
I build internal web apps and connect them to ERP and manufacturing systems. I also work on backend APIs, database performance, deployments, and automation.
Software Engineer
Strategy Companion
I worked on business software using C#, databases, and data visualization.
Things I work with
Languages
- TypeScript · JavaScript
- C# · Python · PHP
- SQL
Web
- React · Next.js · Node.js
- ASP.NET Core · REST APIs
- WebSockets
Data
- MSSQL · MySQL
- ERP integrations
- Data pipelines
Infrastructure
- Linux · Docker · Kubernetes
- CI/CD · IIS
- Application monitoring
I like figuring out why something is slow, awkward to use, or hard to maintain. I’m especially interested in backend engineering, distributed systems, infrastructure, and developer tools.
Education
B.S. Computer ScienceUniversity of California San Diego