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 surfaced nearly $250K of written commitments on a single job the ERP reported as having none, the case an ERP-driven view structurally cannot see.
- 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, integrating 7 upstream systems. 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, and a nightly pipeline distills ~261,000 sign-in events into 29 deduplicated alerts. Each payroll week it reviews ~113 timesheets and ~4,400 labor hours and flags ~42 conditions (~22 critical) for resolution before payroll runs.
- Timecard write-back into a timekeeping system with no published API, over its HTTP and WebSocket protocol rather than a headless browser: promote-then-edit, per-group scope fencing, and an intent-and-result audit line per operation. 769 audited corrections across 37 employees in the first two live payroll cycles, each one previously a manual edit in the vendor UI.