Project Accountant / IT Specialist (Internal Software & Automation) · Odin Electric
Sept 2024 – Present · Remote
- Flask analytics dashboard over the Foundation ERP (MS SQL Server via pymssql): AR aging and DSO, revenue recognition under three methods, project-level cost accounting and margin analysis, GL tie-out against the AR subledger, billing and invoice generation. The invoices go to customers and the reports go to leadership. Currently extending it to GL-driven income statement projections, replacing a hand-maintained forecast spreadsheet.
- Document-to-data reconciliation in progress with a purposeful three-way split: read-only agent extraction from unstructured documents, deterministic matching and calculation, human remediation. First pass identified ~$107,000 in real errors and ~$572,000 in phantom duplicate commitments.
- Natural-language-to-SQL query layer on LLM tool-use. JSON-schema-validated tool calls,
sqlglotAST validation, ~175 unit tests, so a model-assisted feature ships with a correctness bar instead of trust in raw output. - Flask workforce platform over HH2 labor exports and the Microsoft 365 tenant. Configurable rules flag payroll violations before they reach a paycheck; an identity layer reconciles Entra against payroll for terminated employees holding paid licenses, missing MFA, and offboarding left open for years. Timesheet correction throughput rose 82% and pre-payroll correction coverage doubled, measured across 99 payroll weeks of transaction-log history while the workforce grew ~20%.
- License and device drift monitoring. A one-time Microsoft 365 cleanup cut spend roughly 50% and then drifted back; the inventory built to replace it surfaced 62 of 86 devices untracked in any system. Cleanups do not hold; systems do.