Sergey S.

About Me

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.

Database

DevOps

Other

Work history

UpStack
UpStack
Senior DWH/ETL Developer
2019 - Present (6 years)
Remote
  • Creating and developing innovative software solutions for clients across a broad range of industries.

Infopulse Ukraine (Evry Ukraine)
Infopulse Ukraine (Evry Ukraine)
Senior DWH/ETL Developer
2013 - Present (12 years)
Kiev, Ukraine
  • 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.

Raben Ukraine
Raben Ukraine
IT Manager
2012 - 2013 (1 year)
Kiev, Ukraine
  • 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.

Freelance
Freelance
Independent IT Consultant
2011 - Present (14 years)
Kiev, Ukraine
  • Efficiently developed and implemented data warehouse/business intelligence systems on projects for clients.

  • Provide expertise for detailed technical analysis on solutions; to assure the availability and accuracy of data processed by ETL.

  • Regularly investigate data quality issues and implemented appropriate solutions promptly for redress.

Inkerman Winery
Inkerman Winery
IT Manager
2011 - 2012 (1 year)
Sevastopol, Ukraine
  • 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.

Lactalis-Ukraine
Lactalis-Ukraine
IT Manager
2005 - 2011 (6 years)
Kiev, Ukraine
  • 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.

Showcase

Applications Architect - Cloud Data Lake for Data Scientists Teams
Applications Architect - Cloud Data Lake for Data Scientists Teams
  • Managed data extraction, uploading, and preparation from diverse sources (SAP HANA, SQL, file store).

  • Implemented data models, Azure Data Factory pipelines, and data security for the project.

  • Resolved production issues, investigated new technologies, and developed POCs to improve data uploading efficiency by up to 5 times.

Application Architect - Cloud Data Repository
Application Architect - Cloud Data Repository
  • Developed solutions for data loading from on-premise to cloud, including access to data with column-level security via a custom API.

  • Designed and built data models, SSIS packages, and data security systems.

  • Created Proof of Concepts (PoCs) to evaluate new technologies and implemented a data security system for column-level security.

Lead DWH/ETL Developer - Customer Loyalty Analytics for Restaurant Network
Lead DWH/ETL Developer - Customer Loyalty Analytics for Restaurant Network
  • Developed data extraction solutions for restaurant ERP and delivery systems.

  • Implemented analytics with OLAP cubes on the Data Warehouse.

  • Automated event messaging to the market activities system via REST API, reducing data cleansing time by 10 minutes.

Second Architect, Lead DWH/ETL Developer - Compliance Scorecard Dashboard
Second Architect, Lead DWH/ETL Developer - Compliance Scorecard Dashboard
  • Extracted performance data from multiple systems and uploaded it to the Data Warehouse.

  • Developed a REST API for displaying employee KPIs on web dashboards.

  • Designed and implemented backend solutions including data models, REST API, and ETL processes to meet client requirements.

Education

Education
Master's Degree in Computer and Intellectual Systems and Networks
Odessa State Polytechnic University
1991 - 1996 (5 years)
Education
Microsoft Certified Professional
Microsoft
2000
Education
SAP Certified Application Associate - SAP HANA (2015 Edition)
SAP
2015
Education
R Programming
Coursera
2014
Education
Getting and Cleaning Data
Coursera
2014
Education
Exploratory Data Analysis
Coursera
2014
Education
Introduction to Big Data
Coursera
2016
Education
Hadoop Platform and Application Framework
Coursera
2016
Education
Introduction to Big Data Analytics
Coursera
2016
Education
Machine Learning with Big Data (September 2015 Version)
Coursera
2016