russell mazelsky

Led data architecture and DBA support for a team of 15, delivering Oracle and MSSQL BI and ETL processes that ensured accurate data transformation and integrity. Built and tuned complex SQL (PL/SQL, T-SQL, PRO*C) and supported OLTP/ETL batch feeds, reporting, and backup/recovery across 50–100 database backends used by hundreds to thousands of users daily.

Developed an MSSQL ETL architectural solution integrating large data sources into a staging environment for database migration. Profiled, cleansed, validated, and loaded millions of rows using T-SQL and data profiling tools, translating security reporting requirements into compliant ETL processes (SOX) and using PRO*C for Oracle stored procedures.

Designed, tested, and deployed an enterprise database reporting system for medical information using MySQL and Oracle. Analyzed database architecture and migrated processes between Oracle and MySQL customer architectures, improving on-demand reporting with PL/SQL and T-SQL scripts for medical drug and patient analytics across large datasets.

Designed and built an enterprise data warehouse using Oracle Warehouse Builder (OWB 11gR1) and Oracle 11g, including ETL, Operational Data Store modeling, and Business Objects dashboards for monitoring data quality. Implemented stage/vault/mart schemas, delivered enterprise loading architecture (TMDS/DHIMS), improved Oracle Spatial performance by 2–7x, and supported Oracle tuning and SDLC best pra

Served as an ETL administrator, ensuring scheduled jobs completed on time and troubleshooting errors during data processing. Converted over 300 Oracle PL/SQL reporting routines to MSSQL T-SQL, developed ETL routines for Excel-to-database loads, and implemented stored procedures/functions using PRO*C with complex SQL validation across environments.

Led development of the BranchNet Pershing Integration to provide data to an integrated trading system from multiple disparate sources. Managed Informatica PowerCenter v8.x workflows and ETL processes (including schema and data flows), supported SDLC server builds/releases, and developed stored procedures/functions and reports using C and PRO*C on SQL Server 2000/2005 (T-SQL).

Installed, configured, tuned, and re-architected production MSSQL 2000/2005 databases supporting law-enforcement web sites, including ETL job scheduling, security audits, and production DBA monitoring. Developed disaster recovery practices, upgraded and migrated databases (DEV→QA→PROD), and began porting Oracle 9i CALPHOTO to SQL Server using ERWin and reverse engineering of PL/SQL code.

Re-architected the back-end ETL process supporting a call-center reporting data warehouse on Microsoft SQL Server. Built a new warehouse reporting system using Sybase, Oracle, and SQL Server source data to improve call quality and work order responses through attendance/schedule compliance analytics.

Provided production and application DBA support for Microsoft SQL Server and Oracle 9i systems across ongoing projects. Performed configuration/release management, wrote SQL Server stored procedures and Oracle PL/SQL for business logic, and handled performance tuning and troubleshooting including Oracle partitioning, RMAN/Statspack, SQL*Loader, and Linux-based Oracle administration.

Led the data warehouse team for the deployment of the San Diego County IPTS data warehouse, architecting dimensions, cubes, ETL, job scheduling, and reporting queries. Ensured integrity, reliability, efficiency, and data quality of BI design and infrastructure, mentored teammates on Oracle 10g/Oracle Warehouse Builder, and translated business requirements into scalable performance-focused designs.

Designed and implemented data migration and profiling methodology for up to 40 legacy source systems using Similarity Systems Axio and IBI Data Migrator. Led OLTP-to-OLAP architecture for the San Diego County IPTS property tax system, including an Oracle reporting datamart with daily canned reports and JReports-driven ad hoc reporting, while coordinating consultants and migration strategy.

Directed system configuration management best practices for legacy data warehouse systems across Oracle and SQL Server repositories. Managed teams responsible for development and QA testing of core data warehouse systems, build processes, and architectural documentation using Informatica PowerCenter and Business Objects alongside Siebel, Hyperion, and Tidal job scheduling.

Led a team across data warehouse and OLTP methodologies, re-architecting and re-configuring both application types for enterprise deployment. Migrated SQL Server 7.5 to SQL Server 2000 for a multi-TB hybrid OLTP+OLAP system, established company-wide data modeling using ERWin, and implemented backup/recovery and disaster recovery strategies using RMAN with extensive PRO*C and C-based stored procedu

Managed teams producing Oracle certification multimedia training deployed on NT/IIS, built using Trainersoft for Oracle8i/9i DBA and Oracle Applications 11i prep. Provided hands-on administration on Solaris and NT servers running Oracle 8i/9i, Apache, and OracleApps 11i, managed Apps 10.x to 11i migrations/gap analysis, and supported Siebel 2000 administration and Crystal Reports/Visual Basic repo

Led the interface project team to design, develop, test, and deploy integrations between Siebel and Remedy applications. Configured Siebel across NT and Solaris platforms, managed testing across environments, created data mappings using DataJunction/ERWin/ActiveWorks, and developed a Siebel message queueing prototype using IBM MQ Series with Java/XML plus batch synchronization via Siebel EIM.

Managed a team developing a web-based Special Business Approval Manager system with an Oracle back-end database. Gathered and documented functional/design requirements, designed schema and business rules, maintained project repositories and release management using Visual Source Safe, and acted as QA/configuration control manager to complete on time and on budget.

Provided enterprise-level technical guidance, including business process and data modeling and support for migration and integration strategy within data warehousing environments. Led technical evaluation and RFP support for three major systems, managed multiple teams and locations with issue management for 250 people, and assessed operational tooling (e.g., JP1/JPWalker, CAUnicenter, Tivoli) for

Selected and implemented tools supporting SDLC, configuration management, Oracle*Clinical enhancements, batch scheduling, and data warehouse efforts using Oracle 7. Implemented systems for the pharmaceutical approval workflow including labs file transfer across a firewall, data preprocessing for Oracle*Clinical, and automation via UNIX shell scripts integrating AutoSys with Oracle*Clinical and rel

Earned a Bachelor of Science degree in Pre-Medical Bio Engineering from the University of California, San Diego.

Earned a Master of Science degree in Bio Engineering from the University of California, San Diego.

Earned a Ph.D. in Applied Mechanics at the University of California, Los Angeles.