I am a versatile DWH/ETL Developer with 10+ years of technical expertise in data engineering; a certified SAP and Microsoft professional specialist well-versed in system and network administration and cloud data solutions. I am very hands-on in approach; using regular client engagements to deliver excellent design solutions, data analysis and troubleshooting on projects for clients.
Regularly provide technical expertise for the design and development of different DWH and ETL solutions on web, mobile and cloud projects.
Worked on the redesign of a new security system (row-based security); significantly improving solution performance from 5 minutes to a few seconds for data output.
Successfully implemented technology improvements to Infopulse’s Enterprise Data Warehouse environment.
Managed the deployment, monitoring, maintenance, development, upgrade, and support of all IT systems for Raben.
Efficiently oversaw the development and implementation of innovative IT policies and best practices for the provision of production support on IT infrastructure in 8 regions.
Prepared and managed the IT department's annual budget for CAPEX and OPEX and IT implemented strategies to enhance costs control.
Successfully designed, developed, and implemented IT systems, procedures, and policies for Inkerman.
Efficiently implemented new IT infrastructure solutions using Microsoft systems for virtualization, mail, antivirus, data protect and infrastructure management.
Managed Inkerman's corporate licensing agreement with Microsoft and oversaw the upgrade of servers and network equipment.
Developed IT services for business support within the company.
Successfully managed various IT-related projects for clients; implementing IT services and changes in IT infrastructure, and provided IT support for regional/business divisions.
Led tasks on the optimization and reduction of IT-related costs on projects for the client.
Oversaw the extraction, uploading and preparation of various data sets from various sources (SAP HANA, SQL, file store) into DWH solutions. Managed the conversion of CSV -> Parquet with data partitioning and automated data validation and reconciliation processes on the project. Implemented data models, Azure Data Factory pipelines, and data security. Resolved production issues; investigating and troubleshooting and developed POCs to evaluate new technologies and approaches. Defined development approach for the project, decreased data uploading time by up to 5 times (1 hr. vs. 5 hr.) and continuously supervise the addition of new data sources and Data Scientists teams to the platform. There are between 50 and 100 active users currently.
Provided solutions and built tools for the loading of data from the on-premise repository to the cloud, and provided access to data on the cloud with column level security via a custom-built API. Worked on solution design and development for data models, SSIS packages, data security. Developed PoCs to evaluate new technologies and approaches and implemented a data security system to manage column security for each customer without creating a separate database schema.
Engineered solutions for the extraction of data from the restaurant's ERP and delivery systems for cleansing and upload to the Data Warehouse. Provided analytics with OLAP cubes above the DWH. Pushed various event messages (welcome, birthday greetings, bonus changing etc.) to the market activities system on the DWH via REST API. Decreased the decrease customer’s data cleansing time from ~1 hr. to 10 min. The solution has 20 active users.
Worked on the extraction of performance data from various performance tracking systems for upload to the DWH and created a REST API for display on web dashboards with Employee’s KPI. Led all solution design and development tasks in the backend part for data models, REST API, and ETL processes. Implemented data processing and data model tasks to align with the performance requirements of the client. The dashboard has between 500 - 1000 active users.
Education
Master's Degree in Computer and Intellectual Systems and Networks
Odessa State Polytechnic University
1991 - 1996 (5 years)
Microsoft Certified Professional
Microsoft
2000
SAP Certified Application Associate - SAP HANA (2015 Edition)
SAP
2015
R Programming
Coursera
2014
Getting and Cleaning Data
Coursera
2014
Exploratory Data Analysis
Coursera
2014
Introduction to Big Data
Coursera
2016
Hadoop Platform and Application Framework
Coursera
2016
Introduction to Big Data Analytics
Coursera
2016
Machine Learning with Big Data (September 2015 Version)
