Highlights:

Skills:Teradata, Oracle, MS SQL, MySQL, SQLite, VBA, Python, Delphi, JavaScript

Prototypes developer 01/2017 - current
Magnit, Krasnodar, Russia
Industry: Retailer
Realization and support of projects in accordance with the technical assignment related to the assortment, sales, losses, forecasting, etc. Designing and maintenance of ETL-processes in the Informatica Power Center (IPC) system. Creating tables / views / procedures / IPC flows, scheduling MSSQL jobs. Query / code optimization, Explain plan analysis, statistics gathering, data analysis for compression.
Python: a) Modules - teradata, pyodbc - scikit-learn, matplotlib, numpy, pandas - pyexcel, win32com, - TkInter, pyqty5 b) Objectives - ETL-processes support - Machine learning (forecast) - Creation of regression models and their rating - DDL database change - GUI ETL: Informatica Power Center client - Analysis and preparation of data, procedures, macros - Preparing the structures of the target DDL tables - Creation and optimization of data flows - Configuring notification and scheduling of workflows VBA: - Import / export of data - Implementation of algorithms - Exception Handling - GUI IDE: - SQuirrel SQL Client - Spyder - Informatica Power Center - VBA editor - MSSQL Management Studio BD: - Teradata - MSSQL - SQLite--
Engineer of data transmission network and telematic systems 06/2006 - 01/2017
Vimpelcom, Krasnodar, Russia
Industry: Telecomunication
Work with DB Oracle, MSSQL, MySQL. Experience writing programs on language Delphi, creating databases in the service of ADSL subscribers and telephony. Switch and DSLAM configuration.
Designing and implementing Oracle databases accounting ADSL ports (2008-2011). Implementation and maintenance of the ADSL port accounting software: - Establishment of new communication centers (CC), adding equipment to the CC (more than 10 CC); - Creation of orders for crossing, release of ports (more than 5000 ports); - View bills, tariffs, traffic, lin data numbers, number of free ports on the site, accounting for IP addresses, ...; - Logging of crossings / transfers / disconnections / changes in tariffs, etc; - Preparation of data for billing during the reporting period; - Database management RADIUS-server MySQL; - Group operations to change the Rate-limits; - Aggregation of subscriber traffic by days and for the reporting period; - Creation of amounts of charges to subscribers in accordance with traffic and tariff plans. Communication with the subscriber database of the CBOSS system. After 2011, the successful migration of data to ACS Atlant. 2015-2017: Switch configuration: CISCO, Huawei. The configuration of DSLAM: Huawei, Zyxel, Alcatel, Paradyne, ZTE.--

Kuban State Technological University 09/2001 - 07/2006
Krasnodar, , Russia
Degree: Master's Degree
Major:Information Systems and Technology
Programming Engineer