Senior Data Engineer & ETL Architect with 35+ Years Experience

A. Yakov Khanuk

Novi, MI 248-***-**** ***********@*****.*** US Citizen

Professional Summary

Senior Data Engineer and ETL Architect with 35+ years of experience in ETL development, data warehousing, database design, and mainframe-to-cloud modernization. Expert in IBM DataStage, IBM CP4D, DBT, Qlik Replicate, Snowflake, Oracle, DB2, UNIX scripting, Microsoft Access, and SQL. Strong leader with experience in performance tuning, migration, architecture, and production support. Open to full-time, part-time, or contract roles.

Core Skills

• ETL Development and Architecture (DataStage 7.x–11.5, DBT, IBM CP4D)

• Data Warehousing, Data Modeling, Star/Snowflake Schema

• SQL, PL/SQL, Snowflake, Oracle Exadata, Microsoft Access, Qlik Replicate, DBT, DB2 LUW/zOS

• UNIX/Linux Shell Scripting, Perl, COBOL, JCL

• Control-M, Autosys, Tidal; GitLab, Bitbucket

• Performance Tuning, QA/Test Planning, Production Support Professional Experience

Ally Financial – Detroit, MI

Team Lead, ETL Development 2012–2026

• Led ETL development for enterprise DW and Snowflake environments.

• Lead developer for migration from DataStage 8.7 to 11.5.

• Integrated data from multiple systems into ODS, DW, and data marts.

• Designed complex SQL objects for Snowflake and Oracle.

• Developed schedules using Control-M and Tidal.

• Led QA efforts, performance tuning, and documentation.

• Supported production ETL operations and troubleshooting.

• Participated in Snowflake and CDC proof-of-concepts. TEKsystems – Southfield, MI

DataStage Analyst / Data Management (GM OnStar) 2012

• Designed ETL processes and performed data quality analysis.

• Developed DataStage jobs and UNIX scripts.

DataStage Specialist / Administrator (Ford Motor Company) 2010–2012

• Migrated DataStage environments from 7.5 to 8.1/8.5.

• Administered ETL environments and monitored performance.

• Supported production systems and served as SME for developers. CDI IT Solutions – Troy, MI

Senior Data Warehouse ETL Designer (Daimler Financial Services) 2009–2010

• Maintained and enhanced ETL processes feeding the financial DW.

• Designed JCL, scripts, and SQL procedures.

Compuware Corporation – Detroit, MI

Lead ETL Designer / Architect (Chrysler) 2002–2008

• Architected ETL solutions for BI and analytics systems.

• Designed data models using ERwin and PowerDesigner.

• Built DataStage jobs, shell scripts, and SQL procedures.

• Designed COBOL/JCL processes for mainframe extraction.

• Managed ETL developers, reviews, testing, and documentation. Senior System Analyst / Team Lead (Chrysler) 1997–2002

• Led team of 3–5 developers.

• Developed COBOL DB2 programs, stored procedures, and JCL.

• Conducted code reviews and SQL optimization.

Additional Earlier Roles (1991–1997)

Senior Programmer / Analyst roles at NBD, Handleman, United Insurance, Cap Gemini, Allnet

• COBOL, DB2, CICS, JCL development

• System testing, production support, requirements gathering Education

Master of Science in Electronics and Computer Technology Moscow Technical University of Communications and Informatics Training

DBT, Snowflake, Qlik Replicate

IBM InfoSphere/DataStage Admin & Development

Oracle Development, C/C++, BusinessObjects Universe Design Keywords:

DataStage, DataStage administrator, DataStage architect, DataStage design, Microsoft Access, Microsoft Office, DataStage developer, Qlik Replicate, system analyst, Unix shell scripts, ETL architect, data management, data analysis, database design, data modeling, COBOL, SQL, data analysis, system testing, IT, developer, star schema, data warehouse, data mart, database, Oracle, Snowflake, Mainframe, DB2, UDB

Contact this candidate