Position: Data Analyst
Category: Data Analyst
English level: upper
Years of experience: 2

Of the significant tasks, there was a complete reworking of the procedure for transferring data from one DB to another with different encodings. It was required to reduce the execution time as much as possible since this critically affected the operation of subsequent procedures and began to lead to failures. The operating time of the old version of the procedure has constantly increased along with the daily growing volume of data. After the rework, the execution time was reduced from a few hours to 10-30 minutes and remains stable from the end of 2018 to the present day.
Data analyst at the Bank
- writing queries to the database with further uploading the results to MS Excel;
- creation of SSIS packages for data upload;
- primary data processing in MS Excel and data uploading to MS SQL database using SSIS
packages;
- creation and modification of existing automatic reports in MS Excel with receiving data from MS SQL, which includes the creation of procedures, functions, tables in MS SQL;
- creation of semi-automatic reports in MS Excel with receiving data from different MS Excel files and/or DB;
- creation of macros (VBA) for data processing in MS Excel;
- using the Power Query add-in to process data more efficiently.
I don't want to deal with finance.