data and automation for businesses that run on logistics
My name is Brandon Lee Lawrence. I'm a business analyst and back-end developer. My background in mathematics, logistics, and management means I build for the systems and for the people who use them
Open to freelance work and full-time roles. Say hi at info@beeleelaw.com
recent work
Generalist by nature, specialist in warehousing and fulfillment. These are in-house tools I scoped, built, and shipped. They live behind company walls, so here's the rundown
Recently worked with GrowthSpoke (opens in new tab), DGRI (opens in new tab), and Ganzo (opens in new tab)
- Syncs data from the warehouse management system (WMS) to an on-prem database in near real-time
- Keeps data fresh, including catching deleted records
- Two separate refresh algorithms, because reliability comes first
- MSSQL: synced WMS data
- node.js / express: sync server
Tuning queries and indexes so the database stays fast
- One home for printer connections and templates
- Custom UI for filling in warehouse documents
- Print anything to any warehouse printer, even non-network ones, from the UI or straight from the ERP
- Detailed logging
- MSSQL: print jobs and logs
- node.js / express: back-end
- React: front-end
Printers are finicky. Things only run smoothly when IT keeps the machines up to date
- Pulls in invoices from USPS, UPS, FedEx, and DHL
- Flattens them into one standard format
- Checks invoices against business data to generate reconciliation and accrual charges
- MSSQL: database
- node.js: back-end
- React: front-end
Every carrier invoices differently and has its own quirks, so getting them all into one schema is the hard part
projects
Side projects you can try in your browser
bike route safety (opens in new tab)
Pick two places in Grand Rapids and get a safety rating for the bike route between them, based on city infrastructure and traffic collision data. A cause close to my home and my heart
delta flyer (opens in new tab)
A small rogue-like shooter I built in React for fun. I lean more toward building than polishing, but I still love front-end work
contact
Have a project or a role in mind? Say hi
For freelance or hiring inquiries. Resume available on request