CASE STUDY 01 Role: Software Engineer

Case Study: Electronic Provisioning Migration

Executive Summary

Spearheaded the complete overhaul of a legacy electronic provisioning system to support the company's efforts to migrate to a new CRM. Transitioned insecure Perl scripts on an end-of-life Debian server to a modern Python/Django architecture with a modern containerization deployment strategy. Successfully orchestrated enterprise-wide vendor migrations and zero-downtime system cutovers for mission-critical VoIP and 911 emergency services.

Tech Stack

Languages
Python YAML Perl (legacy)
Frameworks
Django Django REST Framework
Databases
PostgreSQL MariaDB Redis
Libraries
Celery requests Zeep Django Prometheus
Testing
pytest (Django Testing, Mocking)
Developer Tools
VS Code Git Docker Sphinx
Infrastructure & DevOps
GitHub Actions (CI/CD) Ansible Nginx Gunicorn Bitwarden API (secrets management) Debian Proxmox
Monitoring & Observability
Grafana Grafana Alloy
Methodologies
Agile

Challenges

Technical Debt

Legacy provisioning systems were built on outdated, insecure Perl scripts that posed severe security vulnerabilities such as containing plain-text secrets, lack of data sanitation, and passing data without encryption. There were also maintenance bottlenecks such as no metrics or logging and lack of a deterministic deployment strategy.

High-Stakes Cutover

Many of the databases and systems that the provisioner utilized were no longer compatible with a modern stack because of end-of-life states. This required enterprise-wide database migrations for life-critical 911 services, which demanded zero-downtime executions, and Radius migrations.

Architecture & Execution

Asynchronous Processing

Architected a centralized hub using Celery & Redis to manage high-volume, asynchronous task processing, ensuring real-time provisioning updates without impacting front-end stability. Also uses built-in retry logic for stable operations.

Run-Time Security

Deployed on supported Debian-based VM servers. Secrets management via the Bitwarden API and UUIDs saved as environment variables. All operations performed within the Django ORM framework.

Pro-Active Security

GitHub Actions CI/CD uses Trivy and dependency scanning so CVEs can be easily corrected and monitored. A full-coverage suite of fast & safe unit tests run on CI/CD before merges are allowed into main.

Ingestion & Validation

The application receives a CRM webhook, validates the payload, and fetches extended product details.

Pattern Matching

Utilizes an abstract factory pattern to match the payload against a registry of valid provisioner serial numbers.

Asynchronous Execution

Upon a match, tasks are dispatched to a Celery Worker to run the correct provisioning method, utilizing lazy initialization at the boundary to fail fast if data is missing.

Observability & Monitoring

Integrated Prometheus and Grafana Alloy to establish comprehensive metrics and centralized logging eliminating the operational blind spots present in the legacy system.

The Business Impact

100% Uptime

Guaranteed continuous availability and successfully managed the risks of high-stakes infrastructure transitions for customer-facing emergency services.

Strategic Alignment

Bridged the communication gap between technical teams and sales/executive stakeholders prioritizing features based on operational ROI.

Team Leadership

Mentored the engineering team on migration best practices, combining high-level systems thinking with hands-on execution.

Documentation & Maintainability

Utilized Sphinx and GitHub Actions to generate and maintain (on-demand or upon releases) robust internal documentation, ensuring the new architecture is easily maintainable and accelerating onboarding for the engineering team.