Aviation operations and systems-safety professional building practical automation tools for dispatch workflows, live translation, media production, and public-facing web systems.
- Aviation operations and dispatch support
- Systems safety, risk analysis, and operational reliability
- Workflow automation and decision-support tools
- Python, VBA, Excel, HTML, FastAPI, WordPress, and FFmpeg
- AI-assisted development for recurring operational problems
- Documentation, regression control, and maintainable handoff
A sanitized aviation decision-support project combining synthetic service-location records with simulated movement signals.
Current public demo
- Runnable Python status engine
- Parking, Landed, Flying, and Uncertain precedence
- Searchable dark/light HTML table and ramp view
- Map-visibility and location-confidence rules
- Unit tests for stale-data and movement-state behavior
A runnable FastAPI and WebSocket demonstration of a model-agnostic Korean–English live-translation workflow.
Current public demo
- REST processing and session endpoints
- WebSocket snapshots and live viewer updates
- Partial-fragment suppression
- Glossary-assisted terminology visibility
- Bounded session memory for reconnecting viewers
- Unit-tested pipeline logic
A config-driven Python and FFmpeg workflow for recurring sermon-media preparation.
Current public demo
- Safe dry-run mode
- Optional authorized execution mode
- YAML configuration
- Latest-recording discovery
- Generated intro, normalization, concatenation, WAV export, and upload-ready packaging
- Tests for naming, discovery, and command construction
A WordPress rebuild case study covering legacy-site assessment, information architecture, event and media organization, workflow integration, and long-term maintainability.
Current documentation
- Directly linked case-study sections
- Operational maintenance model
- Event-calendar refinement
- Sermon-media workflow integration
- Privacy-safe lessons learned
- Identify recurring operational friction.
- Map the real workflow and failure modes.
- Build the smallest useful tool.
- Add conservative safeguards and clear status information.
- Separate public demonstrations from production data and infrastructure.
- Test deterministic behavior and document the handoff.
- Improve the system through operational feedback and regression review.
All public repositories are intentionally sanitized and exclude employer-confidential information, private organizational data, credentials, production records, and copyrighted operational media.