Andrei Sergeev Email & Phone Number

Moscow, Ru

Moscow, Russia

Prevention losses at pick-up/drop-off points.

Moscow, Moscow City, Russia

Dec 2023 - Feb 2024 I am supervising a project to recognize defective hatches using computer vision. I lead a team of 4 people.---Dec 2023 - Feb 2024Supervised 108 schoolchildren to conduct projects as part of the scientific conference "Engineers of the Future"----Jun 2022 - Dec 2023- Gathering requirements and writing technical documentation;- Development of the information resource MTUCI.United_Deanery. Service to simplify the sending of documents by students to the dean's office;- Automatic deployment of Docker + Gitlab imageTechnology stack.Backend: Python, FastAPI, MongoDB, Docker, Gitlab, RestApi

Moscow, Russia

VK Maps (Maps and Geoservices for Business)- Launching the "Traffic Congestion" service (calculating traffic congestion scores in 22 cities in Russia). - Tuning the congestion score calculation model.- Automation and improvement of quality tests for both forward and reverse geocoding (+1.3% across Russia).- Automation and enhancement of data completeness tests based on the Federal Information Address System (FIAS) (+0.9%).- Updating external and internal documentation. Migrating documentation to a new platform.- Migrating all manual scripts to Airflow.- Developed 6 dashboards (5 in Redash, 1 in Grafana).- Preparing key metrics for monthly meetings.- Developing a methodology for evaluating the quality of POI search.- Creating a Clickhouse data warehouse based on a Kafka topic.

Moscow, Russia

Preventing Last Mile losses (pickup points)- Updating Vertica, ClickHouse data marts- Generation of business requirements and writing project documentation on Confluence - Report development (from data uploading from various sources to visualization in Superset)- Raw data collection and processing- Finding non-trivial solutions to problems- Working on improving the antifraud system- Participation in incidents and collection of operational analytics- Developed a process of blocking funds in case of non-systematic returns at delivery points- Initiated adding new features to the Anti-Fraud system- Developed a report in Superset on claims handling to track KPIs of employees- Setting up analytics tools for the LastMile team (Hadoop, Jupiter, PySpark, Kafka, ldap, etc.)- Mentoring of an intern

Moscow, Moscow City, Russia

Direction: loss prevention in courier delivery last mile.Technology stack:Vertica, Python, SQL, Hadoop, AirFlowAutomation script in Python. Working with Vertica, MSSQL, Hadoop, Airflow.- Setting up Pipline processes using Gltlab CI/CD.- Writing documentation and instructions for a quick start.- Publishing modules in JFrog.- Correction and refinement of existing scripts and porting to Airflow.- Developed a script for linking responsible persons to regional warehouses. OneDrive API -> Python -> Confluence API -> Airflow

Moscow, Moscow City, Russia

- Collection and validation of business requirements for building dashboards and reports on Letters of Credit and Escrow products;- Working with large data arrays (analysis, structuring, processing)- Getting data for dashboards from Hive, Excel and csv files;- Participation in the development of analytical materials based on the results of the analysis of large data arrays;- Data preparation in SQL, Python, PySpark, Hadoop;- Suggestion and defense of own hypotheses before the functional manager;- Developed 4 dashboards that are sent weekly to Sberbank's territorial banks;- Normalized and clustered the FTS upload (import/export of goods to Russia) by company name in order to find similar companies;- Carried out an analysis of the penetration of letters of credit into real estate by type of real estate;

Moscow City, Russia

Analysis of accounting entries to identify transactions that are uncharacteristic for business and signs of dishonest actions on the part of the management of organizations.ACL, Excel

Seattle, Washington, United States

My tasks included checking students' homework and helping to conduct face-to-face lessons.

Bachelor'S Degree, Computer Science

Associate'S Degree, Computer Science