Danila Gerasimenko

Experience

• 

  Corporate University of Sberbank (SberUniversity)

  Jun 2023 - Nov 2023

  Data Engineer [course]

  - Developed a relational database and created ER diagram- Implemented file archiving using gzip and tar, compressing files with maximum compression. - Ensured appropriate file access permissions, allowing execution for all, modification by the owner and group, and restricted read access for other users.- Developed Bash scripts for process monitoring, capturing running processes of user and describing files in a specific directory owned by other users.- Extracted relevant information and stored results in both Excel and database formats.- Designed and populated table using SCD2 version, wrote an SQL script to calculate salary payments for employees, considering historical changes.- Configured cron jobs for specific scripts to run daily, hourly, and at custom intervals, ensuring automated and timely execution of tasks.Final project - ETL process for banking dataIt includes scripts for extracting data from source files, transforming and loading it into staging and dimensional tables in a PostgreSQL database and performing fraud detection analysis.link - https://github.com/yuukiqt/fraud-etl-bank Show less

• 

  NTU Sirius

  Mar 2024 - Apr 2024

  Digital methods in energy [DPO]

  Project: Accelerating automated adaptation of hydrodynamic modelsAs part of the "Digital methods in energy" program at NTU Sirius, I led a team of four in a project focused on optimizing hydrodynamic model calculations. My role included parallelizing computations, managing network infrastructure.Achievements:- Reduced the computation time by about 5x times.- Improving the accuracy of the model, which improves the accuracy of reservoir flow rate prediction by accelerating the convergence of the non-convection parameters.- Created a tool for automated parameter adaptation using tNavigator, streamlining the modeling process. Show less

• 

  Ministry of Digital Development

  Jun 2024 - Jul 2024

  System Analyst