chicong115.com
Back to work
work

Software Engineering Manager @ Air360

Jun 2021 – May 2022
Engineering ManagementBig DataClickHouseBigQueryKubernetes.NET Core 6

UX Analytics at Scale

Air360 is a UX Analytics SaaS platform capturing and analyzing millions of user interactions for Conversion Rate Optimization (CRO). Headquartered in France with distributed teams. Managed engineers across Vietnam, France, New Caledonia, and Japan — navigating 4 time zones and 3 language barriers.

Backend Migration (.NET Core 2.1 → 6.0)

  • Spearheaded zero-downtime major framework upgrade using strangler-fig pattern
  • Migrated services incrementally while maintaining backward compatibility
  • Resolved breaking changes in DI, middleware pipeline, and auth flows
  • Result: 35% improvement in request throughput, 20% reduction in memory footprint

Data Pipeline Re-architecture (100TB+)

  • Decommissioned legacy PostgreSQL databases buckling under volume
  • Deployed ClickHouse for real-time analytical queries (sub-second on billions of rows)
  • Google BigQuery for batch analytics, long-term storage, and ad-hoc BI
  • Pipeline: 100TB+/month — click events, scroll events, page views, session recordings
  • Implemented data freshness monitoring (alerts for >5min pipeline lag)
  • Parquet format for cold storage, reducing costs by 70% vs JSON
  • Dead-letter queues for graceful error handling and replay
yaml
# Air360 — Data Infrastructure
pipeline:
  input: "100TB+/month (UX events)"
  real_time: ClickHouse (sub-second on billions)
  batch: Google BigQuery
  storage: Parquet (−70% cost vs JSON)
  monitoring: Data freshness alerts (<5min lag)

infrastructure:
  compute: AWS EKS (Kubernetes)
  migration: Docker Compose → K8s
  observability: Datadog (APM, logs, dashboards)
  sla: "99.95% uptime"

framework_upgrade:
  from: ".NET Core 2.1"
  to: ".NET 6.0"
  pattern: "Strangler-fig (incremental)"
  throughput_gain: "+35%"
  memory_reduction: "−20%"

Tooling & Innovation

  • Deployed n8n for internal workflow automation
  • Built custom Salesforce integrations for syncing product usage with sales pipeline
  • Developed custom Chrome Extensions for internal tools and QA workflows