Open to opportunities

Ilya D

@ilyad

Senior Data Engineer building enterprise data warehouses, ETL pipelines, and analytical data marts for banking, insurance, and healthcare.

Russian Federation

Message

What I'm looking for

I’m looking for a role where I can design and optimize enterprise data warehouses and ETL/data integration, improve SQL/PL-SQL performance, and build reliable analytical marts and BI reporting end-to-end.

I build and optimize enterprise data warehouses, ETL pipelines, and analytical solutions across banking, insurance, and healthcare, including data marts processing hundreds of millions of records.

At G-STAT, I led SAS-based processes for 8 insurance data marts, collaborated with actuaries to translate requirements into analytical models, and cut processing time by 30% for marts with 100M+ rows. I also maintained Excel/VBA QA dashboards and streamlined data integration between Snowflake and SAS.

Before that, at Renaissance Credit I migrated 10 credit risk data marts from SAS to Oracle (PL/SQL), developed 80+ Oracle PL/SQL procedures and SAS programs, and reduced processing time by 50% for daily refreshes. I also worked on Oracle DWH with PL/SQL and SQL Server, improving database maintainability, performance, and reporting through ODI, SSAS, and Oracle BI.

Experience

Work history, roles, and key accomplishments

Data Analyst

G-Stat

Aug 2023 - Oct 2025 (2 years 2 months)

Built and optimized SAS-based processes for 8 insurance data marts supporting life, pension, and health insurance products. Collaborated with actuarial department to translate business requirements into analytical data models.

SAS SAS MACRO SQL Excel VBA Snowflake Data Integration

Data Engineer

Renaissance Credit

Jan 2020 - Aug 2023 (3 years 7 months)

Migrated ETL processes for 10 credit risk data marts from SAS to Oracle PL/SQL. Designed and optimized 80+ Oracle PL/SQL procedures and SAS programs supporting daily and monthly data mart refreshes.

Oracle Pl SQL SAS ETL Data Migration SQL

Data Warehouse Developer

Renaissance Insurance

May 2018 - Jan 2020 (1 year 8 months)

Maintained enterprise DWH processes on Oracle and SQL Server. Developed 30+ Oracle PL/SQL procedures and 10+ SQL Server stored procedures, improving database maintainability and performance.

Oracle Pl SQL SQL Server ODI SSAS ETL

Oracle PL/SQL Developer

Medintegrator

Apr 2016 - Apr 2018 (2 years)

Developed Oracle database solutions supporting healthcare information systems for hospitals. Designed database structures and implemented Oracle Message Queue for real-time patient monitoring data processing.

Oracle Pl SQL SQL Git Database Design Message Queues

Hyperion Consultant

IBS

May 2014 - Apr 2016 (1 year 11 months)

Participated in implementation of enterprise budgeting and forecasting solution based on Oracle Hyperion Planning. Implemented 20+ Oracle Planning forms and 50+ business rules supporting enterprise budgeting and forecasting.

Oracle Hyperion SQL OLAP