Konstantins Kovalovs
Development
Riga, Latvia
Skills
Data Engineering
About
Konstantins Kovalovs's skills align with Database Specialists (Information and Communication Technology). Konstantins also has skills associated with System Developers and Analysts (Information and Communication Technology). Konstantins Kovalovs has 7 years of work experience, with 2 years of management experience, including a mid-level position.
View more
Work Experience
Data Engineer
28Stone Inc
June 2022 - Present
- Maintained the Bank EL Framework by adding a new extract type (APPEND) and updating existing logics (INCREMENTAL and FULL data loads). Created SQL procedures for daily Data Quality checks. Updated transformation and reconciliation SQL scripts for Dim and Fact tables according to the latest mapping documentation. Communicated with data business users and business analysts. Onboarded junior Data Engineers.
Business Intelligence Developer
Visma Enterprise
May 2020 - June 2022
- Led and developed various MicroStrategy BI projects from initial client meetings to solution presentations. Designed, developed, and maintained ETL processes for daily and monthly data loads using Pentaho Data Integration (PDI). Developed and maintained DWH using Oracle, PostgreSQL, and Microsoft SQL. Conducted MicroStrategy 11.2 data visualization training for clients and colleagues. Developed and maintained reports and dossiers in both MicroStrategy Developer and Web versions.
Finance Controller
TietoEVRY
May 2019 - April 2020
- IT project portfolio level ad-hoc Excel reporting. Riga, Latvia Monthly finance result report preparation and presentation to Finance Partner. May 2019 - Apr 2020 Data error corrections and communication with the accounting team.
External Reporting Specialist
Citadele bank
December 2018 - May 2019
- Gathering data from T24 (banking system) and DWH using SQL Developer- Oracle for financial regulator daily reports, bank's auditor and for internal data analysis purpose. Supporting management team in preparation of ad hoc data requests from the Board. Internal procedural updates for the External Reporting Department. Bringing up to date data tables linked to procedures in Confluence according to the latest updates.
Deposit Solutions term deposit account manager. Managing third party attracted
Citadele bank
May 2017 - November 2018
- Riga, Latvia Money Market Speci alist May 2017 - Nov 2018 Competitor analysis of saving products. Saving product pricing and special offer preparation. Coordinating the operation process on saving product interest rate change. Group Investment and Asset and Liability committee documentation. Deposit Solutions term deposit account manager. Managing third party attracted deposits through Open Banking platform.
Education
University of Latvia
MASTER OF SOCIAL SCIENCES IN ECONOMICS
University of Latvia
BACHELOR'S DEGREE IN FINANCIAL MANAGEMENT
American University in Bulgaria
September 2016 - January 2017
