Yauhen Balyshkin Email & Phone Number

Technologies: Databricks, MySQL, Teradata, Spark- Validation of data processing processes- Analysis of the quality of data prepared for ETL and BI systems- Development of complex SQL queries to various databases to check the quality of data and the results of their processing- Development and design of tests for ETL processes, scripts for testing BI applications- Participation in the development of a framework for testing ETL processes- Documentation and support of… Show more Technologies: Databricks, MySQL, Teradata, Spark- Validation of data processing processes- Analysis of the quality of data prepared for ETL and BI systems- Development of complex SQL queries to various databases to check the quality of data and the results of their processing- Development and design of tests for ETL processes, scripts for testing BI applications- Participation in the development of a framework for testing ETL processes- Documentation and support of detected issues Show less

• Analysis of the company's business processes: steps and processes distinction, analysis of what kind of data is generated, at what stages and by which source systems (MSSQL);• Refinement and development of the data model: fixing the data model of sources, DWH and data marts; • Data mappings update;• Data marts prototyping;• Automation of data quality checks (using Grafana);• Documentation of DWH implementation (using Notion and drawio).

Cyprus

* Data collection (UN Comtrade, Eurostat, FAOSTAT, Prodcom, Reuters, Bloomberg, Investing.com, etc.)* Data preprocessing (cleansing, dealing with missing and incorrect values)* Quantitative data analysis* Financial data analysis* Info extraction and presentation (metrics, KPIs, reports, dashboards)* Business analysis of public companies worldwide* Competitors analysis* Qualitative analysis (SWOT, PESTEL, Porter Five Forces, VRIO, etc.)* Managing teams of 3-5… Show more * Data collection (UN Comtrade, Eurostat, FAOSTAT, Prodcom, Reuters, Bloomberg, Investing.com, etc.)* Data preprocessing (cleansing, dealing with missing and incorrect values)* Quantitative data analysis* Financial data analysis* Info extraction and presentation (metrics, KPIs, reports, dashboards)* Business analysis of public companies worldwide* Competitors analysis* Qualitative analysis (SWOT, PESTEL, Porter Five Forces, VRIO, etc.)* Managing teams of 3-5 people* Deadlines monitoring* Reports quality control* Reports development and improvement* Communication with clients* Communication with report publishers Show less

Minsk, Belarus

- DWH Basics (Start Schema, Dimension Tables, Facts Table)- ETL Basics- Oracle DB for DWH and ETL (DB Architecture, Data Access, Join Methods,Partitioning, PL/SQL)- Intermediate Project: created an Oracle DWH that sourced data from twoseparate sources. The DWH had four layers: staging area (external and sourceabstract tables), cleansing layer, 3NF layer and dimension layer (star schema).Implemented restartable ETL procedures that consistently loaded data fromone… Show more - DWH Basics (Start Schema, Dimension Tables, Facts Table)- ETL Basics- Oracle DB for DWH and ETL (DB Architecture, Data Access, Join Methods,Partitioning, PL/SQL)- Intermediate Project: created an Oracle DWH that sourced data from twoseparate sources. The DWH had four layers: staging area (external and sourceabstract tables), cleansing layer, 3NF layer and dimension layer (star schema).Implemented restartable ETL procedures that consistently loaded data fromone layer to other not producing duplicates.- PowerBI (created a report based on a training dataset, created a report basedon previously created Oracle DB)- AWS overview (S3, Athena, Glue, EC2, Redshift, DB Services)- Data Quality (Quality Assurance, SDLC, STLC, tests design, bugs reporting,DWBI testing, DWH testing, test results reporting)- Data Quality Automation (tests automation using Jenkins, JMeter andSelenium)At laboratory project stage I performed as both, reporter (participated in Tableaudashboards creation) and data quality engineer (data profiling, data mapping,checklists and testcases creation for manual and automation testing, Test Planand Test Strategy development, data and dashboards testing). Show less

Data Engineering

Master'S Degree, Economics