# Ian Kostman Ian Kostman is a remote worker on Himalayas, Lead SQL Developer at Axos Clearing, based in United States. Source: https://himalayas.app/@iankostman ```text I build high-concurrency data platforms, pipelines, APIs, and governance systems. ``` | Detail | Value | | --- | --- | | Availability | Looking for a job | | Location | United States | | Authorized to work in | United States | | Salary expectations | 90k+ USD | | Job categories | Data Engineer, Database Engineer, Data Architect, SQL Developer, System Architect, Application Developer | | Skills | SQL Server, Oracle, Snowflake, PostgreSQL, MySQL, Teradata, MongoDB, Microsoft Fabric, Data Modeling, Relational Modeling, Dimensional Modeling, Data Warehouse, ETL, ELT, SSIS, SSRS, Data Pipelines, Query Tuning, Indexing, Partitioning, ORDS, REST APIs, Webhooks, JSON, XML, CSV, Parquet, Avro, X12, EDIFACT, HL7, Swift, ISO 20022, T SQL, Pl SQL, PL PgSQL, Python, Java, JavaScript, Delphi, DDL Auditing, Versioning, Rollback, Compliance and Controls, Documentation, Development Standards, Mentorship, Tableau, RFID, Excel, Salesforce, Quickbooks | ## About ```text 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 ### Lead SQL Developer Axos Clearing. Jan 2023 - Feb 2026 ```text 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%. ``` Skills: SQL-Server, T-SQL, ETL, Data-Architecture, Query-Tuning, Indexing, Governance ### Senior Data Engineer / Analyst Discover. Jan 2022 - Jan 2023 ```text Built Snowflake ingest and transform pipelines for enterprise regulatory remediation. Cut manual reporting effort by 50% with automated SQL and Tableau workflows. ``` Skills: Snowflake, SQL, Tableau, ETL, Data-Quality, Reconciliations ### Senior Data Engineer / Architect [Fidelity Investments](https://himalayas.app/companies/fidelity-investments). Jan 2021 - Jan 2022 ```text 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. ``` Skills: SQL-Server, Oracle, APIs, Data-Analysis, Backtesting ### Application Development Advisor; Data Architect [Cigna](https://himalayas.app/companies/cigna-health-and-life-insurance-company). Jan 2021 - Dec 2021 ```text Designed API-driven integration for cross-system healthcare data exchange. Documented architecture and guided development teams on backend workflow services. ``` Skills: API-Integration, Healthcare-Data, Architecture, Documentation ### Senior Data Engineer / Systems Architect Konami Gaming. Jan 2019 - Jan 2021 ```text 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. ``` Skills: Oracle, ORDS, APIs, ETL, Distributed-Systems, Self-Service-Reporting ### Senior Data Engineer / Architect CTG / HMS. Jan 2018 - Jan 2019 ```text 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%. ``` Skills: Metadata-Driven, Governance, Versioning, Audit, SQL, Standards ### Senior Database Engineer DiTRONICS. Jan 2017 - Jan 2018 ```text 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%. ``` Skills: T-SQL, Excel, BIツール, Fuzzy-Matching, Entity-Resolution, Compliance ### Senior Developer FundAmerica. Jan 2015 - Jan 2016 ```text Built API interfaces, webhooks, gateways, and third-party developer documentation in multiple languages. Published developer guides with sample integrations and streamlined database processing. ``` Skills: APIs, Webhooks, Gateway, Documentation, Databases ### Database Architect / Consultant Monument Systems. Jan 2013 - Jan 2015 ```text Built Coordination of Benefits API gateways for multi-plan healthcare claims, plus warehouse/ETL models, security standards, and developer training. ``` Skills: APIs, Healthcare, ETL, Data-Warehouse, Security, Training ### Director of Development / Systems Architect Nemo-Soft Business Solutions. Jan 2008 - Jan 2013 ```text Led product and data-platform development: APIs, warehousing, ETL, performance monitoring, and integrations with MAS, QuickBooks, and Salesforce. ``` Skills: APIs, Data-Warehouse, ETL, Performance-Monitoring, MAS, Quickbooks, Salesforce ### Chief RFID Technologist Gaming Partners International. Jan 2003 - Jan 2005 ```text 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. ``` Skills: RFID, MAS-200, Manufacturing, Operations, Training ### Senior Programmer Casino Data Systems. Jan 1998 - Jan 1999 ```text 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. ``` Skills: SQL, Database-Proxy, Security, Audit ## Education ### Western Governors University Bachelor of Science, Data Analytics ```text Pursuing a Bachelor of Science in Data Analytics, with an expected completion in 2027. ``` ## Tech stack - Snowflake - Tableau - Salesforce - MySQL - PostgreSQL - MongoDB - Oracle - JavaScript - Python - Java - Swift - JSON - XML - Avro - QuickBooks - Microsoft Fabric To contact Ian, message them from this profile with a Himalayas employer account: [Hire on Himalayas](https://himalayas.app/hire). ## People also viewed - [dave withers](https://himalayas.app/@davewithers): Director, Data Services, PWC - [Sean Cooperman](https://himalayas.app/@seancooperman): Director of Data Engineering, Sightline Payments - [Michael Sutherin](https://himalayas.app/@michaelsutherin): Database Consultant, MacroTrenz Corp - [Randy Abel](https://himalayas.app/@randyabel): Senior Manager & Solution Architect, Insurity, Inc. - [Haji Syed Hassan](https://himalayas.app/@hajisyedhassan): Sr. Oracle Developer, TEK Systems Client: Mount Sinai Hospital - [Michael Monroe](https://himalayas.app/@michaelmonroe): Director, Software Engineering, Customer IAM, S&P Global - [sabira naik](https://himalayas.app/@sabiranaik): Senior Software Architect, KIPP Foundation - [Robert Mills](https://himalayas.app/@robertmills): Data Architect / Conversion Architect, Database Design Arts LLC / Astreax - [Justin Stewart](https://himalayas.app/@justinstewart): Senior Database Engineer, Illumis Global - [Serge Shermon](https://himalayas.app/@sergeshermon): Senior Data Engineer | Data Architect, Apple Bank