russell mazelsky

Served as lead data architect/DBA/developer for a team of 15, building BI and ETL processes and developing complex SQL across Oracle, MSSQL, PL/SQL, T-SQL, and PRO*C/C. Supported large-scale reporting for 50–100 site database backends with a web frontend and ~10GB datasets, performing backup/recovery, data quality reporting, and database tuning for thousands of daily business users.

Designed an MSSQL Server ETL architectural solution integrating multiple large data sources into isolated staging for Archer schema loading to meet asset security and SOX compliance. Profiled, cleansed, validated, and integrated millions of rows from flat files and database tables using T-SQL, metadata models, PRO*C, and data profiling tools, translating security analyst requirements into producti

Designed, tested, and deployed an enterprise database reporting system for medical information using MySQL, Oracle, Windows, and UNIX. Analyzed and migrated reporting processes between Oracle and MySQL architectures, built PL/SQL and T-SQL scripts with PRO*C programs for complex algorithms, and supported on-demand reporting architectures using J-Reports for multiple insurance-provider clients.

Owned data warehouse architecture and ETL design for an enterprise data warehouse integrating multiple source schemas using Oracle Warehouse Builder (OWB 11gR1) and Oracle 11g, including star/snowflake schema modeling and monitoring dashboards. Built stage/vault/mart schemas for the Theater Medical Data Store (TMDS) and implemented XML feeder interfaces, achieving 2–7x performance improvements via

Ensured existing ETL jobs completed on time and resolved errors, including converting over 300 Oracle PL/SQL routines to MSSQL Server T-SQL 2005. Designed and coded ETL routines to load data from Excelergy Oracle to LoadStar MSSQL databases and developed/validated complex SQL and stored procedures using PL/SQL, T-SQL, and PRO*C with C-based reporting components.

Led the BranchNet Pershing Integration effort, delivering data to an integrated trading system and managing the SDLC release process. Managed Informatica PowerCenter v8.x workflows, ETL processes, SQL Server 2000/2005 T-SQL components, and in-house job scheduling while developing stored procedures, functions, and reports using C and PRO*C.

Installed, configured, tuned, and re-architected production MSSQL Server 2000/2005 databases supporting law-enforcement web sites, including crime search and mapping. Performed DBA monitoring, enforced security and best practices, redesigned SAN partition layouts for performance, created DR practices, upgraded SQL Server versions, and began porting Oracle 9i (CalPhoto) to SQL Server using ERWin an

Re-architected the back-end ETL process for a call center reporting data warehouse using Microsoft SQL Server. Designed a reporting statistics system using source systems including Sybase, Oracle, and SQL Server that improved call/workorder quality and call responses by surfacing attendance, availability, and schedule compliance measures.

Provided production and application DBA support for Microsoft SQL Server and Oracle9i, including configuration, testing, and release of new production SQL Servers. Wrote SQL stored procedures and Oracle PL/SQL for business logic, migrated databases between SQL Server and Oracle, and performed performance tuning and troubleshooting using Oracle partitioning, RMAN, Statspack, and SQL*Loader.

Led the data warehouse team for deployment of San Diego County IPTS, architecting the design of dimensions, cubes, ETL processes, job scheduling, and reporting queries while ensuring BI data quality and infrastructure reliability. As Data Migration Specialist, designed profiling/migration for up to 40 legacy source systems using Similarity Systems Axio and IBI Data Migrator, and led OLTP/OLAP deve

Served as a technical project manager for system configuration management best practices across legacy data warehouse systems using Oracle and SQL Server repositories. Managed teams responsible for building and QA testing core warehouse systems and directed preparation of architectural documentation for multiple enterprise intelligence migrations.

Led re-architecture and re-configuration of both OLTP and data warehouse applications, including migrating SQL Server 7.5 to SQL Server 2000 for a multi-TB hybrid (OLTP+OLAP) Customer Center application on Hitachi SAN. Established data/process documentation standards, enforced change control, implemented backup/recovery and DR strategies, and guided modeling using ERWin with source code control an

Managed teams developing multimedia online Oracle certification training deployed on NT Server and IIS 4.0 for Oracle8i/9i DBA and Oracle Applications 11i. Provided system administration and rollout support across Solaris and NT environments, performed backup/recovery operations, installed/configured Oracle Apps 11i and Siebel 2000, and built an Oracle database reporting toolkit using Visual Basic

Ph.D. in Applied Mechanics (ABD) at UCLA; completed coursework and met requirements prior to dissertation completion.

Master of Science in Bio Engineering at the University of California, San Diego.

Bachelor of Science in Pre-Medical Bio Engineering at the University of California, San Diego.