ASHLEY MCMAHON

Technical Solutions Architect | AI & Cloud Data Platforms

📞 0402 123 045 📧 ashley@maximumeffort.academy 🌐 ashleymcmahon.com 🔗 LinkedIn Profile

Summary

Technical Solutions Architect with 20+ years of experience, specializing in architecting and deploying end-to-end data platforms and autonomous, expert-persona AI agents. Expert in bridging Cloud Infrastructure (IaC), DevOps Automation, and complex Python data pipelines to transform high-dimensional, unstructured data into clean, model-ready datasets. Proven experience integrating GenAI/LLMs (Vertex/Gemini) to codify expert human reasoning (from data analysis to market strategy) into scalable, automated applications.

Technical & Systems Expertise

Cloud & DevOps

AWS (S3, CLI)GCP (Vertex AI)Azure (VMs, CLI)TerraformAnsibleIaCPuppet (Hiera)AirflowJenkinsCI/CD

Data Warehousing

SnowflakeBigQueryMongoDBPostgreSQLNoSQLAdvanced SQLETL/ELTData Modeling

Python & AI

PythonFastAPIPydanticSQLAlchemyPandasGenAI Prompt EngineeringLangChainStreamlitdbtREST APIs

Systems & Leadership

RHEL8Linux AdminLVMBash/ShellNetwork BondingAI Agent ArchitectureGlobal Training

Professional Experience & Key Projects

Lead Data Engineer @ Nielsen

Sydney, NSW | 2022 – 2025
Generative AI Data Platform
  • Architected a GenAI-powered data platform to automate the creation of data products, including Generative ETL, Generative BI, and Automated Narrative Reporting.
  • The platform enriches millions of AdTech segments in Snowflake by calling GenAI (Vertex AI) for automated categorization and business-ready descriptions.
  • Includes a 'Persona Engine' that uses LLMs to dynamically write and execute complex, multi-clause Snowflake SQL HAVING logic, turning strategic tiers into queryable audiences.
GenAI-Powered Audience Analytics Platform (FastAPI Backend)
  • Architected the backend data platform for a Tableau Extension, enabling GenAI-driven audience segmentation directly within dashboards.
  • Engineered a Python (FastAPI) backend to translate dashboard interactions into on-the-fly ELT jobs in Snowflake, reducing time-to-insight from days to under one minute.

Senior Systems Administrator & Automation Engineer @ Amadeus

Sydney, NSW | 2002 – 2022
  • Led the 20-year automation strategy for the global data platform, including architecting the full IaC provisioning stack (Ansible, Terraform, Python) and leading the strategic migration from Puppet to Ansible to resolve production-state drift.
  • Spearheaded a zero-downtime migration of production MongoDB clusters (120+ shards) from Gen8 to Gen10 hardware. Orchestrated the migration using a custom Python automation tool (cluster_migrator.py) and YAML configs to safely extend replica sets, sync data, and promote new primaries without application interruption.

Reusable AI Agent Architecture @ Independent Framework

Personal Project
  • Architected a domain-agnostic, multi-chain AI agent framework (Python/FastAPI/Pydantic) designed to codify expert human reasoning into scalable, multi-artifact applications.
  • Designed and built an Autonomous Data Analyst Agent that connects to any Snowflake DB, inspects the schema, and iteratively plans, reflects, generates, and executes SQL to answer ambiguous questions (e.g., "who are our top athletes?"). The agent auto-generates a final, boardroom-ready HTML/CSS report.

Leadership & Evangelism

Athletic Achievements

Athletics Coach & Masters Sprinter (100m/200m), holding multiple Australian State and National records.

References

Aymeric Gerardin

📧 aymeric.gerardin@rev-log.com

🔗 linkedin.com/in/aymeric-gerardin