Douglas Marsh
Eagan,MN
Summary
Background includes data mining, warehousing, and analytics. Proficient in machine and deep learning. Quality-driven and hardworking with excellent communication and project management skills.
Overview
39
39
years of professional experience
1
1
Certification
Work History
MEDICAL FURLOUGH
Eagan, Minnesota
8 2022 - Current
- Due to health concerns and COVID-19 went on disability.
United States Postal Service
EDW Performance Group Lead
03.2007 - 08.2022
- Responsible for performance on Dual Active Teradata System
- Served as DBA on 128 Node Teradata Production System Running V2R6, V12, V13, V13.10
- Maintained User and Object Right Using Roles
- Tested Developer’s Code on Test System
- Implemented Changes to Production Code
- Monitored System Performance
- Wrote View List Application to Determine Databases and Tables Referenced by Views
- Assisted in Diagnosing System Performance Issues
- Wrote MP-RAS Unix Scripts to Assist With Code Promotion
- Used Perl V5.
- For administrative scripts.
Limited Stores
Teradata System Monitoring & Consulting
12.2006 - 03.2007
- Developed & Maintained a daily monitoring system
- Wrote a script to access the AWS log
- Assisted with system performance issues such as:
- Query tuning
- Index analysis & creation
Nationwide Insurance
ETL/Developer Position
01.2006 - 12.2006
- Maintained Large Teradata SQL codebase
- Maintained & developed to SQL & Unix scripts
- Maintained & developed Multiload scripts
- Maintained & developed BTEQ scripts
- Maintained and Developed Batch Applications on MVS and NCR Unix.
- Developed Test Environment Utilities Using Perl
- Including utility to change database names from production to test & back.
- Determined specifications for new development
- Provided on-call support for incremental ETL enterprise system
- Responsible for rapid response to software events
Goodyear
DBA Position
07.2005 - 01.2006
- Tuned Poor Performing Queries.
- Including those produced by Cognos.
- All using Teradata SQL
- Maintained Development & Production Databases.
- Implemented Role Based Security.
- Implemented Multi-value Compression.
- Developed View to be Used with Cognos.
- Tuned Queries by:
- Rewriting SQL
- Evaluating Primary Indexes
- Access is first priority
- Distribution is Next
- Then Volatility
- Creating Secondary Indexes
- USI
- NUSI
- Creating Join Indexes
- Sparse Join Indexes
- Single Table Join Indexes
- Multi-Table Covering Join Indexes
- Wrote JDBC/JAVA application
- Allows Users to Change Their Passwords
Nationwide Insurance
Designed/Developed/Implemented Teradata Survey
02.2005 - 06.2005
- RDBMS Portion collected database information from three distinct Teradata systems.
- Gathered Information such as
- Number of Databases
- Number of Users
- Number of Views
- Number of Columns
- Database Sizes
- Table Sizes
- Data Dictionary/DBC Information
- Program ran on both V2R5 & V2R6 Teradata versions.
- Program was written in Perl using Teradata SQL
- Human Questionnaire Collected Information from Teradata Staff
- Questions were designed to elicit information of processes used to administer the Teradata databases
- Questions covered many different aspects of administration including
- DBA Procedures
- ETL Procedures
- Help Desk Procedures
- Best/Worst Practices
Kaiser Permanente
Designed/Developed/Implemented Clarity Console Job Status Monitor
05.2004 - 02.2005
- Perl based Windows 2000 Service that checks for status and updates a Teradata table when new status is received.
- Designed/Developed Teradata User Maintenance Application in VBScript
- Add User, Modify User, Password Reset, Revoke/Restore Access, Batch Mode
- Modular design included all possible Teradata options in Create/Modify.
- Designed/Modeled/Implemented GL Reconciliation Application
- Created Logical & Physical Model
- Designed, Coded and Implemented ETL program in FastLoad & MultiLoad
- Designed, Coded and Implemented Security Plan and Statistics Collection
- Designed and Coded “Log Scraping” Application in Perl
- Search Logs for Errors & Successes
- Tuned Teradata SQL Queries
US Air Force
Assisted in porting Oracle/DB2 Supply Chain application to Teradata.
10.2003 - 05.2004
- Tuned Queries.
- Wrote Data Integrity Checking Application.
- Wrote Application to Remove Records Based Upon Period.
- Analyzed Primary Index Column Choices.
- Coded Perl DBD::Teradata utilities including:
- ODBCpy utility to copy data between Teradata systems without landing data to a disk.
- Compression tool for V2R5.x column compression.
- Consultant in the Sustainment area on a US Government project in a secure environment.
- Supported Existing Application by:
- Designing Solutions.
- Coding the Designs.
- Unit Testing Code.
- Integration Testing.
- Provided Support to DBAs.
- Tracked down bad Join Index Problem for example.
- Provided 3rd Tier Technical Support.
- Created a Testing Environment using TD demo databases.
- Extensively Documented Design, Coding and Testing Activities.
- Mentored Developers in Teradata SQL.
- Received NAC Clearance.
Coffing Data Warehousing
Wrote Administrative Tools in Perl
07.2003 - 10.2003
- Canary Query Utility
- Runs a User Configured Query at specified intervals.
- Records Times and Return codes.
- Script Audit Tool
- Scans Directories for Files Selected by a user configured list of extensions.
- Saves File Information to a Table;
- Saves Files to another table.
- Files can be recreated from table
- Generates a Report of which Scripts call Other Scripts.
- Compression Analysis Tool
- Searches Teradata database for Columns likely to Compress well.
- Generates Scripts to Re-Create the Tables with the Columns Compressed.
- Generates Scripts to Copy data from old table to new compressed table.
- Generates scripts to drop old tables and rename new compressed tables.
- Arc Script Generator.
- Generates ArcMain Scripts for backup to same system and database.
- Can be used to generate scripts to move tables to new database.
- Can be used to move tables to new system.
- Configurable to backup all or partial tables in a database or system
- Mentored Junior CDW Consultants.
- Wrote Teradata SQL Utilities
- Capture all DDL from TD database.
- Current Session Activity
- Identify Power Users.
- Transactions by Object report.
- Min/Max Transactions by Date
- Object Audit.
Toronto Dominion Bank
Performed a review of their Teradata system
09.2003 - 09.2003
- Analyzed system usage using ResUsage
- Surveyed Views and macros for bad table references.
- Created Benchmark for comparison against after system upgrade.
iGATE MasTech
Taught on-line basic Teradata class using Centra On-Line Classroom.
06.2003 - 07.2003
- Designed PowerPoint class materials including quizzes and web links.
- Prepared course syllabi and Advanced Class Notes.
- Presented Advanced Class in on-site 2-day session.
- Provided “2nd Opinion” for major Canadian bank
- Audited Teradata 2 node system
- Including:
- Hardware Analysis
- Discovered System imbalance caused by heterogeneous node types.
- Validated proposed upgrade.
- Software Analysis
- Initiated discovery process that found:
- Over 7,000 database objects that used “Select
- Instead of explicitly querying.
- Over 5,000 objects that did not use “Access Locking” which can cause blocking.
- Over 300 broken objects which reference other non-existent objects.
- Over 4,000 duplicate objects which can waste space.
NCR CORPORATION, Professional Services Division
Senior Database Consultant
01.1996 - 01.2003
- Teradata Certified Master specializing in ETL in NCR’s Teradata division
- Also provided consulting services in Visual Basic, C (UNIX and Windows) and Perl.
- Wrote custom AXSMOD interface to Teradata’s Multi-Load, which was used to load several hundred Teradata tables from a legacy data source.
- Developed automated system to “forklift” over 600 Oracle 8I Tables to TeradataV2R5.
- Project leader and developer of Visual Basic “Spider” application to obtain metadata information on a Teradata V2R4 system.
- Created a Perl application to generate dynamic ARCMain scripts for Teradata V2R4 system using BakBone’s NetVault.
- Served as DBA on a four-node 2 TB MS Windows 2000 Teradata V2R4.1 system.
- Demonstrated skills in physical design by creating Teradata databases, tables, indexes, and views.
- Determined UPI and NUPI primary indexes as well as USI and NUSI secondary indexes.
- Performed capacity planning and ETL process design.
- Wrote Unix Shell Scripts to support database administration.
- Supervised Informatica data warehouse loads on an hourly, daily, and weekly basis.
- Configured Teradata users including perm, spool, and temp space allocations and privileges.
- Used ERWin to maintain physical data schema.
- Wrote macros, procedures, and BTEQ scripts for Teradata applications.
- Developed ETL scripts to extract data from Operational Data Store (ODS) Star schema and load it into dimension and fact tables using BTEQ, QueryMan, FastLoad/MultiLoad/FastExport/OLELoad and Teradata SQL.
- Configured and scheduled Teradata backup and restore activities using ARC and Net Vault.
- Tuned Teradata SQL by running Explain, Visual Explain Collect Statistics, or tables and indexes.
- Served as system administrator for Informatica Power Center Server.
- Trained in Teraminer.
- Project Leader for Visual Basic 6 Office Automation/ODBC/Web application.
- Used Teradata’s OLE Load & FastLoad to transfer 93 tables from an Oracle system.
- Conducted pre-sales proof of concept, benchmarking, and stress testing of Oracle software.
ORACLE CORPORATION – Services Division
Senior Database Consultant – Financial Applications Division
01.1993 - 01.1996
- Provided ETL and other programming services.
- Customized Oracle Receivables application for state government agency.
- Wrote UNIX ksh scripts to support custom applications.
- Developed automated data interface for patient billing system.
- Upgraded Oracle applications from Version 10.6 to 10.7.
- Project leader on ETL application that loaded legacy system data into Oracle.
- Prepared documentation for data interfaces.
- Trained end users on completed development work.
- Presented completed project to client.
- Wrote General Ledger account hierarchy management system for large retail chain to manage several hundred accounts.
ILAN CONSULTING
Application Developer and Consultant for Banyan Vines, Oracle, and ImageBase
01.1987 - 01.1993
- Project leader and developer of ImageBase applications in both DOS and Windows 3.1
- Integrated document imaging and Oracle databases.
- Developed AIX X-Windows-based electronic strip chart to replace a bank of strip chart recorders at a major public utility.
- Programmed UNIX Shell scripts.
- As Banyan Vines Network Administrator, responsible for file system creation and maintenance as well as user creation, maintenance, and security.
ELEVATOR ENTERPRISES INCORPORATED (EEI)
Programmer/Analyst
01.1985 - 01.1987
- Provided general end user support and network administration.
- In charge of maintaining a customized general ledger and accounts receivable system written in DBMan (an Ashton Tate dBase clone).
- Served as Novell Network Administrator.
- Responsible for PC hardware upgrades and maintenance as well as LAN wiring and maintenance.
Education
No Degree - Psychology
Kent State University
Kent, OH 05.2001 -
Skills
Teradata V2R4, V2R5 & V2R6
Visual Basic
MS-Windows XP, 2000, NT 95, 31
Teradata Load Utilities
VMS
MS-DOS
Teradata SQL
C
MP-RAS
Informatica
Visual FoxPro
Solaris
ORACLE
HTML
HP-UX
ORACLE DBA
Pascal
AIX
ORACLE Financials
Assembler
LINUX
ORACLE Developer 2000
TOP END
ORACLE Express
Ksh – Korn Shell
Informix
Sh – Bourne Shell
My SQL
Java
Gupta
awk
MS Access
Perl
FoxPro
Unix Shell Scripting
Dbase
Tk
Certification
Teradata Certified Master
Timeline
United States Postal Service
EDW Performance Group Lead
03.2007 - 08.2022
Limited Stores
Teradata System Monitoring & Consulting
12.2006 - 03.2007
Nationwide Insurance
ETL/Developer Position
01.2006 - 12.2006
Goodyear
DBA Position
07.2005 - 01.2006
Nationwide Insurance
Designed/Developed/Implemented Teradata Survey
02.2005 - 06.2005
Kaiser Permanente
Designed/Developed/Implemented Clarity Console Job Status Monitor
05.2004 - 02.2005
US Air Force
Assisted in porting Oracle/DB2 Supply Chain application to Teradata.
10.2003 - 05.2004
Toronto Dominion Bank
Performed a review of their Teradata system
09.2003 - 09.2003
Coffing Data Warehousing
Wrote Administrative Tools in Perl
07.2003 - 10.2003
iGATE MasTech
Taught on-line basic Teradata class using Centra On-Line Classroom.
06.2003 - 07.2003
No Degree - Psychology
Kent State University
05.2001 -
NCR CORPORATION, Professional Services Division
Senior Database Consultant
01.1996 - 01.2003
ORACLE CORPORATION – Services Division
Senior Database Consultant – Financial Applications Division
01.1993 - 01.1996
ILAN CONSULTING
Application Developer and Consultant for Banyan Vines, Oracle, and ImageBase
01.1987 - 01.1993
ELEVATOR ENTERPRISES INCORPORATED (EEI)
Programmer/Analyst
01.1985 - 01.1987
MEDICAL FURLOUGH
Eagan, Minnesota
8 2022 - Current