Looking for a job

Ian Kostman

@iankostman

I build high-concurrency data platforms, pipelines, APIs, and governance systems.

I've built high-concurrency data platforms, integration services, and governance frameworks across financial services, healthcare, gaming, and telecom for more than 25 years.

At Axos Clearing, I architected clearing processes for 5M+ daily financial transactions, reduced database footprint by 65% across 25+ TB, cut core query latency 40–60%, and eliminated about $250K in annual licensing costs with an in-house service.

I've also delivered Snowflake regulatory pipelines at Discover, sub-second trade analytics at Fidelity Investments, healthcare integrations at Cigna, and an Oracle ORDS API that consolidated 485+ endpoints at Konami Gaming. I focus on source-of-truth architectures and maintainable systems that teams can operate, audit, and evolve.

Experience

Work history, roles, and key accomplishments

Lead SQL Developer

Axos Clearing

Jan 2023 - Feb 2026 (3 years 1 month)

Architected clearing processes for 5M+ daily financial transactions under audit and compliance requirements. Reduced production database footprint by 65% and cut core query latency by 40-60%.

SQL Server T SQL ETL Data Architecture Query Tuning Indexing Governance

Senior Data Engineer / Analyst

Discover

Jan 2022 - Jan 2023 (1 year)

Built Snowflake ingest and transform pipelines for enterprise regulatory remediation. Cut manual reporting effort by 50% with automated SQL and Tableau workflows.

Snowflake SQL Tableau ETL Data Quality Reconciliations

Senior Data Engineer / Architect

Fidelity Investments

Jan 2021 - Jan 2022 (1 year)

Engineered a convertible-arbitrage platform integrating SQL Server, Oracle, and APIs for sub-second trade data analytics. Delivered secure 24/7 data services and analytical models that improved back-testing throughput 3x.

SQL Server Oracle APIs Data Analysis Backtesting

Application Development Advisor; Data Architect

Cigna

Jan 2021 - Dec 2021 (11 months)

Designed API-driven integration for cross-system healthcare data exchange. Documented architecture and guided development teams on backend workflow services.

API Integration Healthcare Data Architecture Documentation

Senior Data Engineer / Systems Architect

Konami Gaming

Jan 2019 - Jan 2021 (2 years)

Consolidated 485+ legacy endpoints into an Oracle ORDS API and reduced fragmentation about 90%. Built distributed pipelines for tens of thousands of daily mobile interactions with transactional integrity.

Oracle ORDS APIs ETL Distributed Systems Self Service Reporting

Senior Data Engineer / Architect

CTG / HMS

Jan 2018 - Jan 2019 (1 year)

Architected a metadata-driven governance and versioning platform used by 120+ developers, with real-time auditing and rollback. Enforced naming, coding, and deployment standards in-database and reduced deployment errors about 70%.

Metadata Driven Governance Versioning Audit SQL Standards

Senior Database Engineer

DiTRONICS

Jan 2017 - Jan 2018 (1 year)

Consolidated thousands of distributed sources using metadata-driven fuzzy matching and entity resolution. Built compliance batch pipelines and a T-SQL / Excel BI layer that reduced fraud-related losses more than 35%.

T SQL Excel BIツール Fuzzy Matching Entity Resolution Compliance

Senior Developer

FundAmerica

Jan 2015 - Jan 2016 (1 year)

Built API interfaces, webhooks, gateways, and third-party developer documentation in multiple languages. Published developer guides with sample integrations and streamlined database processing.

APIs Webhooks Gateway Documentation Databases

Database Architect / Consultant

Monument Systems

Jan 2013 - Jan 2015 (2 years)

Built Coordination of Benefits API gateways for multi-plan healthcare claims, plus warehouse/ETL models, security standards, and developer training.

APIs Healthcare ETL Data Warehouse Security Training

Director of Development / Systems Architect

Nemo-Soft Business Solutions

Jan 2008 - Jan 2013 (5 years)

Led product and data-platform development: APIs, warehousing, ETL, performance monitoring, and integrations with MAS, QuickBooks, and Salesforce.

APIs Data Warehouse ETL Performance Monitoring MAS Quickbooks Salesforce

Chief RFID Technologist

Gaming Partners International

Jan 2003 - Jan 2005 (2 years)

Architected RFID manufacturing and operations software integrated with MAS-200 for configuration, pricing, cost accounting, and shop-floor tracking. Trained staff and represented the technology to international clients.

RFID MAS 200 Manufacturing Operations Training

Senior Programmer

Casino Data Systems

Jan 1998 - Jan 1999 (1 year)

Designed a database proxy to inspect and route SQL traffic, applied injection and IP controls, pooled up to 1,024 client sessions onto one licensed connection, and logged activity for audit.

SQL Database Proxy Security Audit