Aliaksei Khadzinski

Aliaksei Khadzinski

Database Developer

Followers of Aliaksei Khadzinski363 followers
location of Aliaksei KhadzinskiVilniaus, Lithuania

Connect with Aliaksei Khadzinski to Send Message

Connect

Connect with Aliaksei Khadzinski to Send Message

Connect
  • Timeline

  • About me

    Database Developer at ScienceSoft

  • Education

    • Belarusian State University of Informatics and Radioelectronics

      2002 - 2006
      Bachelor's degree Computer Programming
  • Experience

    • MaxiProSoft

      Sept 2006 - Aug 2007
      Database Developer

      C++ programmer - supporting product adding features achieving customer needsOracle developer, administrator

    • ScienceSoft

      Oct 2007 - now
      Database Developer

      Latest projects:Project description: Migration on-prem ETL solution from SSIS to ADF. We needed to migrate more then 300 packages to ADF pipelineTechnologies/Tools: SSIS, Azure ADFv2, Azure DevOps, Azure CI/CD pipelines, Azure Synapse,PythonProject description: Database migration of several databases from MySQL RDBMS to Oracle RDBMSTechnologies/Tools: Oracle, SQLLDR, MySQL, Python (dataframes, multiprocessing)Process description: Taking metadata from MySQL database, create the same structure in Oracle database, migrate data, optimize target database.Responsibilities. Creating more or less universal Python script for migration all needed databases and starting scripts then customized to each database.Project description: SEO BI solution for optimizing keywords usages on the site.Technonlgies/Tools: SSIS, SSAS, SQL Server, Python. Process description: Batch processing. Ingesting data from several sources, processing, extracting data to DWH.Responsibilities: Redesign BI solution - recreate SSAS cube. Redesign ETL. Optimizing exiting measures, adding new.Project description: System that used for managing and analytic analysis of healthcare proceduresTechnologies/Tools: SQL Server, SSAS, SSRS, SSIS, KyubitProcess description: Taking data from OLTP system, ETL process with SSIS, creating OLAP cube with SSAS. Creating reports with SSRS and Kyubit.Responsibilities: ETL process design and implementation,analytical cube, creating reports with Kyubit, SSRSProject description: Management system for services/product shopsResponsibilities: Creating ETL process for different sourcesTechnologies/Tools: Python, Microsoft CRM, Microsoft SQL Server, SQL Server Reporting Services, SQL Server Analysis Services Show less

  • Licenses & Certifications

    • 467: Designing Business Intelligence Solutions with Microsoft SQL Server

      Microsoft
      Jun 2017
    • Program with PL/SQL

      Oracle
      May 2008
    • Oracle Database 11g: Advanced PL/SQL

      Oracle
      Jun 2010
    • Introduction to Oracle9i: SQL

      Oracle
      Apr 2008