Evgenii is available for hire
Hire EvgeniiEvgenii神经
验证专家 in Engineering
数据工程开发人员
Location
黑山布德瓦市彼得罗瓦茨
至今成员总数
June 18, 2020
Evgenii拥有大约9年的数据库开发经验, 主要关注于构建和优化数据仓库. He started his professional career as an SQL engineer-analyst in one of RosTeleCom Mobile holdings and was promoted to analytical reporting team manager in two years. 在他的职业生涯中, Evgenii has participated in several telecom OSS and BSS migration and integration projects, 包括Tele2 Rus, Optus AU, and Telenet BE.
Portfolio
Samsung NEXT
Apache气流，Python 3, ClickHouse, PostgreSQL, MySQL，数据管道...
Netcracker
Apache Ignite, Cassandra, Java, Shell, Oracle PL/SQL, Apache Airflow...
Netcracker
Java, Shell, Oracle PL/SQL, PL / SQL开发人员, DBeaver, Oracle SQL, PL/SQL...
Experience
Availability
Part-time
首选的环境
Git, IntelliJ IDEA, DBeaver, PL / SQL开发人员, DataGrip, SQL, Oracle PL/SQL
最神奇的...
...thing I've coded and driven is the migration of the analytical DWH of RosTeleCom Mobile into Tele2 Rus systems.
工作经验
高级数据工程师
2021 - PRESENT
Samsung NEXT
- 实现了基于Apache气流的数据管道. These data pipelines collected information from different data sources like PostgreSQL, MySQL, Instagram API, Mixpanel, etc.进入ClickHouse.
- Administered machine learning features data collection into a separate database for recommendation system recalculation.
- Created complex SQL queries on ClickHouse SQL to implement analytical dashboards. 调整和改进现有的分析报告.
Technologies: Apache气流，Python 3, ClickHouse, PostgreSQL, MySQL，数据管道, DataGrip
首席软件工程师
2019 - 2021
Netcracker
- Tasked with internal code delivery drops on build and testing within my stream.
- 管理一个5人的开发团队. 分解、设置和控制任务.
- 进行LOE、工作范围和时间框架估计.
- Communicated with the project team, conterminal streams, and customer representatives.
技术:Apache Ignite, Cassandra, Java, Shell, Oracle PL/SQL, Apache Airflow, Apache Hive, Python 3, PL / SQL开发人员, DBeaver, Oracle SQL, PL/SQL, 工程数据, PL/SQL Tuning, Data Migration, Migration, Python, Data Pipelines, 团队管理, 软件开发管理, Spark SQL, Spark, PySpark
高级软件工程师
2016 - 2019
Netcracker
- Developed PL/SQL transformations into an entity–attribute–value database and validations according to migration documents.
- Managed post-migration activities as a data migration lead with four subordinates. 分析客户需求, 改进了系统功能和速度, 修复bug和设计, 在下属之间分配和控制任务.
- Verified and modified migration rules during discussions with business analysts.
- 寻找迁移速度瓶颈并调优SQL转换.
- Participated in meetings with customer representatives and provided consultations to the onsite team regarding migration procedures.
Java技术:, Shell, Oracle PL/SQL, PL / SQL开发人员, DBeaver, Oracle SQL, PL/SQL, 工程数据, PL/SQL Tuning, Data Migration, Integration, Migration, Data Pipelines
首席数据库程序员
2015 - 2016
Transset
- Developed a database structure based on the entity–attribute–value model. 创建Oracle PL/SQL过程和包.
- Optimized database search time with Oracle Text index as part of my role.
- 使用Oracle ORDS实用工具创建数据库后端REST API.
- Developed a Pentaho 数据集成 schema for database migration from Oracle to PostgreSQL.
- Developed a PostgreSQL integration with MS SQL server for using data in MS SSAS, 包括ETL链和Janino上的子程序.
技术:介绍英国, Microsoft SQL Server, Pentaho, PostgreSQL, Janino, Java, Redgate, Oracle REST数据服务(ORDS), Index, Oracle, RMAN, PL / SQL开发人员, Oracle SQL, PL/SQL, 工程数据, PL/SQL Tuning, Migration
分析报告团队经理
2014 - 2015
Rostelecom
- 执行和控制月度和年度账单程序.
- 管理和控制Teradata客户关系管理集成程序.
- Developed the data warehouse structure and PL/SQL package for flexible schemes of dealers settlement and reward and a dealers fraud identifying reports system.
- Set, split, 并在三个分析报告组开发人员之间控制任务, 激励下属, 协调假期安排.
- Managed and orchestrated the CJSC NSS statistics system migration into the Tele2 Russia informational system.
技术:Java SE, Churn Analysis, Teradata, OLAP, BSS, SQL, Oracle PL/SQL, Oracle SQL, PL/SQL, 工程数据, PL/SQL Tuning, Data Migration, Migration, Data Pipelines, 团队管理, 软件开发管理, Data Analysis, Data Analytics, 分析实现
分析DB工程师
2011 - 2014
CJSC“NSS”(RosTeleCom holding)
- 开发和优化对计费系统的SQL请求.
- Developed the load-base statistics maintaining system for telecom base stations.
- 扩大和改进分析数据仓库系统, 集成了众多数据源的报告系统优化.
- Analyzed and developed single and periodic analytic reports according to management expectations.
- Developed a program pack for working with content providers using Java SE and Oracle 10g PL/SQL.
技术:Java SE, PL/SQL, Oracle SQL, SQL, Oracle PL/SQL, 工程数据, 分析实现, Data Analysis, Data Analytics
Experience
基础运营商迁移到NetCracker BSS & OCS Systems
The process for migrating Base Operator (a part of Telenet Belgium) customers from a legacy system to a NetCracker real-time billing and rating management system.
我是OCS(在线收费系统)迁移团队的负责人, 在迁移设计快完成的时候进入项目. However, 由于大量的产品代码更改, 设计不得不进行了几次戏剧性的修改. Also, 因为缺少OCS迁移业务分析师, I had to proactively communicate with the product implementation team and the customer, performing analysis and design by myself to create and split implementation tasks between team members.
我还负责执行SVT测试, 分析结果, and find ways to improve performance in all parts of the OCS migration ETL—Oracle PL/SQL scripts for data extraction and preliminary transformation, 用于数据传输的Java/Kotlin应用程序, 和Grafana日志用于监控Apache Cassandra负载.
从人员管理的角度来看, 我在做所有常规的团队领导活动:任务分解, 分配和控制, 交货计划, 新特性评估, 和ETA计算.
我是OCS(在线收费系统)迁移团队的负责人, 在迁移设计快完成的时候进入项目. However, 由于大量的产品代码更改, 设计不得不进行了几次戏剧性的修改. Also, 因为缺少OCS迁移业务分析师, I had to proactively communicate with the product implementation team and the customer, performing analysis and design by myself to create and split implementation tasks between team members.
我还负责执行SVT测试, 分析结果, and find ways to improve performance in all parts of the OCS migration ETL—Oracle PL/SQL scripts for data extraction and preliminary transformation, 用于数据传输的Java/Kotlin应用程序, 和Grafana日志用于监控Apache Cassandra负载.
从人员管理的角度来看, 我在做所有常规的团队领导活动:任务分解, 分配和控制, 交货计划, 新特性评估, 和ETA计算.
SingTel Optus迁移到NetCracker OSS系统
Successful migration of Australian Optus operator's OSS systems to the NetCracker TOMS engine.
作为一名资深开发者, 我创建了变换, validation, and reconciliation scripts for millions of records to be processed and uploaded into the EAV data model during migration. A huge part of this work was Oracle SQL tuning and PL/SQL scripts development for matching customers' NFRs for migration timeframes.
迁移后, I continued to work on this project as a post-migration support team lead, distributing data fixes between team members and working with the customer's data extract team on new data integration CRs (customer requests).
作为一名资深开发者, 我创建了变换, validation, and reconciliation scripts for millions of records to be processed and uploaded into the EAV data model during migration. A huge part of this work was Oracle SQL tuning and PL/SQL scripts development for matching customers' NFRs for migration timeframes.
迁移后, I continued to work on this project as a post-migration support team lead, distributing data fixes between team members and working with the customer's data extract team on new data integration CRs (customer requests).
下诺夫哥罗德通信向Tele2 DWH迁移
This project focuses on the management and orchestration of CJSC "NSS" (Nizhny Novgorod Communications) statistics system migration into the "Tele2 Russia" informational system. This migration was necessary after the sale of RosTeleCom PJSC's mobile assets to Tele2 Russia LLC. Our primary objective was to align the analytical and reporting system of CJSC "NSS" with the standards set by Tele2.
I led a team of analytical reporting developers responsible for the migration process. 我们通过进行系统比较来调整系统, collaborating with Tele2 data development and marketing teams to ensure mapping and ETL design, 确定硬件需求, 执行数据验证和性能检查, 编码和执行ETL进程, 并提供移民后的支持.
I led a team of analytical reporting developers responsible for the migration process. 我们通过进行系统比较来调整系统, collaborating with Tele2 data development and marketing teams to ensure mapping and ETL design, 确定硬件需求, 执行数据验证和性能检查, 编码和执行ETL进程, 并提供移民后的支持.
Skills
Languages
SQL, SQL DDL, Java SE, Python 3, Kotlin, Python, Java 8, Java
Paradigms
好了，休息吧
Platforms
甲骨文,Pentaho
Storage
PL / SQL开发人员, Oracle SQL, PL/SQL, Data Pipelines, Oracle PL/SQL, Oracle 11g, 数据集成, Oracle RDBMS, 数据验证, DBeaver, Teradata, Microsoft SQL Server, Cassandra, Apache Hive, PostgreSQL, SQL Server 2012, ClickHouse, MySQL
Other
PL/SQL Tuning, Data Migration, Migration, Integration, 工程数据, 软件开发管理, 远程团队领导, 电讯业务支援系统(BSS), 数据仓库设计, 团队管理, BSS, Churn Analysis, Index, Oracle REST数据服务(ORDS), Janino, Apache Cassandra, 分析实现, Data Analysis, Data Analytics
Tools
IntelliJ IDEA, Git, RMAN, Redgate, SSAS, Shell, Apache Ignite, Apache Airflow, DataGrip, Jira, Postman, Pentaho数据集成(Kettle), TortoiseSVN, Subversion (SVN), Spark SQL
Frameworks
Hibernate, JUnit, Spark
Libraries/APIs
Apache POI, Apache HttpClient, PySpark
行业专业知识
电信
Education
2008 - 2013
Specialist Degree (Master's Degree Equivalent) in Computer Science in Economics
Lobachevsky State University of Nizhnii Novgorod - Nizhnii Novgorod, Russia
有效的合作
如何使用Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
1
分享你的需求
Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2
选择你的才能
Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3
开始你的无风险人才试验
与你选择的人才一起工作，试用最多两周. 只有当你决定雇佣他们时才付钱.
对顶尖人才的需求很大.
Start hiring