Efe Dincaslan
I've built a life of discipline, consistency and hard work. I've worked in sales, accounting, cybersecurity, data mining, AI engineering and full-stack development — and now, data engineering. I train in strength and endurance sports. I've lived in many places and traveled to 20+ countries.
There's more to the story than a résumé.
From banquet halls and BBQ pits to finance desks and consulting rooms — then securing enterprise systems, mining court records, and building full-stack AI platforms, with data engineering at Fidelity up next. Tap a chapter:
- Took over a stalled data platform that had only one city built (Arlington, TX) — with serious data-integrity and data-limitation issues — and rebuilt it end to end into CensusFlow: a nationwide commute & workforce site covering all 50 states + DC (~1,160 city pages) in two and a half weeks, using Claude Code for engineering and Claude Design for the UI.
- Engineered the full Python pipeline — ingesting the Census LEHD LODES dataset (25 tables, hundreds of millions of rows; the raw OD table alone ~546M) on a 500 GB Azure SQL database, transforming it into city-level data marts, rendering thousands of static pages, and publishing them via the WordPress REST API with Azure Blob Storage as the CDN.
- Built the entire front end in vanilla JavaScript (no framework) — ~2,000+ lines across two WebGL maps (deck.gl + MapLibre GL) that draw each city’s commute as a live dot-density visualization (one dot ≈ 75 workers), with hover tooltips, dynamic legends, earnings/industry color modes, residents-vs-workers toggles, client-side search, and a custom responsive design system (~1,600 lines of CSS).
- Built cross-state commuting from scratch — a capability the source data never had — through a 100M+ row global home-block join that correctly counts the ~7.5M Americans who commute across a state line (NJ→NYC, VA→DC), fixing previously-broken city stats like Washington, DC.
- Enriched the data beyond LODES via the Census ACS API (commute time, work-from-home, income) and FCC broadband data across 1,732 cities — running hundreds of SQL queries with data-integrity checks at every stage.
Where the foundations were poured.
I grew up playing basketball, soccer and swimming — and that early love of being active never left. These days it's the barbell and the road: I just ran the Hokie Half, the Charlotte Marathon is next, and an Ironman is the long game. Between training blocks I've chased stamps in 20+ countries.