Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Mansur Fiatiakhotdinov

Abu Dhabi

Summary

A seasoned Sr. Data Engineer with over ten years of experience in data engineering and analysis. Expertise in handling structured and unstructured data. Specialized in developing robust data pipelines, ETL processes and analytical solutions utilizing PySpark, Azure, Databricks, Airflow, Talend. Demonstrated success in collaborating with data scientists to implement predictive models and AI solutions across various departments in leading financial institutions.

Overview

15
15
years of professional experience
1
1
Certification

Work History

Data Engineer, Lead

Miral Experiences
07.2022 - Current
  • Developed end-to-end data pipeline on Azure Data Factory, Databricks, and Talend to process data from different sources, enabling all needed information for business users, accelerated analytics, and provided valuable insights.
  • Provide support for around 50 pipelines, interacting with various teams to ensure smooth data flow.
  • Prepare technical and end user documentation for ETL pipelines.
  • Work closely with vendors regarding data integration for various development projects.
  • Engage with business teams to gather requirements and design optimal data solutions.

Senior Data Analyst

Innotech (VTB Bank)
01.2022 - 07.2022
  • Engaged with stakeholders to define project scope and objectives.
  • Developed ETL/ELT pipelines using Apache Spark, PySpark, and Airflow.
  • Ensured data quality and efficiency in collaboration with the delivery team.
  • Performed root-cause analysis on data-related system problems to recommend or execute corrective action.
  • Analyzed large amounts of data to identify trends and find patterns, signals and hidden stories within data.

Senior Data Engineer

Sberbank
10.2019 - 01.2022
  • Managed data extraction, transformation, and analysis for AI transformation of different departments inside the bank.
  • Worked with both structured and unstructured data
  • Collaborated with data scientists to implement predictive models for various departments.
  • Built and maintained reliable ETL pipelines using PySpark and Airflow.
  • Analyzed both current and historical data for strategic insights.
  • Established ETL pipelines to processed over 100 million transactions daily via ETL jobs on Airflow and Spark.

Senior Data Engineer

Promsvyazbank
10.2017 - 10.2019
  • Oversaw ETL processes and data loading for retail risk department (using MS SQL Server, Oracle, etc.)
  • Worked on extracting data from various internal and external sources, consolidating and processing it for use by analytics and data science teams.
  • Developed pipelines to calculate mandatory financial information and regulatory reporting metrics like IFRS 9.
  • Focused on data consolidation, cleaning, and quality control before dissemination to downstream teams.
  • Created analytical storefronts and self-service BI reporting tools for business users.

Senior Data Engineer

URALSIB Bank
01.2013 - 09.2017
  • Maintained ETL processes and database management.
  • Generated key analytical reports for management.
  • Implemented a management reporting system.

Senior Portfolio Analyst, Retail Risk

Bank SOYUZ
09.2011 - 01.2013
  • Collect and aggregate data from multiple source systems including credit bureaus, origination systems, collection systems etc. to get a complete view of the retail credit portfolio.
  • Perform data analysis to identify trends and insights related to portfolio quality, delinquencies, loss rates, risk concentration across various retail loan products.
  • Develop interactive dashboards and visualizations using BI tools to present portfolio analytics and metrics to senior management and business teams.
  • Prepare detailed portfolio analysis reports and presentations for credit committee meetings covering topics such as portfolio growth, early delinquencies, losses, recovery.
  • Build statistical models for credit risk forecasting, estimating expected loss provisions, stress testing etc. leveraging data science techniques.
  • Monitor adherence to credit policies and risk appetite limits for various retail lending programs. Raise flags and recommendations.
  • Keep updated with industry best practices and regulatory requirements around retail credit risk management and monitoring.

MI Specialist, Retail Risk

HSBC
07.2010 - 07.2011
  • Gained thorough understanding of credit process and policy to provide support and guidance to risk teams.
  • Maintained high accuracy standards for recording and reporting on retail credit portfolio metrics.
  • Reported on new account bookings, highlighted potential risks. Provided insights to shape acquisition strategies.
  • Tracked portfolio performance to identify risk drivers and trends.
  • Supported collection processes tracking and loan loss reserving calculations.
  • Developed statistical models and applications for risk management.
  • Submitted timely and accurate portfolio reports to senior management.
  • Built relationships with cross-functional teams like underwriting, finance, compliance.
  • Supported development of risk scoring systems. Provided ad-hoc analysis for wholesale risk team

Business Support Specialist

Otkritie Broker Ltd
08.2009 - 07.2010

Business Control Support Specialist

Renaissance Capital, Investment Bank
08.2008 - 02.2009

Education

Master of Science - Computer Science

National Research Nuclear University MEPhI
Moscow, Russia
07.2008

Skills

  • Data Engineering: PySpark, SQL, Python
  • Languages: English (Full Professional)
  • Tools & Technologies: Azure Data Factory, Airflow, Databricks, Talend, Snowflake, Hadoop, HDFS, Cassandra, SSIS, MS SQL Server, Greenplum, PostrgeSQL, Oracle Exadata, Git, Jira, Confluence
  • Methodologies: Agile

Certification

  • 10777: Implementing a Data Warehouse with Microsoft SQL Server 2012
  • Cleaning and Exploring Big Data using PySpark
  • AWS Cloud Practitioner Essentials
  • Data Analysis Using PySpark

Timeline

Data Engineer, Lead

Miral Experiences
07.2022 - Current

Senior Data Analyst

Innotech (VTB Bank)
01.2022 - 07.2022

Senior Data Engineer

Sberbank
10.2019 - 01.2022

Senior Data Engineer

Promsvyazbank
10.2017 - 10.2019

Senior Data Engineer

URALSIB Bank
01.2013 - 09.2017

Senior Portfolio Analyst, Retail Risk

Bank SOYUZ
09.2011 - 01.2013

MI Specialist, Retail Risk

HSBC
07.2010 - 07.2011

Business Support Specialist

Otkritie Broker Ltd
08.2009 - 07.2010

Business Control Support Specialist

Renaissance Capital, Investment Bank
08.2008 - 02.2009

Master of Science - Computer Science

National Research Nuclear University MEPhI
Mansur Fiatiakhotdinov