Igor Tymchuk Email & Phone Number

Ukraine

Leading 50+ active projects with a team of 300 tech specialists. Leading N-iX Data and Analytics initiatives.

Lviv, Ukraine

Lviv Region, Ukraine

BI/BigData/Data Science Team Lead at N-IXI'm Team lead of 3 sub teams (Big Data, Data Science and BI) of 12 guys in total.Developing/Supporting AWS BigData soluton AWS Lambda AWS Kinesis AWS EMR Spark SQL HiveData Science R PythonBI Tableau

Senior BI Developer/Tech Lead Create prototypes, choose technologies for implementation of the new features• Worked on design of BI solution. • Developed BI solution using AWS Redshift.• Developed ETL process for extracting and transformed data using SSIS/Azure Data Factory.• Analyzed and created tasks for other BI developers. • Created Tableau reports and dashboards.• Created and supported DataWarehouse solution based on Amazon Redshift.• Created and changed the reports based on Microsoft Reporting Services.• Training junior developer staff.• Created Data Science prototype (using R, Azure ML)• Improved performance issues on overall BI solution.• SSAS Cube development/deploying.• Pilot DW project using Azure technologies (Blob storage, Data Factory, Azure SQL DW)• Optimized performance of various long-running queries and stored procedures• Design Dashboards• Created pilot DataScience solutions and supporting existed ones.

Lviv

1st project: Software DeveloperWorked for global provider of innovative financial software solutions, a permanent partner of ELEKS’. • Developed the database-side of the solutions using the Oracle and MS SQL platforms.• Developed SSAS Cubes, Aggregation, KPIs, Measures, as well as Deploying and Processing SSAS objects.• Developed Oracle and MS SQL stored procedures and scripts.• Extracted and transformed data using DTS in SQL Server 2000, SSIS in SQL Server 2005, SQL Server Import Export, Bulk Insert, and BCP.• Created and changed the reports based on Microsoft Reporting Services.• Investigated and fixed performance issues.• Optimized the execution of different queries.• Wrote PERL, VBS, and VBA scripts.• Experience in working with in memory VoltDB app (Wrote stored procedures on Java for VoltDB)• Experience in working/administrating Linux (CentOS) as well as Windows Server environments.• Experience in Installation, Configuration, Maintenance and Administration Oracle (on Linux and Windows environments) and SQL Server (on Windows) environment.2nd project:Software Developer One of ELEKS’ key long-term partners, a US-based provider of enterprise solutions for wholesale and retail industries, • Was responsible for all the database-related design and development (MS SQL 2008), including support and maintenance.• Responsible for migrations from MS SQL Server 2000 to MS SQL Server 2005/2008.• Created various database objects in C#, MS Visual Studio and ASP.NET and deployed them to the MS SQL Server 2005/2008. • Optimized performance of various long-running queries and stored procedures using SQL Profiler and the database tuning wizard.• Changed the logic of stored procedures to optimize their speed.• Improved queries performance.

Lviv

6/2011 – 4/2012 Software DeveloperThe customer, COINS Ltd., a leader in providing advanced software solutions for the construction industry, needed an ERP solution based on its proprietary Web-based COINS Open Architecture (OA) framework.• Designed and developed the user interface based on the COINS OA platform and using JavaScript.• Maintained the ERP system.• Worked with UNIX servers.• Was partially involved in business analysis.• Created the requirements, investigated and estimated development efforts based on the communication with the customer.4/2011 – 6/2011 Software EngineerA global provider of enterprise software for all kinds of manufacturers all over the world including automotive, consumer goods, hi-tech, and food and beverage, QAD Inc., wanted to design and develop additional functionality for their state-of-the-art ERP system to increase the effectiveness and competiveness of their product. • Developed custom code for the Lear Spain department of QAD. • Worked with Progress 4GL/ Open Edge database. • Created GUI for my task using Open Edge UI module and .NET custom framework.• Worked with UNIX servers.

During this period, I was working at a company specializing in engineering, installing, and maintaining all sorts of security and video surveillance systems. First, I was involved in the IPTV project where I was configuring Cisco Catalyst 2960 and 3750 switches and all the IPTV system with multicasting. Later, the range of my responsibilities was extended to designing security and fire alarm systems, CCTV and access control systems using AutoCAD and MS Visio.

Master, Data Communication Networks

Education record

Software Development

Bachelor, Telecommunications Major