01 — Build
Custom analytical systems
Custom systems let analysts submit, query, review, and reconcile data through an interface built around their workflow. SQL supports storage, aggregation, and database transformations, with Python for calculations, estimation, and analysis where needed. Analysts can compare results, review percent changes, and apply transformations without writing SQL.
02 — Modernize
Legacy-code modernization
FAME, SAS, Stata, and similar production programs converted to tested, maintainable Python, delivered with a reconciliation harness that checks the converted program against legacy output to agreed tolerances across data vintages. Acceptance is documented in a signed reconciliation report.
03 — Connect
SQL and Python pipelines
SQL handles filtering, joins, aggregation, and transformations in the database, paired with Python for calculations and analysis that need its libraries. File interfaces, Excel bridges, integrations, scheduled runners, runbooks, and test suites support production workflows. Version control with Git or Azure DevOps is set up so analysts own their code.
04 — Validate
Validated AI applications
Deterministic programs compute the figures and trace them to source data; LLMs interpret results and draft narrative. The application’s validation layer checks numerical claims in generated text against the computed values. GDPQuery.ai is the reference implementation.
How work is delivered
Fixed-price, deliverable-based work, developed with tests first. Code and documentation are handed over in the client’s own repository, with no dependence on the vendor after acceptance. Cedar Mountain Systems also builds custom software and automation for small organizations.