Aleksei Bobin, Developer in Yekaterinburg, Sverdlovsk Oblast, Russia
Aleksei is available for hire
Hire Aleksei

Aleksei Bobin

Verified Expert  in Engineering

Data Warehousing Developer

Yekaterinburg, Sverdlovsk Oblast, Russia

Toptal member since June 18, 2020

Expertise
Data WarehouseSQLOLAPSSIS
Bio

Aleksei is a senior business intelligence and data warehouse professional with more than nine years of experience. He's an expert in building ETL (extract-transform-load) processes based on large database systems and building data warehouse BI reports containing terabytes of data. Aleksei is also a great communicator who's worked in all types of environments.

Portfolio

Nyxale
IPC, SQL Server Reporting Services (SSRS), SSAS, Microsoft SQL Server
Eastwind
SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)...
DAKS
SQL Server Reporting Services (SSRS), Microsoft SQL Server

Experience

  • Microsoft SQL Server - 10 years
  • T-SQL (Transact-SQL) - 10 years
  • SQL Server Reporting Services (SSRS) - 5 years
  • Data Warehousing - 5 years
  • Data Warehouse Design - 5 years
  • TFS - 3 years
  • SQL Server Analysis Services (SSAS) - 3 years
  • OLAP - 3 years

Availability

Part-time

Preferred Environment

SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SSAS, Microsoft SQL Server

The most amazing...

...thing I've done was to build and design a large, scalable, flexible, and super-fast DWH reporting system for a regional telecom provider.

Work Experience

Senior BI Developer (Team Leader)

2014 - PRESENT
Nyxale
  • Worked as a tech team leader.
  • Designed and built DWH systems and data marts (MS SQL Server 2008/2012).
  • Worked with VLDB (>100 TB).
  • Designed and implemented ETL workflows by using the Informatica Power Center and SSIS.
  • Monitored and did performance analysis of entire system.
  • Led the team and coordination with other teams working on the same project.
Technologies: IPC, SQL Server Reporting Services (SSRS), SSAS, Microsoft SQL Server

Senior BI Developer (Tech Leader)

2009 - 2014
Eastwind
  • Built a data warehouse (MS SQL Server 2008/2012).
  • Designed cubes with star schema using SQL Server Analysis Services (SSAS).
  • Created a load and process data lifecycle.
  • Created SSRS reports which used OLAP and OLTP database as a source.
  • Implemented performance tuning SSAS.
Technologies: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SSAS, Microsoft SQL Server

Senior Database Developer

2006 - 2009
DAKS
  • Implemented a database design (SQL Server 2005).
  • Created stored procedures, functions, and triggers.
  • Did T-SQL query optimization.
  • Created SSRS reports.
Technologies: SQL Server Reporting Services (SSRS), Microsoft SQL Server

Experience

Eastwind Billing Data Warehouse

I built a data warehouse for Eastwind Billing system (a billing system for telecom providers) with OLAP database and printed reports. This solution made it possible to get fast ad hoc reports and to analyze very quickly a huge amount of data.

Data Warehouse Management System

I built a system which allows people create database, tables, indexes, and to control their life cycle. This solution supports horizontal scaling.

Fraud Management System

I built a solution which makes it possible to detect an anomaly on subscriber data and allows a telecom provider to minimize losses. This solution loads huge data into data marts and analyze them to find anomalies.

Education

2000 - 2006

Bachelor's Degree in Physics

Ural State University - Yekaterinburg, Russia

Certifications

AUGUST 2017 - PRESENT

MCSA: SQL Server 2012/2014

Microsoft

DECEMBER 2010 - PRESENT

MCTS: Microsoft SQL Server® 2005, Business Intelligence Development

Microsoft

SEPTEMBER 2008 - PRESENT

MCIP: Database Administrator on SQL Server®

Microsoft

AUGUST 2006 - PRESENT

MCTS: SQL Server® 2005

Microsoft

Skills

Tools

Perforce, TFS, SSAS, Informatica PowerCenter

Languages

T-SQL (Transact-SQL), SQL

Storage

Microsoft SQL Server, SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS)

Paradigms

OLAP

Other

Data Marts, Data Warehouse Design, Data Warehousing, IPC, Multidimensional Expressions (MDX)

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring