Full-stack · Production engineering

Staff Scheduling & Payroll

A web app built to production standards — a pure, fully-tested business-logic core, a modular architecture, type-checked and linted in CI, and deployed live.

77 automated tests CI: ruff · mypy · pytest Type-checked core Deployed & live
staff-scheduling.streamlit.app
Weekly schedule grid
Why it's a good sample

Engineered like real software

The scheduling/payroll domain is just the problem it solves — the point is how it's built.

Tested at every layer

77 tests: pure-logic unit tests, SQLite data-layer round-trips, end-to-end integration, and headless UI tests via Streamlit's AppTest.

CI/CD

GitHub Actions runs ruff, mypy, and pytest on every push and pull request — green before anything merges.

Modular architecture

Pure business-logic and data layers kept independent of the UI; the 1,200-line entry point became a ~50-line router over a views/ package.

Type-safe

The logic and data layers are mypy-clean with modern typed Python; the linter runs zero-error.

Security-minded

Parameterized SQL, timing-safe password comparison, escaped rendering, and input validation before every write.

Shipped

Deployed on Streamlit Community Cloud with an auto-seeding demo so it's always populated and clickable.

What it does

The product

staff-scheduling.streamlit.app · Payroll
Payroll report with by-role breakdown and chart
Built with

Tech stack

Python 3.11+StreamlitSQLite pandaspytestruff mypyGitHub Actions
Copy-ready

Résumé & LinkedIn

Engineering-first phrasing you can paste straight in.

Résumé — 2 bullets

Designed and shipped a full-stack web app to production standards: a pure, fully-tested business-logic core (daily/weekly overtime, role-based reporting) cleanly separated from a modular multi-page UI and a SQLite data layer.Wrote a 77-test suite (unit, integration, and headless UI tests) behind a GitHub Actions CI pipeline running ruff, mypy, and pytest on every push; type-checked end to end, input-validated, with timing-safe auth and parameterized SQL — deployed as a live demo.

LinkedIn — Featured / Projects

A full-stack web app I built to practice production-grade engineering. The interesting part wasn't the domain (shift scheduling + payroll) — it was the rigor: a pure, fully unit-tested business-logic core (daily + weekly overtime, lunch deductions, role-based reporting) separated from a modular UI and a clean data layer, 77 automated tests including headless UI tests, and CI running lint + type-checks + tests on every push. Deployed live.

▶ Live demo: https://staff-scheduling.streamlit.app  ·  💻 Code: https://github.com/squireaintready/staff-scheduling

Copied to clipboard