← В ленту
Senior
Регистрация: 06.04.2022

Алексей Карпов

Специализация: SQL developer / analyst / team lead
sql developer and analyst with project management experience. More than 10 years of experience. Working with tables with tens of millions of records. Design and optimization of queries. Creation of reports. Interface design. Extensive experience as a full-stack developer. Working with legacy projects and designing new ones. Data integration between different systems. Attention to details. Maintenance of technical documentation. Agile knowledge, soft skills. I want to work, study and enjoy life.
sql developer and analyst with project management experience. More than 10 years of experience. Working with tables with tens of millions of records. Design and optimization of queries. Creation of reports. Interface design. Extensive experience as a full-stack developer. Working with legacy projects and designing new ones. Data integration between different systems. Attention to details. Maintenance of technical documentation. Agile knowledge, soft skills. I want to work, study and enjoy life.

Портфолио

Major Auto: LEADs system

Designed and developed a corporate task constructor for the MAJOR automotive holding. Both the server part on SQL, and the interface on the Windows desktop, as well as android and a copy on iOS. Each employee from any department could go to either the desktop application or the mobile application in the morning and see their tasks for the day. These tasks could have an unlimited number of statuses, responsible for each status, any number of different parameters, attachments. Could be created manually or automatically. And administration and configuration did not require the participation of developers. And also allowed to build any analytical reports on different types of tasks of this system. Through this system, employees were hired or fired, vacations were agreed, goods were sold, services were ordered, notifications were made about new documents, and much more. The system has become one of the most popular in the company.

OZON: scheduling procurement system

Developed a system for the purchase of goods according to the schedule for the Ozone online store. Every day, employees of the purchasing department through this functionality determined how much and what product should be purchased, so that when this product arrives in a week, the warehouse would not be overstocked. The entered data was integrated with a department of mathematicians, who built sales forecasts for the weeks ahead through a neural network. All this was accompanied by dynamically changing reports for every day or hour.

Sber: marketing promotions

There was a lot of work in this company related to system optimization, process acceleration and other tasks that cannot be taken out of context. But as a separate project, I remember working on marketing promotions. Like the "Cashback for Units" promotion, which I technically designed and developed entirely based on business requirements. And through my system, a budget of 3 million dollars was distributed among the company's clients. Naturally, with all the necessary analytics and reports.

Скиллы

T-SQL
C#
Android
Java
SSRS
SSIS
Delphi
Analytics
Soft skills

Опыт работы

Senior Database Development Engineer
02.2019 - 03.2022 |Sberbank Asset Management
MS SQL Server, SSRS, SSIS, T-SQL, Git, C#, SSDT
• Database design and development and applied performance tuning optimization best practices. • Worked on DWH with multiple storefronts for all company systems. Was a technical team lead for a team of 4 developers and 3 analysts. • And then I also worked as a lead developer in another team on one of the company's business products for the sale of mutual funds. Where, in addition to development, I coordinated front-end developers, back-end developers and web service developers. • Implemented a marketing campaign "Cashback for purchase of mutual funds", during which my mechanisms distributed a budget of about $ 2.8 million among clients. Including further analytics and reporting. • Significantly improved and maintained the SSIS system from more than 2000 etl packages, each of which poured data between dozens of company databases. • Temporary table, Change Data Capture were used. • Developed reports and configured the SSRS Report Server. • Developed the company's internal website on C#. • Created a full range of processes from data loading to data marts. • Provided transformation, cleaning and validation of data for further use. • Maintained and developed the internal logical processes of the brokerage back office. • Managed the development of reports for SSAS. • Release management. • Was a Scrum Master for two teams. Completed a Scrum Master course. • Gathered requirements from businesses and other clients. Set tasks for colleagues. • 2 years of work completely remotely.
Database Development Engineer
04.2018 - 02.2019 |Ozon.ru
MS SQL Server, SSRS, T-SQL, Git, Delphi
• Designed and developed databases and applied performance tuning optimization best practices. • Developed a system for purchasing goods for the entire company on schedule. Together with a department of mathematicians who calculated product sales forecasts using machine learning methods. • Developed and maintained the company's procurement system. • Designed and developed a back-office application for the purchasing system. • Displayed dynamically changing graphs about the company's performance in Grafana. • Processing the message queue from Kafka. And setting tasks for the web service developer on this topic. • Developed and integrated system of version control Git. • Release management. • Scrum Master. • Gathered requirements from businesses and other clients. Set tasks for colleagues.
Database Development Engineer
10.2017 - 04.2018 |FINAM
MS SQL Server 2016, Delphi, Git, SSRS
• Designed and developed back-office application for brokerage system. • Developed databases. • Working with systems with multiple triggers. • Identify and communicate technical problems, processes and solutions. • Developed reports and configured the SSRS Report Server. • Loading and processing data from third-party sources.
Database Development Engineer and Architect
09.2012 - 10.2017 |MAJOR
MS SQL Server 2016, T-SQL, SSRS, Microsoft Team Foundation Server, Android, Delphi, Fast Report, Dev Express
• Database design and development. • Designed and developed back-office application. • Optimized performance of stored procedures, creating indexes. • Developed reports and configured the SSRS Report Server. And reports on a fast report. • Developed and maintained the LEAD system - a customizable flexible task constructor for company employees, in which you could specify the type, a list of parameters, attach files, set up a system of statuses and responsible for each status, and much more. Became the most demanded functionality in the company. • Сreated Android mobile application from scratch, which duplicated part of the functionality of the company's back-office application, including my LEADS. • Received one more android developer and one outsource iOS developer for porting the application to iPhone. I gave them tasks. • Release management. • Gathered requirements from businesses and other clients. Set tasks for colleagues. • Writing documentation. Implementation of clean code rules in a team of 22 developers.

Образование

Mechanical Engineering Technologies, Engineer for metal-cutting machine tools and automated machine tools
2007 - 2013
Moscow State Technical University. N.E. Bauman

Языки

АнглийскийСредний