Analyst & Developer / Berlin
I build Threshold, an open-source platform that tracks geopolitical escalation. The rest of my time goes to research, data work, and the code that holds it together. Russian by origin, based in Berlin.
Flagship / 2025 to present
Threshold watches international media for events that signal geopolitical escalation. A language model reads each report, pulls out the event, and sorts it. Everything lands in an index with a timestamp. The count is past 200 and the system runs in production.
I wrote all of it. The FastAPI backend, the Supabase database, the React frontend, and the classifier in between. What counts as escalation, and how the rungs are ordered, comes from the work of Schelling and Kahn.
Writing
I write about geopolitics and open-source intelligence, and about the systems that move under the headlines. Longer pieces go on Substack. The quick reactions go to Telegram.
Curriculum Vitae
What I have built and studied, on one page. Below is the same record laid out in full.
I built and run a platform that tracks geopolitical escalation from open sources. I wrote the whole stack alone, from the scraping and the language-model classifier to the database and the frontend. More than 200 incidents are catalogued and the system is live. I presented it to security researchers at Freie Universität Berlin and came away with a referral toward the EXIST startup grant.
I coach students and working professionals through English and TOEFL preparation. I scored 111 out of 120 on the test myself. In 2026 I shaped the coaching into a structured offer aimed at international students in Berlin.
I researched international trade in chemical equipment, wrote commercial proposals for clients in Europe and Asia, and kept the CRM in order.
Focus on relations between the United States and the European Union, security studies, and technology policy.
Thesis on EU energy policy and the Sustainable Development Goals, graded Excellent. Research assistant to Prof. M. Shumilov on European and Asian security.
Technical
Python, FastAPI, SQL (PostgreSQL and Supabase), React, LLM and AI pipelines, OSINT tooling, Git, Excel.
Professional
Analytical writing, research, data organisation and reporting, client communication, public speaking.
Languages
Russian (native). English (near-native, TOEFL 111/120). German (working). Spanish (B1).
Selected work
Ultima Thule, a visual analysis of Arctic sovereignty. On show at the John F. Kennedy Institute in Berlin since February 2026.
Contact
I am open to work in OSINT, research, and risk intelligence. Email is best for anything formal. For everything else I am on Telegram and Instagram under the same handle.
© 2026 Ivan Andrianov / Berlin