Alexander Unterrainer
Alexander is a senior KDB/Q developer, blogger, and the founder of DefconQ (www.defconq.tech), a KDB/Q tech blog. With a wealth of experience, Alexander has contributed his expertise to several large international Investment Banks, showcasing his proficiency in the KDB/Q technology stack. Currently serving as a consultant for Data Intellect, he continues to be at the forefront of cutting-edge developments in the field. As a KDB/Q developer, he possesses an in-depth comprehension of KDB-tick architecture, adequately managing market data storage, processing, and delivering cutting-edge APIs for advanced data analytics, transformation, and visualization. Alexander's educational background in Economics and Computational Finance equips him with a profound understanding of financial products and the complexities involved. Coupled with strong teamwork and communication skills, Alexander seamlessly collaborates with colleagues and business stakeholders
Working Experience
Data Intellect (formerly AquaQ), Consultant [April 2023 - present]
I am currently an independent KDB/Q consultant engaged with a client of Data Intellect. As a senior developer my main responsabilities are developing and maintaining the internal KDB/Q stack (TorQ framework), capturing new data, creating APIs to access data, crafting dashboards to visualize data in Panopticon, and fostering close collaboration with fellow developers, quantitative developers, traders and quants.
HSBC - GFX KDB/Q Developer, Vice President [Feb 2020 - April 2023]
KDB/q developer working on the GFX platforms helping to design, build and run applications in the foreign exchange space as well as maintain and improve existing services. Main developer of a real time hitratio application to analyse how many RFQs (Request For Quotes) resulted in a trade. Developed a real time CEP that publishes data to an RDB. Reduced overnight job that took 60+ minutes to run into real time application. Integration of the data into an API that allowed the business to query the data and enhance it with additional information. Close collaboration with quants, quant devs and surveillance team members.
Technical Skills:KDB/Q, bash, python
Asset Class: FX and all corresponding derivatives such as Futures, Forwards, Options, NDF and Swaps
UBS - Quantitative developer specialised in KDB/q - Consultant[Dec 2018 - Dec 2019]
Quantitative developer specialised in kdb/q and cash equities derivatives. Working on tick data from market data providers such as Thomson Reuters and Bloomberg (both intraday as well as historical big data). Onboarding new data sets (new instruments) and integrating them into the current available APIs. Creating new APIs for end users. Close collaboration with Strats, Quants and Sales to backtest strategies for client trades.
Technical Skills: KDB/Q, bash
Asset Class: Equities and all its derivatices such as Options, Futures and Forwards
Morgan Stanley - KDB/q developer for Quantitative Structured Products - Associate [Sep 2017 - Dec 2019]
Responsible for building and maintaining first class automated trading systems, servicing key stakeholders in the Equity and Derivatives Business Areas such as Quants, Strats and Traders. Improving stability and scalability of the tick plant and associated access points/APIs, enhance the current design and add new features requested by the business. Working closely with the business to design and build q queries to achieve analytics objectives.
Technical Skills: KDB/Q, bash
Asset Class: Equities and all its derivatives such as Options, Futures, Forwards or other structured products
Citi - Technology Analyst 2nd Rotation - KDB/Q developer [Sep 2016 - Sep 2017]
Worked on data and analytics services in KDB+/q, providing real time and historical statistics on orders, executions, transaction costs, and market data to the Electronic Execution, Cash, and Program Trading Desk.
Personal Achievement:
Took ownership of a new greenfield project called QPB (Quantitative Prime Brokerage) running in three regions APAC, NAM, EMEA. Responsible for whole software life cycle including server setup, development, testing, release etc. Coordination of several teams in different regions.
Technical Skills: KDB/Q, bash
Asset Class: Equities, Options, Futures, Forwards
Citi - Technology Analyst 1st Rotation - Global Securitized Markets [Sep 2015 - Sep 2016]
As a technology graduate in Citi Centric Securitized Markets (CCSM) I was working on a new trading application for asset backed securities for the EMEA traders. This greenfield project includes development of both front and back end as well as database design and implementation.
Technical Skills: C#, HTML, CSS, Angular, SSIS, SSRS, SQL
Asset Class: Goverment Bonds, Municipal Bonds, Residential Bonds, Asset Backet Securities, Fixed Income
Qualifications
KXperts
Alexander has been the first developer to be awarded the highest level of "Black Tier" of the KXpert Developer Advocacy Program by KX, for his outstanding work creating blogs, answering questions, speaking at events, and helping the KX Community of over 6000+ developers! If you want to read more about the KXpert Developer Advocacy Program, you can read his blog post here
Education
University College London UCL (United Kingdom, London) - MSc in Financial Systems Engineering - GPA: 75/100 - Distinction - Dean's List [Sep 2014 - Sep 2015]
Compulsory modules
Requirements Engineering and Software Architecture, Software Abstractions and Systems Integration, Validation and Verification, Tools & Environments, Financial Institutions and Markets, Financial Information Systems, Compliance, Risk and Regulation, Professional Practice Awards: Dean's List, commends outstanding academic performance, equivalent to the top 5% of student achievement
University of Essex (United Kingdom, Colchester) - MSc in High Frequency Finance and Trading - GPA: 87 - Distinction - [Sep 2013 - Aug 2014]
Compulsory modules
Agent-Based Modelling in Finance and Economics, High Frequency Finance and Empirical Market Microstructure, Programming Java, Quantitative Methods in Finance and Trading, Big Data for Computational Finance, Trading Global Financial Markets, Financial Market Analysis, Professional Practice and Research Methodology
Master dissertation: An electronic central limit order book for crypto currency pairs supervised by Dr. Steve Phelps.
Purpose: Create a basic framework for a crypto currency exchange where different crypto currencies can be exchanged against each other. The order book was completely build in Java.
Free University of Bolzano (Italy, Bolzano) - BSc in Economics and Management - GPA: 104/110 [Sep 2008 - Oct 2012]
Main modules
Economics, Management, Financial Mathematics, Statistics, Financial Markets and Institutions, Interest Rates Derivatives, Financial Risk Management, Advanced Computer Skills, Corporate Finance.
Bachelor Degree Thesis "Algorithmic Trading - An Overview" supervised by Prof. Alex Weissensteiner and Prof. Paolo Coletti.
Purpose: Introduce the reader to Algorithmic Trading and propose a new algorithm, developed by the author Skills: The ability to work hard and perform under pressure; the ability to absorb and critically assess vast amounts of information in a competitive setting. Effective and efficient time management to allow working experience alongside prolonged university hours
Skills Matrix
Area | Beginner | Intermediate | Advanced |
---|---|---|---|
Languages | K,Shakti | Python,Java,Bash, Matlab, VBA | KDB/Q |
Architecture | KDB Tick | ||
Business Knowledge | Time Series | FX, Quantitative Finance, Options | Equities, Tick data |
Other | Confluence, git, JIRA, Bloomberg, Thomson Reuters, Panopticon |
Personal Details
Languages
English , German , Italian
Passports
Italian, British
Driving Licence
B
Interests outside work
Finance, Quantitative Finance, Financial Markets, Code golf, Fitness (GYM, weight lifting), Martial Arts (Muay Thai, Brazilian Jiu-Jitsu), Music