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.