ALEXANDER UKADER

Brooklyn, NY ***** • 656-***-**** • ad4ibu@r.postjobfree.com

Professional Summary

Proven BI Data Engineer with 6 years of experience in mining, interpreting and presenting large datasets to improve spending efficiency across organizations. Implemented a few data analysis solutions. Worked with a few technology stacks (MS BI Stack, Oracle stack, IBM stack) .Adept in collaborating with cross-functional teams and delivering projects on-time and on-budget.

Skills

Languages: T-SQL, PL/SQL, C#, HTML, XML, PowerShell, Python, C++, Angular

Backup Software: SQLBackup, Red Gate, SqlSafe

Reporting Tools: SSRS, Crystal Reports, Tableau, Power BI, Cognos, Jasper Reports

Operating System: Windows 7 / 8 / 10, Linux

RDBMS/Tools: SQL Server 2005 / 2008 / 2012 / 2014 / 2017 / 2019, Oracle 11gR2, MySQL, MariaDB, Azure

ETL Tools: SSIS, BI (BIDS/SSDT), Pentaho, Informatica, Xplenty

DB Query Tools: MS SQL Server Query Analyzer, SQL Profiler, SSMS, Enterprise Manager, Toad

Work History

STRETTO December 2021 to January 2024

BI Data Engineer

Created Python OCR application. Increased company income by 20%

Developed DWH from scratch using MS Stack (SSIS, SSRS, SSAS)

Analyzed large sets of data, resulting in a 10% increase in efficiency and productivity.

Developed a lot of custom dashboards and reports using Tableau, Power BI (Developed custom Jira dashboard for tracking daily activities), SSRS. Migrated existing Tableau reports to SSRS.

Provided support to senior data analysts, resulting in a positive impact on the company's overall performance.

Created a lot of custom dashboards in Power BI

Intech21 October 2020 to November 2021

BI Developer/Analyst

Develop OLTP database from scratch using the SSIS, SSRS

Created a new custom system for generating automatic reports based on calibration results.

Created and support .NET solution for calibration electronics meters.

Created SSIS solution for load data into database daily and generate reports.

Optimized the performance of Queries and Store Procedures.

Database Migration

Helped stored procedures optimally perform by investigating missing indexes and creating them where appropriate.

Created SQL jobs to for backups, index rebuild/reorg, update stats, and database consistency checks.

Answered access requests from users by creating logins granting the required permissions.

Ellington Management Group March 2021 to September 2021

BI Data Engineer Consultant

Resolving issues with deadlocks

Created custom SSIS components.

Resolving performance issue and modify existing code.

Created SSIS solution for loading data into database daily.

Optimized the performance of Queries and Store Procedures.

Specific - Group December 2018 to August 2021

BI Developer/Engineer

Created a process to run SSIS packages, cubes and reports daily to provide up-to-date data to the customers using SSIS, SSAS, JasperReports, Python, PowerShell

Modified source code to resolve issues with existing Jasper reports. Created custom functions in source code to change the data loading graph and increase reports performance.

Modified more than 300 existing SSIS packages. Moved all SSIS packages logic on SQL Server side. Increased ETL performance by ~200%

Create complex reports and dashboards using JasperSoft to provide data to our customers daily. Modified source code to resolve issues with existing Jasper reports. Created custom functions in source code to change data loading road and increase reports performance.

Created SSAS custom framework that allows to manage SSAS cubes (~100 cubes).

EDUCATION AND CERTIFICATIONS

Belarusian State University of Informatics and Radioelectronics (2010-2015)

Bachelor's degree, Electrical and Electronics Engineering

Contact this candidate