Natalia Filippova
Специализации
Навыки
Обо мне
Has 20 years of extensive experience in projects of building enterprise data warehouses in roles: functional/system analyst, SQL developer (Teradata, Oracle, DB2, SQL Server, etc), BI developer (QlikSense, SAP BusinessObjects), ETL process developer (Ascential / IBM DataStage, SAP BO Data Services), experience working with MDM and Data Quality systems. Participation in implementation through the full project lifecycle.
Roles
-----------
Functional System analyst
Database Developer
Data Modeler
Data Architect
Business Intelligence Developer
Data Engineer
Technologies
--------------------------
Teradata SQL and optimization
Business / System Analysis & Requirement Gathering
Industries
Finance
Retail
Manifacturing
Functional Expertise
----------------------------------------
Data modeling
Extraction, Transformation and Loading (ETL)
Data warehousing
SQL
Data analysis
Data governance
Portfolio
-
Teradata LLC: Project: DWH Data Mart PL_ACC (economic result on non-risk products of legal entities)
Sberbank of Russia / 1 декабря 2019 г.
Analyst, SQL Developer, Data Modeling Full lifecycle of works on the project: Collection and analysis of requirements; Designing a data model, mapping download to data model Teradata FSLDM; S2T preparation (Source-to-target); Development of SQL code for queries/views/procedures (including code optimization work); Development of test scenarios and scripts, participation in functional and acceptance testing; Producing and updating relevant documentation, etc. Technologies Deployed: Teradata, ETL Framework Sberbank (S2T Code Generator software), Gathering business requirements, Architecture and Design, Physical database design, Data Mapping documents. -
Teradata LLC, Project: Retail Risk Department reporting, QlikSense Developer
VTB Bank / 28 февраля 2022 г.
Analyst, SQL Developer, QlikSense Developer Full lifecycle of works on the project: Collection and analysis of requirements; Development of SQL code for queries / views/ procedures (including code optimization work); Development of test scenarios and scripts, participation in functional and acceptance testing; Producing and updating relevant documentation, etc. QlikSense Developer: Development of Data Model, ETL from different data sources and different systems; Report forms. Technologies Deployed: Teradata, QlikSense, Gathering business requirements, Architecture and Design. -
Teradata LLC, DWH Infrastructure Project
Sberbank of Russia / 1 июля 2017 г.
Analyst, SQL Developer Development and implementation of techniques for freeing up disk space: development recommendations to minimize the use of Spool, development of data trimming procedures (data reduction by cleaning historical slices). Technologies Deployed: Teradata. -
Teradata LLC, Teradata managed services: 3rd Line Support of DWH projects.
Sberbank of Russia / 1 апреля 2017 г.
Analysis of incidents and defects, re-work/correction of errors in scripts of queries/views/procedures (including code optimization work); collection and output of Jira / Jazz patches. Technologies Deployed: Teradata, Jira/Jazz), Gathering business requirements, Architecture and Design, Physical database design, Data Mapping documents. -
Teradata LLC, Project: Rollout of balance sheet reporting. Phase 2
Sberbank of Russia / 1 декабря 2015 г.
Collection and analysis of requirements for rework of SQL code for queries/views/procedures within the CRs; Development of test scenarios and scripts, participation in functional and acceptance testing; Producing and updating relevant documentation. Technologies Deployed: Teradata. -
Teradata LLC, Project: Data Mart RCDM, phase 2 (building a DM for the analysis of the client base)
Sberbank of Russia / 1 декабря 2014 г.
Collection and analysis of requirements; Designing a data model, mapping download to data model Teradata FSLDM; S2T preparation (Source-to-target); Development of SQL code for queries / views / procedures; Development of test scenarios and scripts, participation in functional and acceptance testing. Technologies Deployed: Teradata, Gathering business requirements, Architecture and Design, Physical database design, Data Mapping documents. -
UMC DWH (Plan/fact reporting, functional areas: sale, production, payments, transportation)
United Metallurgical Company / 1 декабря 2013 г.
Participation in the project of building corporate data warehouse (Plan/fact reporting, functional areas: sale, production, payments, transportation). Analyst, supports data warehouse architecture (logical / physical model, Oracle DB), ETL-developer (SAP BO Data Services, part of the functionality – SAP BW, Informatica). Administration SAP BO Data Services (OS AIX). Technologies Deployed: Oracle, SAP BO Data Services, SAP BW, Informatica -
Teradata LLC, Data governance project: Unified data quality system
Sberbank of Russia / 1 августа 2018 г.
Development of a subsystem for regular monitoring of data quality. Designing a data model for the DQ-system for storing data describing algorithms and rules for checking data quality, dq-metrics (detailed, aggregated), logs with the results of checks, etc. Participation in the development of the methodology and processes of the data quality control system. Technologies Deployed: Teradata, Oracle, Hadoop, Gathering business requirements, Architecture and Design -
DWH OOO Orglot
OOO Orglot / 1 октября 2009 г.
Participation in the projects of building corporate data warehouse as analyst, logical/physical modeling, ETL-developer (Ascential DataStage 7.X). Administration Ascential DataStage 7.X (OS Windows). Preparation of design documentation. Technologies Deployed: Oracle, SAP BO Data Services, SAP BW, Informatica -
Bank Rosbank (Moscow). Project of building the data mart for call-center bank
Bank Rosbank / 1 января 2008 г.
ETL process developer, Data Modeling, Analyst Client: Bank Rosbank (Moscow). Participation in the project of building the data mart for call-center bank in roles: ETL-developer (Ascential DataStage 7.X) and analyst. Producing and updating relevant documentation, etc. Technologies Deployed: Oracle, Ascential DataStage 7.X, IBM BDW -
Trading House GUM DWH "Logistics"
Trading House GUM / 1 июля 2006 г.
ETL process developer, DBA DWH "Logistics" support in part of: Support logical / physical model (Oracle Database 8); ETL- development (Ascential DataStage); Configure business data layer (Universe BI Business Objects), create BI-reports based on Business Objects Software; Administration: Ascential DataStage 7.X, Business Objects, DWH based on Oracle 8 (partial function) (OS Windows, HP-UX) Technologies Deployed: Oracle, Ascential DataStage 7.X, Business Objects, HP-UX
Education
-
Moscow State Institute of Radio Engineering, Electronics and Automation
Другое / the faculty of Computer Science and Engineering with Specialization in Automated data processing and management information
1 сентября 1994 г. - 1 июля 2000 г. -
Plekhanov Russian University of Economics
Бакалавриат / Bachelor’s in management, specialization in Financial Management (diploma with honors)
1 сентября 2012 г. - 1 июля 2014 г.
Work Experience
-
Professional Services Consultant
Teradata LLC
1 декабря 2013 г. - 1 апреля 2022 г. -
ETL process developer, Data Modeling, Analyst
United Metallurgical Company
1 октября 2009 г. - 1 ноября 2013 г. -
ETL process developer, Data Modeling, Analyst
OOO Orglot
1 февраля 2008 г. - 1 октября 2009 г. -
ETL process developer, Data Modeling, Analyst
Tern Group
1 августа 2006 г. - 1 января 2008 г. -
ETL process developer, DBA
Trading House GUM
1 ноября 2001 г. - 1 июля 2006 г.
Achievements
-
Certifications Teradata 14 Certified Professional, 78MSDYH1JFFEK7QP
Teradata
7 декабря 2016 г.