toptal.com
Contact us: +1.888.867.7001
Evgenii Timofeev, Data Engineering Developer in Nizhny Novgorod, Nizhny Novgorod Oblast, Russia
Evgenii Timofeev

Data Engineering Developer in Nizhny Novgorod, Nizhny Novgorod Oblast, Russia

Member since June 18, 2020
Evgenii has around nine years of database development experience, with a primary focus on building and optimizing data warehouses. He started his professional career as an SQL engineer-analyst in one of RosTeleCom Mobile holdings and was promoted to an analytical reporting team manager in two years. During his career, he's participated in several telecom OSS and BSS migration and integration projects including Tele2 Rus, Optus AU, and Telenet BE.
Evgenii is now available for hire
Hire Evgenii

Portfolio

  • Samsung NEXT
    Apache Airflow, Python 3, ClickHouse, PostgreSQL, MySQL, Data Pipelines...
  • Netcracker
    Apache Ignite, Cassandra, Java, Shell, Oracle PL/SQL, Apache Airflow...
  • Netcracker
    Java, Shell, Oracle PL/SQL, PL/SQL Developer, DBeaver, Oracle SQL, PL/SQL...

Experience

Location

Nizhny Novgorod, Nizhny Novgorod Oblast, Russia

Availability

Part-time

Preferred Environment

Git, IntelliJ IDEA, DBeaver, PL/SQL Developer, DataGrip, SQL, Oracle PL/SQL

The most amazing...

...thing I've coded and driven is the migration of analytical DWH of RosTeleCom Mobile into Tele2 Rus systems.

Employment

  • Senior Data Engineer

    2021 - PRESENT
    Samsung NEXT
    • Implemented data pipelines based on Apache Airflow. These data pipelines collected information from different data sources like PostgreSQL, MySQL, Instagram API, Mixpanel, etc., into 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. Tuned and improved existing analytical reports.
    Technologies: Apache Airflow, Python 3, ClickHouse, PostgreSQL, MySQL, Data Pipelines, DataGrip

  • Lead Software Engineer

    2019 - 2021
    Netcracker
    • Tasked with internal code delivery drops on build and testing within my stream.
    • Managed a team of five developers. Decomposed, set, and controlled tasks.
    • Made the LOE, scope of work, and time frame estimations.
    • Communicated with the project team, conterminal streams, and customer representatives.
    Technologies: Apache Ignite, Cassandra, Java, Shell, Oracle PL/SQL, Apache Airflow, Apache Hive, Python 3, PL/SQL Developer, DBeaver, Oracle SQL, PL/SQL, Data Engineering, PL/SQL Tuning, Data Migration, Migration, Python, Data Pipelines, Software Development Management, Team Management, Spark SQL, Spark, PySpark

  • Senior Software Engineer

    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. Analyzed customer requests, improved system function and speed, fixed bugs and design, and distributed and controlled tasks between subordinates.
    • Verified and modified migration rules during discussions with business analysts.
    • Looked for migration speed bottlenecks and tuned SQL transformations.
    • Participated in meetings with customer representatives and provided consultations to the onsite team regarding migration procedures.
    Technologies: Java, Shell, Oracle PL/SQL, PL/SQL Developer, DBeaver, Oracle SQL, PL/SQL, Data Engineering, PL/SQL Tuning, Data Migration, Integration, Migration, Data Pipelines

  • Lead Database Programmer

    2015 - 2016
    Transset
    • Developed a database structure based on the entity–attribute–value model. Created Oracle PL/SQL procedures and packages.
    • Optimized database search time with Oracle Text index as part of my role.
    • Created a database back-end REST API using Oracle ORDS utility.
    • Developed a Pentaho Data Integration schema for database migration from Oracle to PostgreSQL.
    • Developed a PostgreSQL integration with MS SQL server for using data in MS SSAS, including ETL chains and subprograms on Janino.
    Technologies: SSAS, Microsoft SQL Server, Pentaho, PostgreSQL, Janino, Java, Redgate, Oracle REST Data Services (ORDS), Index, Oracle, RMAN, PL/SQL Developer, Oracle SQL, PL/SQL, Data Engineering, PL/SQL Tuning, Migration

  • Analytical Report Team Manager

    2014 - 2015
    Rostelecom
    • Executed and controlled monthly and yearly billing procedures.
    • Administrated and controlled Teradata Churn CRM integration procedures.
    • 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, and controlled tasks between three analytical reporting group developers, motivated subordinates, and coordinated vacation schedules.
    • Managed and orchestrated the CJSC NSS statistics system migration into the Tele2 Russia informational system.
    Technologies: Java SE, Churn Analysis, Teradata, OLAP, BSS, SQL, Oracle PL/SQL, Oracle SQL, PL/SQL, Data Engineering, PL/SQL Tuning, Data Migration, Migration, Data Pipelines, Team Management, Software Development Management, Data Analysis, Data Analytics, Analytics Implementation

  • Analytical DB Engineer

    2011 - 2014
    CJSC "NSS" (RosTeleCom holding)
    • Developed and optimized SQL requests to the billing system.
    • Developed the load-base statistics maintaining system for telecom base stations.
    • Enlarged and improved the analytical data warehouse system, integrated with numerous data sources for report system optimization.
    • 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.
    Technologies: Java SE, PL/SQL, Oracle SQL, SQL, Oracle PL/SQL, Data Engineering, Analytics Implementation, Data Analysis, Data Analytics

Experience

  • Base Operator Migration into 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.

    I was an OCS (online charging system) migration team lead, came into the project when the migration design was almost finished. However, due to numerous product code changes, the design had to be changed several times dramatically. Also, because of the absence of OCS migration business analysts, 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.
    I was also responsible for executing SVT tests, analyze results, 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 application for data transfer, and Grafana logs for monitoring Apache Cassandra load.
    From the people management perspective, I was doing all the regular team lead activities: tasks decomposition, distribution and control, delivery planning, new features assessment, and ETA calculation.

  • SingTel Optus Migration into NetCracker OSS System

    Successful migration of Australian Optus operator's OSS systems to the NetCracker TOMS engine.

    As a senior developer, I've created transformation, 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.
    After the migration, 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).

Skills

  • Languages

    SQL, SQL DDL, Java SE, Python 3, Kotlin, Python, Java 8, Java

  • Paradigms

    ETL, OLAP, REST

  • Platforms

    Oracle, Pentaho

  • Storage

    PL/SQL Developer, Oracle SQL, PL/SQL, Data Pipelines, Oracle PL/SQL, Oracle 11g, Data Integration, Oracle RDBMS, Data Validation, DBeaver, Teradata, Microsoft SQL Server, Cassandra, Apache Hive, PostgreSQL, SQL Server 2012, ClickHouse, MySQL

  • Other

    PL/SQL Tuning, Data Migration, Migration, Integration, Data Engineering, Software Development Management, Remote Team Leadership, Telecom Business Support Systems (BSS), Data Warehouse Design, Team Management, BSS, Churn Analysis, Index, Oracle REST Data Services (ORDS), Janino, Apache Cassandra, Analytics Implementation, Data Analysis, Data Analytics

  • Tools

    IntelliJ IDEA, Git, RMAN, Redgate, SSAS, Shell, Apache Ignite, Apache Airflow, DataGrip, Jira, Postman, Pentaho Data Integration (Kettle), TortoiseSVN, Subversion (SVN), Spark SQL

  • Frameworks

    Hibernate, JUnit, Spark

  • Libraries/APIs

    Apache POI, Apache HttpClient, PySpark

  • Industry Expertise

    Telecommunications

Education

  • Specialist Degree (Master's Degree Equivalent) in Computer Science in Economics
    2008 - 2013
    Lobachevsky State University of Nizhnii Novgorod - Nizhnii Novgorod, Russia

To view more profiles

Join Toptal
Share it with others
Hire the top 3% of freelance developers TM