RUSSELL N. DONNELLY

***** ****** ****** ***

Garden Grove, CA 92840

ad39jw@r.postjobfree.com

https://www.linkedin.com/in/russell-donnelly/

https://app.pluralsight.com/profile/russell-donnelly

SUMMARY

Senior IT Professional with established achievement leading the development and implementation of IT solutions that increase organizational effectiveness. Experience with Business Intelligence, Database Design and Administration of Microsoft SQL Server, Visual Basic and C# Development. Key strengths include project management experience, team leadership, problem resolution and diverse industry experience, excellent analytical, communication and interpersonal skills, good presentation skills and an experienced team player.

TECHNICAL SKILLS

RDBMS: Microsoft SQL (Structured Query Language) SSMS 2017, 2016, 2014, 2012, 2005, 2008, 2000. Oracle 10g, 9ei, AS/400, Erwin 7.3, Microsoft Access 2007, 2003, 2000, 97

PROGRAMMING

LANGUAGES: TSQL (Transact SQL), C# (C Sharp), PL/SQL (Program Language/SQL), DB2, VB (Visual Basic) 6.0, XML (Extensible Markup Language), HTML (Hyper-Text Markup Language), Fortran (Formula Translating System).

SOFTWARE/TOOLS: Visual Studio 2022, 2019, 2017, 2013, 2012, 2010, 2008, 2005, SQL Data Tools (SSDT), BIDS (Business Intelligence Data Tools), TFS (Team Foundation Server), ETL (Extract Transfer and Load), SSIS (SQL Server Integration Services), DTS (Data Transformation Services), SSAS (SS Analysis Services), SSRS (SS Reporting Services), IIS (Internet Information Services), ADO (ActiveX Data Object), OLE (Object Linking and Embedding), OOP (Object Oriented Programming), MDI (Multiple Document Interface), DAO (Data Access Object), ODBC (Open Database Connectivity), DSN (Database Source Name), API (Application Programming Interface), OOED (Object Oriented Event Driven), Windows Installer, Visual Studio Installer, Microsoft Office Developer, Visual Studio Developer, Microsoft Frontpage, Oracle Discoverer, Access VBA (Visual Basic for Applications), Excel VBA, Project VBA, SharePoint, Redgate, Parallel Data Warehouse (PDW)

OPERATING SYSTEMS: Windows Enterprise Server 2000, 2003, Windows 7, Vista, XP, NT 5.0 / 4.0 / 3.5, 9.x / 3.x, MS DOS (Disk Operating System).

PROFESSIONAL EXPERIENCE

Senior Business Intelligence Developer, ETL and Database Developer May 2020 to November 2023

CalOptima Health 505 City Parkway West Orange, CA 92868

ETL developer, TSQL, SSIS, TFS.

Design and automation loading raw data from health networks and providers.

SSIS package design, VS 2019 and 2017, Instrumental in implementing Change Data Capture, Data Flow Memory Management.

Index design using Query Execution Plans for clustered and nonclustered indexing.

Datawarehouse design using key Kimball concepts: Denormalization, Star schema datamarts, Fact and SCD tables type 0, 1, 2 etc, analytics driven.

Familiarity with Inmon Snowflake design concepts: dimension table normalization and centralized bus architecture.

SQL Server merge operations, subqueries, common table expressions, row number over expression.

Control flow tasks: For Loop and Foreach Loop Container, CDC Control Task.

Data flow components: Conditional Split, Merge, Merge Join, OLE DB Command, Script Command and Union All, CDC Splitter, OLE DB and ADO Net Source and Destinations, Logging, Project/Package deployment.

Redgate

Senior Business Intelligence Developer, ETL and Database Developer Apr 2011 to Apr 2020

Fitness Intl LLC 3161 Michelson Ste 600, Irvine CA 92612

ETL developer, SSRS developer, TSQL, SSIS, TFS.

SSIS package design, VS 2017, 2013, 2012, 2010, 2008, Instrumental in implementing Change Data Capture, Data Flow Memory Management.

Index design using Query Execution Plans for clustered/nonclustered and integrated with clustered column store indexes.

Design of Azure SQL Server for replacement of operational reporting server.

Datawarehouse design using key Kimball concepts: Denormalization, Star schema datamarts, Fact and SCD tables type 0, 1, 2 etc, analytics driven.

Familiarity with Inmon Snowflake design concepts: dimension table normalization and centralized bus architecture.

SQL Server merge operations, subqueries, common table expressions, row number over expression.

Control flow tasks: For Loop and Foreach Loop Container, CDC Control Task.

Data flow components: Conditional Split, Merge, Merge Join, Multicast, OLE DB Command, Script Command and Union All, CDC Splitter, OLE DB and ADO Net Source and Destinations, Logging, Project/Package deployment.

Familiarity with PDW, PowerBI, MicroStrategy, Embarcadero, Redgate, PowerPivot, Temporal Tables.

6 Terabyte DW server.

Database Developer, Architect, Engineer, Programmer, Consultant, Remote, part time Nov 2010 to Apr 2011

SQL Server 2005 development, stored procedures in TSQL, SSIS, SSAS, SSRS, BI

Database Developer, Architect, Engineer, Database Administrator (DBA) and Programmer Apr 2010 to Nov 2010

The Boeing Company, Long Beach, CA, 90815

C-17 Global Sustainment Program, Campaign Proposal & Project Management

Data management and administration of Proposal data in Boeing proprietary platform, Project Integration Management System (PIMS).

Complex Access, Excel and VBA development for analysis of DCAA (Defense Contract Audit Agency) audits of proposals.

For DCAA analysis used MS Access and Excel, ADO, DAO, VBA in Access and Excel, API, OOP, OOED, Collections and Methods, Excel Reporting, Access Reporting and SharePoint.

MS Project VBA to enhance proposal, project management and metrics reporting.

Reason for leaving: Completion of Contract

Database Developer, Architect, Engineer, Programmer, Consultant, Remote, part time Dec 2009 to Feb 2010

VBA design in Access and Excel.

Utilization of VB, VBA, DAO, event procedures, sub procedures, functions, collection and methods, macros and SQL queries, ADO, API, OOP, OOED, Collections and Methods, Excel Reporting and Access Reporting.

SQL Server 2005 development, stored procedures in TSQL, SSIS, SSAS and SSRS.

Database Developer, Architect, Engineer, Programmer, Consultant Jul 2009 to Nov 2009

Ricoh Americas Corporation, Tustin CA 92780

Pacific West Region, Business Operations

Technical expertise for automation of reports.

Automation of billing and invoice reports for Ricoh’s customers, Los Angeles City departments including Fire, Police District Attorney. Data was extracted from Ricoh’s Oracle server, transformed and loaded into a local Access dB file.

Utilized MS Access and Excel, ADO, DAO, VBA, API, OOP, OOED, Collections and Methods, Excel and Access Reporting.

Reason for leaving: Completion of Contract

Database Developer, Architect, Engineer, Programmer, DBA Oct 2004 to May 2009

Toshiba America Information Systems (TAIS), Irvine CA 92618

Toshiba Corporate US Office for Digital Products Division and Service Engineering.

Provided technical skills to support Digital Products Division (DPD) and Service Engineering (SE).

Implemented and designed the replication of a Siebel Oracle database in Germany on a MS SQL Server local platform for DPD service data worldwide for datamining and automated report production. Daily, weekly and monthly reports were produced in a fraction of the time when using the Siebel server. Administrated and developed the MS SQL Server automated job structure to download data daily from the Germany server. This serves as the Data Warehouse for Toshiba America’s analysis.

Utilized ETL and Bulk Insert methods to load the data from the Oracle Germany server, TSQL, PL/SQL, SSRS to automate Excel, Access and PDF file reports.

Utilized SSRS to design reports for most business units of TAIS, Six Sigma Metrics, statistical and demographic analysis.

Administration duties included configuring SSIS for backup and maintenance, assigning users and passwords.

Use of query and performance tuning using tools SQL Profiler, Database Tuning Advisor and Index Tuning Wizard.

Performance tuning of long running TSQL, ad hoc Queries, Stored Procedures and Views using IO Statistics, query table joining techniques, indexing and optimization of Where clause structure.

Conversion of SQL Server 2000 DTS to SQL Server 2005 SSIS / ETL configuration.

ETL/DTS process for loading Data Warehouse aggregated and finely grained fact tables.

Setup database maintenance routines using DBCC utilities as well as complex automated maintenance and backup using SSIS.

Installed and configured Oracle 10g driver on SQL Server platform to facilitate connection between servers.

Administrated and developed the database and interface of Root Cause Analysis (RCA) at the Manufacturing Repair Center (MRC) using:

VS, VB, MS Access and Excel, ADO, DAO, VBA, API, OOED, Windows Installer and SQL Server database.

Designed and maintained processes for Finance’s General Ledger (G/L) reporting.

Also designed processes for Legal, Customer Service and Authorized Service Providers (ASP) reports, as well as other business units.

SSIS processes for loading Excel and Access files, administration of SharePoint to distribute reports.

Familiarity with database mirroring clustering and load balancing.

Reason for leaving: Supported Business Segment downsized.

Database Developer, Architect, Engineer and Programmer Feb 1997 to Sep 2004

Unisource World Wide, Centerpointe CSC, La Palma CA

Commercial Paper and Industrial Distribution worldwide.

Quality Assurance (QA) Coordinator

Design of user interface and reports based on analysis. Data was downloaded from Oracle, MS SQL server and AS/400.

ASCII text files/flat files.

Visual Basic 6.0 / Microsoft Access applications in a fixed width or delimited format.

Implemented TSQL and PLSQL

Reason for leaving: Better opportunity with Toshiba.

United States Air Force (USAF), Pope Air Force Base, NC Feb 1981 to Mar 1985

Pilot

Coordinated missions and flight plans.

Determined flight times needed to transport cargo, execute flight plans and computed passenger data.

Monitored aircraft performance, reported malfunctions and problems to appropriate maintenance personnel.

Flew Lockheed C130 Hercules Aircraft.

Expeditionary Medal in recognition of contribution to Grenada Invasion.

Held Secret Security Clearance.

Reason for leaving: Honorable Discharge after serving commitment.

EDUCATION

Aerospace Engineering, San Diego State University, California

MS study in Aerospace Engineering Oct 1980 to Dec 1980

BS Aerospace Engineering, San Diego State University, California Oct 1977 to May 1980

Minor in Aerospace Studies, Management Training Reserve Officer Training Corps (ROTC), San Diego State University

United States Air Force Academy, Colorado Springs, CO Oct 1974 to Dec 1976

Eisenhower High School, Rialto CA Graduated June 1974

PROFESSIONAL DEVELOPMENT

Certifications

AZ-900 Microsoft Azure Fundamentals 01/12/2024 (https://app.pluralsight.com/profile/russell-donnelly)

Pluralsight Training/Classes (https://app.pluralsight.com/profile/russell-donnelly)

C# 10: The Big Picture (finished 12/11/2023)

C# 10: Fundamentals (finished 12/14/2023)

Debugging C# 10 (finished 12/13/2023)

Asynchronous Programming in C# 10 (12/23/2023)

AZ-900 Microsoft Azure Fundamentals (12/23/2023)

Pass SQL Saturday

Attend yearly meeting Golden West Community College since 2016.

QuickStart

MS-10777 - Implementing a Data Warehouse with Microsoft SQL Server 2012: 70-463.

MS-6236 - Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services.

University Of California at Irvine Extension

Introduction to C# Programming using Visual Studio 2005 (MS 2124).

Gained the knowledge and skills to develop C# applications for the Microsoft .NET platform. Included creating and utilizing looping, exception handling, arrays, functions, subroutines, OOP, common objects, reference types, building classes, operators, delegates, properties and indexers and custom attributes.

Core Windows Forms Technologies with Microsoft Visual Studio 2005 (MS 2546).

Learned to build simple forms, configure standard controls, menus, data-bound controls and dialogs and forms inheritance.

California State University Fullerton Extended Education Department

Certification in Visual Basic 6.0

Client/server data access using activeX database objects, multi-user techniques, creating reusable object linking and embedding components, using Win32 registry, creating OCX(OLE control extension) controls and internet/web development. Object oriented, event driven programming, ActiveX data objects, Windows API, menus, multiple document interface (MDI).

Learning Tree International, Los Angeles, Certification Microsoft SQL Server 2000 DBA

Administer SQL Server RDBMS, install, back up and recover databases, create databases, troubleshoot problems, migrate data to SQL Server, replicate data between databases and manage security.

Courses

Microsoft SQL Server 2000 Application Development, Transact-SQL, SQL Server Comprehensive, SQL Server DBA, Microsoft Windows 2000, XML Comprehensive, Oracle8i Application Development, Oracle Database 10g Administration.

Contact this candidate