Technical Expertise

Experience & Disciplines

Over three decades of hands-on consulting across enterprise databases, data warehousing, ETL development, cloud platforms, and system integration.

As a consultant since 1991, Duane Jurgens has contributed to technical teams at 17 clients across 10 industries. The core of this experience is enterprise relational database technology โ€” delivering solutions in system co-existence, product integration, performance tuning, software development, system architecture, and administration. Since 1999, Duane has served as a senior developer across four Data Warehouse enterprise groups, with deep experience in Microsoft's development stack (SSIS, SSRS, SSAS, MVC) and Ascential's DataStage ETL tool on DB2 and Teradata.

Core Disciplines
Areas of Expertise
๐Ÿ—๏ธ
Data Warehouse

Architecture, design, and development of enterprise data warehouses. Experience with dimensional modeling, star and snowflake schemas, staging layers, and integration with downstream BI tools including Power BI, SSRS, and SSAS.

View Details โ†’
๐Ÿ”„
DataStage ETL

Senior-level development with Ascential DataStage ETL on DB2 (UDB) and Teradata platforms. Extensive pipeline design for large-scale enterprise data integration across complex environments.

View Details โ†’
๐Ÿ—„๏ธ
SQL Server

Deep expertise in Microsoft SQL Server โ€” Transact-SQL development, SSIS package design, SSRS report development, SSAS cube construction, and database administration across enterprise environments.

View Details โ†’
๐Ÿ”ฎ
Oracle

Oracle PL/SQL application development, production readiness assessment, and performance optimization. Project delivery experience at Honeywell, Edina Realty, Liberty Check Printing, and Ceridian.

View Details โ†’
โšก
Performance Tuning

Query optimization, index strategy, execution plan analysis, and database configuration tuning across SQL Server, Oracle, DB2, Sybase, and Teradata. Proven results across financial services and healthcare clients.

View Details โ†’
๐Ÿ˜
DB2 (UDB)

IBM DB2 Universal Database development and administration, including DataStage ETL integration, stored procedure development, and system migration. Extensive project experience at Wells Fargo.

View Details โ†’
โ˜๏ธ
Cloud & Azure

Microsoft Azure platform including Azure SQL, Azure Data Factory, and cloud data pipeline development. AWS experience includes Redshift data warehouse architecture and Airflow orchestration.

View Details โ†’
๐Ÿ”ต
Sybase

Sybase application development, replication server configuration, and stored procedure performance tuning. Architecture of real-time co-existence between Sybase and mainframe VSAM systems.

View Details โ†’

Technology
Full Technology Stack
๐Ÿ—„๏ธ SQL Server / Azure SQL / Transact-SQL
โ˜๏ธ Microsoft Azure / Azure Data Factory
๐Ÿ“Š Power BI / SSRS / SSAS
๐Ÿ“ฆ SSIS / DTS / ETL Pipelines
๐ŸŒฉ๏ธ AWS / Redshift / Airflow / Python
๐Ÿ”ฎ Oracle / DB2 UDB / Teradata
โš™๏ธ Ascential DataStage
๐Ÿ”ต Sybase / Replication Server
๐Ÿ–ฅ๏ธ AIX / HP-UX / DEC Unix / Unix Shell
๐Ÿ’ป C / C++ / MVC .NET / VBA / VB
๐Ÿ“‹ MS Dynamics / IFS / JD Edwards
๐Ÿ“ˆ Salesforce / Domo / Active Batch