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
- androsovsv
- mail@sergeyandrosov.ru
- androsovsergey.ru
- Russia, Moscow
Skills
-
-
Programming
- Python
- Scala
- SQL
- Bash
-
Databases
- Hadoop
- Greenplum
- PostgreSQL
- MS SQL Server
-
Developer Tools
- Git
- Docker
- Teamcity
- Jira/Confluence
Languages
-
RussianNative
-
EnglishB2
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