Jacob Silverman

Verify My Order — medical device prescription verification for a US retailer, built end-to-end as sole engineer. A companion Shopify app: orders don’t ship until a prescription is verified — a state machine that negotiates between doctors, patients and the retailer over multi-channel communications. Regulated-sector approval engine with legally binding response deadlines, scoped directly with the non-engineers who own the process. ~50 orders/day in production. https://verifymyorder.com · https://dimplecolor.com

Private REIT — three-statement financial model built end-to-end as sole engineer from general-ledger and budget data. Inherited a complex VLOOKUP-reliant Excel workbook; iterated across 4+ tech stacks to find the right fit: (1) Python + xlwings, (2) Google Apps Script, (3) MS Access + SQL Server, (4) MS Excel with Power Tools. The MS stack landed as the answer. The technology was the easy part; the hard part was change management — getting finance users comfortable with dates as a time-series column rather than a crosstab, the shape that enables slicers and that the Power Pivot columnar engine needs. Power Query replaced the VLOOKUP chain, feeding a star-schema data model; DAX composed the three statements; CUBE functions pivoted them back into the P&L and balance-sheet layouts users expected; Power BI on top.

Xero/MYOB sync utility (same client) — custom OAuth2 app and Basiq (AU bank-feed API) integrations on Terraform-managed AWS infrastructure (ECR, Lambda, S3, Secrets Manager, CloudWatch, Route53), with D3.js across the reporting surface for interactive visualisations over financial and operational data. Supplied the general-ledger and bank feed data that fed the REIT model.

Sales engineering at a US software-development agency (New York) — scoping custom software builds and translating client requirements into project specs.

Software engineering internship in the Jira/Confluence ecosystem, during my UNSW engineering degree.