← Back to list
Senior
Registration: 29.05.2025

Sergei Gantsev

Skills

SQL
PostgreSQL
REST API
Kafka
UML
BPMN
SOAP
XML
Python
Java
C#
Visual Basic
Sybase
PL/SQL
SSIS
HTML
MQ
DB2
Jira
Confluence
MS PowerPoint
MS Visio
MS Excel
Git
Microservices
Use Cases
User Stories

Work experience

Senior System Analyst
12.2023 - 03.2025 |Diasoft
UML, BPMN, PostgreSQL, REST API, SOAP API
Diasoft is a leading Russian IT solutions provider for the financial sector, serving over 150 organizations, and recognized for its expertise in automation, digital transformation, and global partnerships. ● Led the development of a migration strategy for transitioning from a monolithic system to a microservices architecture, successfully delivering a banking guarantees microservice. As a result, implemented functionality that enables the automatic deployment of the new system, ensuring scalability and efficiency. ● Coordinated and conducted a full module analysis of data structures and algorithms from scratch using Java through reverse engineering, designed a comprehensive set of 25 tables to ensure accurate data mapping, and documented processes and integration workflows using UML and BPMN. ● Independently outlined the complete technology for data loading into the new system, utilizing PostgreSQL, REST API, SOAP API, and message broker technologies for data exchange and collaborating with the key stakeholders. Achieved the lowest defect rate among all parallel projects by enforcing QA measures, validating requirements, and maintaining documentation. ● The developed migration strategy, architecture, and universal migration schema can be reused for other clients, enhancing the efficiency of banking guarantee processing by 50%.
System Analyst & Developer
04.2018 - 09.2023 |Gazprombank
REST API, ESB, ETL, FTP, T-SQL, Visual Basic, JSON, XML
Gazprombank is a leading powerhouse in Russia's financial sector, offering comprehensive banking services to individuals, businesses, and government entities. ● As a sole contributor, led the bank’s integration optimization with Russia’s largest exchange and created a complete data loading solution for the SPB Exchange from scratch, providing the integration services for two key strategic partners. ● Fully automated the bank’s transaction loading system by upgrading all stages, including adapters, front-end, and back-end systems. Increased transaction processing speed by 40% to handle approximately 70-80K transactions daily through the implementation of REST API, ESB, ETL, FTP, and real-time integration. The whole cycle of integration analysis, development, and testing took 6 months from project start to full implementation. ● Established a key collaboration with a new exchange company, introducing an entirely new product to the bank and creating a foundation for increased revenue streams. Implemented support for financial instruments such as equities, bonds, and derivatives across all banking systems by utilizing T-SQL, Visual Basic, JSON, and XML. Delivered the solution within 3 months, meeting tight deadlines while ensuring quality. ● Being solely responsible for all integration aspects, from business analysis to development, testing, and communication with the stakeholders in both projects, ensured seamless transitions to the new systems in a single day with zero downtime.
Business System Analyst
04.2017 - 05.2018 |IT Estafeta
REST API, SOAP, FTP, T-SQL, C#
IT Estafeta delivers full-cycle software development services for financial trading platforms, offering expertise in hardware integration and system optimization. ● Led the redesign of a key module for the biggest Russian bank’s trading platform focused on banking guarantees and government contract accounting. Achieved a 3x-growth in trading platform usage, significantly increasing revenue and customer satisfaction by addressing performance bottlenecks. ● Managed a team of three developers, overseeing concept design, requirements gathering, and client communication to ensure alignment with business needs. ● Implemented three key integrations for client-server architecture: file exchange for client-signed documents, message broker data exchange via Microsoft Query, and counterparty information integration with Seldon. Utilized REST API, SOAP, and FTP. ● Rewrote the module’s backend using T-SQL and C#, creating 70 stored procedures, triggers, and functions with over 30K lines of optimized code to improve database performance threefold. Successfully developed frontend component with ASP.NET.
System Architect
09.2016 - 03.2017 |3G Banking Technologies
SQL, PostgreSQL, REST API, Kafka, UML, BPMN, SOAP, XML, Python, Java, C#, Visual Basic, Sybase, PL/SQL, SSIS, HTML, MQ, DB2, Jira, Confluence, MS PowerPoint, MS Visio, MS Excel, Git, Microservices, Use Cases, User Stories
3G Banking Technologies focuses on building efficient data warehouses, Big Data systems, and regulatory reporting using the best vendor and open-source solutions. ● Rebuilt a previously non-functional Kondor+TP accounting module in 2 weeks, replacing a year-long failed development effort, enabling accurate transaction and posting data integration with the ABS system. ● Automated manual integration processes between the middle office, ABS, and the accounting module, eliminating operational bottlenecks and supporting increased transaction volumes. ● Successfully developed and deployed 7 new financial instruments, including currency derivatives and market deposits, driving business growth and operational scalability.
Head of Analytics Group
04.2007 - 08.2016 |Promsvyazbank
Stocks, Bonds, Futures, Forex, T-SQL, XML, VB
Promsvyazbank is one of Russia's leading universal banks, offering a wide range of financial services to corporate and retail clients. ● Led 10+ major projects, including automating client onboarding for brokerage services, working with P&L and margin calculation, automating the bank's investment activities, and streamlining internal accounting processes (Instruments: Stocks, Bonds, Futures, Forex) ● Automated internal accounting and regulatory reporting, leading a team of 5 to deliver a system generating 15 reports, reducing manual workflows by 5 FTEs, and mitigating license risks. The solution streamlined daily transaction processing, report generation, and ABS integration using T-SQL. ● Automated taxable income calculations for trading, cutting manual workflows by 80% and generating 20 compliance reports across 10 instruments. Delivered in one year as the sole analyst with three developers, ensuring regulatory compliance and reducing risks through SQL-driven algorithms. ● Automated taxable income calculations and reporting for 15K trading clients, scaling from 3K. Replaced manual workflows with real-time tax compliance, delivered as the sole analyst leading three developers, and ensured scalability for rapid client growth. ● Led the implementation of a modern trading platform, enabling real-time data processing, margin info, and automated exchange integration. Supported business growth, scaling the client base from 300 to 15K in 4 years. Utilized T-SQL, XML, VB, and file-based integration.

Educational background

Mathematical Analysis (Doctor of Science)
Till 2001
Ufa State Aviation Technical University
Applied Mathematics
Till 1998
Bashkir State University, Faculty of Mathematics

Languages

RussianNativeEnglishUpper Intermediate