Andrei Filippov Email & Phone Number

St Petersburg, St Petersburg City, Russia

I worked in the "Analytics and Budget" team. The main task is to receive bank transactions, process and analytics on them, build a budget, loyalty programs.The team has 2 backend developers with me.- Designed, developed and reviewed the code, API, database tables and technical documentation;- Participated in the discussions of system design and solutions;- Suggested enhancements and modifications to improve the work quality;- Interacted with the client and their services;- Wrote component tests and e2e tests;- We launched our project from scratch and released mvp.Stack: Kotlin, Ktor, PostgreSQL, JOOQ, Gradle, Minio, Redis, Docker, Kubernetes, Swagger

St Petersburg, St Petersburg City, Russia

Project for the allocation of locomotives, trains, wagons for Railways:- Created new services, tables, queries, as well as optimized existing queries in database (Oracle);- Launched a project, that had been started by other companies, refactored the legacy code;- Wrote a big data transfer from CSV to the database using jdbc;- Suggested to improve existing process of bug reporting and tasks creation;- Wrote queries using MyBatis, along with scripts to migrate a project from ant to gradle or maven;- Optimized the SQL request using more suitable indexes.Stack: Java 7 (then 11), Kotlin, Spring Boot 2, MyBatis, Hibernate, PostgreSQL, Oracle, jdbc, Consul

St Petersburg, St Petersburg City, Russia

Projects:1. SPB Bank. An application for legal entities. 2. LUKOIL. An application for the LUKOIL gas station that allows you to pay for the refueling without leaving the car.- Built the database architecture, created tables and queries, optimized existing queries;- Came up with a solution for determining regions and writing geo queries to them;- Interacted with the client and their services;- Was responsible for the production server and promptly correct errors or performed urgent tasks from the client;- Changed the existing algorithm for sending push notifications;- Designed and added versioning together with the team leader;- Sped up some requests using caches;- Evaluated tasks and also I was mentor for one developer;- Optimized the SQL request using more suitable indexes;- Met tight deadlines with the team.Kotlin, Spring boot 2, Hibernate, Oracle, MS SQL, Spring Webflux, Redis, SOAP, Liquibase, Jackson, Firebase, Thymeleaf, Swagger

A startup project to create a shooter in a futuristic universe. Was closed.- Wrote code, unit and integration tests;- Moved data from MySQL to PostgreSQL;- Designed tables for clans in the game.Stack: Java 8, Spring, Mysql, PostgreSQL