The starting point
Reporting ran on a legacy FoxPro data platform hosted on Windows Server 2008. The network and identity setup also needed a serious overhaul.
What I did
- Data platform. Rebuilt it as containerized ETL: Python and Polars pipelines orchestrated by Airflow, loading SQL Server, running in Docker, with dbt data models behind Power BI and Excel reporting.
- Network and identity security. A FortiGate firewall cluster with VLANs, Microsoft 365 with Entra ID SSO and MFA, and AWS (S3, RDS, Secrets Manager).
- How I worked. Directly with senior management and non-technical teams, rebuilding the stack and software the way they wanted it, and translating security concerns into clear fixes.