Aleksei Pisarov
Angestellt, Head of Data Engineering, B9
Moskau, Russische Föderation
Über mich
Hi, I'm Aleks! Nowadays, the most valuable thing a company has is its data. Companies need systems for storing and quickly accessing data, I can help with that. I have 10 years experience in administration of databases, developing corporate data warehouses and business intelligence systems, I like working with data, organizing it and looking for meaning in it.
Werdegang
Berufserfahrung von Aleksei Pisarov
Bis heute 2 Jahre und 10 Monate, seit Aug. 2021
Head of Data Engineering
B9
Bis heute 3 Jahre und 9 Monate, seit Sep. 2020
ETL Developer
MVideo
I develop and maintain corporate DWH and ETL processes. Volume of DWH is 60 TB. List of sources: PostgreSQL, Google BQ, Hana, etc. In my work I use Greenplum, SAP DS, Python.
2 Jahre und 1 Monat, Aug. 2018 - Aug. 2020
BI \ DWH Team Lead
Cashwagon
Created a corporate DWH and tabular model from scratch. Configured data cleaning and integrity checks, as well as ETL processes. The volume of DWH is 3 terabytes and fastly grow, the volume of the tabular model is 10 gigabytes, the largest table in tabular model has 600 million rows, all systems were stable and have worked fastly. In my work I used SSIS, SSAS (Tabular), MS SQL, T-SQL, PowerBI, Python, Jira, Confluence. For DWH we've used the Inmon approach.
4 Jahre und 1 Monat, Juli 2014 - Juli 2018
Database Administrator
Federal Tax Service
I put the maintenance plans in order (there was no integrity check, work with indexes, statistics, etc.), changed the server and database settings to optimal ones, eliminated deadlocks in the system. Optimized stored procedures and many Adhoc queries, now they are executed several times faster. Created a normal recovery plan, gave value to RTO and RPO and Baseline for counters, etc. In my work I used MS SQL, T-SQL, SSIS, SSRS and Symantec NetBackup 7.5 (configuring and administering)
2 Jahre und 1 Monat, Juli 2012 - Juli 2014
Database Administrator
Federal bailiff service
Ausbildung von Aleksei Pisarov
2 Jahre und 11 Monate, Aug. 2009 - Juni 2012
Business process automation
Bauman Moscow State Technical University (Kemerovo Branch)
Sprachen
Englisch
Gut
Russisch
Muttersprache