Sergey Androsov

Profile

Data Engineer with extensive experience in designing and implementing Data Warehouses (DWH) and Data Marts. Proficient in various technologies including Apache Hadoop, Spark, Greenplum, and more. Seeking opportunities to leverage expertise in data engineering to drive innovation and contribute to impactful projects.

Experience

Yandex

Moscow, Russia

Senior/Lead Data Engineer

Apr 2024 - Present time

  • Leading development of data processing pipelines.
  • Collaborating with cross-functional teams for designing a large-scale data warehouse that supports business intelligence and analytics.

Innotech

Moscow, Russia

Lead Data Engineer

Mar 2021 - Apr 2024

  • Designed and implemented Data Warehouses and Data Marts to support diverse analytical needs.
  • Utilized technologies such as Apache Hadoop, Spark, Greenplum, etc., to process and analyze large datasets efficiently.
  • Developed ETL processes for data ingestion, transformation, and loading, ensuring data integrity and quality.
  • Collaborated with cross-functional teams to understand business requirements and deliver tailored data solutions.
  • Optimized performance and scalability of data infrastructure to meet evolving business demands.
  • Hadoop
  • Spark
  • Scala
  • Python
  • Airflow
  • Leading
  • Agile

Sber

Moscow, Russia

Senior Data Engineer

Jul 2019 - Mar 2021

  • Assisted in building and maintaining data pipelines for extracting, transforming, and loading data into DWH.
  • Conducted data quality assessments and implemented data cleansing processes to ensure accuracy.
  • Contributed to the optimization of database queries and data processing workflows.
  • Participated in team meetings and discussions to brainstorm solutions and share insights.
  • Hadoop
  • Spark
  • Scala
  • Python
  • Oozie
  • Agile

Medialogiya

Moscow, Russia

SQL Developer/DBA

Apr 2018 - Jul 2019

  • Wrote and optimized complex SQL queries for data retrieval, manipulation, and reporting.
  • Conducted performance tuning and optimization of database queries and indexes.
  • Administered and maintained MS SQL Server databases, ensuring optimal performance, availability, and security.
  • Implemented database backup and recovery strategies to minimize data loss and downtime.
  • Monitored database performance and implemented optimizations to enhance efficiency and scalability.
  • Installed and configured MS SQL Server instances, patches, and upgrades.
  • Managed user access and permissions to maintain data security and compliance.
  • Provided technical support and troubleshooting for database-related issues.
  • Developed and maintained documentation for database configurations, procedures, and standards.
  • SQL
  • MS SQL Server
  • DBA
  • Reporting

FNS Russia

Anapa, Russia

Head of IT Department

Jan 2013 - Apr 2018

  • Lead and managed the IT department, overseeing all technology operations and initiatives.
  • Developed and implemented IT strategies aligned with business goals to drive digital transformation and innovation.
  • Directed the planning, budgeting, and execution of IT projects, ensuring on-time delivery and within budget.
  • Collaborated with cross-functional teams to identify technology needs and implement solutions to improve business processes and efficiency.
  • Ensured compliance with regulatory requirements and data security standards.
  • Provided leadership and mentorship to IT staff, fostering a culture of continuous learning and professional development.
  • Established strong vendor relationships and negotiated contracts for IT products and services.
  • IT Management
  • MS SQL Server
  • Microsoft Windows Server
  • Supporting

Education

Automatic systems information handling and management

Russian State Social University

Sep 2007 - Jun 2012

Engineer
photo of me

Skills

    • Programming
    • Python
    • Scala
    • SQL
    • Bash
      Databases
    • Hadoop
    • Greenplum
    • PostgreSQL
    • MS SQL Server
      Developer Tools
    • Git
    • Docker
    • Teamcity
    • Jira/Confluence

Languages

  • Russian
    Native
  • English
    B2

Diplomas

  • Cisco Courses aka CCNA (2016)
  • Innopolis University Java Engineering (2018)
  • Newprolab Spark Data Engineer (2020)
  • NVIDIA FUNDAMENTALS OF DEEP LEARNING (2020)
  • NVIDIA BUILDING INTELLIGENT RECOMMENDER SYSTEMS (2020)

Interests

  • Travelling
  • Computer Games
  • Reading books
  • Languages