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.