Aleksei Ovchinnikov - Data Engineer, Exadel

Keep in touch with meI'm using Intch to connect with new people. Use this link to open chat with me via Intch app

Network Power100+ people

Roles

✔️100%

🏦100%

Finance

Geos

🇬🇪100%

Georgia

Work Background

ExadelMiddle Software Engineer

May. 2022Tbilisi, Georgia · RemoteSoftware development company, 3000+ Projects successfully delivered, 2800+ employees. Duties: 1) Collaborating with other developers, architects, and testers to ensure the quality and usability of the solution. 2) Troubleshooting and resolving issues and bugs. 3) Improve the existing ETL based on SQL server and Airflow and develop new. 4) Work across different projects and transfer best practices from one to another. Key achievements: 1) Created Power BI dashboards with performance-related reports in order to show statistics about data-related incidents so we could focus on the most critical issues. 2) Built a functionality to check the client's data quality and notify the client about data-related issues. That solution helped to reduce data-related problems, helped our clients save extra money, and got new functionality faster. 3) Covered all SQL Servers by different metrics using DataDog - encryption status, average time to upload the data, virtual machine monitoring, and more. 4) Lead communications with various clients in order to resolve sustaining issues faster.

SberbankMiddle Data Engineer

Jan. 2021 - Mar. 2022Moscow, Russia · On-siteThe largest Russian bank, top 30 European banks, 100+ million clients, 280 000+ employees. Duties: 1) Incorporate core data management competencies including data governance, data security and data quality. 2) Gathering large, complex data sets that meet business requirements. 3) Developing data pipelines and other data products using Hadoop and Spark. Key achievements: 1) Developed and implemented a mechanism for client unification among various banking systems (end-to-end key). That helped the bank save money and cut off rudiment CRM systems. 2) Developed a pipeline for processing information on various segments' clients and integrated it with other banking systems. 3) Made the release process to upload new functionality easier so that we could make releases more often.

RosbankJuniour Data Engineer

Nov. 2019 - Dec. 2020Moscow, Russia · HybridRosbank ex. Société Générale member. Top 10 Russian banks, 5 million clients, 12 000 employees. Duties: 1) Design and develop ETL processes to gather essential data from various banks' systems. 2) Process data from various sources, standardizing it to facilitate automation tasks and ensure data consistency. 3) Conduct performance tuning and optimization activities to enhance query performance and overall system efficiency. 4) Maintenance the existing Power BI reports and communicate with various stakeholders to add new features & dashboards. Key achievements: 1) Designed and implemented pipelines to process structured data using SAS platforms (for ETL) and SQL. 2) Worked with business analysts to create interactive Power BI Dashboards that helped discover data insights. 3) Created a corporate Power BI course to help junior data engineers how to visualize data so that we can create more dashboards for a limited time. 4) Automated about 80% of manual reports, reducing the time-to-market of our business analysts and letting them spend more time on business problems. 5) Performed ongoing monitoring of data pipelines and worked with stakeholders to troubleshoot and performance tune.

SberbankIntern Analyst

Feb. 2019 - May. 2019Россия, Екатеринбург · On-siteThe largest Russian bank, top 30 European banks, 100+ million clients, 280 000+ employees. Duties: 1) Perform data cleaning and data wrangling for analysis. 2) Extract data from data platforms (databases and different inner company sources). 3) Analyzing bank's data to identify patterns or opportunities for improvement. Key achievements: 1) Created a few data pipelines using PL/SQL that helped our data analysts to use the data in their weekly reports. 2) Created a regexp educational course for colleagues to easily use and reduce the time for creating new functionality.