Download PDF
  • USA-1820 Ave V Apt 4D Brooklyn NY 11229, BELARUS - Minsk. Korvata st. 62-52

Alexander Ukader

BI Developer

Summary

To work as a Business Intelligence Developer with a leading software company where I can design, test, and deploy data warehouse as well as provide solutions to data analytic issues.

Work History

May 2013June 2015

BI developer

Interconest
  • DWH developer (Trainee)

The training includes a number of tasks on BI topics. The goal of the training is preparation for work on the project.

Responsibilities:

  • Documented user requirements, translated requirements into system solutions and develop implementation plan and schedule.
  • Maintained effective communication with non-technical client personal and handled the change requests.
  • Created SSIS mappings using the designer, respective workflows and worklets using the Workflow manager to extract, transform and load source data from various heterogeneous sources to the associated Facts and Dimensions
  • Created cubes, dimensions, hierarchies, mappings using Microsoft BI tools
  • Stored reformatted data form relational, flat file, XML files using SSIS (ETL)
  • Consolidated variant feeds with different formats to fields with a specific delimiter using shell

 

Tools and environment: Sql Server Management Studio

Languages and Technologies: T-SQL, SSIS, SSRS, SSAS, C#

Sep 2015Dec 2015

Trainee

Issoft
  • Training: BI (April 2014 – May 2014)

The training includes a number of tasks on BI topics. The goal of the training is preparation for work on the project.

Tools and environment: Sql Server Management Studio

Languages and Technologies: T-SQL, SSIS, SSRS, SSAS, C#

Dec 2015June 2016

BI Developer

Issoft
  • Evolution1 

Evolution1 is a company that simplifies the business of healthcare. Evolution1 does that through innovative healthcare software and payment solutions that administer consumer directed accounts. Evolution1 offers a multi-tenant SaaS system used to manage consumer directed health savings accounts in the U.S. 

Responsibilities:

  • Involved in Designing, Developing and Testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS
  • Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS)
  • Responsible for coding SSIS processes to import data into the Data Warehouse from Excel spreadsheets, Flat Files and OLEDB Sources
  • Worked on various tasks and transformations like Execute Sql Task, Execute Package Task and conditional split, Script Component, Merge and Lookup while loading the data into Destination
  • Have used BCP, BULK INSERT to transfer data from and to SQL server database
  • Developed SSIS solution for developing a fully-fledged data warehouse solution
  • Develop and implement best practices in creating BI solutions.

Tools and environment: SQL Server 2012, SSIS 2012, SSRS 2012,.NET Framework, C#, ASP.NET,CSS,T-SQL, VisualStudio.NET IDE, XML, MS Excel, Visual Studio 2013.

Aug 2016Oct 2016

BI/Report Developer

IsSoft
  • MyAlerts (TrackIf) (December 2015 – Till Date)

TrackIf Shopping Solutions helps online sites to capture the future purchase intent of their online customers.

Responsibilities:

  • Creating Ad Hoc, dashboards and Parameterized various Reports using JasperSoft Server and JasperSoft Developer Studio
  • Improving performance and customizing JasperServer elements
  • Creating SQL queries for processing data and creating reports
  • Embedding Jaspersoft reports using visualize.js
  • Deploying JasperSoft reports on Amazon Web Services
  • Customization Ad Hoc concept
  • Develop and implement best practices in creating Jasper Soft reports
  • Control of the environment
  • Fixing bugs

Tools and environment: JasperSoft Studio, JasperSoft Server, Ireport, Amazon Web Services (AWS), MySql, Java IDE

 

Oct 2016Present

BI Developer

Issoft
  • Lifetouch

Lifetouch is a photography company that captures precious memories for millions of individuals, families, and organizations. For more than 70 years, the company has been providing quality childhood, student and family photographs, along with other valuable memory keepsakes. Lifetouch utilizes many consultants for development efforts.

Responsibilities:

  • Converting Pentaho ETL jobs to SSIS packages.
  • Creating Ad Hoc and Parameterized various Reports using SQL server 2012 Reporting Services
  • Responsible for coding SSIS processes to import data into the Data Warehouse from Excel spreadsheets, Flat Files and OLEDB Sources
  • Added Script and lookup components using C#

Tools and environment: SQL Server 2012, SSIS 2012,VisualStudio.NET IDE, XML, MS Excel, Visual Studio 2013, Pentaho ETL

Languages and Technologies: T-SQL, SSIS, C#

Skills

Hodoop(Cloudera), Hive, MapReduce, Oozie, Spark, Kafka
OC Windows, Linux
SSMS, Visual Studio, TFS, ErWin, Rational Rose, Enterprise Architect, dB Forge
SQL Server, Oracle, MySql
T-SQL, SQL, PL/SQL
Microstrategy, Pentaho, JasperSoft, Power BI, Tableau
SSRS,SSIS,SSAS
.NET, C#, Java, JavaScript
English language, Russian language

English - Intermidiate, Russian - Native

Education

Sep 2010Jun 2015

Bachelor’s degree 

Belarusian state university of informatics and radioelectronics

Electronics Engineer

Sep 2013Jun 2015

Bachelor’s degree 

Belarusian state university of informatics and radioelectronics

Software Engineer

Reference

On request.

Status

Green card holder