OPEN TO SOFTWARE & MIS ROLES
Software · Information Systems · Data
I'm David Xu. I use SQL, Python, web, and desktop technologies to turn fragmented data and manual steps into usable, testable, maintainable tools.
SELECTED WORK / START HERE
RepairFlow demonstrates workflow and backend integration. Inventory Insight demonstrates SQL, reconciliation, and decision output. Both are available as public demos.
Cloudflare Workers · Hono · D1 · Documents
One workflow connects repair intake, case tracking, status management, and document delivery. The public version offers a safe form and read-only admin; the local version keeps full management features.
SQLite · SQL · Python · Reconciliation
Reconcile sales, returns, and SQL report totals first, then surface high-stock and no-demand items as an actionable review list.
The same operational problem can be delivered as a PWA or a native Windows tool, depending on the device and workflow.
Offline catalog, multi-room quotes, IndexedDB drafts, and three document formats.
A PyQt5 application for catalog search, quote editing, and Excel export.
WHAT I CAN OWN
Connect forms, states, administration, and documents into trackable operations.
Use joins, CTEs, and validation logic to make report numbers traceable and explainable.
Choose web, PWA, or Windows based on the context, with testing and deployment included.
HOW I WORK
Find manual transfer, waiting, repeated input, and error-prone steps.
Finish the central task first and validate it with real devices and synthetic data.
Add reconciliation, automated tests, deployment, and handoff documentation.