Circuit Vitae

Mihail Ksenofontov
Riga, Latvija

Phone: +371 2 9720407
Email: ksenofontov.mihail[at]gmail.com
Social: Telegram | Git | LinkedIn
Languages: Russian, English, Latvian


Skills:

Bloomberg, IBKR, SQJ, Quik, Transaq, JForex, MT4/5, Xnt etc.
OracleSQL, PostgreSQL, T-SQL, HTML, CSS, Pyton, Git, Ubuntu, Power BI, Tableau
JS, PHP, API, REST, CRUD, CLI, Oracle Cloud, Bootstrap, Canva, Figma


Certificate:

SQL
All in 2021
Credential ID
PostgreSQL: UC-2c18ef73-3a0a-4843-a1cc-1e4efe266123
Oracle SQL: UC-44fd7468-9b91-4ad9-8c6b-66bb2e923181
T-SQL: UC-efbd7f8d-8190-4ta7-bbcd-8d6b8eafdc14

Awarded as a Best client consultant ERGO, Riga
July 2005

Latvian Insurers Association (LIA) qualification, Riga
July 2006


Employment:

Open for work
May 2021 – Till now

  • Founder psql.pro
  • Business consulting and software development.
  • Projects focused on the financial market using Python and SQL.
  • Freelancer.

Trading desk at EXANTE
September 2018 — November 2019

  • Execute trades and develop short/long-term financial strategies, ensuring that quality standards and company policies are fully met.
  • Collaborate with other traders and industry professionals to provide expertise and best financial services possible.
  • Identify and explore new investment opportunities.
  • Monitor and evaluate potential investment risk.
  • Create market analysis to identify new opportunities.
  • Close cooperation with IT team to improve company’s trading system through developing new, more effective procedures.
  • Assist in purchasing/liquidating financial assets.

R.M. department DUKASCOPY
July 2013 — August 2018

  • Brokerage & Monitoring of the trading system is functioning and related troubleshooting.
  • Liquidation of trading discrepancies. Monitoring of the FX exposures.
  • Clients support (English/Russian) with regards to the FX trading, platforms and trading system related questions.
  • Project management.
  • Systems Testing.

Personal projects:

Development of trading systems and project manager.
Creating Advisors. (more than 10 projects)
Creating indicators. (3 projects)
Creating scripts. (2 projects)
Portfolio: MQL profile (Final draft 2020.)


Trading Operations at SEB AB
July 2008 — March 2011

  • Handle Settlement, Payment, Reconciliation and Confirmation process for Derivatives products traded within SEB Globally (NDF, FX Options, CDS, Futures, NASDAQ OMX).
  • Perform trade affirmation with counter parties; perform payment investigations and trade reporting.
  • Mentor ship.

Personal projects:
A joint project based on the financial instrument Options.
The essence of the project: Creating a portal for learning the basics and theory of option trading, strategy.
Portfolio: Option Laboratory (The project was closed in 2014)


Client manager at A/AS ERGO Latvia
April 2004 — March 2008

  • New contract signing (retail, corporate clients).
  • Pricing of individual risks.
  • Client support.
  • Monitor payments.
  • payment investigations (accounting, financial reporting, underwriting and claims).

Education:

Middle level, 33. Middle School, Riga
September 1990 — June 2001

High level, Information Technology and Management (ISMA), Riga
Management and marketing.

High level, Social technology highschool, Riga
Management and marketing.