Natalia Dogadina

Responsibilities:

• Managing the analytics team, including planning and controlling project work
• Designing the architecture of DWH and ETL processes
• Designing and developing data marts and data lakes
• Developing reports and dashboards for business stakeholders

Key achievements:

• Implemented core financial data marts, including General Ledger, product-level marts for the loan portfolio and funding (attracted funds), PnL, transfer pricing and customer analytics
• Provided Finance and Risk teams with a consistent and integrated view of key financial metrics across products and customer segments, enabling more reliable analysis and reporting

Skills:

Data Analysis · PostgreSQL · Greenplum · ClickHouse · Superset · SQL · Oracle Database · Microsoft Power BI · Team Leadership

Responsibilities:

• Performed product and player behaviour analysis to support game design and monetisation decisions
• Built and maintained reports and dashboards for product and marketing teams
• Worked with large game-event datasets using SQL and Python to generate insights and hypotheses

Skills: Python · Amazon Athena · Big Data Analytics · SQL

Skills & technologies:

• Project portfolio management (KYC direction)
• Data mart and data lake design (including ETL processes)
• Data analysis and report development
• Teradata, Greenplum (PostgreSQL), Hadoop/Spark, Python, Qlik Sense
• Agile, Scrum, Jira, Confluence

Skills & technologies:

• Business / system analysis and requirements gathering
• Data modelling and data warehousing
• ETL (extraction, transformation and loading)
• Data governance
• Teradata SQL and optimisation

Key projects (Analyst & Data Architect):

• Analyst and architect of the “Client4D: Clients’ Payments” data mart used for customer behaviour analysis
• Analyst and architect of the “Client4D: Customer” data mart used to organise sales campaigns for banking products and services to existing customers
• Developed a subsystem for regular data quality monitoring, which ensured that business requirements for data quality in management reporting were met

Head of the DWH Department and data mart development programme. Responsible for Big Data and ETL projects. Participated as Lead, Analyst and Manager in projects for various bank departments, including Headquarters (ISP Group) initiatives.

Key projects:

• Internal projects: data marts and reports for the Accounting Department (reports for the state regulator), Finance Department (management reporting, IFRS), Risk Department, CRM, etc.
• Headquarters (ISP Group) projects: ETL process design and development for solutions to control and check data flows, including Finevare/PH3/IFRS 9 (Deloitte), ERMAS (Prometeia) and Electronic Credit Application (Prometeia)
• DWH team development and mentoring, including technical competence and productivity

Technologies: MS Project · PowerDesigner · MS SQL Server · SSIS · .NET

Responsibilities:

• Designed and implemented DWH solutions for banking and FinTech customers
• Developed data marts and multidimensional models, including data views, dimensions and cubes, in line with the company’s development methodology
• Developed and implemented reports based on DWH data for different bank departments
• Participated in projects as architect and data engineer, including logical and physical data modelling

Technologies: Oracle · Informatica · MS SQL Server · .NET

Responsibilities:

• Participated in a corporate data warehouse implementation project as a business/system analyst
• Developed reports using SQL and SAS
• Supported the data warehouse architecture (logical and physical models on Oracle)

Technologies: Oracle · Informatica · SAS

Responsibilities:

• Designed and developed corporate DWH solutions for banks
• Built reporting solutions for different bank departments based on DWH data

Technologies: Oracle · Informatica · MS SQL Server · Python